We provide IT Staff Augmentation Services!

Computer Programmer Of Datawarehouse And Bi Reporting And Etl Applications Resume

EXPERIENCE SUMMARY:

  • Over all 9 years 5months of experience in implementation, development and support of OBIEE and ETL Applications (including BI Publisher reports)
  • Good knowledge on data warehousing and dimensional modelling and working experience on OBIEE RPD, Reports, Dashboards.
  • Proficient in analyzing and translating business requirements to technical requirements and architecture.
  • Strong database skills, Object Oriented Programming and development knowledge
  • Good communication skills, interpersonal skills, quick learner, team player.

AREAS/APPLICATIONS:

  • Oracle Business intelligence 10g, 11g, 12c
  • Oracle BI Publisher
  • Informatica
  • Oracle Datawarehouse Admin Console (DAC)
  • Oracle Data integrator (ODI) 11g
  • Oracle database 11g
  • PL/SQL Developer
  • Putty
  • WINSCP
  • Mainframe Host Explorer
  • CA WA workstation

CAREER PROFILE:

Confidential

Computer Programmer of Datawarehouse and BI Reporting and ETL Applications

Responsibilities:

  • Development and support of analytical business trend reports to help Company leads extract meaningful insights and take appropriate actions. In last financial year, on time delivery and correct usage of these reports improved client’s operational efficiency by 25% and helped executives grow business in
  • Ensuring delivery of streamlined business reports to store leadership across the organization on Company Performance and Sales information on daily basis.
  • Build and support of organization wide data warehouse to store historical and forecast data in a consistent form for the enterprise that can be leveraged for creating analytical reports.
  • Implemented data security to protect the integrity of confidential corporate data and mitigate risk of security incident.
  • Automated data movement across systems and delivering reports to business users to enhance productivity on time consuming tasks. Reduced 70% of team’s manual activity cost of a year.
  • Provided consultation on appropriate software usage facilitating client requirements. Acquired a new project to promote company built software that was well suited for the specific requirement of the client.
  • Conducted functional and technical training for business users to keep them acquainted on newly implemented analytical applications. 90% of the company’s employee base is now well aware of BI concepts and its usefulness on taking correct strategic decisions. Clients now are more willing than ever to invest on BI projects. This added multiple opportunities in company’s pipeline of work in the last financial year.
  • After decommissioning legacy infovision reporting, Confidential needed new enhanced platform for company’s operational and executive sales reporting. As part of this project from Confidential, RMA was developed and delivered for all sort of hourly, daily and weekly sales reporting
  • Build estimation for requirement gathering, design architecture and build for new reporting platform using Oracle BI technologies
  • End to end knowledge gathering from legacy application team on existing functions and working with client IT team to understand new features.
  • Build data warehouse on Oracle database using ETL tool Oracle Data integrator (ODI) and PL-Sql from OLTP source system (Retail Merchandising system-RMS)
  • Data modelling and creation of OBI repository. Designing fact, dimensions and hierarchies in RPD
  • Development of interactive reporting and email delivery
  • Object and data level user security set up on RMA reports
  • Environment set up for Unit and Integration testing of data and report functionality
  • Work with Business Users to perform User Acceptance Testing
  • Analyze problems / defects identified during testing and apply fixes
  • Deliver end-to-end test results to clients before moving into production
  • Cutover and production deployment
  • Warranty and production support of delivered code
  • HR analytics - OBIA implementation of HR module
  • Customization of HRA module to pull data from source peoplesoft and show it on OBIEE dashboards
  • ETL code enhancement in Informatica and Datawarehouse admin console (DAC) to meet client specific requirements and fix source system issues.
  • Query tuning and logic improvisation of oracle provided OOTB code for improved performance on daily data processing
  • Workforce profile and payroll dashboards configuration in OBI rpd and analytics
  • Security implementation to mirror same data and object level access set up as in source peoplesoft system
  • Warranty and production support of delivered code
  • Financial analytics - OBIA implementation of FA module
  • Configuring OOTB ETL code to pull data from source EBS system using Informatica and DAC
  • OBI rpd and reporting set up for AP and GL
  • Special intra day microload batch set up for more frequent source data pull into OBIEE (apart from daily night data refresh) to help company’s finance team during month/quarter/year end processing.
  • Security implementation to mirror same data and object level access set up as in source EBS
  • Warranty and production support of delivered code
  • For all the live analytics modules, automated monitoring and alert mechanism implementation is in progress
  • Using company’s central mainframe system (ESP) and BI scheduler along with shell scripts, all executive reports are now automated. Post successful data load via ETL, sales trend analytical reports get delivered to company higher authority every morning.
  • Automated data validation framework is implemented for RMA and other custom BI modules using ETL. After source data extraction, validation jobs check for data consistency between source and target.
  • Work is in progress to create consolidated BI system health monitoring dashboard. This would provide real time status of all concerned servers like BI server, ETL Informatica and ODI servers, Database server and its nodes etc. With alert mechanism and level one automated recovery process, this would help client IT operational team in effective monitoring of overall system and early identification/fast remediation of any issue.
  • Fixing technical Production issues and business user tickets
  • Monitor daily production environment batch jobs that process the data from different systems and address any failures immediately.
  • Address Performance issues reported in the existing applications by doing SQL tuning, collecting statistics on the tables used by the application.
  • Perform comfort test on the applications to ensure availability of the systems before business opening.
  • Research user incidents with the system logs and errors reported and implement fixes.Provide resolution if incidents are due to user errors and procedural errors
  • Code development in co-ordination with offshore team
  • Sprint planning for code build, test and deployment
  • Conducting discussions, knowledge transition sessions with offshore teams to make them understand correct requirement.
  • Code review and migration
  • Gather weekly project status from team and keep track of the status and effort consumed by the team members
  • Business update to clients
  • Discuss issues, risks and mitigation plans to make live system more stable

