QUALIFICATIONS PROFILE:

• Solutions - oriented Application Engineer & Delivery Manager with a proven track record of effective design and development through 18 + years of experience in EAI,
• Big Data and Hadoop Ecosystem, data modeling and data warehousing and data integrations for supply chain, financial, inventory, payroll, auto claims, auto underwriting, entertainment industry and Medicare systems.
• Over 12 + years of Solid EAI expertise utilizing See Beyond (Data Gate/e*Gate/SRE & JCAPS & DATASTAGE & INFORMATICA) Interface Tool to design and execute various applications involving ERP & HL7 & Dataware House.
• Design and Develop an enterprise wide SeeBeyond’s EAI e*Gate (v 4.1.2, v.4.5.1, 4.5.2 and 4.5.3) interfaces between HTTP, HIPPA, XML, Oracle, SAP and flat-file in Windows-2000 and Unix environment using e*Ways, Oracle/SQL Server/Sybase e*Way Connections, JMS Connections, IQs, JMS IQMgrs, Active Directory, ELS, Monk and Java.
• 5 + years of Extensive experience with data modeling and data analysis, interacting with legacy systems including SAP, Mainframe, and Oracle Financials.
• Deep knowledge of Oracle database features, utilities, and tools including Designer 2000, Developer 2000, and Erwin.

TECHNICAL SKILLS:

Big Data / Hadoop: Hadoop Distribution Amazon 2.7.2, HBase 1.2.1, Phoenix 4.7.0, Hive 1.0.0, Pig 0.14.0, Hue 3.71, Spark 1.6.2, Scala, Oozie 4.2.0, Zookeeper 3.4.8, Sqoop 1.4.6

EAI: SRE 5.0.5, JCAPS 5.X, SeeBeyond e*Gate 4.1.2/V 4.5.2/4.5.3, DataGate 3.5.2, HL7, X12, ELS, e* Gate Monitor, LDAP, Active Directory, Siebel (7.8.2).

Integration: SeeBeyond e*Gate (v.4.1.2/ v.4.5.1/v. 4.5.2/4.5.3 ), Monk, e*Xchange, SAP BAPI, Oracle, SQL Server, Sybase, Batch, File, and email e *ways, X12 and HL7 standards

Tools: Tableau, SQL Navigator, TOAD, SQL*Loader, Developer2000 (Forms, Reports, Graphics), Crystal Reports, Test Director, Designer/2000, Erwin, Power Designer, Server Manager, Enterprise Manager, Replication Manager, Livelink, Kanata, Informatica Power Center 7.1.3 & DataStage 9.1.0

Database: Oracle 7.x/8.x/9i/10i, Sqlserver 2005/2008, Sybase, Teradata, DB2, PostgreSQL.

Internet: JavaScript 1.2, DHTML, JSP, HTML 4.0

Web Server: I Planet 3.6/4.1

Platforms: UNIX, UNIX-AIX, Windows 95/98/2000/NT/XP, MS-DOS, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, CA

BI Technical Architect /Delivery Manager

Tools: included Hadoop Distribution Amazon 2.7.2, HBase 1.2.1, Phoenix 4.7.0, Hive 1.0.0, Pig 0.14.0, Hue 3.71, Spark 1.6.2, Scala, Oozie 4.2.0, Zookeeper 3.4.8, Sqoop 1.4.6, Amazon Redshift, Tableau, Datastage 9.x, Jira, Mingle, SQL Server 2008, DB2 10.x, Shell Scripts, Java Scripts, JDBC, PostgreSQL, Toad for DB2 5.1.0, Windows and Linux Systems.

Responsibilities:

• Conducted cross-functional meetings to map current business processes and collaborated with business units to revise and create processes and procedures.
• Analyze and define clients’ business strategy and determine system architecture requirements to achieve business goals.
• Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.
• Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize object-oriented software and database development.
• Successfully delivered couple of initiatives(Implementation & development) on Big Data Analytics and large data processing using Hadoop ecosystem viz. Pig/Hive, HDFS, Zookeeper, HBase, Phoenix, Oozie..
• Worked on Big Data ecosystem, Hadoop and Spark, Setting up a Data Analytics Platform primarily responsible for organization wide reporting base on Hadoop Cluster.
• Expertise in processing frameworks with Spark, designing HBase schema and managing large data ingestion using technologies like Flume, Sqoop.
• Extensively used Spark applications using Python, Scala and Java.
• Extensively worked on open source Pentaho to load data into stage with complex logic
• Planning, implementing and supporting of project delivery / deployment / release from development environment to testing environment (QA) and from testing environment (QA) to production environment in a distributed environment.
• Conducted meetings and discussions with Program Managers, Application Owners and Business Users to identify business requirements and to develop functional specifications. Identified and documented dependencies between various business processes.
• Developing policies, standards, procedures, processes, and performance standards
• Implemented application developments, resolved performance issues, and provided end-user training on hardware and software.
• Managed Scrum and Scrum meetings successfully.
• Implemented Daily Scrum activities to identify impediments, project mood and progress.
• Responsible for data analysis, requirements gathering, report analysis, source-to-target mapping, frequency analysis, process flow diagrams, and documentation.
• Designed job sequences to automate the process and document all the job dependencies, predecessor jobs, and frequencies to help the production support people better understand the job runs.
• Designed, developed and implemented Data Warehouse for ODS System.
• Used Amazon Redshift for Data ware housing for Smart Data Registry Project
• Designed and developed Generic Common Audit Control process for entire DataStage
• Implemented Logfiles, Outbound Feeds for Confidential
• Conducted reviews in design, development and QA.
• Created Technical Specification Documents, Functional Requirement Specification Documents which included Scenarios, activity, work flow diagrams and data mapping.
• Created detail Migration Plan for IT to deploy the changes to UAT and Production environments.
• Created DataStage Common Routines which are integrated with Unix Shell Scripts.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Managed and and coordinated with Onsite/Offshore team and implemented project deliverables and milestones successfully
• Created Unix Shell Scripts for the environments and automatic job schedules
• Proactively adapted new Technology (SAS) and implemented and compared successfully Mercer and Confidential output data.

