SUMMARY

• Senior Software Engineer with 7+ years of experience in Data Warehousing and solid background in both ETL (Informatica) and reporting (OBIEE)
• Experience in design and development of ETL methodology using Informatica PowerCenter for supporting corporate-wide data transformations and processing
• Expertise in designing and developing mappings from varied transformation logic including source qualifier, filter, expression, rank, router, aggregator, joiner, lookup, normalizer, sorter, stored procedure and update strategy

• Excellence in understanding business needs and converting them into technical solutions
• As Support Engineer, maintained a large ETL/Data Warehousing environment with close to 250 Informatica integrations running with super critical information
• Expertise in creating OBIEE reports and dashboards
• Good understanding of proposal writing through attending proposal boot camps and collaborating on multiple proposal development teams
• Expertise in designing ETL processes and develop source to target data mappings
• Very good Knowledge in SQL and PL/SQL
• Experience in developing BI solutions using leading BI tools such as Oracle Business Intelligence Enterprise Edition(OBIEE)

WORK EXPERIENCE

• Performed migration of the Oracle Discoverer (detail) and Express (summary) reports to OBIEE reports
• Conducted BDN Decoupling changes and impact analysis for BDN decoupling from VOR
• Created a new SQL procedure for the EP687 STAR brokered random sampling cases. Modified the existing STAR SQL procedure to optimize and error-proof the SQL code
• Responded to Hot Adhoc requests to pull up pending reports with null suspense dates. Received appreciation from project team lead for completing the tasks in an expedited manner
• Developed Informatica mapping to merge three materialized views logic to one mapping
• Modified Informatica mapping to capture the logic for the claims closed on Sundays and holidays
• Conducted reviews and analyses on defective SQL queries, identified errors and performed corrective actions
• Worked on client initiated change requests, created documentation and conducted CCB meetings to deploy the changes to Production environment
• Queried the repository to study workflow status and progress of Informatica runs
• Responsible for maintaining the day-to-day running of the Pre-Prod environment and troubleshooting of any errors that might arise
• Conducted report reconciliation against the Oracle Discoverer and Express reports immediately after the production deployment
• Created end-to-end express reports comprising of Database and Informatica changes
• As team liaison, exhibited excellent communication skills and was proactive in coordinating critical workflow integrations and deliveries
• Responsible for preparing technical specification document for the supported projects and uploading them in dimensions
• Developed new mappings for GULF WAR GWVIS pending claims project
• Developed Informatica mappings for existing SQL procedures to improve process efficiency and reduce breakdowns

IT Environment: Informatica 9.x, OBIEE 11 g, UNIX and SQL Navigator

• Responsible for daily maintenance and troubleshooting of Point Of Sale (POS) flow
• Queried the repository to study workflow status and progress of Informatica run
• Conducted data validation in multiple environments to ensure delivery Service Level Agreements (SLA) and to validate POS data using DMove data from Mainframe, Active Data Source, Redbrick and Teradata
• Managed the Point Club Rewards process for Ad Plex (Interdirectusa) and Rapp Collins Worldwide
• Coordinated Informatica upgrade from version 7.1 to 8.5 for a group of 12 workstations
• Responsible for conducting daily health checks of Informatica workflows and keeping track of the daily inventory process
• Worked in Teradata High Availability Dual Active (HADA) project
• Responsible for period close week validation
• Created integration for processes for recovering inaccurate data before reaching the Data Warehouse
• Supported non-Informatica applications critical to client (HEB)
• Handled the MQ-Informatica trickle feed process
• Maintained and worked in the REI (Retail Experts) process
• Fixed all issues/failures within tight SLA for databases viewed and analyzed by 400+ business users; including the client CIO and stake owners

IT Environment: Informatica 7.x/8.x, Teradata, UNIX, Redbrick, TIBCO, Putty, WinSql & HPSM

Confidential, November 2006 - June 2008
Software Engineer Overland Park, KS / Bangalore, India

• Developed Cognos IMR reports, Architect Models and Power Play Cubes
• Performed Cognos and Informatica runs as part of the Swiss Re Mainframe migration from US to Zurich environment
• Prepared documentation for the supported application and uploaded them in PVCS (Version controller)
• Raised code change requests with the tools like Maximo and Kintana
• Involved in designing high level technical documentation based on specifications provided by the client manager
• Responsible for efficiently managing the application shut down process
• Created Informatica workflows and sessions and ran the sessions to load target data with specified conditions. Conducted mapping, debugging and unit testing for target data
• Interacted with Business Analyst to understand the source and target system
• Designed technical documentation for source to target mappings
• Received rewards and appreciation certificates from client for the successful and timely completion and quality of project
• Responsible for working on helpdesk tickets tracked in the ITSM tool

IT Environment: Informatica 6.x/7.x, Cognos 7.x, Business Objects, PL/SQL Developer, Toad 7.6, Citrix Client 7.1, PVCS, Kintana & ITSM

Confidential, January 2005 - October 2006
Software Engineer Overland Park, KS / Bangalore, India

• Trained with Business Analyst to understand the functional business processes and client requirements
• Created Cognos reports to view the TRAC system effectively
• Designed and developed drill-through Cognos detail reports for Payment TAT and Payment Accuracy calculation
• Extracted, transformed and loaded data from legacy systems and built a datamart for ERC Life Business
• Designed and developed Cognos Summary Cube with specified dimensions and measures from the target datamart
• Design and developed extract feeds from the datamart to the Digital Cockpit database
• Managed user access rights in the development environment using Cognos Access Manager
• Published Cognos Impromptu reports to the Development Upfront
• Received client appreciation for excellence of work in understanding the requirement, providing input and implementing the logic

IT Environment: Informatica 6.x/7.x, Cognos 7.x, PL/SQL Developer, Toad 7.6, Citrix Client 7.1, PVCS, Kintana, Transwarp & EDB Deployer

EDUCATION

Master of Computer Application (MCA)
B. Sc in Information Technology

TECHNICAL SKILLS

• ETL Tools: Informatica Power Center 6.1, 7.1, 8.5, 9.0.1
• Reporting Tools: OBIEE 11g, Cognos 7.3 (CQ Reports, Architect Models, Cognos Powerplay, Impromptu Catalogs & Reports), Business Objects
• Languages: SQL
• Database: Oracle, MS Access, Teradata, Redbrick
• Software: PL/SQL Developer, Toad 7.6, Citrix Client 7.1, PVCS, ITSM, Transwarp, EDB Deployer, Redbrick Client(ODBC Driver), Putty, WinSql, Teradata ODBC Driver & SQL Navigator
• Six Sigma: Six Sigma Green Belt Training, QMS for Developers
• Standards: ISO 27000, Software Configuration Management (SCM)