OBJECTIVE:

Experienced data professional seeking a lead role leveraging skills in design, development and operation in the areas of data analysis, data migration, data integration or data warehousing

PROFESSIONAL SUMMARY:

• Extensive experience in the IT industry and skilled in analysis, design, development, maintenance, testing and documentation of large projects in Unix and windows environments
• Experience spans a variety of industries like financial, accounting, publishing, energy, trademark/copyright
• Skilled in leading a team and coordinating with onshore and offshore teams on all aspects of system life - cycle with projects using Scrum-Agile or waterfall methodologies
• Strong experience in collaborating with various business and technical teams in all aspects of data sourcing, data transformations and publishing to various systems
• Excellent understanding of data warehousing architecture and reporting concepts
• Experience in data analysis to identify patterns and relationships in source data
• Expertise in data integration design, development, testing and support using Informatica PowerCenter and PowerExchange
• Strong experience in Informatica administration including performing upgrades
• Strong experience in database application development using SQL server T-SQL, Oracle PL/SQL, Sybase and SQL Anywhere
• Expertise in Unix korn/bash-shell scripting, Unix C development, SQL procedures and performance tuning in Informatica, Sql Server and Oracle
• Experience in data migration to SAP systems, data extraction from SAP Hana and using SAP Hana Studio
• Familiarity with QlikView BI Visualization tool
• Experienced in developing technical documents on design, client environment, implementation, transition and production acceptance
• Demonstrated expertise in Object Oriented Analysis, design and development using Rational methodology and tools.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 5.1/7.1/8.5.1/8.6/9.1/9.5 with Grid option, PowerConnect for SAP/BW & SAP R3, PowerExchange for Mainframe (Striva Detail), MX Views, Business Objects 5.0/6.1b/6.5, BO SDK, SQL Loader

Databases: SQL Server 2012, Oracle 9i/10g/11g, Sybase SQL Anywhere, Sybase System 11, MS Access

Development Tools: SSMS, SAP Hana Studio, RedGate SQL Sentry Explorer, Toad, SQL Navigator, Visual SourceSafe, Visual Studio, PVCS, Rational Rose, IBM SAX Parser

Utilities: TFS, Maestro scheduler, Erwin, Hummingbird Exceed, Remedy, Rational Rose 2000, Fidelity Tracer 2000, RogueWave libraries, Excel, Knowmadic

Programming Languages: Unix Shell Scripts, PL/SQL, Transact-SQL, C, ASP.Net, ADO.Net, VB.Net Visual C++, MFC

Methodologies: Data Analysis, ETL Design, Performance Tuning, Scrum-Agile, Test Planning, Object Oriented Analysis/Design/Programming, RUP, UML, Database Design, SEI/CMM Standards, Structured Programming, Productivity Management

Hardware: Windows 2012R2, Sun Sparc, HP

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead consultant

Responsibilities:

• Responsible for development of Phased Release of metrics (Release 1 and 1.1) related to opportunities (CRM), engagements, revenue growth and profitability
• Performed a key role in integrating opportunity, engagement, Accounts Receivable, time and expense source data from Confidential (SAP ECC / CRM) and HANA for Finance, Accounting and Marketing departments
• Involved in data discovery phase to analyze KPI catalog requirements, create data elements, study the business process, analyze reports and interact with business teams as well as SAP and HANA technical teams to identify the right source for the data elements.
• Analyzed data sources to study and uncover patterns, trends, relationships, and anomalies.
• Involved in gap analysis to identify gaps between requirements and available data elements
• Created mapping documents for each data element between source, staging, warehouse and datamart elements
• Served as Subject matter expert for data extraction from SAP and HANA sources
• Developed stored procedures and table valued functions for data transformation from staging to warehouse and warehouse to datamart, incorporating necessary business rules based on requirements, at each step
• Improved performance in source queries by adopting best practices in query design, indexing and usage of hints
• Identified necessary data quality checks to be performed from staged data and created exception reports.
• Implemented error handling techniques to log run time errors for each batch run
• Created reconciliation queries for engagement related metrics at summary and detail levels
• Key team member in the design of the data warehouse including staging area, warehouse and individual datamarts
• Provided key inputs in the modeling of Kimball’s star schema dimension models
• Developed processes, created technical documents and implemented incremental load using CDC, history tracking through SCD Type 2, Job control
• Created a common master set of reference tables and hierarchy tables to be used across projects
• Created mappings and workflows for each data flow stage. Utilized Informatica scheduler to schedule workflows
• Aided user analysis and reporting with QlikView BI tool by preparing the data for best performance

