About Me

•  Pursuing Master of Science in Business Analytics and Information Systems at University of South Florida
•  3.8 years of experience as Oracle ERP/Technical Consultant in HCM & Finance domain.
•  Strong analytical background in data cleaning, transformation, analyzing and visualization of large data sets
• Proficient in Predictive Analytics, Data Segmentation, reporting and visualization using R, SQL, Excel, and Tableau.
• Good interpersonal and analytical skills and a hard working person with a zest to learn more.

Programming Languages: SQL, PL/SQL, UNIX, JAVA, R.
Familiar: NodeJS, Python, XML, XSLT, MVC, J2EE, JSP, Servlets, Struts, JDBC, HTML5, JavaScript, CSS, C++, Excel VBA.
Tools/IDEs: R Studio, XML/BI Publisher, SQLDeveloper, JDeveloper, Eclipse, MS Visual Studio, WinSCP, Putty, GIT, SVN
Visualization Tools: Qlik Sense, Tableau, MS Excel.
Big Data Ecosystems: MongoDB, Cassandra, Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig.
Databases/Frameworks: Oracle DB 10g and 11g, SQL Server, MongoDB, Oracle Application Framework (OAF).
Platforms: Windows, Ubuntu, Linux, AWS, Microsoft Azure
Oracle Application Modules: AP, AR, INV, OM, HRMS, GL, CM.

  Professional Summary

Managing Consultant (BI)

Capgemini

Pune, Maharashtra,     Oct 2012 - Jul 2016Previous Experience

• ETL scripts, Interfaces and Extensions design and development for data cleansing and migration activities using PL/SQL.
• Extensively developed Reports using XML Publisher (BI Publisher) for Order to Cash & Procure to Pay cycles. 
• Decreased component deployment time by 80% with the development of ‘Single Deployment Script’ in UNIX.
• Assisted in system requirement gathering, analysis, designing databases (schemas) with the technology teams.
• Created File Based Loader & OTBI/BI reports with HCM Extracts integration in HCM Cloud.
• Worked on Proof-of-Concept (POC) demos on consuming RESTful services in Oracle Cloud Service from AngularJS. 
• Personalized/Customized custom web pages using Oracle Application Framework (OAF) in JAVA.
• Data Analysis primarily identifying large data sets, source data, source metadata, data definitions and data formats. 
• Developed and Executed scenarios for unit/module testing and integration testing of ownership components.
• Saved 85% of reporting time by developing ‘Data Migration Auto Reporting Tool’ in Excel VBA.
• Created and monitored HRMS & GL conversion/migration programs for multiple regions (ACCPAC/JDE/11i).
• Performed performance tuning using parallelism & bulk processing on ETL scripts & reports.

  My Projects

Designing Standalone E-commerce Website over Cloud (Azure Web Services) using Scalable Distributed Architecture

Web Developer

Aug 2016 - Dec 2016 (0 years 4 months)

Designed, configured, implemented and deployed a complete bare bone E-commerce solution over a distributed big data environment. All resources used were incorporated using Azure Web Services and other open source tools.
• Implemented non-blocking Node.js as the primary engine behind the application deployment
• Used Express Framework and bootstrap over jade for front end development
• Cached content using standard tier REDIS as a service on Azure Web Services
• Utilized document-oriented MongoDB with RoboMongo for storing product data with seamless connection using Monk driver
• Static content hosted over Akamai Content Delivery Network on Azure
• Textual data indexed on Microsoft Azure Search with Lucene search features
• Hosted the entire site on cloud as an Azure app service using continued deployment via Microsoft Visual Basic\

HAL (Heathrow Airport Limited)

Reports Developer

May 2015 - Jul 2016 (1 years 2 months)

• Objective: The objective is to move from multiple legacy systems to single Oracle R12 system globally, for EMEA, US and ASIA sites implementation that involves implementation of Oracle ERP R12/ EBS, which includes data migrations, customizations, interfaces, reports, forms, workflows.
• Responsibility – Development of Reports, Interfaces and Extensions components in Order to Cash and Procure to Pay cycles. Create UNIX scripts to automate interface programs.  Handling Release Management of components. Involved in executing technical design and sizing on proposed enhancements. Worked with performance tuning tools like Explain Plan to improve the performance of various custom PL/SQL Packages, Procedures and Reports developed.

UBM (United Business Media)

PLSQL Developer/ETL Developer

Apr 2013 - Apr 2015 (2 years 0 months)

• Objective:  This project involves the implementation of Oracle ERP R12 from a legacy system that includes data migrations and customization namely reports, interfaces, forms, workflows etc.
• Responsibility – Developed Data Migration/Conversion components and Oracle Reports. Handled System administration responsibilities. Coordinated and performed document and code review of deliveries from the offshore team. Involved in unit testing, module testing, and integration testing.

Competency: Oracle BI Cloud Competency

BI Reports Developer

Jun 2015 - Jul 2016 (1 years 1 months)

• Objective: This is an extra initiative taken by Capgemini to explore new areas of Oracle Fusion Cloud.
• Responsibility: Creation of Proof of Concept demos on BI reports and integrating it with HCM Extracts.  Worked on File Based Loader and Process Data Mapping in HCM Cloud.

  Awards& Honor

Project Star Award 2014

Capgemini

Jan 2014


        

Oracle PL/SQL Developer Certified Associate

Oracle

May 2015


        

  Research, Authorship and Publications

  Blog Posts


Opportunities

Looking for job / talent?

Access Marketplace

Chance to earn up to 1000$ / referral

Refer & Earn

Similar Profiles

Abhishek Gaggar

Student Assistant at University of South Florida

Tampa, Florida, United States
Priyadarsini Chelikam

Tampa, Florida, United States
Dave Rich

VP Strategic Finance and Analytics at Vology Inc

Tampa, Florida, United States
Prudhvi Adapa

Tampa, Florida, United States
Srinivas Kalyan Potru

Tampa, Florida, United States
Pranavan Maruthainar

Graduate Teaching Assistant at University of South Florida

Tampa, Florida, United States
Ragini Radhakrishnan

Data Analyst at Accenture

Tampa, Florida, United States
Sachin Kant Misra

Big Data Analyst (Data Science) at Dell EMC

Tampa, Florida, United States
Neha Selokar

Graduate Teaching Assistant at University of South Florida Muma College of Business

Tampa, Florida, United States
Swapnil Awasthi

Senior Software Engineer at CenturyLink, Inc.

Tampa, Florida, United States