SUMMARY

• 8 years of experience in all phases of the Software Development Life Cycle, driving design, implementation, Development, testing, integration, and maintenance of scalable, high - performance software applications and systems.
• 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, SQL joins, performance tuning and query optimization.
• Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server 2014/2012/2008 - R 2/2008/2005.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Teradata, Sybase, Flat File and MS Access.
• Extensively worked on SSIS, Data Cleansing, Data Scrubbing and Data Migration.
• Expertise in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
• Experience in creating jobs, alerts, SQL mail agent, database mail, and scheduled in SSIS packages.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drilldown reports using MS SQL Server Reporting Services 2014/2012/2008 R 2/2008/2005.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• In depth knowledge in designing new reports, enhancing existing reports, and wrote ad hoc reports for client using Crystal Reports. Manipulated and created new data sets using SQL, MS Access, Excel, and/or Crystal Reports. Expert in generating Sub Report, Standard, Cross Tab Reports and Graph Reports by Using Chart expert of Crystal Report.
• Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake schema using Erwin Tool.
• Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Forward engineering, Reverse engineering and model to model comparison.
• Expertise in designing and developing MS SQL Server Analysis Services 2014/2012/2008 R2/2008/2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Strong working experience in implementing Key Performance Indicator (KPI) Objects in SSASAnd create calculate member in MO LAP cube using MDX in SSAS 2014/2012/2008 - R 2/2008/2005.
• Excellent communication and interpersonal skills with ability to develop creative solutions for challenging client needs using AGILE methodologies.
• Intensive experience as a scrum master to lead and guide all the team members in all the meetings proposed by agile like pre planning meeting, planning, daily scrum, review and retrospective meetings.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

• Microsoft SQL Server 2014/2012/2008 - R2/2008/2005
• MS SQL Server Integration Services (SSIS)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• T-SQL
• PL-SQL
• Erwin Data Modeler v7.0/v4.x
• Microsoft Visual Studio 2010/2008/2005
• MS SharePoint
• TFS
• Rational Rose
• Crystal Reports
• Presentation Point Server (PPS)
• Microsoft Access
• Microsoft Office(MS Word/Excel/Power Point)
• MS Project
• MS Dynamics
• Oracle People Soft
• Java
• C++
• C#
• Visual Basic 6.0
• Microsoft Visio
• Windows 2008/2003/2000 Advanced Server
• Windows 10/8/7/XP.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Designed and developed Data Models using ERWIN and also responsible for Forward and Reverse Engineering of data models.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into 4 Weeks "sprints."
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views, Index.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Worked on performance tuning of T-SQL scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent.
• Formulated and documented the ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source to target mappings, transformations, look ups, aggregations, and expressions.
• Extracted data using SSIS 2014 from Oracle and Excel Files.
• Created packages in SSIS 2014 (.dtsx files) with error handling as well as created complex SSIS packages using various Data Transformations like Conditional Splitting, Fuzzy Look Up, For Each Loop, Multi Cast, Column Conversion, Fuzzy Grouping, Script Components.
• Responsible for implementation of Data Viewers, SSIS Logging, Error Configurations for error handling the packages.
• Deployed and configured various SSIS packages.
• Based on required reports, identified various data sources and established the connections using SSRS and constructed data source view.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as Interactive reports according to business requirements in time restricted environment using SQL server reporting services(SSRS) 2014.
• Designed and developed report with running value, interactive sorting as well as conditional formatting. Experience with creating reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.

Confidential, Edison, NJ

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked in T-SQL to create Tables, Function and Stored Procedures, View, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement
• Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor
• Created Cluster and Non Cluster Index to optimize performance of TSQL queries
• Key tasks include design of tables, stored procedures, conversion of stored procedures into ETL code, database schema and ERD logical model change management, develop, test and implement complex SQL statements, stored procedures, triggers, and functions in SQL Server 2008 R2
• Created SSIS packages to transfer data between Staging database and DW
• Worked with the ETL architect and lead to ensure ETL developers have the required data schema and metadata information and participate in knowledge transfer with the goal to remove any knowledge gaps that might exist.
• Assist with source data analysis and profiling and in the development of the source to target mapping documents.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Fuzzy Grouping, Derived Columns, Conditional Split; Term extraction, Aggregate, Execute SQL Task, Data Flow Task
• CreatedSSISpackages to import data from MS Access, Excel to SQL 2008 R2
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008R2
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Performed Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Confidential, Detroit, MI

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in extracting the data from OLTP to Data warehouse using SSIS.
• Developed and deployed various SSIS packages.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS 2008 and then created reports using SSRS 2008.
• Tested and managed the SSIS 2008 packages and was responsible for its security.
• Identified the data source and defined them to build the data source views.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2008.
• Responsible for stylish Report Layouts and Deployed the Reports using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Wrote Complex Stored Procedures, Triggers, Views and Queries.
• Wrote standard and complex t-SQL queries to perform data validation and graph validation to make sure test results matched back to expected result base on business requirements.
• Used execution plan, SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created various DB objects like indexes, Constraints, views etc.

Confidential, NYC, NY

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Analyzed existing logicaldatamodel (LDM) and made appropriate changes to make it compatible with business requirements.
• Worked on identifying facts, dimensions and various other concepts of dimensionalmodeling, which are used for datawarehousing projects.
• Optimized cubes for better query performance.
• Aggregated cube with 30% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Drop down menu option, Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Used Database engine tuning advisor, SQL Profiler for Performance Tuning.

Confidential

MS SQL Server SSIS Developer

Responsibilities:

• Planned, Defined, and Designed database based on business requirement and provided documentation.
• Gathered data and documenting it for further .
• Designed DB using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Lookup Values & implementing rules provided by Business in the mapping document.
• Created SSIS packages using Fuzzy Lookup 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.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2005
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for Monitoring and Performance Tuning of Reports.
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.