TECHNICAL SKILLS:

ETL: ODI (Oracle Data Integrator)11/12C, IBM DataStage Enterprise Edition 8.5/8.1, SSIS, Informatica Power Mart/Power Center, Clover

Replication: Oracle Golden Gate

Reporting: OBIEE11g/10g, Tableau

Databases: Oracle 11g/10g, SQL Server

Data Modeling: Dimensional Data Modeling, Star Schema, Snowflake Schema

Other Tools: Toad, SQL Developer, SSMS, MS Office, NetBeans, Putty, Service Now, Autosys

Programming: PL/SQL, SQL,DB2, C, C++, Java, MATLAB, UNIX Shell Scripting, HTML, XML, CSS

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer

Responsibilities:

• Reviewed and captured all the ETL development efforts required for PeopleSoft 9.2 upgrade.
• Modified ETL code (DataStage) changes for addition and deletion of records in 9.2 and documented all the changes.
• Designed and developed of software components related to all aspects of Data Sourcing, Transformation, Data Quality and Reporting using standard ETL, EDW and BI technologies and DataStage.
• Wrote code for enhancing existing programs and developing new programs, estimated project timelines required to complete programming projects.
• Collaborated with Production support team and Software engineering resources to deliver high quality deployments that meet department and customer expectations for quality and schedule.
• Developed packages, scenarios, and mappings based on extract, transform, and load methodologies in ODI.
• New environments set up for ODI, Exported and Imported Master and Work Repositories, created standalone and OMPN agents. Maintained Topology Navigator
• Attended data mapping sessions, provide inputs to ensure mappings are accurate from a technical standpoint.
• Understand business requirements and translate them into robust technical specifications
• Developed complex ETL queries, Testing the ETL Flows, Database Tuning, Data Modeling
• Analyzed data across multiple sources to design and document logical and physical data models, and maintain the Enterprise Data Warehouse Data Model.
• Wrote code for system designs that span platforms, wrote detailed technical specifications for applications and identify integration points, supported application throughout the Product Development life cycle.

Environment: ODI, OBIEE 11g, IBM DataStage 8.5, Informatica Power Center, People Tools 8.53, Windows, Linux, Oracle 11g, HCM,FSCM and SCM Source Systems, Application Designer, ESSBASE, Autosys, PeopleSoft EPM 9.1, PeopleSoft EPM 9.2

Confidential

Responsibilities:

• Lead the team of developers and effectively monitor their status to assure expectations are met and deliverables are on time.
• Automate the process of receiving and extracting the data from clients.
• Implemented change management process for code deployment and reduced the error occurrence by 90 percent.
• Documented the load process documents to train the business analyst on how to use the application.
• Developed and maintained ETL processes using Clover and SSIS to validate, transform and maintain integrity of client provided data.
• Lead the team and performed end to end test of the automated process application.
• Wrote data analysis queries and stored procedures which feed the data to the charts in the user interface.
• Collaborated with data analysts to get timely feedback on application and to gather requirements for application enhancements.
• Triaged between developers and business analysts during QA and UAT to make sure all the issues are correctly reported and all the reported issues are fixed.
• Production support for Clover requests on day to day basis.

Environment: SSIS, SSMS, Windows, Linux, Clover ETL

Confidential

Senior ETL Developer

Responsibilities:

• Part of enterprise data warehouse team in building the DW from scratch.
• Involved in the data integration architecture conversations.
• ETL data from source systems: FISERV, nCino and Primatics.
• Created and assisted creating DW source target mapping for Credit Risk Reports
• Responsible for creating and maintaining ODS, EDW staging and EDW tables and ETL mappings to populate these tables.
• Responsible for creating snapshot tables to compare and track activities.
• Implemented change data capture (CDC) using hash algorithms to track the data that has changed.

Environment: SSIS, SSMS, Toad, Windows, OBIEE 11g, DEPCON

Confidential

ETL Developer

Responsibilities:

• Responsible for development and maintenance of ETL mappings for financial statements and trial balances.
• Performed code review and quality assurance of all SQL and PL/SQL coding.
• Tuned long running SQL and PL/SQL queries.
• Trained team members in writing SQL and PL/SQL queries in efficient way.
• Assisted the team with requirement gathering and source target mapping for the facts and dimensions.
• Performed testing for data accuracy between DW data in OBIEE reports and the legacy data reports.

Environment: SSIS, SSMS, Toad, Windows, OBIEE 11g

Confidential

Lead ETL Developer

Responsibilities:

• Performed current state assessments to identify the known operating states of DataStage ETL, assessments include host ad server information, best and worst performing jobs from the existing jobs.
• Performed current state assessments of OBIEE environments, assessments include architectural model, migration process, security model and configuration/log file locations.
• Tuned long running jobs to save more than 300 minutes on the daily batch window.
• Performed dependency tests on all the FSCM/HCM/SCM jobs in EPM warehouse and implemented job bucketing methodology.
• Performed database and index tuning to improve the performance.
• Implemented table partitioning on large tables to improve the query performance and maintenance operations.
• Provided and implemented the solution for the oracle delivered long running incremental CRC jobs.
• Created and maintained custom ETLs for the ESSBASE cube loads.
• Involved in developing and testing the reports, action links and driver documents.
• Wrote complex load rules for ESSBASE cube loads.
• Performed error handling, data cleansing and repository clean up with in the DataStage
• Production support for all the new implementations.
• Performed cube dependencies with ETL loads and integrated the Database, ETL and ESSBASE services accordingly and automated the load process.
• Documented all the tuning (ETL, Database) steps and customized ETL design.
• Created ETL solution overview and star schema model for the EPIC data source according to the requirements.
• Developed customized jobs to load the EPIC data into EPM warehouse.
• Implemented delete strategy, data validation, handling deletes and error logic for all the custom ETL’s developed for the EPIC data source.
• Part of OBIEE development team to create new subject areas for the EPIC data models, metadata repository (.rpd) development (Physical, Logical and Presentation Layers).
• Created connection pools to Oracle database and ESSBASE cubes in physical layer.
• Documented source to target mapping including all the transformation logics, environment variables and other design related sections.

Environment: OBIEE 11g, IBM DataStage 8.5, People Tools 8.53, Windows, Linux, Oracle 11g, HCM,FSCM and SCM Source Systems, Application Designer, ESSBASE, Autosys, PeopleSoft EPM 9.1

Confidential

Data Warehouse Developer

Responsibilities:

• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Involved in Sales Analytics, Supply Chain, Hyperion projects and few other internal projects.
• Collaborated among DW, Salesforce, Supply Chain, Finance, BI and BICC teams to understand the business requirements and business value for the deliverables.
• Gathered requirements from respective Business System Analysts to implement and deliver data quality by meeting DW standards and acceptance criteria.
• Followed Kimball methodologies in designing aspects.
• Oracle Data Integrator (ODI): Designed REPL, ODS, FDN, NRT, Dimension and Fact Jobs which includes interface design (mapping), transforming data, procedures, package creation, scenario generation and knowledge module customizations.
• Created data models for Oracle and flat file (xml, csv, large text, excel) data sources.
• Performed reverse engineering for data sources and targets.
• Created ODI load plans and scheduled jobs.
• Written complex and efficient SQL’s and PL/SQL procedures to extract the data from source and to transform the data.
• Designed automated audit processes to make sure counts on ERP and DW matches.
• Involved in production support on rotation basis.
• Peer reviewed ODI solutions and PL/SQL scripts.
• Managed offshore resources on ETL tasks.
• Created the data model as per the requirements to process the salesforce data into data warehouse.
• Developed complex ETL jobs to extract the data files from the CALLIDUS ftp server on to local and process those large data files.
• Implemented a temporary solution which is creation of flat data structure in data warehouse for the SHIPPING and RECEIVING data sources.

Environment: ODI 11.1.1.6/12 C, Windows, Linux, Oracle Golden Gate, Toad, SQL Developer, Service Now, Tableau, Oracle CDC, Salesforce, CALLIDUS, Oracle EBS

Confidential

ERP Analyst

Responsibilities:

• Involved in requirement gathering from the functional users.
• Datastage 8.1/8.5: ETL job coding and customizations based on the requirements.
• Involved in HCM, FCM and CSW projects, main focus on CSW project implementation.
• Oracle Golden Gate: learned fundamentals of golden gate and designed the replication processes using golden gate.
• Identified and resolved many data issues in the warehouse by working closely with the functional users.
• Tested job designs of other developers as a peer reviewer.
• OBIEE 10g/11g: Worked with BI developers and created reports for the functional users based on their requirements.
• Created reports for testing purpose to match the data in both transactional system and data warehouse.

Environment: OBIEE 11g, IBM DataStage 8.1/8.5, Windows, Linux, Oracle 10g/11g, HCM,FSCM SCM and CS Source Systems, Application Designer, Oracle Golden Gate

Confidential

ERP Analyst

Responsibilities:

• Worked on the Campus Solution Data Warehouse ETL Project at Enterprise Resource Planning FSU.
• Assisted the reporting team in development, testing, data analysis and maintenance of the new student system.
• Designed Custom OWS ETL jobs.
• Knowledge of IBM Data Stage Enterprise Edition, SQL Developer and OBIEE.
• Documented Source and Targets mappings between CS Functional and CS Warehouse environments for different functional areas.

Environment: OBIEE 11g, IBM DataStage 8.1/8.5, Windows, Linux, Oracle 10g/11g, HCM,FSCM SCM and CS Source Systems, Application Designer, Oracle Golden Gate