SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server 2012/2008 R2/2005/2000 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 2005/2000/7.0, 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 v7.0 to SQL 2000 and SQL 2000 to SQL 2005.
• 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 2005, SSIS 2008.
• 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 2005, SSRS 2008.
• Expert in scheduling and deployment of reports and uploading files to a report server catalog from report manager.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• 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/2008 R2/2005/2000
• 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, Greene, NY

MS SQL Server Developer/SSIS/SSRS

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.
• Developed and deployed SSIS packages also upgraded DTS packages to SSIS.
• Involved in extracting the data from OLTP to Data warehouse using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2012 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 2012 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 2012.
• Used script task to pull data from C#. Wrote simple code in C#.
• Implemented SSAS cubes, facts and dimension tables to perform analysis
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using Informatica.
• Responsible for stylish Report Layouts and Deployed the Reports using SSRS 2012.
• Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2012.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Use Inmon and Kimball method for data analysis.
• Created indexes, Constraints and rules on database objects.

Confidential, West Chester, PA

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created and scheduled jobs to automate various processes.
• Using SSIS, created packages to load data from various formats and exported data to various formats.
• 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.
• 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.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using SSIS and loaded data into target, by scheduling the sessions.
• Importing data into Oracle from Excel files through SQL loader.
• Wrote queries and developed complex stored procedures and user defined functions.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• 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.

Confidential, Minneapolis,MN

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.
• Developed SSIS packages to produce details and summarized reports on a daily basis.
• Experience in complete database Administration, ETL including data analysis, design, data mapping and conversion & data load.
• Created SSIS packages using Conditional Split, Data Conversion, Fuzzy Lookup.
• Experience in SSAS (SQLServerAnalysis Services) inSQL2005 andSQL2008.
• Experience in Design, deployment, and maintenance of various SSRS Reports inSQLServer2008 and 2005.
• Experience in monitoring and tuningSQLServerdatabase performance using tools likeSQLProfiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Thorough knowledge of new features of SQL Server 2008.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and index view.
• Created Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Experience in disaster recovery with Backup and Restore Strategies and scheduling those backups.
• Knowledge of XML and Experience working with XML in SQL Server 2005.
• Extensive experience in basic and advanced report creation with thorough knowledge of report serving architecture.
• Experience in creating various types of reports(table, chart and matrix report, web reporting by customizing URL Access etc)
• Created the multi Dimensional data model(Star Schema).
• Designed and developed Drill down and Drill thru parameterized reports using SSRS.
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Developed custom reports and deployed them onserverusingSQLServerReporting Services (SSRS).

Confidential, PA

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.
• Consolidated the requirement and worked to create the enterprise Data Model along with the logical Data Model for the system using ERWIN CASE tool.
• Created Entities, attributes, relationships and the data dictionary for the system.
• 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, Hartford, CT

MS SQL Server Developer/SSRS/SSAS Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Used SSIS Import/Export Wizard, for performing the ETL operations.
• Createdalerts, notifications, and emailsfor scheduledSSISpackages execution.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Designed a schema for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Troubleshootand fixed issues in existing cubes in SSAS.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Generated dynamic reports from cubes (SSAS) using SSRS.
• Designed a new schema for the data mart databases.
• Implemented SSAS cubes, facts and dimension tables to perform analysis.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Confidential, Stamford, CT

MS SQL Developer /SSIS/SSRS/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.

Confidential, Dallas, TX

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 incorporate 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 2005 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

MS SQL Server Developer

Responsibilities:

• Successfully migrated database from SQL server version 7.0 to SQL server 2000
• Created database objects such as tables, procedures, triggers, indexes and views
• Generated logical and physical data models for the insurance policy holders.
• Developed processes, automation of maintenance jobs, tuning SQL Server, administered SQL Server security and SQL Server automatic e-mail notification.
• Worked on project planning, scheduling for database module with project manager.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Tested to optimize the procedures and queries to be used in production.
• Helped analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Conducted performance tuning to optimize the SQL queries using query analyzer.
• Configured Snapshot replication for reporting, user acceptance test and development servers.