SUMMARY

• Six Years experience in the IT industry as a MS SQL Developer, SSIS/SSAS/SSRS in OLTP and OLAP (Data Warehousing) environments
• Expert in MS SQL Suite of Products like SSRS, SSAS and SSIS of MS SQL Server 2005
• Expert in developing ETL interfaces using SSIS, DataMarts/ cubes using SSAS and enterprise/ reports using SSRS/ Crystal using latest versions (2005/2008) and features
• Expert in generating SQL Server Reports using SSRS 2005
• Expert in writing Parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005
• Expert in data migration experience, data quality assessment, data cleansing, loading and validation
• 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
• Extensive experience in Data Warehousing
• 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 handling queries using C#
• Extensive experience in writing codes using ASP.NET
• Experienced in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005
• Skilled in sorting the data, defining subtotals for the reports
• Proficient in the use of T - SQL for developing complex stored procedures, triggers and functions
• Excellent in creating tables, views, indexes, replication and other SQL joins and query writing
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers
• Expert in handling sub reports in SSRS 2005
• Expertise in generating reports using Business Objects 6.5/XI, Crystal Reports and SQL Server Reports
• Experience in creating the cubes and dimensions
• Experience in using SQL Stored Procedures
• Expert in working with trace files and execution logs
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries
• Creating and managing roles for security in reports.
• Proficient in creating DTS packages for transferred data modifications.
• Experience in designing and developing Reporting System using Business Objects.
• Experience in working with ASP.NET
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills as well as flexible to learn advancements in the IT industry.
• Effective management on multiple projects in order to meet deadlines.

TECHNICAL SKILLS

Database: SQL Server 2000, 2005, 2008, Oracle 10i

Operating Systems: Windows XP/2000/2003

Programming Languages: SQL, PL/SQL, C, C++, C Sharp

BI Suite: SSAS, ProClarity

Reporting Tools: SSRS, Crystal Report

ETL Tools: SSIS, DTS, SQL Loader, Informatica

Application Servers: Internet Information Server (IIS) 5.0, 6.0

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SSIS/SQL Developer/SQL DBA

Responsibilities:

• Developed SSIS Packages for running the different claims.
• Generated automated passwords for sending email to the different clients.
• Responsible for auto- generation of different user ids for the users.
• Write Stored Procedures, Views and Functions to support reports.
• Created SSIS package for finding dentists in the Mid- Atlantic area.
• Ran the Commercial Extracts for sending it to the client ‘Healthation’.
• Used T-SQL for automating backend processes.
• Developed and tested user friendly navigator by utilizing JavaScript and VB.NET.
• Developed COM components in VB to implement business rules and data access objects.
• Performed testing tasks for different validation purposes.
• Generated the extract validation report for checking the reason for the errors occurred in the different tables.
• Send notifications and data via email to the different users.
• Worked with project sponsors and team leaders to prioritize existing and new issues based on the size of the impact on process efficiency, data quality, the Project timeline, and the organization’s ability to affect change.
• Testing the emails sent to the different users using the application.
• Responsible for dealing with the end users for any production support issues.
• Provide technical support to end users.
• Strong in SQL, scripting, and understanding of how web access to SQL needs be configured.

Environment: MS SQL Server 2008, MS Visual Studio 2010, MS Outlook, MS SharePoint, MS Excel, SQL Server Profiler, Windows XP, C- Sharp

Confidential, Minneapolis, MN

SSIS/ SQL Developer/SQL DBA

Responsibilities:

