SUMMARY

• 8 + years of strong IT experience in SQL Server 2008 R 2/2008/2005/2000 development & support;
• Highly experienced in SDLC and Agile environments across healthcare, banking, and hospitality domains;
• Strong experience in preparing and delivering drill down, slice and dice reports, parameterized reports, Linked reports, and Snapshots using SQL Server Reporting services (SSRS) using 2008 R 2/2008/2005/2000 ;
• Strong Experience in creating report server model designer;
• Extract Transform load (ETL) using SQL Server Integration Services (SSIS) 2008 R2/2008/2005;
• Experienced in installing, configuring and deploying MS SQL Server suite of products that includes SQL Server Integration Services, SSRS, SSAS;
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS;
• Dimensional Data Modeling and Cube Development in SQL Server in SQL Server 2008 R2/2008/2005;
• Experience in data normalization and data modeling using Erwin;
• Working Experience in documenting complex database applications, and data;
• Strong knowledge in SQL Server disaster recovery, backup/restore, migration and upgrade participated in disaster recovery drills;
• Hands - on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and troubleshooting deadlocks in SQL Server 2008 R2/2008/2005;
• Database consistency checks using DBCC Utilities;
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, Job Scheduling and SSIS Package Designer;
• Transformed data from one server to another using Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension;
• Experience in defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services;
• Excellent multi-tasking capabilities including multiple client interaction; and
• Excellent communication, analytical, interpersonal, presentation, project management skills and ability to work with minimum supervision in large and small teams.
• Data Modeling with Erwin
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures
• Extract Transform load (ETL) using SQL Server Integration Services (SSIS) 2012/2008 R2/2008/2005
• SQL Server Reporting services (SSRS) 2012/2008 R2/2008
• SQL Server database performance monitoring
• Project Management including requirement gathering in SDLC and Agile environments
• Having Expertise in supporting team Offshore model using VPN (Nortel Networks.)

TECHNICAL SKILLS

Operating Systems: Windows 2008 Server/7/ Vista/XP/2003 Server/2000

RDBMS: MS SQL SERVER 2008 R2/2005/2000, MS Access, Oracle10g/9i/8i

Database Tools: Management Studio, Business Intelligence Development Studio, SQL Enterprise Manager, SQL Server 2005, Query Editor, Reporting Server, SQL Query Analyzer, and MS-Access

ETL Tools: Data Transformation Services (DTS), and MS SQL Server Integration Services (SSIS) 2008 R2/2005

Reporting Tools: MS SQL Server Reporting Services (SSRS) 2008 R2/2005

Data Modeling: MS Visio 5.0, ER-Win

BI Tools: MS SQL Business Intelligence 2008 R2

Languages: SQL, T-SQL, and PL/SQL

Agile & PM: Rally for Agile Development

PROFESSIONAL EXPERIENCE

Confidential, Plano TX

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements and designed normalized and de-normalized tables and relationships using agile methodology including Data Modeling with Erwin;
• Developed Database for VTouchBase Campaign Manager, Template Manager, and Admin Manager. The Template manager includes various templates for claims processing notifications;
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2008 R2/2008/2005 followed by analysis and testing of those database objects before deployment to the production server;
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers;
• Identified, tested, and resolved performance issues of poorly running queries and performance of database itself by using Index Tuning Wizard, SQL Profiler, and Query Analyzer. Also monitored Deadlocks in SQL server using SQL Server Profile in SQL Server 2008 R2/2008/2005;
• Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance;
• Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default;
• Set Physical Security of SQL Server, to prevent unauthorized users from accessing the servers;
• Designed and developed Data Warehouse processes. Mapped disparate data sources - flat files, Excel spreadsheets, Comma Separated Value files and Tab delimited text files using various transformations to target schema;
• Designed Extraction Transformation and Loading (ETL) process to source and scrub data in a landing temporary table as well as legacy data sources using SSIS in SQL server 2008 R2;
• Well versed with different components of SSIS (Control Flow, Data Flow and Connection Manager) while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks;
• Highly experienced in developing SSIS complex and multistage SSIS packages using various tasks such as For-each-loop, Execute Process Task, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task, FTP Task, File System Task, Send Mail Task, Bulk Insert Task;
• Created Master SSIS packages in order to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use to other team members;
• Implemented data warehouse design principles and Best Practices for maintaining dimension and fact tables;
• Developed analytical and transactional reports using SSRS 2008 such as open rates, bounce rates, click rates, invalid rates, duplicate rate, opt out rate. Developed reports based on OLAP cubes. Developed ETL process monitoring reports. Used Report Builder to develop ad-hoc reporting;
• Used SSRS Reporting services (SSRS 2008 R2/2008) to write complex formulas and to query database to generate different types of reports (Drill Down, Drill Through, Linked, Sub-reports, and Parameterized) for Business Intelligence;
• Created views as required by front-end developer for easier implementation on Java Server Pages pages, and wrote instead-Of Triggers on those views to provide efficient Data Manipulation;
• Created, updated and maintained ETL Technical Documentation for future reference by other team members;
• Worked with SQL Server Agent to create the job and monitor closely for job run; and
• Worked in a team of 6 which includes Business Analysts, Data Architect, Database Developers, J2EE Developers, and Project manager.

