SUMMARY

• 14+ years of extensive experience in software industry, specialized in Business Systems analysis, Software development, Architecture and Administration including Oracle SOA technologies, MuleSoft, PL/SQL, Java, ETL, Data Warehousing, ERP, BI, EDI and Oracle WebLogic 10g/11g.
• 6+ years of PM/PO/BSA experience in managing Data migration, Enterprise Integrations, Cloud Infra setup, Devops projects. End - to-end Business Requirements Gathering & Analysis experience and expertise in dealing with both internal and external stakeholders.
• 4+ years of Design, Architecture & Infra setup experience in various Cloud application like Mule Cloud, Onestream Cloud, AWS Cloud and Azure Cloud.
• Proficiency and experience in Oracle SOA - Service Oriented Architecture (BPEL, OSB and ADF), Mulesoft, Java Rest API, Event Driven and Message Based (JMS) architectures.
• Demonstrated expertise utilizing ETL tools like Informatica, Talend & RDBM systems like Oracle, and DB2.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers, Views, DB Links to retrieve, manipulate and migrating complex data sets in Oracle Databases 10g/9i/8.x/7.x.
• Experience in Data Modeling (ERWIN) & UML Modeling, Data Migration & Data Conversion.
• Extensively used Python, UNIX shell Scripts for automating batch programs.
• Good Knowledge of Big Data /Hadoop Ecosystem.
• Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLAP and OLTP processing. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Adapts to new systems and environments quickly and capable of transforming business requirements into technical solutions.
• Detail-oriented with excellent analytical, troubleshooting and problem-solving skills.
• Worked on functional domains like Finance, Banking, Retail, Insurance, Pharma, Utilities, Product, Logistics, Security and End-User support.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Java, Shell Script Programming, Python

Oracle Fusion Middleware: Oracle SOA Suite 11.1.1.6 (BPEL, OSB, ADF), JMS, JDBC, Adapters - DB, File, JMS, AQ

ETL/Reporting/BI: Informatica, Tableau, Einstein Analytics(Wave), SAP BO, QlikView

Databases: Oracle 8.x/9i/10g/11g, Sybase, IBM DB2, SAP Hana, AWS Redshift, Azure Cosmos DB

Monitoring/ Logging Tools: Nagios, Splunk, ELK, CloudWatch, CloudTrail, Azure Monitor, Prometheus, Grafana.

Administration: WebLogic Server, Oracle Database, Jira

DevOps: Azure HDInsight, Kubernetes, Dockers, Ansible, Jenkins, GIT, Terraform

Operating System: Unix, Linux, Solaris, Windows, Red hat, CentOS

Dev Tools: Oracle JDeveloper Studio 11g, TOAD, SQL Navigator, SQL*Loader, Erwin, Eclipse, SOAP UI, Edifecs, Microsoft Visio, Lucid Charts

Others: XML, JSON, Microsoft Office, SOAP, JDBC, FTP, HTTP, CPQ, GUS, Jira, Confluence.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr Technical PM/Scrum Master

Responsibilities:

• Meet with various Business stakeholders (Finance, Platform, EDW, BT teams) to gather detailed Business Requirements, Use Cases and translate Technical specifications into product requirements.
• Kept track of all project timelines and strive towards meeting project deadlines.
• Manage and allocate resources accordingly to multiple tracks within same project and across other projects.
• Update Planview sheets on a regular basis to inform the PMO team about the progress made by scrum teams.
• Prepared product road maps, backlogs, initiate and closed down the phase wise development activities spread across multiple sprints.
• Orchestrated communications between other Program Managers, Product Managers, and Senior Leadership to provide clear project visibility.
• Assisted Finance Team with Retiring SAP Business Objects, Confidential Einstein Analytics.
• Assist various teams with ongoing data migration activities from Oracle databases to Snowflake.
• Gather complete & precise details about Oracle Database schemas. All the processes/jobs needs to be recreated in Snowflake.
• Assisted Finance Team with successful implementation of Tableau as the main reporting system.
• Successfully delivered couple of High visible Finance Sales Dashboards (Mark Benioff level visibility)
• Conduct daily standup and scrum meetings with onsite-offshore resources to check on the project status.
• Prioritize various defects, enhancements and deliver the code fixes in a timely fashion.
• Assist Business users with UAT testing and get UAT signoffs.
• Perform code reviews and provide QA signoffs.
• Support and maintain Product documentation - Confluence pages, Google sheets, Google docs.
• Used SQL for back end testing, data retrieval and data analysis.

