Project Manager Management

Pankaj KC

*** **** **.,********, ** Zip *****

Email id: ***********@*****.***

Ph. 314-***-****

Professional Summary:

> Resourceful and dynamic Business Analyst with over 5 years of

experience with strong business analysis skills and an understanding

of the software development life cycle (SDLC) and Agile methodology.

> Expertise in broad range of technologies including business process

tools such as MS Project, MS Excel, PowerPoint, MS Visio, BPMN,

technical assessment tools, Data Warehousing concepts and web design

and development.

> Proficient in Crystal Reports XI R2/Business Objects XI R2

OLTP/OLAP/Data Warehouse reporting tools.

> Proficient in developing Use Cases, Use Case Diagrams, Behavior

Diagrams (Sequence diagrams, Collaboration diagrams, and Activity

diagrams), and Class Diagrams based on UML using Rational Rose.

> Strong experience in client interaction and understanding business

applications, business data flow and data modeling using Logical

Modeling, Physical Modeling, Dimensional Modeling, Star and Snowflake

schema.

> Extensive experience in using the change management tools like

Rational Clear Case, Rational Clear Quest, and Perforce & requirement

management tools like Rational Requisite Pro.

> Extensive success in translating business requirements, reporting

requirements, and user expectations into detailed system

specifications employing Unified Modeling Language (UML).

> Expertise using Business Objects tools such as Supervisor, Designer,

BCA, Web Intelligence and Info view.

> Expert in facilitating and defining the entire Testing Life Cycle

including test strategy, test planning, test case preparation and test

execution.

> Experience in conducting Automation and Performance testing using

various tools including Rational Suite Tools, Selenium, and JMeter.

> Self motivated and possess ability for critical thinking, analysis,

team oriented, technically motivated and creative, user oriented with

ardent desire to learn clients business requirements.

> Transfer knowledge effectively to functional team once the project is

complete.

Education Qualifications:

Bachelor Of Computer Information System(BCIS)-Pokhara University 2002-2006

Masters Of Business Administration (MBA)-Fontbonne University, USA, MO

2007-2009

Skillset:

SQL Server 7.0/2000/2005, MS Access, ERwin 4.5/3.5.2, SQL*Loader, Oracle

9i, Business Objects (XI R2/5.0/5i/6i), Web Intelligence 2.6, Business

Intelligence 6.6, Crystal Reports (XI R2/10), Toad 8.5, SQL, PL/SQL, C/C++,

Load Runner, Mercury Test Director, HP Quality Center, Rational Tools, MS

Office, MS Share Point, MS Visio, MS Project .

Employment History

Employee Lunar Software Company Private Limited Company, Kathmandu, Nepal

2002-2007

Position : Busniness Analyst/QA lead/Tester/BI

Nepal Ecom Center (ECSC), Butwal, Nepal 2001-2002

Position: Intern ( for 2 months)

Position: Developer/Assistant Project Manager ( for 8 months)

Projects Summary:

Lunar Software Company Ltd., Kathmandu, Nepal

Project Coordinator/ Business Systems Analyst/ Test Manager

Project: Mortgage Management Supporting Service (MMSS)

Lunar Software Company is a leading software company which offers various

software services for various inshore as well as off-shore clients. LSC has

credential portfolio of developing software for private banks, law offices,

security organizations,Hospitals, Universities and private wealth

management sector.

-The Mortgage Management supporting service application called MMSS was

delivered within estimated time line. Plus it had an integration with the

pre existing system where we worked on conversion of multiple interfaces

which must be changed to support the new environment. I was also involved

in converting all Mortgage related loans into the BOK(Bankof Kathmandu)'s

MMSS system as part of the merger activity.

Responsibilities:

> Created functional design documents based on the Mortgages approved

requirements and supported the Enterprise Interface partners in

creating Technical Designs.

> As a Business Analyst, was involved in the analysis of source data and

created detailed Data mapping document between the new servicing

system (MMSS) and the various middleware and front-end applications.

> Worked on mapping of MMSS Web services to Enterprise Interface