Environment: Informatica Power Center 9.1/9.5, SQL Server 2012 R2, T-SQL, Excel, SAP HANA Studio, Red Gate Source Control, SQL Sentry Plan Explorer, QlikView

Confidential

Responsibilities:

• Solely responsible for integrating legacy data and creating extracts for the major finance modules: Work-In-Progress (WIP), General Ledger (GL) Trial Balance, GL Cash/Tax
• Designed and created mappings/mapplets for integrating data from the legacy systems to staging, conversion of the data to the target system based on target configurations, extraction of data to a load file in the specified format, sequencing and splitting of files to cater to load programs and improve load performance, creation of delta records to complete the load process for the failed records
• Converted WIP data based on business rules and aggregation of WIP balances for each category (Time, Expense, Billing, Adjustments) and open engagement, product and Business unit
• Created mappings to calculate summary level General Ledger balances for each cash balance and Profit and Loss accounts for each product and Business unit after the month close, based on Chart of Accounts
• Routed error data to error logs to perform error analysis for the clients and to fix data errors before subsequent load cycles to reach a target of zero-error in final production cycle
• Maintained master reference data used across all the modules
• Performed source data profiling before each load cycle and notified clients to assist them in resolving issues at source level
• Created reconciliation queries to perform validations of target against the source at summary and details levels
• Worked on replicating the data migration initiative from Americas region to ASPAC (Asia-Pacific)region
• Worked on automating the process of identifying data quality issues in entities and contacts, reporting to clients and incorporating their feedback in to SAP load.

Environment: Informatica Power Center 9.1/9.5, SQL Server 2012 R2, T-SQL, BCP, Excel

Confidential

Database/ETL Lead Consultant

Responsibilities:

• Designed and developed the complete system workflow
• Improved the measurement, governance, compliance and profitability of the SPV portfolios by classifying and tracking them based on Active, Matured, New, Restructured events
• Enabled monitoring of exposures, reserve and financial losses across all SPV by creating reports on Feed level exceptions, Business Integrity exceptions, day-on-day economic movements
• Developed informatica mappings at every stage - feed level to datamart to datawarehouse
• Created bash shell scripts to process ftp feeds and perform source level quality checks
• Created packages, functions and stored procedures to process business rules and to feed the GUI application and SSRS reports
• Extensively used informatica scheduler to schedule the workflows
• Performed UAT and production roll-outs after every incremental development
• Closely involved with the QA team for test cases and off-shore for development
• Created ETL mapping design, data model and other technical documents

Environment: Informatica Power Center 8.5.1/9.1, Oracle 10g/11g, Toad, PL/SQL, MX Views, Bash shell scripts, Erwin, Visio, HP Quality Center

Confidential

Database/ETL Lead Consultant

Responsibilities:

• Developed a reporting solution to enable S&P to administer and manage current and new regulations, policies, risks and controls, track policy changes, associated business controls and risk profiles of those controls.
• Setup a datamart and designed and developed ETL mappings to move data to datamart from ODS database that houses the application data.
• Worked on a dimensional data model for policy, risk, quality and various metrics like market share, new issues, ratings
• Created Unix korn shell scripts to schedule and run jobs on a monthly and daily basis
• Involved in integrating team’s work and moving to QA and production

