Jonathan Plata Email and Phone Number

 Talk with users about their needs and ask the right questions to surface essential requirements information, evaluate the information gathered from multiple sources and decompose high-level information into details, distinguish user requests from the underlying true needs and distinguish solution ideas from requirements. Projects manage the mission critical technical implementation of Infor Enwisen systems. Analyze scope and implement integration between Infor Enwisen systems and other client systems. Work with the client and other team members to resolve technical issues. Develop, design and manage installation and upgrade of Infor Enwisen systems. Scope system customizations’ and manage its delivery with Infor Enwisen developers Scope and perform data migration for client’s legacy data into Infor Enwisen systems. Provide ad-hoc Technical consultancy. Participate in documenting and improving team processes and documentation. Responsible for conducting analysis and development of the logic, processes, and scripts to acquire data from source systems to designated data tables in the database. Responsible in maintaining and resolving SSIS (SQL Server Integration services) issues. Provide guidance to a group of Technical Consultants. Work closely with colleagues to try and identify data-related problems and solve them.  Assure all programs are documented using standardized documentation procedures Provide project leadership on projects as assigned. Assume major responsibility for resolving problems in assigned systems. Provide high-level estimates as well as accurate detailed estimates Experience in Importing/Exporting Data from various datasources like Excel and Flat file using SSIS 2005 Designed Data Warehousing and Business Intelligence platform for MS SQL 2005. Developed database utilities and automated reporting using SSRS Analyzed, consolidated and tuned database for optimal efficiency

 Designed Data Warehousing and Business Intelligence platform for MS SQL 2005. Developed database utilities and automated reporting using SSRS Analyzed, consolidated and tuned database for optimal efficiency Created indexes as necessary for optimization Optimized slow-functioning MS SQL 2005 queries Installed and test upgrades and patches Evaluate and recommend new database technologies Ad-hoc data-mining for creation of custom reports in response to needs of business users Talk with users about their needs and ask the right questions to surface essential requirements information, evaluate the information gathered from multiple sources and decompose high-level information into details, distinguish user requests from the underlying true needs and distinguish solution ideas from requirements. Participate in project scope identification, data architecture development and project planning in coordination with other members of the data warehouse team. Create ETL program and mapping development using SSIS (specify, develop, test, deploy) utilizing a defined project methodology and internal standards. Develop data transformation processes, automating load processes and maintain and update acquisition and loading processes. Consult with Users, application areas and other technical support areas on Data migration/Data warehousing related topics. Develop and improve standards and procedures to support quality development, testing, production and operational oversight of the data warehouse processes. Develop and oversee monitoring systems and remedial processes to ensure data loads always occur on schedule and data is accurate. Define and capture metadata and business rules in coordination with other data warehouse team members to support the projects. Assure all programs are documented using standardized documentation procedures Provide project leadership on projects as assigned.

 Scopes and manages complex development projects utilizing sound planning, resource management and budgeting techniques. Communicate with stakeholders regarding improvement in operations performance; reduce cost particularly in acquisition, development, training and maintenance. Assumes accountability for the overall technical integrity of assigned product(s) including design effectiveness, performance management and programming efficiency. Increase overall quality by ensuring that documented requirements are fully understood and products and services are designed to meet those requirements. Likewise actively participates in the evolution and reengineering of the development processes. Provides timely and effective communication with the other functional organizations related to development plans, issues, changes, and so on and moves through the change cycle, and motivates and leads staff through the change cycle while maintaining a high level of productivity. Meets or exceeds internal and external customer expectations on functionality, timelines, and reliability; maintains high standards of ethics and performance; establishes and manages quality improvement processes towards project goals. Gather requirements and design of datawarehouse and data mart entities using SQL Server 2000 Analysis Services. Plan, Create, Maintain and Support Merck’s Datawarehousing/Business Intelligence Management System in Sales Operation and Marketing Research for gathering, storing, analyzing and providing access to data to help enterprise users make better business decisions

 Legal and Commercial (L&C)- Ccure is Accenture badging solution that provides a high performance, cost-effective identification management system. Leads and supervises the team. Serve as main point of contact. Application performance management Drive and support the business initiative in Manila for auto importing of personnel in CCure. Conduct project status meeting and create meeting minutes. Establish and maintain relations with various personalities, including development team, network team, end-users and vendors. Assist to improve processes and contribute to technical team activities in design, testing and documentation. Review Technical Design of the Interface Data feed for Ccure using Sql Server Integration Services (SSIS) 2005. Work with users to analyze current business processes and procedures to help identify gaps and areas for process improvement.  Reach out with the network team pertaining to network connectivity and security solutions. Conduct project post mortems to improve the efficiency of future projects. Coordinate and monitor troubleshooting to isolate and diagnose common system problems. Document system events to ensure continuous functioning. Recommend course of action and implement as approved. Utilize standard corporate tools like Clear Quest to record scope changes, service requests, issues, risks and defects for tracking purposes. Intellectual Property and Asset Management System (IPAMS) - is the central repository for information on offerings and assets used by Accenture client teams to sell and deliver work to their clients • Create the following Reports using Sql Server Reporting Services (SSRS) 2005o Product by Country-Location Report - Country-Location is a combination of the country and a specific city or site (Accenture, Client) out of which a product is delivered.

 Distributor Customer Management System (DCMS) • Used Visual Basic 6.0 as Front End Microsoft Sql 2000 as Back End and Seagate Crystal Report 8.5 as a Reporting tool.• Developed and maintained said system to support the ordering of ULP’S Distributors Customers using Solomon IV. Added additional code to enable integration to handheld devices.• Extract Data from Solomon IV like Customer Masterfile,Inventory Items,Deliveries and Inventory/items• Project analysis and design, including creation of Input Process Output and database design. • Redesigned and created the user interface of the project• Created technical and user manual. Order Plan Guide System (OPGS) • Used Visual Basic 6.0 as Front End and Microsoft Sql 2000 as Back End and Seagate Crystal Report 8.5 as a Reporting tool.• Developed and maintained said system to support the ordering and auto-replishment requirements of ULP’S Distributors using Solomon IV.• Extract Data from Solomon IV system like ,Active Inventory Items Sales History, Main/Van Ending Inventory, Pended Orders, Customer Pended Orders • Project analysis and design, including creation of Input Process Output and database design. • Redesigned and created the user interface of the project• Created technical and user manual.