SUMMARY:

• 19+ years of IT experience in Software Analysis, Development, Implementation of business applications for Healthcare, Financial, Insurance, Manufacturing and Government verticals.
• Extensive Knowledge of Relational databases and Data Warehousing.
• Full lifecycle implementation experience.
• Creative and effective problem solver with good analytical skills.
• Quick learner with strong leadership, analytical and communication skills.

TECHNICAL SKILLS:

Data Warehousing: Star Schema, Snowflake Schema, OLTP, OLAP, DTS Packages, SQL Server Integration Services 2005/2008/2012, Red Gate Compare Tool, Visual Studio 2008/2010, SSMS, IBM clear quest, Rational, Jira, SVN, TFS

Databases: SQL Server 2005/2008/2012 /2014, DB2

BI & Reporting Tools: SSIS 2005/2008R2/2012, SSAS 2008R2/2012, SSRS 2008R2/2012, Informatica Powercenter 9.5.1

Languages: SQL, T - SQL, C#, XML, MDX, VB.NET

Operating Systems: Windows 2000/XP, Windows 2008R2, Windows 2012

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr BI Consultant

Responsibilities:

• Involved with Russell Investments Risk vertical.
• Architected, designed and developed SSIS 2008R2 packages from Informatica9.5.1Workflows for Risk Metrics application.
• Provided Production support activities for EDW (Enterprise Data warehouse) and Risk Metrics applications.
• Involved with SQL query development, performance tuning of SQL Queries.
• Involved with SQL stored procedure development to be used in SSIS packages and Informatica power center
• Involved with creating Adhoc SQL queries to fix production/UAT issues.
• Involved with analysis and development of BRD, TSD, Mappings documents
• Worked with various groups (Business, Architecture, QA) to gather requirements and perform support activities.

Environment: SQL Server 2014/2016,T- SQL, SQL Server Management Studio, SQL Server Integration Services 2008R2/2012, Windows 2008 Server, Red Gate, MS Office, Visual Studio 2010, C#, MS Outlook, SVN, Jira, Informatica Power Center 9.5.1

Confidential

Sr Technical Architect

Responsibilities:

• Involved with Post Office Information systems Migration project.
• Involved with environment setup, migration of SSIS packages from SQL 2005 to SQL 2014 .
• Developed SSRS reports from BO reports
• Migrated databases from SQL server 2005 to SQL server 2014.
• Designed and developed SSIS Packages to load data from source to target tables.
• Developed stored procedures, SQL database scripts, SSIS packages and SSRS reports using Visual Studio 2010, SSIS 2012, SSRS 2012
• Involved with setting up SQL jobs, testing the complete flow from local SFTP to client SFTP

Environment: SQL Server 2014,T- SQL, SQL Server Management Studio, SQL Server Integration Services 2012, SQL Server Reporting Services2012, Windows 2008 Server, Compare tool, MS Office, Visual Studio 2010, C#, MS Outlook, SVN, Jira.

Confidential, Nashua, NH

Sr MSBI Consultant

Responsibilities:

• Involved with Medicaid/Medicare Management Information systems project part of Confidential
• Analyzed the functional specs provided by the TRA and created technical specification documents for all the mappings.
• Designed and developed SSIS Packages to load data from source to target tables.
• Developed stored procedures, SQL database scripts, SSIS packages and SSRS reports using Visual Studio 2008/2010, SSIS 2005/2008, SSRS 2005/2008.
• Created SSIS packages to extract, transform and load data from different sources like flat files, Excel spread sheets and CSV files, DB2/Oracle Tables, transform data and load to Stage and Target SQL Server Tables/flat files by adhering to SSIS ETL framework in .NET environment with VB.NET being the primary language.
• Deployed SSIS packages in Development, SIT, UAT and Production using customized deployment utility tool.
• Created and deployed cubes in star schema. Performed and worked with dimensions, measures, generating KPI, MDX queries.
• Used IBM Rational Tool (RQMS Migration system) for migration process.
• Resolved SIT/UAT/Production defects relating to SQL Server database and SSIS packages.
• Provide On-Call support for MMIS data warehouse systems which included DSS, JSURS, Member, Eligibility, Claims, Prior Authorization, Reference, Provider modules containing these components (UC4 jobs, SSIS packages, stored procedures, triggers, functions, command lines and run books).
• Used TFS to maintain version control repository for SSIS packages.
• Worked on developing adhoc/remediation using T-SQL scripts to fix TR and PR’s.
• Used Data Import/Export tool available in SSMS to Import/Export data from one instance to another in SQL Server 2005/2008, upload excel spreadsheets.
• Converted SSIS packages from 2005 to 200 8.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Maintaining the existing databases by making enhancements, optimization and fixing defects.
• Optimized ETL Jobs, DTS Packages, and Stored Procedures to improve data integration.
• Fixed application deadlocks by defining Locks with Isolation Levels in stored procedures.
• Used Red compare tool to compare data between tables/stored procedures residing in two different servers to perform synchronization’s.