Environment: MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, ER Win, J2EE, Windows XP, Fedora Linux, and Rally.

Confidential, Chicago, IL

SQL Server ETL Developer

Responsibilities:

• Analyzed requirements and designed normalized and de-normalized tables and relationships using SDLC methodology including Data Modeling with Erwin;
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2008 R2/2008/2005 followed by analysis and testing of those database objects before deployment to the production server;
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers;
• Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance;
• Designed and developed Data Warehouse processes. Designed and developed stage data model and dimensional data model for data warehouse. Mapped disparate data sources - relational Databases and text files onto target schema;
• Designed Extraction Transformation and Loading (ETL) process to source from Oracle applications as well as legacy data sources. Developed ETL processes to source data from flat files using SSIS 2008. Designed ETL processes to load fact and dimension tables in data warehouse;
• Developed T-SQL functions and stored procedures. Developed SSIS complex and multistage SSIS packages using For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task;
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation. Scheduled the ETL processes on SSIS server and managed integration server;
• Designed indexes to tune the ETL process performance. Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification. Developed ETL auditing system using SSIS Event Handler and Custom Scripts;
• Developed analytical and transactional reports using SSRS 2008. Developed reports based on OLAP cubes. Developed ETL process monitoring reports. Used Report Builder to develop ad-hoc reporting for ETL QA as well as for DW UAT process;
• Created, updated and maintained ETL Technical Documentation for future reference by other team members;
• Worked with SQL Server Agent to create the job and monitor closely for job run; and
• Worked in a team of 5 which includes Business Analysts, Data Architect, Database Developers, and Project manager.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL.

Confidential, NJ

SQL Server ETL Developer

Responsibilities:

• Analyzed requirements and designed normalized and de-normalized tables and relationships using SDLC methodology including Data Modeling with Erwin;
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2005 followed by analysis and testing of those database objects before deployment to the production server;
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time. Also monitored Deadlocks in SQL server using SQL Server Profile in SQL Server 2005;
• Created DTS Package to transfer data from the Oracle source database. Modified DTS to SSIS packages to accomplish critical business logic;
• Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases. Logical Data Modeling using ER-Win to fit business requirement;
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing. Created check constraints to maintain data integrity;
• Developed SSIS complex and multistage SSIS packages using For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task;
• Data migration (import & export/BCP) from Text to SQL Server. Configured Replication Server. Planned complete Back-up of Database and Restored the Database from Disaster Recovery. Generating ad-hoc reports using MS-Excel and Crystal Reports;
• Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default;
• Used SSRS Reporting services (SSRS) to write complex formulas and to query database to generate different types of reports (Drill Down, Drill Through, Linked, Sub-reports, and Parameterized) for Business Intelligence;
• Coordinating post-implementation events such as testing;
• Implemented data warehouse design principles and Best Practices for maintaining dimension and fact tables;
• Created, updated and maintained ETL Technical Documentation for future reference by other team members;
• Worked with SQL Server Agent to create the job and monitor closely for job run; and
• Worked in a team which includes Business Analysts, Data Architect, Database Developers, and Project manager.

Environment: MS SQL Server 2005/2000, SSIS, SSRS, T-SQL, DTS Windows 2003 Server, ER-Win.

Confidential

SQL Server ETL Developer

Responsibilities:

• Involved in configuring and converting MS SQL Server 6.5 database to MS SQL Server 7.0. Partially involved in Database design and Database objects. Created backups for databases. Partly Involved in Performance tuning;
• Created DTS Package to transfer data from the Oracle source database. Modified DTS packages to accomplish critical business logic;
• Responsible for Developing GUI Screens. Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system;
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers;
• Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default;
• Created, updated and maintained ETL Technical Documentation for future reference by other team members;
• Responsible for creating COM Components using Active X DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions. Developed various management reports using Crystal reports. Maintain the application as per the user requirement.

Environment: SQL Server 2000, Crystal Reports, Access, Excel.