SUMMARY

• 10+ years' experience in ETL, database development using SQL Server 2005/2008/2012 , MS Access/VBA, Oracle, DB2, FoxPro and dBase.
• 9+ years' experience in using T - SQL, Stored Procedures, Reporting using SSRS, Data Integration using SSIS, Data Analysis using SSAS under SQL Server 2005/2008/2012 .
• 10+ years programming / database development experience in COBOL, SQL Server, DB2, JCL under UNIX using VI editor. Trouble shooting batch programs under mainframe environment.
• IBM Certified Solution Developer (InfoSphere DataStage V8.0)
• 10+ year's excellent experience in financial data analysis, budget and expenditures.
• 10+ years' experience in conducting family planning / health surveys, questionnaire designing, data analysis and programming. Experience in Population Projections using DEMPROJ.
• 10+ years' experience in data collection, cleaning and quality assurance.
• 10+ years' experience in data analysis / programming using SPSS, SAS Base and Excel using pivot tables.
• 10+ years' experience in information gathering, discussing systems, and placing under technical environment.
• Developed dashboards and reports under Cognos, Tableau, Crystal Reports, and QlikView using dimensions and measures/fact tables.
• Worked under Salesforce environment and created custom objects, fields, reports, dashboards, formulas, and merged duplicate records.

TECHNICAL SKILLS

• SQL Server 2005/2008/2012
• Oracle
• DB2
• MS Access/VBA
• FoxPro 2.6 /dBase-4
• Salesforce
• VBA
• T-SQL
• Stored Procedures
• SQL Server 2005/2008/2012 .
• COBOL under UNIX using VI editor
• COBOL
• SQL
• DB2
• JCL on IBM Mainframe platform
• FORTRAN on IBM Mainframe
• Power BI
• Cognos
• Tableau
• QlikView
• and Crystal Reports
• SSAS
• SSRS
• SharePoint
• SPSS
• SAS Base
• Demproj

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. ETL Developer

Responsibilities:

• Development of ETL packages for health projects using SSIS and SQL Server 2008/2012.
• Extract data using facets tables as source and OLE DB as target.
• Promoted packages to dev, test, and prod environment using GIT.
• Created package level and task level variables and integrated SQL commands within variables.
• Created master packages by including child packages.
• Incorporated changes in the existing packages and made them faster by applying different logic.
• Created links using expressions to make the package more adaptable in changing environments like dev, test and prod.
• Developed packages for Inserts, Updates, Deletes and Reactivates processes.
• Configured package using Package Configurations.
• Edit complex SQL in packages in case of changes.
• Submitted packages to run on-demand or per schedule using Control-M and IS Service portal.

Confidential

Database Developer/SQL Programmer

Responsibilities:

• Developed database for Ministry of Health using standard operating procedures given in HMIS.
• Designed and developed stored procedures to extract data from different files and wrote to the destination tables.
• Designed tables under SQL Server and created all the referential integrity.
• Performed standard ETL operations using SSIS.
• Dashboards and reports were developed for various departments using Power BI.
• Developed searches and created reports using SSRS.

Confidential, Deerfield, IL

Database Analyst/Developer

Responsibilities:

• Developed stored procedures to match required variables from different tables by converting existing data to SQL Server using SSIS, T-SQL, Triggers and Constraints.
• Designed Value Stream Mapping (VSM) to make data processing more efficient.
• Analyzed the structure of different countries regarding "Global Tenders Data" to design ETL procedures for extraction of specific data using SSIS.
• Managed fact and dimension tables placed under data warehouse using T-SQL and SSIS.
• Used Apex Data Loader to perform ETL operations under Salesforce Sandbox environment for Bio360 Compliance Integration (BCI) project.
• Developed reports using SSRS and created data cubes using SSAS.
• Developed dashboards using Power BI.
• Used MS Access and VBA code as front-end and SQL Server 2012 as back-end for converted database.

Confidential, Albany, NY

Programmer

Responsibilities:

• Converting the existing database from Access to SQL Server.
• Designed the system for ‘Extramural Grants Administration' based on Access as front- end and SQL Server as back-end.
• Transferred all the records from Access to SQL Server and removed errors occurred during this process.
• Developed the relationship among tables which was available in the previous system.
• Re-designed the forms based on SQL Server for data entry, editing and deletion of records.
• Analyzed the existing database and develop more comprehensive procedures.
• Developed macros for buttons like Save, Update, Delete, Search and others.
• Designed views and reports using T-SQL, SSIS, SSRS, SSAS, and Stored Procedures under SQL Server 2012, Access/Excel, Macros, and VBA.
• Used SSIS to design ETL procedures for data warehouse.
• Used Crystal Reports to create standardized reports and ad-hoc queries.
• Developed dashboards regarding utilization of grants using Power BI.
• Used Lotus Notes for email, manage meetings and upcoming events.
• Prepared documentation of the developed procedures.
• Uploaded grants data/reports for internal usage using SharePoint.

