Summary

• Leader with 10+ years of experience in Business Analysis, software design and implementations.
• Expert in Supply Chain, Business Intelligence and Analytics systems implementations.
• In depth knowledge on Data warehousing concepts and Experience in leading BigData warehouse projects.
• Expertise in Supply Chain Planning, Forecasting, replenishment, planogram, freight management, inventory management.
• Quick in grasping client requirements, providing technical and business process solutions.
• Presented the project solutions and approach for major projects to higher management in Green light process.
• Executed projects with highest standards in all process groups of project life cycle (Project Initiating, Planning, Executing, Monitoring and Controlling, and Closing )
• Good working experience in entertainment, supply chain, health care, capital market and banking areas.
• Good working knowledge of CMMI maturity levels and project management processes.
• Motivational team lead with well appreciated qualities of leading the team members to achieve the project targets effectively.
• Excellent leadership, team management, communication and interpersonal skills.

Bachelor of Technology in Mechanical Engineering

Confidential,Los Angeles Feb 2007 – Till Date
Lead Systems Analyst

leading entertainment studios in the world. Paramount Home entertainment (PHE) is one of the main revenue generating division in paramount with more than $400 million revenue per year.

As a Lead Analyst in Paramount, I am responsible for implementing the Supply Chain and BI solutions for PHE. I lead several major supply chain and BI projects.

Implementation of Demand Planing and Promotion Planning using JDA Scpo Solutions
Order Management Implementation using eVMI application
Data Warehouse and Microstrategy Reporting Solutions for Several projects.
Informatica ETL projects to transfer the data between different systems
SAS Analytics for Home Video sales forecasting
Business Enabled Web portal to Automate regular IT tasks to reduce the IT burden

Responsibilities:

• Designing and implementing Supply Chain and BI solutions for PHE
• Analyzing the business requirements and providing technical or business process solutions
• Managing the development work, and critical production support issues with onsite and offshore vendor consulting teams
• Installed and configured the JDA SCPO suite
• Tuned JDA standard and custom jobs for performance improvements
• Designing and Creating Microstrategy reports and dashboards
• Lead several projects to move the home entertainment data (using Informatica tool) into paramount data warehouse system for analysis reporting purpose
• Lead process automation projects using VB Scripting, .Net. These projects reduced significant amount of support and business team hours
• Training the clients and new team members on JDA Demand/eVMI replenishment, Informatica and Microstrategy Reporting systems
• Leading the SAS Proof of concept project with help of consulting company
• Planning and managing the quality control of all projects

Environment: JDA SCPO Suite, eVMI Replenishment System, Microstrategy, Informatica, SAS, Windows/Unix, Oracle 10g, DB2,Teradata, Confluence, Sharepoint, Jira, Servicedesk, PL/SQL, Quest Tools(Toad), SVN Version Controlling system, Maestro job scheduler.
Confidential,March 06 – Jan 2007

Worked as DW Consultant for Pearson Government Solutions on CMSNGD Data Warehouse project. CMS is a US federal agency which administers Medicare, Medicaid and the State Children\'s Health Insurance Program. In this project, I was mainly involved in gathering requirements, data analysis, developing data models and testing the deliverables for 1800 Medicare call center applications.

Responsibilities:

• Requirements gathering and documenting them.
• Creating Solution and design documents for each enhancement.
• Creating test strategy and plan for all major enhancements.
• Provided the Data Model changes for DW enhancements.
• Automated Data quality checks, file transfer from FTP sites using UNIX scripts.
• Provided Adhoc repors for CMS business users for decision making
• Used Siebel eBusiness Application to verify the data in production
• Conducted Training and workshops for clients on CMS applications and Reporting solutions
• Prepared the support and user guide documentations
• Production Support (after Implementation) and resolving the issues raised by the clients
• Coordinating with Business, Development and testing teams to keep the project deliverables according to agreed requirements
• Training new team members on Cognos, Informatica and CMS applications

Environment:Windows NT/Unix, Oracle 9i, Informatica 6.2 & 7.1,Cognos Series 7, PL/SQL, Quest Tools(Toad), PL/SQL Developer, Siebel eBusiness Application7.7, CaliberRM 2005, PVCS Tracker, PVCS Manager.
Confidential,USA Jun 2003 – Feb 2006

leading global consulting services provider. I have worked with different prime clients in different locations.

Client: UBS Wealth Management, New Jersey Oct 2005 – Feb 2006
Project Lead

UBS Wealth management is a worldleading wealth management bank. I worked here as a project lead to understand the wealth Management applications and train onsite/offshore testing team members.

Responsibility:

• Preparing the System Appreciation documents for each application
• Training onsite/offshore test team members
• Strategizing the Quality Control process
• Created the Test Plan and involved in Test Case creation process
• Involved in test execution and validate the test results
• Involved in preparation of automation strategy
• Prepared the status reports of project and reported to management regularly

Confidential, (Singapore, Pune)
Project Lead Mar 2004 – Oct 2005

UBS Investment bank is a well known and leading investment bank in the world. I have worked on EDS – Equities Data Service and FusionHistorical Data System projects as consultant to work on new enhancements.

Responsibilities:

• Worked on requirements gathering and design technical solutions
• Worked on the detail analysis of the new data feed before loading into the database and tested its synchronization with the existing data model
• Developed ETL processes using Shell, Java scripts and Informatica to get the data from different sources and load them into EDS & Fusion databases
• Developed automation tests using shell and java scripts to test APIS and metadata
• Developed on database stored procedures, Functions and triggers for EDS and Fusion projects
• Designed and developed data validation reports to find and notify the users about data and system issues
• Tuned the performance of data load programs into Fusion database
• Supported Production system throughout the assignment and monitored the production activities as and when required
• Prepared user guide documents for each major release

Environment:Windows NT/Unix, Informatica 6.1, Oracle 8i, PL/SQL, SQL*Loader, Toad, Shell Scripting, Perl Scripting, Java 1.4.2. C++