ANUPAM  PIAREJI

Phone: 9821168583   Email: anupamf@gmail.com

 

EXECUTIVE SUMMARY:

Experienced manager & business analyst with over 10 years experience and more than three years focused on Project management activities performing project planning, creating work breakdown structure, system analysis, design, monitoring and delivery of project. Well skilled in managing projects from concept to completion.

Experienced professional with excellent verbal and written communication skills and proven ability to identify, analyze, solve problems and follow through to increase customer satisfaction and control projects.

Technical background of working on database. Experience in designing and modeling of databases and writing SQL queries. Apart from handling PM related activities, have always handled DB related tasks.

 

Key skills:
Project planning, scheduling and project delivery management.

Implementation and control.
Project communications and coordination.

Excellent interpersonal skills to develop business relations, communication and training.

Excellent interaction and cross functional team leadership.
Strong analytical and pattern detection.
Team motivation and development by mentoring members for increased performance.
Good in understanding requirement and converting these to SRS / FRS.
Experience in managing project life cycle through all phases.
Fully aware of project development methodologies: SDLC, Agile.
Strong technical background of working with databases.
Can analyse and design ERD for new projects.
Independent Database migration (using ETL tools).
Experience in SQL tuning: both Oracle, SQL server and PostgreSQL.
Working knowledge of Java – am currently leading Java projects.
Self motivated and result oriented working.
Excellent documentation skills. 


