Consultant as a Technical Lead/Certified Sr. Business System's Analyst/Data Analyst @ Netstar Corporation Consulting: Policy Studies Inc. (PSI)
Technical Team Lead/Sr. BI Data Analyst and Report Developer @ AxisPoint Health (Formerly a McKesson company)
Diplomas for QlikView's Design I & II and Developer I & II, Business Intelligence Tool Developer and Designer @
Technical and Functional Manager of 6 BI and Reporting Analysts and Developers – 8+ years of data analytics with a BI focus and 30+ years spanning every role within the development life cycle of various methodologies. Highly motivated self-starter with the ability to work as a leader and team member and possessing strong communication and organization skills.
Technical and Functional Manager of 6 BI and Reporting Analysts and Developers – 8+ years of data analytics with a BI focus and 30+ years spanning every role within the development life cycle of various methodologies. Highly motivated self-starter with the ability to work as a leader and team member and possessing strong communication and organization skills. Drive key business and technical initiatives solving complex problems through a systematic approach using innovation with Project Management Principles (PMP) to maximize Return on Investment (ROI). Partnered with the Business and BI Delivery team to establish data solutions for the strategic-integrated data warehouse while defining and maintaining standard and repeatable processes and procedures. Enthusiast and experienced Qlikview developer and application designer. Managed small and large scale project plans for high profile deliverables with strict timelines. Instrumental with establishing, designing, training and incorporating necessary internal and external standard business processes and procedures.
Programming: Qlikview (QV) Developer and Application Designer, PL/SQL, T-SQL and MDX, Microsoft BI Stack - SSMS/SSIS/SSAS/SSRS
Databases: Oracle9i/10g/11g, Microsoft SQL Server R2 2008
Tools: TOAD, SSMS, SQL PLUS, Hyperion Interactive Reporting (IR)
Reporting & Project Tools: QlikView 10 SR2 – 11 SR11, Oracle Report Builder 6 - 10, Crystal Reporting, Eloquence, Hyperion Interactive Reporting (IR), SSRS/PPT/SharePoint, OBIEE(+), Microsoft Excel, PeopleSoft SQR, Visio & Microsoft Project.
Technical and Functional Manager/ BI Development and Reporting @ Department Reorganization from MHS to MCCA. Promoted to manage a high functioning team of data and reporting analysts and developers; objective of maintaining organization’s effectiveness and efficiencies by defining, delivering, and supporting strategic and tactical plans for implementing technological problem solving solutions; maintain quality service by establishing and enforcing standards. Recommend information technology strategies, policies, and procedures by evaluating outcomes and trends, identifying problems, and anticipating requirements. Currently managing the implementation of all reporting, using various tools for our latest product in the marketplace. This custom Chronic Care Application, called VITAL, is the vehicle our RNs use to improve the quality of care/ quality of life for some of the most vulnerable members of society. In support of providing decision making data while using and documenting Best Practices/Standards, Managing a QV 6 month project Upgrade QV10 SR2 to QV11 SR11 and Optimize the Servers Architecture; Build and store a 3 tier data model to Extract, Transform and Incrementally Load (ETL) the VITAL data; Design secure QV Dashboards for the many audiences, Executive, Management, Operational and Client Facing. On-going vendor management for our new telecom system CISCO and sub vendor Acqueon. Providing the reporting via the Operations preferred reporting tool QV. Exceeded the expected Return on Investment (ROI) of 250K in the first quarter of being operational. Maintain current professional and technical knowledge by reading publications; establishing personal networks and attending educational workshops and presentations. From August 2013 to Present (2 years 4 months) Technical Lead BI Analyst/ Data Analyst /Reporting/Developer @ As a permanent employee continued to work closely with the business to create and implement a ‘Standard Reporting Package’ in support of a new Disease Management Program. As the technology had changed to OBIEE+, supported building out the Business Model and Mapping (metadata layer) from the physical layer to the presentation layer. Focused on the data content and quality while partnering with the Data Steward and Architect's to build on an existing small scale Integrated Data Warehouse (IDW). In addition, continue to be the lead analyst in support of our existing client’s initiatives. Collaborate with the IDW ETL and Data Architects to implement identified data content gaps, from multiple sources, essential for internal and external reporting and decision making. Develop and enhance reports via Oracle Report Builder incorporating graphical representation. Promoted to lead a new business direction with a goal to deliver true self-service BI, empowering the users and driving innovative decision making. Deeply involved with developing and designing applications using Qlikview- a pioneered in-memory Dash boarding tool. Developed and deployed over 100+ QVD Applications to individual clients containing disease management, nurse advice line and billing content. Simultaneously, leading a team with other business unit initiatives utilizing a variety of BI and Reporting tools; developing new letter generation via Eloquence and reporting on a new business complex case management program via Crystal Reports. From August 2008 to August 2013 (5 years 1 month) Consultant/SR Data and Reporting Analyst @ Consultant as a Lead BI Analyst/Certified Sr. Business System’s Analyst for MHS started on a Business Intelligence (BI) project in support of a strategic enterprise data warehouse for a Disease Management Program. Refining data analytics with a focus on Business Intelligence. Worked closely with the business to analyze and understand reporting data requirements. Perform process, system and data analysis for the multiple source applications as they relate to the data model. Clearly define and write the system requirements to describe the dimensions, conformed dimensions, facts and transformations. Recruited on a small team to perform a BI readiness assessment while supporting the BI Delivery/Infrastructure Architect with developing and designing strategic client reporting via Hyperion IR and PR as well as Access. The BI Readiness assessment led to changing our strategic approach through Oracles OBIEE+. Owned the business and system requirements and performed as the liaison between the Client, business and technology. From January 2007 to August 2008 (1 year 8 months) Consultant/Sr. Data and System's Analyst @ As a Certified Sr. Business Systems’ Analyst / Technical Lead for PSI working on the Florida Government Child Health Care Administration System (CHAS), responsible for the implementation of large and small software releases through the software development life-cycle. Work closely with Florida Healthy Kid’s staff to understand the business requirements. Analyze the system and data impacts and identify any gaps. Clearly define and write the technical requirements to describe the ‘How’ as it relates to the current system architect and all interfacing sub-systems. Assist and support the developers with the interpretation of the technical requirements into the design and coding and unit testing phases. Review and assist with the creation of the feature, system and user test plans and test cases. Support the execution of all testing phases to validate the system meets the functional and non-functional requirements. Analyze reported defects throughout the testing phases. Identify true defects and track them through the defect process of coding through retesting. Provide operation’s support on-site during major software releases. Clearly communicate with all levels of participation throughout the complete project cycle. In addition to project work, provide adhoc production support which resulted in identifying and correcting many critical data and process issues with the application. Tasked by the client to verify that the application processed children appropriately based on the business rules. Spent six months analyzing the data to identify, communicate the defects and coordinate the execution of SQL procedures I wrote to correctly reprocess over 8,000 children who were incorrectly rejected or suspended from the program and were not receiving subsidized health care insurance. From April 2005 to January 2007 (1 year 10 months) Sr. Business System's Analyst @ As a Sr. Business Systems’ Analyst for ABCBS in the Financial Systems Department, Performed Project Management tasks including planning, estimating, status reporting and scope management. Created and maintained Project Plans using Microsoft Project. Responsible for defining functional, usable, reliable, performable and supportable requirements related to back-end financial systems that supported the billing and cash receipts. These systems included Anthem’s in-house developed systems and PeopleSoft Accounts Receivable (PSAR), Billing (PSBI) and General Ledger (PSGL) modules. Translated business requirement’s into high-level and detailed design’s that described how to implement the system. Created and executed Feature and Integration test plans and test cases to validate that the system met the functional and non-functional requirements. Supported the User Acceptance testing and the production implementation. All these responsibilities were in support of many large-scale projects such as Claims/Membership System conversion, HIPAA, Sarbanes-Oxley and Member Unique Identifier. From April 2002 to April 2005 (3 years 1 month) Consultant @ As a Consultant for MidWest Consulting Group, contracted with Sprint North Supply, providing Testing Team support for PeopleSoft 8.0 Software upgrade and releases within a 3-Tier Client/Server environment. Using TestDirector 7.0, instrumental in the planning, writing and execution of the manual test effort. Also key team member in validating test data and verification of fixed defects. Defining and creating DB2/SQL queries, VISIO system flowcharts and detail job scheduling documentation for the clients.
Previously provided project management requirements for American Century’s (ACI), IT Vendor Management team and their new relationship with vendor clients. Defined and documented responsibilities and procedures within ACI between the Help Desk, Network Services and Production Support Teams, measured and reconciled Standard Levels of Agreement (SLA’s) between company and clients. Created and distributed management reports using Crystal Reports and accessing Tivoli. Provided on-call support and adhoc technical processing. From February 2001 to December 2001 (11 months) Software Engineer IV @ As a Software Engineer IV for Sprint, Project Coordinator for the Line Information Database System (LIDB), Automated Repair Bureau System (ARBS) and Trouble Reporting System/National Reporting System (TRS/NRS). Developed, maintained and enhanced project plans and schedules utilizing Microsoft Project. Performed extensive requirements gathering, analysis & design, programming, testing and implementation while always meeting strict timelines, methodologies and budgets. Technical, Project Lead for a major enhancement to meet LNP requirements for the LIDB system where COBOL and DB2 were utilized. While in this role, also utilized CICS, VSAM, JCL, Hiper-station and Crystal Reports. Provided production on-call support. From November 1998 to May 2000 (1 year 7 months) Software Engineer IV @ As a Software Engineer IV for Cardinal Detecto Scales, was a member of a three man IS department. Enhanced systems that included Inventory Control, Accounts Receivable/Payable, Sales Order Entry, Purchasing, Finance, Material Requisition Planning and Reporting. Performed full Project Life Cycle responsibilities and all communications with the users. Designed and implemented an Electronic Data Interface (EDI) System as well as an automated truck depreciation reporting system for the accounting department. Supported routine and non-routine production issues and provided adhoc reporting and technical processing on request. All utilizing COBOL, BMS, FlexGen (a tool for online code and screen generation), SCL, Relative and VSAM file processing in a UNIX environment. From September 1997 to November 1998 (1 year 3 months)
Associate's Degree, Computer Science/Accounting, 3.87 @ Delaware Technical and Community College-Terry From 1981 to 1983 SetFocus Rhonda Smith is skilled in: SDLC, Visio, Data Warehousing, SQL, Business Intelligence, Requirements Analysis, SSIS, ETL, SSRS, Databases, Requirements Gathering, PL/SQL, T-SQL, Crystal Reports, Unix
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension