SUMMARY

• Over 7 years of total IT experience in ETL Development, Enhancement, Maintenance, Production support, Data Modeling, ReportingincludingBusiness requirement, system requirement gatheringof Enterprise Data warehouses for payroll, insurance domains.
• Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects. Capable of handling responsibilities independently as well as a proactive team member.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTEs, Views and Cursors.
• Expert in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and developing BI solutions using BI suite (DTS/SSIS, SSAS, SSRS)
• Excellent skills in High Level Design and implementing ETL packages using SSIS 2005/2008/2012 for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, XML, Oracle, flat file, Text file) by using multiple transformations available in SSIS toolbox such as Script task, Slowly Changing Dimensions, Data Conversion, Conditional Split, Bulk Insert, Merge, Fuzzy Lookup, Multicast, Lookup and Union all.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expertise in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Possesses excellent skills in Data Modeling using Star and Snowflake Schema's.
• Expert in creating SSAS 2005/2008/2012 cubes, MDX queries, working with facts, dimensions, hierarchies, Perspectives and various storage settings (ROLAP/MOLAP)
• Strong experience in defining Referenced relationships in SSAS.
• Developed/deployed and supported complex SSIS Packages for Data Migration and Transferring Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• High Level understanding of Teradata environments.
• Possesses advanced knowledge of normalization techniques and implementation strategies, backup/recovery strategies, and performance tuning strategies.
• Worked extensively in MS-SQL Server 2005/2008/2012 Configuration, Backup & Recovery, Database Security, Data Transformation Services, database designing and query optimization.
• Experience in DTS, SSIS, Import/Export Wizard, SQL Server Enterprise Manager, and SQL Query Analyzer, Access 2000/2003, Excel 2003/2007.
• Experience in developing applications using C#.NET 2.0/3.0, ASP.NET 2.0/3.0 and .NET Framework 2.0/3.0/3.5.
• High-performing team player with expertise in building/optimizing process, tools and infrastructure to maximize results in various business settings.
• Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

TECHNICAL SKILLS

Languages: C#.NET

Web Technologies: ASP/ASP.NET, HTML, XHTML, XML, Java Script

DBMS: Microsoft SQL Server 2005/2008/2012 , Oracle 10g/9i/8i

DB tools: SSRS 2005/2008/2012 , SSAS 2005/2008/2012 , SSIS 2005/2008/2012 , Programming SQLWindows 2000/2003, PL/SQL, SQL*PLUS, TOAD, Windows 7 Pro/8.MS Office

PROFESSIONAL EXPERIENCE

Confidential, Orange, CA

SSIS/ Sr.SQL BI Server Developer

Environment: SQL 2008/SQL 2012, T-SQL,C#.NET, Excel, Access, flat files, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Oracle, MS Office, MS-Project, MS-Visio, XML

Responsibilities:

• Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from different data sources (online transaction Processing (OLTP) databases, Oracle, Flat Files, CSV, Excel source files, XML files etc) to data warehouse databases and involved in Data cleansing in the data transfer.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Redesigned legacy SSIS packages and converted DTS packages to SSIS packages.
• Extracted data from various sources such as Pervasive database, SQL Server, Excel, XML, Access and flat files using SSIS into destination tables as per the business requirements mapping documents.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make package tasks dynamic.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Performed unit, integration and functional testing of the packages.
• Developed SSIS Templates, which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Deployed packages to SSIS Package Store (MSDB database)
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental Load.
• Involved in the Migration of Databases from SQL Server 2008 to SQL Server 2012.
• Involved in SQL Server 2008 installation and Upgrade in Test, Development, QA & Production servers
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views and functions.
• Developed and Optimized Stored Procedures, Views, CTEs and User-Defined Functions for the Application.
• Supported front-end development team to resolve SQL related issues in Active Server Pages.

Confidential, Pasadena, CA

SQL/BI Developer

Environment: SQL 2005/SQL2008, T-SQL, PL/SQL, C#.NET, Excel, Access, flat files, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle 10i, TOAD for Oracle, Visual studio 2008, MS Office.

Responsibilities:

• Gathered functional, Business requirements and wrote technical specifications for building the Database objects.
• Wrote user requirement documents based on functional specification.
• Performed database design by analyzing business requirements.
• Build and maintain SQL scripts, stored procedures, Views and complex queries for data analysis and extraction.
• Worked on optimization and tuning of SQL queries and indexes.
• Provide database coding to support business applications using T-SQL.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Extracted data from various sources such as SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements mapping documents.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make package tasks dynamic.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views and functions.
• Performance tune Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques and Indexes.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created Tabular, Matrix, and Chart and parameterized Reports using MS Reporting services 2005.
• Developed Reports for business end users usingReport Builderwith updating Statistics.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• Designed Reports by creating linked server Views against MySQL database tables.
• Debugged and deployed the generated reports directly onto the client’s workstation.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Designed and implemented stored procedures and triggers for automating tasks.
• Assisted in troubleshooting and resolution of database issues.
• Tested applications for performance, data integrity and validation issues.
• Deployed packages to SSIS Package Store (MSDB database) and Scheduled the jobs to do these tasks periodically

Confidential

SQL /BI Developer

Environment: MS SQL Server 2005, MS SQL Analysis Services 2005, T-SQL, Windows 2003, MS SQL Server Reporting Service 2005.

Responsibilities:

• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications.
• Wrote complex Stored Procedures, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Created indexes, Constraints and rules on database objects.
• Developed store procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created SQL server Reports using SSRS 2005.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Generated various reports with drilldowns, calculated members drop downs from the cubes by connecting to Analysis server from SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Supported the front application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Dealt withFine-tuningStored Procedures to improve performance with aQuery planusingSQL Tuning advisor.
• Created an entire new system for reports for the senior management.

Confidential

SQL Developer

Environment: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SQL Analysis Services 2005, MS SQL Integration Services 2005 T-SQL, Windows 2003.

Responsibilities:

• Gathered functional, Business requirements and wrote technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with developers, end users in designing and creating the Global Enterprise Data warehouse.
• Developed a multi-dimensional database and OLAP cube using SQL Server 2005 that stored and maintained data.
• Involved in the complete data warehouse development life cycle.
• Responsible for the design, development and maintenance of several cubes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards
• Designed MDX in accessing cubes and hands-on experience in query structuring, performance optimization.
• Created SQL server Reports using SSRS 2005.
• Generated various reports with drilldowns, calculated members, and dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Debugged and deployed the generated reports directly onto the client’s workstation.
• Responsible for transferring data using SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications. Data migration (Import & Export using BCP) from text to SQL Server2005.
• Migrated the DTS packages to SSIS packages.
• Performed creating Stored Procedures for reports generation.
• Documented all kinds of reports and DTS and SSIS packages.
• Implemented constraints on tables.
• Developed complex T-SQL code for the application.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained table performance by following tuning tips like normalization, creating indexes and collect statistics.
• Used SQL Profiler and Index Tuning Wizardfor tracing slow running queries and stored procedures.
• Tested applications for performance, data integrity and validation issues.