SUMMARY

• Extensive experience in ETL, reports, database design, development and administration with MS SQL Server versions 2012, 2008 R2/2005 using SSIS, SSRS, SSAS, SharePoint 2010, Reportive Studio 9.0/9.2 (ETL Dashboard) and report development experiences in Courier, Finance, Banking, Technology, Healthcare and Pharma industries.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Development, setup and configuration knowledge and experience of Business Intelligence technologies.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS, 2005/2008/2012 ), DTS (Data Transformation Services), MS SQL Server Reporting Services (SSRS MS SQL server 2005/2008/2012 ) and Analysis Services (SSAS 2005/2008/2012 ).
• Experienced in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and Visual Studio 2010.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2012
• Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Visual Studio 2008/2010/2012/2015
• Reportive Studio 9.0/9.2 (ETL dashboard)
• Business Intelligence Development Studio (BIDS)
• DTS (Data Transformation Services)
• BCP
• SQL Profiler
• Enterprise manager
• SQL Server Management studio 2008/2012
• T - SQL
• Power Shell 3.0
• ASP.NET 5
• C#
• VB.Net
• HTML
• XML
• XSL
• XSD
• SharePoint 2010
• Oracle 9i/10g
• DB2
• SQL Server 2008 R2 Master Data Services (MDS)
• Crystal Reports 8.5/9/10/11
• Team Foundation Server 2010/2012 (TFS)
• PVCS
• IBM Data Staging
• MS office 2003/2007/2013
• Windows 2000/2003 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• Progress 10.0b
• Progress10.0b (character mode)
• Progress 10.0b (GUI)
• Open Edge
• KTech-Fusion Employee Self-Service Portal
• Data link Connector
• APPTIO.

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

SSIS Developer and SQL Server Developer

Responsibilities:

• Analyzed and converted teh customer's requirement into a technical design document.
• Designed, developed and automated teh ETL process in SSIS and SQL Server to load teh current Fiscal year data for teh internal client.
• Designed, developed and maintained teh databases, tables and stored procedures in SQL Server 2008R2.
• Developed teh automated ETL process in SSIS packages for multiple databases to handle teh current Fiscal year data.
• Developed teh connector scripts in xml and mapped this to teh Datalink to teh APPTIO for FTP.
• Loaded teh data to teh development and staging environment, through teh datalink to teh APPTIO for reporting requirements of teh internal client.
• Perform Unit testing for Reconciliation and participated in QA testing for teh assigned projects.
• Developed scripts in Power Shell to automate teh SSIS package Execution process and other related tasks.
• Participated in Production Deployment and UAT testing.
• Developed, tested and implemented teh table definition scripts to add teh new and to maintain teh existing tables in teh SQL Server database for production deployment.
• Developed, tested and implemented teh Bulk Insert SQL Server script to load teh data to teh SQL Server database from .csv file during production deployment.
• Installed and configured teh Team Foundation Server
• Developed teh new and maintained teh existing SSIS Packages.
• Migrated objects from development to production environments.

Environment: MS SQL Server 2005/2008 R2/2012, SSRS 2008 R2 /2012, SSIS 2008 R2 /2012, Visual Studio 2010/ 2012/2015 , Windows NT/2003, Window7, TFS 2008/2012, Power shell 3.0, Microsoft Office 2013, C#,ASP.Net 5, xml, KTech-Fusion Employee Self-Service Portal, Data link Connector, APPTIO.

Confidential, Paramus, NJ

BI Developer and SQL Server Developer

Responsibilities:

• Experienced in designing, developing and maintaining teh SQL Server database for MIRR.
• Developed teh stored procedures, views, indexes and Triggers.
• Designed, developed and maintained Master and Child SSIS Packages for MIRR (Mail Innovation Reconciliation Repository) SQL Server database.
• Configured and deployed teh SSIS packages through both process, Catalog database 2012 based and file based configuration at MSDB (SSIS Server).
• Optimized teh SSIS Packages and developed SQL deployment script for Catalog database based SSIS Packages.
• Developed SQL Agent Job script for teh SSIS Packages.
• Worked on database partitioning, Indexes, performance tuning and query optimization.
• Participated in Unit and Integration testing of teh database and SSIS Packages.
• Synchronized teh TFS Source control with teh development database.
• Documented all teh design, development and testing process.
• Provided training to other team members.

Environment: MS SQL Server 2005/ 2008R2/ 2012, SSRS 2008R2/ 2012, SSIS 2008R2/ 2012, Visual Studio 2010/ 2012, Windows NT/ 2003, Window7, TFS 2012, Microsoft Office 2013, C#, xml

Confidential, New York

SQL Server, SSRS / ETL Developer

Responsibilities:

• Worked on many assignments for data processing in ETL through T-SQL stored procedures and third party job launcher in .net and C#.
• Developed MTD Accrual Reconciliation Report, Transparency Report and Portfolio Security Report, by gathering teh requirements from Business Analyst, developing in SSRS and deploying it on Report Manager.
• Developed four Various Daily Stock Loan reports in one SSRS RDL file which generate four different sheets for each report in one excel file and deployed it on Report Manager.
• Developed many new stored procedures and modified teh existing stored procedures for SSRS reports and data Feed Definitions.
• Maintained and promoted SQL Stored procedures and RDL files through Surround SCM in testing and production environment.

