TECHNICAL SKILLS

Languages: PL/SQL(Advanced), Python, Unix Shell Scripting

Reporting BI Tools worked on: Tableau, Business Objects, Dashboards, Splunk

Databases Worked On: Oracle, Teradata, HANA, Vertica, Hadoop, Essbase

Theory and Techniques: Data Warehousing, Business Intelligence, Data Mart

Version Control Tools: SVN, GIT, Autosys, ETL

PROFESSIONAL EXPERIENCE

Confidential, Cupertino, CA

Application Developer, Functional/ Data Analyst, Technical Lead

Technologies used: BI Dashboard, SQL, Oracle, Teradata, Tableau, Service Layer, Informatica, Storm, Business Objects

Responsibilities:

• During a bank holiday, planners waited until midnight to push the delivery date from same day ship to 1 - 2 business days.
• During a dynamic high-velocity event this manual activity would be unreliable and time consuming
• Delivered a quote recommendation process where planners could schedule mass uploads on any desired date
• Parallel processing, query tuning and job scheduler frequency updates improved quote accuracy by 94%.
• Replaced Informatica workflows to Storm enabling real-time data processing and faster reporting in BO, dashboards
• Developed several scenario-based summary reports including graphical representation and trend analysis reports

Confidential,Cupertino, CA

Application Developer, Functional/ Data Analyst, Technical Lead

Technologies used: BI Dashboard, SQL, BW, Teradata, Excel data validation, MDM, ETL - Informatica, Storm

Responsibilities:

• Replaced 4 forecast data providers by one comprehensive forecast sourced from Confidential.
• Designed and developed ETL data pipelines from Confidential to Enterprise Data warehouse and then published to 15 subscribers as per need.
• Created strategic project plan of 3 phases, collaborated with cross-functional teams, organized scrum meets
• Researched data inconsistencies between source and target systems by creating automated validation reports and built timeframe KPIs to analyze forecast accuracy by comparing with actual sales data for 12 quarters.
• Built a re-usable metadata framework to refresh certain data segments on a custom frequency that was easy to maintain and flexible.
• New forecast metrics were made compatible with all existing dimensions in BO universe

Confidential

Application Developer, Functional/ Data Analyst, Technical Lead

Technologies used: SQL, Teradata, Tableau, Business Objects, Informatica, Asynchronous Replication, Essbase

Responsibilities:

• Assessment of actual sales reported by resellers and corresponding activated units enabled more reliable reporting which helped the executives in supply chain demand management system, in ad-hoc analysis and forecasting
• Created complex BO/Tableau reports on historical and current data available in Enterprise data warehouse

Confidential

Application Developer, Functional/ Data Analyst

Technologies used: BI Dashboard, SQL, Teradata, Unix Shell Scripting, ETL - Informatica, Business Objects

Responsibilities:

• Eliminated manual upload of Point of Sales data by building rule-based User Data Management Tool that notified erroneous user inputs.
• Facilitated reporting across product, country, timeframes using Webi and BO Designer