SUMMARY:

• Over 20 years of IT experience with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working with fortune 500 companies in various Industry verticals like Finance, banking, investing, insurance and Health Care.
• Extensively worked with the Business Users gathering their requirements and actively cataloging and supporting various issues and providing their solution.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures
• Expertise in T - SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Background in Data warehousing projects development and seven years of ETL experience using SQL Server SSIS
• Experience in Data Modeling, creating ERD and data dictionary. Exposure to various data modeling tools like Oracle Developer 2000, Erwin, MS Visio etc.
• Experience in Extraction, Transforming and Loading (ETL) using SSIS creating mappings/workflows to extract data from SQL Server, Oracle, Excel file, DB2, SharePoint lists and Flat File sources and load into various Business Entities.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning,
• Good Business and System analysis skills to understand the requirements and client needs.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access, Oracle to MS SQL Server by using BCP utility and DTS/SSIS services.
• Strong working experience of Data Warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema), OLAP and Database performance tuning.
• Experience with C# and VB script.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. SQL Developer

Responsibilities:

• Worked on SQL Server 2012 to develop ETL Solutions.
• Experience in software Analysis, Design, Development, and Testing
• Worked in Agile environment. Participated in daily Scrum meetings.
• Used Team Foundation Server (TSF) 2013.
• Worked with Dynamic SQL, Stored Procedures and Triggers
• Developing SSIS packages for ETL processes.

Confidential, NJ

Sr. BI Engineer

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle, DB2 to SQL Server by using SSIS services.
• Expertise in software Analysis, Design, Development, and Testing
• Involved in writing scripts and job scheduling using IBM Maestro
• Experience in version controlling using Star team tool.
• Worked with data extraction from Netezza.
• Extracted data from main frame DB2 and populated data warehouse after various transformation.
• Experience in performing Data Conversion, Data Scrubbing, and Data Transformations with SSIS Packages and stored Procedures.
• Responsible for applying new company standards on existing SSIS packages using dynamic configurations, custom view for error handling, .
• Working with C# and VB Script.Worked on SQL Server 2008 data warehouse
• Expertise in software Analysis, Design, Development, Testing, Implementation and Production Support of Client/Server and Web based applications.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access to MS SQL Server by using SSIS services.
• Expertise in writing SSIS Template Package using - Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable which Deployment and Troubleshooting.
• Strong working experience of Data Warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema), OLAP and Database performance tuning.
• Expertise in T-SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Experience in data normalization and data modeling using Erwin and Visio

Confidential, Camp Hill, PA

MS SQL Server Developer/SSIS Developer

Responsibilities:

• Involved in various business analysis meeting and created the business requirement document according to end clients’ needs.
• Responsible for performance tuning of existing SSIS packages and introduced dynamic configurations, custom logging, Error Handling etc.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created configuration Tables, Stored Procedures, User Defined Functions in SQL Server Management Studio to support the whole SSIS process workflow.
• Created the workflow documents for all existing and new SSIS packages.
• Responsible for Troubleshooting Report Processing, Subscription, Delivery and Configuration
• Developed Query for generating drill down and drill through reports in SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Modified custom page in SharePoint designer to permit users kick off specific workflows based on user selections and privileges.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: MS SQL Server 2008, T-SQL, SSIS, SSRS, Visio, MS Excel, MS Word, Visual Studio (BIDS)

SQL Developer

Confidential, NJ

Responsibilities:

• Created and configured the database. Created the tables having required constraints.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Integrated Flat files and Excel sources data into SQL Server 2005 through SSMS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by my team lead for different environments and assisted in coding, design and performance tuning.
• Backup and restore databases.
• Created the DTS Packages through ETL Process in which records were extracted from Flat file and Excel sources and loaded daily Confidential the server.
• Managed logins, roles, assigning rights and permissions. Created views to implement security.
• Backing up master & system databases and restoring them when necessary. Supported production environment.

Environment: - MS SQL Server 2005, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, MS Excel & Windows NT platform.

Confidential

Project Management Coordinator

Responsibilities:

• Responsible for data extraction from various in house and external sources. Verified the integrity of data and mapped the data to the target database.
• Was responsible for producing daily reports for the client. This included a variety of reports.
• Designed logical and physical data model of a consolidated database.
• Designed and created an Access database to store the directions and contact information about the cellular sites.
• Interviewed user and stake holder of the system to understand the needs and recommend a solution.
• Crated a requirement document for the system.
• Created Data modeling for delivery confirmation system using Oracle Developer 2000.
• Created functional specifications for data archival and retrieval system
• Provided the application team with the technical specifications.

Environment: - IBM 3090, DB2, TSO, Endeavor, Query SPUFI, Access, MS Excel, MS Word & Windows NT platform.

Confidential - Pittsburgh, PA

Application DBA

Responsibilities:

• Developed logical model and implemented physical DB2 database for sales department of the bank.
• Created the database dictionary for the database
• Created and maintained a QA environment for the group.
• Created complex Stored Procedures and Functions to support the front-end application.
• Helped application developers fine tune SQL queries for improved Performance.
• Re-organized database structures as needed, automate procedures Confidential regular intervals.
• Optimized long running Stored Procedures & Queries for effective data retrieval.
• Founded and chaired a company-wide DB2 user group
• Worked on the managed health care system.
• Involved with the system conversion effort from VSAM to DB2.
• Developed technical specifications for programmer
• Helped the application programmers’ fine tune the SQL queries.
• Execution of various DB2 utilities
• Worked in the payroll department of UPS.
• Involved in the development and implementation of a new DB2 payroll system.
• Disaster recovery coordinator for payroll application.
• Carried out a developer’s role on Health and Welfare Using COBOL II and DB2.
• Experience with international Financial system