Environment: SQL Server 2005/2008R2,T- SQL, SQL Server Management Studio, SQL Server Integration Services 2005/2008, SQL Server Reporting Services2005/2008, SQL Server Analysis Services 2005/2008, Windows 2008 Server, IBM Rational tool, DB2, Red Gate Compare tool, MS Office, Visual Studio 2008/2010, TFS, share point, VB.NET, Ultra Edit, Ultra Compare, MS Outlook.

Confidential, Lowell, MA

Senior Database/MSBI Developer

Responsibilities:

• Involved with Meaningful Use project part of Alere Analytics claims verticals as part of scrum team.
• Created SSIS packages using visual studio 2010.
• Created stored procedures and be used in call from SSIS packages and also were triggered from SQL server Agent jobs.
• Created SQL Server Agent jobs, to run T-SQL commands, SSIS Packages, Stored Procedures.
• Worked on adhoc requests to generate scripts for data loading from files, excel spreadsheet Into SQL Server tables.
• Worked on deploying SSIS packages from DEV to SQA, UAT and PROD. Used environment variables, SSIS configurations, package configurations to perform dynamic calls of passing data from tables into SSIS packages.
• Debugged, analyzed production and development issues pertaining to SSIS packages, stored procedures.
• Developed many Tabular Reports, Matrix Reports, Drill Down Reports, Sub-Reports, Drill Through, and Parameterized Reports using SQL Server Reporting Services (SSRS).
• Worked on HL-7 interfaces on Bronx project.
• Worked on Red gate tool to compare data and synching databases.
• Created stored procedures, views, indexes, triggers, tables.
• Optimized SQL server Stored procedures, SSIS packages, T-SQL scripts and ad hoc queries.
• Ad hoc tasks also included taking database backup’s and restores.
• Modified SSIS script tasks using C# to parse input XML.
• Created and deployed cubes using SSAS.

Environment: SQL Server 2012,T-SQL, SQL Server Management Studio, SQL Server Integration Services 2012, SQL Server Reporting Services 2012, SQL Server Analysis Services 2012, Windows 2012 Server, Red Gate Compare tool, MS Office, Visual Studio 2010, XML, SubVersion/SVN, share point, C#, MS Outlook.

Confidential, Manchester, NH

Lead ETL/Database Developer

Responsibilities:

• Involved with data conversion project part of River Stone claims and Re-insurance verticals.
• Created entity relationship diagrams using Visio.
• Incorporated best practice methodologies to be used in creating functional and technical specifications.
• Created an master template framework code to bring the new code development under standard framework guidelines.
• Performed analysis of legacy data and created technical specifications document for developers to code.
• Synchronize the database schema - table, columns and indexes for all clients and base version.
• Take part in daily scrum meetings to inform the status and bring up issues with management.
• Interact with technical, business and QA groups on daily basis to raise/resolve outstanding issues.
• Involved in setting up meetings with technical and business personnel to discuss in creating requirements and technical mapping templates.
• Involved with code migration to Test, QA and PROD regions.
• Involved with writing complex SQL queries, creating packages and stored procedures to load data.
• Used TFS to maintain version control repository for SSIS packages, stored procedures, triggers, views, technical and functional specifications.
• Used tracking tool to maintain repository of mapping documents and update status of source to target field level details percentages.
• Build and Maintain indexes to tune T-SQL queries.
• Defined data integration settings by updating stored procedures and packages to improve the application performance.
• Used Red compare tool to compare data between tables/stored procedures residing in two different servers to perform synchronization’s.

Environment: SQL Server 2008R2,T-SQL, SQL Server Management Studio, SQL Server Integration Services 2008, SQL Server Reporting Services 2008, Windows 2008R2 Server, Red Gate Compare tool, MS Office, Visual Studio 2010, TFS, share point, Tomcat Webserver, Guide wire tool, VB.NET, MS Outlook.

Confidential, Nashua, NH

Sr. Database/ETL Developer

Responsibilities:

