Anita Varma

 Anita A Varma Email id:- Mob:- Experience Summary Experience of 11 years 3 months in Data warehousing, Informatica. Good knowledge in Greenplum, R Programming and Business Analytics Exposure to domains like GE Oil & Gas, GE Energy, Life Science & Healthcare, Media & Information Services, Banking , Hospitality Good Experience in solving various data related issues in Spotfire visualizations. Good exposure working with the onsite clients Experience in performance tuning of Informatica Mappings and eliminating bottlenecks Responsible for Overall delivery of assigned projects Project Lead with IGATE Global Solutions (Sep 2015-Till Date) Technical lead with Quintiles Technologies (I) PVT.LTD (Business Unit Acquisition from Ness Technologies) (April 2012 – July 2015) Member Technical Staff with Ness Technologies (Sep 2010 – April 2012) Assistant Systems Engineer in TCS (Nov 2006-Sep 2010) worked in projects that provided comprehensive BI solutions for Banking, Media &Information Services and Healthcare domains. Programmer Analyst with Cognizant Technology Solutions (Jan 2005-Nov 2006) worked on several Data warehousing projects for the client Cendant. Skills Domain Experience Life Science & Health Care, Media & Information Services , Banking , Hospitality Tools Informatica Power center 9.x, 8.6, 8.1.1, 7.x, R Programming ,Tibco Spotfire 6.5.2, Tableau 10.1.3,Informatica Power Analyzer, Siebel 8.x Tools and Client,PL/SQL Developer, Toad, HP Quality Center,HP Application Lifecycle Management Database Greenplum,Oracle 11i, 9i, 10g,SQL Server 2005 Operating System Windows XP, Unix Experience Profile – Key Projects GE Oil & Gas Commercial Pricing Analytics January 2017-Till Date Description: GE Oil & Gas is a world leader in advanced technology equipment and services for all segments of the oil and gas industry, from drilling and production, LNG, pipelines and storage to industrial power generation, refining and petrochemicals. GE Oil & Gas also provides pipeline integrity solutions, including inspection and data management, and designs and manufactures wire-line and drilling measurement solutions for the oilfield services segment.  GE Oil & Gas operates in more than 100 countries with 43,000 employees. Commercial Analytics DevOps is required to provide the O&G leadership an integrated view of Commercial and Pricing Analytics. Roles and Responsibilities: Understood requirements of the project. Involved in the Estimation of development effort, designed the different datalake tables, and developed and validated the Tableau dashboards. Involved in scrum calls and retrospective meetings with the client. Responsible for project deliverables. Responsible in preparing WSR (Weekly Status Report), weekly and monthly Billing submission, weekly and monthly metrics Operating System: Window XP Tools: Talend 5.6,Tableau 10, Informatica 9.6 Database: Greenplum, Oracle 11i GE Energy April 2016-December 2016 Description: GE Grid Solutions business serves customers globally with over 20,000 employees in approximately 80 countries. Grid Solutions helps enable utilities and industry to effectively manage electricity from the point of generation to the point of consumption, helping to maximize the reliability, efficiency and resiliency of the grid.  Roles and Responsibilities: Handled multiple projects like Sales Manager Dashboard, Supplier Ageing Understood requirements of the projects. Involved in the Estimation of development effort, designed the different tables and validated the Qlikview dashboards. Involved in status meetings and UAT with the client. Responsible for project deliverables. Responsible in preparing WSR (Weekly Status Report), weekly and monthly Billing submission, weekly and monthly metrics Operating System: Window XP Tools : Informatica 9.5,Qlikview Database: Oracle 11i GE Healthcare BI & Analytics Testing November 2015-April 2016 Description: Regression testing for the different BI projects in GE Healthcare .Performance Testing for different BI projects developed in OBIEE and Cognos. Roles and Responsibilities: Understood requirements of the project and prepared regression test plan and test cases. Involved in the Estimation of testing effort Involved in status meeting with the client and different project teams. Responsible for project deliverables. Responsible in preparing WSR(Weekly Status Report),weekly and monthly Billing submission, weekly and monthly metrics Operating System: Window XP Tools : HP Application Lifecycle Management, NPI LoadRunner, Informatica Metadata Manager Database: Teradata Quintiles- Infosario Trial Management Data Hub October 2010 –July 2015 Description: The TMDH platform is to build a unified view of Trial Management operations integrating data sourced from multiple operational systems; leveraging MDM. It uses the best concepts of two major data warehouse architectures. Operational Data Store & Dimensionally designed with enterprise conformed dimensions. The ‘Trial Management Data Mart’ is dimensionally modeled supporting reporting on the metric information gathered in the TM_ODS. The dimensional model will contain a number of star schemas optimized to support reports. Roles and Responsibilities: Technical Requirements gathering and Implementation of the project at all stages of development lifecycle. Involved in the Estimation and high level Technical design of the ETL flow Prepared Technical specification document and resolved technical issues raised by customers. Responsible in preparing WSR(Weekly Status Report),weekly and monthly Billing submission, weekly and monthly metrics Involved in status meeting with the onsite Project Management team and responsible for deliverables Participated in the process of Performance tuning and Code reviews for various projects in the business unit Operating System: Window XP Tools : Informatica 8.6,Informatica 9 , Spotfire 6.5.2 Database: Oracle 11g Quintiles-CSO Veeva Data Export February 2013 –August 2013 Description: The purpose of this project is to automate many of the manual CRM data imports and exports that are currently being performed by Quintiles Commercialization. These imports/exports are required by multiple customers using the Veeva CRM system to meet their data needs. Roles and Responsibilities: Technical Requirements gathering and Implementation of the project at all stages of development lifecycle. Involved in the Estimation and high level Technical design of the ETL flow. Prepared the Technical specification document. Prepared UNIX scripts to encrypt and FTP the files to customer’s server. Involved in status meeting with the onsite Project Management team and responsible for deliverables Interacted with the client and solved various data issues raised by them Operating System: Window XP Tools : Informatica 9 Application: Veeva Salesforce Johnson &Johnson Inc.-GS Finance Automation January 2010 –September 2010 Description: The Scope of this project is to automate the Business Analysis of Global Services by creating   Cognos reports: Balance To Go (BTG), Estimated To Complete (ETC) and Variance and implementing object level security on them. The users of this system are the financial users and Directors of Global Services and GS Delivery Directors across various regions and business processes. Roles and Responsibilities: Technical Requirements gathering and Implementation of the project at all stages of development lifecycle. Involved in the Estimation and high level Technical design of the ETL flow. Involved in status meeting with the onsite Project Management team and responsible for deliverables Interacted with the client and solved various data issues raised by them at the onsite client location. Operating System: Window XP Tools : Informatica 8.6 Database: SQL Server 2005 Professional Memberships / Certifications Awards and Honors Pat on the Back Award,2016 Special Achievement 1 Award, 2013 Special Achievement 2 Award,2012 Memorable Customer Service Team Award, 2011