Programmer/systems Analyst Resume
Sparks, MD
SUMMARY:
- 7+ years of experience as a Business Analyst along with 3 years of data visualization using Tableau Desktop.
- Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
- Tableau tools include Tableau Desktop versions 6/7/8.1, Tableau Reader, Tableau Public, and Tableau Server.
- Produced attractive visuals/dashboards to convey the story inside the data.
- Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
- Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
- Administered user, user groups, and scheduled instances for reports in Tableau Server.
- Strong knowledge of Software Development Life Cycle (SDLC).
- Good understanding and background in health care industry.
- Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
- Hands on experience working with HIPAA 4010/ transactions such as 837, 835, 834, 278, 270 and 271, ICD - 9/ICD-10 codes.
- Possess strong knowledge of healthcare terminology and extensive experience working on healthcare projects.
- Excellent analytical skills in gathering business requirements through analyzing the needs of Business and Stakeholders and converting them into functional/technical requirements.
- Excellent communication skills in both written and oral along with ability to tell a story through data.
- Ability to interact professionally with a diverse group including executives and managers.
TECHNICAL SKILLS:
BI/Visualization Tools: Tableau Desktop 6/7/8.1, Tableau Public 8.1, Tableau Reader 8.1, Tableau Server 8.1, Cognos 8.4/10.1
Programming: SQL, UNIX Shell
Utilities: MS Office Suite, MS SharePoint, MS Project
Databases: Oracle 10g/11i, Oracle SQL Server 2008 R2, MS Access, MS Excel
Platforms: Windows 7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX, Linux, Ubuntu
Networking: TCP/IP, LAN/WAN Technologies
PROFESSIONAL EXPERIENCE:
Confidential, Sparks, MD
Programmer/Systems Analyst
Responsibilities:
- Involved in reviewing business requirements and analyzing data sources form Excel/Oracle for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Responsible for creating reporting data model as per the requirements.
- Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
- Created Heat Map showing current subscribers by color that were broken into regions allowing business users to understand where we have most customers vs. least customers.
- Projected and forecasted future growth in terms of number of sales based on the products by developing Area Maps to show details of which products are being sold the most.
- Converted charts into Crosstabs for further underlying data analysis in MS Excel.
- Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
- Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
- Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
- Involved in migration of Reports from BIRT to Tableau.
- Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle, MS Excel, Cognos 8.2/8.4/10.1, Erwin
Confidential, Rocky Hill, CT
Programmer/Systems Analyst
Responsibilities:
- Compiled vision and scope documents to define the rationale for the project and gathered requirements from business to determine functionality that should be provided to the users.
- Performed feasibility, adaptability study and risk analysis to identify the business critical areas from the user perspective.
- Gathered user/business requirements by meeting with business users and generated business models and use case analysis.
- Conducted individual and group (JAD) sessions with business and technical units. Gathered requirements by interacting with the stakeholders by interviewing them, by preparing questionnaires and getting feedback which helped in developing application according to HIPAA Rules.
- Exposure to HIPAA Compliance requirements. Considered HIPAA rules while data validation and testing.
- Participated in ICD 9 to ICD 10 codes mapping sessions as well as status meetings and provided comments and suggestions on challenges
- Involved in creating functional specification documents for the design, development and implementation of the project.
- Custom tables within a Dynamics SQL database were developed to ascertain custom reporting needs.
- Analyzed and documented Business requirements and detail design of the software for full understanding of the business
- Responsible for research and analysis of data requirements and issue resolution as related to the design.
- Developed a set of best practices with regard to Part 11 remediation and have implemented innovative and cost effective strategies for achieving compliance.
- Conducted Joint requirements Planning (JRP) sessions with management, SME’s, users and other key members for open and pending issues to develop specifications.
Environment: SQL, PL/SQL, UML, MS Visio, PMO, Windows, MS Access
Confidential, Cranbury, NJ
Business Analyst
Responsibilities:
- Key player in Managing project and was involved in resource management.
- Processed EDI test files and verified system to validate certified and non-certified trading partners.
- Conducted interviews with key business users to elicit, collect and manage requirements and prepared BRD. Created RFPs and evaluated vendor proposals.
- Developed business requirement and specification documents as well as high-level project plan and translated business requirements into data and process models.
- Developed process decomposition diagrams, data models, data flowcharts, entity relationship diagrams, screen mockups and state diagrams.
- Conducted JAD sessions between the business users, Developers, testers & Subject Matter Experts to resolve bottlenecks.
- Played important role into creation of CRUD (Create, Read, Update and Delete) Metric to make analysis and better understand data flows between different systems.
- Set up work flowcharts, and worked in close conjunction with Business Process Modeling tools for users for the procedures in claims with the help of SMEs.
- Performed relational database design and modeling and conducted multiple SQL querying.
- Responsible for creating & maintaining Requirement Traceability Matrix in order to track the development and QA process.
Environment: RUP, UML, SQL, MS Visio, MS Word, Agile, HP Quality Center.
Confidential
Business Analyst
Responsibilities:
- Participated for the creation of Functional Requirement Document (FRD) and Business Process Workflow with Stakeholders.
- Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC.
- Involved throughout the business System Development Life Cycle (SDLC).
- Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
- Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
- Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
- Facilitated JAD sessions with model diagrams to elicit future state business requirements and to document Business Use Case To-Be artifacts.
- Worked with QA team to develop performance test cases based on projected user load.
- Involved in all stages of testing process - Development of Test scripts and Test cases based upon requirements for Functional Testing, Integration Testing and support for User Acceptance Testing.
- Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application.
- Worked with management to create and communicate critical information to the user community via email and discussion boards.
Environment: MS Office (Word, Excel, Power Point), RUP, Share Point, MS Visio, Microsoft Outlook