Partners and coordinated with MSP Web Services environment to access

and connect related tasks/issues.

> Conducted Data analysis including loading data in tables and accessing

databases and writing sequel to analyze the data using My SQL.

> Coordinated Requirements gathering sessions and made sure the

requirements were clear and un-ambiguous.

> Conducted IT Reviews of the gathered requirements with the Enterprise

Interface IT Partners and developed Mock-ups and Wire-frames using

Adobe Flex to help them understand it better.

> Planned and conducted feasibility and impact analysis on the gathered

requirements based on resource, timelines, and the budget and helped

build the project plan.

> Tracked Project Requests in the Enterprise Releases and helped resolve

issues/risks arising out of that.

> Involved in developing Strategies and effectively implementing them

for Requirement tracking, Test Planning and Defect Management as the

Test Manager for the entire Enterprise Integration team and used

Quality Center to achieve the same.

> As the Test Lead, developed test plan and test scenarios and provided

aid to the test team with the build related information,

cycling/loading of account data and other technical information via

weekly meeting.

> Worked on doing End-to-End testing, and other complex database testing

using Toad/ Oracle and supported Black box testing by the LOB.

> Worked extensively on Quality Center all the way from requirements

loading, creating/updating test cases and tying them back to

requirements, test execution and defect logging/tracking.

> Worked on developing the Implementation plan for the entire Enterprise

Integration Team supporting multiple enterprise wide applications

during Conversion time-period and supported all the Enterprise

applications for a smooth transition from the old to the new system.

> As part of project close-out activity, was involved in documenting

various functional specs for future reference and cleaning-up the

WS Data Mapping doc for any errors.

> During post-production, was instrumental in improving performance

of the MSP system by 35% by collecting information from various

front-ends to monitor/observe the transaction volumes/ trend-lines

of the system and recommending infrastructural/ coding changes to

the various services used.

Environment: MS Word, Excel, MS Access, MS Project, HP Quality Center 9.2,

XML, RUP, MS Share point, Subversion UML, .NET, Oracle 7.3, PL/SQL, BPMN

1.2, Toad, Cognos 8.0, MSP, CA, BOE, Web Services, Lotus Notes, Windows

Outlook and Windows XP.

Lunar Software Company Ltd., Kathmandu, Nepal

Business Analyst/Business Intelligence Lead

Project : Enterprise Asset Management System

Lunar help their clients to most effectively manage their asset portfolios

to meet their strategic objectives. As the part a project "enterprise asset

management system" was Kicked-off to its clients.

Lunar was developing a radio-based automated meter reading system (AMR)

which reads information from electric, water, and gas meters. The

information is collected to a central database and is available through a

web-based interface. The Meter Mesh project was involved in developing an

Enterprise level software solution containing various modules like

Administration, Operations, Customer Service and Management, which cater to

the needs of the AMR system in any utility company.

Responsibilities:

> Conducted a thorough analysis and understood the requirements gathered

through the previous phase in the project.

> Gathered the business requirements for the new phase through Interviews

and JAD sessions.

> Analyzed the requirements and prepared the Vision documents for the

different modules to get the approval sign-off from the client.

> Created the mock-ups and screen shots using Adobe Flex to help the

development team better understand the requirements.

> Prepared the Use Cases for various functionalities in the enterprise

system and performed Business Process Modeling using Sequence diagrams,

and Activity diagrams using MS Visio.

> Communicated with the Stakeholders and SME's through JAD sessions and E-

mails to gather the reporting requirements used in the software solution.

> Prepared the Reports Standard documents and the Reports Design Documents

to help the reporting team effectively understand the requirements.

> Led and coordinated with the off-shore reporting team of four on a daily

basis in completing the reporting requirements using Crystal Reports.

Environment:

MS Word, Excel, PowerPoint, Visio, Agile, MS SQL Server 2005, SQL, Crystal

Reports XI R2, ASP .Net 2.0/1.1, C#, VB. Net, HTML/DHTML, XML, Windows XP,

Flash Player, Adobe Flex.

