Summary

Oracle Database developer and Project Management Professional with over 5 years of experience in providing design, development, and implementation support of technology operational systems. Demonstrated success in designing and implementing programs for billing and ordering systems, with proficiency in business interface. A proven leader effective in interfacing with users, stakeholders, subject matter experts, and members of the IT staff; delivering projects focused on teamwork, creativity, and profitability. Excellent written and verbal communication skills. Hold M.S. in Computer and Information Science (CIS). Core Strengths include:

• Requirements Gathering & Documentation
• Process Improvement
• Systems Design, Development & Coding
• Analysis/Investigation
• Issue Resolution
• Client Satisfaction

Confidential, New York, NY

Project Manager, Feb 2012 - May
Responsible to replace the current intranet with a new one that would bring in more features and functions for the users.

• The new intranet platform that will enable employees, (and vendors and volunteers) to communicate and collaborate more efficiently.
• Department structure: Department landing pages; Hierarchical storage of department resources, user friendly document management.
• Group collaboration: Calendars, notifications, blogs/forums/messaging.
• Powerful Search (like Google.)
• Organizational directory listing (using AD and HRIS data.)
• Robust calendaring (ability to choose and search what you want on your calendar.)
• Fine-tuned notifications and subscription options; IM, options for video, audio.)
• Document Management (multiple document upload, version control, and checkout.)
• Role based content (different users will see different content on their homepage/dashboard on login.)
• Single sign on; links to apps; sign on for vendors and volunteers.
• Role based permissions; Google Analytics.
• The new intranet with full-feature, cutting-edge technology to enable all users to contribute to and benefit from each other's knowledge.
• Worked on PL/SQL programming, Triggers, Procedures and Packages, views for one of their projects.
• Responsible for successful implementation of website: zipthecure.com for raising donation for the organization (Identified existing talent in group and asked a programmer in the group to implement an automated tool for rendering of the US map. The external vendor had troubles and could not implement this tool. Also implemented load testing tool to test the amount of load the web site could handle for this project and got it implemented within a week.
• Wrote the architecture of zipthecure website which the vendor did not provide.
• Eye to identify talent in group and using resources most efficiently.
• Experience in translating business needs into detailed development specifications.

Verizon, New York, NY 1998 - 2011

Technical Lead, 2011
Supported ordering and reporting systems, interfacing with billing application system for the legacy retirement project used by over 1.5K customer service representatives and other internal application users. Worked on the backend system of Oracle using PL/SQL programming, Queries, Triggers, Procedures and Packages, views, sequences, Sub Queries, etc.

• Served as key member of team that designed, implemented, tested, and supported migration to another platform, retiring existing system.
• Led project planning and document requirement efforts with onshore and offshore staff; pro-actively addressed problem resolution and implemented any identified process improvement.
• Researched processes for improving efficiency and flawless delivery of all strategic and revenue impacting initiatives. Identifying errors resulting in reducing errors up to 20%.
• Recognized for consistently coordinating cross-functional teams through all phases of lifecycle, ensuring successful 10 month project completed on time, within budget; and in meeting enterprise standards and SLAs.

Team Lead and Software Programmer 2006 - 2011
Designed provisioning table system for NSOP (billing) application where any front end application could access the tables and get real time data. Coordinated and implemented all releases, and partnered with onshore/offshore team to ensure timely and error free deliverables. Worked on PL/SQL programming, Triggers, Procedures and Packages, Queries, Functions, views, sequences, etc.

• Created new architecture, improving efficiency of table updates; led to retirement and dependency of vendor based systems.
• Designed and implemented new processes to facilitate database cleanup and synch up, resolving customer billing issues.
• Created and implemented procedures for bundles (DSL, FiOS, TV, and Phone); contributed to increasing revenue by ~15% for double and triple play offers.
• Optimized the query performance with modification inPLSQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.
• Developed new functions for exit of West Virginia from long distance services. Provided ordering extracts, reconciliation and retirement of ordering data pending, and completed tables.
• Led NSOP (billing) onshore and offshore team of 5, creating a parallel environment for billing and ordering systems to facilitate testing of long running projects outside of BAU ITO; increased testing efficiency by ~20%.
• Created and implemented design to copy orders to the completed tables for historical and regulatory purposes and for executive appeals responses.
• Researched and executed production queries to compare orders in different systems to resolve billing issue.
• Participated in Disaster Recovery Exercise

Software Programmer, 2005 - 2006/1999 - 2004
Responsible for service order design, implementation, coding, and testing of various projects for consumer accounts and ordering systems. Project enhancements included: Centrex, DSL, Unity, IOBI, Dry Loop, Grandfather Calling Plans, Voice Mail, Package Billing, Bundles, Flexpath, Resale, Taxes, Collections, FTTP, Resale, Wholesale, CLEC, NPA Splits and Overlays, TPV, VZLD Unlimited Plan, Winbacks, Dial Tone Features, Special Pricing Plans, Rate Changes, and Concession.

• Coded, tested, and implemented projects for monthly ordering and billing, correcting fallout of orders and facilitating overall order flow system process; improving efficiency by ~15%.
• Created stored procedure for the ordering system to pass correct data to other systems and support several IVR applications.
• Served as team leader on bundle offers (DSL, TV, and Phone); increasing revenue by ~20%.
• Supported CMM level processes.

QA Tester, 2004 - 2005

• Prepared Test plans, executed and tested them.
• Completed regression and code integration testing.
• Interfaced with clients.
• Delivered traceability to the client.

Programmer, 1998 - 1999
Involved in design and development of VB application with Access database for updating mainframe tables outside the mainframe environment and sending it back through ftp. The data was used by Edits-Tables team for updates.

Confidential, Newark, NJ 1997 - 1998

Lab Assistant, Lead
Supervised daily workplace operations; this included: serving as technical support for IBM PC's, and DEC-VAX terminals, assisting users with software problems in windows applications on Novell Network, facilitating customer requests and programming issues, and performing routine software/hardware checks of over 100 computers.

EDUCATION

Master of Science degree; major: Computer and Information Science (CIS)
Bachelor of Science degree; major: Computer and Information Science (CIS)

Technical/Software Skills

Database: DB2, MS SQL Server, Oracle, MS Access
Languages: PL/I, SQL, FORTRAN, PL/SQL, C#, C, C++, Turbo Pascal, VB, Expert System
MS Office Suite: Word, Access, PowerPoint, Excel