SUMMARY

• 5+ Years of IT experience which includes Data Analysis, Design, Development & Support of MS SQL Server 2008, 2005 and 2000 in Warehouse, Production, QA and Development Environments.
• Involved in the design of Logical and Physical design models of various relational databases using Erwin Data Modeling tool and also forward/reverse engineered data models with the implementation of Normalization.
• Involved in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views and Cursors to support the existing applications.
• Wrote Complex Stored Procedures and Triggers for use in Auditing, ETL and for Reporting.
• Involved in Performance Tuning using SQL Profiler and Database Tuning Advisor (DTA) and Indexes.
• Implemented the Extraction, Transforming and Loading (ETL) strategy by creating packages using SSIS to extract data from DB2, SQL Server, Excel file, other databases and Flat File sources.
• Handled errors in SSIS Packages using Event-handlers, Loggings, Transactions and Checkpoints.
• Designed and Developed Data Warehouses using Star Schema, Snow Flake Schema depending upon business needs.
• Involved in creating SSAS cubes and objects like Key Performance Indicators (KPIs), Translations, Perspectives
• Implemented Cube Optimization Techniques such as Cube Partitioning, Aggregation Wizard, Defining Hierarchies with the cube structures.
• Involved in creating Drill down Reports, drill through, Sub-Reports, parameterized reports and cascaded parameterized reports using SSRS 2005/2008 as well as Ad-hoc reports
• Implemented proper report optimization using optimized query and proper Caching and Snapshots in report server.
• Involved in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

SOFTWARE SKILLS
Data Modeling Tools: Erwin
Database and related tools: MS SQL Server 2000/2005/2008
BI & Reporting Tools: SQL 2005/2008 Integration Services, Analysis Services, Reporting Services
Programming: T-SQL
Operating Systems: Microsoft Vista/XP/7, 2003/2008 server

PROFESSIONAL EXPERIENCE

Confidential, Fairfield, OH June’11 – Till Date

SQL Server Data Warehouse Developer

The major scope of the project was to create a Data Mart to allow the management to make critical business decisions. Reports and cubes were also created as part of the project for business analysis.

Responsibilities:

• Involved in the creation of Data Mart by taking into various business process by identifying different dimensions and facts.
• Created database objects like Stored Procedures, UDFs, Triggers, Indexes and Views using TSQL in both OLTP and Relational data warehouse in support of ETL.
• Optimized the performance of various T-SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Developed complex ETL Packages using SQL Server 2008 Integration Services to load data from various sources like Oracle/SQL Server/DB2 to Staging Database and then to Data Warehouse.
• Implemented master child packages so only the Master package has to be scheduled which will in turn fire the other packages.
• Managed package configuration to efficiently deploy ETL packages from development environment to Production environment.
• Created drill down and drill through reports, cascaded reports, sub-reports, and parameterized reports in SSRS
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Created report models from cubes as well as relational data warehouse to create ad-hoc reports and chart reports.
• Designed reports to include charts and logos that complies with the organizations culture and polices of reporting and documentation.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.

Confidential, Dayton, OH Sept’10 – May’11

BI Developer

The project involved design and development of an ETL framework to extract, transform and load the data warehouse to provide the business with analytics data.

Responsibilities:

• Used Erwin tool for dimensional modeling (Star schema) of the staging database as well as the relational data warehouse.
• Created stored procedure for auditing purposes as well as triggers for consistency checks and used CTEs for code management in complex stored procedures.
• Created indexed views, UDFs and stored procedures to be accessed by front end applications.
• Used SSIS to extract, transform and load data from multiple input sources and loading into SQL Server.
• Was responsible for detecting errors in ETL Operation and rectify them using event handlers and debugging techniques.
• Worked on SSIS creating all the interfaces between front end application and SQL Server database, then from legacy database to SQL Server Database and vice versa.
• Used control flow tasks and container as well as Transformations in a complex design to build an algorithm to cleanse and consolidate data.
• Extensively used fuzzy lookup, fuzzy grouping as well as the slowly changing dimension wizard as well as custom T-SQL code to extend ETL packages.
• Partitioned several cubes used as sources for optimization of the reports that needs to be created.
• Scheduled the deployment of cubes and was involved in extending them by creating new measure groups, and creating KPIs.
• Extracted data from SQL Server into Excel spreadsheets and developed pivot tables for analysis.
• Created new procedures and modified existing code, tables, views, and scripts to meet changed system requirements.
• Optimized SQL queries using indexes and execution plans for maximum efficiency and performance.
• Developed reports that would produce Excel output for users.
• Worked closely with the Administrator for proper backup and recovery plans.
• Created Reports using SQL Server Reporting Services to report trends from existing Warehouse.
• Extended reports as well as invoked embedded functions and integrated assemblies using expressions.
• Involved in troubleshooting and debugging of ETL, SQL stored procedures and reports.

Confidential, Independence, OH Jan’10 – Aug’10

SQL Developer

The Project involved creating a new Data warehouse in SQL Server and to create an ETL process using SSIS packages in SQL 2008 and also develop SSRS reports from the warehouse. 
Responsibilities:

• Created, modified and redesigned OLTP and DW Data Models and Forward Engineered Data Model of Staging Database to SQL Server using Erwin.
• Created Stored Procedures for Reporting on Audit Information and Error Information during each ETL Process.
• Used SSIS Packages to extract, transform and load data from multiple input sources like flat files, SQL Server 2000 into SQL Server 2005 Staging Database.
• Implemented various types of Transformations in Packages including Slowly Changing Dimension, Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
• Implemented the Master – Child Package environment to minimize overhead of Package Schedule Maintenance.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Designed the ETL processes using SSIS to load data from Oracle, SQL Server, Flat Files and Excel files to target SQL Server staging database.
• Created Dimension and Fact Tables for the Staging Database following the Kimball Methodologies.
• Performed data transformations using complex stored procedures and queries and embedded them into SSIS Packages.
• Used SQL Server Agent to schedule jobs, maintenance tasks, and BCP and ETL packages.
• Used Job Monitor to monitor the execution of the Jobs as well as notification services to alert the team on success, completion and failure of a job.
• Maintained existing SSIS Packages and worked on the performance tuning of the queries, ETL Procedures and processes.
• Deployed packages from testing to production environment using Package Configurations in SSIS
• Created various types of Reports like linked report, parameterized report and sub-report from SQL Server Reporting Services.

Confidential, Sep’07 – Dec’09

Software Engineer/SQL Developer

Responsibilities:

• Involved in Database designing (physical and logical) to meet new enhancements using ERWIN.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Designed and facilitated the implementation of data warehouses required by application systems.
• Promoted database objects and packages from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for Oracle extractions into SQL Server dimensional model.
• Created SSIS Packages to Extract, Transform & Load data from Production DB to Staging DB and import data from MS Access, MS Excel and Text Files.

EDUCATION
Bachelor in Computer Science