Programmer Analyst Resume Profile
CAREER SUMMARY
- Seasoned Senior Business / Systems Analyst with over 15 years of IT experience including over 13 years full software development lifecycle experience in CMMi, SDM Waterfall, and Agile methodologies, across a variety of industries including publishing, banking, accounting, government, finance, health care, education, and insurance industries.
- Project Management Strengths: Proficient in MS Project, Gantt charts,. Experienced in Agile, Waterfall, RUP and Rapid Application Development RAD methodologies, budget management, resource leveling, project scope agreements, on-time delivery, developing and managing customer relationships, cost avoidance, continuous design improvements, status meetings, success, improving business processes, recognizing strengths, writing project charters, negotiating statements of work SOW . Excellent at vendor and commercial-off-the-shelf COTS application integration.
QUALIFICATION SUMMARY
- Exceptional written communication skills as demonstrated gathering, developing, and editing project scope agreements, business requirements, test/validation plans, requirements traceability matrixes, and user guides
- Exceptional oral communication as demonstrated interviewing end users, clients, and technical teams
- Strong data warehouse background with knowledge of ETL and data mining
- Strong Object Oriented Development analysis in Java and .NET environments
- Exceptional SQL and reporting skills
- Project Management PMO and Business Process Improvement experience
- Team player who works well in groups and independently
- Extensive Healthcare, Medicare, Medicaid CMS experience
SKILLS MATRIX
| SKILL | YEARS EXPERIENCE | PROFICIENCY |
| IT Experience | 20 | Expert |
| Business Analysis | 12 | Expert |
| Business Process Improvement | 15 | Advanced |
| Data Extraction | 10 | Expert |
| Requirements Documentation | 13 | Expert |
| SQL | 15 | Advanced |
| JAD | 15 | Advanced |
| Testing | 12 Business Intelligence tools/Test Director | Advanced |
| Work with Quality Teams | 15 | Advanced |
| Work with Training | 13 | Advanced |
| Customer Support | 13 | Expert |
| Relational Database | 13 Oracle/DB2/Foxpro/Access | Advanced |
| UML/BPD | 12 | Advanced |
| Reporting | 12 | Expert |
| SOA | 6 | Advanced |
| ICD-9, ICD-10 | 3 | Advanced |
| Agile | 9 | Advanced |
Proficiency Scale: none, academic, beginner, intermediate, advanced, expert
TECHNICAL SUMMARY
Hardware Experience:
| IBM PC's COMPATIBLES |
Software Experience:
| MS OFFICE | MS PROJECT | PL/SQL/PERL/CGI |
| CMS/WCM | BUSINESS OBJECTS | MS ACCESS |
| JAD/RAD | BUSINESS INTELL. | DATA WAREHOUSE |
| HTML/MACROMEDIA | CRM | COBOL/TSO/FOCUS |
| ISPF/CICS/MVS | VISUAL BASIC/ VBA | VISUAL FOXPRO |
| OLAP/OOD | .NET, JAVA | MS VISIO |
| HYPERION/BRIO | RATIONAL SUITE | MERCURY SUITE |
COTS Experience:
| RED DOT CMS/WCM | MS SHAREPOINT | PEOPLESOFT |
| GOLDMINE/SALESFORCE/RELATIONALS CRM | SALLIE MAE SYS. | WORDPRESS |
| TIBCO | ADMARC | WAUSAU FINANCIAL |
| BANNER | COLLEAGUE | QNXT |
PROFESSIONAL EXPERIENCE
Confidential
- Medicare fraud detection full lifecycle Project Management, Business Analysis, development and testing.
- Consulted with client CMS and vendor Northrop Grumman to cater Verizon in house application for government use.
- Planned and scheduled projects for approval.
- Maintained project schedules, budgets and resources.
- Managed analysts, testers, and developers and collected statuses to meet schedule.
- Prepared all documentation for government audit including testing, requirements, and verification
- Web application development from initial statement of work phase throughout documentation, development, unit testing, user acceptance testing and training.
- Business Process Development BPD for as is and future development and design utilizing UML/Visio
- Managed the engagement, scoping, implementation, onboarding training and change management for web portal systems in .NET environment.
- Analyzed and developed Sharepoint sites for client internal sites.
Confidential
- Lead analyst for Software Solutions team of National Health Care provider of Medicare and Medicaid solutions.
- Managed a team of five Business Analysts, 5 Systems Analysts and coordinated with in-house and off-shore developers for application solutions.
- Project Manager/Analyst for application solution projects concerning, member based services, pharmacist applications, Medicaid/Medicare eligibility and services, medical approval surveys, and customer service applications.
- Led Scrum meetings and reported on project development.
- Created CRM system for entire member relations and correspondence using documental architecture including BPD's, FRD's, UAT, and training documentation.
- Gathered and documented requirements for web based applications utilizing .NET technologies in a Microsoft environment.
- Communicated with QNXT Health Care application to provide end users real time member and provider information.
- Managed multiple projects from beginning to end in an Agile work environment.
- Designed and developed process maps, work flows, business rules, user stories, acceptance tests, and use cases for business process improvement.
- Maintained strategic partnerships between business needs and technology delivery and cohesiveness of the two.
- Performed analytical work and project deliveries for the CIO, CEO, VP's and end users.
- Converted Gant charts to BPD utilizing UML.
- Converted ICD-9 and ICD-10 codes in user interface for practical verbiage and usage
Confidential
- Gathered and documented requirements for federal business systems and processes creating web based solutions.
- Managed and mentored team of Business Analyst to solicit requirements from several government agencies and bureaus.
- Lead analyst and subject matter expert for 2.1 release of the DOJ's Justice Security Tracking and Adjudication Records System JSTARS .
- Produced Requirements documents FRD , Testing documents, System Design Documents SDD , Requirements Traceability Matrixes RTM , User Acceptance Training UAT plans, Training plans, and training manuals and modules utilizing UML.
- Created Requirements documents and Use Case Diagrams utilizing IMB's Rational Suite Rose, Requisite Pro, Clear Case
- Worked effectively with end users to perform a thorough analysis of business operations and procedures to increase efficiency and productivity.
- Worked with other IT teams in ongoing design, testing support of business application system needs.
- Installed, tested and supported multiple application system releases into the test and production environments.
- Troubleshoot day to day database and related application issues.
- Assist in security of databases to ensure accurate and appropriate use of resources and data.
- Provided leadership to the project team. .
- Reported to management on project plan adherence
Senior Business Systems Analyst
Confidential
- Interacted with and facilitate meetings with customers to gather and document business requirements for web-based applications, user interfaces, websites, and web content management solutions.
- Scrum Master for facilitating NEA project development.
- Organized sprints and documented status through the project management lifecycle.
- Led and facilitated daily scrums with the project management team.
- Responsible for interviewing, hiring and mentoring BA's on best practices in Agile environment.
- Managed team of twenty developers in Quito, Ecuador.
- Utilized SOA/EAI/ESB practices for a large systems integration project providing data communication between over 20 applications for the largest online university in the world.
- Communicated with offshore developers to create web services, ETL processes, build stand alone applications, web portals, fulfillment systems, etc.
- Traveled to client sites to interview, meet, and train stakeholders and end users on utilizing applications, accessing web content management systems, data reporting ad measurements, etc.
- Traveled overseas to communicate and train with developers in advancing technologies.
- Communicated with developers and business owners to create complicated and intricate websites utilizing business dependant technologies Java, .NET, Flash, RedDot CMS, etc.
- Investigated customer business problems and employ general business common-sense.
- Participated in defining project scope and objectives. Oversee/coordinate assigned aspects of the development project.
- Compile business requirements into functionality matrices and similar documents that outlined user business needs.
- Built business process models to detail business workflow
- Documented detailed requirements into functional specification documents that detail how applications are to work from a user's point of view.
- Work with technical team members to ensure functional specifications are technically sound.
- Created and maintained test plans and was responsible for the creation of applicable use cases as a component of development specifications.
- Responsible for performing quality assurance testing and sign-off of assigned functionality post/during development.
- Build user training documents and conduct onsite user training.
- Contributed to adherence to project budgets.
- Monitor assigned components of the project from initiation through delivery, interfacing with development resources and project management structures on all matters.
- Assist in assessment of project issues and develop resolutions to meet productivity, quality, and client-satisfaction goals.
- Assist in the development and delivery of tasks outlined in work plans, schedules, project estimates, resource plans, budgets, and status reports.
Senior Business Systems Analyst
Confidential
- Performed scoping, developed requirements, wrote test cases, set up test data and executed test cases in support of the Sales Desktop project.
- Utilized several different methodologies including SDM Waterfall, and Lean Agile to successfully enhance and lead projects throughout the entire SDLC.
- Conducted JAD session to gather requirements and statements of work
- Interfaced and created communication with several different databases and applications to accurately report client financial information.
- Integrated sales functionality for COTS applications and in-house portal based applications used by several associates to service retail customers on online, via telephone and at investor centers.
Business Systems Analyst
Confidential
- Gathered requirements, business rules and metrics and provided reporting analysis for Social Security Administration's Medicare Modernization Act MMA utilizing Microsoft Office, CaliberRM, Mercury Test Director, Brio Intelligence, Hyperion, and mainframe technologies.
- Allocated and monitored time and resources to adequately staff projects
- Utilized several different methodologies including CMMI, Waterfall, and SPLC pilot to successfully monitor and lead projects throughout the entire SDLC.
- Assisted the PMO in project status, conducted status meetings and documented and reported results.
- Performed interviews and meetings to determine actually project scope and best process practices.
- Performed investigation and analysis to consolidate several separate databases into one integrated data warehouse.
- Wrote and optimized complex SQL queries to retrieve datasets across multiple database tables. Primary goals were to identify discrepancies within data and at times to generate key metrics and benchmarks.
- Performed system integration and documentation detailing source to target mapping, conceptual designs, and gap analysis.
- Analyzed, tested, validated, and reported on the Unified Metric System SUMS database and ETL Data Warehousing project.
- Performed Unit Testing, System Testing, Regression Testing, and User Acceptance Testing UAT to thoroughly test applications.
- Provided analysis and reporting from SSA's Managerial Cost Accounting System MCAS .
- Analysis, validation, calculating and reporting on Medicare Part D Subsidy Applications MSA , Redeterminations, Medicare Part B Income Related Monthly Adjustment Amount IRMAA , SSI Supplemental Security Income Benefits, and Medicare Part B Premium Surcharge Protests.
- Provided reporting and data mapping for the Enterprise Information System EIS .
- Utilized technical writing for project scope agreements, requirements documents, validation plans, and meeting notes.
- Created user guides for data retrieval and analysis.
Systems/Programmer Analyst
Confidential
- Developed, gathered and edited business requirements, use cases, test cases and implementation plans for Data Warehousing project.
- Conducted nationwide client interviews to plan and implement programming and processes.
- Utilized and centralized three CRM systems: Goldmine, Relationals, and Salesforce
- Created and documented Extract, Transfer and Load ETL processes for Data Mining repository and Data Warehousing.
- Calculated trend analysis for monitored metric counts of activities.
- Created specifications for OLAP applications.
- Conducted query and adhoc reporting analysis.
- Created and analyzed different Business and System Intelligence practices utilizing Business Objects and Oracle Reporter extracting data from several different universes in DB2 and Oracle back end.
- Wrote numerous Business Objects reports both according to specifications and on ad-hoc basis. Provided Business Objects training to departmental user groups.
- Defined and maintained documentation pertaining to business processes, systems operations and user documentation within the department.
- Develop and support systems to track, analyze, and report on revenue trends, ad sales, year to year variances, volume, and circulation for the publishing industry.
- Data reporting for advertising salespersons, middle and upper management
- Develop and maintain sales Forecasting/Plan/Budget/Actuals data database.
- Extracting and presentation of data using SQL and Oracle Reporter and all Microsoft Office applications Excel/Access/Word/Power Point/Visio/Project.
- Communicating with database applications using TSO/MVS, JCL and FOCUS programming.
- Creating intricate VBA Excel Macros to monitor data for call center and sales performance and to automate weekly reports for auditing and sales commissioning.
- Adhoc reporting/programming for time sensitive data.
- Utilize and support several end users on Goldmine CRM management tool.
- Create documented requirements for software purchasing and implementation.
- Create technical solutions to create liaisons between legacy systems, current and incoming systems and alter all to match business practice.