• Developed scripts for building stored procedures in SQL
• Modified procedures to check them back into TFS
• Responsible for the creation of the applications by using vb.net and enhancement of the projects for .net applications
• Responsible for the automation and the development of the business environment
• Managed XML scripts to build codes for SSIS packages
• Data analysis and reconciliation
• Write Stored Procedures, Views and Functions to support reports
• Develop and customize reports to support the hedge fund of funds business
• Worked to improve the performance and migrate the existing database application
• Used .NET to develop the codes and migrate to production
• Designed, developed and tested the solution in MS SSAS 2008
• Used Oracle Client Access to maintain the integrity of the SSIS package
• Built SSIS packages to deal with various xml codes
• Migrated and recreated existing Dimensions and Cubes using Star Schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS)
• Assisted in the business process redesign and documentation as needed for new technology
• Resolved Deadlock Issues with the Database/ Servers
• Ability to write complex SQL queries and data retrieval from very large scale relational databases or Data Warehouse.
• Significant testing expertise in a Data Warehouse Environment Extract/Transform/Load (ETL)
• Worked on Performance Point 2010
• Developed VB utilities for data export and import
• Send notifications and data via e-mail; asSSRSdata sets; and for SharePoint and other web front ends
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports
• Utilize SQL Profiler to troubleshoot issues withSSRSand other reports
• Deploying and scheduling Reports usingSSRSto generate all daily, weekly, monthly and quarterly Reports including current status
• Developed advanced workflow - based on event notification applications using the SSRS to notify subscribers via email
• T-SQL scripts to manage the different databases
• Used T-SQL for automating backend processes\
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system
• Worked with QRM Operations team on daily operations
• Strong experience with test Planning/defect tracking systems such as Quality Center and typical prioritization / escalation processes
• Worked on C-Sharp
• Administration of Microsoft SQL Server Database environment
• Delivered package enhancements for the promotion to UAT.
• Performing testing tasks with a minimum of oversight and direction.
• Responsible for transferring the data using SSIS packages.
• Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
• Extensively used SSIS Import/ Export wizard, for performing the ETL operations.
• Strong back end testing from a data warehouse environment.
• Worked in support of a custom .NET development environment.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Worked with the production and data warehouse teams.
• Created indexes, constraints and rules on database objects.
• Knowledge of data warehousing concepts.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as excel, CSV file and XML file.

Environment: MS SQL Server 2005, MS SQL Server 2008, C-Sharp, MS Visual Studio 2005, Unix, Oracle, MS Visual Studio 2008, Windows XP, MS Outlook, MS Excel, SQL Profiler.

Confidential, Hartford, CT

SSIS/ SQL Developer/SQL DBA

Responsibilities:

• Worked on the database to build the reports using SSRS 2008.
• Created the data sources to get the required data.
• Generated data sets from the stored procedures created using SQL Server 2008 R2.
• Built stored procedures for the balanced and control reports required for product design.
• Supported for the MS SQL Server 2008 in production.
• Worked on the data migration part of the project which included data quality assessment, data cleansing, loading and validation.
• Responsible for the creation of the applications by using vb.net and enhancement of the projects for .net applications.
• Strong in SQL, scripting, and understanding of how web access to SQL needs be configured.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Send notifications and data via e-mail; asSSRSdata sets; and for SharePoint and other web front ends
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports
• Utilize SQL Profiler to troubleshoot issues withSSRSand other reports.
• Developed VB utilities for data export and import.
• Designed and developed user interface for mesh design using Visual Basic 5.0.
• Developed advanced workflow - based on event notification applications using the SSRS to notify subscribers via email.
• Deploying and scheduling Reports usingSSRSto generate all daily, weekly, monthly and quarterly Reports including current status.
• Worked on Performance Point 2010.
• Worked on Shell scripting.
• Worked on Unix and different scripts of Oracle.
• Worked on Dashboard Development.
• Experience in converting MS Access databases to MS SQL Server.
• Worked in Strategy Companion.
• Design, develop and maintain BI and Data Warehouse based solutions.
• Experience working with IIS suite (IBM Information server, data stage, quality stage, profile stage components).
• Identified the Data Source and defining them to build the Data Source Views.
• Implemented data models in SQL Server 2008.
• Experience in Data Modeling, Database design and well-verse with SQL Server best practices.
• Designed the database to get the basic data required for report generation.
• Worked in performance tuning of the views and the underlying queries.
• Worked as a data architect for the BI environment.
• Designed cubes using SSAS.
• Used C-Sharp to migrate data from one environment to other.
• Expert in XML Extraction and Transformation, XML Databases and Indexing/ Search.
• Experience in 3NF data modeling in the SQL Server environment.
• Assisted with cube generation and deployment.
• Assisted in writing ETLs in SSIS 2008.
• Worked on the C-Sharp skills to develop the code and present to the team.
• Worked to get access to the stored procedures created using the database administration.
• Generated user ids and passwords and stored them in the secure server using SQL Server 2008.
• Optimized SQL and C# code for efficiency and security.
• Designed and implemented MySQL databases.
• Developed DTS packages and scheduled database tasks.
• Created Packages that dealt with text files containing dynamic number of columns.
• Created Log Files so that in case of Package failures the errors could be troubleshot.
• Created Script tasks to check for existence of Source files for a specified amount of time.
• Modified existing reports to Tabular SQL reports when the report performance was found to be below par.
• Worked in the data warehousing and the multi-dimensional data mart environments.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Worked with IIS suite (IBM Information server, data stage, quality stage, profile stage components).
• Used ASP.NET to connect the different reports to the server.
• Worked in support of a custom .NET development environment.
• Designed, developed and tested the solution in MS SSAS 2008.
• Designed complicated reports with drill-down, drill through, cascading parameters, etc.
• Granting permissions to end users to access the database.
• Designed and Implemented row-level access control for users to access detail reports.
• Designed and implemented datasets and layouts for various reports with SSRS.
• Retrieved data from cubes and generated OLAP reports with SSRS and SSAS.
• Maintained data integrity by performing validation checks.
• Developed complex stored procedures for ETL.
• Loaded data from heterogeneous sources using various tasks and transformations in SSIS.
• Created jobs to automate and schedule data loading, backup, reporting with SQL Server agent.
• Worked with 64 bit Windows OS.

