SUMMARY:

• Currently working as a Tech Lead (Data Analytics) .
• More than 12 Years of Work Experience in IT industry.
• Experience in Data Analytics, Hadoop, Tableau, Teradata, Unix Shell Scripts, MS SQL Server, Oracle PLSQL
• Extensively involved in Development, Enhancement, QA Testing, Performance Testing, Production Support & Trouble shooting of many critical applications for Confidential clients.
• Software Development Life Cycle, Testing Methodologies and Techniques.
• SLA Management.
• Change Management.
• Agile Methodology.
• Exceptional communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead

Responsibilities:

• End - to-End Project Planning right from inception phase to design, development and delivery.
• Tableau Dashboard and Analytics Report creation on Hadoop HDFS Data Lake.
• Agile Project Management with an Confidential /Offshore Delivery Model.
• Exploring New Avenues/Projects for growth in terms of Revenue.
• Preparing Project Delivery Dashboard for showcasing Project Health which Includes Risks to be Mitigated and Status of the Future Releases.
• Closely Involved in Design, Development & QA Testing, and Performance Testing of a 3 Way Reconciliation of Billing, Inventory & Contracts of Verizon Data Warehouse.
• Designing of the Data hub and Reporting Solution.
• Automation of Data Extraction/Transformation process from heterogeneous Data Sources.
• Automation of the End-to-End Analytics and Data Reconciliation process.
• Unit, IT & QA Testing of the Individual modules and Batch processes in Data Hub
• Performance Testing of individual modules in the Data Hub.
• SQL Query tuning and Writing Cost effective SQL queries for adhoc report generation.
• SQL Query development for performance testing on Mainframe system for Billing Data Validation.
• Data profiling to build business rules and logic for data transformation and reconciliation.
• Identifying Data Lineage to establish the data links between discrete Business Applications/Systems.
• Preparing Test Cases for IT/QA/Functional Testing.
• Coordinating with stakeholders (POCs & Account Teams) to understand the various data sources.
• Data Analysis for the inbound & outbound systems.
• Building the Billing & Cost Discrepancy Reports for Audit purpose.
• Tracking Project Deliveries during Dev/IT/QA Phase for a smooth Go Live and Pre-Production validation.
• Mentoring and Helping team in trouble shooting applications and bug fixing.

Technology: Hadoop, Tableau, Teradata Teradata (TPUMP, Fast Load, Multiload, Performance Tuning, Data Modelling), MS SQL Server, MYSQL, Mainframe, Oracle, Unix, Confidential, Performance Tuning, DB/SQL Performance Testing, VB Scripting, Microsoft Project Plan.

Confidential

Tech Lead

Responsibilities:

• End to End Project Management and Delivery from Offshore.
• Currently involved in Design, Development & Testing of Confidential Trade Interfaces. For Analytical Reporting within the application (Phase I & II).
• Requirement gathering for multiple modules in Confidential .
• Enhancement and Development of Riskbox/Adaptiv & Bancware Interfaces of Treasury Applications.
• Tracking Project Deliveries during Dev/IT/UAT Phase for a smooth Go Live and Pre-Production validation.
• Mentoring and Helping team in trouble shooting applications and bug fixing.
• Production Support of Riskbox & Bancware Treasury Applications.
• SLA Management for timely solution on issues in Treasury application.

Technology: Teradata Teradata (TPUMP, Fast Load, Multiload, Performance Tuning, Data Modelling), MS SQL Server

Confidential

Project Lead

Responsibilities:

• E2E Requirement Gathering and Functional Testing of large Confidential projects.
• Responsible for UAT Signoff and Project Implementation.
• Responsible for Effort Estimation of multiple projects.
• Managing Myforecast team at Confidential /Offshore
• Reviewing and Tracking all deliveries from offshore including Design, Development & Testing.
• Responsible for delivery of multiple projects for Confidential Singapore.
• Exploring new opportunities in GBI Asia Pacific area.
• Involved in review meeting with customer for multiple projects.
• Guiding the Confidential /Offshore Functional Team in requirement gathering and preparing the BRD documents for new projects.