Environment: Informatica Power Center 8.1.1, Oracle 10g, Erwin Toad, PL/SQL, Korn Shell scripts, Sun Solaris 10, Scrum-agile methodology, BO XI reporting

Confidential

Responsibilities:

• Set up Informatica 8.6.1 development environment and administered users
• Led the design and development of a variety of mappings using Informatica 8.6 to source, transform and load data elements on a daily basis from Capital IQ and World Insight sources through Unix nightly batch jobs
• Worked on data discovery, sourcing and ETL specifications
• Designed access permissions for relational and XML database users through various roles
• Led the database team in designing and setting up of the XML Database environment - created resources for different story types to store corresponding XML content
• Worked closely with the centralized DBA team in setting up db environment and on-going db modifications
• Created views and stored procedures for access of instrument data by application developers
• Worked in scrum-agile setting, involved in story/task planning, estimating, weekly review and provided daily status reports to client

Environment: Informatica Power Center 8.6.1, Oracle 11g, Oracle XML, Oracle web service, Toad, PL/SQL, Korn Shell scripts, Sun Solaris 10, CVS, Remedy, Scrum-agile methodology

Confidential

Principal Consultant/Lead Developer

Responsibilities:

• Designed and developed a variety of mappings using Informatica ETL tool. The transformations included normalizer, aggregation, joiner, stored procedure, lookups among others to source, transform and load stage data to NODS and DDS databases on a daily basis through Unix nightly batch jobs scheduled on Maestro scheduler.
• Developed and maintained PL/SQL stored procedures for calculating average market prices, daily profit & loss, trade volumes and broker fees.
• Created ad-hoc SQL queries for reporting and populating missing data from source
• Resolved business and performance issues related to mappings
• Improved performance of sessions and rectified schedule overruns. Monitored session failures and resolved them early.
• Created Unix scripts for repository backups, running workflows, sending e-mail alerts, setting up process dates and other admin tasks
• Proficient in powercenter admin console to perform administrative tasks such as creating new users, assigning restricted permissions to access repository and integration services, restarting repository and integration services, repository backup and recovery and resolving licensing issues
• Utilized Informatica Debugger, session logs and Toad to resolve problems in a timely manner.
• Worked on Informatica upgrades to 7.1.3 and 8.5.1. Involved in estimation, project planning and implementation, test plans and performance monitoring. Tightened up security privileges to conform to Sarbanes-Oxley
• Set up Informatica web service for clients and administered web service hub
• Analyzed metadata and developed reports on sessions, run time, tables with rejected rows using MX views
• Analyzed mappings, stored procedures and table indexes to improve performance
• Worked with DBAs in creating database partitions for large size tables to improve selects/updates and establish export procedures
• Mentored junior team members on design and development issues.
• Coordinated with off-shore team to resolve high-priority production issues
• Performed leadership role in conducting bi-weekly client meetings, tracking action items, project statuses and overseeing tasks to closure
• Streamlined earlier work by cleaning up unused scripts and centralizing e-mail contacts
• Well versed in interacting with informatica support staff and using their velocity best practices
• Developed applications using Knowmadic tool to automate file downloading/web scraping of data from secure web sites (using login/certificates) of regional transmission organizations on an hourly/daily basis, processed and stored them in staging databases.
• Implemented a Disaster Recovery environment for production

Environment: Informatica Power Center 7.x/8.5.1, Oracle 9i/10g, MX Views, Toad, PL/SQL, Korn Shell scripts, Maestro scheduler, Knowmadic, Sun Solaris, PVCS, Remedy

Confidential

Responsibilities:

