Ratika Gulati

Experience

• 

  Tech Mahindra

  Nov 2007 - Jul 2013

  • Awarded (internal company appreciation - Pat on the back) for delivering Business Intelligence project and a production support project for healthcare client, GlaxoSmithKline, along with handling additional internal projects• Accountable for gathering and baselining requirements from different GSK business groups, to document a project plan for the team to execute on• Spearheaded the gathering of data from SQL on demand in-house via message broker and warehoused the data using SQL and ETL techniques• Strong understanding of data analyzed by business groups, to gather requirements • Baseline Universe model to allow business users create reports by drag and drop • Write SQL procedures to preprocess the data. Develop Universe (mapping/processing data in the database to easily understandable classes and objects) using Business Objects X1 R3 • Write scripts to create business reports, scheduled to deliver to business on weekly basis• Successful on-time and in budget delivery of project• Create and deploy stored procedures for updating data of CRC, a ticketing application • Handle adhoc business requests on daily basis, creating presentations, documentation of new processes• Resolve Remedy tickets raised by users Show less • Awarded (Individual appreciation award, and Best Team Award) for smooth kick off for 24/7 Production Support for 25 point of sale and retail applications for AT&T (OPUS, OpusLite, SSK, PDC2, Phoenix, STDI, Sunrise, MyCSP, VIPS, ROCCS, EDP, CSCR, CSI, Uverse, IPOS, SLU-PLU, IPOS, EJB, Centaur, RWOT)• Understand client expectations and gain knowledge about the retail applications to support• Document daily routines to be performed at client’s end and at offshore, transfer knowledge to offshore team• Migration of database from Oracle 9i to 10g, on Development, Test, Production and Disaster Recover servers• Application migration from Weblogic servers 9.2 to 10.3, End-to-End application support in Weblogic Platform• On demand deployment of applications on WebLogic Server, maintain load balance, high availability and fail-over functionality• Automate support processes, write and execute stored procedures and shell scripts for code deployments, server bounces, file transfers, process monitoring, database pushes• Deployment/support change requests and new releases, resolve remedy tickets, log error checks, running batch jobs for database pushes, regression and shakeout testing• Automate daily Morning shakeout test for application across Stage, Production and DR• Manage project document repository, manage internal quality audits for the project• Train new team members to get on board with projects daily activities Show less • For Telecom, AT&T, worked as full stack developer for Phoneshowroom webapp to view and compare all the new and active devices currently sold by AT&T• Technologies involved were PL/SQL, Java, Struts, J2EE Technologies using Hibernate, Weblogic Application Server and Iplanet Server, HTML, CSS, XML, Agile, Scrum• Developed an interface using Oracle Apex to push phone details/images to database and iplanet servers• Worked in all the phases of SDLC, Understand, document, implement, test and deliver requirements• Implement change requests, peer code/test case reviews, test case execution• Developed a tool using Oracle Apex, to track resource to task ratio of Retail App Production Support team for one application (SystemX), data of this application was used to predict resources required for new 25 retail application support Show less

  • Technical Project Manager

    May 2011 - Jul 2013

  • Project Technical Manager

    Jan 2009 - Apr 2011

  • Developer/ Support Analyst

    Nov 2007 - Dec 2008
• 

  Tech Mahindra

  Jul 2019 - Jun 2021

  Data Analyst/Engineer

  • Provide accurate data insights to Azure Storage Stake Holders, to help in decision making. • Working on Big Data platform using Microsoft Technologies, create complex Kusto queries.• Extract Transform and Load data from Sources Systems to SQL using a combination of Azure Data Factory Pipelines, T-SQL, and U-SQL Azure Data Lake Analytics Create and Maintain Data Pipeline in Azure Data Lake and COSMOSa. Data processing capacity is ~90TiB per hour per stream• Migrate jobs to Lens Orchestrator from Data Studio. Create jobs using Power Automate – Flows • Analyzing the impact of new feature launch and adoption, with the Customer• Analyzing the Retention Rate of the customers, understanding their lifespan, to help reduce Customer Churn• Analyze impact of new feature launch by competing services• Create relevant Power BI reports, showing the products state from all dimensions, creating data models, data transformations, Used custom build visuals and from Market place, used DAX extensively for creating measure and modeling.• Testing the accuracy and reliability of data, investigating and eliminating abnormalities.• Cater adhoc support to customer and coordinating with Data, Billing, Finance and Operations team Show less

• 

  Costco Wholesale

  Aug 2021 - Mar 2022

  Data Engineer
• 

  Microsoft

  Mar 2022 - now

  • Data Engineer

    Mar 2022 - now

  • Data Engineer

    Mar 2022 - now