We provide IT Staff Augmentation Services!

Consultant Senior Programmer Resume

SUMMARY:

  • Over 10 years of industry experience in architecting data - related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
  • ODI: 5 years of extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
  • OWB: 9 years of extensive DW experience using Oracle Warehouse Builder, configured and setup OWB Workspaces, Users, configured locations to corresponding control centers in repository browser and configured Workflow manager to execute process flows.
  • Data Modeling: 4 years of Data Modeling experience using Dimensional Data modeling, Star Schema modeling, Snow-Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling.
  • OBIEE: More than 5 years of experience on creating RPD, Dashboards and ad-hoc reports
  • Oracle Discoverer: 5 years of experience on creating workbooks and reports.
  • Extensively worked with large Databases in Development, Testing and Production environments.
  • Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • Thorough knowledge of Software Development Life Cycle SDLC with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing.
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Used Oracle Data Integrator Designer ODI and Oracle Warehouse Builder OWB to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Expert in installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
  • Specialized in developing stored procedures, functions, packages, views and database triggers using Oracle SQL and PL/SQL to improve query performance.
  • Self-starter, entrepreneurial, highly motivated team- player with excellent communication/problem-solving skills.
  • Expert in Developing Reports using OBIEE, creating OBIEE RPD and Dashboard
  • Experience in Reporting tools e.g. Oracle Discoverer and Oracle Reports

TECHNICAL SKILLS:

ETL Tools: ODI 11g & 12c, OWB 10g & 11g, Informatica

BI Tools: OBIEE

RDBMS: Oracle 11g/10g/9i, Teradata

Languages/Scripting: SQL, PL/SQL, UNIX/LINUX Shell Scripting, PowerShellTCL Script

Operating Systems: UNIX/LINUX, MS-DOS, Windows NT/2000/XP

Design/Application Tools: Microsoft Visio, TOAD, SQL Developer, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential

Consultant Senior Programmer

Responsibilities:

  • Review the changed business logic and data structure of source systems.
  • Identify the changes in DW and BI.
  • Implement the changes in Database objects and ETL
  • Implement the changes in Discoverer and Oracle Reports
  • Work closely with the DBA team to pin point the performance pitfalls.
  • Implement the recommendation of DBA regarding the SQL queries and PL/SQL procedures, Views.
  • Create documentation to handover the works to the state worker.

Environment: ODI 12c, Oracle 12c, SQL Assistant, Toad, Shell Scripts, PL/SQL UNIX, Oracle Discoverer, OBIEE

Confidential

Enterprise Data Warehouse/ETL Developer

Responsibilities:

  • Review the call pattern of possible illegal VOIP provider.
  • Review the business logic with the concerned department and regulatory authority.
  • Analyze the Requirements.
  • Design the ODI 12c Mapping (interface) and Packaged Workflows (Scenarios) for the ETL.
  • Implement the changed business logic into the existing ODI 12c Mappings and Workflows based on the observation and recommendation from the Functional expert.
  • Implement the analytical functions in ODI 12c Mappings to analyze the call pattern of suspected MSISDNs.
  • Work closely with the DBA team to pin point the performance pitfalls.
  • Implement the recommendation of DBA regarding the SQL queries and PL/SQL procedures.

Environment: Teradata, ODI 11g, ODI 12c, Oracle 11g, SQL Assistant, Toad, PL/SQL, Shell Scripts, UNIX, Power Shell

Confidential

Migration Expert

Responsibilities:

  • Understand the module in Teradata.
  • Prepare Requirement Document for target Oracle Server.
  • Design and create the Oracle Schemas required for migrating the module.
  • Configure and Migrate the ODI Interface and Scenarios to populate the Oracle Database.
  • Extracting data from various database, flat files and XML files
  • Performance Tuning of the new target Oracle Database.
  • Java Code support
  • Supporting web interface using HTML5 and .Net
  • Create WebServices for the interface
  • Powershell
  • Compare the results between Old and New Server and fix the bugs.
  • Decommission the Old Server.
  • Tuning and optimizing query with the help of DBA
  • Adding data elements in reports using Crystal Reports 2013

Environment: Teradata, ODI 11g, Oracle 11g, SQL Assistant, Toad, Shell Scripts, UNIX, Java, .Net, Powershell, SQL Tuning, XML, Crystal Report 2013

Confidential

Developer

Responsibilities:

  • Gather the Requirements from the concerned Business Units.
  • Understand the business logic and examine DW system.
  • Create summery tables in the Teradata Database based on the DW system knowledge and Business Logic with Conformed Dimensions and Facts.
  • Build the ETL subsystem to automate the data population using Informatica.
  • Extracting data from various database, flat files and XML files
  • Java Code support
  • Supporting web interface using HTML5 and .Net and Java
  • Create WebService for the interface
  • Powershell
  • Facilitate the UAT.
  • Rollout to the Production.
  • Technical documentation for the operation team
  • Power point presentation for the business users on the reports.