Confidential, Los Angeles, CA

Application Delivery Manager

Tools: included Teradata13.0, BO4.0, Oracle 11i, Datastage 8.x and 9.01, Tableau, Jira, Autosys, SqlServer, Shell Scripts, Java Scripts, Toad8.6, Windows and Linux Systems.

Responsibilities:

• Initially hired as ETL Technical Architect and was awarded as great Leadership skills and was promoted as Application Delivery Manager.
• Awarded for Service Excellence, Great Leadership qualities, flexibility and adaptability of any Technology.
• Developed Processes and procedures as well as Program Plan, Risk Assessment, Organizational Structure, Communication Plan and Change Management Plan.
• Acted as Single Point of Contact for Project metrics, strategic project planning, and resource management and streamlined the process.
• Developed application development strategies, coding standards implementation, release procedures and high level system design documentation.
• Implemented Agile Methodology from Waterfall in order to resolve outstanding first release requirement issues.
• Managed and involved in all phases of Software Development Life Cycle (SDLC) of multiple projects.
• Facilitated meetings with Stake holders to review the migration plan and lead the upgrades from DataStage 8.5 to 9.1, Teradata 13.0 and Business Objects 4.0.
• Worked with Business Analyst, Stake holders and Development teams to gather and document requirements, designed and developed multiple projected and delivered it successfully ahead of schedule.
• Architected, Design and implemented successfully Rentrak project, Horizon Home Entertainment Project, Retail Link Project, Multi-Territory, AC Nilseon and GFK Sales Data Projects.
• Managed and coordinated with Onsite/Offshore team and implemented project deliverables and milestones successfully.
• As ADM, conducted meetings with Business Users/ Stake holders with (i) Weekly status reports, (ii) Release Schedule, (iii) Past Due Items, (iv) upcoming prioritized demand/check book plan, (v) Any high priority incidents and problems, (vi) Check point meetings/ Go or No Go and (vii) stake holder signoffs.
• Involved in documenting Technical Specs, Functional Specs, and Business Process Flow diagrams and created a centralized location on SharePoint. Once uploaded, the documents are reviewed and approved by the project coordinators.
• Maintained and created Scorecard for incident tracking and shared it with Business Users and Stakeholders.
• Managed IT Support teams, SLA monitoring and on time resolutions to clients which resulted in additional business to the company.

Confidential, Nashville, TN

Engineer/ETL Architect/Analyst

Responsibilities:

• Lead JCAPS Team both Off-shore and On-site with team of 15.
• Provided Solutions Architect for Loading Customer, Booking and Charges data from various systems such as 5x5/LMS/AV & Acxiom to Dataware House.
• Worked on Dataware house dimension load and defining Type1 and Type2 Records.
• Worked on JCAPS ETL Data Load Process.
• Configured Complex Business Process flows & Connectivity Maps in JCAPS.
• Created complex Stored Procedures and Invoked through JCAPS.
• Created Custom, Database, FlatFileDB, FTP & XSD OTDS in JCAPS.
• Worked on Complex JCDS and ETLS and eViewer Applications.
• Involved in Creating Functional Specs, Source to Target Data mappings & Unit Test cases and System Test Cases.
• Created Job Schedule Controls.
• Worked with Axiom 3rd party to integrate the MDM process for Confidential properties.
• Awarded “Leadership Qualities” from VP Of IT from Confidential .

Confidential, El Segundo, CA

Team Lead/Integration Engineer Admin

. Tools: included Oracle 8i, 10i, ICAN SRE5.0.5, JCAPS 5.X, JCAPS 6.X, NetBeans 6.0 editors, e*Gate4.5.3, e*Gate4.5.2, Java, JDBC2.0, e*Ways (Oracle e*Way, Batch e*Way, SIEBEL EAI e*Way, HTTP e*Way, SQL SERVER e*Way, Syabase e*Way), LDAP, Active Directory, Mercator, SQL*Plus, Informatica, PL/SQL, and SQL*Loader in a Windows and unix-aix environment.

Responsibilities:

