SUMMARY:

• 20 years of experience in software development on a wide range of technological platforms from client server to web technologies.
• 15 years of experience in scoping, requirements gathering, business process analysis, business process modeling and reengineering.
• Rich experience of working with key stake holders for planning, status reporting, managing, tracking and delivering business critical applications and using Project/Program Management tools such as MS Visio, MS Project, MS Project Server and ProjectByNet.
• Excellent track record in successfully executing complex projects for legacy migration, third party transitioning, business applications development and implementation of Data Warehousing and Business Intelligence solutions.
• Worked on all phases of Software Development Life Cycle on a wide range of technological platforms using industry standard methodologies and practices.
• Worked with Fortune 500 clients in US, UK & Europe using global delivery model.
• Strong database programming skills using T - SQL and PL/SQL.
• Excellent written, verbal and client interfacing skills, strong problem solving skills, proven ability to work under pressure in a fast paced environment by interacting/liaising with people from different groups at various levels from diverse background, wealth of experience of working in international environment are the key strengths.
• High motivation level, ‘Can-do’ attitude, professionalism and the genuine desire to make contribution are the main assets.

TECHNICAL SKILLS:

Operating System: Windows 200/XP/Vista, UNIX/Linux, AS 400

RDBMS: Sybase 10/12.0, MS SQL Server 2000/2008, Oracle 8.0/10g and DB2 8.0/9.5, Teradata 12.0

Programming Languages: PowerBuilder 6.5/9, Visual Basic 6.0, C++ & VC++, Java, T-SQL, PL/SQL

Web Technologies: ASP .Net 2.0/3.0, XML, XSD, JSP, J2EE

Middle Tier Technologies: COM/DCOM, MTS & BizTalk Server 2004,EJB, WebLogic Server 5.1

Reporting Tools: Hummingbird BI Query Reports 9.0.2, Crystal Reports 8.5 and MS Reporting Services 2000/2008.

Configuration Management Tool: PVCS 4.0, Visual Source Safe, Clear case and TFS.

Project/Program Management Tools: MS Visio, MS-Project, MS Project Server, ProjectByNet, MS SharePoint

Others: Sybase Open Client/ Open Server, Informatica 5.5/6.0

PROFESSIONAL SUMMARY:

Confidential

Project Manager

• Held meetings with different stake holders like Government Agencies, Peoples’ representatives at different levels, village folks and University Professors for assessment of problem,
• Extracted data from different sources about the drinking water schemes, rainfall history, villages facing scarcity, drought prone areas, sources of water, ground water levels etc.
• Mapped drought areas with water schemes and conducted feasibility studies of providing water to villages facing scarcity through piped water or water tankers.
• Developed mathematical models for prediction of ground water levels with the help of University professors.
• Based on the studies of historical Government plans on drought mitigation developed new plans and obtained approval of the same from the stakeholders.
• Managed Execution and monitoring of the plans.

Environment: Quantum GIS, PostGIS 1.5, PostgreSQL, MS SQL 2008

Confidential

Business Analyst

• Led the business requirements sessions with main stakeholders ie selected FPOs, group of farmers, Government Officials, bulk purchasers and end customers for the development of technology platform.
• Developed prototype screens and documented business processes.
• Worked with development team for system analysis and system design sessions.
• Developed Test plans and test cases for both black box and white box testing.

Environment: MS .Net 2.0, MS SQL

Confidential

Business Consultant and IT Project Lead

• Performed Vendors Assessment & Vendor Product Assessment for shortlisted vendors.
• Business Process Analysis using Kaizen methodology & Business Process Reengineering for New Cash Office System
• Defined and Developed Work Flow based System and integration with VeriBalance, the Vendor Product
• Developed a Business Intelligence application for Fast Lane Cash Monitoring and Forecasting.
• Developed intelligent support tools for tracking, auditing and issue fixing in the balancing lifecycle by integration of data.
• Developed a Disaster Recovery Solution for store and corporate balancing systems.
• Carrying out Project Planning, Scheduling, monitoring, tracking and delivery
• Managed development and delivery using distributed development model with a combination of onsite and offshore teams.