Environment: MS SQL Server 2008 R2, SSRS 2008 R2, SSIS 2008 R2, Surround SCM, Windows 7, Microsoft Office 2007, C#, .Net .

Confidential, Bedminster, NJ

Software Developer/ BI Developer

Responsibilities:

• Prepared technical documentation of client’s Activity, Performance and Results for sales and marketing of their products.
• Performed design, development, implementation and unit testing of reports in SSRS 2008 R2 (Report Builder 3.0) and Reportive Studio 9.0/ 9.2 with SSAS 2008 R2 cubes and Oracle 11g SQL query as data source, published in MI 7 (mobile intelligence laptop and iPad) for pharma clients
• Provided teh training and demo to teh team in SSRS (Report Builder 3.0) and MS OLAP cubes.
• Configured and setup teh OLAP cubes in Reportive Studio 9.0/9.2 to deploy on SQL Server 2008 R2 as SSAS OLAP cubes.
• Configured teh multiple nodes of Report Server for development, QA and Production environments.
• Maintained teh ETL scripts of Reportive Studio 9.0/9.2.
• Converted teh Reportive Studio 9.0/9.2 ETL scripts to SQL query in Oracle 11g for MI 7 (mobile Intelligence) Reports for various pharma clients.

Environment: MS SQL Server 2005/2008 R2, SSRS 2008 R2, SSIS 2008 R2, SSAS 2008 R2, Windows NT/2003, Microsoft Office 2007, Reportive Studio 9.0/ 9.2 (ETL Dashboard), Oracle 11g .

Confidential, Short Hills, NJ

SQL Server / SSRS Developer

Responsibilities:

• Developed many reports for remittance and inquiry reports for CDS, Checking, Saving and Loan business requirement by region and branch for internal clients.
• Used BCP utilities, Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Developed and scheduled a SSIS Package to programmatically extract teh DB2 Data Warehouse to SQL Server database to support teh MIS team’s reporting requirement.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize teh run time. Exported reports into various formats (PDF, Excel) and resolved formatting issues.
• Optimized teh performance of queries with modifications in T-SQL queries, Normalized Tables, established Joins and created Indexes whenever necessary.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.

Environment: MS SQL Server 2005/2008 R2, SSRS 2008 R2, SSIS 2008 R2, Windows NT/2003, Microsoft Office 2007, C#, .Net .

Confidential, Madison, NJ

SQL Server Developer / ETL Analyst

Responsibilities:

• Identify and document transformations and business rules implemented in CDR DTS (Data Transformation Services) for data elements dat has been defined in CORe and other than those dat has been defined in CORe.
• Recommend a strategy and high level end-state architecture for re-architecting existing CDR inbound and outbound interfaces suitably (in conjunction with CORe).
• Experience in developing, modifying and performance tuning of teh new and existing triggers, stored procedures, indexes and constraints to provide required solution for packages.
• Modify and develop SSIS packages for inbound and outbound files on daily basis to teh target table and to log teh details of teh load as and when load teh file into teh Data Warehouse.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Analyze teh WebSphere Data Stage Transformation packages dat provide teh source data (AS/ 400, Oracle and Siebel) to teh CDR and document it accordingly.
• Continuous coordination and collaboration with other development and QA team members.

Environment: MS SQL Server 2005/2008 R2, DTS (Data Transformation Services), IBM Web Sphere Data Stage and Quality Stage 8.1, MS Visio 11.0, Windows NT/2003, Microsoft Office 2007.

Confidential, Allentown, PA

MS SQL Server Developer/BI Developer

Responsibilities:

• Worked on historical records maintenance of teh SQL Server database for auditing.
• Extensively working experience in developing, modifying and performance tuning of teh new and existing triggers, stored procedures, indexes and constraints with better solution to be used in dot net application.
• Set up and configuredTFS (Team Foundation Server) Source Control for MS SQL Server Management Studio and maintained theSQL scripts in TFS to support teh development team.
• Installed, configured and tested teh MDS (SQL Server 2008 R2 Master Data Services) to has efficient functionality available in T-SQL development.
• Developed SSIS packages to load teh flat file on daily basis to teh target table and to log teh details of teh load as and when load teh file into teh database.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.

Environment: MS SQL Server 2008 R2, SQL Server Integration services (SSIS), BIDS 2008 R2, Visual Studio 2010, TFS 2010 (Team Foundation Server), MDS (SQL Server 2008 R2 Master Data Services), MS Visio 11.0, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential, Woodbridge, NJ

System Analysis & Development Analyst

Responsibilities:

• Worked on Relational redesign project where modified teh modules for VPAS system.
• Run query on timely basis and generates ad hoc reports in Progress 4gl v10 on for teh operation according to teh issues created by liaison group.
• Test and run periodically global price correction module in progress 4gl to correct teh price of provided funds.
• For AMPLIFI modified program in Progress 4gl v8 to support an interface control file dat meets Company interface standards. This control file is valued with teh count of teh number of records sent.
• CMF Code modification was done in Progress 4gl v8 for conversion by changing and adding teh criteria to get teh required value from VPAS System during teh System release. Modified module calls other module to get teh calculated value.

Environment: Progress 9.1b / 10.0b, Open Edge, UNIX, Lotus Notes 5.0, MS Office, Visio 3.0, MS SQL Server 2005.