We provide IT Staff Augmentation Services!

Ssis Developer And Sql Server Developer Resume

4.00/5 (Submit Your Rating)

Montvale, NJ

SUMMARY

  • Extensive experience in ETL, reports, database design, development and administration wif 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 wif 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 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.
  • Designed, developed and maintained the databases, tables and stored procedures in SQL Server 2008R2.
  • Developed the automated ETL process in SSIS packages for multiple databases to handle the current Fiscal year data.
  • Developed the connector scripts in xml and mapped dis 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.
  • Perform Unit testing for Reconciliation and participated in QA testing for the assigned projects.
  • Developed scripts in Power Shell to automate the SSIS package Execution process and other related tasks.
  • Participated in Production Deployment and UAT testing.
  • Developed, tested and implemented the table definition scripts to add the new and to maintain the existing tables in the SQL Server database for production deployment.
  • Developed, tested and implemented the Bulk Insert SQL Server script to load the data to the SQL Server database from .csv file during production deployment.
  • Installed and configured the Team Foundation Server
  • Developed the new and maintained the 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 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 SQL deployment script for Catalog database based SSIS Packages.
  • Developed SQL Agent Job script for the SSIS Packages.
  • Worked on database partitioning, Indexes, performance tuning and query optimization.
  • Participated in Unit and Integration testing of the database and SSIS Packages.
  • Synchronized the TFS Source control wif the development database.
  • Documented all the 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 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.
  • Developed many new stored procedures and modified the 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 wif 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 the training and demo to the team in SSRS (Report Builder 3.0) and MS OLAP cubes.
  • Configured and setup the OLAP cubes in Reportive Studio 9.0/9.2 to deploy on SQL Server 2008 R2 as SSAS OLAP cubes.
  • Configured the multiple nodes of Report Server for development, QA and Production environments.
  • Maintained the ETL scripts of Reportive Studio 9.0/9.2.
  • Converted the 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 the DB2 Data Warehouse to SQL Server database to support the MIS team’s reporting requirement.
  • Wrote T-SQL queries, Store Procedures and used them to build packages.
  • Worked wif stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats (PDF, Excel) and resolved formatting issues.
  • Optimized the performance of queries wif 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 have been defined in CORe and other TEMPthan those dat have 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 wif CORe).
  • Experience in developing, modifying and performance tuning of the 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 the target table and to log the details of the load as and when load the file into the 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 the WebSphere Data Stage Transformation packages dat provide the source data (AS/ 400, Oracle and Siebel) to the CDR and document it accordingly.
  • Continuous coordination and collaboration wif 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 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 wif 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 the development team.
  • 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.
  • Coordinated wif 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 the modules for VPAS system.
  • 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.
  • For AMPLIFI modified program in Progress 4gl v8 to support an interface control file dat meets Company interface standards. dis control file is valued wif the count of the number of records sent.
  • CMF Code modification was done in Progress 4gl v8 for conversion by changing and adding the criteria to get the required value from VPAS System during the System release. Modified module calls other module to get the calculated value.

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

We'd love your feedback!