Parth Shah Ph.no: 408-***-****

Sr Reports Developer (Linthicum Heights – Maryland) Email: adcctm@r.postjobfree.com

Experience Summary

Mr. Shah has experience in Software Development LifeCycle (SDLC) with background in Forms Management, Reporting, Analysis and Design along with implementation, Testing and Deployment of Web-based applications, Client/Server applications and Web services. Experience and good knowledge in Healthcare Domain projects.

5+ years of hands on experience on SDLC (software development lifecycle) from initial phase of Requirement analyses to project execution.

Worked in various stages of Software Development Life Cycle (SDLC) deliverables of the project in the AGILE development methodology like requirement analysis, development, testing, build deployment, etc.

Good experience with SCRUM Development Process. Good understanding of various SDLC models like Waterfall, Iterative, Spiral and Agile development.

3.5 years of experience with gathering requirements, planning and development and user support of QlikView/Qliksense Dashboard and distribution of report to various stakeholders using Nprinting tool.

2+ Years of experience creating and scheduling PDFs/Notices in the Qlik Nprinting Tool in Pixel Perfect, Excel and Word reports.

Proficient in creating Guided Analytics Dashboard using QlikView tools like List box, MultiBox, Container Box, etc. along with uses of functions like Data and time, Keep, Mapping and using various Charts based on the requirement.

Experience in Migrating Qlikview reports to Qliksense.

1.5 years experience working with Informatica BDM tool, creating workflows and maintaining existing ones for ETL of the data.

2 years of experience working with Tableau reporting tool. Connecting data to Tableau from different data sources like Excel, OracleDB, flat file etc.

3 years of experience with Adobe LiveCycle Designer and Workbench ES3 developing notices and forms as per the design document and deploying the same using LiveCycle Archive. Developing and modifying existing forms for design, functionality and Validation with JavaScript for Conditional display of the content in the form.

Proficient in developing XML Schemas used in dynamic Forms and binding data connection to the specific XML path.

Experience in creating stored procedures for database transactions in SQL Server/PostgresSQL.

Proficient in using defect tracking tools like ServiceNow, HP Quality center/ALM and JIRA.

Experience in Database technologies and backend testing using SQL Queries.

Hands on experience with Defect management flow and resolved issues from the UAT testing.

Good working knowledge of UNIX and Windows platform.

Excellent communication and interpersonal skills, quick learner, able to meet deadlines, and adaptable to fast paced environment.Organized, detail-oriented and a good team player and ability to work on my own.

Work Experience

2018- Current

Sr. Reports Developer – Eligibility and Enrollment, Elkridge, MD

Eligibility & Enrollment (E&E) is the name of the new system being developed as part of the MD THINK program for State of Maryland. The E&E system will be Maryland’s new Integrated Eligibility system and eventually support all other Medicaid programs beyond LTC/Waiver, as well as other DHS programs, such as Food Supplement, Temporary Cash Assistance, and TemporaryDisability Assistance Program etc.. The E&E system will be introduced in a phased approach and will replace the CARES mainframe system as well as myDHR, the current online application for DHS benefits.

Key responsibilities in this position include:

Based on the business requirement create complex/advanced reporting solutions by generating Dashboards using QlikView

Developed qliksense/qlikview dashboards based on the business and technical requirements from the Users.

Involved in complete process of QlikView life Cycle by Gathering requirements, performing ETL on the data, Building Interface -Dashboards and Distributing the reports to the stakeholders;

Developed a ETL code to make necessary changes on the Data in order to display the information on the Dashboard according to the users need.

Created Dashboards using guided Analytics feature while linking all the tables and boxes on the Sheet;

Involved in analyzing the data and defining Key Performance Indicators (KPI).

Developed complex SQL queries to perform the data fetching from the respective tables from the Database.

Gather and loaded data from various data sources into the QlikView. (.CSV, Excel, Postgres)

Created Dashboards using different tools like List box, MultiBox, Bar Chart, Line Chart, Pie Chart, Container Box, Drop Downs etc;

Created Input boxes, Pivot Tables, Straight Tables, Buttons on the User Interface to make the data easily accessible to the users. Implement data level security using Section access.

Analyze and compare the solution on Dashboard by comparing the data in the raw source file

Developed reports in QlikView and in NPrinting and email the reports to end users.

Design and Developed Workflows and Mapping in Informatica BDM to perform the ETL

Worked on Qlik server to load the reports and manage the user access to these reports along with scheduled refreshing and sending out reports of the incidents created on a daily basis

Software/Tools: Qlikview, Qliksense, UNIX, Amazon Web Services (AWS), XML, Nprinting, Informatica Big Data Management, Javascript, QMC, Stored Procedures, SQL Server, PostgreSQL, DB2, Flatfiles, JSON, Python, SQL.

2016 - 2018

Reports Developer - DHHR – RAPIDS Project, Charleston, WV

State of West Virginia provides different types of benefits to the people of West Virginia through its Web Application called eRapids. Different types of benefits like Food Stamps, LIEAP, Medicaid, School clothing allowance, etc. are provided by state to the people based on their Income, Accommodation, Household size etc. It is an Integrated Eligibility application that determines eligibility of the applicants based on different parameters and sending out Client Notices to the applicants.

Key responsibilities in this position include:

Based on the business requirement created complex/advanced reporting solutions by creating Dashboards using QlikView.

Involved in complete process of QlikView life Cycle by Gathering requirements, performing ETL on the data, Building Interface -Dashboards and Distributing the reports to the stakeholders.

Created Dashboards using guided Analytics feature while linking all the tables and boxes on the Sheet.

