Professional Summary:

8 years of work experience in Business Analysis and Project Management in Financial and Manufacturing industry. Specialized in data analysis reporting, data governance, demand management, databases designing and maintenance, database administration, lean and six-sigma techniques and supply chain management.

Areas of Expertise:

• Project Management Business Analysis Data Governance
• Data Analysis Investment Management Data Modelling
• Data Management Reporting Database Administration Master Scheduling
• Supply-Chain Management Database Development Demand Management
• Change Management Requirements Management

Professional Experience:

Sr. Data Analyst/Business Analyst

Confidential

• Worked with the data governance working groups in authoring data governance policies and procedures
• Conducted training sessions on data analysis
• Gathered requirements by working with the business users on reference data and market data
• Used SQL to analyze data on data bases
• Worked with the technical engineers on development and production support teams
• Tested the applications along with the Quality Assurance testing teams
• Used Microsoft Visio to draw business process swim lane diagrams
• Provided estimates to the project managers
• Provided regular status reports to the management
• Managed the issues on HP Quality center ALM
• Implemented the change management procedures
• Coordinated with .net development team and database development teams in requirements gathering and analyzing

Environment:

Aladdin Blackrock, Eagle Systems, Inbound/outbound interfaces, SQL, .Net, SQL Server, PL/SQL, Microsoft Access, Visio, Share Point, HP Quality Center

Sr. Business Analyst

Confidential

• Involved in designing and developing Web-services using MVC, C , ADO.net, and XML to handle online transactions with operational database, which reduces the time, required performing data entry and generating reports
• Experienced in applying the ETL transformations for DBA tasks
• Worked on designing the DW model and the physical structure
• Worked closely with database development and administration teams
• Involved in various phases of data modeling process
• Used ITIL process Change Management, Issue Management on HP tools
• Provided regular status reports to the management
• Managed the scope, schedule and cost on the projects
• Used Microsoft Visio to draw business process swim lane diagrams
• Tested the applications along with the Quality Assurance testing teams
• Wrote Microsoft Excel Macros. Developed Share Point sites
• Used SQL to analyze data on data bases
• Gathered requirements by working with the portfolio managers, traders, investment operations, investment accounting users on trade life cycle
• Authored the Business Requirement BRD , User Requirements, Functional Requirements FRD
• Proficient in developing database objects like queries and stored procedures
• Created and maintained database objects like complex Stored Procedures, Cursors, and Tables, Views and User Defined Functions

Environment:

Bloomberg POMS, Eagle Pace 6.0, Global One, Omgeo, IBM MQ Series, Message Broker, Unix, Autosys Scheduling, Unity, Inbound/outbound interfaces, SQL, .Net, Sybase, SQL Server, PL/SQL, Microsoft Access, Visio, Share Point, HP Quality Center

Confidential

Business Analyst/Team Lead

• Involved in designing and successfully implementing a new procurement planning model by addressing logical flaws in the existing system
• Involved in Business Requirements gathering, User Requirements and technical requirements gathering by interacting with various stake holders of the company i.e procurement team, Finance and marketing teams, planning team and production teams
• Involved in project strategy preparation and implementation
• Experienced in project report generation, tracking the project and presenting project status to management
• Designed Metrics and scorecards for major processes handled by Supply Chain team, suggested implemented process changes based on these metrics. Received appreciation and award for the same
• Worked on demand management activities like forecasting, safety stock levels and maximum stocking levels for spare parts at various locations by studying and analyzing reference and historical data
• Worked on VMI Vendor Managed Inventory management through rigorous data analysis and helped the organization save 5M per quarter
• Worked on Network re-optimization of spare parts inventory, a process to shift the market focus of the organization from North America to Asia
• Worked on determining outliers in customer orders, a process to deal with unexpected market demand conditions
• Automated many existing manually executing processes using MS-Access, Excel, macros and received appreciation from higher management
• Worked on effective inventory management activities like redistribution of excess inventory at a location/depot to a location with shortage of inventory after considering various factors
• Responsible for conducting training sessions for associates, monitoring team meetings and preparing meeting minutes
• Responsible for presenting the team metrics and meeting minutes and other issues to top management and cross-functional teams
• Responsible for analyzing the data, finding the root cause, creating the metrics and suggesting the process improvements

Environment:

SAP ECC 6.0, Oracle 10g/11g, BRIO, MS Access, MS Excel, MS Visio, Sharepoint

Confidential

Oracle Database Administrator

• Involved in capacity planning and database requirements gathering
• Performed technical and system requirements analysis
• Installed Oracle 10g Database and Upgrading to 11g on Linux and Solaris platform
• Involved in database backup strategy preparation and Performed Backups on scheduled time and Monitored Scheduled Backups
• Refreshed development/test database from production using DataPump, Exp/Imp to ensure that the latest data is available in the development/test database
• Worked extensively on performance tuning including Query Optimization, PL/SQL Procedure Tuning, Instance / Memory / IO Tuning
• Review Oracle patches: Patch Set Update PSU , Critical Patch Update CPU whether there is any performance impact/issues and provide recommendation
• Created procedures, functions, packages, and triggers using PL/SQL
• Monitor oracle database wait events and provide recommendation according to improve performance
• Creating and dropping of users, granting and revoking rights as and when required
• Storage and space management including table spaces and data files and Management of table space growth, monitoring data files additions, extent growth
• Creating Databases and all database objects
• Constantly monitor the performance of the Databases and viewing Alert log files Trace files
• Effectively resolved incident tickets in the production environment

Environment:

Oracle 10g/11g, SQL Plus, Shell Scripting, PL/SQL, Windows-NT, Red hat Linux