Shravan Kumar Mansani
Development
MO, United States
Skills
Data Engineering
About
SHRAVAN MANSANI's skills align with Programmers (Information and Communication Technology). SHRAVAN also has skills associated with System Developers and Analysts (Information and Communication Technology). SHRAVAN MANSANI has 16 years of work experience.
View more
Work Experience
Senior Software Engineer
Mastercard
April 2023 - Present
- Senior Software Engineer Apr 2023 - Till Date Mastercard * Developed Splunk queries to establish alerts for job failure notifications * Written Java code and Junit test cases for writing data to HDFS in Parquet format * Collaborated with Streaming data sets to ingest data from Kafka topics for loading into HDFS * Oversaw the migration of on-premises Streaming jobs to ingest data from MKS and load into EBS * Transferred on-premises batch jobs to AWS EMR and Glue jobs for enhanced efficiency * Configured EC2 instances for loading data from EBS to S3 buckets * Developed Shell scripts for archival of data to improve performance of the application by 30% * Creating Airflow DAGs using GlueJobOperator and deploy Glue jobs * Designed scripts to auto restart processes, reducing downtime and minimized business impact by providing proactive production support to address job failures promptly * Deployed, monitored, and supported Production jobs, addressing any failures promptly Tools & Technologies: * Cloudera, AWS, S3, Glue, EMR, Airflow, Splunk, Linux, Sqoop, Nifi, Spark, Hive
Consultant
Re-Insurance Group of America
June 2020 - April 2023
- * Gathered requirements from the user community and performed gap analysis and built the solution * Configuring and scheduling of Tidal jobs to execute ETL processes as required * Supported new jobs in UAT and Production environments * Provided Production support to job failures in Production * Building an automated solution for handling load failures * Performance Optimization of ETL jobs * Integration of the data from multiple servicer files * Building an automated solution for generating business extracts as per the required business logic * Configure business logic to perform business validations of the data * Scheduling and orchestration of the job to process the data whenever a source file is placed and send the file in the required data to the external clients * Implement manual business logic to automatically include or exclude data processing jobs to avoid data inconsistencies Tools & Technologies: Tidal, Oracle, Vertica, SQL Server, Informatica
Consultant
Compunnel Inc
June 2020 - March 2023
Senior Developer
World Wide Technology
April 2018 - June 2020
- * Gathered requirements from the user community and performed gap analysis and built the solution * Extraction of data from different cloud applications like Salesforce, Empower, Bullhorn, ADP and Service Now using Rest API and Oracle Data Integrator and Oracle eBS * Extraction of Data from Oracle EBS and Oracle Cloud using Oracle Data Integrator and Oracle BICCC and Oracle UCM * Developed ODI mappings, packages, scenarios and Load Plans using ODI 12c to replace existing ETL code * Developed data solutions for business requirements using Oracle SQL/PL SQL * Improved the performance of the execution of ODI Packages and Oracle SQL queries * Implemented a PoC on Python for ETL purposes * Development and supporting reports using IBI WebFocus Developer Studio * Development and providing support to Tableau data sources for creating workbooks * Supporting users from multiple teams like Finance/Supply Chain/Sales with data from various systems Tools & Technologies: Oracle, Oracle Cloud, ODI
Senior Developer
World Wide Technology
April 2018 - May 2020
Senior Corporate Business Consultant
Perficient Inc
August 2015 - January 2018
- * Gathered requirements from the user community and performed gap analysis and built the solution * Implemented the required changes in the data warehouse for generating the required reports * Developed ODI mappings, packages, scenarios and Load Plans using ODI 12c to replace existing ETL code * Developed, tested and fixed the Informatica SCD Type 2 ETL mappings and related ETL objects to fix the data discrepancies in the fact tables data * Improved the performance of the ETL jobs by optimizing the SQL queries in the Informatica Lookup overrides and other techniques * Migrated reports from on premise OBIEE system to new reporting system (BICS) * Developed, tested and migrated the OBIEE reports and OBIEE RPD * Development of Tableau visualizations, dashboards, worksheets, extracts, data sources, filters, parameters and other reporting features * Designing all the three layers of the RPD to build the fact and dimensions for reporting * Held meetings and discussions with the source team to understand the data points and build the ETL Tools & Technologies: ODI, Informatica, OBIEE
Corporate Sr Business Consultant
Perficient Inc
September 2015 - January 2018
Consultant
Syspro Technologies Inc
July 2014 - August 2015
Consultant
Gartner
March 2015 - August 2015
- * Developed SQL Procedures to get the required data from multiple Sales systems, and modified existing tables, views, and SQL*Loader scripts * Defined and executed the load rules for loading Essbase Cubes with the data from Relational Tables * Development of ETL components (Interfaces/Packages/Load Plans) using ODI 11g and Oracle * Configured OBI RPD to import the data from Essbase Cubes and Oracle Relational Database * Importing specific configuration of Essbase Cubes into OBI Tools & Technologies: ODI 11g, OBIEE 11g, BI Publisher 11g
BI Consultant
PNC Bank
July 2014 - March 2015
- * Working closely with financial analysts to understand the report details to the end user community * Customized and developed the OBI repository * Created scripts to load the data from MS SQL Server to Oracle Database * Developed Informatica mappings and workflows to support ETL code * Created custom reports to produce pixel perfect reports using BI Publisher desktop to generate RTF templates for generating BIP reports * Analysis and implementation of the reporting requirements of the LCR project * Implemented PoCs on the reports User Interface requirements * Implemented complex sql queries to implement the BI Publisher reporting requirements Tools & Technologies: Informatica, OBIEE 11g, BI Publisher 11g
Project Lead
Tech Mahindra Ltd
June 2013 - June 2014
- Project Lead Jun 2013 - Jun 2014 Tech Mahindra Ltd * Proposed the enhancements required and effort estimates for the data warehousing and the reporting requirements * Developed the reports by using complex SQL queries to feed the BI Publisher reports for the Accounts Reconciliation Management (ARM) for GE Finance * Customized and developed the OBI dashboards and reports * Implemented changes to the Star Schemas and in all the 3 layers of the RPD * Created and modified hierarchies in the Business Model and Mapping Layer * Fixed performance issues for improving report performance Tools & Technologies: OBIEE, BI Publisher, Tableau, Informatica
Technical Analyst
Oracle India Pvt Ltd
October 2011 - June 2013
Technical Analyst
Oracle India Pvt Ltd
October 2011 - May 2013
- * Provided technical support to clients and internal stakeholders, troubleshooting issues and implementing solutions to ensure system stability and performance. * Maintained Human Resources (HR) Analytics and Financial Analytics applications * Designed and implemented custom business intelligence solutions (Dashboards/Reports) and dashboard prompts using the BI Applications Analytics platform * Managed upgrade and maintained the environments with latest patches Tools & Technologies: OBIEE, Siebel, Informatica, Oracle
Sr. Software Engineer
Wipro Technologies
September 2007 - October 2011
Senior Software Engineer
Wipro Technologies
September 2007 - October 2011
- * Analysis of the required metrics and their functional usage * Proposed and formulated the metrics as per the requirement * Involved in the design activities and created the design specifications and documents * Analyzed the functionality of the application from all the aspects of the data flows from different sources into the data warehouse * Enhanced the data model to generate the reports and the dashboards Tools & Technologies: OBIEE, Siebel, Informatica, Oracle, DAC Page1
Education
Osmania University
Masters of Computer Application
