We provide IT Staff Augmentation Services!

Solution Specialist Resume

SUMMARY

  • Senior Data Engineer with exceptional technical purview for organizational development, seeking career enriching jobs in the field of IT with a professionally managed organization
  • Qualified professional offering over 9 years of experience in Analytics, Data Management and Integration in roles like Designer, Developer, Admin, Tester and lead
  • Well - versed in working on Data Integration and Analysis Project utilizing wide range of ELT/ETL, Reporting and Data management tools
  • Skilled in working on tools / technologies like ODI, OAC, OBIEE, Data Stage, Informatica PowerCenter, IDQ, FDMEE, Hyperion PSPB, SOA, PLSQL, UNIX and JAVA
  • Adept at integration with Oracle APPS, PeopleSoft, PSPB and SOA, installation, development, configuration, performance tuning and migration
  • Distinguished publisher of data validation tool to automate test cases for ETL. Tool: ODI

TECHNICAL SKILLS

Cloud: Oracle Analytics Cloud, Oracle Business Intelligence Cloud, Oracle Database Cloud, Oracle Autonomous Data Warehouse

Software / Products: Toad 9.X, Toad 11.X, WebLogic 10.3, EBS R12, Hyperion PSPB, OBIEE Admin Tool

Development Tools / Languages: ODI 11G, ODI 10G, ODI 12C, Python, JDeveloper, JDeveloper 11G, Soap UI, HTML, XML, Shell Script, Java, Informatica 9.6.1, Informatica 10.1, IDQ 9.6.1

Hardware / Operating Systems: Windows 2003 Server, Windows 7, RHEL 6.x, Sun Solaris

Middleware / Databases: JDBC, Oracle 10g, Oracle 11g, SOA 10G, SOA 11G, FDMEE

General Tools: Microsoft Excel, Microsoft Word, Microsoft Power Point

PROFESSIONAL EXPERIENCE

Confidential

Solution Specialist

Responsibilities:

  • Led multiple teams and functioned as SPOC / Lead Developer in multiple projects utilizing tools and technologies like ELT/ETL tools - ODI/Informatica, OBIEE, FDMEE, IDQ, Hyperion Planning
  • Guided team of 5 members in modernizing existing ETL layer to Informatica for a health insurance client and delivering over 300 WFs and 350 CTRLM jobs
  • Guided DWH team at a state client for ETL process improvements and Formulated process for the Data Stage / Cognos Development & Deployment.
  • Functioned as OAC Specialist and coordinated with the project lead in analytics architecture encompassing Source-Staging-DWH integration approach. Worked on ETL components, Data modeling, Code migration to Upper Environments
  • Worked as ETL Lead Developer involved in identifying system requirements to setup the new Environment for ODI. Coordinated with data modeling team from client side and developed mappings to load data to the data warehouse
  • Extracted data from different sources/entities (ADP, worktime, custom systems) to staging area. Transformed data as per mapping rules and consolidation
  • Involved in field by field data analysis and profiling in the two source systems using SQL queries and Informatica data quality

Confidential

Technology Analyst

Responsibilities:

  • Migrated client's middleware infrastructure from one data center to another and implemented next generation of connected services for the automobile using ODI 10G, Oracle 11G, RHEL 5.X, OAS
  • Developed middleware components for integrating source like 3rd party feeds and order system with end systems - Siebel, ERP and custom applications using ODI 10G & 11G, Oracle 11G, SOA 10.1.3.5, SOA 11.1.1.7
  • Contributed in Transformation project of Oracle EBS 11i to R12 for Anglo-Dutch multinational publishing and information company using ODI 10G & 11G, EBS R12, Solaris
  • Developed and maintained custom applications used for sending out notification to customers for planned/unplanned outages for British multinational telecommunications services company using Oracle 10G, Windows Server 2003, Apache Tomcat

Hire Now