SUMMARY

• Passionate about solving complex problem with data driven approach with a strong grasp of building, maintaining data pipelines and getting insights from data analysis
• 8 years of IT experience creating Data Warehouse, BigData solutions in Retail & Manufacturing.
• Led offshore and onshore teams to drive implementation through data driven iterative approach with different methodologies like Agile scrum, Waterfall etc.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

BI/Data Visualization Tools: Tableau, Essbase, Power BI

Data Modelling Methodologies: Star schema, Snowflake schema, Logical/Physical modeling

Languages: SQL(Teradata, Oracle, Hive,MySQL), PL/SQL(Oracle),Unix Shell scripts, Python

Data Modelling Tools: Power Designer, SQL Developer

RDBMS: Teradata, Oracle, DB2, SQL Server, MySQL

ETL Tools: Talend, DataStage,, Teradata Utilities, Denodo

Data Querying Tools: TOAD, Oracle SQL developer, Teradata SQL Assistant

Scheduler: ESP scheduler(Mainframe),CAWA, Cron

PROFESSIONAL EXPERIENCE

Data warehouse/Big Data/Azure Technology Lead

Confidential, San Francisco, CA

Responsibilities:

• Analyze the data in various systems - Oracle Suites, Big Data to identify the optimum source and review with the PDM
• Played the role of an Engineering manager to drive the delivery of various interfaces from OMS, WMS and JESIE systems.
• Identified data gaps in the by analyzing data in the source systems and explaining the impacts of it to business.
• Drive Architecture discussions with the solution architecture teams to define integration patterns and train the development teams towards the delivery
• Created Framework for Ingestion of data into Azure Blob and ADW.
• Constantly define and redefine the MVP for the delivery with the program management, PDM and vendors due to the constant change in scope
• Consistently keep track of the priorities and juggle them with every change in scope. Have tough discussions with the leadership to de-prioritize items with realistic timelines.
• Led a global team of 6 members across different time zones and mentored them with business context and technical solutions
• Came up with the Data mapping and Data Model based on the interactions with the business & PDM.
• Implemented rest services using Denodo for very large datasets successfully.
• Lead the team into multiple roles from developer to lead as part of the PETE(Product End to End) program, to implement the Receipt Visibility track and multiple other projects as well.

Techno-Functional Lead

Confidential, Sunnyvale, CA

Responsibilities:

• Implemented the logic for allocating the sales from multiple tier resellers to respective Confidential Opcos as part of WISR project.
• Did Requirement Analysis, Created Design Document & Teradata Procedures to in corporate the allocation logic.
• Did the historical restatement for the data after the implementation of logic which was a very complex and tedious effort to be carried out without impacting the business.
• This was greatly appreciated as for the first time the VP/stakeholders of the various Opcos were able to accurately visualize the sales by slicing/dicing along the organization hierarchy.
• Lead the team on a compliance project which aimed at identifying the PII data across entire GBI and then presenting the impact to stakeholders.
• Created an automated report in a very short span of time to identify the teams/users not complying with the standards pertaining to PII data.
• Created a DataMart as part of Compliance project, which used to refresh daily once and would send out reports to the different team/managers not complying with PII standards.

Data warehouse Technology Lead

Confidential, San Francisco, CA

Responsibilities:

• Led the EDW development team comprising of 3 onshore and 6 offshore as part of Mars Sunset project.
• Design and develop new applications/enhancements using DataStage ETL, Teradata utilities, Unix shell scripts.
• SME for different subject areas - Inventory, Size, Pricing, Sales in EDW
• Perform root cause analysis for complex data issues and provide tactical and strategic solutions
• Performance Tuning of Teradata SQLs and Datastage jobs
• Document High level and Technical design documents
• Migrated Teradata from version 13 to 14.
• Extensively pairing up with Architecture team for carrying out POCs.
• Train, mentor and onboard new team members

Environment: Data Stage 7.5.1/7.5.3 /8.5 (Designer, Director, Manager and Administrator), Oracle 10g, Teradata, ESP, Unix AIX, Teradata V12, Microstrategy, Toad, Windows NT, Serena Dimensions, HP Service Manager, CAWA

Technology Analyst/Senior Software Engineer

Confidential

Responsibilities:

• Built and implemented Data warehouse solutions using DataStage and Teradata utilities as ETL tools for clients - Confidential Inc
• Create Functional and Technical design documents, data mappings
• Performance tuning of Data stage jobs, Teradata and Oracle SQLs
• Perform Unit, System, Integration and performance testing.
• Conduct shakeout for the ETL through ESP tool in Mainframes for system and integration testing phases.
• Provide implementation support

Environment: SQL Server 2005, Data Stage 7.5.1/7.5.3 (Designer, Director, Manager and Administrator), Oracle 9i, Oracle 10g, Toad, Teradata database, Teradata utilities, ESP, Unix AIX, Toad, Windows NT