Jan 2018 – Apr 2020 · 2 yrs 3 mos · Menlo Park, California, United States · On-site

• 𝓟𝓻𝓸𝓳𝓮𝓬𝓽 : 𝓡𝓸𝓲𝓷𝓷
• Roinn is a Datamart which provides a consolidated, reliable, and easy-to-query view of billing data. It focuses on the Accounts Receivable (AR) position, and a customer dimension table, for use primarily by accounting and finance Operations.
• 𝓟𝓻𝓸𝓳𝓮𝓬𝓽 : 𝓣𝓱𝓻𝓮𝓼𝓱𝓸𝓵𝓭 𝓒𝓸𝓵𝓵𝓮𝓬𝓽𝓲𝓸𝓷𝓼
• Threshold Billing customers are typically invoiced for small amounts (circa $500). When they do not pay, the debts are placed with external agencies (OCAs) for collection. The Threshold Collections data drives this process, both in terms of generating the monthly placements and tracking repayments.
• 𝓟𝓻𝓸𝓳𝓮𝓬𝓽 : 𝓖𝓸𝓸𝓰𝓵𝓮 𝓟𝓵𝓪𝔂/𝓣𝓪𝓵𝓸𝓼
• Finance BI&A support Play Finance by producing the Talos DataMart. This provides reporting on Financials, Users, Apps, Partners, and Ads on Play to support the Play business.
• 𝑬𝒏𝒗𝒊𝒓𝒐𝒏𝒎𝒆𝒏𝒕: Oracle r12, Google Technologies: Plx, F1, Dremel, CNS, Placer, Borg, Google3, Rapid, Stubby, g3doc, Pentaho, Python, GCP, Big query, Py spark, Gcs Bucket, G-Cloud Function, sql, etc.

Jun 2016 – Dec 2017 · 1 yr 6 mos · Foster City, California, United States · On-site

• Worked with business team to gather requirements for reporting needs.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Responsible for collecting information regarding the design on how to move the data for each system to decide on what will be needed to be taken to do the archival for each system.
• Worked with the subject-matter expert to get the increment logics of all the systems on a daily basis
• Provided Support and effort for process optimization and ETL automation.

Jan 2015 – Jun 2016 · 1 yr 5 mos · Glendale,AZ · On-site

• Estimated project levels of effort and resource requirements and working with staff to understand scope of effort.!!
• Managed project team of 8-10 members in an onshore-offshore model.
• Leaded and guided development of an Informatica based ETL architecture for Insurance Systems.
• Planned and executed schedules for major and minor releases and other technical deliverable's as well as ad-hoc support.
• Facilitated scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)
• Implemented an Informatica based ETL solution fulfilling stringent performance requirements.
• Collaborated with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
• Managed build phase and quality assure code to ensure fulfilling requirements and adhering to AAA ETL standards.
• Supported design, development and operations in cross tracks applications for master data management, business intelligence as well Other Teams.!
• Served as a member of the Cross track meetings within larger group, representing MDM Solutions Technical Lead to view & address any impact in MDM Solutions.
• Leaded Unit and Integration Testing activities and assisted in User Acceptance Testing.

Jan 2013 – Jan 2015 · 2 yrs · San Francisco Bay Area

• Worked as ETL Salesforce Lead & Lead Developer
• As a ETL lead and responsible for the following activities.
• Involve in requirement gathering session with business users.
• Analyze the requirement and prepare Technical Specification doc.
• Implement/manage ETL development activities with offshore team by providing them
• sufficient guidance to develop code with quality and reusable standards.
• SQA Support by running data loads, bug fixes during testing in SQA environment.
• Participate in UAT sessions with business users to support data validation in UAT
• environment.
• Responsible for creating various project related docs like Detail design doc, STM's (Source to
• Target Mappings), Deployment docs, Operation support docs.

Jan 2009 – Dec 2012 · 3 yrs 11 mos · Emeryville, California, United States · On-site

• Working as Sr.ETL Developer Involved in EDW Design at Leapfrog. Currently Working as Informatica Production Support Role,Informatica Admin and Developer.

Apr 2008 – Dec 2009 · 1 yr 8 mos · Palo Alto, California, United States · On-site

• Involved in analyzing, defining, and documenting data requirements by interacting with the client and
• Salesforce team for the Salesforce CRM objects.
• ♦ Developed Mapping Document to present to Business and sales team for the Informatica process for the
• Salesforce objects migration.
• ♦ As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and
• processes, writing ETL specifications for developer, ETL and Informatica development, administration.
• and mentoring.
• ♦ Performed some of the roles of Salesforce.com Administrator in the organization.
• ♦ Worked with various salesforce.com objects like Leads, Lead Opportunities Update, Parent
• Opportunities Update, Opportunity Record Type Update, Opportunities, Revenue Line Items, Order
• Logs, Split Territories, Order Mappings, Attachments, Reports, and Dashboards.
• ♦ Involved in extracting the data from Siebel source systems into Defined Staging area based on the
• inclusion and exclusion criteria.
• ♦ Created and edited custom objects and custom fields in Salesforce and checked the field level
• Securities.
• ♦ Worked on Offshore Onshore model, held meetings on a daily basis for coordination and planning in the
• Siebel-Salesforce CRM Migration and Integration Testing.