INFORMATION TECHNOLOGY PROFESSIONAL

• I am a Bi-lingual English- Spanish senior level information technology professional with history of achieving cost savings and enhancing system functionality. I have a track record of tackling and solving tough business and technical problems. I am a strong leader with demonstrated ability to work effectively with individuals at all levels and in all functional areas. I have extensive experience in managing full project lifecycle from requirements gathering to final implementation users and customer training.
• Experience interfacing with key business units including logistics, E-commerce, marketing, finance, sales, human resources, manufacturing and engineering in multi-cultural global areas. I am an excellent communicator, with emphasis on building strong client relations, capable of making professional presentations. I am a quick learner that rapidly adapts to emerging technologies. Over ten years of experience with the following technologies: .NET, VB, VBA, MS SQL Server, PHP/MySql, Mongo DB, MS Access applications developer with experience in full system development life cycle, including Business Analyst, System Analyst, Data Analyst, Data warehousing, DBA, Business Intelligence, Database Design Engineering, Web Development, ERP, CRM, SCM Dynamics GP, AX, SL system configuration and implementation. Infrastructure management and hardware/software upgrades.

Technical Proficiencies:

• Over 15 years of experience in negotiating purchases of IT hardware/software/services and managing the Implementation of systems infrastructure upgrades, network upgrade/implementation and software development Agile/waterfall methods
• Over 10 years of experience in systems analysis, business analysis, data analysis in various industries.
• XML, HTML, DHTML, JavaScript, CSS, Crystal Reports, Dynamics GP Reporting Tools,
• SQL Reporting Services.

• Experience with design, development, and coding of business/commercial applications using C ,
• ASP.Net, VB.Net, Visual Studio.Net, Visual Basic and .NET Framework, web services using XML.

• Experience with creating and customizing Client/Server and Web based applications using .Net,ASP.Net, C , VB.Net, ADO.Net, PHP.

• Experience installing/Configuring: Windows Server 200-2008, SQL server 200-2008, MS Exchange 2000-2010, Windows XP, Windows 7 Professional, Ms Office 97-2010

• Experience installing/upgrading Auto CAD Electrical/Mechanical , Solid-Works, Micro Station

• Strong experience with Database Design and Database Programming Stored procedures, Triggers
• SQL Server 2000/2005/2008, MySql and over 7 years of experience developing MS Access apps.
• Networking:TCP/IP, Wireless 802.11 a/b/g, DNS, WINS, DHCP, SAN management, VMWare, Sysco switches/routers, SharePoint server. Project Management Tools:
• MS Project 2007-2010 , Goto Meeting, Skype

RELEVANT EXPERIENCE

Confidential

Business Data Analyst / Big Data Analytics/.NET Developer

• Data Analysis for Early Alert Process
• Confidential established an Office of Student Success in July 2012 to provide more integrated academic support services. Under the leadership of an Assistant Dean for Student Success, the Office staff members include professional academic advisors, the Disability Services Coordinator, the First Year Programs Coordinator, and Academic Resource Center staff. The Assistant Dean, who reports to the Associate Vice President for Academic Affairs, monitors the overall early alert process.
• Student Success staff members use data from the Admission Office to identify possible at-risk students before the start of their first semester based on pre-college characteristics associated with an increased likelihood of academic challenge. Tracking high school GPA, ACT and SAT test scores, financial need and minority status allows administrators to anticipate service needs. Support services are highlighted during Orientation and Registration activities. Placement into appropriate courses is done with the guidance of academic departments, with special attention to English and Mathematics courses.
• Primary role and responsibilities was to analyze multiple business applications and data sources used by multiple departments within the university.
• Create a data warehouse, data marts and cubes within MS SQL 2012 to auto ETL all require data for further automated analysis.

Project Phases

• Phase IV: Track outcomes to answer how effectively the system identified students at risk, and how effective the interventions were. Acquire and integrate additional data sources, revise the statistical model to improve accuracy and identify students at risk more quickly.
• Phase III: Use the model to connect students with support resources to enhance academic success. Devise methods to track use of resources integrate with Tutor Trac .
• Phase II: Connect the database to Excel to enable advanced data modeling to identify students at risk. Create a data cube/ power pivot. Export data for use with SPSS or other statistical tools to build a predictive model.
• Purpose: Employ Big Data concepts to automatically collect and analyze available data to quickly identify students at risk for intervention. Phase I: Build interfaces to move Colleague and other data as identified into a database.
• Confidential Managed the complete back-end MYSQL data migration of approximately four million subscribers and related data between a custom built legacy system to Cloud-base Sales Force environment
• Responsible for researching and implementing an integration solution between MS SQL 2012 and Cloud-based Sales Force applications for real-time replication, synchronization, reporting and single or bulk record manipulation.
• Reachout Wireless business revolves around strict and regulated government rules and regulation that applies to customer enrollment eligibility, annual verification process and high level of data integrity. In order to meet or exceed business regulation, among other one of my main responsibility is to:
• Analyze current business processes and practices utilize to determine customer eligibility enrollment to phone activation and shipping process.
• Architect, designed and implemented a custom .NET web-based application to identify sounds-like accounts, potential fraud, enrollment duplication, incomplete or invalid data.
• Architect, designed and implement multiple MS SQL SSIS data packages and store procedures to identify and report incomplete documentation and possible same household applicant.
• Architect, designed and implement a custom VBA application to push orders from Sales Force to Microsoft Great Plains Dynamics SOP, RO and IV tables.
• Architect, designed and implemented a custom HPH/MySql E-commerce web retail store.

