SUMMARY

• Twelve years experience in ERP development and management, SAP implementation, project management, system analysis, data analysis, software development and web development.
• Experience in SAP MM module with full life - cycle implementation.
• Four years experience in leading software development team of eleven for development of ERP system that integrates procurement, production, distribution, sales, service, accounting and Human Resource.
• In-depth understanding of project lifecycle, including all phases of system and software development.
• Clear understanding of financial data and accounting impacts of all transactions.
• Strong background working with business personnel and programmers to convert requirements into business design, provide cost analysis, and develop implementation timelines.
• Sound experience in database design and development with SQL Server 2000, 2005, 2008.
• Experience in ETL using SSIS, and in C# scripting in SSIS.
• Significant experience in software design and development using asp.net and c#.
• Profound experience in understanding report requirements and develop reports using BO and Crystal Reports.
• Superior analytical, mathematical, planning and problem solving skills.
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

ERP System: SAP R/3 ECC 6.0

Programming Languages: C, C++, C#, ASP.NET, Java, Java Script, AJAX, Visual Basic, Basic, COBOL, HTML, UML, Power Builder, Crystal Reports.

Database Applications: Oracle, MS SQL, Sybase, Access, SSIS, TOAD.

Operating Systems: Windows Server 2003/2008, Windows XP/7, DOS, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead/Business Analyst/ System Analyst

Responsibilities:

• Worked with SAP implementation partner PricewaterhouseCoopers (PWC) on MM module during implementation life-cycle: blueprinting, configuration, realization, testing (Unit testing, User acceptance testing, and Integration testing), final preparation, training, documentation, data uploading, go live and post go live (production) support.
• Worked as MM module owner of the organization after go live of SAP.
• Worked on MM integration with PP, SD and FICO.
• Worked with business personnel in Production and Sales to prepare functional requirement of PP, SD, FICO and CRM modules of SAP.
• Helped project manager to manage the SAP implementation project successfully.
• Worked as project manager for two months while the project manager was on leave.
• Planed, organized, directed, controlled and evaluated the operations of in-house built ERP (which covered procurement, production, sales and distribution, and accounts) and other information systems.
• Developed and implemented policies and procedures for MIS systems’ operation.
• Hired, managed and developed information systems’ personnel and contractors to design, develop, implement, operate and administer computer software and information systems.
• Communicated with stake holders, captured business logic, designed and monitored project phases.
• As manager and technical lead of the development team, designed and led the development and maintenance of the ERP system, which used SQL server in the back end; C# and ASP.NET on the front end; and Crystal Reports for reporting in agile method.
• Led the team for in-house built ERP system testing (automated Unit testing, User acceptance testing and Integration testing).
• Designed, developed and maintained database, and wrote complicated SP, trigger and function.
• Developed web application in MVC framework.
• Solved issues in development of the ERP system raised by the technical team or the business personnel.
• Analyzed procurement, production, sales and financial data for accuracy and reporting purposes.
• Developed and maintained plan for data security and integrity.
• Maintained and trouble shoot data server for its uninterrupted operation.
• Reported to the Director of the company about the IT department’s goals and achievements.

Confidential

System Analyst/Data analyst

Responsibilities:

• Gathered, analyzed, validated and documented business requirements. Developed new requirements document format that included tracking of business requirements from Business, user, functional, non functional requirements.
• Constructed System Context Diagrams, Data Flow Diagrams, Entity Relationship Diagrams, Process Sheets, and State Transition Diagrams.
• Analyzed existing system and new requirements for Gap analysis.
• Compiled and incorporated user feedback into the new system.
• Designed, maintained and modified data base according to system requirements.
• Determined and managed the data migration procedure from legacy system to new developed system.
• Developed complex SQL queries extensively to create ad-hoc reports for the data analysis and testing purpose.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Used data analysis techniques to validate business rules and identify low quality data in the existing enterprise data warehouse (EDW).
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Developed reports according to various departments’ requirements.

Confidential

System Specialist III (Team lead)/Business Analyst

Responsibilities:

• Managed a team of eleven employees as the team lead.
• Created project plans, business requirement documents, and actively collaborate with the business personnel to ensure alignment to the goals and the success of projects.
• Performed mortgage process analysis of customer activities seeking to understand their needs and provided system solutions that benefited both the customer and the company
• Performed Gap analysis by analyzing existing system, customer requirements and legal requirements.
• Defined the Feasibility and Risk Matrix for technology support in developing the system.
• Played a major role in finalization of User Interface Design through iterative approach.
• Analyzed complex database table structures to resolve user issues and report design.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Designed data marts that were used as the source for analytic reporting.
• Developed System Requirement Specification (SRS), Use cases, System Requirement Change Requests, and Data Dictionary along with the technical staff and developers.
• Managed team’s workflow as the company required.
• Developed timelines for project delivery, and managed projects and resources.
• Maintained liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
• Supervised hiring and training of new employees.

Confidential

Data Analyst/System Analyst

Responsibilities:

• Designed, developed, and maintained database that stored data from the electronic tests of Fiber Channel and Optical Technology based Storage Area Network (SAN) products as they are manufactured.
• Worked in the test group of SN6000 which is a switch of SAN based storage system that managed enormous amount of data storage in the most efficient manner.
• Conducted data warehouse requirement-gathering sessions with users from Hardware testing group.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Object Oriented Design Diagrams.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Designed and developed data collection interfaces using Power Builder that interacted with test script written with Visual Basic, C and C++.
• Analyzed test scripts written in Visual Basic, C and C++ to build seamless path of data from different platforms to automate data transfer.
• Developed supportive source to target data mapping and data transformation rules.
• Created reporting applications that generated and posted reports on the intranet for management using Power Builder, Java script and Java applet.
• Planned and executed data migration from legacy system to newly developed system.
• Assisted in developing manufacturing test processes from board-level diagnostics to system-level tests.
• Developed training manual for the end users to teach the new software system designed by my group.
• Developed timelines for project delivery, and managed projects and resources for successful completion.
• Maintained all project documentations.

Confidential

Computer Lab Assistant

Responsibilities:

• Provided student, faculty, and staff with assistance regarding software and operating systems.
• Supported hardware, performed memory upgrades, assisted users with Mail, and Turbo on Sun OS.
• Performed troubleshooting of hardware.