SUMMARY:

• 17+ years of IT experience in Microsoft,Oracle and Sybase D Confidential bases with various Industry verticals like Banking, Healthcare, Insurance, Manufacturing, Retail and Government as a Sr. D Confidential Warehouse ETL Developer, lead software Engineer, lead D Confidential base developer, sr. D Confidential base analyst, BI Developer in MS SQL server 2012/2008R 2/2008/2005/2000 and Oracle /11 g /10 g d Confidential bases.
• Strong experience in Extraction, Transformation and Loading (ETL) d Confidential from various sources into D Confidential Warehouses and D Confidential Marts using WhereScape red, SSIS and Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor) on Oracle, and SQL Server D Confidential bases.
• Excellent knowledge in creating D Confidential bases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define d Confidential types, Cursors and Indexes using T - SQL and PL/SQL.
• Experience in D Confidential 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 teh 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 d Confidential using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Terad Confidential, 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 d Confidential reconciliation and scheduling with WhereScape scheduling tool, Active batch, UC4 and SQL Agent.
• Experience in Designing and Building teh 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 teh d Confidential 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 teh reports and assigning permissions to teh valid users for executing teh 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 d Confidential base performance using tools like SQL Profiler, Index Tuning Wizard, D Confidential base 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 teh accuracy of teh d Confidential .
• Experience in Configuring and Managing Linked Servers, d Confidential transfer between SQL Server and other heterogeneous relational d Confidential bases 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) principal/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)

D Confidential base: 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:

Developer,

Confidential,

Responsibilities:

• Parsed high-level design specification to Create ETL & ELT process using SSIS & WhereScape Red.
• Designed and customized d Confidential models for supporting d Confidential from multiple sources in real time.
• Involved in building teh ETL architecture and Source-to-Target mapping to load d Confidential into ODS, d Confidential warehouse.
• Created mapping documents to outline d Confidential flow from sources to targets.
• Educating end users on how to use ODS, D Confidential 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 d Confidential models for D Confidential warehouse supporting d Confidential from multiple sources on real time
• Involved in building teh ETL architecture and Source to Target mapping to load d Confidential into D Confidential warehouse.
• Created mapping documents to outline d Confidential flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of teh D Confidential warehouse and used power designer to design teh business process, dimensions and measured facts.
• Performing system analysis, estimating work effort and writing design documents dat 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, d Confidential 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 teh users to discuss business logic and workflow of teh new modules
• Responsible for logical and physical design with a significant effort toward application and d Confidential base tuning.
• Created and maintained stored procedure, trigger and optimize teh SQL and stored proc.
• Created Complex query and report using session or temporary table.
• Created or managed table, view, indexes and other d Confidential base related task.
• Responsible for collecting specifications, technical analysis and technical reviews with client. Involved in Technical design and development of teh 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 teh system.

Environment: Oracle8i, Powerbuilder8

Confidential,

Responsibilities:

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

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

Older Relevant Work History Includes:Consultant at Confidential Global Services Sweden

Environment: SQL SERVER 2000/ SYBASE 12.5, PowerBuilder 9, Omnis Reports, Crystal Reports, PFC Consultant at Unified Freight System

Environment: Oracle 8i, AIX, PowerBuilder 8, PFC, UFEConsultant at Confidential America

Environment: Oracle 8i, UNIX (HP-UX), PowerBuilder 7, PFC Consultant at Contour Financial

Environment: Sybase 11.5, Window NT, PowerBuilder 6.5, PFC