SUMMARY

• 8 years of IT experience as MS SQL Server Developer 2016/2014/2012/2008 R2/2008 in various Industry verticals like Financial Services, Health Insurance, IT, Healthcare and Bank.
• Strong understanding of financial valuation concepts and various capitalmarketinstruments and processes includingEquities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back - Office operations.Strong experience in Stored Procedure, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
• Involved in developing stored procedures, triggers for the application.
• Expertise in Creating, Configuring and Fine-tuning ETL workflows designed using SSIS of MS SQL Server 2016/2014/2012/2008 R2/2008.
• Extensive Knowledge in creating complex SSIS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
• Proficient in creating sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2016/2014/2012/2008 R2/2008 (SSRS).
• Highly skilled in writing Parameterized Queries for generating parameterized reports and Sub reports using global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2016/2014/2012/2008 R2/2008.
• Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

• MS SQL Server 2016/2014/2012/2008 R2/2008
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access
• C#
• Team Foundation Server
• ASP.NET
• 2007/2010/2013
• Business Object 3.1
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• COBOL
• JCL
• CICS
• Easytrieve+
• TSO
• Database Engine Tuning Advisor
• Toad
• Designer 16.0, 16.5
• Vb.net
• Erwin Data Modeler 9/8/7
• Excel VBA
• Crystal Reports 8.5
• T-SQL
• MS Visio 2007/2010/13/2016
• Windows 2003/2008 Advanced Server/Professional
• Windows NT 2012/2008/2003 Server/Workstation

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Sr. SQL Server/SSIS/ETL Developer

Responsibilities:

• Planned, defined and designed data based on business requirement and provided documentation.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes.
• Adapted Excel spreadsheets into Access Database applications for League Table ranking, Derivatives, Convertibles and Alternative CapitalMarkets(improved reporting efficiency 500%)
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy lookup and Exact lookups and String manipulations.
• Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
• Responsible for creating the reports based on the requirements using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Created different type of reports which include: Chart report, Sub report, Drill-down report, Drill-through report and Parameterized report and deployed and scheduled them in Report Manager to generate all daily, weekly, monthly and quarterly Reports.
• Performance tuning of existing stored procedures and T-SQL Queries to improve the runtime of existing reports.
• Delivered different format of reports to end users by using the report manager to implement subscription like standard subscription and data driven subscription.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Modified the existing SSIS packages to meet the changes specified by the users.

Tools: & Technologies: MS SQL Server 2016/2014, T-SQL, SSIS, SSRS, TFS, ODBC, Microsoft Excel

Confidential, New York, NY

Sr. SQL Server/SSIS/ETL Developer

Responsibilities:

• Planned, defined and designed data based on business requirement and provided documentation.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes.
• Adapted Excel spreadsheets into Access Database applications for League Table ranking, Derivatives, Convertibles and Alternative CapitalMarkets(improved reporting efficiency 500%)
• Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and used Custom components such as Audit on Pre-Execute, Audit on Post-Execute and Statistics Logging Component.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy lookup and Exact lookups and String manipulations.
• Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
• Responsible for creating the reports based on the requirements using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Created different type of reports which include: Chart report, Sub report, Drill-down report, Drill-through report and Parameterized report and deployed and scheduled them in Report Manager to generate all daily, weekly, monthly and quarterly Reports.
• Performance tuning of existing stored procedures and T-SQL Queries to improve the runtime of existing reports.
• Delivered different format of reports to end users by using the report manager to implement subscription like standard subscription and data driven subscription.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Modified the existing SSIS packages to meet the changes specified by the users.

Tools: & Technologies: MS SQL Server 2016/2014, T-SQL, SSIS, SSRS, Business Object 4.0, Oracle 11g, ODBC, Microsoft Excel

Confidential, NY, New York

MS SQL Server Developer/SSIS/SSRS Developer/Data modeler

Responsibilities:

• Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or an Excel pivot table.
• Worked on SQL Profiler to view indexes performance to mostly eliminate table scan.
• Performed operations such as Fine-tuning highly complex TSQL stored procedures for maximum efficiency and performance.
• Online banking data conversion. Collection of data from a mainframe data source (COBOLand easytrieve). Upload retrieved data files into MS Excel spreadsheets.
• Transfer data into SQL SERVER database tables using T-SQL Stored Procedures and ETL.
• Produced operational reports in SSRS 2014 i.e. drill-down, drill-through, chart reports, parameterized reports, snapshot reports.
• Provided design, implementation and maintenance for custom reports using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Worked with project manager and technical leads for resolution of technical issues.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Slowly Changing Dimension and row count etc.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Kept track of changes using Team Foundation Server (TFS).

Tools: & Technologies:MS SQL Server 2014, T-SQL, SSIS, SSRS, SSAS, Erwin 9.6, Microsoft Access, Oracle 10g

Confidential, New York, NY

Senior MS SQL Server/SSIS/SSRS Developer/ Data Modeler

Responsibilities:

• Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2014/2012 to store data and to maintain database efficiently.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS 2014/2012, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Deploying, Testing and Scheduling SSIS packages using SQL Agent.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
• Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.
• Worked with production control team to deploy code and for schedule run in both staging while testing and production.
• Responsible for providing 24/7 on-call production support for daily job and ETL loads.
• As in development team, worked with DBA teams for database update and system restarts.

Tools: & Technologies: MS SQL Server 2014/2012, T-SQL, SSIS, SSRS, Win 2013 Advanced Server, Erwin r9.5 and ASP.Net

Confidential, New York, NY

SQL developer/MSBI Developer/Data Modeler/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Designed Database using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicast, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Trained on building Conceptual, Logical and Physicaldatamodel.
• Created the conceptual model for thedatawarehouse with emphasis on insurance (life and health).
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Reviewed the conceptual EDW (EnterpriseDataWarehouse)datamodel with business users
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2012.
• Generated parameterized reports, sub reports, tabular reports, Drill down reports, Drill through reports using SSRS-2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.

Tools: & Technologies: MS SQL Server 2012, SSRS, T-SQL, SSIS, Win 2012 Advanced Server.

Confidential, New York, NY

Jr. MS SQL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
• Designed and modeled Microsoft SQL Server 2008 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Configured file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Perform T-SQL tuning and optimizing queries for Reports, which take longer time in execution SQL Server 2008.
• Migrated some Crystal reports to SSRS reports manually
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Tools: & Technologies: SSIS, MS SQL Server 2008