Confidential, Riverwoods, IL

MS Access/SQL Server Database Developer

Responsibilities:

• Analyzing the existing database and develop more comprehensive procedures.
• Developed VBA procedure to upload data from Excel sheets into Access tables.
• Designed controlled forms using VBA code.
• Developed dashboards for selection of different criterions to run queries/reports using Power BI.
• Designed and developed database for ISSUES and ACTIONS using Access.
• Developed Test Plan forms and make it auto populated in Testing forms using VBA and Access database.
• Performed ETL operations using SSIS for data warehouse fact and dimension tables.
• Designed searches, views, queries, and reports using T-SQL, SSIS, SSRS, SSAS, and Stored Procedures under SQL Server 2012, Access/Excel and VBA.
• Discussed existing system and included fields in new tables for better system designing and data handling.
• Requirement gathering, business analysis, and adding the data in system flow.
• Used Lotus Notes for email, manage meetings and upcoming events.
• Prepared documentation of the developed procedures.
• Used SharePoint to publish Issues/Actions reports for internal usage.

Confidential, Glendale, CA

MS Access / SQL Server Database Developer

Responsibilities:

• Designed tables and created relationship among them.
• Developed forms using dependent and independent fields.
• Developed queries using multi-sort order.
• Wrote VBA procedure to upload data from multiple excel data sheets.
• Handled null values while reading data from excel and writing to access tables.
• Designed text search and other searches using input from forms and searching the required data in tables.
• Developed dashboard for different queries and reports using VBA code and QlikView.
• Extracted data from different tables and incorporated the same into excel for analytical purpose.
• Developed ETL processes for data integration and performed conditional split on source data using SSIS.
• Designed ad-hoc queries, views and reports for immediate data analysis using T-SQL, Stored Procedures, SSIS, SSRS and SSAS under SQL Server 2012.
• Designed and developed database for items and orders using Access/VBA from scratch.
• Collected information for system designing and discussed each field in detail with the manager.
• Business analysis, information collection using different sources, and converting information into technical documentation.
• Prepared reports using Access/Excel.
• Used Lotus Notes for email, meetings and scheduling.
• Published sales reports for different components using SharePoint.

Confidential, Mount Laurel, NJ

MS Access /SQL Server Database Developer

Responsibilities:

• Developed VBA code to import data from different input sources.
• Designed tables to incorporate imported data into Access tables.
• Designed input and searchable edit forms using a key field.
• Designed controlled forms in Access using VBA code.
• Developed database for items received, sold, pricing, and invoices.
• Designed multi-level sorted queries, views and reports using T-SQL, Stored Procedures, SSIS, SSRS and SSAS under SQL Server 2008.
• Developed ETL processes for data integration using SSIS for sources like flat files, Excel Sheets, and Access data.
• Developed searches by selecting any item to see the re-order level.
• Performed mathematical calculations in queries and reports.
• Discussing systems, managing information and placing under technical requirements.
• Used Lotus Notes for email, meetings and scheduling.

Confidential

Programmer/Application Developer

Responsibilities:

• Database development in MS Access/VBA, FoxPro 2.6, COBOL, DB2, Oracle and SQL Server 2005.
• Designing queries, searches and reports using different platforms including MS Access/VBA, Oracle, COBOL with DB2, and SQL.
• Web development using ASP.Net, HTML, C#, VB.Net, and SQL Server 2005.
• Created database(s) and developed views, queries, searches and reports using T-SQL, Stored Procedures, SSIS, SSRS and SSAS under SQL Server 2005.
• Designed ETL jobs using DataStage V8.0.
• Population projections using DEMPROJ.
• Used Cognos to develop different reports for Sales and Marketing Meta Data placed under data warehouse.
• Used Tableau for data analysis and creating dashboards.
• Trouble shooting COBOL batch program code.
• Programming in COBOL, DB2, SQL, and JCL under UNIX environment.
• Shell scripting in UNIX using VI editor.
• Performed data collection during national surveys, wrote procedures for data cleaning and developed reports.
• Analyzing the business needs and incorporating under technical environment.
• Data Analysis and programming using SPSS 10.0 and SAS Base 9.2.
• Maintenance of official website.
• Developed and managed national level IT projects in public sector.