SUMMARY

• Six Years experience in teh 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 teh data, defining subtotals for teh reports
• Proficient in teh 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 teh 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 teh 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 teh different claims.
• Generated automated passwords for sending email to teh different clients.
• Responsible for auto- generation of different user ids for teh users.
• Write Stored Procedures, Views and Functions to support reports.
• Created SSIS package for finding dentists in teh Mid- Atlantic area.
• Ran teh Commercial Extracts for sending it to teh client ‘Healdation’.
• 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 teh extract validation report for checking teh reason for teh errors occurred in teh different tables.
• Send notifications and data via email to teh different users.
• Worked with project sponsors and team leaders to prioritize existing and new issues based on teh size of teh impact on process efficiency, data quality, teh Project timeline, and teh organization’s ability to affect change.
• Testing teh emails sent to teh different users using teh application.
• Responsible for dealing with teh 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 teh creation of teh applications by using vb.net and enhancement of teh projects for .net applications
• Responsible for teh automation and teh development of teh 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 teh hedge fund of funds business
• Worked to improve teh performance and migrate teh existing database application
• Used .NET to develop teh codes and migrate to production
• Designed, developed and tested teh solution in MS SSAS 2008
• Used Oracle Client Access to maintain teh integrity of teh 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 teh efficiency of SQL Server Analysis Services (SSAS)
• Assisted in teh business process redesign and documentation as needed for new technology
• Resolved Deadlock Issues with teh 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 teh SSRS to notify subscribers via email
• T-SQL scripts to manage teh 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 teh promotion to UAT.
• Performing testing tasks with a minimum of oversight and direction.
• Responsible for transferring teh 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 teh 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 teh 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 teh database to build teh reports using SSRS 2008.
• Created teh data sources to get teh required data.
• Generated data sets from teh stored procedures created using SQL Server 2008 R2.
• Built stored procedures for teh balanced and control reports required for product design.
• Supported for teh MS SQL Server 2008 in production.
• Worked on teh data migration part of teh project which included data quality assessment, data cleansing, loading and validation.
• Responsible for teh creation of teh applications by using vb.net and enhancement of teh 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 teh 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 teh Data Source and defining them to build teh 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 teh database to get teh basic data required for report generation.
• Worked in performance tuning of teh views and teh underlying queries.
• Worked as a data architect for teh 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 teh SQL Server environment.
• Assisted with cube generation and deployment.
• Assisted in writing ETLs in SSIS 2008.
• Worked on teh C-Sharp skills to develop teh code and present to teh team.
• Worked to get access to teh stored procedures created using teh database administration.
• Generated user ids and passwords and stored them in teh 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 dat dealt with text files containing dynamic number of columns.
• Created Log Files so dat in case of Package failures teh 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 teh report performance was found to be below par.
• Worked in teh data warehousing and teh multi-dimensional data mart environments.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet teh business requirements.
• Worked with IIS suite (IBM Information server, data stage, quality stage, profile stage components).
• Used ASP.NET to connect teh different reports to teh server.
• Worked in support of a custom .NET development environment.
• Designed, developed and tested teh solution in MS SSAS 2008.
• Designed complicated reports with drill-down, drill through, cascading parameters, etc.
• Granting permissions to end users to access teh 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 teh organization.
• Responsible for transferring teh 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 teh cube.
• Developed, monitored and deployed SSIS packages.
• Created and administered OLAP cubes on teh SQL Server Analysis Services platform using teh Star Schema Method.
• Partitioned Cubes for optimizing teh performance of Query and reduce down time.
• Developing OLAP Cubes to have a better analysis for teh Business Needs.
• Worked on Mirroring, Log Shipping.
• Worked on Shell Scripting.
• Worked on Unix and teh 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 teh world scope data feed, halp design teh target schema and develop an ingestion feed process using SSIS.
• Developed SSIS project for transferring teh 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 teh team of developers.
• Migrated and recreated existing Dimensions and Cubes using Star Schema on 2005 Server to achieve teh 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 teh calculations to aggregate physical measures.
• Analyzed reports and fixed bugs in stored procedures for teh 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 teh project.
• Designed and implemented complex ETL packages.
• Implemented teh calculations to aggregate physical measures.
• Designed and developed teh database infrastructure.
• Created ER Diagrams (physical and logical) and mapping teh data into database objects.
• Normalized teh 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 teh end-user and checking teh structure of teh 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 teh ETL operations.
• Created SSIS process design architecting teh flow of data from various sources to target.
• Developed SSIS solution for developing a fully fledged data warehouse solution.
• Used C-Sharp to develop teh 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 teh size of teh impact on process efficiency, data quality, teh Project timeline, and teh 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 teh 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 dat 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 teh 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 teh 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 teh data into teh OLTP data model.
• Maintained data integrity by performing validation checks.
• Involved with teh technical architecture team to ensure dat teh 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 teh data sourcing and data flows, data quality analysis, working in conjunction with teh data warehouse architect on teh development of logical data models.
• Provided information and assistance to teh database architects on physical models, and teh 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 teh size of teh impact on process efficiency, data quality, teh Project timeline, and teh organization’s ability to affect change.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Identified teh data source and defining them to build teh 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 teh 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 teh 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 teh complex business logic and calculations into coding.
• Worked in coordination with development team to deploy and test teh 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 teh 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 teh 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 teh 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 teh 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 teh 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 teh fly.
• Worked with teh Data Architect to migrate legacy data into teh new analysis data mart and created reports for inventory module.
• Transformed teh 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

Confidential

SQL Server Developer

Responsibilities:

• Developed backup restore scripts for SQL Server as needed.
• Tuned SQL statements (Using Indexes) and stored procedures.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, SQL Server automatic e-mail notification.
• Tested to optimize teh procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in analyzing and designing disaster recovery/ replication strategies with business managers to meet teh business requirements.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Involved in job scheduling and alerts.
• Resolved any deadlock issues with teh Database/ Servers.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
• Configured Snapshot Replication for reporting, user acceptance test and development servers.
• Supported front-end development team to resolve SQL related issues in Active Server Pages during server migration.

Environment: MS SQL Server 2000, C-Sharp, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import and Export Data, Windows 2000 Server