SUMMARY:

• Senior Database/ETL Developer with six plus years of IT experience in design, development, and implementation experience using SQL Server, Oracle and SQL Server Integration Services.
• Involved in all the stages of Software Development Life Cycle mainly in Database Design, Logical and Physical modeling, Data access and development using MS SQL Server, Oracle and ETL Products and Web Applications development.
• Experienced in developing complex Web applications using .NET, ASP.NET, VB/C# with Visual Studio and version control using Team Foundation Server.
• Advanced knowledge of T - SQL (DDL, DML and SQL CMD).
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS) and Reporting Services (SSRS)
• Strong SQL development skills on developing complex Stored Procedures, Triggers, Views, and User Defined functions.
• Good Experience in Tuning SQL queries & improving the performance of the Database.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks
• Hands on experience in installing, configuring, managing, monitoring SQL Server.
• Experience in troubleshooting, debugging and supporting business intelligence applications in Microsoft Business Intelligence Stack configuration.
• Experience in developing SSIS Packages to extract, transform and load (ETL) data into data warehouse/data marts from heterogeneous sources.
• Extensively worked on Data extraction using the Microsoft DTS/SQL Server integration services, various source transformations, including flat files, XML and relational systems
• Experience in creating SSIS packages, Jobs, Sending Alerts using SQL Mail.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and SSIS.
• Extensive experience in creating enterprise reports using SSRS using Report Manager, Report Builder and BIDS.
• Experience in various Drill Through, Drill Down and parameterized reports using SQL Server Reporting Services.
• Expert in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
• Review, analysis, and modification of programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Worked to establish connectivity between VB, ASP application servers by using ODBC and Maintained existing code and fix bugs whenever needed.
• Adaptable, passionate and project oriented team player with sound communication and leadership skills to develop inventive solution for demanding client needs.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2014/2012/2008 R2, IBM DB2 9.5/9.7, MySQL 4.0/5.0, MS Access, Oracle 11g/10g/9i, Teradata, Amazon Redshift, Amazon RDS and SQL Azure.

ETL Tools: SQL Server Integration Services and Informatica Power Center.

Reporting Tools: SQL Server Reporting Services, Tableau, Dundas Dashboard and Data Visualization components, Pyramid Analytics and Crystal Reports

Languages & Tools: T-SQL, PL/SQL, VB.Net, C#

Tools: /Methodologies: SQL Server Data Tools, Microsoft Visual Studio, Business Intelligence Development Studio, Shell Scripting, UNIX Scripting, TFS, TOAD, Management Studio/Enterprise Manager, SQL Profiler, Tuning Adviser, DTS

Web Technologies: ASP.NET, VB.NET, WSS, MOSS, C#.NET, Asp.net Ajax, Web services, Silver light JavaScript, ADO.Net and Classic Asp

Operating System: Windows Server and RHEL

Web Servers: IIS, Apache Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior Database/ETL Developer

Responsibilities:

• Primarily worked on a project to develop internal ETL product to handle complex and large volume healthcare claims data. Designed ETL framework and developed number of packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local MS SQL 2012 databases to facilitate reporting operations.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Developed Mappings, Sessions, and Workflows to extract, validate, and transform data according to the business rules using Informatica.
• Querying, creating stored procedures and writing complex queries and T-SQL join to address various reporting operations and also random data requests.
• Performance monitoring and Optimizing Indexes tasks by using Performance Monitor, SQL Profiler, Database Tuning Advisor and Index tuning wizard.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Loading Star Schema DW Fact and Dimension tables.
• Primary involvement in all phases of Data Conversion and Migration like Extraction, Analysis, Mapping, Cleansing, Transformation, Test Loading, Error reconciliation, and Production Loading.
• Also worked with Error Handling, Execution Plan, Logging, Configuring Packages and Deploying packages into different environments.
• Extensively worked on SSIS Packages using FUZZY LOOKUP and Merge Table tasks.
• Used various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to Data scrubbing.
• Worked on SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Worked on creating client reports and custom reports (On demand, Ad Hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, etc) using SQL Server Reporting Services 2008R2/2008.
• Developed and schedule reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs
• Resolved locking and blocking issues and Created partition tables for good performance

Environment: MS SQL Server 2014/2012, Oracle 10g/9i, Amazon Redshift, Amazon RDS, SQL Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Share Point, TFS, MS Project and MS Access.

Senior Database/ETL Developer

Responsibilities:

• Designing and developing SQL Server Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Migrating the data from an Access database to SQL Server 2008R2.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Developed mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, normalizer, Router and Mapplets.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows. Also Worked on creating test cases by using Informatica DVO as Testing tool
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Worked on Exception Handling with Try/catch and data access layer development using ADO.NET components.
• R esponsible for ETL operation s using SQL Server Integration Services (SSIS ). Involved for sending and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data)
• Create a Package to update the data warehouse database using SSIS.

Environment: MS SQL Server, Oracle, MS Visio, .NET Framework, SQL Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),Share Point, TFS, MS Project, MS Access, VBA.

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Extensively worked on SSIS Packages for integrating data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Designed database objects like tables, views, indexes, stored-procedures, triggers and cursors.
• Migration of DTS to SQL Server Integration Service (SSIS) and Designing/ Implementing Backup policies for databases.
• Extensively worked on various DDL/DML triggers in SQL Server.
• Creating, maintaining the users, roles and granting privileges and Rebuilding indexes on various tables.
• Wrote SQL stored procedures to implement business logic and Optimized the performance of queries with modifications in T-SQL queries.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services Planned and modified the permission issues in the server.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Database testing, maintaining the data and writing the procedures.
• Fine tuning the Database Settings as well as the Server Settings.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: MS SQL Server, Oracle, MS Visio, NET Framework, SQL Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),SharePoint, TFS, MS Project, MS Access, VBA.