SUMMARY:

• Over 8 years of experience in IT industry as a SQL Server Developer with specialized skills in SSIS, SSAS and SSRS.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008) & features.
• Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de normalized reporting systems (OLAP) as well as staging areas and data marts.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and Normalizations.
• Extensively worked in OLTP and OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Experience in writing R scripts to develop graphical reports.
• Hands on experience in using various R packages.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Ability to work on multiple tasks in a fast paced environment independently and in a team, mentor to other team members to c follows same techniques and standards.
• Excellent analytical/Communication Skills, Team Play and very much result Oriented.

TECHNICAL SKILLS:

Operating systems: Windows 98/NT/2000/XP/Vista/Windows7/8

Databases: MS SQL Server 2000/2005/2008, MS Access

Database Tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools: DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools: SSRS, R studio, Crystal Reports, Congo's, Micro Strategy

Development Skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.Net, Asp.Net(C#)

Application Packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, New York City

SQL/ETL/SSIS/SSRS Developer

Responsibilities:

• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),R Studio, OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007.

Confidential, New York City

SQL/ETL/SSIS/SSRS Developer

Responsibilities:

• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s.
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors.
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Implemented free text parser for FTP and web data feed in C# .Net
• Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Involved in migration and conversion of Reports from SSRS 2005 to 2008.
• Designed some graphical reports using R studio for the Business Users.
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),R Studio, OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007.

Confidential, Dallas, Texas

SQL/SSAS/SSIS/SSRS Developer

Responsibilities:

• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Enforced business rules with checks and constraints
• Involved in code review and code review meetings
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints
• Involved in migration and conversion of Reports from SSRS 2005 to 2008
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Created cubes, dimensions, measures and calculated measures according to the requirements
• Deployed and processed Cubes on a weekly basis to update information using SQL Server Agent
• Built MDX Queries using SQL Server Analysis Server (SSAS) 2008/2005

Confidential, New York City

SQL/SSAS/SSIS/SSRS Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Involved in the data analysis and database modeling of both OLTP and OLAP environment.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
• Created Tabular reports, Matrix reports, List & 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.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008, BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, Infomatic, HealthCare database, Oracle 9i, DB2, TFS.