Application Developer, Functional/ Data Analyst, Technical Lead Resume Cupertino, CA - Hire IT People

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