Environment: Oracle Database, Jitterbit, SAP BO, Informatica, Tableau, Einstein Analytics, Unix servers, Onestream, Python, Tidal scheduling assistant, Planview, GUS.

Confidential, CA

Technical Cloud Infra PM

Responsibilities:

• Implemented SDLC methods for the Development life cycle and followed the standards process in developing the application.
• As Technical PM - kept track of all project timelines and strive towards meeting project deadlines.
• Meet with various Business stakeholders (Finance, Tax & Treasury, Integrations teams) to gather detailed Business Requirements, Use Cases and translate Technical specifications into product requirements.
• Work with Finance PMO team for preparing product road maps, backlogs, initiating and closing down the phase wise development activities spread across multiple sprints.
• Represent FINBI team in the “AWS Cloud Migration” project meetings at Confidential .
• Assist various teams with data migration activities from on-premise data center to AWS Cloud - Redshift DW.
• Gather complete & precise details about Oracle Database schemas. All the schemas need to be recreated in AWS Redshift.
• Assist Developers with Transforming and loading data to AWS Redshift Data warehouse from on-premise datacenter using AWS DMS.
• Bring in Finance data from various source systems (SAP BPC, Revpro, SAP S4, ERP) into various Datamarts - Spendmart, Finmart, Revmart.
• Build Integrations using SAP CPI-DS for moving data from Anaplan, Concur to Datamarts.
• Identify logics and formulas for populating various dimensions, measures in Qlikview Dashboards. Qlikview Dashboards will to be converted to PowerBI dashboards.
• Conduct daily standup and scrum meetings with onsite-offshore resources to check on the project status.
• Create Business Critical/Flexible Releases (BFR, BCR, Jade requests) for sending code fixes to PROD
• Prioritize various defects, enhancements and deliver the code fixes in a timely fashion.
• Assist Business users with UAT testing and get UAT signoffs.
• Perform code reviews and provide QA signoffs.
• Support and maintain Product documentation - Wiki pages & Sharepoint.
• Used SQL for back end testing, data retrieval and data analysis.

Environment: Oracle Database, SAP Hana, SAP S4, SAP BO, SAP BPC, AWS, Informatica, Unix Servers, Python scripting, Qlikview, PowerBI.

Confidential, CA

Sr Technical PM/Scrum Master

Responsibilities:

• Meet with various Business stakeholders ( Confidential EU Legal Team, Finance, Employee success team) to gather detailed Business Requirements, Use Cases and translate Technical specifications into product requirements.
• Provide regular status updates to the Engineering and Product Management directors in the EDS all hands meeting.
• Traced and resolved critical issues related to manpower and the project to minimize risk factors.
• Assist Data scientists with data dictionaries & other data (Leads, Opportunities, Orders, Renewals) related help.
• Assist Data scientists in building machine learning models & ML pipelines for accurately identifying best leads out of thousands of leads marketing team brings to Confidential .
• Phoenix project is about replacing Oracle Hyperion Financial system with Onestream Cloud.
• Design and Develop 20 Integrations which will transfer data from various internal Confidential systems - Oracle ERP, EDW, Workday, Oracle Hyperion to the target system - Onestream Cloud.
• Leveraged the AWS S3 concepts for storing data temporarily before transferring huge data files to Onestream Cloud.
• Prepared the Functional Requirement Documents (FRD) as well as Non-Functional docs (NFR’s).
• Perform Impact Analysis and do Change control management for Change Requests (CR’s).
• Prepare ERD diagrams using Lucid Charts and maintain the project details on Confluence pages.
• Work with various stakeholders and assist them with executing the UAT Testcases and get signoffs from all respective parties.
• Coordinate with EMDS team for successful deployments and assist them in pre and post deployment activities.

