SUMMARY

• 10 years of professional experience in IT Industry wif expertise in Development and Implementation of Data Warehouse applications and architecture.
• Experience wif Derivatives both OTC and ETD operations and reconciliations.
• Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter 8.5/7.3/6.2
• Experience in TOAD, Explain Plan, Ref Cursors, Constraints, Triggers, Indexes - B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links and Export/Import Utilities.
• Involved in the full development lifecycle from requirements gathering through development and support for retail, banking and communications industries using Informatica PowerCenter, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Worked extensively on sources/targets like SFDC, Flat Files, XML, SAP, PeopleSoft, Relational databases etc.
• Strong knowledge in all phases of Software Development life Cycle (SDLC) and application ILM (Informatica Life Cycle) wif experience in Financial, Manufacturing, Insurance and Retail Domain.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.
• Business Domains: Banking, Non-Profit, Finance, Health Care, Insurance, Pharmaceutical, Oil and Gas.
• Asset Management, Client, Delivery, Automate, Clients, Designing, Finance, Informatica, Memory, Migration, Developer, QA, Servers, SQL, T-SQL, Web Intelligence.
• Backup, Data Analysis, Documentation, Financial reports, Explorer, Excel, Enterprise, Oracle PL/SQL, Read, Scripts, Strategy, UNIX, Workflow.
• Data Warehousing Tools Informatica PowerCenter 9.6/9.1/ 8.6/7.3/6.2 Business Objects 5.1/6.2, SSIS, SSRS, OBIEE, Cognos EBusiness Suite, Micro Strategy, SQL, PL/SQL, shell scripts, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, Toad 8.0, Windows 2000, XML, UNIX.
• Strong working experience on IDQ (Informatica Data Quality) which involves developing plans.
• Used informatica web service transformation to read data from a web service source and write data to a web service target
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Interacted wif business partners and Vendors to identify information needs and business requirement and reporting.
• Involved in Project Management, Collaborative problem solving and decision making.
• Data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimensions tables, physical and logical data modeling OLAP and Report delivery methodologies.
• Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and Excel
• RDBMS Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 R2, MS Access, DB2, Teradata 13.
• AS400, Decision support, XML, Informatica 9, MB, Word, Oracle database, Quality, SAP R3, Loader, Toad 8.0, VC++.
• Business Analysis, Data integration, EBusiness, FTP, Java script, Exchange 8.6.1, ODS, PL/SQL, Relational Database, Shell Scripts, System Integration, UNIX Shell Scripting.
• Used Data collection in B2B to gather data from external sources using managed file transfer, using secured communication protocols S/FTP, HTTP/S.
• Installation and configuration of Applications on servers and client environments.
• Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
• Operations Monitoring, Policy evaluation, Disaster recovery, Network development and administration.

PROFESSIONAL EXPERIENCE

CA PPM/Apptio/Miro/Informatica -Sr. Project Manager

Confidential - Chicago IL

Responsibilities:

• Developed periodic goals, organized the work, set short-term priorities, monitored all activities, and ensured timely and accurate completion of the work by employees and outside technology contractors.
• Provided input into performance management and career development processes and staffing and disciplinary actions.
• Maintained risk management and compliance programs and activities for their assigned groups.
• Identified business needs and develops conceptual systems design.
• Analyzed existing test environments, technology stack, app configuration mapping, infrastructure needs, interfaces, components & batch inventory by apps.
• Completed status reporting for projects.
• Advised systems staff on the impact of systems enhancements to existing designs.
• Provided project planning including docket prioritization and budget considerations.
• Markets systems products and services to other partners or clients
• Carried out complex activities wif significant financial, client, and/or internal business impact.
• Ensured compliance wif all audit requirements including change control procedures and data security.
• Communicated wif various business areas and outside vendors, consultants, and clients regarding automation needs.
• Provided feedback to vendors on contractor(s) performance and recommended changes.
• Managed daily operational activities and supervised day-to-day work of project team employees.
• Managed all system and code change requirements wif code development and DB Teams including CRQ Management.

DB Tech Support Lead

