SUMMARY

• Over 15 years of extensive software development experience in Data Modeling, Analysis, Design, Development and Implementation of various Data Warehouse and Client/Server Projects using Informatica PowerCenter and Oracle Data Integrator
• Strong Experience in Data Warehouse requirements gathering, conversion of business requirements into high level functional specifications, File Management and Data Loading Process
• Experience in Dimensional Data Modeling using Star Schema/Snowflake modeling, Fact and Dimension tables, Physical and Logical data modeling, and PL/SQL coding
• Domain knowledge experience in Health Care, Utilities and Telecommunication industries
• Experience in developing interfaces, packages, scenarios and load plans in Oracle Data Integrator
• Experience in working with mappings, transformations, and workflows in Informatica PowerCenter
• Strong skills on transforming data from various sources like Flat Files, Oracle, and SQL Server to data warehouse using ETL tool Informatica PowerCenter and Oracle Data Integrator
• Implemented analytical and reporting systems, such as Oracle Business Intelligence Enterprise Edition
• Excellent Analytical, Communication and Presentation skills

TECHNICAL SKILLS

Data Warehousing: Oracle Data Integrator (ODI) 11g/12c, Informatica Power Center 9.1.x, Oracle Business Intelligence Applications (BI Apps) 7.9.6.x, Oracle BI Apps 11.1.1.8, Data Administration Console (DAC), SQL Server Integration Services (SSIS)

Databases: Oracle 11g, SQL Server 2000, MS Access, DB2, Teradata

Data Modeling: Entities, Cardinality, Attributes, ER - Diagrams

BI/Reporting Tools: Oracle Business Intelligence EE 11g / 12c

Programming: SQL, SQL Plus, PL/SQL, Python 2/3

Environment: Ret Hat Linux, Windows Server

Others: SQL Developer, SQL Server Management Studio, TOAD, Teradata SQL Assistant, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Architect and Sr. ODI Developer

Responsibilities:

• Part of a team that processes Claims and Membership data for Companies that work with Payers
• Create ODI processes to extract and stage Million+ dataset from various flat file formats and validate data integrity
• Work closely with Business analysts to design and execute complex ODI processes to land the staged data to final target per the standard business rules
• Implement data load process as Truncate and Reload, or Incremental per project requirement
• Automated repetitive process using Python / Jython as part of the ODI
• Created Jython script and scheduled to monitor monthly CMS file, download from website when available, unzip and rename to proper naming convention, and process data using ODI
• Assist with process enhancement, debugging and resolving defects, code migration, technical documentation and data processing in production
• Design and update OBIEE reports and dashboards

Skills utilized: Oracle 12c, OBIEE 12, ODI 11g / 12c, SQL Developer, PowerPoint, Jython / Python

Confidential, Jacksonville, FL

Project Spark / Sr. BICS Developer

Responsibilities:

• Assisted in implementation of Oracle Business Intelligence Applications (BIAPPS) on Platform as a Service (PaaS)
• Configured system to pull data from Oracle Cloud Source Applications, such as Fusion and Taleo
• Helped in configuration of OOTB functionality for Finance and HCM modules required by business
• Worked extensively with Oracle Support to resolve setup, configuration and OOTB functionality bugs
• Consulted with Oracle Fusion team to enable functionality that were required for BI Apps
• Documented installation and configuration process of DBaaS, BI Apps, BICS Lift and Shift
• Researched through Oracle documentation to resolve BI Apps Load failures / issues
• Scheduled UCM and BIACM Load, and supporting nightly production load

Skills utilized: Oracle Cloud Services, Oracle BI Apps 11.1.1.10.2 , ODI 11g, SQL Developer, Putty

Confidential, Miami, FL

Optum StepWise Rating System / Lead BI Consultant

Responsibilities:

