15+ Years of Extensive experience in ETL, reports, database design, development and administration with MS SQL Server versions 2016, 2014, 2012, 2008 R2/2005 using SSIS, SSRS, SSAS, Power BI 2.3, SharePoint 2010 and report development experiences in Courier, Finance, Banking, Lending, 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 mobile technologies and Power BI 2.3.
Expert in Microsoft Business Intelligence(BI) technologies like MS SQL Server Integration Services (SSIS, 2005/2008/2012/2014/2016), DTS (Data Transformation Services), MS SQL Server Reporting Services (SSRS MS SQL server 2005/2008/2012,2014,2016) and Analysis Services (SSAS 2005/2008/2012,2014,2016).
Developed TSQL Stored procedures, Function, Views, indexes and experienced in query optimization and Database Performance Tuning.
Designed and developed logical and physical Database, experienced in normalization and data modeling using Erwin and Visual Studio 2010.
MS SQL Server 2005/2008/2012,2014,2016, Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Power BI 2.3, Visual Studio 2008/2010/2012/2015, Business Intelligence Development Studio (BIDS),Data Transformation Services (DTS), BCP, SQL Profiler, Enterprise manager, SQL Server Management studio 2008/2012, 2014, 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, 2010 Advanced Server/Professional, Windows NT 4.0 Server/ Window 12 Workstation, Progress 10.0b, Progress10.0b (character mode), Progress 10.0b (GUI), Open Edge,, KTech-Fusion Employee Self-Service Portal, Data link Connector, APPTIO.
Montefiore Medical Center, Yonkers, NY 03/2018 - Present
Software Engineer (SQL SERVER, SSIS, Power Shell)
Responsibilities include development in SSIS packages, Power Shell scripting, SQL Server Database development for Managed Care at Montefiore. The project is to implement a new Interface process from Salesforce Database to Epic Database and handle another assigned tasks related to project.
Developed interface process in SSIS Master and child package concept to generate the flat file for the Epic Database.
Automated the manual window tasks for SQL Server Agent Job in power shell script and SQL Stored procedures and functions.
MS SQL Server 2005/2008 R2/2012, 2014, 2016, SSRS 2008 R2 /2012, SSIS 2008 R2 /2012, 2014, 2016, Visual Studio 2010/ 2012/2015, 2016, Windows NT/2003, Window7, window 10, Window 12, TFS 2008/2012, 2014, 2016, Power BI 2.3, Power shell 3.0, Microsoft Office 2013, C#, ASP.Net 5, xml.
Fundation, New York, NY 01/2016 –01/2018
Senior Database Engineer
At Fundation, a direct lending company, with role of Senior SSRS report and SQL Server database developer, handles all the internal business users and management reports requirement with the responsibilities of analyzing, developing, testing and deploying the reports. Publish and manage the SSRS reports subscription in the SSRS 2014 report manager, mobile reports in SSRS 2016 Reporting Services Web Portal and mobile reports in Power BI web portal. Documented and developed many SSIS packages, modified and developed stored procedures, functions, views and indexes.
Develop and subscribe daily, weekly, monthly and quarterly SSRS reports in Excel through the Report Manager and Reporting Services Web Portal.
Designed, developed and published the SSRS and Power BI mobile reports for the internal client.
Configured the Report Manager, Reporting Services Web portal, Power BI web portal and integrated these to the Mobile phone and Tablet.
Documented the existing and new ETL process, developed the SSIS packages from various sources and deployed these in SSIS.
Maintain and develop the new and existing stored procedures, Function and view in Azure Database.
Optimized T-SQL queries and stored procedures by analyzing the script in the Execution Plan and maintaining the proper indexes for dot net applications, SSRS reports and SSIS packages.
Normalized the tables, established Joins and created Indexes for Database performance tuning.
MS SQL Server 2005/2008 R2/2012, 2014, 2016, SSRS 2008 R2 /2012, SSIS 2008 R2 /2012, 2014, 2016, Azure Database, Visual Studio 2010/ 2012/2015, 2016, Windows NT/2003, Window7, window 10, Window 12, TFS 2008/2012, 2014, 2016, Power BI 2.3, Power shell 3.0, Microsoft Office 2013, C#, ASP.Net 5, xml.
KPMG, Montvale, NJ 05/2015 – 11/2015
SSIS Developer and SQL Server Developer
Responsible at KPMG in development for internal client in MS SQL Server 2008 R2, T-SQL, database design, SSIS / Advanced SSIS architecture design and development of SSIS ETL Data Flow. Performance tuning, troubleshooting, ETL Job Scheduling, scripting in Power Shell for automating the Scheduler and other tasks. Analyze the requirement, design, document, develop and unit testing for assigned projects.
Analyzed and converted the customer's requirement into a technical design document.
Designed, developed and automated the ETL process in SSIS and SQL Server to load the current Fiscal year data for the internal client.
Developed SSIS packages to load the current Fiscal year data in many databases.
Developed the connector scripts in xml and mapped this to the Datalink to the APPTIO for FTP.
Loaded the data to the development and staging environment, through the datalink to the APPTIO for reporting requirements of the internal client.
Developed the new and maintained the existing SSIS Packages.
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.
UPS, Paramus, NJ 07/2013 – 03/2015
BI Developer and SQL Server Developer
As a team member at UPS, development activities include real-time applications, services and management components. Also, Knowledge and experience of designing and developing experience in T-SQL and SSRS Reports. Hands on experience with Microsoft Visual Studio, SQL Stored procedures and SSIS are integral to the job. Responsibilities also include participation in requirements analysis, technical designs, coding, unit testing, product test support, and deployment support.
Experienced in designing, developing and maintaining the SQL Server database for MIRR.
Developed the 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 the SSIS packages through both process, Catalog database 2012 based and file based configuration at MSDB (SSIS Server).
Optimized the SSIS Packages and developed T-SQL deployment script for Catalog database based SSIS Packages.
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
Hazel Tree, New York _ 01/2013 - 06/2013
SQL Server, SSRS / ETL Developer
At Hazel Tree, worked on projects for various new and existing clients to provide new reports and data Feed Definitions, maintained the existing Feed Definitions and reports in MS SQL Server, SSRS and ETL.
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 the 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.
MS SQL Server 2008 R2, SSRS 2008 R2, SSIS 2008 R2, Surround SCM, Windows 7, Microsoft Office 2007, C#, .Net .
Investors Bank, Short Hills, NJ 12/2011 – 11/2012
SQL Server / SSRS Developer
Responsible at Investors Bank for designing, developing, maintaining MS/SQL based data warehouse reporting solution. Work with business lines to define requirements for new BI reporting initiatives; Assist MIS Manager in the development of specialized reports and trend analysis.
Developed many reports for remittance and inquiry reports for CDS, Checking, Saving and Loan business requirement by region and branch for internal clients.
Developed and scheduled a SSIS Package to programmatically extract the DB2 Data Warehouse to SQL Server database to support the MIS team’s reporting requirement.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.
MS SQL Server 2005/2008 R2, SSRS 2008 R2, SSIS 2008 R2, Windows NT/2003, Microsoft Office 2007, C#, Dot Net.
Pfizer, Madison, NJ 05/2011 – 11/2011
SQL Server Developer / ETL Analyst
At Pfizer, the project is to document all business rules defined in the Pfizer Animal Health (PAH) US Common Data Repository (CDR) as well as to recommend a high level strategy and end-state architecture of CDR in conjunction with the development of the new Data Warehouse (DW) solution. The role is to analyze and document the transformations and business rules, evelop many SSIS packages for SQL Server Data Warehouse maintenance,
Recommend a strategy and high level end-state architecture for re-architecting existing CDR inbound and outbound interfaces suitably (in conjunction with CORe).
Modify and develop SSIS packages for inbound and outbound files on daily basis to the target table and to log the details of the load as and when load the file into the Data Warehouse.
Analyze the WebSphere Data Stage Transformation packages that provide the source data (AS/ 400, Oracle and Siebel) to the CDR and document it accordingly.
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.
iNetu, Allentown, PA 05/2010 – 04/2011
MS SQL Server Developer/BI Developer
INetu is a Managed Hosting technology corporation. The project is to develop, maintain and provide the better solution for the SQL Server database migrated from My SQL database for a dot net intranet web application of order and payment department. The role is to assist development team by providing them required solutions and develop many SSIS packages for SQL Server database maintenance.
Worked on historical records maintenance of the SQL Server database for auditing.
Extensively working experience in developing, modifying and performance tuning of the new and existing triggers, stored procedures, indexes and constraints with better solution to be used in dot net application.
Installed, configured and tested the MDS (SQL Server 2008 R2 Master Data Services) to have efficient functionality available in T-SQL development.
Developed SSIS packages to load the flat file on daily basis to the target table and to log the details of the load as and when load the file into the database.
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.
PRUDENTIAL FINANCIAL, Woodbridge, NJ
System Analysis & Development Analyst (03/2000 – 06/2009)
Member of the Annuities Technology department with responsibility to include analyze requirements and code for minor modifications in Progress 4gl to the VPAS System. Completed several projects for system maintenance, system release, addresses most of the data fixing issues, queries and ad hoc reports as soon as they are received.
Run query on timely basis and generates ad hoc reports in Progress 4gl v10 on for the operation according to the issues created by liaison group.
Test and run periodically global price correction module in progress 4gl to correct the price of provided funds.
Software Environment: Progress 9.1b / 10.0b, Open Edge, UNIX, Lotus Notes 5.0, MS Office, Visio 3.0, MS SQL Server 2005.