Special Software: Oracle Business Intelligence 11g, Oracle BI Publisher, Informatica, Oracle Datawarehouse Admin Console (DAC), Oracle Data integrator (ODI) 11g, Oracle database 12c, Putty, WINSCP, PL/SQL Developer, Toad, Mainframe Host Explorer, CA WA workstation

Confidential, Plano, Texas

OBIEE Developer

Responsibilities:

  • Technical developments like designing dimensional modeling in OBIEE Repository and creating custom reports and system security implementation.
  • Code migration between environments.
  • Production support, bug fixing and handling change request modules.
  • Resolving OBIEE server related issues
  • Completed OBI Applications Certification.
  • Development of new OBI reports
  • Code migration
  • Addressing performance issue of reports and back end queries
  • Server maintenance support

Special Software: Oracle Business Intelligence 11g, Oracle BI Publisher, Oracle database 11g, Putty, WINSCP, PL/SQL Developer, Toad, Mainframe Host Explorer, CA WA workstation

Confidential, Bentonville, AR

Data Warehousing Specialist and OBI Developer

Responsibilities:

  • Discussions with client personnel based on the System Requirements Document to cover the functionality, operationality, technical issues and scope of work.
  • Analyzing scope, planning, tracking aspects of the project.
  • Estimation of the software development effort
  • Preparation of Technical and Functional documents and Unit Test Documents
  • Technical developments like designing dimensional modeling in OBIEE Repository and creating custom reports and system security implementation.
  • Code migration between environments.
  • Production support, bug fixing and implementing change request modules.
  • Completed Oracle Business Intelligence Certification.
  • Custom HR analytics implementation
  • ETL development to pull data from source OLTP system EBS and build data warehouse to store data denormalized form for reporting.
  • Data modelling to define fact and dimensions
  • OBI repository build defining fact, dimension, company hierarchies and customized logic
  • Build custom reports on employee headcount, Leave of absence, payroll etc.
  • Security implementation to mirror same data and object level access set up as in source peoplesoft system
  • Warranty and production support of delivered code
  • Requirement gathering
  • Analyzing scope and designing new data model
  • Development
  • Code migration between environments
  • Bug fixing and enhancement.
  • Maintenance support of deployed product

Special Software: Putty, WINSCP,User Productivity Kit(UPK),PL/SQL Developer, OBIEE11g, Oracle BI Publisher, Informatica,DAC

Confidential

Data Warehouse Specialist and OBI Developer

Responsibilities:

  • Discussions with respective onshore clients based on the System Requirements Document on expected functionality, operationality, technical issues and scope of work.
  • Analyzing scope, planning, tracking aspects of client request for each project
  • Estimation of the software development effort
  • Preparation of Technical documents, Functional documents
  • Technical developments like designing dimensional modeling in OBIEE Repository and creating custom reports in OBI and BI Publisher.
  • Developing new tool for effective evaluation of customer requirements.
  • Demonstration to clients about Confidential provided solutions.
  • Giving consultation to critical issues in Confidential internal projects.
  • Requirement gathering of new projects
  • Analysing scope and designing data model
  • Planning on code implementation and on time delivery
  • New software development
  • Maintenance support to other Confidential internal projects
  • Bug fixing and code enhance of mission critical projects

Special Software: Putty, WINSCP, PL/SQL Developer, OBI Apps 7.9.6.2, OBIEE10g, OBIEE11g, Oracle BI Publisher, Informatica, DAC

Confidential

Data Warehouse Specialist and OBI Developer

Responsibilities:

  • Requirement gathering from business users
  • Code development, end-to-end testing and Production deployment
  • Production support including bug fixes and resolution of user tickets
  • OBIEE reports and SQL Code development
  • Maintenance support SQL packages and OBIEE reports and data model

Special Software: Putty, WINSCP, PL/SQL Developer, OBI Apps 7.9.6.2, Informatica,DAC

Confidential

Data Warehouse Specialist and OBI Developer

Responsibilities:

  • Production support of OBI reports
  • Bug fixing in Pl/sql packages

Special Software: Putty, WINSCP, PL/SQL Developer, OBI Apps 7.9.6.2, Informatica,DAC

Confidential

PL/SQL Developer

Responsibilities:

  • Discussions with client personnel to cover the functionality, operation, technical issues and scope of work.
  • Planning, tracking aspects of the project.
  • Estimation of the software development effort
  • Preparation of Technical documents, Functional documents and Unit Test case Documents
  • Technical developments like enhancement of SQL packages and development of sql embedded xml.s and Performance tuning of sql.s
  • Product maintenance support activities
  • XML Code development with embedded sql.s
  • Testing and code deployment
  • Bug fixing and enhancement of product

Special Software: Putty, PL/SQL Developer, TOAD.

Confidential

Trainee

Responsibilities:

  • Training of basic computer language Java, Advanced Java, DBMS and Operation system were given.
  • Training on Oracle Application, SQL and PL/SQL
  • Solved assignment on given training and given exit test.
  • Done WBT and brain bench test in iCalms.

Special Software: PL SQL Developer, eclipse

Hire Now