Environment: MS .Net, MS SQL 2008, DB2 9.5, Teradata 12

Confidential, Orlando, FL

Program Manager

• Carried out assessment of current system.
• Worked with the stakeholders to gather business requirements and define scope of the‘To be’ system
• Performed gap analysis, defined System Requirements and system architecture.
• Carrying out Project Planning, Scheduling, monitoring, tracking and delivery
• Expanded the account into four separate tracks within a short time span

Environment: MS .Net, MS BizTalk RFID Server, MSMQ, SAP

Confidential

Business Consultant & Project Manager

• Worked with both business and technical stake holders to create and demonstrate a prototype of envisioned front end extension called Launchpad using Service Oriented Architecture (SOA) for accessing business data from legacy back end systems and providing a single view of customer data to Customer Service Professional.
• Played a key role in using wireframe model to document business processes and task flows to get a consensus on the requirements from business stakeholders from different regions.
• Prepared Proposal and Project Plan

Environment: MS .Net, SQL 2005, UNIX, Oracle 10g, DB2 8.1

Confidential

Project Manager

• Led the development team for Design and deliver .Net based online publishing application for subscribing, searching, adding and maintaining manuscripts and billing with integration of third party products for online community/forums.
• Performed evaluation and Integration of third party products for blogs and credit card payments and billing solution for PCI compliance.
• Performed data mapping, data cleansing, transformation and data load using custom SQL based scripts.

Environment: MS .Net, SQL 2003

Confidential

Business Analyst and Project Manager

• Defined the scope of the project and completed Requirement gathering and Business Analysis
• Delivered a state-of-the art MS .NET based solution for ESOP administration and CRM solution with a high level of reusability that reduces the deployment time.
• Successfully managed Data Migration from PROGRESS to MS SQL Server database through custom script based ETL process for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”.
• Successfully developed a Data Warehouse and business reporting solution using M.S. Reporting Service.
• Developed subject matter expertise in financial and health benefits by understanding the core functionality, thereby expanding the scope of engagement

Environment: Windows 2000 Advanced Server, MS SQL Server 2000, Visual Studio .NET 2003, M.S. Reporting Service 2000, QTP

Confidential

Project Manager

• Defined Project Scope, migration strategy and prepared feasibility studies.
• Completed business analysis and devised a strategy to automate the conversion for productivity gains and developed a tool for the same.
• Defined delivery and Quality processes for onsite/offshore model.
• Performed rationalization and improvements of reports for business intelligence solution.
• Lead the team successfully by managing the scope of the assignment, client interaction for revised estimations on account of complexities of reports, client side issues during UAT and overall schedule constraints to deliver the project on time.

Environment: Windows 2000 Advanced Server, MS SQL Server 2000, Visual Studio .NET 2003, MS Reporting Services, Crystal Reports 8.0.

Confidential

Project Manager / Business Analyst

• Defined Project Scope and conversion strategy.
• Prepared a high level Data Conversion Design for performance efficiency.
• Defined ETL Process to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”
• Used Oracle based Development Environment to develop migration scripts to leverage offshore model before carrying out the final migration in AS 400 environment.
• Closely monitored all the project activities of the onsite team and the offshore team, resolved issues in data mapping, developed exhaustive test scripts for quality purpose and deliver the project on time.

Environment: UNIX, Oracle 8.1.4, PL/SQL, IBM OS/390, IBM AS 400, RPG/400

Confidential

Project Manager

