SUMMARY:

• Over 13 years of experience in Business intelligence and Data Technologies.
• Experience in managing and leading Data Products.
• Functional experience in Payments, CRM, Financial, Mortgage Lending, Security, Entertainment and Salesforce.com domains.
• Expertise in Data conversion, Data integration and Data cleansing and Data Visualization
• Employed deep subject matter expertise to drive the development of new and innovative ideas, end - to-end product ownership, develop and champion product area vision and strategy.
• Expertise in managing product roadmap with proper phasing, communicating product roadmap to cross- functional partners and stakeholders, and proactively identify and manage interdependencies.
• Expertise in project management methodology and leading change efforts on behalf of the business and product teams.
• Adequate problem solving and decision-making skills with an ability to work under pressure in fast-paced environment with minimal supervision.
• Experience in leading and managing offshore teams and vendor teams.
• Expertise in Enterprise and Mart level architecture, data modeling, relational and dimensional star schema, data quality, data migration and data integration ETL process, meta data management, and OLAP reporting
• Familiarity with Agile Scrum, Traditional Water Fall methodologies.
• Familiarity with Big Data technologies.
• Data modeling experience with Erwin
• Expertise in SQL queries and Query Optimization, Report Testing techniques
• Excellent knowledge of relational databases through exposure to Oracle, Teradata,DB2, SQL Server and Sybase
• Experience with Big Data Google Cloud Platform.
• Experience with HiveQL, SparkQL and Big Query.
• Excellent Coordination skills in working with cross functional teams
• Interpersonal communication, team management skills and sound work ethics

TECHNICAL SKILLS:

OS: Windows NT/2000, Unix (HP-UX 11.x, Sun Solaris 2.x)

Web Servers: IIS 5.0, PWS, Apache

Languages: Visual Basic 6.0, ASP, VB.Net, ASP.Net, HTML,JAVA, Java Script,SQL, PL/SQL, XML, COBOL, Perl

Databases: MS Access 2000, Oracle 7/8/9/10g, SQL Server 2000, DB2 UDB, Lotus Notes 4.0, Sybase, Netezza 2.3, Teradata V2R.06

Data Warehousing Tools: Informatica 5.1/6.2/7.1/8.5, Cognos Impromptu 6.5, PowerPlay Web Reports, MicroStrategy 8.0, UpFront, Business Objects4.x/5.x/11i, Web Intelligence2.6, Hyperion System Planning 9,SQL Loader, ErWin, BODI DQ and DP 10g, Tableau

Big Data: Hadoop, Spark SQL, HiveQL

PROFESSIONAL EXPERIENCE:

Confidential, CA

Technical Product Manager

• End to End ownership of migration of e-com application to Google Cloud Platform
• SME for e-com legacy and new Mosaic platform
• Coordination between Engineering team, DM, BI, Product and other Stakeholders.
• Design and develop Data migration strategies into Cloud.
• Delivered Key metrics to top management for Current Demand Sales.
• Extensively involved in requirement gathering, Data Analysis.
• Ensured Data Quality and Integrity and enabled business users in UAT.
• Communicate gaps, feature changes across the organization.
• Drive product roadmap, scope and delivery by working closely with the Leadership team.
• Work with user groups to resolve questions, assess user needs, and recommend changes.
• Work with business partners to understand problems, define, develop and document requirements, develop and execute test plans.
• Support business partners requests for additional research, as well as, business and systems analysis related to projects.
• Work closely with project managers and technical staff to support projects.
• Working on Big Data technologies like GCP, Hue, Hive and HiveQL.

Environment: MySQL, Workbench, Teradata, Tableau, SQL Assistant, Jira, Rally (Agile Scrum Methodology), Google Cloud Platform, Hue, Hive, HQL

Confidential,San Jose, CA

Technical Product Manager

• SME for Customer and Payment Domains and SFDC Implementations.
• Liaison between Business users and Technical teams.
• Extensively performing Data Analysis of cross property data to optimize the solutions keeping in view the Enterprise Data Strategy.
• Delivered Analytical Solutions to Business enabling them to make informed decisions and adopt effective strategies.
• Delivered Key KPI’s, Scorecards and Actives Metrics reported by Confidential to Wall Street.
• Managing Rally Sprints and Prioritization of user stories.
• End to end Ownership of Product delivery.
• Managed offshore and vendor resources.
• Supported Data Governance initiatives to ensure quality and delivery of certified Data.
• Worked on prototypes to understand the requirements and propose effective solutions.
• Responsible for the delivery of end-to-end solutions by working closely with Business, Analytic Users, Development and Operations teams
• Extensively used SQL in analyzing, testing, prototyping the Data solutions in Teradata
• Worked closely with business users in performing UAT
• Worked on Big Data Projects and queried the data using HiveQL and Spark SQL.
• Worked with Reporting Tools such as Tableau, Microstrategy.

