SUMMARY:

• Accomplished professional with more than seventeen years of experience in information technology.
• Demonstrated ability to manage complex projects and programs and achieve goals.
• Proficient in requirements gathering, system analysis, database architecture, business intelligence, business process improvement, project management, program management, IT assessment, and strategic planning.
• Excellent communication, analytical, strategic thinking, and problem solving skills.
• Self - motivated and enthusiastic about learning new things and taking on challenges.

TECHNICAL SKILLS:

Knowledge of IT Best Practices and Project Management Methodology : PMBOK, ITIL, Scrum

Project Management Software Used : Microsoft Project, Microsoft Project Server, JIRA, Basecamp, Celoxis

Project Environment & Tools Used in projects I managed or worked on: Microsoft SQL Server including Reporting Services, Analysis Services, Integration Services and Power BI, Informatica, Oracle, Tableau, SharePoint, .Net Framework, BizTalk, ASP, ADO.net, C#, XML, XSL, Web Services, SOA (Service Oriented Architecture), UML, Crystal Reports, HTML, JavaScript, Windows, PHP, Linux, Joomla, Drupal, Java, Dreamweaver, Crystal Report, InfoPath, Deltek CostPoint, Cognos, Empirix E-tester, Load Runner, Visual Basic, Microsoft Access, ArcGIS for Desktop, ArcGIS for Server, ArcGIS Online, Windows Azure, Visual Studio, Erwin, Rational, FME, Visio, Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Program Management Officer

Responsibilities:

• Led the County-wide implementation of Confidential No. 32-201 4, a County Council legislation that requires County departments to make more data and documents accessible to the public.
• Analyzed the requirements of Confidential . Created the web portal architecture. Completed Web Portal Implementation Plan and submitted to the County Council and County Executive.
• Completed Governmental Transparency and Accessible Data Plan and Guidance Document including vision, mission, goals, objectives, technical architecture of where different data will reside and how data could be utilized using BI tools or embedded into the County website, roles and responsibilities, process workflows, metadata standards, governance, and data security and privacy guidelines. Submitted to the County Council and County Executive as required by the Confidential legislation.
• Worked with Confidential task force members. Submitted the task force report to the Director of Technology and Communication Services.
• Worked with fourteen County departments to collect data inventory. Submitted the combined data inventory to the County Council and County Executive. Worked with more than 150 people including department directors, deputy directors, data coordinators, and SMEs.
• Issued an RFP for an open data portal platform to publish machine-readable data. Evaluated proposals and selected a platform with the evaluation committee. Worked with departments, Office of Law, Office of Public Information Office, and the vendor. Successfully launched the open data portal in eight weeks.
• Worked with a team to automate the dataset publishing to the open data portal using FME software.
• Led a team to automate document publishing from Open Text records management system to the County website.
• Assessed BI tools including Microsoft Power BI, Tableau, QlikSense, SAP Lumira, and IBM Watson Analytics. Create BI prototypes and demonstrated to County departments to show how they could use self-service BI tools to analyze data, create dashboards, share visualizations, and embed dashboards and visualizations into the County website.
• Worked with departments to publish documents to the County website.
• Worked with departments to continuing publishing and refreshing datasets on the open data portal.
• Participated in Maryland State’s Council on Open Data meetings.

Confidential, Columbia, MD

Senior Project Manager

Responsibilities:

