Jan 2019 – Mar 2020 · 1 yr 2 mos

• Used monthly snapshots of sales figures data over the past 4 years to carry out data analysis and modeling in python.
• Extracted the data from flat files and other RDBMS databases into staging area and developed jobs to fetch the required information.
• Experience in converting the Store Procedures logic into ETL requirements.
• Exposure of working on Talend to migrate data from various RDBMS sources to HDFS datalake.
• Build multiple Data Lakes. Build how the data will be received, validated, transformed and then published
• Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL Datawarehouse environment
• Migration of on-premise data (Oracle/ SQL Server) to Azure Data Lake Store using Azure Data Factory

May 2016 – Jan 2019 · 2 yrs 8 mos

• Lead a team of 6resources and maintain accountability of the team deliverables.
• Participated in Analysis, Design and implementation of Business Applications using Oracle (RDBMS).
• Client facing position for requirement gathering and implementation of Reporting application leveraging data from multiple interfaces including SFDC, SAP and Oracle OnDemand tools
• Develop ETL packages to read data from multiple inputs and transform into usable format whilst doing inline cleansing
• Created numerous simple to complex queries involving self joins, correlated subqueries, collections for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies
• Working as technical architect for APEX reporting. Involved in design and development of complex reporting solutions with Oracle APEX and HI Charts.
• Gather business data and analyze to draw suitable functional design and set project timelines. Proposing a suitable project model on basis of the data collected.
• Involved in building complex SQL queries to generate reports to load faster.
• Incorporating HI Charts in reports to give better graphic reports and expanding each section to the very minute detail.
• Performance tuning of APEX pages to get faster results by use of AJAX calls for partial page region refresh.

Nov 2013 – May 2016 · 2 yrs 6 mos

• Mentor a team of 6 resources offshore and maintain deliveries by co-ordination with business and on shore.
• Participated in RFP to discuss the feasibility of the project.
• Involved in requirement gathering, designs, and UAT support.
• Continuously assisting in improving the process and profitability of client business.
• Involved in presentation, client communication and interaction with external vendors.
• As a Technical Analyst, was involved in conducting weekly status reviews with client, delegating the work in the team and ensuring the smooth delivery. Also involved in handling development and enhancement of various business processes, performance tuning and customization, Oracle PL/SQL, Oracle Reports and Forms Customizations.
• Good knowledge of Application Development and support processes.
• Worked on technical and process documentations.
• Built APEX application along with its supporting database from scratch single handedly.
• Unit tested and implemented code to deliver with minimum number of defects.
• Have handled the delivery of critical enhancements, developments and have delivered 24*7 production support of systems in Oracle Purchasing modules and Oracle Application Express.
• Have worked on deploying scripts from one environment to other for database and APEX applications via export /import

Sep 2011 – Nov 2013 · 2 yrs 2 mos

• Support all data management as per the business validations for the maintenance of the different unit, plant and part structures, have delivered 24*7 production support for it.
• Monitor daily production failures and process them.
• Fetch data from the database using complex joins to get reports as requested by users.
• Manage application administration by assigning or removing roles from users.
• Performed problem management & root cause analysis and fixed production issues.
• Delivered changes and new enhancements.
• Performed performance tuning of custom codes.
• Handled various jobs to trigger mails via the interface to notify users.
• Have been involved in managing packages to generate xml data from gathering information from various table structures.
• Have participated in data load from a static source into the database with use of various tools.