SUMMARY

• Over 9 years of strong experience in the IT industry as a MS SQL Server 2012/2008R2/2008/2005 Developer/BI Developer in various domains like Financial, Healthcare and Banking.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin.
• Excellent experience in designing, maintaining & tuning various RDBMS like T - SQL & SQL Server 2012/2008R2/2008/2005, MS-Access databases.
• Highly proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.
• Skilled in performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers.
• Expert in using SQL Profiler, Execution Plan and Performance Monitor.
• Proficient in Migration of database, successfully migrated database from SQL Server 2005 to SQL 2008 and SQL 2008R2 to SQL 2012.
• Excellent in Performance Tuning and Optimization of queries and stored procedures.
• Experience in creating jobs, SQL Mail, Alert and Schedule SSIS Packages using SQL Server Agent.
• Extensive experience using various transforms in SSIS as an ETL tool while transferring the data from various sources into the destination files.
• Expert in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2005, SSIS 2008.
• Transformed data from various data sources to SQL Server using BCP, DTS and SSIS 2012/2008R2/2008/2005
• Adept in defining referenced relationships and calculated members in SSAS and used MDX queries, creating OLAP structures from OLTP databases.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012/2008R 2/2008/2005.
• Mastered creating stylish Report Layouts using Global expressions, functions, Subtotals, Sorting the data in SSRS 2012/2008R 2/2008/2005.
• Experienced in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment.
• Maintained positive communications and working relationship at all levels.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• Data Stage
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Rational Rose
• ERwin4.x
• TOAD 6.0
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• XML
• C#
• MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

MS SQL Server/SSIS/SSRS/SSAS/ETL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2012/2008 to store data and to maintain database efficiently.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS 2012/2008, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse..
• Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Deploying, Testing and Scheduling SSIS packages using SQL Agent.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
• Created many Cascaded parameters in the reports using SQL SSRS 2012/2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008).
• Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.

Confidential, West Chester, PA

MS SQL Server/SSIS/SSRS/SSAS/ETL Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Involved in extracting the data from OLTP to Data warehouse using SSIS.
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS 2008 and then created reports using this data using SSRS.
• Tested and managed the SSIS 2008 packages and was responsible for its security.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2008.
• Responsible for stylish Report Layouts and Deployed the Reports using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.

Confidential, Greene, NY

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Participated with business analysts in order together requirements for design and implementation of database.
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation for the data mart of OLTP and Data warehouse databases.
• Expert in extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created local variables and global variables package configurations and error handling.
• Generated a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Wrote MDX queries to access data from OLAP cubes.
• Created parameterized reports and ad-hoc reports using Report builder for the brokers and clients.
• Responsible for designing, creating and deploying the reports into the production server.
• Created complex store procedure to copy Database Objects from remote server to local machine and vice versa.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Confidential, Edison, NJ

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Enhanced PMS data model to in corporate new reporting on wealth management system requirements.
• Build mapping document to map all the data elements from wealth management system to PMS.
• Involved in ER diagrams (Physical and Logical using ERwin) and mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.
• Build packages for data reconciliation between wealth management system and PMS and logging them for auditing purposes.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such asreplicationand log shipping.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Confidential, Jacksonville, FL

MS SQL Developer /SSRS/SSIS/SSAS

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2005.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2005.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Deployed the generated reports created using SSRS 2005 on to the server.

Confidential, Stamford, CT

MS SQL Developer /SSRS/SSIS/SSAS

Responsibilities:

• Deal with requirements gathering, analysis, design, development, change management, deployment and user training.
• Added logins, roles, groups to the Window NT and MS SQL Server and maintained proper security procedures.
• Designed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Created Linked Servers to connect OLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Performed Data Analysis for automating various drugs related reports utilizing SQL Analysis Services.
• Designed, programmed, deployed and tested the requested Reports.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.