SUMMARY

• 11+ years of IT experience as Database Architect, ETL and AWS Development.
• Strong Experience in Developing Applications, including Dimensional Data Modeling - Star Schema, Facts & Dimensions.
• Experience in ETL development through Oracle Data Integrator ODI 11G/12C, Informatica, PL/SQL for critical business requirement.
• Experience in Data integration and reporting to meet Business Intelligence needs for applications such as applications ODI and OBIEE.
• Strong understanding of the entire AWS Product and Service suite primarily EC2, S3, VPC, Lambda, Redshift, Spectrum, EMR(Hadoop) and other monitoring service of products and their applicable use cases, best practices and implementation, and support considerations.
• Experienced in extract transform and load (ETL) processing large datasets of different forms including structured, semi-structured and unstructured data.
• Experience in migrating existing databases from on premise to AWS Redshift using various AWS services
• Worked extensively on Data Modeling with Erwin in several projects in both OLAP and OLTP application.
• Performed data analysis and data profiling using SQL and ODI on various sources systems including Oracle and Teradata.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins in databases using PL/SQL and Involved in performance tuning.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team

TECHNICAL SKILLS

Data base \ETL: Oracle 11g\12C, SQL Server 208, DB2, Teradata, VPD, ODI 11g/12C, BICS

Reporting: OBIEE 11g\12C, OBIA 11.1.1.X, BI Publisher

Data model: Erwin, SQL Developer, Toad

Oracle apps: Oracle EBS Suit R12.1\11i, PL / SQL

Big Data: Apache Hadoop, Pig.

Operating Systems: Windows XP, 7 &10, Unix\Linux

General: AWS Services

PROFESSIONAL EXPERIENCE

Confidential - New Orleans, LA

ETL / AWS Data Architect

Responsibilities:

• Participated on design, architecture review meetings and provided suggestions, improved qualities.
• Lead the design of the ETL solution; oversee the ETL low-level design and design phase deliverables
• Modified and convert Batch Controller to execute Oracle packages using ODI Load Plans
• Utilized ODI in-built Journalizing (J$ tables) methodology to manage and maintain Change Data Capture (CDC) from source data
• Developed and assisted developers of writing SQL, PL/SQL, stored procedures and triggers.
• Development Detailed Design Flow of Change Data Processing in ODI from PL/SQL.
• Involved in the extraction of data from different sources like OLTP server, flat files, excel and legacy databases.
• Designed and Developed ETL jobs to extract data from Salesforce replica and load it in data mart in Redshift.
• Setup of Cloud Watch alarms, setting up CloudTrail, creating S3 buckets.
• Load data into Amazon Redshift and use AWS Cloud Watch to collect and monitor AWS RDS instances within Confidential.
• Used BI Cloud Connector (BICC) to schedule data extracts from a Fusion Applications Cloud data source.
• Designed External and Managed tables in Hive and processed data to the HDFS using Sqoop
• Extracted View Object (VO) data stored on the Oracle Universal Content Management (UCM) server
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Created logical and physical data model for Online Campaign Data Management using ERstudio and Visio
• Perform ETL Testing by validating data.
• Developed and executed a migration strategy to move Data Warehouse from an Oracle platform to AWS Redshift.
• Conducted code reviews and planned the knowledge transfer to client.

Confidential - Baltimore, MD

AWS / ETL Developer

Responsibilities:

• Proficient in AWS services like VPC, EC2, S3, ELB, Auto Scaling Groups(ASG), EBS, RDS, CloudFormation, Route 53, Cloud Watch, Cloud Front, Cloud Trail.
• Design and Compile ETL Technical Design document for ODI Architecture, referring to Business requirements from customer information FDD and corresponding data mappings.
• Designed and developed ETL/ELT processes to handle data migration from multiple business units and sources including Oracle, Access and others.
• Manage IAM roles and console access for EC2, and ELB services.
• Converted PL/SQL codes, Packages, Procedures in to ODI ETL codes processes.
• Monitor and create alarms for CPU, memory, disk space, using Cloud Watch
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse
• Developed ETL scripts to enable weekly processing of 2-4 GB data sets into data warehouse
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Worked on PL/SQL Packages, stored procedures, functions and triggers.
• Involve in design high availability applications on AWS across availability zones and availability regions.
• Built a VPC, established the site-to- site VPN connection between Data Center and AWS .
• Configured Oracle Data Integrator Clustering for High Availability and Failover for Dev and Prod environments
• Optimized the knowledge modules to improve the functionality of the process.

