SUMMARY

• Polished technology professional with more than 13 years' experience working on complex, high - profile projects in roles such as a project manager, business systems analyst, database developer, systems administrator, programmer, and training instructor in corporate,
• Familiarity with FERPA, HIPPA, PCI, IDEA, and SOX compliances and practices, supporting supply chain, general ledger, treasury, financial accounting, payroll, and learning management systems within medium to large matrix organizations, as well as local government.
• More than 10 years supporting databases: Informix (SUSE Linux and AIX), Oracle, SQL Server, DB2, etc.
• Served as Project Lead of Electronic Medical Records, mobile applications, web development, payment­processing, billing, and SaaS (Software as a Service) implementations, just to name a few.
• Hands-on experience with data migration, system integration and new implementation projects using Agile, Scrum and Waterfall methodologies and the systems development life cycle practices.
• Experienced in leading project from end-to-end, managing with confidence kick-off meetings, and providing status updates on key milestones within a Salesforce or SharePoint environment.
• Able to effectively author and manage project plan, project schedule, risk management plan, communication management plan, release schedule or change management requests, while managing off-shore project staff, developers, project managers, and other technical staff.
• Proficient in several BI tools such as Microsoft SSRS/SSIS, Cognos, Crystal Reports, and Sybase InfoMaker.
• Able to identify key deliverables from inception of project and utilizing Sales notes and discussions to develop business requirements in order to meet customer expectations and projects goals.
• Experienced in gathering detailed project requirements, preparing business requirements documents, writing functional specification documents, translating requirements into technical specifications, updating Project Charter, developing Statement of Work for enhancements, etc.
• Proven ability to assess detailed analysis to create business processes that will allow successful completion of UAT testing,
• Able to create and communicate project plan, prioritize and identify project risks, and define requirements in order to prevent occurrence of defects and unnecessary delays.

TECHNICAL SKILLS

• Oracle SQL Developer (Query Builder
• PL/SQL)
• PuTTygen
• Notepad++
• Snipping Tool
• Cognos 8/10 (Administrator
• Analysis Studio
• Report Studio and Query Studio)
• Cognos Impromptu
• SQL Server Data Tools; SSRS Reporting Services (Management Studio 2005/2008/2008 r2 and Business Intelligence Development Studio)
• Crystal Reports
• VB6
• VB.NET
• XML
• Cascading Style Sheets (CSS)
• HTML
• PHP
• JCL (Job Control Language)
• SAS Enterprise Miner
• Bluespring
• MySQL phpMyAdmin
• SQL (Informix
• Access)
• Unix (KSH) Scripting
• Oracle Warehouse Builder (ETL Development)
• Business Objects
• VBA for Excel (Macros)
• COBOL (IBM
• MVS
• VAX)
• CICS Control/Apps
• Serena PPM Mariner (SQL)
• Lawson Payroll
• Peoplesoft
• Satori (VB)
• Jenzabar CX 8.1 ERP jQuery
• JavaScript
• PERL
• C++
• C#
• CARS Quickmate
• Adobe Creative Suite (CS4) Design Standard
• Fireworks
• Adobe InDesign
• Adobe Photoshop
• Adobe Flash
• Adobe Dreamweaver
• Aqua Data Studio
• TicketOs
• Informatica Analyst 10.0
• Microsoft Project 2010/2013

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

DATA INTEGRITY CONSULTANT

Responsibilities:

• Recommend changes to improve processes of respective business units.
• Deliver ongoing support of Line of Business (LOB) facing self-service analytics to infrastructure to support the efforts to maintain the data in the CRM.
• Partner with the LOB data stewards to conduct ongoing CRM data profiling to ensure that data integrations are done successfully.
• Using Microsoft SQL Server Management Studio stack, write, modify and run queries to extract certain data criteria into MS Access tables, .csv, or Microsoft Excel for further analysis of data mappings.
• Serve as Subject-matter Expert (SME) of data validation rules for CRMs that feed into the Wholesale LOBs, researching legal entity business ownership and subsidiaries as needed when handling confidential and Material Nonpublic Information in the Wholesale department.
• Automate manual processes in Microsoft Access and MS Excel, using VBA script, macros, and complex functions to load .csv and flat files that are required for reporting and further analysis by the LOBs.
• Working with big data sets, deliver statistical reports from the quantitative data analysis to LOBs, assuring they were clear on the issues impacting the integrity and quality of their data.
• When sharing data across the LOBs, assure that certain CRMs are restricted to receiving information on a "Need to Know" basis.
• Ensure business requirements are documented with the appropriate level of detail and design meets the intended need.
• Partner with Technology Team to deliver initial solution.
• Assisted with defining a repeatable process for data quality work with marketing materials, which was used to clean up data for many lines of business, specifically built into an Informatica environment which allows a quicker, more easily repeatable process and included the metrics solution.
• Effectively communicate and report risks and penalties associated with violating laws prohibiting anti­competitive behavior.

