SUMMARY

• 17+ years of IT experience in Microsoft,Oracle and Sybase Databases with various Industry verticals like Banking, Healthcare, Insurance, Manufacturing, Retail and Government as a Sr. DataWarehouse ETL Developer, lead software Engineer, lead Database developer, sr. Database analyst, BI Developer in MS SQL server 2012/2008R 2/2008/2005/2000 and Oracle /11 g /10 g databases.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into DataWarehouses and Data Marts using WhereScape red, SSIS and Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor) on Oracle, and SQL Server Databases.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define data types, Cursors and Indexes using T - SQL and PL/SQL.
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using ERwin Tool and Microsoft Visio.
• Good hands-on experience in using all kinds of SQL Server and Oracle Constraints, writing SQL (T-SQL and PL/SQL) Queries & Dynamic-queries.
• Experience in writing complex T-SQL and PL/SQL queries using Inner, Outer and Cross Joins.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Excellent in High Level Design and migration of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata, access) by using multiple transformations provided by SSIS and informatica
• Extensive experience in upgrading SQL Server and migrating DTS Packages
• Experience with ETL framework standards, including error processing, validation and data reconciliation and scheduling with WhereScape scheduling tool, Active batch, UC4 and SQL Agent.
• Experience in Designing and Building the Dimensions and cubes with Star Schema using SQL Server Analysis Services (SSAS).
• Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2012/2008/2005 .
• Created Parameterized reports, Sub reports and thorough knowledge of reporting server architecture. (Table, chart and matrix reports).
• Experience in creating roles, administrating the reports and assigning permissions to the valid users for executing the reports.
• Hands on experience in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server 2012/2008R2/2008/2005/ and applying service packs and hot fixes and unattended Installation.
• Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience on Ref Cursor, External Tables, Collections and Exception Handling.
• Experience defining and building audits and controls to ensure the accuracy of the data.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle, DB2 etc.
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
• Experience in using Automation Scheduling tools like Active batch, UC4 and SQL server agent
• Good knowledge of Software Development Life Cycle (SDLC), Agile Methodology, Application Lifecycle Management (ALM), and Technology Project Management (TPM) principle/guidelines.
• Expertise in Maintaining, supporting and troubleshooting applications and fixing bugs.
• Additional responsibilities include setting quality standards, enforcing efficient quality control across systems, code walk-through.
• Ability to multi-task, highly result oriented, and possess strong soft skills to be effective in a team.

TECHNICAL SKILLS

• Languages & Platforms: Visual Studio 2012/2010/2008, Sharepoint2010, IIS 6/7, ASP.NET MVC, C#, XML, XSLT, XSD ADO.Net, .Net 4.0, PowerBuilder 11.0.02, PowerBuilder Foundation Classes (PFC), JavaScript, HTML, Citrix server, Power Shell Script, Active batch & UC 4 automation tools, UNIX, Shell Scripting, EMC xPression 4.5 (xDesign, xAdmin,xDashBoard)
• Database: MS SQL Server 2012/2008R 2/2008/2005/2000, Oracle 11gR2/11g/10g, Sybase 15/12.5, Access 2007/2003
• DB Utilities: SQL Server Management Studio, Query Analyzer, SQL*Plus, SQL Builder, Power Designer, Erwin, PL/SQL Developer, Toad, DBArtisan
• Reporting: Crystal Report 10, Business Object (Deski, Webi), MS Access, Excel, SSRS, COGNOS
• ETL & BI Tools: WhereScape Red 6.6, SSIS, SSRS, SSAS, DTS, Informatica Express9.6.1, Informatica Power center, SQL*Loader
• Change Management Tool: TFS, VSS, PVCS, Clear Case,

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Parsed high-level design specification to Create ETL & ELT process using SSIS & WhereScape Red.
• Designed and customized data models for supporting data from multiple sources in real time.
• Involved in building the ETL architecture and Source-to-Target mapping to load data into ODS, data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Educating end users on how to use ODS, Data Warehouse structures and resources.
• Create user documentation, scheduling meeting to discuss key topics and responding to questions from end users

Environment: WHERESCAPE RED 6.6, SSIS, SSRS, SQL SERVER 2012, VS2012/2010, BO (Webi and Deski), TFS,Oracle 11g

Confidential,

Responsibilities:

• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used power designer to design the business process, dimensions and measured facts.
• Performing system analysis, estimating work effort and writing design documents that meet requirements.
• Design and develop ETL using SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Created XML Schema and xpath definition for XML using XSLT. Converted XML to formatted output using XSLT Transformations.
• Migrated/Re-wrote DTS Package to SSIS Packages using SSIS Server.
• Automated SSIS using Automation tool (Active Batch) and SQL Server tools.
• Created SSIS Package for Automated Check Print and Correspondences letter & kit print from xPression server
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Created Drilldown, Document level, matrix report using SSRS and IIS server.
• Migrated all crystal report to SSRS report for CLTCAS/NLTCAS System

Environment: SQL SERVER 2012/2008/2005, VS2012/2010, ASP.Net, Crystal Report, SSAS, SSIS, SSRS, Powerbuilder11.2, TFS, PFC, xPression 4.5 (xDesign, xAdmin), Informatica Express 9.6.1

Confidential,

Responsibilities:

• Involving in Analysis, design, development (new development & enhancements) maintenance and production support. Interacting with the users to discuss business logic and workflow of the new modules
• Responsible for logical and physical design with a significant effort toward application and database tuning.
• Created and maintained stored procedure, trigger and optimize the SQL and stored proc.
• Created Complex query and report using session or temporary table.
• Created or managed table, view, indexes and other database related task.
• Responsible for collecting specifications, technical analysis and technical reviews with client. Involved in Technical design and development of the system.
• Preparing detailed document specifications, Integration & unit Test cases (Test Plans)
• Design and Created touch screen based application point of care (POC) for Assist Living facility

Environment: Sybase15/SQL SERVER 2000, Powerbuilder10.5 & 9, PFC, CDE.

Confidential,

Responsibilities:

• Involving in analysis, design, development (new development & enhancements) maintenance and production support. Interacting with users to discuss business logic and workflow of new modules.
• Created and maintained stored procedures, triggers and optimized existing SQL and stored procs.
• Responsible for collecting specifications, technical analysis and technical reviews with client. Involved in Technical design and development of the system.

Environment: Oracle8i, Powerbuilder8

Confidential,

Responsibilities:

• Collected user requirements, analysis, design (GUI & Database) and developed the system. Interacted with the users to discuss business logic and workflow of the all the system. Created technical design document, Integration and unit test cases.
• Designed (GUI & Database) and developed Business Objects using non-visual user object and created new ancestors for data entry validation and template creation. Extensively utilized tree view and tab controls linked to data window.
• Utilized advanced PowerBuilder techniques: multiple inheritance, wizards, non-visual user objects, OLE, drop down and shared data windows, composite data window, nested reports and xml template.
• Created interface with MS active directory using LDAP protocol and used SMTP protocol for sending email to the concern managers.
• Used OLE controls to connect and retrieve data from/to Excel spreadsheet.
• As a database developer, responsible for database schema, writing stored procedures, triggers, business analysis, design and implementation.

Environment: SQL Server 2000, DTS, Powerbuilder10, ASP, JavaScript.