SUMMARY

• Over 8 years of extensive experience in data warehouse complete life cycle using SQL Server 2000/2005/2008 suite of products SSIS, SSRS, and SSAS.
• Hands on experience in SQL Server DTS and SSIS (Integration Services) package design, constructing, and deployment.
• Expert in identifying KPIs and defining Referenced relationships and analyzing data intensively using SSAS 2005.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Strong understanding and experience in SQL 2008 new features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expert in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
• Experienced in writing Stored Procedure/TSQL coding,, Physical and logical Database Design, and Triggers.
• Designed and developed more than 100+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expert in the SSAS storage and partition, aggregations and calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Proficient in defining Granularity within a measure group and drill through actions.
• Successfully migrated content from SQL server 2000 to SQL server 2005, SQL Server 2005 to SQL server 2008.
• Expert in migrating data from various heterogeneous OLTP sources to OLAP destinations.
• Experienced in connecting to database components using C#, VB.NET for Data Access.
• Expert in designing, maintaining & tuning various RDBMS such as SQL Server 2008/2005/2000 .
• Experienced in deploying the cubes on the Analytical Server and connecting the cube objects with various cubes.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Batch Processing and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experienced in collecting requirements and generate stylish reports using Crystal Report and SSRS.
• Strong understanding of finance module and loan center application. Performed dynamic calculations, developed, reviewed, and optimized queries in SQL Server.
• Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SQL Server Integration Services
• SQL Server Analysis Services
• SQL Server Reporting Services
• Erwin
• Crystal Reports
• OLAP
• OTLP
• ODBC
• MS Access
• Windows NT/2000/XP/Server 2003
• MS Visio
• Excel
• Access
• T-SQL
• PL/SQL
• HTML.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

MS SQL Server Developer/SSRS/SSAS/SSIS

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into ETL Design Specifications and SSAS cube.
• Designed and implemented Sales Data warehouse star schema, Fact and Dimensions.
• Implemented type 1 and type 2 Slow Changing Dimensions.
• Using Control Flow elements like For Each loop Container and Sequence container.
• Was involved in dealing with the users offshore.
• Execute SQL task, Execute Process task, Execute package task and Script task, File System task Send Mail Task.
• Extensively used variables, package configurations, logging
• Designed and deployed Reports, Report Model using SSIS
• Created and used stored procedures for database transactions in SQL Server.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in the project from planning stage to pushing codes to production.

Confidential, Louisville, KY

Senior BI Developer

Responsibilities:

• Responsible for extracted and reviewed data from heterogeneous sources like (.csv, flat file, MS Access, text format data) using SQL server Integration Services (SSIS).
• Handled the tasks of developing and training a onsite team members.
• Provided sufficient information and data related to migration process, design and developing the framework to offshore team.
• Successfully coordinated with end client to discuss framework process and design.
• Responsible to find out bugs in designed framework and provided guidelines to offshore team.
• Applied various data transformations like Lookup, Sort, Multicasting, Conditional Split, Derived column etcetera.
• Wrote complex TSQL scripts, stored procedures, functions to fulfill the requirements by keep in mind the execution process and performance.
• Successfully coordinate with 18 offshore team members and distributing tasks and verify their works.
• Successfully fulfill all the deadlines given by end client.
• Involved in Database design, Creation and Maintenance of Databases.
• Participated in creating indexes to improve the performance of database.
• Provided documents for all kinds of SSIS packages.
• Compared end process output data with Data Junction by writing scripts in PL SQL.

Confidential, Denver CO

Senior SQL/BI Developer

Responsibilities:

• Responsible for extracted and reviewed data from heterogeneous sources like (.csv, flat file, text format data) using SQL server Integration Services (SSIS).
• Analyzed data quality, worked in conjunction with the data warehouse architect on the development of logical data models.
• Involved in analyzing, deploying and dynamic configuration of SSIS packages.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Monitored the system utilization by using the query optimizer, checking the execution plan and worked in Enterprise Manager for job scheduling.
• Performed Database Normalization to avoid data redundancies.
• Applied various data transformations like Lookup, Data-Conversion, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
• Provided documents for all kinds of SSIS packages.

Confidential

MS SQL Developer/BI Developer (SSIS, SSAS, SSRS)

Responsibilities:

• Responsible for extracted and reviewed data from heterogeneous sources like (.csv, flat file, text format data) using SQL server Integration Services (SSIS) from OLTP to OLAP.
• Involved in planning, defining and designing database using Erwin on Business requirements.
• Involved in installation and configuration of SQL Server 2008.
• Created SSIS packages to extract data from OLTP having sources like MS SQL Server 2000, Oracle Database, Text Files, Excel and Access to OLAP systems (SQL 2005/2008) and scheduled jobs to call the packages and stored procedures.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, SCD to maintain the history of the data and Derived column.
• Wrote T-SQL queries, stored procedures and used them to build packages.
• Implemented OLAP cubes, Facts and Dimentions for providing summarized and aggregate views of large sets of data and used Multi-Dimentional Expression (MDX) to access them.
• Responsible for query optimization to improve the quality of software by using SQL Profiler.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Created cubes and portioned them for query optimization using SSAS.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS).
• Wrote MDX queries and created OLAP report sourcing from SSAS cube.
• Created SSRS 2005 reports using MDX queries to structure stored procedure.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Provided documents for all kinds of SSRS reports, DTS, SSIS.
• Built enterprise reports with standard formats using SSRS and published in to Servers.
• Involved in migration of data from Windows server 2000 to Windows server 2003.
• Improved Performance of the database by creating Clustered and Non Clustered Index.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler.