• Worked as BI Architect, ODI Developer and Tester in a team of 7 members
• Evaluated existing process, assisted in gathering requirements and proof-of-concept design
• Worked with BA to identify new source mapping for the required BO data
• Architected the automate solution to process the data from source to target StepWise System
• New solution eliminated existing manual intervention and Access Databases
• Designed a monthly extract process using ODI Interfaces Logic and complex Package routine to extract data from multiple sources and database platform
• Integrated data from sources, such as Enterprise Data Warehouse (EDW) resided in Oracle
• Pivotal data reside in SQL Server Database and FlatFiles, and landed final dataset in StepWise system which also resided in SQL Server Database.
• Coded validation, exception handling and data reconciliation as part of the process
• Documented full design, along with the data flow diagram.

Skills utilized: Oracle Data Integrator 11g, OBIEE 11g, SQL Server 2008 R2, SQL Server Management Studio, Oracle 11g, SQL Developer, PowerPoint 2016

Confidential, Alpharetta, GA

Cayenta BI / Solution Architect-BI Lead

Responsibilities:

• Performed fit-gap analysis between Cayenta and BI Apps AR module
• Designed a solution by leveraging Universal Adaptor BI Apps mappings to extract the data from the Cayenta system and map to respective AR Fact and Dimension Tables
• Designed simple Dashboard / Reports in OBIEE 10g to show billing and payment information by various key attributes
• Documented fit-gap analysis findings, provided recommended approach for a complete solution design
• Enhanced and implemented designed Cayenta BI solution to Production with 1 year of history
• Installed and configured Oracle BI Apps 11.1.1.8 as a proof of concept for future upgrade
• Redesigned Cayenta BI solution using OBIA 11.1.1.8 architecture and OBIEE 11g
• Documented BI Apps 11.1.1.8 Installation/Configuration steps and Cayenta solution designed load process.

Skills utilized: Informatica PowerCenter 8.6.1, Oracle Data Integrator 11g, OBIEE 10g/11g, Cayenta, Oracle PeopleSoft 8.9, Oracle 10g/11g, DAC 10g, SQL Developer

Confidential, Chattanooga, TN

EDW Redesign / Lead Informatica Developer

Responsibilities:

• Work as a Lead BI Apps developer in a team of 15+ members
• Installed and configured Proof of Concept Win Server 2008 with BI Apps 7.9.6.4, Infa 9.1 and DAC 11g
• Assisted in Combine executions plan design in DAC 11g, where 2 separate subject area with conformed objects can work together and created Custom Subject Area / Tasks
• Worked closely with Oracle EBS SME to understand the source data flow and business analysts to understand requirements
• Evaluated pre-built ETL 100+ mappings of BI Apps Modules’ subject area
• Troubleshoot and optimized Informatica PowerCenter Mapping processes
• Enhanced and/or changed complex pre-built mappings to function according to business requirements
• Worked with complex Transformations, documented Mappings, ETL procedures, modifications and enhancements
• Leveraged Universal Adapter mappings to extract Budget and Forecast data from Cognos Planning Budget system source feed
• Designed Simple ETL to load IQN Contractor Cost data from IQNavigator external system into warehouse
• Assisted in designing of Error Handling scripts and run as part of the ETL to check for Flat File Sources

Skills utilized: Informatica PowerCenter 9.1, OBIEE 11.1.1.7.x, Oracle BI Apps 7.9.6.4, Oracle 11g, DAC 11g, SQL Developer, HPQC Defect Management

Confidential, Jacksonville, FL

Infomatics / ODI Developer

Responsibilities:

• Worked in team of 10, where I am one of 3 ETL developers tasked to design Historical and Incremental data load processes
• Designed simple Source to Target and customized Type I/II ODI Interface processes
• Worked extensively with Business Analyst to understand the business rules and requirements
• Contributed in designing and managing ODI Packages that consist of variables and procedures
• Tested and validated individual tables and end to end data load process in Dev and Test Environment, along with managing defect log for the team
• Familiarized and understood Client’s in-house Master Scheduler Process, which was used in migrating code from one environment to another and scheduling the load process
• Aid in PL/SQL and ODI Interface performance tuning, and troubleshooting data load process
• Documented ODI Interfaces, PL/SQL Procedures and data load ODI Package flow

Skills utilized: Oracle 11g, ODI 11.5.x, SQL Developer, Visio