Confidential - Evansville IN

Responsibilities:

• Prepared/shared environment questionnaire to identified stakeholders that includes app owners, SMEs, infrastructure teams, application/tool support teams, infrastructure manager, DB support teams, network support teams, monitoring tool support teams.
• Conducted interviews and break-out sessions wif identified stakeholders to collect, analyze and clarify environment information.
• Analyzed existing test environments, technology stack, app configuration mapping, infrastructure needs, interfaces, components & batch inventory by apps.
• Build strategy, plan, timelines and resource requirements for standing up test environments for applications in scope.
• Build component inventory/technical solution design doc for the environment build inclusive of monitoring of applications and dependent components.
• Review recommendations and build strategies wif approvers and get sign-off.
• Define detailed RACI across the build phases and submit a SOW for build phase.
• Health Check Automation
• Prepared/shared health check automation questionnaire to identified stakeholders that includes app owners, SMEs, infrastructure teams, application/tool support teams, monitoring tool support teams.
• Conducted interviews and break-out sessions wif identified stakeholders to collect, analyze and clarify health check information and requirements.
• Tool evaluation for environment monitoring.
• Analysis of monitoring parameters and thresholds required in the target state.
• Defined environment monitoring strategy.
• Analyzed smoke testing scenarios for all in scope applications.
• Analyzed data and workflow dependencies needs for the identified scenarios to be executed.
• Assessment of automation tools and framework that needed to be leveraged/built for developing smoke tests.
• Defined smoke test automation/health-check strategy.
• Reviewed recommendations and strategies wif approvers and got sign-off.
• Analyzed solution defined in each of the capability tenets and created Wave 1 Build strategy, plan and roadmap.

GMI DDM C&IS /Cluster Lead /ETED SQM Support Lead

Confidential - Chicago IL

Responsibilities:

• Worked wif Business users and Management for requirement gathering (BRD), Business analysis and translated the business requirement into technical specifications to provide Production level 1 and level 2 Support for Applications GMI and DDM both OTC and ETD.
• Set team goals, priorities to meet SLA’s both in Prod and UAT to meet business needs.
• Worked closely wif vendors like FIS and Business partners to ensure product support and upgrades and was involved in management of new custom implementations in GMI Application.
• SQM- Enterprise INT/UAT Support, Environment reservations, Project support, Test data planning, Incident coordination, Batch Monitoring (Mainframe and Distributed), Incident Resolutions and Health Checks.
• Configuration change, Problem and Knowledge Management for over 109 TLA’s in scope.
• Interacted wif Technical, Functional and Business Audiences across different phases of the project life cycle.
• Prepared the Standard Operating Procedures (Knowledge Transfer) documents, KEDB Articles which provides necessary information, required for the Maintenance and Operations of the Applications.
• Vendor Management FIS and open tickets resolution and custom Business development.
• Monitoring Broker Feeds Daily feeds, Pricing and Reports process and scheduling Control-M jobs.
• Management support duties including work assignment, CRQ approvals, meetings and Information sharing etc. in lieu of Manager’s absence.
• Capacity forecasting, Close price monitoring, INC ‘s, WSR, MSR, Health Check Reporting and meetings.
• Disaster Recovery coordination and Fire Call/Swat Call handling/Escalations.
• CRQ Approvals, Escalation and WMOM meetings.
• Squirrel SQL INC resolutions and Business user support.
• Dashboard Management updates, Production installations and UAT testing, JIRA Tasks for UAT Development.
• KT Sessions on key TLA’s and Business functions to different groups and teams.
• FIS weekly meetings and job assignments including quarterly upgrades.
• Created and released requests for QA Builds to include all the release requirements and was involved in the implementations of QA, UAT and Production Release.
• Developed a UNIX Shell script which will send the reports to clients over the network using file transfer protocol (FTP &SFTP) and generating the log file, which maintains the history for the FTP reports.
• Provided Data loading, Monitoring, System Support and worked on data issues raised by end user during Applications production support phase.

Informatica Admin/IDQ Consultant

Confidential - Dallas, TX

Responsibilities:

• Production Support and Issue resolutions.
• Developed ETL procedures to transform the data in intermediate tables according to the business rules and functionality requirements.
• Involved in the development of Informatica mappings and tuned for better performance.
• Provided upgrade and configuration support as part of administration.
• Migration of data from Oracle 11g to Oracle Exadata.
• Worked on Data integration from various sources into ODS using ODI (Oracle data Integrator).
• Calculated the KPI’s and worked wif the end users for OBIEE Report changes.
• Success factors of integration includes, historical data, data archiving strategy, cache sizes calculations on the server etc.
• Created Schema Objects like Indexes, Views, Sequences and integrated data from DB2 to SQL Server.
• Involved in Unit Testing of Mappings, Workflows and debugging Mappings for failed sessions.
• Performed unit testing and system testing of the mappings developed and documented wif various scenarios.
• Written Unix shell scripts for repository backups, job scheduling and Crontab etc.

Informatica Admin/Sr. lead Developer

Confidential -Houston, TX

Responsibilities:

• Designed, developed, implemented and maintained Informatica Power Center and IDQ 8.61 application for matching and merging process.
• Informatica Data Explorer (IDE) AND Informatica Data Quality (IDQ 8.6.1) tools are used along wif IDE for data profiling over metadata and data quality measurements.
• Developed mappings and workflows which supported the mappings in PowerCenter and MDM.
• Custom Mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server and XML files.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and Unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator Transformations.
• Worked on Migration of Mappings from Data Stage to Informatica.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of Workflows in Control -M.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce DISK me/O and Sorts.
• Administrative role and monitoring and support for several projects in Staging and Production Environments for Informatica and OBIEE.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Prepared knowledge documents and Disaster Recovery procedures for Production Server application and Maintenance.

Sr. Informatica Developer/Oracle Developer

Confidential -Houston, TX

Responsibilities:

• Designed the ETL process for extracting data from heterogeneous source systems, transform and load into Data Mart
• Designed data model using Erwin 4.2.
• Involved in Upgrading Informatica from version 8.6 to 9.0.
• Created copies for the non-production environments by masking the data to make sure test and development processes are not exposing sensitive information.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Responsible for testing different versions of Informatica and resolving the issues identified in the new version wif the Informatica Support Team.
• Performance tuning was done for various facts and dimension maps to reduce the load time.
• Developed various mappings & mapplets to load data from various sources using different transformations like,
• Expression, Lookup, Aggregator, Update Strategy, Union, Joiner, Normalizer, Sorter, Source Qualifier, Router and Filter to store the data in staging area/target tables and flat files.
• Used the fast Export, Multi Load utilities of Teradata.
• Worked closely wif executive sponsors and user decision makers to develop the transformation logic to be used in Informatica. configured Oracle DAC for the Informatica workflows schedule.
• Worked wif Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, and Sorter and Aggregator transformations.
• Imported data from AS400 to be loaded into SQL Server 2008 into the dbo schema through import wizard and stored it as an SSIS package.

Informatica Developer

Confidential - Austin, TX

Responsibilities:

• Requirement Gathering and Business Analysis
• Analyzed the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Worked wif multiple sources such as Relational Tables, Flat Files, Excel Sources, ERP (SAP-BW) sources for Extraction using Source Analyzer/Power Exchange
• Extensively involved in the Analysis, Design and Modeling. Worked on Star Schema, Data Modeling, Data Elements
• Created CDC sources in Power Exchange and imported that into Power Center
• Designed the ETL process for extracting data from heterogeneous source systems, transform and load into Data Mart
• Created Logical and Physical models for production using Erwin 3.5.
• Worked wif Informatica Power Connect to get data from PeopleSoft XLATTABLE table and modules like General Ledger, Accounts Payable, Accounts Receivable, and Asset Management.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Provided production support including error handling and validation of mappings, sessions and workflow.
• Extensively used Debugger Process to test data and applying Break Points while Session is running.
• Used Informatica web services to create work requests/work Items for the end user.
• Universal Data Transformation for wordfiles, documents, and messages toextract data according to client requirements.