Professional Summary

• 7 years of experience in IT industry performing Database Administration, Design and Development using SQL Server 2005/2008 R2/2012.
• Expertise working with SQL Server 2005/2008 R2/2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
• Experience in data Normalization and Data Modeling using Erwin and generating mapping documents.
• Extract Transform Load ETL development using SQL Server 2005, SQL server 2008R2 Integration Services SSIS and SQL Server 2008R2 Reporting Services SSRS .
• Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Configured and administer BPA Business Process Automation for designing ETL work flow and including multiple packages within the work flow
• Documenting all ETL projects and work flows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
• Developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.
• Working with new data quality services DQS in SQL 2012 as part of creating rules for data mapping and data cleansing.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
• Experience in Data Migration by using side-by-side upgrade process Management.
• Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions. Implementing SQL Server security and Object permissions.
• Hands on experience in configuring TEMP DB with considerable MEMORY and RAID LEVELS for better performance.
• Good experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace and 3rd party tools.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.
• Managing Production Server and Development server for SCCM Reporting.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Experience in Query Tuning by Using Execution Plan, query analyzer and tuning advisor.
• Good understanding and knowledge of Relational Database Management Systems RDBMS .
• Migrated DTS Packages to SSIS using various versions of SQL Server.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Experience in creating Jobs, Alerts and scheduling SSIS Packages in SQL Agent.
• Good Knowledge of Web development technologies such as HTML, XML, DHTML and Visual Studio 2008/2010.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

Technical Skills

MS-SQL Server 2012/2008 R2/2008/2005, SQL Server Enterprise Manager, Transact-SQL T-SQL , MS SQL Server Reporting Services SSRS , MS SQL Server Integration Services SSIS , Master Data, DQS, MS Access, MS Visual Studio, Microsoft Office, MS Visio 2003/2007, XML, ASP.NET, Crystal Report, Erwin 9.0, Share Point 2010,TFS 2010/2012,HP Quality Center HPQC .

Projects Summary

Confidential

SQL/ BI Developer

Hardware/Software:

MS SQL Server 2008R2/2012, SQL server integration services 2008R2/2012, SSRS 2008R2/2012, SSAS, TFS, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, Teradata 14.10, MS Access, Erwin 9.0, Report Builder 2.0/3.0,Siebel CRM, Oracle 11g, BPA Business Process Automation .

Responsibilities:

• Extracting data from various sources like flat files delimited, fixed width , Siebel CRM, Teradata, Oracle 11g, SQL 2008R2 and load it to SQL database for further process.
• Gathered requirement from the end user and developing ETL work flow for various ongoing projects
• Designing physical and logical data models and handling data repository for data models.
• Handling most of independent packages as well projects and troubleshooting it in case of any failure.
• Good exposure of Teradata express studio for writing queries and comparing the result with SQL audit tables.
• Configured and administer BPA Business Process Automation for designing ETL work flow and including multiple packages within the work flow.
• Administrating the Medicare and CRM data projects and deliver the data to vendor for further analysis and development.
• Documenting all ETL projects and work flows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
• Creating a template for the projects and making sure that following the same template across the project for better view and knowing. Supporting data modeler for the design prospect and help them to review it.
• Handling status call for every week and noting the work done and ongoing for the team.
• Created and maintaining audit for all the projects to store the execution logs in SQL database with insert, update and delete records.
• Developing data warehouse solution for customer marketing analytics group data and designing the ETL data flows to load history tables.
• Working with Informatica cloud and Salesforce integration for live data feed in SQL Databases.
• Configuring and maintaining reporting services for ad-hoc reporting and report models for the users.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.
• Developing and Tuning Data Cubes in SSAS for achieving best performance at reporting level. Writing MDX for generating SSRS reports and maintaining existing Dashboards.
• Working with BI stacks SSIS, SSRS, SSAS to creating aggregated datasets and datamart for business user as well dashboards.

Confidential

SQL/BI Developer

Hardware/Software:

MS SQL Server 2008R2/2012, SQL server integration services 2008R2/2012, SQL server Reporting Services 2008R2/2012, TFS, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL,PL/SQL, AS 400, MS Access, Erwin 9.0, Report Builder 2.0/3.0, SEQUEL Viewpoint, System I Navigator, TFS 2010.

Responsibilities:

• Closely worked with business users for gathering requirements and conducting a weekly meeting for BI team. Worked with Data modelers to create physical and logical models by using ERWIN.
• Developed DDL script using ERWIN and implemented rollout data models to design further SQL development. Creating test cases to implement the changes to QA and PROD for new ETL development and existing ETL packages.
• Extracting data from I-series AS 400 , Oracle, SQL 2005 and flat files using SSIS and performing all necessary procedures for data cleansing. Maintaining Landing zone and staging zone for data dumping.
• Running PL/SQL script and validate the data load for SQL server.
• Performed intensive data quality on various data migration and written various post scripts to perform data correction. Used various tasks like fuzzy lookup, for each loop, file system task for data cleansing and automate the process.
• Documented all ETL packages and applying versioning with other changes. Also created supporting documents for future failures. Worked on multiple projects for ETL development and system integration for new environment.
• Provide resolution and escalation of tickets assigned to Data Management group using Remedy force.
• Worked with TFS 2012 for check in, check out and deploying packages to QA and PROD.
• Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Multiple views were created to reduce the complexity of writing procedures and increase database performance.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process mappings, sessions, workflows from source systems to staging to DW and offshore team management.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse. Configuring and administering MDM services for direct client access.
• Hands on experience using DQS services and DQS task for Data Cleansing and creating rules for business.
• Highly skilled in developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11. Good exposure on Cognos 10.1 report studio and Framework manager.

