Aasheet Kothari
Senior Data Architect at GEICO FEDERAL CREDIT UNION (FCU)
Senior Data Architect
SENIOR DATA ARCHITECT
aasheet.k@hotmail.com

US CITIZEN

	20+ years of total IT experience with recent 12+ years of extensive experience with
Data Warehouse, Data Modeling, Database Developer and related work in VLDB and 24x7 environment
	Experience with various industries including Banking and Financial companies for Hedge Funds, Asset Management, Fixed Income, CDO, Derivatives, Securities, Equities and Trading. Also have experience with Healthcare and Insurance industries. 
	8 years of experience with client-server software and database systems development including Visual Basic, SQL server, MS Access, Oracle, VB Script and GUI Reports. 
	Exposure with VMWare, Hardware, Routers, installing and upgrading windows operating systems and setting up networks.

EDUCATION:		Masters in Computer Science (with teaching assistantship)	G.P.A.: 3.8/4.0
			Wayne State University, Detroit, MI	1991

CERTIFICATES:	www.ikmnet.com certified with strong category (80-100%) for SQL	2010
	www.proveit.com certified with 90% for SQL Server	2009
	
DATABASE: 	MS SQL Server, Teradata, Oracle, MYSQL, Sybase, DB2, MS Access 

LANGUAGES/	T-SQL, SSAS, SSIS, ERwin, PL\SQL, Visual Basic, VB Script, XML, Crystal Reports, Visual 
TOOLS:	Source Safe Version Control, MS Office Products, MS Outlook 2003, Sharepoint

OPERATING 	Windows Server 2008/2003, Windows 2000 Advance Server, Windows XP, VMWare, MS DOS, 
SYSTEMS:	UNIX, Macintosh

Specialties: AASHEET  KOTHARI
SENIOR DATA ARCHITECT
US CITIZEN

aasheet.k@hotmail.com
GEICO FEDERAL CREDIT UNION (FCU)
GEICO FEDERAL CREDIT UNION (FCU), MD, USAhttp://geicofcu.com		March 2009 – Present
Subsidiary of Berkshire Hathaway (500 database servers, 24,000+ employees)

Environment:	MS SQL Server 2008/2005/2000, SSAS, SSIS, SSRS, Windows server 2003/2008, , 
		Agile framework, UNIX.
		
Description:	This organization provides Insurances, Banking, First Mortgage Loans, Refinances, Home Equity 
		Loans, Second Trust Loans, Home Improvement Loans, Auto Loans and consumer loans. It also 
		provides Online banking, Deposits and Credit cards.

Role:	Data warehouse architect and related tasks:
	
•	Cost-benefit analysis and feasibility study for the data warehouse projects
•	Created roadmap and blueprint for approved projects
•	Designed and created data marts and was involved in data governance maintenance
•	Using normalizations, designed snow flake schemas
•	Created E-R diagrams for Conceptual, Logical and Physical designs. Created constraints for 
business rules and validations. Applied forward engineering
•	Designed and created metadata, data marts, fact and dimension tables
•	Worked on ETL to convert data from heterogeneous data sources and formatted as needed
•	For data mining, designed and created data warehouse cubes using aggregate amounts, hierarchy of the fields, Filter, for different dimensions
•	Developed and tuned SQL scripts and stored procedures
•	Participated in analysis and discussions to move Oracle to Teradata database
•	Capacity Planning using heap and clustered data, index tree levels, etc. for 5 terabytes of OLAP database and for 100k+ daily transactions for OLTP
•	Designed and implemented partition on date column using filegroups
•	Designed, documented and implemented storage policies for RAID and SAN configurations and separate  drives for logs, tempdb and Indexes
•	Created signoff documentations for approvals and technical minutes of meetings
•	Technical documentations.
•	Database security including standard security practices and checklist.
Senior Data Architect
Sovereign Bank, Subsidiary of Santander
https://www.linkedin.com/company/santander-bank-na
Sovereign Bank, PA, USA	August 2008 –February 2009
Subsidiary of Santander (1130 database servers, 180,000 Employees)
www.sovereignbank.com

