Application Developer, Functional/ Data Analyst, Technical Lead Resume
Cupertino, CA
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