SUMMARY:

• Over 8 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2016/2014/2012/2008 R2. Experience in various industries includes Financial, Healthcare and Insurance.
• Experience in SQL Server and SSIS (Integration Services) package design, development, and deployment using SQL 2016 advanced features in Control flow, data flow, Error Handling and event handling.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services and SQL Server Integration Services (SSIS) ( 2016/2012/2008 R2/2008/).
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Real time Experience in Modifying SSIS Package & Create SSIS Package by using different sources like XML, Web - service.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Strong experience in Stored Procedure, User Defined Function, T-SQL 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.
• Responsible for writing parameterized queries for generating tabular report, Sub reports, using global variables expressions and functions, sorting the data, defining the data, defining the data sources and subtotal for the reports using SSRS 2016/2012/2008 R2.
• Strong knowledge in Performance Point Server 2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports.
• Extensive experience in SSRS (Reporting services) and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP and Sub reports, and formatting them.
• Migration of SSRS reports from SQL 2012 to SQL 2016.
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, and Star schema for OLTP/OLAP systems.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS:

Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SharePoint, SQL Server Data Tools for Visual Studio 2016//2012/2010/2008, Erwin 8/7.2 Data Modeler, MS Visio, CrystalReports7/8/8.5,BusinessObjects, JIRA Microsoft office 2010/2012

Database: MS SQLServer 2016/2014/2012/2008 R2/2005, SQL CMD, Microsoft Office 2012/2010/2007, MS-Access. MS Excel, Oracle8i/9i

Operating System: Windows 7/XP/2008/2005, Windows server 2008/2003

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

SQL Server /SSIS/SSRS Developer

RESPONSIBILITIES:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created AD HOC reports with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Interacting with onsite people, Taking clarifications regarding applications and Formulating SQL queries and stored procedures on assigned modules.
• Responsible for estimations of the new requirements or enhancements in existing projects.
• Responsible for requirement gathering and creating requirement and technical document.
• Wrote stored Procedures, Functions and Triggers as per the requirements.
• Designed and implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2014 and wrote the SQL queries, Stored Procedures and views.
• Built data connection to the database using MS SQL Server and Have worked with Database testing and SQL queries.

ENVIRONMENT: Visual Studio 2012/2016, Microsoft SQL Server 2012/2016, SSIS 2012/2016, SSRS 2012/2016, JIRA, DB2, Team foundation server, SQL Developer, MS SQL Profiler, SQL Server Database Engine Tuning Wizard, Maestro Scheduler, Windows Server 2016, MS Office, MS Access, MS Visio.

SQL Server /SSIS/SSRS Developer

RESPONSIBILITIES:

• Requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, oracle, SQL Server 2008 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2008 to SQL Server 2012.

Tools: & Technologies: SQL Server 2012 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS) SSDT for visual studio 2010, TSQL, C# .Net framework, XML, MS Visual Source Safe and Windows Server 2014, Crystal Reports

SQL Server /SSIS/SSRS Developer

RESPONSIBILITIES:

• Gathering Requirements from Client and understand current Database and system environment and then integrate it with business logic and made documentation on it.
• Based on documentation generated different data model for the Data Warehouse and worked on Data mapping/Data profiling & create hierarchy as per business requirements.
• Start working on specification and transformation meanwhile start working to create new structure of DW and other objects like ETL Store Procedure,
• Required Sys tables, lookup tables and also link server to fetch data from different servers.
• Hand on experience to create complex store procedure and ETL SSIS Packages to load records into DW tables, also need to maintain referential integrity between DW tables.
• Generated SSIS Package for ETL Process and develop source to Client data mappings using SSIS various tasks such as Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
• Created Views and Synonym to reduce complexity of end user.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Cluster and Non-Cluster Index to optimize performance of TSQL queries.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2
• Migration of SSRS reports from SQL 2008R2 to SQL 2012.
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and parameterized reports using SSRS.

ENVIRONMENT: MS SQL Server 2012, T-SQL, SSIS 2012, SSRS 2012, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, BIDS, Erwin v7.1, Windows XP, MS Office 2010, MS Access

SQL Server /SSIS/SSRS Developer

RESPONSIBILITIES:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Used the SSIS script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times (using For each Loop )
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star schema.
• Designed relationships between the dimensions and measures. Resolved complex many to many relationships and referenced relationships between the dimensions and the measures.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Setup Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server 2008 Partition functions and schemes.
• Involved in Unit testing integrated testing and System testing.

ENVIRONMENT: Microsoft SQL Server 2008R2 T-SQL, SQL SSIS, SSRS, Windows server 2005, BIDS, Visual Source Safe, Visual Studio 2008, Erwin v7.2.

Junior SQL Server Developer

RESPONSIBILITIES:

• Worked with non-technical colleagues and provide them SQL 2008 queries and store procedures to make their task easy and less time consuming.
• Created complex SQL join queries, views, and store procedures.
• Write Stored Procedures, ad hoc queries, join operations, dynamic SQL to extract the data in smoother and quicker manner out of Database.
• Used SSIS to process the text file data into Database and clean up the file system folders for next day's processing.
• Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance
• Worked on data cleansing techniques using look-ups, conditional split, and fuzzy lookup.

ENVIRONMENT: MS SQL Server 2008, SSIS 2008, SSRS 2008, MS Office 2008, MS Access, MS Excel.