Environment: SQL Server 2008, C-Sharp, SSAS 2008, SSRS 2008, MS Outlook 2010, Unix, Oracle, ASP.NET, MS Excel, Windows XP.

Confidential, Howell, NJ

SSIS/ SQL Developer

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Involved in development and implementation of SSIS application solutions for various business units across the organization.
• Responsible for transferring the data using SSIS packages.
• Responsible for data migration in SQL Server.
• Worked on data quality assessment, data cleansing, loading and validation.
• Experience working with IIS suite (IBM Information server, data stage, quality stage, profile stage components).
• Experience in Building Clusters.
• Strong in SQL, scripting, and understanding of how web access to SQL needs be configured.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Developed, monitored and deployed SSIS packages.
• Created and administered OLAP cubes on the SQL Server Analysis Services platform using the Star Schema Method.
• Partitioned Cubes for optimizing the performance of Query and reduce down time.
• Developing OLAP Cubes to have a better analysis for the Business Needs.
• Worked on Mirroring, Log Shipping.
• Worked on Shell Scripting.
• Worked on Unix and the different versions of Oracle.
• Worked in support of a custom .NET development environment.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
• Responsible for understanding the world scope data feed, help design the target schema and develop an ingestion feed process using SSIS.
• Developed SSIS project for transferring the data.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Used C-Sharp to develop code and present it to the team of developers.
• Migrated and recreated existing Dimensions and Cubes using Star Schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Deploy/ Design Cubes in SSAS environment Star and Snowflake Schema Designs.
• Identified and Defined Key Performance Indicators in SSAS 2005.
• Upgraded Analysis Service 2000 to SSAS 2005.
• 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.
• Implemented the calculations to aggregate physical measures.
• Analyzed reports and fixed bugs in stored procedures for the ongoing database operations, to resolve business problems.
• Generated reports using SQL Server Reporting Services (SSRS).
• Redesign/ Deploy reports using Reporting Services 2005.
• Created report models for Report Builder and managed reports using Report Manager.
• Involved in creating Technical specification Document (TSD) for the project.
• Designed and implemented complex ETL packages.
• Implemented the calculations to aggregate physical measures.
• Designed and developed the database infrastructure.
• Created ER Diagrams (physical and logical) and mapping the data into database objects.
• Normalized the database into small tables by applying Normalization, defined Check constraint and applied Business Rules.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), C-Sharp, Unix, Oracle, MS SQL Reporting Services 2005, ASP.NET, MS Excel, Windows XP.

Confidential, Whitehouse Station, NJ

SSIS/ SQL Developer

Responsibilities:

