SUMMARY

• Over SEVEN years of experience in analyzing, designing, tuning and developing client/server, Business Intelligence (BI) database application, using MS SQL Server 2012/2008R2/2008/2005 DTS/SQL Server Integration, Reporting and Analysis Services (SSIS, SSRS, SSAS).
• Extensive SQL Development experience inhealthcare, logistics, retail,energy industries and insurance department with a strong understanding of data & analytics.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, and triggers usingSQL Servers.
• Experienced in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Expert in creating indexes, user defined functions, and common table expressions (CTEs) to facilitate efficient data manipulation and data consistency.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experienced in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, 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.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Experienced in using global variables, expressions and functions for the reports.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server 2008 to 2008 R2 and 2008R2 to 2012.
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• MS-Access 2007/2003
• Oralce 10g/11g
• MySQL
• C
• C#
• SQL
• T-SQL
• HTML
• .Net
• ASP.Net
• VB.Net
• XML
• MS Visual Studio 2008/2005
• SSRS
• SSIS
• SSAS
• DTS
• SQL Profiler
• DTA
• Management Studio
• MS Visual Source Safe (VSS)
• Erwin (data modeling)
• MS Visio 2008/2005/2003

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

MS SQL Server Developer/ETL Developer

Responsibilities:

• Worked closely with the Project Leads to understand and analyze the requirement.
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, Triggers, Emails, Jobs etc. according to the Requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Implemented SQL queries and stored procedures and validated code against designs.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Migrated SSIS packages from 2008 to 2012.
• Responsible for creating, deploying and scheduling new SSIS packages.
• Configured the Properties in the Reports Project so that the Reports could be deployed from Visual Studio.
• Involved in testing and updating VB application.

Environment: MS SQL Server 2012, SSIS, SSRS, Visual Studio 2010, MS Office 2007/2003, MS Excel

Confidential, Berkeley Heights, NJ

MS SQL Server Developer/ETL Developer

Responsibilities:

• Responsible for create data marts to support Cognos report and migration data from old model to new model.
• Modified existing mappings for enhancements of new business requirements.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created table, join, view, case when and functions for different proposes.
• Created various Stored Procedures to validate the data from Source and update the records and insert them into a newly created table.
• Create SSIS packages for migrating data, importing data from excel and flat files.
• Execute and maintain exited packages as business user required.
• Involved in Cognos report testing and solving errors.
• Constantly interacted with business users to discuss requirements.

Environment: MS SQL Server 2005, SSIS, Visual Studio 2005, Cognos, MS Office 2007/2003, MS Excel

Confidential, Somerset, NJ

MS SQL Server Developer/BI/ETL Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, SSIS packages, SSRS reports.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables and worked with database objects like Tables, views and indexes.
• Used stored procedures, wrote new stored procedures and triggers and modified existing ones.
• Planned and Designed SSIS packages based on the business requirements.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Used various SSIS tasks such as Conditional Split, Merge Join, Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Performed error handling using Script Task and event handlers.
• Created sub-reports, drill down reports, summary reports, and parameterized reports using SSRS.
• Designed and implemented reports with different layouts usingSSRSand exported them into Excel, PDF and HTML.
• Have done Technical, Revision and Unit Test documentation of the package and reports.
• Created and Configured OLAP Cubes (Star Schema and Snow flake Schema) using SSAS.
• Evaluate business performance with key performance indicators (KPI) using SQL Server Analysis Services

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, SSAS, SQL Profiler, SharePoint, VSS, .Net, C#, Windows XP, Microsoft Word 2010

Confidential, Wayne, NJ

MS SQL / SSRS / SSIS / SSAS Developer

Responsibilities:

• Created SSIS package to load data from Flat File, CSV File, and Oralce to Data warehouse and Report-Data mart and applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Pivot Transformation, and Merge Joins in SSIS.
• Export and Import data from SQL Server to Access, Text and Excel files using SSIS and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Designed, developed, created and tested Excel Pivot Table / Power Pivot reports based on OLAP cubes and offline cube files for business analysts.
• Provided documentation about database /data warehouse structures and updated functional specification and technical design documents for cubes, reports and SSIS Packages.
• Formatted the reports using the Global variables and expressions.
• Developed cubes for reporting purpose
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
• Involved in project life cycle (SDLC).

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), VSS, PowerPivot, T- SQL, Erwin 8.0/MS Visio 2010, MS Excel 2007/2003

Confidential, Lisle, IL

MS SQL Server/BI/ETL Developer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
• Created SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Configured and Maintained Report Manager and Report Server for SSRS.
• Created reports to retrieve data using Stored Procedures that accepts parameters depending upon the client requirements.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Involved in Debugging and Deploying reports on the production server.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes.
• Preformed ad hoc reports.
• Fixed issues in the existing Crystal Reports.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Responsible for the Performance tuning and optimization with the use of the Query Analyzer and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, Business Intelligence Studio, DTS, TSQL, SQL Profiler, SQL Query Analyzer, Windows XP/ NT / 2000/2003SQL

Confidential, Dallas, TX

MS SQL Server Developer/ BI Developer

Responsibilities:

• Worked with Business Analyst and Business Users in requirements gathering phase actively cataloging and supporting various issues and providing their solution.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in performing incremental loads while transferring the data OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Used various transformations depended on business requirements, like the slowly changing Transformation to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS.
• Created different Parameterized Reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Subscription of reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly and monthly basis.
• Deployed and configured the reports in the Report Server.
• Created OLAP Cubes for various measure groups and dimensions for analysis of Per Member/Per Month cost to meet the business answers for the client needs using SSAS
• Designing and implementing dimensional data structure like star and snowflake schemas and virtual fact tables and constructing the dimensional hierarchies, calculated members and measures, actions and MDX using SSAS based on the OLAP reporting needs.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio2008, Star Team Version Control tool, T- SQL, Erwin 8.0/MS Visio2008, MS Excel 2007/2003