• Cleaned and fixed financial raw data from different clients• Did Data analysis and research to find the errors, mismatches etc. AndAssigned security ID, account number. • Sent Data to DPC for approval• After Approval, sent data to production. And sent results to claims department and file for the case.Platform: Oracle TAO15.1 (64 Bit) and MS Office

Sr. SQL Server DB Developer/Technical LeadPlatform:MS SQL Server 2014, SQL Server Data Tools for Visual Studio 2013, Informatica 10.2.0Detail Work:• Requirement gathering• Data analysis, profiling and Database design and modeling• T-SQL programming for stored procedures, functions, views, transactions, indexing, etc. • Designed and built data warehouse with Snow flakes and star schema • Designed, built, supported, enhanced and maintained ETL processes (SSIS/Informatica)• Built Data Lakes for data processing• Check data lineage for relate data fields in different tables• Designed, developed and maintained Reports (SSRS, Tableau reports)• Data mining, debugging, investigation and provide solutions• Developed excel VB form and VBA code for excel data processing • C#, VB, ASP .NET development• GUI design and programming• Troubleshooting and investigation data and reporting issue

Technical Consultant• Cleaned and fixed financial raw data from different clients• Did Data analysis and research to find the errors, mismatches etc. AndAssigned security ID, account number. • Sent Data to DPC for approval• After Approval, sent data to production. And sent results to claims department and file for the case.Platform: Oracle TAO15.1 (64 Bit) and MS Office

Data warehouse / BI consultant• Database/Data warehouse design and implementation• T-SQL programming for stored procedures, functions, trigger etc.• DBA work, such as backup, restoration, database tuning and optimization• SSIS package development• Design, create and maintain reports with MS SQL Server SSRS, MS Excel• Support Legacy solutions and reports while migrating to new platform.• Convert ad-hoc and Excel reports into SSRS reporting solutions.• Manage and maintain the reporting infrastructure (SSRS Server, report deployment, report source control, and security.• Standardize Organize and document the reporting process company-wide.

Sr. BI/Database DeveloperPlatform: MS SQL Server 2008, MS Office, Visual Studio .NET 2008• Developed SQL Stored procedure, functions, trigger etc.· • Developed SSIS package and SQL code to load and maintain data• Used SSRS to created reports in reporting server• Performed Daily Database administration work

Sr. SQL Developer/DBAPlatform: MS SQL Server 2008, MS Office, Visual Studio .NET 2008• Created Actuarial Data warehouse from scratch • Designed all the fact/dimension tables · • Developed SQL Stored procedure, functions, trigger etc.· • Developed SSIS package and SQL code to load and maintain data• Used SSRS to created reports in reporting server• Performed Daily Database administration work

Worked for FINANCIAL DIMENSION INC. ABC IMAGING LLC PCS Revenue Control Systems Inc. Platform: Visual Studio.NET (C#, VB), JavaScript, HTML, XML, MS SQL SERVER, Crystal Report, MS Office on Windows XP Developed and maintained ABC Imaging web applications, and other Client/ServerApplications. Detailed work includes:• Web designing, Programming, testing and implementation• Designed and implemented Web Services• Application Design, programming and testing• Designed and maintained SQL Server Databases• Developed and maintained SQL stored procedures for reports• Used SSRS reporting services to develop reports• Used SSIS to develop SSIS packageBENELOGIC, LLC TIMONIUM, MD 10/2002 - 1/2005Application/Database DeveloperPlatform: Managed Human Resource Data (Payroll, Heath Insurance, 401 K etc.)on Windows XP Platform. The back end was MS SQL Server; the frontend was developed on Microsoft .NET platform; the Web tier was developed on ASP .NET platform. The other tools used included MS Access, MS Excel, Sax macro, and other third part software. Developed and maintained HR software to process health Insurance,Payroll and other benefit data. Detailed work included:• Designed and implemented SQL Server Database· • Developed SQL Stored procedure· • GUI Design and programming. • Developed Visual Basic, C#, ASP .NET Code. • MS Office macro programming

Platform: MS SQL SERVER, MS Office and Visual Basic on Windows NT Platform.Projects: Designed, Developed and implemented elements software forEarthquake, Tornado and Hurricane Risk, Loss, Coverage, Damageanalysis and Calculation. The tools used included with Visual basic 6.0, MS SQL Server, MS Office and third part software.IDEA INTEGRATION (CONSULTING) 7/1998 – 4/2001Technical ConsultantProject I: QwikQuote for First Insurance Funding Corp.(Full lifecycle development)Platform: Visual Basic 6.0, Visual C++ 6.0, ActiveX controls (Crystal Report,Formula One, Far pointer), InstallShield 2000 on Windows NT4.0.Project Summary: QwikQuote is an Insurance lending software. This software was an MDI Windows application including 33 VB forms. My responsibility included: • Wrote the proposal which included platform selection, cost and time estimate.• High level design, prototype design, work flow design, coding and testing.• Project design using Visual Basic 6.0, Visual C++ 6.0, ActiveX controls.• Visual Basic GUI design including Menu, Toolbar, Form design, and insurance calculation design.• Developed code for Visual Basic forms navigation, insurance calculation, file import, export, FTP. • Developed software in Visual C++ to build the connection between third party software Applied System and QwikQuote. • Designed legal lending contracts (88 pages) for all states in USA in Crystal Report 8.0.• Built setup program in InstallShield 2000. Setup program works on all Windows environment (Windows 95/98/2000/NT).• Wrote design documentation and user menu.