• Gathering data from the end-user and checking the structure of the schema.
• Updated functional specification and technical design documents.
• Migrated data to SQL Server 2005 via SQL Server Integration services (SSIS).
• Extensively used SSIS Import/ Export wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Developed SSIS solution for developing a fully fledged data warehouse solution.
• Used C-Sharp to develop the code.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Worked with project sponsors and team leaders to prioritize existing and new issues based on the size of the impact on process efficiency, data quality, the Project timeline, and the organization’s ability to affect change.
• Used SSIS to create ETL packages (.dtsx) files to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Identified and defined key performance indicators in SSAS 2005.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLTP reporting needs.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Responsible for identifying KPIs in SSAS 2005.
• Reviewed and fine tuned stored procedures and triggers before production migration.
• Created various database objects- tables, indexes, views and roles.
• Assisted in migrating de-normalized DB into a Star Schema Design.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Design, deploy and maintain SSRS reports in SQL Server 2005.
• Experience working with SharePoint.
• Developed reports using efficient data retrieval techniques.
• Designed and implemented Parameterized and cascading Parameterized reports using SSRS.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Profitability reports using SSRS 2005.
• Experience in creating multiple reports (SSRS) in Drill Mode using tables, cross tabs and charts.
• Maintained security role and database users.
• Transformed the complex business logic and calculations into coding.
• Optimized queries, tuned them and monitored server performance.
• Developed physical data models and created DDL scripts to create database and its required objects.
• Designed data models using Erwin.
• Imported data from various sources into a staging area and merge the data into the OLTP data model.
• Maintained data integrity by performing validation checks.
• Involved with the technical architecture team to ensure that the architectural integrity is maintained.

Environment: MS SQL Server 2005, MS Access, MS SQL Analysis Services 2005, MS Excel, Visual Studio 2005, Windows Server 2003.

Confidential, Houston, TX

SSIS/ SQL Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Provided information and assistance to the database architects on physical models, and the setup and maintenance of metadata.
• Performed backup/ restore, database objects such as tables, procedures, triggers, views, constraints and indexes.
• Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
• Worked with project sponsors and team leaders to prioritize existing and new issues based on the size of the impact on process efficiency, data quality, the Project timeline, and the organization’s ability to affect change.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Identified the data source and defining them to build the data source views.
• Created various DTS packages for data transfer and migration.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Developed, monitored and deployed SSIS packages.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Use of SSIS to create ETL packages (.dtsx) files and process SSAS cubes to store data to OLAP databases.
• Performance tuning to optimize SQL queries using query analyzer.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as excel, CSV file and XML file.
• Created indexes, constraints and rules on database objects.
• Created complex SSAS cubes with multiple facts measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Used C-Sharp in different scenarios.
• Identified and defined fact relationships in SSAS.
• Created various weekly and monthly reports showing detailed information.
• Defined unknown members and null processing properties.
• Created indexes, constraints and rules on database objects.
• Transformed the complex business logic and calculations into coding.
• Worked in coordination with development team to deploy and test the application.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005, C-Sharp, MS Analysis Services 2005, MS Access, Import and Export Data, Windows XP

Confidential, New York, NY

SQL Developer

Responsibilities:

• Gathered requirements from the business users.
• Wrote user requirement documents based on functional specification.
• Performed backup, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Maintained the table performance by following tips like normalization, creating indexes and collecting statistics.
• Developed stored procedures, functions, views, triggers.
• Involved in job scheduling using SQL Server Agent.
• Performed Data Transfer (Import-Export) using BCP.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Wrote DTS scripts for data transfer.
• Used C-Sharp to migrate the code from one environment to other.
• Responsible for supporting investment operations by making comparison of general ledger balances withassets managementschedules.
• Performed tasks of reviewing and controlling accounting activities of the organization.
• Prepared and maintain reports of wire transfer payments, tax payments, electronic payments and bank payments.
• Prepares accurate monthly and annual financial statements.
• Responsible for maintaining data for securities on deposit in line with the requirements of state and other companies.
• Indexed views, dimensions and stored outlines for optimal performance.
• Optimized SQL queries using SQL Query Analyzer.
• Used T-SQL for automating backend processes.
• Created batch scripts, using T-SQL, for production rollouts.
• Performed Data Analysis for automating various customers’ orders reports utilizing SQL Reporting Services.
• In-depth working knowledge of ODBC.
• Created many complex stored procedures/ functions and used them in crystal reports directly to generate reports on the fly.
• Worked with the Data Architect to migrate legacy data into the new analysis data mart and created reports for inventory module.
• Transformed the complex business logic and calculations into coding.

Environment: MS SQL Server 2005, C-Sharp, MS Analysis Services 2005, MS Access, Import and Export Data, Windows XP