Environment: Teradata, Informatica, SQL Assistant, Shell Scripts, UNIX, PL/SQL, Unix, Powershell, Java, .Net

Confidential

Data Integration Expert

Responsibilities:

  • Gather the Requirements from the concerned Business Units.
  • Understand the business logic and examine source system.
  • Integrate the Data Model based on the source system knowledge and Business Logic with Conformed Dimensions and Facts.
  • Build the ETL subsystem to automate the data population using Informatica and Teradata.
  • Facilitate the UAT.
  • Rollout to the Production.
  • Power point presentation for the business users on the Reports
  • Technical documentation for the operation team.

Environment: Teradata, Informatica, SQL Assistant, Shell Scripts, UNIX

Confidential

Migration Expert

Responsibilities:

  • Understand the module in TeraMiner.
  • Configure and Migrate the ETL from TeraMiner to Informatica.
  • Compare the results between TeraMiner and Informatica and fix the bugs.
  • Decommission the TeraMiner.
  • Documentation for the Operation team.

Environment: Teradata, Informatica, SQL Assistant, Shell Scripts, UNIX

Confidential, San Francisco, CA

Technical Lead Consultant

Responsibilities:

  • Shell Script Development for Sourcing & Landing.
  • Customization for Data Feeding for Data Mart & ODI/OWB Practices.
  • OCDM OBIEE Customization and Report.
  • Documentation.

Confidential

Solutions Architect

Responsibilities:

  • Implemented Mappings in ODI 11g using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components.
  • Debug the mappings using debugger to resolve code issue.
  • Involved in Dimensional Modelling such as Star Schema, Snow Flake Schema, creating Facts, Dimensions and Measures.
  • Worked in importing data from heterogeneous data sources like database, flat file.
  • Designed Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle Data Warehouse.
  • Implemented Interfaces for loading Source data into Staging area and Staging data into Dimension and Fact tables of Reporting Data mart.
  • Designed end to end ELT process flow and implemented it using ODI packages.
  • Created static and dynamic variables and used them as declare, set, evaluates and refresh types.
  • Implemented ODI Procedures to execute pre and post process commands such as disable and enable Indexes.
  • Implemented Success and Failure Notifications into ODI Packages.
  • Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
  • Created test cases for end to end and rated testing of ELT Packages.
  • Performed unit and system testing of ELT Packages.
  • Create handover documents for the clients’ technical team on the ETL system

Environment: ODI 11g, Oracle 11g, Toad, Shell Scripts, UNIX

Confidential

Technical Lead Consultant

Responsibilities:

  • Installed and configured ODI 11g into DEV and PROD environments.
  • Created ODI jobs to replicate the existing process of Shell scripts and SQL scripts.
  • Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target.
  • Created ODI Package of various complexity and automated process data flow.
  • Configured the testing environment and process to export and Import ODI Objects into the Testing and Production Execution environment.
  • Performed source to Staging and staging to target mapping specifications and developed ETL/ELT ODI code for the same.
  • Created ODI Interfaces to load data into ODS for downstream systems.
  • Created ODI Interfaces to load data into dimension and fact tables for CDR traffic and billing data mart.
  • Used IKM, LKM, JKM CKM knowledge modules to create ODI Jobs for data loading.
  • Created Packages and it's Scenario to automate loading jobs.
  • Used ODI to build performance data integration solutions including extraction, transformation and load packages for data warehousing.
  • Used principles of Normalization to improve the performance.
  • Involved in ETL code using PL/SQL in order to meet requirements for Extraction, transformation, cleansing and loading of data from source to target data structures.
  • Developed Advance PL/SQL Packages, Procedures, Triggers, Functions, Indexes to implement business logic using Toad.
  • Create handover documents for the client on ETL process (ODI and UNIX shell scripts)

Environment: ODI 11g, Oracle 11g, Toad, Shell Scripts, UNIX

Confidential

Data Warehouse Developer

Responsibilities:

  • Gather requirements from business users.
  • Design New Data Mart modules as per business requirements.
  • Design the ETL using Oracle Warehouse Builder.
  • Design the reports using OBIEE (Both in RPD and Presentation layer).
  • Support the existing Data Marts.
  • Support Ad-hoc queries.
  • Administering the OBIEE.

Confidential

Solution Architect