Other duties and responsibilities

• Manage updates and execution of various API PHP scripts use for communication and XML responses between Verizon and other telecom companies.
• Implemented a series of data marts and data warehouses utilizing MS SQL and Mongo DB to store approximately one billion call detail records
• Confidential Corporate Information Technology Manager / IT Project Manager Direct Reports:1 Project Manager Roanoke, VA , 2 Systems administrators Roanoke, VA , 1 Systems administrator Pocatello, ID , 2 Systems administrators Chihuahua, Mexico , 12 Programmers Mexico/India
• Primary role was to manage the companies' IT infrastructure, network, manage resources, enforce corporate policies across the enterprise and the design, testing, implementation and training of various applications that connected to the companies' green screen legacy system, Auto CAD and Solid-Works. The new systems gave the company a centralized application that eliminated redundant business processes increasing productivity, reduce operating cost and provide stakeholders and upper management intelligent reporting for business feasibility. The system also improved the BOM creation and manufacturing components order process reducing the on-hand inventory.
• I served as the main point of contact on all IT-related projects for all departments Business office, sales, HR, engineering, manufacturing, shipping . Reviewed and documented business processes also wrote system business requirements, software/systems technical requirements and test cases. I meet regularly with stakeholders to ensure that IT understands, meet or exceed the companies' goals. I was able to reduce the companies' IT operating budget by 20 without affecting business needs or customer satisfaction. All projects, resources, milestones were track with MS project 2007. MS Visio 2007 was used to create architecture diagrams and flowcharts. I responded/acted positively to upper-management direction, communicated effectively with department managers to identify needs and evaluate alternative business solutions continually sought opportunities to increase productivity and deepen client relationships. I resolved or escalated issues in a timely fashion. I managed the IT strategic plan/budget. I negotiated/approve IT related vendors used by the organization. I negotiated and managed the purchase, implementation of various IT related hardware/software/services including the upgrade of the telephone system to include IP phone deployment. I managed the IT budget creation and the overall IT staff performance and attendance. I coordinated priorities between stake- holders, IT department and users to align business needs with technology solutions.
• Confidential Primary responsibility is to oversee the streamlined operation of the IT department and to ensure it aligns with the business objectives of the organization.
• Develop and manage application portfolios for each department and to attain all IT service level agreements for the user community within the organization. I managed the implementation and training of Dynamics CRM. I managed the implementation and training of a SharePoint Server. Upgraded MS Exchange from 2003 to 2007.
• Planed, coordinate, direct, and design all policies and operational activities of the IT department, as well as provide direction and support for IT solutions that enhance mission-critical business operations. I worked closely with decision makers in other departments to identify, recommend, develop, implement, and support cost-effective technology solutions for all aspects of the organization. Other duties included managing the infrastructure, providing helpdesk support, ordering and installing equipment, software, database application development and ensuring the company meets the various compliance guidelines for confidentiality and information security.
• Confidential Managed the information technology department in accordance with corporate policies and goals. Ensured proper functioning of the organization's information systems and make upgrades as necessary. Helped business operations utilize information systems to improve efficiency. Kept computer equipment, hardware, and software updated to meet corporate policy and organizational needs. Evaluated, designed, implemented and maintain various database s . Constructed data decomposition diagrams data flow diagrams and documented business processes. Reviewed, analyze and evaluated business systems to meet user needs.

Confidential

Division Business Project Manager / Systems Analyst / Programmer Analyst / BI development / Web Master

• I Managed the migration of a large filePro database to MS Access 2003 utilizing tables, queries, forms, reports, macros, modules, and VBA. Troubleshoot and maintain existing MS Access databases for Telemarketing Dept. Troubleshoot and diagnose UNIX, filePro, PC, and MS Windows XP related problems for in-house staff
• Designed and implemented new applications/Databases that connected to the companies ERP legacy green screen system that eliminated redundant business processes and increased productivity given the enterprise faster data entry / data retrieval and reliable and accurate reports giving stakeholders and upper management business feasibility.
• All Interfaces were created with customizable graphical user interface that resembles the companies' legacy system using .NET, SQL server 2000 and MS Access 2003, which minimizes employees training time. Implemented training course for new software. Managed the implementation of Microsoft Dynamics SL