Confidential

SSIS/SSRS Developer

Hardware/Software:

MS SQL Server 2005/2008 R2/2012, SQL server integration services 2008 R2/2012, SQL server Reporting Services 2008 R2/2012, TFS, Microsoft Visual Studio 2010/2012, SQL Server Management Studio, MS Excel, T-SQL, DB2 Mainframe, MS Access, Erwin 9.0, Report Builder 2.0/3.0.

Responsibilities:

• Involved in gathering requirements for Database creation, scheduling status review meetings, documents and code review.
• Good exposure in creating and managing conceptual, physical and logical data models.
• Created data mapping and sourcing documents for various sources to NPS New App .
• Involved in designing and implementing relational database RDBMS model as per business needs. Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using SQL Server 2012 integration services.
• Extracting data from IMS/DB2, MS Access, SQL Server 2005/2008 for migration and performing various transformations in SSIS ETL per business rules.
• Configured integration services 2012 and reporting services 2012 for developing new environment for NPS systems New Application . Converted existing DTS packages to SSIS ETL and tune the connections pointing towards new applications.
• Conducting a meeting with BSA to gathering more information on work flow for data migration and to understand new terminology for new application.
• Used change data capture CDC to simplify ETL in data warehouse applications.
• Experience in creating jobs, alerts, SQL mail agent and schedule SSIS ETL packages.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server. Experience Type 1 SCD and Type 2 SCD mappings to update slowly changing dimension tables. Experience pulling data from SSAS cube and developing and maintaining cubes.
• Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services SSRS .
• Performs System testing for all the modules and helps business in User Acceptance Testing.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.
• Well Experience in using tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
• Coordinating with offshore team for on time delivery of products and query resolution activities.

Confidential

SSIS/SSRS Developer

Hardware/software:

MS SQL Server 2008 R2, SQL server integration services 2008 R2, SQL server Reporting Services 2008 R2, TFS , .NET Framework, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, SCCM 2007 Console, SQL Sentry Power Suite Performance Advisor for SQL , Report Builder 2.0/3.0.

Responsibilities:

• Extract Transform Load ETL development using SQL Server 2005, SQL server 2008R2 Integration Services SSIS and SQL Server 2008R2 Reporting Services SSRS .
• Captured Plan information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance advisor to providing a record of all plan changes and optimizing query based on results.
• Developed and maintained ETL packages SSIS Packages to extract the data from various sources and involved in debugging and upgrading of several ETL structures as per the requirements.
• Build Development Server for Reporting and creating SCCM Reports Based on infrastructure needs. Publishing Reports on Reporting Server and Share point portal.
• Managing Production Server and Development server for SCCM Reporting.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Formatted the reports using the Global variables and expressions. Managed security by defining roles and rights.
• Manages the implementation and support of SQL Server 2008R2 and SCCM across multiple applications.
• Experience in data migration using tools like DTS, Bulk Insert, BCP and Replication between different homogeneous and heterogeneous systems and SQL Server.
• Working knowledge of disaster recovery and high availability solution like replication, transaction log shipping, mirroring and clustering.
• Monitored the database server performance and if required go for tuning of the T-SQL queries, stored procedures etc. Proven ability to handle database of more than 500 GB in size.
• Conducted root cause and analysis for database incidents and problems. Provide 2nd and 3rd level support and rotating on-call support.
• Monitored data activities i.e. database status, logs, space utilization, extents, checkpoints, locks and long transactions .
• Developed and maintained scripts, utility jobs or implement needed software for database maintenance.

Confidential

MS SQL/BI Developer

Hardware/Software:

MS SQL Server 2005/2008 R2, SSRS, SSIS, SSAS, DB2/UDB 9.5, .NET Framework, C , ASP.NET, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access.

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Worked in Active passive cluster environment. Used log shipping for synchronization of databases. Update statistics, database integrity check and Backup operations
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
• Migrating databases from legacy system to SQL server and involving in rewrite codes and validate after migration.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Developed T-SQL for maintaining, developing and creating database and fine tune Stored Procedures and Queries to improve performance of system.
• Proficient in creating and tuning database, developing views and having good exposure of C and .NET Framework.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Developed, monitored and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS SQL server reporting services and SSAS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.

Confidential

SQL Developer

Hardware/software: MS SQL Server 2005/2008, SQL server integration services 2008, SQL server Reporting Services 2008, VSS visual source safe , .NET Framework, ASP 3.0, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Responsibilities:

• Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2008 and Defined the report layout and identified datasets for the report generation.
• Created different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.
• Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as stored procedures, triggers, functions, indexes and views.
• Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a version control.