Responsibilities:

  • Identify some complex mapping in OWB which involved heterogeneous sources and complex business logics
  • Recreate those mappings by ODI in test environment
  • Compare the execution time of OWB and ODI mapping
  • Compare the maintenance of the mapping in both ODI and OWB. Area of interest were
  • Ease of change
  • Performance tuning
  • Adding custom scripts
  • Execution reports
  • Ability to execute from the point of failure
  • Ability to take advantage of the advanced features of the Database

Environment: OWB 11g, ODI 11g, Oracle 11g, Toad, Shell Scripts, UNIX

Confidential

Solutions Architect

Responsibilities:

  • Involved in Analysis of the Project requirements.
  • Extracting the data from various source systems.
  • Dealing with the source systems for the source data.
  • Documenting the Gap analysis.
  • Creation of LLD and HLD.
  • Designing the logic.
  • Estimation of efforts.
  • Developed various OWB objects including Table functions, pluggable mappings, pivot operator, lookups, expressions, complex joins, mappings, locations, and process flows.
  • Deployed all objects in their respective schemas using appropriate deploy option in Control Center via OWB locations.
  • Developed ETL mappings to perform business rules.
  • Created OWB locations for multiple oracle sources.
  • Worked on implementing slowly changing dimensions SCD, lately arrived dimensions LAD.
  • Java Code support
  • Supporting web interface using HTML5 and .Net
  • Create WebService for the interface
  • Powershell
  • Configured the mappings by removing the hints to improve the performance.
  • Participate regularly in meetings with Business Analysts, clients for gathering requirements and participate in Design review discussions with architects.
  • Work on the items or tasks created on individual contributor basis.
  • Design the OBIEE Physical, Logical and Presentation Layer for the reports.
  • Design the Dashboards and Answers as per the business report requirements.
  • Prepare handover documents for the operation team
  • Prepare power point presentation for the business users on the underlying data structures and conduct session on how to create ad-hoc reports and dashboards in OBIEE

Environment: OWB 11g, Oracle 11g, Toad, Shell Scripts, UNIX, OBIEE, Crystal Report, Java, .Net, Powershell, PL/SQL, XML

Confidential

Solutions Architect

Responsibilities:

  • Gather the requirements from the business.
  • Create the underlying database tables and views.
  • Create the ETL using PL/SQL Stored Procedure and Packages and OWB Mappings and Process Flows.
  • Create the Reports and Answers and Dashboards using the OBIEE.
  • Create the stored procedures for Data Integration in Risk Database using MS SQL.
  • Conduct training sessions for the business users on ad-hoc reports and underlying data structures.

Environment: OWB 11g, Oracle 11g, Toad, Shell Scripts, UNIX, OBIEE, MS SQL

Confidential

Solutions Architect

Responsibilities:

  • Create and maintain ETL using PL/SQL Stored Procedure and Packages and OWB Mappings and Process Flows as per the specification.
  • Create and maintain Merchant related Reports and Dashboards through OBIEE, Crystal Reports and Oracle Reports (RPD and Presentation).
  • Troubleshoot and enhance the performance of ETL and OBIEE reports.
  • Java Code support
  • Supporting web interface using HTML5 and .Net
  • Create WebService for the interface
  • Powershell
  • Documented and conduct sessions to train the business users on the structure of the newly created subject area.

Environment: OWB 11g, Oracle 11g, Toad, Shell Scripts, UNIX, OBIEE, Crystal Report, .Net, Java, HTML5, Powershell, Oracle Report

Confidential

Solutions Architect

Responsibilities:

  • Gather the reports requirements from the business verticals.
  • Design the underlying database tables and views.
  • Create the ETL using PL/SQL Stored Procedure and Packages and OWB Mappings and Process Flows as per the specification.
  • Create the Reports using OBIEE (RPD and Presentation).

Environment: OWB 11g, Oracle 11g, Toad, Shell Scripts, UNIX, OBIEE

Confidential

Solutions Architect

Responsibilities:

  • Gather the reports requirements from the business verticals.
  • Design the underlying database tables and views.
  • Create the ETL using PL/SQL Stored Procedure and Packages and OWB Mappings and Process Flows as per the specification.
  • Create the Reports using OBIEE (RPD and Presentation).

Environment: OWB 11g, Oracle 11g, Toad, Shell Scripts, UNIX, OBIEE

Confidential

Solutions Architect

Responsibilities:

  • Gather the requirements of reports from various business verticals.
  • Create and maintain the reports for Risk Collection using the OBIEE (RPD and Presentation).
  • Create and maintain the reports for Risk team using the OBIEE (RPD and Presentation).
  • Create and maintain the ETL using PL/SQL Stored Procedure and Packages and OWB Mappings and Process Flows as per the specification.

Environment: OWB 11g, Oracle 11g, Toad, Shell Scripts, UNIX, OBIEE

Hire Now