Project Management

RANGANATHAN (Preferred Name: Ram)

****, **** ******* *****, *** # 60, San Diego, CA 92119 . Cell: 619-888-

**** . *-****: ****.*****@*****.***

EXPERIENCE SUMMARY

. 7 years of diversified experience in ERP and CRM implementation

systems, Business Planning Analysis and Market Research, Project

Management, Change Management, Risk Assessment, Software Asset

Management, Business Process Reengineering, Financial Management, and

Software Development life cycle processes (Requirements Gathering,

Design, Implementation, Testing and Maintenance).

. Comprehensive business analysis experience in all phases of Software

Development Life Cycle (SDLC) including Requirement gathering and

Documentation, Use Casing, Functional specification, Business Case

analysis, Quality Assurance and Testing.

. Experience in interacting with business users and executives to

identify information needs, gather Requirements, and authoring

Business Requirement Documents (BRD), Use Case Diagrams, Activity

Diagrams, Sequence Diagrams using UML modeling.

. Successfully managed complex projects on schedule with high quality,

interacting with geographically distributed teams in a culturally

diverse, highly rapid-change environments.

. Demonstrated excellent skill set in devising project schedules,

project scope and establishing project guidelines for small to medium

sized projects while constantly interfacing with the different stake

holders, Subject Matter Experts and other functional managers working

as part of the project.

. Displayed great project management and/or coordination experience with

excellent ability to multitask and coordinate several projects while

providing clear and concise documentation, including management of

tasks and project plan updates.

TECHNICAL SKILLS

. Programming Languages: PL/SQL, SQL, Java, C, C++, C#,.Net Framework,

VB, J2EE Framework, PL/SQL, SQL, JavaScript, Word Press, Firebug &

AJAX, HTML, XML.

. Databases: Oracle 9i, 10g &11g R2, MS-SQL Server 2005/2008, MySQL,

DB2,, IBM cloudscape

. Operating Systems: Windows XP/ 2000, Vista, Win Server 2003 & 2008, MS-

DOS, Linux.

. IDE: MS Visual Studio, MS Share Point, MS Project, Visio, Oracle-SQL

Developer, SAP BO,Salesforce, Qualtrics, Quest Toad, IBM DOORS,

CA Erwin Data Modeler & MS visual source safe, HP PPM & QTP

. Others: MS Office (Word, Excel, Power Point, Outlook, Access), MS

Visio, MS Project, and MS FrontPage

PROFESSIONAL EXPERIENCE

SONY ELECTRONICS (Retail, Operations & Sales)

San Diego, CA

Business Application Analyst / Consultant

Sept 2010 - June 2011

. Collaborated with groups in Sales, Logistics and other Business Units

while regularly frequenting with Information systems team in

implementing some of the E-CLIPS modules in SAP Business objects.

. Created project schedules for effectively monitoring Key Performance