Confidential, Charlotte NC

IMPLEMENTATION PROJECT MANAGER

Responsibilities:

• Provide an end-to-end project lifecycle experience to more than 26 client implementations, as well as 10 mobile application developments, making certain that from the initiating to close processes that the client is informed and completely aware of the project risks, testing, and budget needs.
• Lead and coordinate all initial kick-off meetings with clients, which included gathering technical specifications and implementation project requirements that were specific to the respective project.
• Update Opportunities in Salesforce with correct contact information to ensure details needed for demos being developed for sales staff were valid.
• Provide weekly status reports to Director as part of the efforts to communicate any resource needs.
• Within the Salesforce CRM, modify project milestones statuses, upload deliverables received, communicate risks, concerns, and progress related to assigned implementations.
• Work collaboratively with Sales and Account Managers to assist with Request for Proposals (RFP) and define business requirements that will be needed for Implementation or product development.
• Interact and collaborate with technical resources, as well as Operations and Development teams in order to make certain project requirements were documented, deliverables were received, and testing of newly developed technologies and mobile applications were conducted by assigned clients.
• Attend sprint meetings with the Development Team, as part of the efforts of communicating concerns and following up on development status for upcoming software and development releases for other Project Managers within the Implementation Team.
• Use necessary Quality Assurance practices to measure performances of UAT Configuration, Custom Phrases, Vendor API, and Connectivity to the CIS Database and Notification Database. This also included working with conversion billers to ensure they had correct IP Addresses in order to verify production connectivity and verify payments and notifications were successful prior to scheduled Go-Live of Interactive Voice Response system.
• Complete UAT testing for all assigned implementations and signoff for Implementation Team as needed, prior to submitting web portal URLs and VOIP telephone numbers to Project Managers.
• Assure that all file specifications, sample .csv and .txt flat files, and public keys received from client met company standards in order to minimize risks and prevent delays of implementation project rollout.
• Manage at least 26-30 client implementations simultaneously for web-based, utility bill payment projects.
• Implement and configure web-based applications, using SQL and UNIX KSH scripting, for assigned clients and ensure development specifications from SOW or Master Services Agreement are included once implementation of UAT is completed.
• Using Oracle SQL Developer, write PL/SQL stored procedures and scripts for assigned implementations in UAT, which included customizing web portal field labels and names, creation of customer portal e-bills, mobile application dashboard, and respective payment systems, as needed to support and assist my colleagues on my team.

Confidential, Charlotte NC

CRM PROGRAM MANAGER

Responsibilities:

• Communicate technology delivery risks and concerns that are relative to data migration, service request requirements, and new technology implementation for the city's non­emergency response citizen relationship management system.
• Offer guidance and support to project managers to make certain that the Project Charter and Project Scope align with the budget throughout the Project Management Lifecycle.
• Using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services as part of several predictive analysis exercises, developed SQL scripts, business processes and strategic planning reports to be used by management for measuring the effectiveness of a given task used when filling citizen service requests.
• Troubleshoot and test new releases related to screen resolution issues within the 311 call-center software, which was needed to assist those employees with sight disabilities, communicating risks.
• Served as the SharePoint Admin for the 311 Call Center Project Team, managing rights for groups when certain deliverables were to be made available on a "Need-to-Know" basis, utilizing version control.
• Attend and facilitate meetings with required resources who are responsible for coding, development, or completing deliverables for all projects/tasks assigned.
• Analyze big data for call center and service requests statistics in order to determine frequency counts and data reported is reliable and being utilized across multiple departments accurately.
• Communicate with project team about deadlines, assuring that the project stays on track for deployment.
• Prioritize each software delivery effort based on the business needs.
• Effectively set agile estimations that were using a relative over absolute style, comparing the amount of effort to others already in queue.
• Assess and communicate all risks associated with potential delays in assignments that were tasked to various resources across multiple departments within the city and county administrative government and technology areas, escalating to senior-level management and sponsors when necessary.
• Manage offshore and local vendor communication channels for the Confidential and third parties for all projects assigned, making certain that the project managers and business analysts are communicating regularly and effectively during meetings and via electronic mail sources.