Confidential, Jersey City, NJ.

MS SQL Server / SSIS/SSAS/SSRS Business Intelligence Developer

Responsibilities:

• Installed upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Designed ER diagrams and mapped the data into database objects.
• Designed and created different ETL packages using SSIS from Oracle source to SQL Server as destination.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Excellent Experience and understanding of SSAS, OLAP cube, and multi-dimensional modeling on Multi-terabytes database.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Created database, tables and procedures to update and clean the old data.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Created and updates cubes(measures, dimensions, hierarchies, relationships), defined calculation(calculated members, named sets), KPIs, perspectives using SSAS and MDX.
• Created cubes, did performance optimization and generated OLAP reports with SSAS.
• Designed and implemented datasets and layouts for various reports with SSRS.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Generated matrix reports, drill down, drill through, sub reports, and chart reports.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Configured SQL mail Agent for sending Automatic emails on Errors.
• Created star schema in SSAS and developed SSRS reports based on the cubes.

Confidential, Plantation, FL

SQL Server Developer/ ETL Developer (SSIS)/SSAS

Responsibilities:

• Experienced with defining and implementing new processes, workflows, or policies within an organization.
• Profiled the data to check if it meets the company’s ETL data quality standards by using the Row Count transformation to count the records in the SSIS dataflow and store it in a variable, used the Multicast transformation to check the source data quality against a standard approved dataset and a Conditional Split to filter unacceptable data to flat files and SQL tables.
• Identified duplicate data by using an Aggregate transformation that groups data by contract id. An email task was used to point other team members and managers to the files with the unacceptable data and also state the data issues.
• A Percentage Sampling transformation was used to limit the profiling to partial datasets. Used the Fuzzy Lookup transformation to find the best Insured individual match (person that is being insured) by checking the Insured table.
• Used the Derived Column transformation to cleanse data, change column names and include additional columns.
• Use ForEach Loop to loop through all the files in the folder and save the location to a variable then used again in an SQL Task to delete the tables if they already exist and create the tables in the database with the exact names as the source files.
• Used one SSIS package to execute multiple SSIS packages in the same and also in different projects simultaneously.
• Used Copy Column and Data Conversion tasks to copy columns and change data types.
• Used the Multicast, Aggregate and Merge Join transformations to retrieve the most recent records and re-join them.
• Managed the development and deployment of new applications, systems software, and/ or enhancements to existing applications throughout the enterprise.
• Involved in Database design, Creation and Maintenance of Databases.
• Designed & implemented Stored Procedures and Triggers for Automating Tasks.
• Created XML configuration files (.dts config files) to dynamically alter package properties.
• Migrated DTS packages to SSIS
• Designed and implemented DTS packages to import data from Oracle and SQL Server.
• Created for key transaction tables and Inserted/Updated Log Table for each transaction using Triggers.
• Experienced in Performance Tuning in SQL Server 2005 using SQL Profiler and Data Loading.
• Allocated Resources, Added Users and granted Permissions. Closely worked with front-end Programmers.
• Worked on database designing, logical and physical data modeling, worked on large scale data migration using BCP, SQL Scripts, Stored Procedures, Triggers, Views, etc

Confidential, South Birmingham, AL

MS SQL Server SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed OLTP databases for the data coming from various sources.
• Extracted data from OLTP to OLAP using SSIS using complex data transformations.
• Created the structure of the model and cubes in SQL Sever Analysis Services.
• Oversaw installations, upgrades of SQL 2005, SQL 2000 to SQL 2005.
• Involved in Database design, Creation and Maintenance of Databases.
• Provided Disaster Recovery procedures and policies for Backup and Recovery of Databases.
• Created automatically generating reports for both ESS and SCAN Plus which populate vast amounts of data on a daily basis.
• Reviewed cubes with the end user and changed them to in corporate all the data required for their reporting.
• Created ETL packages to migrate data from various sources like MS Access, MS Excel, Flat files.
• Prepared end user documentation, technical documentation, dimension map, contact list and published them in production.
• Provided training to the end users to familiarize them about how to use cubes and view the reports.
• Administered tasks such as scheduling, deployment and security.
• Created various tables and views.
• Wrote complex stored procedures, queries, triggers, functions, indexes, user-defined functions and cursors for various applications.

Confidential

Junior SQL Server/Application Developer

Responsibilities:

• Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers.
• Responsible for creating the tables, views, stored procedures, triggers.
• Participated in creating indexes to improve the performance of database.
• Created Constraints, Defaults and Views.
• Active part in performance tuning and query optimization.
• Generated reports using Crystal reports.
• Used Data transformation Services (DTS) to export and import data.
• Assisted in taking database backup and restore.
• Used SQL server profiler to troubleshoot the problems.
• Involved in creating users and assigning permissions to access the database.