• Gathering User requirements and creating the Functional Specs and data mapping specs Interface between Siebel to ODS Oracle Database.
• Involved in major upgrades from eGate 4.5.3 to SRE 5.0.5 and JCAPS 5.x.
• Extensively worked with end users to gather the user requirements.
• Extensively worked on creating the Common services for LDAP and Active Directory using eGate.
• Engineered Oracle database e*way to store and retrieve data for billing purposes.
• Designed the XML ETDs and mapped the inbound and outbound event types.
• Worked on Interface between Siebel Wiz Pac Tickets to ODS database.
• Worked with OffShore Team to convert all Javacaps to SOA (BPEL/ESB).
• Created BPEL Project and build the project using JBI application.
• Worked on Bi-Directional communications using common Intgrated components such as JBI(BPEL 2.0, BC) and Repository(OTD/JCD/eway/BPEL 1.0)
• Completed working on implementing the Common email services between Siebel2ODS, Siebel2ISIS, SBR, Passman, Billing2Siebel Interfaces.
• Generated the Custom eGate logs for end users
• Worked on Manual Database connections and Siebel Connections.
• Configured the Dynamic Scheduler e*Way which will trigger the Multiple different components.
• Configured the FTP e*Way to collect client data and used HTTP e*Way to post the message to Siebel.
• Created Stored Procedures to load the data coming from External systems to Oracle.
• Worked on multiple interfaces such as Billing/Pac Tickets/Order/Billing/Customer/Affiliate Order/Isis which sends data to wizard and ODS.
• Integrated with Mercator Programming Interface.
• Created on Clustering Environment.
• Granted user access roles.
• Created New Production environment for SRE migration from eGate.
• As an Architect completely involved setting up new Production environment and re-configuring the stcms and JMS.

Confidential, Bartlesville, OK

Systems Analyst

Tools: included Oracle 8i, 10i, ICAN SRE5.0.5, e*Gate4.5.3, e*Gate4.5.2, Java, JDBC2.0, e*Ways (Oracle e*Way, Batch e*Way, SAP, ALE, BAPI e*Way, SQL SERVER e*Way, Syabase e*Way), Active Directory, SQL*Plus, Informatica, PL/SQL, and SQL*Loader in a Windows and unix-aix environment.

Responsibilities:

• Designed and Implemented a JMS Publisher to publish Pricing data onto JMS Intelligent Queues.
• Involved in gathering requirement from clients and design and architect the solution.
• Created and Configured the SAP ALE, SAP BAPI, Oracle, Multi-Mode, Batch e*Ways, IQs and defined the collaborations that route the data.
• Configured Multi mode e*ways for sending/receiving the events using e*way connections, from SAP to various databases (Oracle, Sybase, SQLServer).
• Wrote common java API classes that are used across different interfaces. API interacts with internal Oracle database to get SAP code descriptions.
• Used Java Collaboration rules to translate the iDocs information into a subscribing application message formats. Created and validated ETDs using sample data.
• Designed and developed the interfaces to SQL Server database and SAP.
• Designed the XML ETDs and mapped the inbound and outbound event types.
• Configured Multimode e*ways, JMS IQ Managers and JMS, BAPI, Oracle, Batch e*way, SQL SERVER, Sybase Connections.
• Involved in the production support and maintenance/testing of all interfaces.
• Migrated the existing applications from DataGate3.5.2 to e*Gate4.5.3.
• Migrated existing applications from e*Gate4.5.2 to e*Gate4.5.3.
• Involved in creating the Tech Specs, Unit Test Plans and Data Flow Diagrams using visio.
• Created Stored Procedures to load the data coming from External systems to Oracle.
• Configured the Dynamic FTP Batch.
• Configured the Dynamic Scheduler e*Way which will trigger the Multiple different components.
• Worked on ELS to Process the Prices Information which is coming from different sources.
• Extensively worked on creating the Common services for LDAP and Active Directory using eGate.
• Involved in SRE Migrations from eGate 4.5.3 to eGate SRE environmet.
• Extensively worked on Informatica Power Center to write the Interfaces.

Confidential, Los Angles, LA

Systems Analyst

Tools: include Oracle 8i, e*Gate4.5.3, Oracle e*way, Batch e*way, SQL*Plus, PL/SQL, and SQL*Loader in a Windows and unix-aix environment.

Responsibilities:

• Created HL7 TCP/IP e*Way Configuration using Stcdgwtcpiphl7.exe.
• Created Oracle e*Way/Batch e*Way Configuration Using Stcgenericmonk.exe with the options of (Batch/Dart).
• Created the Dart Scripts for accessing Oracle Data.
• Extensively worked in Clinical Systems like CTMS.
• Responsible for Production Support for the Above Specified Interfaces
• Developed technical specifications and test plans. Tested and migrated the Schema components to the Production server.
• Responsible for Creating the Shell Scripts for ftping the files to the Unix Servers.
• Created the ETDS(Event Type Definitions) using the following standard HL7 message structures i.e. A01, A02, A03, A04, A05, A06, A07, A08, A11, A13, A18, A24, A28, A34 and A36.