Confidential, SFO, CA

Technical Product Owner

• Involved in the migration project SFA-CANANDA involving data migration from MDM,Siebel to SFDC.
• Involved in preparing the Data mapping, S-T document from Seibel to SFDC.
• Involved in Data Profiling
• Analyzed source data and identified key data points and metrics
• Involved in gathering requirements and translating to technical specifications
• Implemented all the inclusion and exclusion rules for the conversion.
• Designed the ETL architecture for the conversion
• Created test scripts using SQL and documents for unit and integration testing, resolved issues with business users
• Involved in creating Test scripts to ensure Data Quality
• Prepared UAT scripts and ensured smooth UAT process
• Responsible for conversion of Accounts, Address, Brand Affiliations
• Involved in performance tuning at source, target, mapping and session level using the Informatica Connector for SFDC

Confidential, Sunnyvale, CA

Product Owner

• Involved in the migration project Onramp from Siebel to SFDC in an Agile Scrum methodology.
• Involved in preparing the Data mapping, S-T document from Seibel to SFDC.
• Involved in gathering requirements and translating to technical specifications
• Implemented all the inclusion and exclusion rules for the conversion.
• Created test scripts and documents for unit and integration testing, resolved issues with business users
• Involved in creating Test scripts to ensure Data Quality
• Responsible for conversion of Contacts, Activities and Opportunities, FPVR, Quotes,Sharing Team
• Involved in performance tuning at source, target, mapping and session level using the Informatica Connector for SFDC

Confidential,Mt View,CA

Sr. Business Systems Analyst

• Involved in gathering requirements and translating to technical specifications
• Prepared S-T documents, Test plans and UAT scripts.
• Responsible to Quarterly release on Production fixes and Enhancements
• Involved in performance tuning at source, target, mapping and session level
• Worked with XML, flat file sources
• Resolving issues with business users and taking care of the reporting requirements
• Created test scripts and documents for unit and integration testing
• Lead Onshore and Offshore team at the client site

Confidential,Palo Alto,CA

Sr. Data Conversion Lead

• Involved in the conversion project Everest Phase 3 for migration of Non-GSS data.
• Involved in preparing the Data mapping, S-T document from Seibel to SFDC.
• Involved in gathering requirements and translating to technical specifications
• Implemented all the inclusion and exclusion rules for the conversion.
• Designed the ETL architecture for the conversion
• Created test scripts and documents for unit and integration testing, resolved issues with business users
• Responsible for conversion of Contacts, Activities and Opportunities
• Involved in performance tuning at source, target, mapping and session level

Confidential,Mt View,CA

Sr. Business Systems Analyst

• Involved in gathering requirements and translating them to technical specifications and mapping document for ETL process.
• Involved in developing the logical and physical data models.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse. (Informatica ETL and Business Objects reporting).
• Involved in designing the ETL Architecure and Design
• Involved in performance tuning at source, target, mapping and session level
• Worked with XML, Flat File and PeopleSoft sources
• Responsible for leading ETL development of ePayment DataMart and reconciliation with the ERP data in the EDW
• Used Unix Scripts to validate the loads from source to targets
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Resolving issues with business users and taking care of the reporting requirements
• Created test scripts and documents for unit and integration testing
• Involved in extensive data validation using SQL queries and back-end testing.
• Experience with ODI DQ and DP
• Responsible to Quarterly release on Production fixes and Enhancements
• Lead Onshore and Offshore team at the client site

Confidential,San Jose, CA

Business Systems Analyst

• Involved in Analysis and Implementation of enhancements to current Data Warehouse environment
• Responsible for Accounting and Financial Subject areas and remodeled Informatica applications for custom usage
• Re-architected and remodeled COGS module from custom Informatica Applications (IA)
• Involved in Integration of two databases after the merger
• Worked with Hyperion reports for financial planning, created adhoc reports to troubleshoot data issues.
• Lead Onshore and Offshore team at the client site
• Worked with Salesforce.com data
• Involved in Informatica Upgrade from 7.1 to 8.0
• Worked with Teradata database and used features like FLoad and Mload
• Resolving issues with business users and taking care of the reporting requirements
• Involved in the Business Objects upgrade from 6.1 to Xi