Indicators (KPI's) including on-time delivery Weeks of Supply,

Forecast Accuracy and Point of Sales.

. Developed action plans, schedules and metrics for supply chain and

sales business processes with emphasis on recommendation for

improvements to reduce volatility and increase data accuracy.

. Exhibited excellent skill set in using ERP systems tools to interpret

complex data in providing precise detailed analysis and

recommendations to the Sales, Inventory Management and Demand Planning

team.

. Prepared regular budget and spend reports for major distribution

channels (Costco, Tech data & Sony Style) and periodically coordinated

with various business planning managers to interpret the demand

allocation and order fulfillment data using Business Intelligence

reporting tools..

. Implemented and Supported a Microsoft Dynamics Customer Relationship

Management (CRM) solution in the Sales Force Automation environment

existent at Sony Electronics.

. Acted as a liaison between the business planning units and Information

systems team to interpret the needs and requirements of the various

demand planning managers in the existing Electronic Closed Loop

Integrated planning System (E-CLIPS).

. Worked extensively with business planning managers in understanding

their user requirements to retrieve data pertaining to the distributor

channel information: Account(s) summaries, Monthly Statements, Balance

transfers between different resellers, profit centers and specialty

stores like RITZ Camera.

Environment: Quest, IBM Infosphere, IBM Cognos, Sales force,

Salesgenie, MS office Suite, MS Share Point, MS Project, MS Visio.

SONY ELECTRONICS (PMO)

San Diego, CA

Project Manager

June 2010 - Sept 2010

. Identified potential risks and opportunities for the software

portfolio of contracts worth $9.8Million encompassing 138 software

titles and representing a total of 64 software vendors.

. Devised an engagement process timeline to drive accountability for the

usage of software licenses among the various business units across the

US region.

. Proposed insightful recommendations in effectively consolidating and

managing the existing software licenses to the PMO by partnering with

cross functional teams in Supply Chain, Security, Finance, Accounting,

Marketing and HR departments to incorporate them in the IT Asset

Management program.

. Guided the software vendor management team in developing a service-

based cost budget program by researching the Statement of Work (SoW)

and End User License Agreement (EULA) for various software license

contracts to reduce software and maintenance costs by right sizing

contract agreements based on the number of licenses used / seats

purchased, license types, expiration dates, software spend and the

different types of vendors.

. Collaborated with Regional and Global Application Managers to

regularly track the software utilization levels by conducting personal

and panel interviews, distributing questionnaires and JAD sessions.

. Prepared and presented weekly and monthly business progress reports to

the Information Systems Division Controller and various other Business

Applications Managers to interpret the intermediate project goals and

their alignment towards incorporating a full-fledged Software Asset

Management program.

. Illustrated higher competency levels in oral and written modes in

communicating information to both the internal and external audiences.

Environment: MS Project, Visio, Excel, Power Point, SAP BO & Share

Point, HP PPM Software Suite

Computers 2 SD Kids (www.c2sdk.org)

San Diego, CA

Change Management Specialist

Sept 2010 - Dec 2010

. Created a comprehensive IT strategic plan with a primary focus in

implementing various business process enhancements and change

management plans to achieve C2SDK's sort term and long term IT goals

specifically in increasing the diversification of funding sources

through partnerships, sponsorships and other charitable donations

. Assisted in reengineering core business processes of C2SDK; i.e.

Donation, Disbursement and Inventory Management by configuring

changes in portfolio and contract management to maximize the ROI while

measuring the existing IT utilization levels.

. Prepared and recommended project delivery metrics aligning with

C2SDK's IT infrastructure goal to refurbish up to 6000 computers on a

yearly basis until 2015.

Environment: Expert level skill in Visio, PowerPoint, Excel and MS

Office package, Strategic IT models.

Computers 2 SD Kids (www.c2sdk.org)

San Diego, CA

Information Security Analyst

Jan 2010 - June 2010

. Collaborated with IT Management, legal, safety and security department

to manage security vulnerabilities.

. Prepared Information Technology Services documentation, including

department policies and procedures, Notifications, Web Content and

alerts to manage and maintain security awareness for C2SDK.

. Performed a security audit for C2SDK and developed and published

Information Security policies, procedures, standards and guidelines

complying with best practices and requirements in the industry.

. Interfaced with IT security team members and various Business Units

(HR, Accounting, Finance and Inventory Management) to resolve a wide

range of security issues including architectures, firewalls,

electronic data transmission and network access.

. Used various vulnerability assessment tools and conducted manual

testing to identify vulnerabilities within the IT-enabled applications

at C2SDK. Presented vulnerability reports to the senior management and

communicated remediation actions to the different application owners

and developers.

Environment: Nessus 4.0, Appscan, Web Inspect, AppDetective, Password

Evaluator, Eraser, Wire Shark (Packet Sniffers), SuperScan (Port

Scanners), Refog Key Logger, Qualys & HoneyBot.

SDSU, School of Communication

San Diego, CA

Business development Analyst / Consultant

Sept 2010 - Dec 2010

. Researched potential new business and/or product opportunities,

alliance partners/vendors, competitors and service providers for a

Testing Assessment tool named IMPACCT (http://impacctassess.org/)

conceived by a professor in the communications department.

. Partnered with industry professionals and third-party companies to

learn about market dynamics in and around educational testing services

segment.

. Worked collaboratively with team members to initiate and develop new

business concepts/models and strategic partnerships which can

complement IMPACCT's market strategies in the US region.

. Designed and prepared 10 year stipulated financial statements and

other excel-based models for IMPACCT's innovative business concepts

and strategies.

Environment: Business Plan Pro, Financial Modeling (Fin Calc,

Quantrix) MS Excel, MS Power Point

COMPARE NETWORKS

South San Francisco, CA

Business Intelligence Analyst

Jul 2009 - August 2009

. Methodical in producing ETL design guidelines ensuring an efficient

ETL infrastructure for BI systems.

. Extensively involved in Unit Testing and System Testing of ETL

processes.

. Involved in creating maintenance tasks and schedules using both the

SQL server agent and SSIS.

. Facilitated in developing necessary reports and helped in designing,

coding and testing the business Intelligence module connecting the

buyers and suppliers on-line using available BI tools.

. Experienced in Data modeling, Multi-dimensional Modeling and involved

in creation of Star Schema dimensional schema using Erwin Tool.

. Demonstrated proficiency in sorting the data, defining subtotals for

reports and designing report layout and worked with a Share Point

Server as the deployment and browsing solution for internal business.

. Managed package configurations in XML files to efficiently promote

unit tested packages to live environment from development environment.

Environment: Business Intelligence tools (Business Objects & Cognos),

PL/SQL, SQL, Oracle 9i, 10g

&11g R12, MS-SQL Server 2005/2008, MS.Net Framework, MS Project,

Oracle-SQL Developer, Windows

XP/ 2000, Vista, Windows Server 2003 & 2008, Toad, CA Erwin Data

Modeler, XML & SSRS.

INTERGRAPH (www.intergraph.com)

Huntsville, Alabama

Project Coordinator / Business Analyst

Oct 2005 - Dec 2008

Client: Fortis Alberta, Canada

Dec 2007 - Dec 2008

. Identified, assessed, and designed functional use cases that are in

alignment with the business requirements for one of the Canada's

largest distribution utility firm: Fortis-Alberta

(http://www.fortis.ca).

. Played the role of a module lead for the project and a requirements

analyst to review the overall functioning of the migration

configuration project.

. Worked as part of the QA team to realize testing responsibilities to

perform extensive Functionality Testing, Regression Testing, Menu

Testing, Configuration Testing, Interoperability Testing and

Compatibility Testing.

. Assisted in pitching the Intergraph's product development services to

prospective clients in US and UK.

. Assisted the team at Intergraph, Canada in validating the

functionalities, implementing the fixes (Transfer and Change

Requests), and making configuration adjustments during the warranty

period.

Environment: PL/SQL, SQL, Java, C, C++, MS.Net Framework,

Oracle 9i, 10g &11g R12, MS-SQL Server

2005/2008, MySQL, Windows XP/ 2000,Win Server 2003 & 2008,

Linux, MS Share Point, MS

Project, Toad, MS Visio, Business Intelligence tools (Business

Objects & Cognos), HTML, XML,

JavaScript, IBM Cloudscape, Word Press, Firebug & AJAX, MS

visual source safe,Crystal Reports & QTP.

Client: Anglian Water, UK, Swindon (Phase I & II)

Oct 2005 - Nov 2007

. Occupied multiple roles as a Module Programmer, Module Tester, Scrum

Master and Product Owner

. Partnered with the prime contractors of Anglian Water in defining

business & functional requirements including data flows and standard

procedures for implementing the various processes and maintenance

related enhancements spanning the SDLC and SCRUM projects.

. Planned and implemented a structured system flow for a data migration

project from gathering systems requirements to project maintenance.

. Provided analytical support for activities including; process

enhancements, identifying operational dependencies, configuring and

maintaining databases and document libraries, monitoring and reporting

on program metrics including the production of ad-hoc reports; and

effectively managing the overall document and information management

for the largest legacy migration project with Anglian Water.

. Prepared Database Design Diagrams using Erwin and Rational Rose.

. Interfaced with the different stake holders and team members within

the project during the planning phases of a Sprint. Closely monitored

the product development team to make sure, the potential product

increments fits within the client architecture and has the required

behaviors.

. Provided weekly project status update and reports to the higher

management by creating charts, graphs and other visualizations to

provide a high level overview.

. Worked closely with a large team of testers and subject matters

experts to resolve complex trouble requests and change requests, and

other third party issues.

. Designed and implemented basic SQL queries for QA Testing and Report/

Data Validation.

. Involved in UAT (User Acceptance Test), reviews and preparing project

documentation and user guides.

Environment: .Net Framework, Oracle 9i, SQL Server 2000, XML, MS

Office 2003 (Word, Excel, Project), Visio, Rational Rose, Quest, DOORS

Business, SAP Software Suite, PL/SQL, SQL, Oracle 9i, 10g,Toad

Intergraph's products (G/Technology,Geo Media & Business Intelligence

for Public Safety).

PRAMATI TECHNOLOGIES (www.pramati.com)

Hyderabad, India

Systems Analyst / Trainee

May 2004 - May 2005

. Analyzed, clarified and translated Business and users requirements to

Software Requirement Specification (SRS) and Functional specification

documents.

. Worked with Application developers and architects in solving

performance and configuration problems in Java & J2EE Technologies.

. Assisted in installing, configuring and troubleshooting the following

application servers: Pramati, Web logic and Web sphere.

Environment: Java, J2EE, IBM Websphere, Oracle, MS office.

[pic][pic][pic][pic][pic][pic][pic]

Contact this candidate