• Hired as Senior Project Manager under the supervision of the Confidential President, oversaw the Customer Service System project and successfully launched the new system for membership management, camp management, POS transactions, class and program registrations, space reservations, and online member account management and class registrations.
• Assessed the custom developed software which had been developed for several years but was not completed due to large amount of defects to determine whether CA should fix and complete the system or whether there were other options.
• Prepared an RFP. Evaluated commercial off-the-shelf products.
• Made the recommendation of pursuing the COTS product instead of continuing the custom software development to the President and Board of Directors.
• Completed the procurement contract negotiation.
• Provided monthly briefings to the Board of Directors and weekly reports to the President.
• Communicated with the President, senior executives, and team members about tasks, milestone dates, status, and resource allocation during the implementation.
• Led a diverse team of members from Sports and Fitness, Camp and School Age Services, Accounting, Internal Audit, Sales and Marketing, Finance, and Information Technology, as well as the software vendor.
• Implemented the COTS product and replaced the aged system Confidential used for years.
• Worked as Data Manager on the initiative from Confidential President about data management including business intelligence applications and GIS (Geographic Information System) applications.
• Implemented ArcGIS Online platform to enable internal users to view, create, and share maps and map applications. Partnered with ESRI to create a GIS road map.
• Created a data warehouse / BI application to gain insights into membership data.
• Researched data management tools including open data tools such as Socrata, and Business Intelligence tools such as Microsoft BI tools, MicroStrategy, Cognos, and Tableau.
• Created data analytics and visualization using SQL Server 2012, Excel Power Pivot, and Tableau to analyze Howard County Health Survey results for the Community Health division.
• Participated as a selection committee member to evaluate and select contractors to implement the new CA web site.
• Worked as Director of Data Management Center for Pursuit of Excellence. Worked with other Center for Pursuit of Excellent directors on a process to implement innovation ideas.

Confidential, Silver Spring, MD

Project Manager

Responsibilities:

• Managed IT projects and conducted project status briefings with business stakeholders. Reported project status to IT senior directors, IT Vice President, Danya Confidential Vice President, Danya President, and others.
• Managed Education Outcomes, a monitoring and evaluation project, to gather student and teacher engagement data and evaluate for future performance improvement for Evansville Vanderburgh School Corporation. The system allows students and teachers to fill out surveys online while providing dashboards and reports for teachers and school admins. Used Scrum to build the product iteratively. Motivated and led the team to work energetically and steadily in each sprint.
• Managed Confidential Reviewer Management project to provide reports and dashboards via a data warehouse for program monitoring and evaluation purpose.
• Used agile project management methodology to build product iteratively. Conducted daily Scrum meetings, sprint planning meetings, and sprint retrospectives. Interfaced with business stakeholders and product owners.
• Worked with product owners to prepare and prioritize product backlog. Managed resource allocations and estimation.
• Maintained issue log and removed impediments. Used JIRA to track user stories, tasks, and sprint burn-drown graphs.
• Oversaw Confidential system integration with Danya Deltek CostPoint accounting system which enabled data exchange of Confidential review financial commitment information in the payment validation and processing area. Gathered requirements and prepared product backlog before a product owner was designated. Conducted daily scrum meetings, sprint planning meetings, sprint reviews, and sprint retrospectives. Removed impediments. Reported project status to senior management.
• Managed HR and Confidential Integration project to implement Kenexa 2x Recruit (HR COTS) for Confidential reviewer recruitment and Danya corporate recruitment.
• Managed Confidential program with a team of twelve members. Oversaw project enhancements to various systems including Confidential Gateway, Confidential Review Tracking, Monitoring Report Analysis Production, Feedback Management System, and Reviewer Management System. Ensured FISMA self-assessment of Confidential systems was complete.
• Managed Confidential Gateway and Confidential integration project which enabled Confidential reviewers to access the Confidential system via Confidential Gateway system with a single sign-on.
• Managed Follow-up Reviews project which allowed Danya Confidential operations group to schedule follow-up reviews for grantees.
• Led Reviewer Performance Assessment System project. Developed reports and email notification module which allowed reviewers and review coordinators to view performance assessment scores and receive email notification of completing assessment online.
• Led the team and improved the business process by automating reviewer hold release process based on grantees’ status.

Confidential, Washington, DC

Consultant

Responsibilities:

• Provided advice to senior management on SQL Server Reporting Services as a reporting tool for Confidential systems to achieve organizational goals, missions and objectives.
• Led the team in building a data mart which was used by OLAP for business intelligence. Loaded data from a staging database into the data mart.
• Led requirements gathering for review support reports for HS Monitoring Support project.
• Led the project tracking project and created a project tracking database to keep track of change management requests and work items.
• Evaluated InfoPath to see if users could use InfoPath forms to submit work requests.
• Analyzed the database structure and database activities of a legacy system.
• Documented web service programs used for grantee data exchange with Confidential Enterprise System at OHS.

Confidential, Baltimore, MD

Consultant

Responsibilities:

• Evaluated the need of a staging database as data quality assurance environment for the enrollment medical pharmacy claims data warehouse.
• Worked on the Case Trakker Renewal Project and evaluated whether the Case Trakker software could meet the company needs or the company should pursue other third party tools or a custom application. Evaluated if prior implementation’s methods, scripts, and data mapping for data conversion were usable. Extracted data from the current Midas Plus care management system. Ran prior implementation’s DTS packages to load data into Case Trakker.
• Reviewed daily reports generated by nightly data extract jobs.

Confidential, Baltimore, MD

Senior Database Analyst

Responsibilities:

• Worked as team lead with other team members to provide application development and implementation services for school wide users by utilizing SQL Server 2000, ASP, or .Net technology.
• Played various roles in areas of requirements, system analysis, database architecture, database development, report creation, testing, and project coordination.
• Created work break down structures. Executed project schedules. Communicated project status.
• Led the team, designed, and implemented Trend, Analysis and Budgeting System as a tool to project, budget and report general fund expenditure for the current, future and prior fiscal years. The system was used by academic departments and Office of Finance and Administration for timely reporting to the Dean of Public Health using Crystal Report and for conducting data reconciliations with the university accounting system.
• Led the team, designed, and implemented Course System as a means for faculty, academic coordinators, Committee of Academic Standards members and Student Academic Support Services to enter new course information as well as to change existing course information, and for students, faculty and staff to search courses and view reports.
• Led the team, designed, and implemented a departmental Performance Review System to allow reviewers and employees to enter review comments and joint comments for current reviews as well as to view past reviews.
• Led the team and developed a Training Program System for Office of Graduate Research to keep track of training program application process, training programs/grants and trainees, and to view reports.
• Led the team and developed a Continuing Education System for summer institutes and noncredit course programs to allow applicants to submit online applications and payments, and academic coordinators to track application, billing, housing, and course registration information.
• Worked on other projects such as HIPAA, Student Printing, Alumni Email Alias System, and Tobacco Survey.
• Participated in Hygiene Admissions Tracking System which used an Oracle database to allow Admission Office to keep track of events associated with the admission application process.
• Created, implemented, tested and maintained databases. Developed standards for database naming conventions and database procedures. Administered Microsoft SQL Server 2000 databases on the development and staging servers. Applied changes to production databases.
• Created reports using Crystal Report. Provided assistance, consultation and training for users on application features and work flows. Wrote technical documentations.
• Evaluated SQL Server Reporting Services and Rational software.

Confidential, Kansas City, MO

Software Engineer

Responsibilities:

• Provided office automation development using desktop tools to increase associate efficiency.
• Designed and tested relational databases for Network Services group to maintain voice site information from different regions and states.
• Created user interfaces for database navigation and data entry.
• Loaded data into databases. Designed reports.
• Developed Microsoft Exchange Forms which helped the communication between business units.
• Held project meetings. Documented project requirements and user manuals.
• Installed an Oracle database application for users.

Confidential, Cedar Rapids, IA

Intern

Responsibilities:

• Developed an interface between an Access database and Microsoft Word for automating the generation of Historical Data Collection reports.
• Tested, documented and presented the report automation features.
• Participated in the SLOC summer project to design a SLOC tool using object-oriented methods.

Confidential, Iowa City, IA

Teaching Assistant

Responsibilities:

• Held office hours for answering students' questions and posted class notes on the web.
• Graded assignments and exams for three classes.