Skills

  • MySQL Performance Tuning 5.6
  • Oracle Taleo
  • Python

About

Master of Computer Application with 12-year 7months experience in AWS Development & Architecture, Software Development, Project Implementation, Production Support, Configuration.  Adept in Analyzing and gathering requirements, preparing solution

Education

Experience

    Functional/Technical Role

    TCS, Gurgaon

    full-time

    Identifying the objects, workflows etc., to be developed to achieve the end results.  Preparing / reviewing the functional requirement document.  Conducting end to end Functional Testing of custom reports, interface and modules.  Create Tables, Functions, Procedures, Cursors, View and Synonyms.  New Product configuration and Requirement gathering from Client.

    May 2010 - Oct 2013

    IT Analyst

    TCS, Gurgaon

    full-time

    Requirement gathering and preparing Functional Specification document.  Preparing of Technical Specification for customer.  Create Tables, Functions, Procedures, Cursors, View and Synonyms.

    Oct 2013 - Jul 2014

    Module Lead

    Accenture

    full-time

    Create Tables, Functions, Procedures, Cursors, View, Package and Synonyms and bug fixing.  Functional Testing, Smoke Testing and Regression Testing of Modules through Testing Tools.  Tools used in this project: Altova XML, RIT (Rational Integration Tester), RCQ for defect raise and Enterprise Architect (EA) Tools.  Direct dealing with client for requirement gathering and Preparing of Technical Specification, System Design Document (SDD).

    Aug 2014 - Apr 2015

    Module Lead

    Accenture

    full-time

    Working as Senior Analyst into Digital Analytics Solution factory.  Worked as a data analyst to develop analytical and statistical reports for strategy and predictive analysis, requirement gathering, Enhancement of existing system.  Currently working for Eight regions. In this project we are generating monthly, quarterly and ad- hoc reports to writing SQL Queries in Redshift Dataware House. Comparison based on fuel spent and non-spent and other categories also. Currently working in cloud computing.  End-to-end Functional knowledge of the system. Automation of business processes to minimize the manual intervention and monitoring.

    May 2015 - May 2019

    Team Lead

    Accenture

    full-time

    It’s a migration project. In current project we are migrating data from different sources (i.e. SFDC, SAP, Report prod, Callidus etc) to single target using AWS Glue. we are keeping flat files/csv files in S3 and reading via AWS Glue. we have multiple layers raw data layer, Intermediate layer and Master layer. In Intermediate layer we are implementing business logics/ transformations and dumping in Redshift DWH. SNS(Simple Notification Service) using for Job success/failure alerts & Step Function for scheduling the jobs using of Cloudwatch events configuration. Database architect design for end-to-end flow. End-to end system knowledge for whole project. Datamart also design based on business verticals.  Currently working for EMEA, APAC & US regions. End-to-end Functional knowledge of the system. Automation of business processes to minimize the manual intervention and monitoring.  Create Roles, writing policies, EBS volumes, Route53, VPC configuration & Applying routing policies, Snapshot, Instance creation using Cloud Formation.  Creating pipelines with AWS Glue with the help of python code.

    May 2019

Acievement Certificates

    No Records Found

Portfolio

    No Records Found