Confidential, Charlotte NC

APPLICATIONS DEVELOPER

Responsibilities:

• Conduct extensive data analysis of customer service call center and technical services operations, measuring data quality and developing key performance indicators. Additionally, developed queries and scripts using SQL and Transact-SQL (T-SQL) to manipulate, aggregate, and extract data for loading in SSRS Reporting Services or Crystal Reports to be analyzed further in dashboards and cubes.
• Developed and deployed Crystal Reports applications on 32-bit and 62-bit HP or Dell laptops, troubleshooting as needed.
• Deliver data visualization statistical reports using such tools as Microsoft Excel, Crystal Reports and SQL Server Reporting Services, as part of efforts to present useful information about a client's operational and internal performance outcomes that needed to be improved.
• Attend Sprints as part of the Scrum method of Project Management Life Cycle to summarize work that was completed.
• Using T-SQL and ETL tools, developed fact tables from daily loads imported into the enterprise data warehouse, as part of the efforts to report on security events and customer service call center logs handled by agents and technical support staff.
• Support ASP.NET coding changes of the online client web portal, as well as Dev and Prod environments.
• Write functions and queries in MS SQL Server using VOIP/DNS, general ledger, and workforce management data to identify duplicate back-door and glass breaking occurrences and security events for Family Dollar, Dollar General, Citi Trends and GameStop stores that were logged erroneously by the call center agent at the time of call resolution.
• Wrote scripts and stored procedures in SQL and T-SQL to load bulk data daily for analysis by the executive team, which included, but not limited to creating, inserting, and truncating tables as needed.
• Using SSRS, successfully automated and recreated several MS Excel Spreadsheets that contained complex/advance formulas for the CEO and COO, in order to help the executive team better utilize their time and better manage their KPI's (Key Performance Indicators), saving costs in Technical Services, Installations and Operations.

Confidential, Charlotte, NC

PROGRAMMER ANALYST

Responsibilities:

• Develop reports for university staff based on targeted performance measurements and student ratios, using Microsoft SSRS and BIDS, ReportBuilder 3.0 and/or Sybase InfoMaker as tools.
• Assure college LMS remained in compliance to IDEA 504 law, within the technologies designed for users.
• Perform routine database maintenance, including system updates and patches, as necessary to support the Jenzabar EX ERP application; merge all duplicate student and staff records as needed.
• Modify modules as needed and required for support of various departments.
• Write new and modify existing stored procedures and job processes on the Microsoft SQL Server database, updating table structures and schematic designs when necessary.
• Maintain documentation of all functional specifications required for scheduled or implemented changes to existing scripts.

Confidential, Crestview Hills KY

SYSTEMS ANALYST PROGRAMMER

Responsibilities:

• Provide IT support in academia of the Jenzabar CX (aka CARS) system that is used by all departments within the college, possessing the primary responsibility to enhance and design ACE reports and new GUI implementations, assuring that development took into account ADA and IDEA compliances
• Served as primary support for Institutional Advancement department, assisting with grant funding and annual donations modular functions with the Jenzabar CX software system.
• Perform daily data cleanup, removing duplicate school, academic, or relationship records, by writing scripts to extract data and delete as necessary using SQL queries; Writing and enhancing reports using ACE, Cognos 10, and Aqua Data Studio.
• Monitor nightly jobs and system activity through the alerts that are received via email on a daily basis, analyzing informers and communicating with team and users as necessary.
• Using TicketOs system to track internal help desk related matters, respond to user requests for program/data support, password resets, printer spooler issues, new report developments, application screen changes, and government reporting data extractions.
• Develop IPEDS reports, modifying existing SQL queries in Aqua Data Studio, as part of supporting Financial Aid and Business Office with their financial and statistical data governmental reporting needs.
• Under the Agile Methodology, design and support screen changes for Admissions, Registrar, Institutional Advancement and Financial Aid modules as needed, conducting required testing and communicating statuses to departmental sponsors.
• Interact with software vendors when new product is being considered for review or existing software solutions are being reviewed for contractual extension; participate in Webinar presentations, as required for reviewing new software releases and updates.

Confidential, Cincinnati OH

PROGRAMMER/ANALYST

Responsibilities:

• Provide project management and IT support of the Corporate Business Systems thatwere owned by the Accounting, Payroll, and Mail Center business units.
• Following Waterfall Methodology, handled big data feeds and wrote scripts that would such scrub and migrate data to be stored or extracted from one system and then utilized in another.
• Wrote and prepared Business Requirements Documents, Functional Specifications Documents and Technical Requirements Document for all new group life and dental insurance products scheduled for the projects owned.
• Served as primary contact and project manager over the Treasury, Actuary, Mailroom, Accounting and Miscellaneous Disbursements Departments for the Corporate Business area of the organization.
• Served as the business systems analyst and systems administrator of all Corporate Business Systems; actively involved in VB.NET, C++, COBOL and JCL coding changes related to new insurance products, relying on IT knowledge to develop and deploy all changes to production by deadline.
• Served as secondary support for General Ledger, Lawson and Peoplesoft applications during data conversion projects.
• Using JCL and COBOL, support batch afternoon and nightly cycles for the Miscellaneous Disbursements Accounting System that was used to ftp checks via the online mainframe environment for all corporate- produced checks.
• Using the Agile Methodology, developed a database for Treasury Department to manage company assets.
• Coordinated all systems upgrade testing with the business unit in order to assure that production links and functionality for the online mainframe system was successful after update was implemented by the Operations team.
• Supported mainframe jobs and feeds to Bridger application - used to prevent money laundering.

Confidential, Cincinnati OH

SENIOR IT CONSULTANT

Responsibilities:

• Project Lead for a clinical psychology, Electronic Medical Record (EMR) system used to track and market genetic profiles medications, using the Agile Methodology
• Key IT Consultant for Psychological Application Development project, which required maintaining an updated version of the Project Charter, ongoing Project Plan, Statement of Work, and preparing business requirements and functional specifications.
• Managed a technical team of six individuals according to the senior IT consulting status, collecting status updates from each team member and communicating to the client on a weekly basis, which was necessary for project management of the new application development
• Sampled text files, created and setup new Extraction-Transform-Load (ETL) processes, validated schema, and designed mappings and process flows to be used during data transmission.
• Lead developer of the VB.NET application solution used to track genetic profiles through an authorized user approval process.
• Assist developers with making required analysis, and accurate estimates of development, testing and delivery for all releases and iterations.
• Unit test all code as it is being written to ensure everything works according to the functional specifications and requirements.
• Using HTTP and SOAP messages to securely invoke web services, designed a functional VB.NET web application with necessary encryption on certain functions
• Setup the remote desktop (RDP) and authorities for users who would have access to the hosted box.

Confidential, Cincinnati OH

PROGRAMMER/ANALYST

Responsibilities:

• Implementation of System Enhancements to use in Online Purchasing System Following the Waterfall Methodology, perform user acceptance testing on behalf of business procurement team in order to find both communicated and non-communicated problems with online purchasing system, which is used by 85% of the Kroger workforce.
• Serving on 24/7 rotation support for after-hours business systems support needs, contributed to the effectiveness of application design, installation, and implementation.
• Served as liaison between business executives and support team; communicating user expectations to the support team during monthly meetings which are designed to identify concerns, and address issues with the application/reporting.
• Using TFS (Team Foundation Server), make source code changes as necessary for the team.
• Led data migration project efforts across a matrixed organization, ensuring that files were uploaded prior to SLA agreement, and were data was sent via SFTP in the correct format for processing within CRONTAB.
• Utilize SQL and VBA scripting skills to maintain, modify and create new queries or processes to be accessed through an ODBC connection to the Informix Database.
• Served as systems analyst and programmer for the forecast analysts and business analysis team, utilizing KSH (kornshell) scripting in an AIX environment.
• Instrumental in successfully developing nightly processes and UNIX scripts that will complete data loads as required for the data migration project for all distribution centers under the supply chain systems area.
• Reviewed, analyzed, and evaluated mainframe and logistics business systems and user needs.

Business Intelligence Administrator

Confidential

Responsibilities:

• Using the waterfall methodology of project management, review project documentation at points throughout the system development life cycle of a project, addressing assumptions and issues.
• Create test plans incorporating all modules and deliverables when new projects are requested.
• Assign and coordinate resources and testers to create an effective and efficient project test.
• Coordinated system upgrades with DBA group, and users, reviewing processes in order to identify gaps between requirements.
• Planned and analyzed testing environment for database upgrades, maintaining a functional environment for the users during upgrade processes, gathering feedback on effectiveness.
• Reviewed and analyzed impact on baseline measures, making recommendations and offering guidance as needed to ensure effectiveness and functionality.