• Involved in maintenance and enhancements of the data warehouse and data integration process of the system
• Monitored production jobs and resolved issues within the response and resolution times in SLA
• Developed ad-hoc sql queries for reporting purposes and stored procedures to update parameters and prepare for batch runs
• Created a grid environment with the main processing in a powerful server and repository in a different server thereby resolving reporting issues and database update issues over WAN
• Created shell scripts for pre and post session commands, run workflows and modify parameter files
• Implemented upgrade of the system to Informatica 7.1.5 and 8.5.1
• Resolved licensing issues for SAP connectivity
• Installed SAP programs in stream mode and tested workflows for SAP connectivity to obtain personnel and work order information from SAP R/3 source
• Designed mappings calling SAP functions to provide data for reporting purposes
• Used session parameter files to control weekend and month end processing
• Resolved issues related to missing or incorrect data in BO reports by analyzing the root-cause of the problem
• Resolved replication problems between master and 11 local oracle database servers thereby maintaining the integrity of the data.
• Maintained a knowledge repository of frequent and unique problems and their solutions for use by the team. This helped in greatly reducing the time for resolving problems.

Environment: Informatica 7.1/8.5.1 in grid environment, PowerConnect for SAP, Oracle 9i/10g PL/SQL, Toad, Sybase SQL Anywhere, Visual C++, Transact-SQL, PVCS, Solaris 9/10, Maestro scheduler

Confidential

Responsibilities:

• Developed Informatica mappings to perform complex processing as per requirements
• Used informatica partition to improve session performance
• Expertise in using Striva Detail tool (PowerExchange) to exchange data with mainframes
• Using PowerExchange client, created new datamaps for the VSAM files and imported the datamaps to the repository
• Effectively used grid option to enable jobs to be run on powerful servers.
• Tested mappings for accuracy and performance - used Quality Center for creating functional and detailed test plans
• Coordinated UAT and resolved problems
• Set up, implemented and documented Disaster Recovery procedures
• Worked as a team in developing a system in VB.Net to automate downloading of hourly data from PJM website thereby saving time and improving the productivity of the system instead of relying on a different source for the same data.
• For a different part of the same project, played a lead role in successfully transitioning the project and coordinated in outsourcing certain aspects of the operations to Indian team.
• Met with client on a weekly basis in reporting key issues and their resolutions

Environment: Informatica Power Center 7.1.5/8.5.1 with grid option, Oracle 9i/10g, Solaris 9/10, Toad, Korn Shell Scripts, Maestro scheduler, Striva Detail (PowerConnect), VB.Net, ADO.Net, Remedy, Quality Center

Confidential

Responsibilities:

• Maintained a system to automate tracking of railcar movement, their expected time of arrival at destinations and information about lost and stagnant cars using Knowmadic (a web extraction tool). This information was posted to a website using ASP and also e-mailed to client on a timely basis.
• Interacted with vendors for problems regarding missing/incorrect information in web sites.
• Worked with DBAs in creating right privileges for developers/users as per company policy for IT for Sarbanes Oxley
• Set up and maintained Knowmadic repository in Sql Server 2000

Environment: Knowmadic, SQL Server 2000, IIS 6.0, ASP

Confidential

Responsibilities:

• Developed enhancements to Business Objects Web Intelligence reports from data gathered from SQL Server 2000 and PI (proprietary database)
• Created and maintained user accounts in Supervisor
• Modified Universe and stored procedures as per user requirements.
• Performed performance tuning on critical reports.
• Created and scheduled DTS packages to move data from PI to SQL Server
• Developed VB code using BO SDK for refreshing developed reports at periodic intervals
• Developed VB code to e-mail clients about the server/service live status

Environment: Business Objects 6.1 full-client, Webi, BO SDK, Sql Server 2000, DTS, Transact-SQL, VB 6.0

Confidential

Responsibilities:

• Reponsibilities included creating Stored procedures, creating SQL scripts, analyzing and resolving performance issues, sql tuning, assisting DBA with database creation, using DTS to transfer data

Environment: Sql Server 2000, DTS, Transact-SQL, Oracle PL/SQL