Technology: Fast Track Schedule (MAC), Microsoft Project Plan, Teradata (TPUMP, Fast Load, Multiload, Performance Tuning, Data Modelling), Oracle, Unix, Informatica, Autosys Scheduler and Confidential scripts, MySql DB.

Confidential

Project/Technology Lead

Responsibilities:

• Managing GBI iTunes - PX4 Project with a strong 10 member team in an Onshore-Offshore model.
• Responsible for delivery of projects worth 1 Million USD in Data Warehousing ( Confidential ) & Business Intelligence (BI).
• Responsible for delivery of multiple projects in GBI iTunes - PX4
• E2E Requirement Gathering and Functional Testing of large Confidential application.
• Exploring new opportunities in GBI area.
• Reviewing and Tracking all deliveries from offshore including Design, Development & Testing.
• Guiding the Confidential /Offshore Functional Team in requirement gathering and preparing the BRD documents for new projects.
• Responsible for Resource Management through lateral hiring for the Delivery Unit.
• Responsible for Customer Invoicing for all billable resources.
• Interacting with Customer on a weekly basis for project delivery updates, issues, concerns for seamless delivery from Offshore.
• SLA Management and Change Management for the Production Support of this Application

Technology: Fast Track Schedule (MAC), Microsoft Project Plan, Teradata (TPUMP,Fast Load, Multiload,Performance Tuning,Data Modelling), Oracle, Unix, Informatica, Autosys Scheduler and Confidential scripts.

Confidential

Tech Lead

Responsibilities:

• Working across Verticals like Energy, Aviation, Legal, Commercial Finance, Real Estate, etc for their org specific implementation in Oracle AP (GE SSS AP)
• Extensive coordination between Business owners, vendors, SIT testing team, development team and the data warehouse team and across various other teams within GE Corporate for go live and Implementation.

Technology: Microsoft Project Plan, Oracle Applications 11i ERP (Buy To Pay, iProcurement), Teradata, Unix and Oracle Confidential scripts.

Confidential

Team Leader

Responsibilities:

• Involved in resource allocation to match capabilities of the team members & complexity of work.
• Coordinating with the Migration Managers to generate high level reports for the Senior Management.
• Acting as a central coordination point for various activities in Confidential
• Gathering Information from the workshop documents and the ASM team and third party vendors for applications under transition scope
• Planning effort estimations for upcoming work stack.
• Generating Resource Utilisation report for every subsequent month in consultation with Delivery Heads
• Assisting in scope definition & quotes related activities. Actual effort estimations.
• Liaising with the Technical Infrastructure team and ASG for smooth transition.
• Provide technical assistance to team members.
• Co-ordinating delivery timelines with development teams.
• Participating in PMRs

Technology: Microsoft Project Plan, Oracle, Unix and Confidential scripts.

Confidential

Team Leader

Responsibilities:

• Performing Confidential co-ordinator role for 12 months for Confidential .
• Configuration and Support of Oracle Incentive Compensation Management module of Confidential UK.
• Enhancement and support of Oracle ICM (Incentive Compensation Management) used in Confidential for compensation payouts to the dealers.
• Developing and supporting the various modules using Oracle Tools for configuration, eScripting, workflows etc, Oracle ICM, and Informatica for ETL from Oracle to Oracle ICM.

Technology: Oracle, Confidential, UNIX, Informatica, Oracle ICM E-Business Suite

Confidential

Software Engineer

Responsibilities:

• Blackberry Application Support & Development. Involved in resource allocation to match capabilities of the team members & complexity of work.
• Working on Blackberry CUK Development (CUK: Companion UK an IBM System supporting the customer of mmO2)
• Coding the business logic using PLSQL. Writing stored procedures, functions, triggers and creating database objects like tables, synonyms and views.
• Shell scripting for loading various data in CSV file format.
• Unit Testing of the modules.
• Working on Vantive tool to raise and solve cases pertaining to Blackberry Application Support Group.
• Worked on Software Configuration Management.

Technology: Oracle, Confidential, UNIX, Open VMS, DCL Scripting.

Confidential

Team Member

Responsibilities:

• Carried out the Impact Analysis for Migration of MPower System to Oracle 10g.
• Migration of all the forms and reports from Oracle 8i to Oracle 10g which is a web based technology.

Technology: Oracle 10G Forms and Reports Migration Tool.