• Involved with Medicaid/Medicare Management Information systems project part of Confidential
• Analyzed the functional specs provided by the data architect/TRA and created technical specification documents for all the mappings.
• Designed and developed SSIS Packages to load data from source to target tables.
• Developed stored procedures, SQL database scripts, SSIS packages and reports using Visual Studio 2008/2010, SSIS 2005/2008, SSRS 2005/2008, SSMS.
• Created SSIS packages to extract, transform and load data from different sources like Mainframe flat files, VSAM, Excel spread sheets and CSV files, DB2/Oracle Tables, transform data and load to Stage and Target SQL Server Tables/flat files by adhering to SSIS ETL framework in .NET environment with VB.NET being the primary language.
• Deployed SSIS packages in Development, SIT, UAT and Production using customized deployment utility tool.
• Used IBM Rational Tool (RQMS Migration system) for migration process.
• Resolved SIT/UAT/Production defects relating to SQL Server database and SSIS packages.
• Provide On-Call support for MMIS data warehouse systems which included DSS, JSURS, Member, Eligibility, Claims, Prior Authorization, Reference, Provider modules containing these components (UC4 jobs, SSIS packages, stored procedures, triggers, functions, command lines and run books).
• Used TFS to maintain version control repository for SSIS packages.
• Worked on developing adhoc/remediation using T-SQL scripts to fix TR and PR’s.
• Used Data Import/Export tool available in SSMS to Import/Export data from one instance to another in SQL Server 2005/2008, upload excel spreadsheets.
• Converted SSIS packages from 2005 to 200 8.
• Maintaining the existing databases by making enhancements, optimization and fixing defects.
• Optimized ETL Jobs, DTS Packages, and Stored Procedures to improve data integration.
• Fixed application deadlocks by defining Locks with Isolation Levels in stored procedures.
• Used Red compare tool to compare data between tables/stored procedures residing in two different servers to perform synchronization’s.

Environment: SQL Server 2005/2008R2,T- SQL, SQL Server Management Studio, SQL Server Integration Services 2005/2008, SQL Server Reporting Services2005/2008, Windows 2008 Server, IBM Rational tool, DB2, Oracle 8i, VSAM, Red Gate Compare tool, MS Office, Visual Studio 2008/2010, TFS, share point, VB.NET, Ultra Edit, Ultra Compare, MS Outlook.

Confidential, Merrimack, NH

Data Warehouse Developer

Responsibilities:

• Design Multi Environment ETL framework by creating deployment folder with SSIS Packages, stored procedures, SSIS connections to run the SSIS Packages.
• Designed and Developed Generic ETL Jobs to load data dynamically by providing Source and Target on the fly.
• Developed Stored Procedures to accommodate the customer request to Run the SSIS Packages, Load and archive the data in the Data Warehouse.
• Designed and build multi-dimensional OLAP cubes in real-time to provide Very Large Volume Financial data to publish Analytical reports on the Portal.
• Maintain Data Integrity by running ETL Packages and keeping tables updated with latest data in various environments.

Confidential, Concord, NH

Sr Programmer/Analyst

Responsibilities:

• Involved with New Heights Project under Confidential Practice of Confidential .
• Developed Cobol, DB2 programs for Application Entry Module of the New Heights Project.
• Involved with creating Systems development Specifications, Technical systems Development, Development of code.
• Involved with Code walk through, Unit Testing and Systems Testing.
• Interact with functional leads to gather requirements as and when needed
• Provide On Call Production support for New Heights Project.
• Maintenance, Enhancement and Periodic Monitoring of Application Entry Batch Job ‘s using Zeke Scheduler.
• Developed Test Cases and documentation.

Environment: TSO/ISPF, SPUFI, DB2, COBOL II, SQL, OS/390, JCL, FILE-MANAGER, TMON, ENDEVOR, DB2, INTER-TEST, ZEKE, REXX, SYNCSORT, MS-OFFICE, CA-DB2 TOOLS, WINDOWS 2000, VISIO, LOTUS-NOTES, FTP.

Confidential, Dearborn, MI

Programmer/Analyst

Responsibilities:

• Involved with eDDL (electronic Direct Data Link) systems under Manufacturing and supply chain Practice of CMMS system.
• Developed Complex Cobol/DB2 Stored Procedures, COBOL/DB2/IMS Online and Batch on Mainframe from ground up based on functional requirements gathered from end users and business analysts.
• Involved with designing, development, testing and integration of back end Mainframe Stored Procedures with real time web front-end screens.
• Modified the existing code as we get enhancement requirements from business customers.
• Provide on call Production support
• Developed Specifications, Code, Test Cases and Performed Unit, Functional and Systems testing for all the programs in accordance with Solution Delivery Methodology Practice.
• Created Help text documentation in HTML for the web front-end screens.

Environment: TSO/ISPF, QMF, SPUFI, DB2, COBOL II, SQL, Z/OS, JCL, IMS DC, IMS DB, ABEND-AID, FILE-AID, XPEDITOR, OMEGAMON, MOBIUS, VSAM, DB2 SPB, WLM, MS-OFFICE, WINDOWS 2000, VISIO, CHANGEMAN, SYNCSORT, PUPS, MS-OUTLOOK, DB2 STORED PROCEDURES, WSAD, HTML, MFS, STROBE, TEST DIRECTOR, FTP, DOCUMENTUM TOOLS (EROOM, EKB), SDM DOCUMENTATION.