Environment:	MS SQL Server 2005/2000, Oracle,MS Visual Studio, VB Script, MS Source safe version control.
Tasks:		
•	Created and enhanced Data warehouse and ETL work for different data sources.
•	Created and tuned stored procedures and SQL scripts
•	Resolved Deadlock, memory and hardware issues
•	Monitoring, Performance tuning, SQL tuning, health checks, etc.
•	Cost-benefit analysis and created roadmap to consolidate about 250 existing database servers
•	Discussed and coordinated matters with related users, technical staff, management and vendors
•	Resolved issues to apply patches to database by populating missing installation files and adding needed logins to all the servers for automatic upgrades.
•	Installation, Upgrade, Migration of database with maintenance jobs including database backups. Created security and assigned roles.
•	Replication set up, monitoring and troubleshooting. Generated reports every morning for daily replications and resolved issues. 
•	Designed, implemented and maintained Disaster Recovery plans.
•	Guided Junior and Mid level data staff. 
•	Set up testing environment for testing the release
https://media-exp1.licdn.com/dms/image/C4E0BAQEJtSMnVltG6Q/company-logo_100_100/0/1625091284001?e=1655942400&v=beta&t=pHLIz5ke1mUpaYwBN37DdYeNqEbSgOrdzE5ug16e9Bs
Data Architect, DBA
AAA Computer Services
AAA Computer Services, USA                             						May 1999 - July 2008

Environment:	MS SQL Server, Teradata, Oracle, DB2, MS Visual Studio, Agile framework, VB Script, Visual 
		Basic, DB2, MS Access, MS Source safe version control, VMWare.

Role:	Data warehouse architect, Lead and related tasks

•	Cost-benefit analysis, feasibility study and Roadmaps for data warehouse and other projects
•	Designed and created OLTP for VLDB. For Data profiling, Built Cubes with fact and dimension tables from OLAP Database with multi terabytes.
•	Designed and created snow flake schemas using normalizations.
•	Designed and created conceptual, logical and physical DB models using Erwin
•	Extensive Data warehouse and ETL for heterogeneous data sources including text files.
•	SQL Tuning and created stored procedures, SQL scripts, views, triggers etc
•	Received data warehouse and database related trainings.
•	Created reports from multiple tables.
•	Worked with Credit card, Fixed Income, Credit Derivatives and Portfolio Trading data
•	Stored data to SQL environment using ORM.
•	Followed agile framework with Scrum and sprint of 30 days.
•	Monitoring, Performance tuning with native SQL and third party tools
•	Reindexing, Index defrag based on fragmentation of indexes. 
•	Troubleshooting memory and hardware issues.
•	Developed Central Monitoring server and set up Alerts for database space, deadlock and high usage of CPU.
•	Database security including security best practices and checklist. 
•	Set up Development, Preproduction and Production servers.
•	Worked closely with users, technical staff and management. 
•	VMWare Configurations.
Lead (Hands On) Data Architect and Developer
United Parcel Service (UPS)
WorldWide Code Repository (WWCR)

Received training using ‘Microsoft mastering web development’ CD.  Developed web pages including department home page, using VB Script.  Users can select department name from the listbox and than populate values or the description for the selected department.  From another web page, users can also select Facility tables and populate further values.
	Role:		Consultant.  Involved with functional specifications, design and development.
				
ii)	Customer Service Telephone Center (CSTC) - USA
			Client-server MDI applications with pull down menus including the following functionalities:
•	Customer Support
		Customer Information
		Package Tracking
	Delivery Information.
•	Customer Service Requisition Complaints /Suggestions
•	General Information
•	Employee Bulletin Board
•	Pickup Requisition
Senior Programmer/Analyst
FINOVA Capital Corporation (Leasing Firm)
Client-server MDI applications with pull down menus to view, add and maintain legal details of  the
			customer on Sybase DB tables.  Provided validations and restrictions to information, based on user’s 
			Login ID level.  Application for the legal department has 30 forms.  Application information was 
			retrieved from existing application coded in workstation basic language on VAX using INGRESS 
			database.  Developed stored procedures for various queries and database operations.  Took training 
			for IQ Pro.  Developed a few IQ Pro reports which include receiving formulas from Visual Basic 
			Front end, other formulas, grouping, Summary, table links, etc.
	Role:		Functional specifications, design, development, stored procedure, reports, testing and installation.
Visual basic Programmer/Analyst
Mercedes Benz of North America, Inc.
A Client-Server application displaying number of owners and number of vehicles, falling within user
			selected criteria.  Application creates SQL statements from the user selections and executes it to 
			retrieve counts.  SQL statements also link Informix(5.01) DB tables.  Application includes Query 
			Maintenance screen to save, Load and delete frequently run queries using MS Access DB.