Environment: Oracle Database, SQL, PL/SQL, Mule ESB, SOA, AWS, AI/ML, Onestream Cloud, Oracle Hyperion, Workday, Informatica, Unix Servers, Shell scripting, SFTP, Einstein Analytics.

Confidential, CA

Sr DWH/Infra Project Manager

Responsibilities:

• As a Data Architect/PM contribute to the Data Migration project - Teradata being replaced with Oracle Exadata. Also assist the team with Azure Infra Setup at DOR-SPG.
• Meet with end user groups to gather detailed Business Requirements, Use Cases and translate technical specifications into product requirements.
• Prepare the Business Requirement documents and Technical design documents.
• Perform Impact Analysis and do change control management.
• Generate Data reports for the State Health boards and other groups.
• Involved in Data Migration project - Teradata is being replaced by Oracle Exadata.
• Assist the Data engineers with setting up Azure, Hadoop Environment in SPG group. Act as a bridge between DOR IT and Kaiser IT teams.
• Involved in analyzing group how AWS Redshift or Azure SQL DWH can be used to replace the traditional DWH (Oracle/Teradata).
• Good Knowledge in Azure cloud services, Azure storage, Azure Data Lakes, Databricks & Data Factory. Managing Client's Microsoft Azure based PaaS and IAAS environment.
• Assist the Data scientists in their Data mining activities by providing them with regular SAS datasets.
• Generate Tableau monthly reports for the end users.
• Represent the Data Warehouse team in the monthly PAG status meeting along with Director of SPG and give status report of entire team to the Division of Research management.
• Prepared Flow diagrams for the projects using Microsoft Visio tool.

Environment: Oracle PL/SQL, Teradata, SAS, JAVA, Hadoop, HDFS, Hive, Sqoop, Unix, Oracle Exadata, AWS Redshift, AZURE cloud, Tableau, Python & Shell scripting, EDI, HIPPA.

Confidential, CA

Enterprise Integration Project Manager

Responsibilities:

• Responsible for delivering the Healthcare Reform project (end-2-end solution)
• Lead a team for Analysis, Design, Build and testing of OSB integrations based on business requirements.
• Managed financial tracking of project budgets to compare budgeted against actual project cost.
• Develop applications to integrate various Confidential systems like RMB, EEP & MTV.
• Meet with State/exchange partners to finalize the requirements.
• Worked on HIPPA 5010 Transaction sets (834/820/999/TA1), EDI/X12 and Edifecs, Medical trading partner format agreements and Transaction Companion guides.
• Creating Technical ADF workflows (Task flows for the business process).
• Deployed the EAR and WAR archives into Web logic Servers.

Confidential, CA

Enterprise Integration Project Manager

Responsibilities:

• Developed web services to integrate various PGE orgs like CC&B, Myenergy Portal with each other and with outside orgs like Kubra & Genesys.
• Developed Java web services and OSB web services.
• Converted JSON data to xml and vice versa while making REST calls to Genesys.
• Called Database Procedures, Functions from BPEL using DB Adapter

Confidential

OFM Scrum Master/SOA Tech Lead/Sr Integration Developer

Responsibilities:

• Developed applications to integrate various force.com orgs like Org62, Peopleforce, Supportforce & Oracle Financials(EBS) with each other and with outside orgs like Concur, Coupa & Workday.
• As Scrum master for the CE Scrum team manage the offshore team and eliminate any blockers for successful delivery of the projects in each sprint.
• Designed and created complete BPEL processes for orchestration using different process activities for Cisco Order Submission process.
• Prepared the partner WSDLs for all the services involved in orchestration.
• Involved in code reviews with other offshore team members and groups.
• Build the SOA environment and train CSI employees to handle the future development.