Lunar Software Company Ltd., Kathmandu, Nepal

Jr Business Analyst/Data Analyst/Tester

Project: Policy management system for Everest Insurance Company

This was my very first project in Lunar software company as an Business

Analysis. It was great honor to work as a junior Analyst and get to know

all the tactics of analysis and requirement gathering Project was for a

client which was leading national writer of automobile, homeowners; marine

and personal excess liability insurance. It had different offices across

the country.

Project involved developing an Integrated Policy management System where

the client wanted to extend its existing policy management systems for

access by the company's countrywide network of independent producers and

make it accessible over the Internet.

Responsibilities:

> Involved in gathering Business Requirements for new models through JADs,

E-mails and Surveys.

> Performed extensive Use Case analysis.

> Performed extensive Business Process Modeling using Swim-Lane diagrams,

Sequence diagrams, Workflow diagrams and Activity diagrams using MS

Visio.

> Conducted Feasibility Analysis to study the benefits of using the

application thro' Data Flow Diagrams and used Trace-ability Matrix to

find out the best possible technologies to be used.

> Coordinated with all Allstate agents to gather requirements for the

application and managed them using Rational Requisite Pro.

> Involved in Gap Analysis and ROI Analysis of existing policy management

system with the Enterprise system.

> Integrated Requisite Pro with Clear Quest and Rose to provide all teams

visibility and maintain tractability among requirements, use cases and

change requests.

> Analyzed the final requirements of data and authored the Source To

Target Mapping (STTM) Documents.

> Created Data Dictionary as descriptions for the mock-ups screens and

wire frames for the development teams.

> Studied and Analyzed the Reporting requirements of agents so as to

include them while building the application.

> Developed Test Plan and Test Cases in co-ordination with Quality Analyst

to perform manual and performance testing.

Environment:

MS Word, Excel, Access, Visio, Load Runner, Rational Requisite Pro,

Rational Rose, Rational Clear Case, Rational Clear Quest, ERWin 4.5, UNIX,

SQL, Business Objects XI R2, ASP .NET, Crystal reports 7.0, Windows XP.

Nepal E-com Center

Application Developer

Project: Shopping Center Record

Description:

This was the Window-based application for keeping daily sales record of

Kathmandu Mall with highly flexible reporting system. Involved in the

development using VB.NET and SQL Server 2000 etc. Includes GUI Design and

Development of the application.

Role and Responsibilities:

. Involved in all phases of SDLC, Design, and Coding, System testing,

Bug fixes, Modification and deployment.

. Developed solutions for diverse programming scenarios (prototyping) in

.NET Technologies, employing object oriented programming concepts.

. Components were consumed by windows applications utilizing SQL Server

and stored procedures to perform logical business transactions.

. Wrote database components to access Database using ADO.NET.

. Extensively worked with Win Forms and Server, Data Binding.

. Used VB.NET for creating classes of this application. Integrated

Crystal Reports with VB.NET and VB.NET pages.

. Developed GUI pages using VB.NET and ADO.NET as the data consumer.

. Deploy and manage applications, including monitoring, performance

tuning, logging, and configuring, troubleshooting, quality assurance.

. Performed testing, documentation and support of the newly developed

application

Tools & Environment: C#.Net, C#,.Net Framework 2.0,VBScript, ADO.Net, XML,

HTML, DHTML, IIS, SQL Server,T-SQL, Crystal Reports, Windows 2000 Server.

References:

Mr. Sekher Thapa ( worked together for four plus year)

Project Manager

Lunar system Pvt. Ltd

Kathmandu, Nepal

Ph:#: 00977-9851088816

****@********.***

Mr. Bibek Diwadi ( worked together for 2 plus year in LSC and currently

working for different client)

Developer/ software engineer

Driven Inc, Fall church VA

Ph#: 515-***-****

*******@*****.***

Mr. Hari Poudel ( worked for more than 3 plus year and now currently

working for different company)

Developer/ software engineer

Information Intellect, Fort Worth, TX

Ph#: 641-***-****

********@*****.***

Contact this candidate