Developed stored procedures for database operations.  Developed crystal reports which include receiving formulas from Visual Basic Front end, other formulas, grouping, Summary, table links, etc.
Visual Basic and Crystal Reports Programmer / Analyst
salomon brothers
Client-Server applications to enter, administrate, maintain, and display reports for Human Resources 
			and Benefits Department expenses.  The database includes employee information, security, salary, 
			bonuses and many other expenses for the department.  Developed on line help file using RTF format 
			and MS help compiler.  Also, developed application for Executive Fitness Center to enter, display and 
			maintain time spent on each machine.  Developed nine Crystal reports for different competitions and 
			machines.
	Role:		Design, development, report generation, version control, testing, installation and user training.
Visual Basic Consultant
Masters
Computer Science
https://media-exp1.licdn.com/dms/image/C4D0BAQFVWmT5IsrY_Q/company-logo_100_100/0/1591178690810?e=1655942400&v=beta&t=5Ab4HA591t4512pebifr1Sk3GpCz-6SM5DUBZ7zbyLo
Wayne State University
https://www.linkedin.com/school/wayne-state-university/
B.E.
Engineering
https://media-exp1.licdn.com/dms/image/C4E0BAQFOem5sfsvzfg/company-logo_100_100/0/1519882382257?e=1655942400&v=beta&t=hEkDvr9Tfj_tTBoH131sFZpA3lKhutzbSVZqyJzdyTI
Dharmsinh Desai University
https://www.linkedin.com/school/dharmsinh-desai-university/
https://www.linkedin.com/in/jerry-hosack-17a85b7
Emporia, KS
Jerry Hosack
Data Architect at Bank of America
https://www.linkedin.com/in/gary-wotton-a8a0a44
Collinsville, CT
Gary Wotton
Enterprise Data Architect at CIGNA
https://www.linkedin.com/in/saraju
Dublin, CA
Saravanan Raju
Data Architect at AARIN
https://www.linkedin.com/in/balamurugan-mayilappan-2017b16
Redmond, WA
Balamurugan Mayilappan
SDET at Microsoft
https://www.linkedin.com/in/hye-ok-lee-48173013
Bellevue, WA
Hye Ok Lee
SDET at Microsoft
https://www.linkedin.com/in/coby-chimene-a21265112
Colorado Springs, CO
Coby Chimene
Pega Certified System Architect/Java Full Stack Developer at Revature
https://www.linkedin.com/in/joel-harris-916525a0
Renton, WA
Joel Harris
SENIOR SDET at Microsoft
https://www.linkedin.com/in/dewayne-korth-766003b
Littleton, CO
Dewayne Korth
Senior Application Architect
https://www.linkedin.com/in/mark-andes-9a157155
Golden, CO
Mark Andes
Software Architect at Ascent360
https://www.linkedin.com/in/sergeykuzmichev
Boston, MA
Sergey Kuzmichev
Data Architect at Admirals Bank
https://www.linkedin.com/in/danbarrese
Denver Metropolitan Area
Dan Barrese
Software Architect at Trustwave
https://www.linkedin.com/in/erin-m-mcnulty
Greater Philadelphia
Erin McNulty
Data Architect/Business Intelligence Developer at ICON plc
https://www.linkedin.com/in/yudhvir-chauhan-188a173
Bellevue, WA
Yudhvir Chauhan
SDET II
https://www.linkedin.com/in/vbganapavarapu
Fort Collins, CO
Vinay Ganapavarapu
Data Architect at Colorado State University, LinkedIn Open Networker:: LION
https://www.linkedin.com/in/srinicenthala
San Jose, CA
Srini Centhala
Chief Architect at Bizstats.AI
https://www.linkedin.com/in/ronsystems
Dallas, TX
Ron Ahmad -Principal (REMOTE DATA ARCHITECT) RONSYSTEMS CORP-CLOUD DATA ARCHITECT-IBM, AWS, GCP
ACTIVELY SEEKING REMOTE JOB OPPORTUNITY-REMOTE CLOUD DATA ARCHITECT-EMAIL JOB OPPORTUNITIES TO RONAHMAD@HOTMAIL.COM
https://www.linkedin.com/in/timcost
Euless, TX
Tim Costello
I help small businesses turn data into insight.
https://www.linkedin.com/in/constantin-alexander
Los Angeles, CA
Constantin A. Alexander
Founder dedomena.io
https://www.linkedin.com/in/rberry
Raleigh, NC
Richard Berry (LION)
Data Architect
https://www.linkedin.com/in/bboyle37922
Knoxville, TN
Bob Boyle
Sr Data Architect
Jigar Desai
      
          



            
              
        
              
  

    
        Aasheet has a vast range of SQL server 2005/2000 knowledge and was very helpful in assisting me on the setup and maintenance for Replication, DR strategies, etc.

He is a very valuable asset to any organization who would like to take advantage of his skillset