Roop Kumar Naram
Apt#***,Scarborough, ON, M1J3C9.
(416) [439 2046] - Residence Email: [**********@*****.***.***]
_____________________________________________________________
Profile
Roop Kumar Naram is an experienced Project Management professional with over 6 years of Project Management experience. He got over 24 years of complex business systems design, development and implementation experience in Manufacturing, Insurance, Banking, Financial, Mutual fund, Supply chain and software industry. He lead big projects of team size 28 software engineers of on-site and off-shore. He got expert estimation skills using functional point analysis and developed complete project plan, budget plan, resource planning and risk management. He also got experience in provincial government work management software. He got excellent team management and team building experience. He has full lifecycle (SDLC) Application development experience, including technical reviews, defect tracking and change management. He has got excellent client facing skills and awarded five years contract for FISERV.
1. Hands-on experience in developing detailed project plan using MS Project 2000
2. Proactively escalate project issues that require executive attention
3. Excellent communications skills with peers, stakeholders and vendors
4. Working knowledge in systems software, network communication, database
5. Effective in conflict resolution in terms of scope, change management
Areas of Expertise
Products: MS Project, MS Word, MS Excel, MS SQL Sever 2000, MS Visio, Oracle Developer 6i, Oracle Forms 6i, Oracle Reports 6i, ERWin Data Modeler, Toad 7.6.
Standard, Libraries, frame works: HTML,XML, SQL
DBMS: SQL, Access, Oracle9i, Oracle 10G
Programming languages: C, PL/SQL, Unix shell scripting.
Platforms: Windows 95 / 98 / 2000 Professional / NT / XP, VAX-VMS, UNIX
Tools: Business Objects Data Integrator 11.2, Informatica 8.1
Professional Experience, Accomplishments:
Aug 07 – Till date MD Financials Toronto, Ontario
Project Manager
Responsible for the ETL Development team for requirement gathering, analysis, design and development of mappings. Managed different groups like Developer team, Testing teams and Management team.
Other key responsibilities:
• Managed all vendor supplied resources and permanent staff.
• Verified that mappings meets the Business requirements, User needs and Specifications
• Analyzed project documents to identify requirements in order to extract the conditions to be develop
• Reviewed mappings that covered Functionality of requirement
• Reviewed functional and technical documentation of mappings Scopes, development, implementation
• Tested to see that the mappings able to deliver expected results.
• Interact with Business Analyst in order to pin point problems and solve them
• Communicate project status and issues to the Project stackers.
Accomplishments: Complete validated flat files handed over to Citi group.
Application type: Financial Applications.
Tools and technologies used: MS Project, Business Objects
Data Integrator 9.2, Oracle 9I, PL/SQL, Windows NT
May 07 – Jul 07 City Of Toronto Toronto, Canada
Project Manager
Responsible for interface development for Hansen work management system
Team, responsible for implementation and testing of the interfaces of
project. Responsible for deliverables for different clients for same like
Development, testing and Management.
Other key responsibilities:
• Developed project estimation, planning and execution.
• Prepared requirement specification for the 311 integration.
• Prepared the functional design, Technical design.
• Developed code for the integration.
• Developed test plans.
• Tested the code based on the test data.
• Refreshed the environment and test all code.
• Migrated to production environment.
Accomplishments: Seem less integration of Hansen system with 311 system .
Application type: Ms Project, Hansen Work Management 7.7 based onOracle 9i.
Tools and technologies used: Hansen Work Management 7.7, Oracle9I,
PL/SQL, Windows NT
Jul 06 – Apr 07 NCR Toronto, Canada
Project Manager
Responsible for delivery of patches of all bugs of supply chain product of
Unix, Linix, Sun solarisis and Window NT. Developed project plan in consultation
with business group and technical development teams. Prioritized delivery
schedules for release of bug fixes based on criticality. Managed clients in
resolving issues and proving updates in timely manner.
Other key responsibilities:
Monitored technical testing for Tera data based supply chain System.
Executed test cases for the Tera data based supply chain system that uses 128-bit SSL data encryption, currently the highest commercially used data encryption algorithm.
Verified application modules are developed in accordance to functional specifications
Worked closely with Business users, Business Analysts and Technical Writers on clarifying business requirements and documenting applications functionality
Participated in design review meetings to understand and improve technical and functional systems specifications
Lead a team of 8 onsite, 3 off-shore
Accomplishments: Managed release of patches as per schedule.
Application type :MPRAS 3.1.2 Supply chain system based on Tera data.
Tools and technologies used: Unix, Linix, MPRAS 3.1.2, MPRAS 3.2.2,
Windows NT
Sep 05 – Mar 06 HawaiianTelecom Denver, Colorado
Project Manager
Responsible for estimation, development of resource plan, project plan and
execution. Managed all expenses based on budget and approval for new budget. Responsible for all deviation report and other reports bases on the project plan for the management. Managed different client groups like End users, Business and the development.
Other key responsibilities
Tested all functional and technical specifications against the requirements for developing customized reports and forms in GL INV, PO, OM modules and integrated them with other applications.
Created Concurrent programs to add new Suppliers and update existing supplier’s data.
Developed PO Requisition Interface based on Functional design from flat file to PO Interface table using different validations like verifying vendor Id, charge account, code combination Id, Unit of Measure and prepare. Validation is performed using SQL * Loader, validation Procedure, and if any errors occurred can be validated in Error Tables.
Wrote Technical Documents (TDS) for various custom reports and outbound interfaces developed in FA and AR modules.
Worked extensively with User Acceptance Testing and developed Unit Test Documents (UTD) for most of the PL/SQL packages developed for conversion process in FA and various custom reports in GL PO and OM.
Developed SQL* LDR scripts and did SQL tuning of PL/SQL packages.
Accomplishments: Successfully migrated Verizon legacy data to Oracle Financials 11i .
Application type: Oracle Financials 11I based on Oracle 9i.
Tools and technologies used: Oracle Financials 11I, Oracle 9I, PL/SQL, Windows NT, Unix, Toad.
Dec 03 – Aug 05 Sun Life Toronto, Canada
Technical Consultant
Project Manager for Oracle Financials 11i suite, responsible for customization and testing of forms, reports, interfaces for GL, AP,AR. Responsible for implementation new system.
Other key responsibilities
Involved in the migration of Insurance legacy data into Oracle GL module. Developed various PL/SQL packages for data validation for the conversion process. Also involved in reconciliation of GL data with legacy system.
Developed Outbound interfaces for extracting data from Oracle GL to Data warehousing systems for the access of the data from end users.
Wrote shell scripts for the outbound interfaces in GL and registered them as concurrent programs and executed them successfully.
Worked extensively in developing customized reports based on the client requirement in GL AR, INV, PO, OM modules and integrated them with applications.
Set up Oracle Inventory and interfaced with the custom developed order
entry system.
Set up of item, UOM, ATP rules, Work calendar and other set up issue.
Wrote Technical Documents (TDS) for various custom reports and outbound interfaces developed in FA and AR modules.
Worked extensively with User Acceptance Testing and developed Unit Test Documents (UTD) for most of the PL/SQL packages developed for conversion process in FA and various custom reports in GL AP and AR.
Involved in writing SQL* LDR scripts and SQL tuning of PL/SQL packages.
Accomplishments: Successfully migrated legacy data to Oracle Financials 11i .
Application type: Oracle Financials 11I based on Oracle 9i.
Tools and technologies used: Oracle Financials 11I, Oracle 9I, Oracle Forms 6i, PL/SQL, PRO*C, Windows NT, Unix, Toad.
.Have previously worked on projects with the following large organizations:
• A S Watson, India, Dev. Role
• Retek Logistics, OH, USA. Dev. Role
• GE ERC, KS, USA. Dev. Role
• Cummins Engines, IN, USA. Dev. Role
• Wheeling Pit, WV, USA. Dev. Role
• Norwest Financials, IA, USA. Dev. Role
• Phillips Petroleum, OK, USA. Dev. Role
• TSC, TN, USA. Dev Role • PMSC, India. PM Role
• Fiserv, India. PM Role
• GE Drives, India. Lead Role
• Southern Edition, India Dev Role
• CAA, Bahrain, Middle East Lead Role
• CMC, Bahrain, Middle East Lead Role
• Mutual Funds, India Lead Role
• TCIL(TATA Steel), India Lead Role
Details of projects with these organizations and specific achievements in each organization can be provided in a detailed résumé if required.
Education Qualifications
Specialized Training and Courses
Nov 07 Informatica V8.1 Toronto, Ontario
Aug 07 MS Project 2003 Toronto, Ontario
Jun 06 Oracle Financials 11i
Functional/Technical Toronto, Ontario
Nov 02 Dataware housing,
Cognos, ERWIN Training Hyderabad, India
Jul 99 Oracle DBA 8I Advanced Training Dallas, USA
Jun 99 Oracle Backup and Recovery Training Dallas, USA
May 99 Java Programming Training Dallas, USA
Jan 90 - Jan 91 Post Graduate Diploma In Systems Management
National Institute Of Information Technology, India
Jul 84 - Oct 86 Post Graduate Diploma In Labour and Social Welfare
Institute Of Labor Studies, Jamshedpur, India
Apr79 - Mar 82 Bachelor of Science in Zoology, Botany and Chemistry
Andhra University, India
Languages English, Hindi References Available upon request