PROFESSIONAL EXPERIENCE: Total Experience – 10 years
1. Company : DSS, Mumbai (7 yr 9 months) – Feb'05 till date.
POST: Project Manager / Manager Analyst – Functional (3 ½ Yrs - Sep'08 till date).
Responsibility:  In charge of the management of project assigned. This included client communication; finalizing specification; creating WBS, creating project plan (MPP); regular reporting of project status, update and presentation of project plan / status to both clients and management; identifying problem situations; taking remedial actions for identified problems; team building activities by creating development programs; in-charge of testing and internal QA of project; documentation for various processes and project; handling of DB related work; design DB for the project; SQL query writing and tuning.

Projects handled as Project Manager / Manager Analyst: 

oject Name / Domain: Otto – PLQ [ Online sourcing application ] - Dec’12 – till date.

Team Size: 8

Software: Java, EBJ3.0, ZK, PostGreSQL

Description: Site for helping buyers to create sourcing plans, analysis reports for reviewing the planned versus actuals. ZK (zkoss) used for UI with EJB 3.0. Responsibility involved are: Analysis, prepare related SRS\FRD, preparing of Project plan (includes WBS), preparing test plans, working towards deliveries, doing functional testing.

Creating of DB structure design and maintenance on PostGreSQL.

 

Project Name / Domain: Master Data Management [ eCommerce site ] - Sep'11 – Dec’12.

Team Size: 4

Software: PHP, MySQL

Description: Master Data management system for Babyoye.com - LAMP project. Responsibility involved working as Business Analyst: work on Concept, finalize the concepts with client, preparing screen, preparing and approval on FRD\SRS, preparing test plans, functional testing.

Creating DB structure and maintenance on MySQL.

 

Project Name / Domain: OI eBuying2.0 [ Online auction site ] - Dec'09 – till date.

Team Size: 11

Software: Java, EBJ3.0, ZK, PostGreSQL

Development and GO LIVE: Feb’11.

Maintenance and Enhancments – till date.

Description: Auction site for the largest home shopping catalogue company in Germany. ZK (zkoss) used for UI with EJB 3.0. Responsibility involved are: Project Manager Analyst: create and finalize Concept, prepare related Screens, convert to SRS\FRD, checking concept with Proof of concept, preparing of Project plan (includes WBS), preparing test plans, working with the team towards deliveries, doing functional testing.

In charge of the entire DB structure design and maintenance on PostGreSQL.

Migration Lead for migrating data from 2 different DBs: SQL Server, Oracle to PostgreSQL. 

 

Project Name / Domain: Otto Logistics [ Logistics site ] - Mar'08 – Feb'09

Team Size: 12

Software: JWings, EBJ3.0, PostGreSql

Description: Site for Logistics - tracking of products from Suppliers to the Customer shops for one of the largest clothing company in Europe. It coordinates for movement and tracking of exact products sizes from various ports, consolidation and de-consolidation of products and had EDI for tracking information from various sources. Started with managing the project as Project Leader / Coordinator then promoted as Project Manager. JWings used for UI with EJB 3.0. Responsibility involved were: working as project co-ordinator to get phase wise details from the client, finalizing and documenting of requirements, tracking of work both within and outside the scope, functional testing, incharge of project deliveries, closing of project.

Involved in SQL query tuning – PostgreSQL.

 

POST: Project Leader / Lead Analyst – Functional (2 yrs - Mar'06 – Feb'08)

Responsibility: In charge of the Java modules for a client, both development and maintenance. Site included client communication; preparing module specification; creating change requirement documents, preparing delivery schedules; bug handling; identifying problem situations; billing for both maintenance and new development; in charge of testing and QA of deliverable; identifying new work / tasks in existing module development and presentation to clients for acceptance of estimate. Also incharge of database management for the project.

 

Project handled as Project Leader:

Project Name / Domain: Bonprix.com. B2B site for a clothing company – Mar'06 - Feb'08

Team Size: 7

Software: Java servlets, JSP, JSF, Spring, Hibernate, SQL Server 2005/ 2000

Description: The client is part of the Otto group and specializes in garments sales in Germany. Responsibility included maintenance of the B2B Java projects. The different modules included product tracking, supplier rankings, MIS reporting. Responsibility included maintaining the site having different modules. Some of the modules had varied technology and requirements. Incharge of maintaining the SQL Server and all the database functions / procedure and query tuning, database optimization.

 

POST: PL / SQL developer – Oracle 10g (1+ yr - Feb'05 – Feb'06)

Responsibility: In charge of the PL/SQL programming in the project. Created and maintained the database structure for the project. Writing and optimizing SQL queries, functions views. Giving suggestion for better implementation of functional requirements through sql statements.

 

Project handled as PL/SQL developer:

Project Name / Domain: CARO [ online auction site ] - Feb'05 – Feb'06

Software: JSP, Struts, EBJ 2.0, Oracle 10g.
Description: In charge of the entire DB design and maintenance. Creating SQL queries, procedures; optimizing of SQL queries; implementing of requirement via SQL queries or views.

 

2. Company : Sitel India Limited, Mumbai (2 ½ yrs - Feb'02 to Jul'04)

POST: Technical Support Associate (2 ½ yrs - Feb'02 to Jul'04)

Responsibility: In charge of : Trouble shooting issues; help setup features and controls; responsibility included work as Mentor (senior Tech) within the team; support products of client (given below); researching new issues / viruses members face; learning and finding bugs in products before launch.

Supporting the following products:

McAfee Anti-Virus – Creator of the 2^nd largest anti-virus and consumer firewall products. Work included helping setup and clean virsuses. Senior work included capturing Viruses and identifying newer viruses. Finding removal steps for newer viruses.

America Online – Helping setup and find problems with connecting with America Online – America's largest ISP.

 

SKILLS

RDBMS: PostGreSQL 8.x, SQL Server 2005/2000, Oracle 10g.

ETL Tools: SSIS, Kettle, EFS Data migration tool, (basic knowledge of Informatica)

Other tools: SSIS – used for data-migration, basic knowledge of SSAS, Visio – for database design, knowledge of ERWIN.

Project Management tool: MS-Project.

Have good hands-on for Word docs for preparing different documents for a project, preparing &  presentations using Powerpoint and reporting using Excel features.

 

 

EDUCATION

M.C.M. - Master of Computer Management (2001) from Lokmanya Tilak Institute of Management Studies and Research, Nagpur.

P.G.D.C.C.A - Post Graduate Diploma in Commercial Computer Application (2000) from Inter Institutional Computer Center, University Campus, Nagpur

B. Sc. - Bachelor of Science  (1999) [Physics] from Hislop College, Nagpur

 

Professional Certifications

IBM e-Business Application Programmer  from Pentasoft Centre, Nagpur.

Aptech's ADSE - Advanced Diploma in Software Engg from Aptech Education Center, Nagpur

CNA 4.x equivalent course from Aptech Education Center, Nagpur.

 

PERSONAL DETAILS

Full Name : Anupam Piareji

Address : ,19, Nav-Chintamani Apts, Dada Patil Road, Thane West (Mumbai).

Phone: 98211 68583

 

Read Less