Plano TX-Texas, US
Phone: xxx-xxx-xxxx
Email: xxx@xxxx.xxx
Looking For: Technical Project Manager, Technology Archietect
Occupation: IT and Math
Degree: Master's Degree
Career Level: Experienced
Languages: English
Highlights:• 11+ years of experience in software development with 4+ years in managing projects by applying people, process, problem solving, and technical skills to achieve project objectives and improve individual, team and organization performance. • Project Management Professional Certified (PMP®) - PMP® Number: 1981823, with proven track record of strong technical contribution and leadership in enhancing team productivity, deliverable quality, and customer satisfaction. • Experience in managing 1.5 M+ project with a team of 20+ resources, and driving end to end project development by mentoring, motivating, supporting team to surpass defined goals. • Executed and maintained project management processes and disciplines in the areas of: project schedule and quality management; communications management; human resource management; cost management; risk / issue management; change management. • Excellent technical, analytical, problem solving, communication, interpersonal and leadership skills for effective interaction with customers, business partners and management at all levels. • Strong technical expertise and hands on experience on Oracle PL/SQL (11i/10g/9i/8i), UNIX shell scripting. • Technical oversight and good experience on leading projects using Core Java, Java Springs Framework, Spring MVC, Jquery, JSP. • Experience in redesigning/developing data model for many Supply chain systems Data warehouse and developing ETL loaders, ETL loader job scheduling. • Extensively involved in performance re-engineering of large supply chain systems data warehouse with expertise in Query Optimizer, Explain Plan, Indexes, HINTS. • Expert level skills in SQL, PL/SQL Development (SQL scripts, Functions, Stored procedures, Cursors, Triggers and Packages, Advanced PL/SQL objects, Bulk collections, Materialized views, etc.) • Experienced in working with SQL*Loader, External Tables, Import, Export to extract and load large volumes of data, Partitioned large Tables. • Technical oversight and good experience working in VB, VBA, SQL Server, C# and ASP.NET.
Skills:PMP, Oracle PL/SQL, Unix Shell Scripting, Java, VB.NET, VBA, C#
Goal:Lead/Manage projects by applying people, process, problem solving, and technical skills to achieve project objectives and improve individual, team and organization performance.
Membership:Active Member of PMI (Project Management Institute)
Certification:Project Management Professional Certified (PMP®) - PMP®
Honor:? Wow! Award, top performance rated for 4 continuous years at Infosys Technologies Ltd. ? Awarded Vendor excellence award by Ford Technology services for successfully managing suite of finance forecasting applications. ? Awarded spot recognition by Ford Technology Services for successful transition of TVM-ER application in spite of lot of hurdles and complication and completing the process in the estimated time without delay. ? Awarded Spot recognition by Ford Management systems practice head – Europe, for excellent solutions in financial forecasting and Effective reporting. ? As an appreciation for the successful function of our team, we have been awarded Team of the quarter award for 4th quarter of financial year 2010 by Ford Technology services India. ? Awarded Spot recognition by iSOFT management for working effectively in a release for Scottish customers in a very critical situation and for completing it without any delay. ? Microsoft certified Professional in Designing and implementing SQL server 2000 Enterprise Edition.
Project Manager at Infosys/Technology Architect at TI on behalf of Infosys 04/2015 - current
Infosys Limited, Plano, Texas United States
Industry: Software Development
Product Costing System:The objective of this project is to revamp the pricing system within Texas instruments to prepare for growing need for more flexibility in pricing. The system is being designed to support smart/quick decision making and corrective actions where required.
Responsibilities:
• Manage development team size of 20 resources at offshore for development and implementation of solution.
• Work with the business development and program management team, by effectively handling requirements elicitation and requirements analysis.
• Collaborated with key stakeholders and internal teams to understand requirements and design data model and solution in Oracle database using PL/SQL as programming language.
• Proposed generic user interface tool solution using Java Springs framework for data reporting out of Oracle tables aggregated at different levels.
• Business rules design and implementation for data validation which is one of the challenging parts of this project.
• Created a modeling tool that allows 100’s of users to model costing data by maintaining the user session and huge set of data specific to the session all through the modeling.
• Designed and implemented a generic user interface tool using Java springs framework for manually maintaining business configuration data.
• Participate in requirement elicitation process, architecture review sessions for the design/solution sign-off.
• Design and develop history maintenance and history data retrieval process for business object reporting.
• Monitoring / Tracking and co-ordinate the development activities at offshore.
• Lead the team during development, testing, deployment/implementation.--
Technology Lead / Delegate Project Manager 03/2013 - 03/2015
Infosys Limited, Chennai, Tamil Nadu India
Industry: Software Development
ADSIT Supply Chain Projects for Texas Instruments: This is a group of project/program executed from Infosys Chennai for Texas Instruments to support all system revamp, technological advance, automation, reporting, managed services support etc
Responsibilities:
• Manage development team size of 25 resources at offshore and facilitate the development activities for all projects executed for ADIT supply chain systems between March 2013 and March 2015.
• Manage project metrics and milestones with a goal/plan to achieve planned productivity improvement year on year.
• Apply statistical process control measures to monitor and control quality metrics.
• Achieve planned productivity improvement year on year by proposing and implementing tools and automation
• Manage project budgeting, timesheet, billing and invoicing, forecast revenue by carefully analyzing all future opportunities, demands.
• Resource management for the current project activities and demand forecasting for all future resource needs.
• Review and manage all risk identified from project metrics, resource issues, budget etc.
• Work on business case, solution proposal and project estimation/budget for all opportunities identified.
• Project Estimation for development and implementation and resource planning.
• Prepare detailed project schedule by carefully analyzing the effort, dependencies and resourcing.
• Monitoring / Tracking and co-ordinate the development activities at offshore.
• Lead the team during development, testing, deployment/implementation, transition.--
Technology Lead 08/2011 - 02/2013
Infosys Limited, Chennai, Tamil Nadu India
Industry: Software Development
ADS-IT Supply Chain - SVA Data Migration: This project is to set up an infrastructure for the purpose of archiving the history of data in order to improve the performance in the reporting.
Responsibilities:
• Designed the infrastructure data model to be used for the project.
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Designed and developed a ‘BDW Data Archival/Retrieval Process’ in Unix Shell scripts and Oracle data warehousing concepts which involves archiving/retrieving historical data to/from offline storage
• Written Unix Scripts and PL\SQL procedures and functions to implement the business rules
• Automated the testing using the DDLs and Procedures to test the loaders.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created Materialized Views and partitioning tables for performance reasons.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed procedures using Dynamic SQL.
• Interacted closely with Business Users to gather requirements and helped with the data modeling effort Some of the business benefits reaped out of this project
• Reduces storage cost - As the data gets archived over a defined period of time, it reduces the database storage and the maintenance cost to good extent.
• Improve application performance - Business data queries could be retrieved or processed faster, as only required/relevant data is present in production environment.--
Technology Lead 12/2011 - 08/2011
Infosys Limited, Chennai, Tamil Nadu India
Industry: Software Development
ADS-IT Supply Chain - SVA Data Migration: This project is to migrate the part numbers, contact details of National to TI. Supply chain systems, User profile registration process and contact data flow across departments/applications has been re-engineered to fit the national data without any impact to existing Texas instruments data.
Responsibilities:
• Written PL\SQL procedures and functions to implement the business rules
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Developed stored procedures to extract the data from different sources and load it into data warehouse
• Interacted closely with Business Users to gather requirements and help with the data modeling effort.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
• Written UNIX shell scripts to read the third party data files and loading into database
• Involved in monitoring the sql performance by the gradual increase of data load in the respective tables and modified the necessary sqls
• Responsible for Analyzing and Implementing the Change Requests.
Tools and Technologies: Oracle 10g PL\SQL, UNIX shell scripting, NFS mount, stored procs, functions, triggers, index, DDL scripts, Toad for Oracle, HPQC for defect tracking.--
Software Engineer 01/2011 - 12/2011
CSC, Chennai, Tamil Nadu India
Industry: Software Development
Forward Production Cost System: The Forward Product Cost System (FPCS) is an integrated tool for PD Finance analysts to track and report on the financial aspects of new model programs. It supports Tracking and reporting of variable cost, weight and investment costs for new model programs. It fully supports major Ford vehicle programs, minor Ford vehicle or power train programs, and PAG programs. It also helps Forecasting average profit across vehicle line, market, region, etc.
Responsibilities:
• Preparing Technical Design/specification document and managing development activity
• Development estimate and detailed task plan.
• Lead/guide all development, enhancement activities.
• Developed excel reports using VBA macros.
• Develop ETL process using Oracle PL/SQL.
• Written PL\SQL procedures and functions to implement the business rules
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Developed stored procedures to extract the data from different sources and load it TVMER database
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
• Responsible for analysis, estimation, coding, peer review , Unit testing , release request and to migrate the change to testing and production environment
• Coordinating second line support activities in resolving the production support issues.
• Responsible for Analyzing and Implementing all enhancements and change requests.
Tools and Technologies: VB, VBA macros, eDB framework, Excel 2003, Oracle PL/SQL, SQL developer for Oracle, HPQC for defect tracking.--
Software Engineer 06/2008 - 12/2011
CSC, Chennai, Tamil Nadu India
Industry: Software Development
Team Value Management & Effective reporting: The purpose of this project is to create different financial forecasting reports to present to the business team on the financial forecasts. This includes the details like Supplier commodity, Benchmarking details, Part details, financial forecast data etc.
Responsibilities:
• Interacted closely with Business Users to gather requirements and help with the data modeling and development effort.
• Development estimate and detailed task plan.
• Preparing Technical Design/specification document and managing development activity
• Lead/guide all development, enhancement activities.
• Developed excel reports using VBA macros.
• Develop ETL process using Oracle PL/SQL.
• Written PL\SQL procedures and functions to implement the business rules
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Developed stored procedures to extract the data from different sources and load it TVMER database
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
• Responsible for analysis, estimation, coding, peer review , Unit testing , release request and to migrate the change to testing and production environment
• Coordinating second line support activities in resolving the production support issues.
• Responsible for Analyzing and Implementing all enhancements and change requests.
Tools and Technologies: VB, VBA macros, eDB framework, Excel 2003, Oracle PL/SQL, SQL developer for Oracle, HPQC for defect tracking.--
Software Engineer 10/2005 - 06/2008
ISFOT, Chennai, Tamil Nadu India
Industry: Software Development
iPatient Manager:I Patient Manager is a product of iSOFT. Designed and developed for managing patient information and healthcare services. i.Patient Manager enables healthcare organisations to manage their patient, clinical, business and financial processes, overall making it easy to access patient information at the point of patient care.
Responsibilities:
• Involved in project Development using VB, VB.NET
• Preparing detailed documentation for the development activity
• Create test case and unit testing.
• Preparing user guide for the customer.
Tools and Technologies: VB, VB.NET, Oracle, Sql Server--
Noorul Islam College of Engineering 07/2001 - 03/2005
Thucklay, Tamil Nadu, India
Degree: Bachelor's Degree
Major:Computer Science
B.E. in Computer Science and Eng.
PMP,MBA,BE with 11+ yrs in IT PMP, Oracle PL/SQL, Unix, Shell Scripting, Java, VB.NET, VBA, C#