Connecting different Tables to a specific column by using Script Editor and making changes to the code in the script editor.

Gathered and loaded data from various data sources into the QlikView. (.CSV, Excel, Oracle)

Created Dashboards using different tools like List box, MultiBox, Bar Chart, Line Chart, Pie Chart, Container Box, Drop Downs etc.

Analyzed and compared the solution on Dashboard by comparing the data in the raw source file.

Worked on QlikView server to load the reports and manage the user access to these reports along with scheduled refreshing and sending out reports of the incidents created on a daily basis.

Create, design, and review test scenarios and test cases along with documentation and executing of test cases for Forms Designing on Adobe Live Cycle.

Keeping track of the defects and following the defect management workflow in ServiceNow (Defect Management Tool).

Meeting and discussions with Developers, Business Analysts and Client to define and establish system requirements and goals.

Working on Client Notices Module that takes care of sending crucial information to the client.

Involved in initial setup of the Adobe LiveCycle tool and resolved the deployment issues.

Using Adobe LiveCycle Designer and Workbench ES3 to develop notices and forms as per the design document and deploying the same using LiveCycle Archive.

Developing and modifying existing forms for design, functionality and Validation with JavaScript for Conditional display of the content in the form.

Running daily batch jobs in Production environment and sending out different types of letters and Notices to Clients every day using StreamServe Control Center Tool.

Performing complex SQL queries in different tables in DB2 to analyze the issue at hand also checking logs to do the Root Cause Analysis of the issue.

Performing Functional, Regression, and Integration testing to validate after the issue is resolved.

Software/Tools: QlikView 11.0,12.10, Adobe Livecycle SuiteES3, Adobe LiveCycle Designer, SQL, XML, HTML, MS Excel, Selenium IDE, JBOSS

2014 – 2016

QA Analyst / Adobe LiveCycle Developer, Deloitte(MHBE), Camp Hill, PA

Mr. Shah worked on Reports & Notices. Notices are sent out to consumer who enroll in Maryland State Health Exchange in medical insurance through State and Federal funded programs like Medicaid, CHIP etc. Generated several notices and reports such as consumer notices and worker reports.

Key responsibilities in this position include:

Working in Agile environment and involved in Sprint planning, daily stand up meetings, sprint review and retrospective.

Working closely with Business Analyst to understand the business requirements.

Preparing test scenarios and test cases for 20 different types of notices based on requirements in Excel and exported them to JAMA (Test Management tool).

Attending SCRUM (standup) calls and defect triage meetings as part of SDLC.

Reviewing test cases and providing input on the test cases and scenarios.

Convert business requirement into Dashboard Views and Designs and conduct relevant research, data analysis, and create reports using Tableau Desktop.

Migrated reports from Excel data source to ServiceNow dataMart. These reports were sent out on daily basis to different stakeholders.

Working on developing PDF notices templates by applying changes to existing forms for design, functionality and validation using Adobe LiveCycle ES3.

Wrote JavaScript for conditional content in the notice and Unit tested the notice after the changes via Render Notice functionality.

Maintained and managed different versions of the LiveCycle folders in the Workbench.

Created static and dynamic text using JavaScript and displayed the address of the consumer such that it shows on the plastic window of the envelope.

Unit tested the notices by giving sample XML input to the notice template by modifying the XML with different cases.

Used different functions in Adobe LiveCycle ES3 like Fragments, Bindings, Tables, Signature field, Calculations, DropDown Fields, Barcodes, PrintButton, etc.

Created and Deployed LiveCycle Archives files to deploy the .xdp’s to the higher environment.

Developing and modifying automated scripts using Selenium IDE tool using HTML.

Reading logs to understand the root of the issue and reporting the same.

Performing Back End testing by executing SQL queries to get Health enrollment details from DB2 using IBM data studio.

Writing complex SQL queries to get the desired data.

Performing verification and validation of EDI transactions in 834 file sent to insurance carriers. And involved in running and maintaining various batches to generate various files and notices.

Performing verification of records in 8001 file sent to MMIS.

Also involved in bulk service testing using SOAPUI tool in order to validate the Mock/Hub data presence.

Good understanding of ECM (Enterprise content management), extensively involved testing and developing notices sent to customers and documents received from customers by the health exchange through FileNet system.

Actively involved in Performance testing using RPT (Rational Performance Tester) tool to run Load test for monitoring performance of the system and sending out status reports before the application going to Production.

Software/Tools: Adobe LiveCycle SuiteES3, Adobe LiveCycle Designer, SQL, XML, HTML, JIRA, SOAPUI, MS Excel, Selenium IDE, RPT, JBOSS, WebSphere, Jenkins

Education

Masters in Electrical Engineering – San Jose State University, San Jose, CA (2012-2014)

Bachelors in Electronics Engineering – Sardar Patel University, Vidyanagar, India (2007-2011)

Technical Skills

Hardware, Software, Languages, Operating Systems, etc.

Languages: Python, JavaScript, HTML, SQL, XML, UNIX

Analytics/ETL Tools: QlikView - 11.0,12.10, Qliksense, Tableau - 10.1,10.2, Informatica Big Data Management, MS Excel

Form Designer: Qlik Nprinting (Nov 2018), Adobe LiveCycle Designer and Workbench ES2 and ES3, Adobe Acrobat Professional

Databases: Postgres, DB2, MS SQL Server, My SQL, Oracle

Technical Tools: JIRA, Selenium IDE, Rational Performance Tester, SOAPUI, HP Quality Center/ALM

Other Tools: TOAD, PUTTY, MS Office

Contact this candidate