• Defined Project Scope, completed efforts estimation and feasibility studies.
• Prepared Data migration Strategy document and impact analysis document
• Prepared testing Strategy document and impact analysis document
• Gathered Business knowledge and all aspects of JDA’s Portfolio Merchandise Management System (PMM) functionality for Requirement Analysis.
• Lead the team successfully by managing dependencies, business and technical challenges in migrating over 200,000 Case Packs and 125,000 POs and over a million inventory transactions.
• Managed automatic testing of migrated data using Silk Test tool.
• Met the delivery milestones without compromising on quality.

Environment: Oracle 8.17, UNIX, and JDA’s Portfolio Merchandise Management System, Silk Test Suite

Confidential

Project Manager / Business Analyst

• Worked on solution development and system design.
• Set up offshore team, resolved a number of outstanding issues and streamlined the onsite/offshore delivery processes.
• Managed client interaction & Offshore project deliveries.

Environment: C# .NET, MS SQL Server 2000, Rational Clear Case and Clear Quest

Confidential, Cleveland, OH

Project Leader/Project Manager

• Interacted with the client for assessment of the system and requirements analysis, presented creative solutions for radical performance improvement, developed a proof of concept, prepared proposal and got agreement from all the stake holders in the project.
• Developed a data extraction and load process to load the data from disparate systems into SQL database.
• Successfully brought down the response time from 75 minutes to less than five minutes eliminating all the jobs hanging and database locking issues

Environment: Visual Basic 6.0, COM, and MS SQL Server 7.0, DTS

Confidential, NY State, NY

Project Leader / Project Manager

• Interacted with client for requirements gathering and preparing specifications, proposing technological solution, design specifications and project cost estimations.
• Successfully completed all the project management tasks and delivered the solution on time.

Environment: Visual Basic 6.0, DB2, AS 400, MS ACCESS, IBM Client Access 3.0/5.0

Confidential, Grand Rapids, MI

Senior Technical Consultant/Team Lead/Business Analyst

• Designed and developed Product history and location maintenance modules using Object Oriented methodology.
• Worked as a Business Analyst on the Warehousing and distribution system for Put away.
• Worked as Team Lead for “Put away” module involving a set of complex business rules and developed the same using PowerBuilder, CICS6000/C++ and Sybase System 11.
• Designed a de-normalized table and wrote complete specifications for 30 stored procedures to build and maintain it using Sybase Replication Server to meet the response time requirement of two seconds.
• Worked as Team Lead for Performance tuning of a transaction for Hilo drivers moving the product into the warehouse and successfully brought down the response time from 39 seconds to less than 5 seconds to meet the Service Level Agreement.
• Developed a mathematical algorithm for distance calculations within the warehouse and incorporated it into SQL statements. This combined the power of mathematics with the set operations of SQL to significantly reduce the response time.
• Worked on web accessible Product at Location Status Reports.

Environment: Power builder 6.5/7.0, Sybase System 11.9, CICS 6000/C++, Rogue Wave Tools++/DB Tools++, Visual Studio 5.0/6.0

Confidential, Detroit suburb, MI

Team Lead

• Prepared design specifications with OOD methodology.
• Helped the team solve complex technical problems both on front end and back end for customization of the TESS system.
• Wrote a number of stored procedures and triggers and other PL/SQL scripts for business functionality.
• Successfully completed benefits, accruals and other reports to meet customer requirements.
• Worked as Quality Assurance and post-delivery technical support lead.
• Trained and mentored team members in different technical skills.

Environment: PowerBuilder 4.0/5.0, ORACLE 7.x, PL/SQL 2.0, Sybase System 11 and MSS 6.5

Confidential, Grand Rapids, MI

Team Lead

• Played a lead role in Development of Prototype and writing system specifications.
• Involved in GUI Design using Application Development Framework (Viper), Preparation of Design Documents and Construction.
• Developed PO Calculation module with C++ for Allowances, Charges, Gross and Net Cost etc.
• Designed and developed PO Split Process and PO Purge process using Sybase stored procedures.
• Designed Triggers for PO Audit functionality

Environment: PowerBuilder 4.0, Sybase SQL Server 10.0, Watcom C++ 10.5