Confidential - Sarasota, FL

Sr BI / ETL Developer

Responsibilities:

• Did extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.
• Modified the existing ODI interfaces in both category 1 & II used cases and created custom interfaces, Packages, variables, scenarios, LP etc for Universal adaptor to get the Financials and Manufacture Analytics into the Data warehouse.
• Other tasks included were documenting ODI Installation and Configuration process, Design and Technical documentation for the developed ETL processes.
• Lead the task of migrating SDE, SIL and PLP code from Informatica 9.6.4 to ODI 11.1.1.9.0.
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
• Involved in Design and Development of custom business intelligence solution (Metadata and Dashboards/Reports) using OBIEE 11g/12C
• Involved in SQL Query tuning and provided tuning recommendations to SQL ETL materialized Views to populate DWH tables.
• Configured OBI Applications to use DBLink configuration in ODI that best suits their deployment.
• Report to the senior project lead with weekly and monthly project status report
• Involving in Unit Testing, Validating Reports and production support.

Confidential, Omaha, NE

BI / ETL Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical design document.
• Installation of OKA, ODI 11.1.1.8, Staging and Reporting data bases as per Oracle standards.
• Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI.
• Wrote detailed design specs for ETL. Converted the functional specs written by Data Modelers into the detailed design spec for ETL. These specs were used in the development of code using ODI
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
• Performed extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.
• Troubleshoot the process or production issues and resolve the problems
• Used SQL tools like SQL Developer to run SQL and PL/SQL queries and validate the data loaded into the target tables.
• Worked with QA team to design test plan for user Acceptance Testing (UAT)
• Performed stakeholder analysis team and weekly status reports to leadership teams

Confidential, St. Louis, MO

BI / ETL Developer

Responsibilities:

• Involved in requirement gatherings and Analyzed Functional & technical design documents.
• Created master & work repositories and configured ODI connections for source and target systems in topology.
• Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
• Configured Oracle BI Applications Configuration Manager and Oracle Data Integrator, Oracle BI Applications Functional Setup Manager.
• Modified the existing ODI interfaces and created custom interfaces for Universal adaptor to get the standard Enterprise Asset Management Analytics
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created ODI Interfaces to update Hyperion Planning/Essbase Metadata and to import Essbase Data and to export data from Hyperion Essbase to File System and relational databases.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• Loaded data from different source systems to target warehouse using interfaces with Knowledge modules like LKM, IKM and CKM for data quality check
• Customized ODI Projects, Packages and Interfaces to extract the data from Oracle EBS database load to OBAW.
• Involved on OBIA 11g performance recommendations in hardware, software, OBAW and ETL Performa
• Involved in Knowledge transfer to Confidential IT Developer on various issues and product maintenance.
• Responsible for creating additional Users and maintaining Visibility Privileges using OBIEE Administration on Repository side as well as front end to display of OBIEE reports based on business user needs.
• Involved in unit testing, Security and integration testing of the reports generated by OBIEE

Confidential, Aiken, SC

ETL / Data Warehouse developer

Responsibilities:

• Gather requirements from client or end-users to develop a layout plan.
• Created ETL transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica 9.5.1 designer from PeopleSoft 9.2
• Worked with DBA and SQL developers to create jobs and schedules to build materialized views.
• Customized OBIA ETL mappings and table extensions to design the Star Schema and populate the Data warehouse based on business requirements.
• The solution included DB2 configuration, data modeling, and identification of trusted data sources, database creation, and ETL processes.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements Customized OBIEE repository by adding custom columns and tables using BI administration tool for Service Analytics tables like W ACTIVITY F, W AGREE F, W AGREEITEM F, W QUOTE D, tables in Service Analytics (Oracle PeopleSoft 9.2).
• Involved in co-coordinating onsite-offshore teams in various life cycles of the projects
• Validated technical design created by developers against functional specifications.
• Assisted in integrating OBIEE application with Oracle RDBMS database.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance
• Customized the RPD with the requirements of the End User. Designed and Developed the three layers (Physical, BMM, Presentation)
• Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs

Confidential, Long Island, NY

BI / Data Warehouse Developer

Responsibilities:

• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Performed Installation and upgrade discovery of Oracle 10.1.3g to Oracle 11g Enterprise Edition, as well as Migrated Analytic RPD and web catalog from one environment to another.
• Managed the onshore and offshore deliverables and maintained a highly organized and streamlined environment
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Created OBIEE reports and Dashboards for the Marketing Operations of the Organization.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.