Confidential

Project Manager / Systems Analyst / Programmer Analyst / BI development

• I managed the continuing developing of a comprehensive web-based system that integrates Retail Point of Sale, Sales and Inventory Control, Merchandise Management, Customer Marketing, Accounts Receivable, Accounts Payable, General Ledger and Financial Reporting for specialty retailers to maximize competitive advantages.
• Managed the installation, training and implementation of MS Dynamics GP HR/Financial, CRM Dynamics 3.0
• Confidential Systems Analyst / Data Base Analyst / OLAP / ETL Analyst / Product Lifecycle Management PLM / Product Data Management
• Managed the development of the Universal Syndications Inc, PatenHealth and Universal Media divisions in-house business Applications utilizing SDLC/Agile methods using Visual Basic 6.0, SQL Server 2003, MSDE 2003, and Crystal Reports as development environments.
• Managed the infrastructure and software upgrade to improve technology in order to increase, quality, efficiency, and improve client service. Managed the upgrade, migration from SQL 2000 to SQL server 2005. Work with a team of Programmer to design implement support systems, interfaces, and reporting.

Confidential

Project Manager / Business analyst / Systems Analyst

• Contract Consultant - OLAP Analysis Services - SQL Server Holmes Biznet. Berlin, Ohio
• Managed the creation of various Data warehouses used by the Information Systems department of the Literature
• and Small Package Fulfillment Division of a leading provider of outsourced operations to develop an OLAP
• prototype of key performance indicators. The prototype was developed using Microsoft Access,
• Analysis Services 2005 and SQL Server 2005.
• Confidential Managed the integration/training of Dynamics GP/CRM to an independent medical billing company Private physicians to improve efficiency and productivity allowing them to spend more time focusing on customer service and collections and less time gathering/querying/distributing data.
• Confidential Managed the development of applications for Akron based visual in-pared assistance organization to assist visual challenge working professionals. Development environment: Ms Access, Visual Basic, Jaws for Windows internal software speech synthesizer . SDLC/Agile methods using .NET, SQL Server 2005, MSDE 2005, and Crystal Reports as development environments were utilized.

Confidential

• Managed the Development, implementation Visual Basic, SQL Server application Primary function to track customers in-bound inquiries, sales, renewals, service installations, cancellations, associates commission, associates bonus system, reporting, statistical dada and reporting including graphical charts. Managed internal customer relationships by engineering and administering a suite of mini-functional data warehouses, and Data Marts to produce strategic BI necessary to achieve planned business objectives.
• Created e-CRM data mart to manage customer prospects, arming management with market intelligence distilled from customer and market data mined from Dun Bradstreet's Market Spectrum , including market penetration and customer opportunity analysis by summarized by demographic with drill-down analysis enabled, thereby driving annual sales growth of 20

Confidential

Project Manager / Systems administrator / Software engineer / Database Developer / OLAP - RDB Developer

• Managed and analyzed existing applications to find more efficient methods to enhance day-to-day operations and to more quickly and efficiently collect and transmit information thus eliminating redundancy there for lowering labor and increasing productivity.
• Developed applications to link to existing credit grantor App. providing a complete solution for the receivables module. CBO/RBO Reports Included enabling the company to recognize/reduced delinquencies and increased recoveries.
• Designed, tested and implemented new applications/Databases that eliminated redundant data entry / data retrieval within all departments of the company. AP / AR / HR / MBA Mitek business Application all Interfaces were created with Visual Basic, PHP, HTML customizable graphical user interface, which minimizes employees training time. Implemented training course for new software speeding productivity. On-site and on-The field implementations and training of new applications. Managed the integration of Dynamics AG Manufacturing/HR/Finance to custom applications.
• Created an intranet web-site to document existing systems. Then created Extraction-Translation and Loading from Great Plains Dynamics / Peoplesoft Oracle servers to a Windows 2000 Advanced Server using ETL/DTS. Added an audit trail to data cleansing operations. Created separate databases for each fiscal years data. Created separate MS Analysis Services OLAP partitions for each fiscal years data. Loaded each database to the corresponding partition. Corrected errors in the SQL and OLAP calculations. Created ranking and comparison reports using Crystal Reports 9 and 10.
• Other duties included: Day-to-day technical support hardware and software, data analysis importing and exporting , report writing, and network administration 123 user LAN National T1 intranet Day to day trouble shooting of systems both hardware and software and networking related issues.