OBJECTIVE:

• To improve breath of knowledge in Data Analytics and eventually grow to the position of Solution Architect.

SUMMARY:

• Certified ODI and OBIEE implementation specialist.
• More than 9 years of experience in IT with strong background in Analysis, Design, Development, Implementation of Data Analysis, Migration, MDM etc.
• Experienced in all phases of System Development Life Cycle (SDLC).
• Experience in performance tuning Data Warehouse to meet Business Intelligence needs.
• On hands experience in version upgrades and environment setups.
• Experience in creating ad - hoc analysis and Dashboards using OBIEE Answers.
• Strong understanding on Data Warehousing concepts such as Star and Snowflake schemas. Excellent knowledge of Kimball Methodology.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experienced in Installing and Configuring Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.
• Experienced in setting up ODI standalone Agents and J2EE Agents on WebLogic server based on requirements.
• Experienced in provisioning users (Security Manager) and setting up/manage source and target system connections (Topology Manager) in ODI.
• Experienced in developing stored procedures, functions, packages and database triggers using Oracle SQL Developer and PL/SQL to improve query performance.
• Strong SQL knowledge. Familiar with creating queries, tables, views and other relational objects, and maintaining the referential and data integrity.
• Experienced in gathering business requirements developing business requirement document, data mapping documents.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem-solving skills in the technology arena.
• Established and maintained productive working relationship with Management, Clients and Team Members. Self-starter, highly motivated team- player with excellent communication /problem-solving skills. Quick learning ability vis-a-vis new technology. Easy adaptability to new environments.
• Subject matter Expert for ODI projects.
• Expert in Dimensional modeling and Data Warehouse designing.
• Lead and train team. Also coordinate with offshore Leads to delegate work.
• Requirement analysis and Detailed Design development.
• Designed the HLD over the client framework.
• Creates Proof of Concepts to explain above implementations and ODI functions. Developed POC to suite the Business requirements like SMTP email alerts, SSL enabled data source, Dynamic mapping (Mapping in prod changes automatically when new source columns are added), etc.
• Create/Modify ODI Knowledge modules to in corporate tuning options.
• Data Modeling and Flow design.
• DDL Scripting and Data Transformation creation.
• Create and Administer the Data Servers, Physical architecture, Contexts and Logical Architecture in different environments.
• Designed User Interfaces for APEX applications.
• Handled High Availability and Performance Tuning of the ODI components.
• Point of contact for Standard Testing team for Defect analysis and Fixes.
• Building and integrating Web Services into ODI.
• Support the CTRL-M batches in Production Environment.
• Handle the Remedy Incidents and track.
• Generate batch analytics of the production runs and give estimated reports availability timings.
• OSB scenario creation, Xqueries creation and testing with Java Stubs.

TECHNICAL SKILLS:

Tools: used: Oracle Data Integrator (ODI) 12c,11g Oracle Business Intelligent (OBIEE) 12c,11g PowerBI Oracle Data Visualization Tableau Oracle Application Express (APEX) 4,5 Oracle Warehouse Builder 10g,11g Oracle GoldenGate (OGG) WebLogic Server 12c Tomcat TIBCO Designer Suit 4.xx Oracle Service Bus (OSB) SQL Developer Data Modeler

Programming Languages: Shell, Powershell, Groovy, C, C++, Java, Basics of J2EE

Web Technologies: XML, XSLT, WSDL, HTML, CSS

OS: Macintosh, Windows, Unix

Applications: SQL Developer, SOAP UI, Eclipse

Version Control Tools: GitHub, Visual Source Safe, Rational rose Clearcase, Jenkins

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analyst, Data Modeler, Developer-Lead

Responsibilities:

• Design Account Profile Attributes Sourcing, Consolidation and Uploading Interfaces.
• Design Data warehouse tables (OLAP). Create Facts and Dimension based on OBIEE requirements and Partition table for better performance.
• Gather business requirements and create use cases.
• Create Detailed Design Documents and Unit Testing Plans.
• Lead and train team.
• Review codes and designs.
• Coordinate the deliverables ODI and Data model deliverables.

Technologies: Oracle Data Integrator 12c, Oracle Golden Gate, SQL Developer Data Modeler, WebLogic Server 12c, Web Services, SSL, PL/SQL, DB2, GitHUB for Version Control, Confidential Compare.

Confidential

Senior Analyst Programmer

Responsibilities:

• Developed POC to suite the Business requirements like SMTP email alerts, SSL enabled data source, Dynamic mapping (Mapping in prod changes automatically when new source columns are added), etc.
• Designed the HLD over the client framework.
• DDL Scripting and Data Transformation creation.
• Requirement analysis and Detailed Design development.
• Create and Administer the Data Servers, Physical architecture, Contexts and Logical Architecture in different environments.
• Worked with multiple datasets, unions, joins, filter.
• Configure, Create and Test the variables, Sequences and Procedures.
• Design the Interface and create Package Flow.
• Give Generic Sessions on ODI for new resources.
• Create pattern document for describing common project level implementations.
• Handle KT, Work assignment and supervise for newcomers.
• DB modifications based on the requirement and data sample reports.
• Help team to understand the flow and different components of the tool.
• Explore the new capabilities of tool to provide best solution for client.
• Unit Testing Plan Creation and Review.
• Integration Testing, Code Reviews and Code Optimizations.
• Point of contact for bug analysis and fixes.
• Tuning for High Availability and Performance improvement.
• Support the CTRL-M batches in Production Environment.
• Handle the Remedy Incidents and track.
• Generate batch analytics of the production runs and give estimated reports availability timings.

Technologies: Oracle Data Integrator 11g, Oracle Golden Gate, Unix Commands, Groovy Code, Web Services, SMTP, SSL, PL/SQL, MS SQL, DB2 Commands, GitHUB for Version Control, Confidential Compare.

Confidential

Architect and Developer

Responsibilities:

• Developed POC to showcase the APEX capabilities.
• Requirement analysis and Detailed Design development.
• Data Modeling to store all possible mappings and transformations that can be created in ODI.
• Designed the web-based GUI.
• Developed the complete web application to consume existing Mapping sheets and for the Data Lineage.
• Gave KTs on APEX for improvising classic tools at Confidential .
• Developed complex dynamic actions and Complex tree queries.
• Pages were completely customized with graphics and colour coding.
• Flawless navigation thru the pages, takes users to required information from any page. Example user can navigate to interfaces of Application from the versions of mapping and back to list of projects from there.
• Used cascading master child forms.
• Created custom page and Reports template.
• Created multiple CSS styles for Buttons, paragraphs and HTML regions.

Technologies: Oracle Application Express, Oracle Data Integrator 11.1.1.6.

Confidential

Senior Analyst, Developer

Responsibilities:

• Developed POC to Explain DB to XML.
• Created Document to Explain reverse engineering of XML to handle as Relational Database.
• Designed the HLD over the client framework.
• DDL Scripting and Data Transformation creation.
• Requirement analysis and Detailed Design development.
• Create and Administer the Data Servers, Physical architecture, Contexts and Logical Architecture in different environments.
• Design the Interface and create Package Flow.
• Give KT on ODI for new resources and also about the PPLV.
• Integration Testing, Code Reviews and Code Optimization.
• Coordinate with onsite counterpart for requirement gathering and analysis.
• Design Common flow for the team to follow.
• Handle the Resource allocation.
• Offshore Point of Contact for technical details and implementation.

Technologies: Oracle Data Integrator 11.1.1.6, Unix Commands, Groovy Code, Web Services, PL/SQL, GitHUB for Version Control, Confidential Compare.

Confidential

Developer

Responsibilities:

• Analyze Requirements and Specifications for compatibility with the backend services.
• Create Design documents and WSDLs for services with one or more interfaces based on the specifications sent by onsite team.
• Develop services for the same in OSB as per the design document which involve Proxy service, Transformation service, XQuery and End Point Service.
• Debug the existing service in case the functionality is not achieved.
• Suggest and Create Proof of Concepts for new capabilities.
• Build and Deploy OSB services on various environments along with supporting files.
• Maintain Versions with SCM tools in Local and Master repositories.
• Improve the auditing tools and process with required modifications in tools and process.
• Was involved in development of stubs and iStubs for testing independently on JAVA.
• Started working on BPEL, which will replace JAVA In the project.

Technologies: Oracle Service Bus 10g, WebLogic, Rationalrose Clear Case.

Confidential

Developer

Responsibilities:

• Coding and Testing using TIBCO BW and TIBCO EMS.
• Included interfaces that involving createAccount, fetch Details etc...
• The TIBCO Businessworks process receives messages front-end system. Based on the request type and mode it is dynamically rooted. This Business work process transforms the message using the data mapping sheets as the input.
• The Input fields like the PIN and SSN are verified by calling the corresponding database. In case of invalid inputs, the fault message is sent back.
• After processing the message, Business functionality is carried out and the process publishes the message onto a EMS queue.
• Reviewing technical design documents and code reviews.
• Deployment of the developed modules in TIBCO Admin.
• Worked on creating testing stubs for the project.
• Code reviews and group reviews and assisting other members in understanding requirements.

Technologies: TIBCO BW, TIBCO EMS, XML, TIBCO Administrator.