Engagement Lead/ Solution Architect Resume
SUMMARY:
- Over 13+ years of experience in BI, ETL, Data Warehousing and Data Engineering. A data engineering professional with substantial experience designing and executing solutions for complex business problems involving large scale data warehousing, real - time analytics and reporting solutions.
- Hands on expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation).
- Part of End to End implementations, Upgrade, Support Engagements, SDLCs and Transition of BI&ETL projects.
- Expert level experience of Data Engineering tools like ODI, OBIA, OBIEE and Informatica. Capable to work on any Data Engineering and Analytics Projects, Certified BI Professional.
- Leads and independently analyzes and completes complex business intelligence data, report and dashboard requests and provides support for assigned applications and systems by performing workflow assessments, capturing business needs, and analyzing systems to determine functional requirements while mentoring other analysts.
- Leads as a Subject matter expert or PM on complex data projects to design and architect solutions, guides the development of test cases and scripts, manages project resources and ensures projects meet business and IT objectives
- Worked in Oracle Cloud teams and good knowledge and understanding of AWS Cloud.
- Experience designing, reviewing, implementing and optimizing data transformation processes in the ODI, Hadoop and Informatica ecosystems. Able to consolidate, validate and cleanse data from a vast range of sources - from applications and databases to files and Web services
- Capable of extracting data from an existing database, Web sources or APIs. Experience designing and implementing fast and efficient data acquisition using Big Data processing techniques and tools
- Experience in building large-scale data processing systems and serving as an expert in data warehousing solutions while working with a variety of database technologies. Experience architecting highly scalable, distributed systems using different open source tools as well as designing and optimizing large, multi-terabyte data warehouses. Able to integrate state-of-the-art Big Data & Cloud technologies into the overall architecture and lead a team of developers through the construction, testing and implementation phase.
- Experience in effort estimation, risk and Gap analysis, quality reviews, overall solution and service solution RFP responses
- Familiarity with technologies Hadoop, Spark, Kafka, EC2, EMR, RDS, and Redshift in supporting data transformation, data structures, metadata, dependency and workload management
- Provides technical leadership in a pre-sales and post-sales capacity for customers to support successful understanding, evaluation and adoption of BI Solutions
- Working experience with world’s leading clients across different industries & locations
- Have worked in multi-various domain like Banking, Retail, Health care, Manufacturing, Marketing &Telecom etc.
SKILL:
Data Engineering: ODI, Informatica, AWS Data Glue
Visualizations: OBIEE, BI Publisher, Tableau
Databases: Oracle, MS SQL Server, DB2, Amazon RDS, PostgreSQL
Programming: SQL, PL/SQL, UNIX Shell scripting, Python
Big Data Ecosystem: Hive, NoSQL
Operating System: Linux, Solaris, Windows
Cloud Platforms: Oracle, AWS
Other Utilities: OBIA, Oracle Apps11i /R12, Discoverer4i/10g, Oracle Developer 6i/10g, Hyperion, Exalytics, Endeca, TOAD, SQL Developer, PUTTY. Interaction with Siebel, JDE, JDA, RMS, PeopleSoft, IRI, Oracle RightNow etc
Support: ITIL (Change Management, Incident Management, Problem Management)
Delivery: Architecture, Project Planning, Analysis, Design, Implementation, Quality Assurance, Performance Management, Release Management
SDLC: Agile, Waterfall
Leadership: People Management, Organization Development, Strategic Planning, Project/Program Management, Product Management, Budgeting, Communication
Collaboration: Negotiation, Vendor Management
PROFESSIONAL EXPERIENCE:
Confidential
Engagement Lead/ Solution Architect
Tools: OBIA, OBIEE, BI Publisher, Exadata, ODI, Python
Responsibilities:
- SME for all BI related queries, tickets and issues.
- Work on Reporting and ETL team troubleshoot issues.
- Work with business users on BI adoption.
- Enabling Incident Management /Change Management and Problem Management for BI support
- Performing major and minor enhancements using OBIEE, Tableau, Informatica and Python
- Performing data analysis, to answer user queries and data validation, etc.
- Developed Data visualizations using OBIEE and BI Publisher.
- Managing and coordinating teams in various time zones.
- Involved of Migration on prime to Oracle Cloud of OBIEE environments.
- Involved in requirement gathering, Fit-Gap Analysis, creation of Module design document to track functional and technical requirement
- Performed SQL, BI and ETL tuning.
- Developed the dashboard to help the data Quality issues
- Developed BIP Reports for reconsolidations
Confidential
ETL Lead
Tools: and Utilities: Linux, Unix, Windows and Oracle Exadata environments, several data warehousing and reporting tools including PL/SQL programing, ODI,OBIA, OBIEE, Tableau, Informatica, Snaplogic, Oracle ServiceNow and DAC. Exadata, Exalytics, Oracle Endeca, OBIEE, Tableau, Python, AWS, Hadoop, EC2, EMR, RDS, and Redshift.
Responsibilities:
- Expertise of distributed systems driving large-scale data processing and analytics with a successful history of manipulating, processing and extracting value from large disconnected datasets
- Conducted requirement gathering sessions with business users to come up with data pipeline design for enhancements and needs from visualization tools.
- Gained advanced working database knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases such as Microsoft and Oracle databases to advance analytics capabilities
- Developed the data pipelines for data ingestion from various sources using ODI and Informatica.
- Responsible for ETL/BI implementations, Support and Upgrade Projects which includes of standalone modules and BI Apps modules such as Procurement and Spend Analytics, Order Management and Supply Chain, Financial Analytics and Spend Classification.
- Involved in preparing effort estimation, risk and Gap analysis, quality reviews and user acceptance testing.
- Accountable for formulation of the process and coding to maintain data quality and adhoc reports, in addition to the automation of process using Shell scripting and ODI scheduling.
- Involved in rigorous technical analysis, performance tuning.
- Experience on the full data mining steps from data preparation, modeling, visualization and interpretation.
- Responsible for maintaining schedules and managing midsize teams, where he led them in Design, Analysis, development and documentation
- Responsible to handle and fix the issues during stabilization period.
- Prepared the support documents and transitioned the project to the Support team.
- Develop Data visualizations using OBIEE, BI Publisher and Tableau
- Enabling Incident Management, Change Management and Problem Management for BI support
- Performing major and minor enhancements using OBIEE, Tableau, ODI, Informatica and Python
- Performing data analysis, to answer user queries and data validation, etc.
- Managing and coordinating teams in various time zones.
- Developed evaluation and suitability matrix.
- Provides the optimal Data ingestion (ETL) Solution (Batch/Stream) to extract and load the data from different source system to Data Mart.
- Extensive experience in OLAP and interacted with heterogenous OLTP source systems like EBS, Peoplesoft, Siebel RMS, AS400 etc
- Create the Technical Design Specification Document.
- Design POC Mappings and helped the ETL team on data acquisition techniques and loading strategies during the development phase.
- Worked as a SME for Integration related data for the different affiliate (65 countries data)
- Worked with vendors to organize demos and trainings.
- Performed POC setups.
- Drafted and presented the recommendation proposal to review board.
- Build KPIs and Data Stories for executive reviews
- Build and Data Stories for executive reviews.
- Produced insightful reports that can be shared with and actioned by Management
- Developed Data Quality dashboards to prevent the data issues and improve the data quality
- Good understanding of ITIL support processes
Confidential
BI SME
Tools: OBIEE, Exadata, Exalytics, Oracle Endeca, Tableau, Bigquery, Python, Spark, Airflow
Responsibilities:
- SME for all BI related queries, tickets and issues.
- Help ETL and Reporting team troubleshoot issues.
- Work with business users on BI adoption.
- Enabling Incident Management /Change Management and Problem Management for BI support
- Performing major and minor enhancements using OBIEE, Tableau, Informatica and Python
- Performing data analysis, to answer user queries and data validation, etc.
- Developed Data visualizations using Tableau and Big query.
- Managing and coordinating teams in various time zones.
- Perform SQL and ETL tuning.
Confidential
Consultant
Tools: and Technologies: OBIA, BI Publisher, OBIEE, Data Warehouse, DAC, ETL Tools: Informatica & ODI, SQL, PL/SQL, JAVA, Oracle, Essbase, Siebel Applications, Operating Systems: Windows, Solaris, LINUX and UNIX; TOAD and SQL Developer.
Responsibilities:
- Architecture and design for Implementation, Upgrade & Maintenance of OBIA Projects.
- Responsible for project lifecycle, includes. Analysis, design, development, implementation, support and enhancement
- Contributes to the requirements elicitation process by creating assigned parts of the requirements documentation by interacting with customer.
- Participate in creating application architecture document to provide deliverables in line with architectural requirements.
- Creates low level design artifacts independently and high-level design artifacts with guidance and supports prototyping through creation of POCs.
- Explore existing OBI Warehouse and provide quick prototype.
- Delivers high quality code deliverables and supports peers in quality checks such that design requirements are met.
- Leads validation activities for the assigned sub-modules for all types of testing e.g. Functional, Integration, System, User experience.
- Performs root-cause analysis of any issues that arise post implementation and works on solutions related to issue fixing.
- Participate in KT sessions, help prepare system appreciation documents and support the Transition process.
- Collaborate and provide necessary support to the deployment team.
- Does impact analysis of issues logged, prioritize and ensure that production support is provided as per the committed SLAs.
Confidential
Technical Analyst
Tools: and Technologies: Oracle BI Applications (Marketing Analytics, Financial and Procurement & Spend), Siebel 8.1.1.3, Oracle 11g, Linux x86-64, BI Publisher Reports, Oracle Business Intelligence Enterprise Edition OBIEE V 10.1.3.4.1 , Informatica 8.6.1,ODI and DAC, Oracle Apps 11i (Rel 11.5.10.2), Oracle Forms 10g, Oracle Reports 10g, Oracle Financial and Supply Chain
Responsibilities:
- Worked in OnDemand Unit, now it is calling as Oracle Cloud unit. Responsible for a technical interface for customers, Original Equipment Manufacturers (OEMs) and Value-Added Resellers (VARs) for resolution of problems related to the installation, recommended maintenance and use of Oracle Products. The primary task was to implement the solution, consulting, Developing the solution, support to customers who contact the Oracle Solution Center and maintain a high level of customer satisfaction while meeting guidelines.