Data Assistant

Chandrakant Patel

Ellicott City, MD ***** 901-***-****

*********@*****.***

Career Summary

MicroStrategy Architect • Data Analyst •AWS Solutions Architect

A highly resourceful, multi-certified technology professional with 18 years of experience in multiple domains, including Medicare, Medicaid, manufacturing, distribution, retail, pharmaceutical and Geographic Information System (GIS).

A productive contributor who excels in delivering the right solutions and support by incorporating the industry’s best practices to transform requirements into efficient solutions.

8 years of experience in Data Warehousing, Business Intelligence systems, and OLAP environments using the MicroStrategy product suite.

Strong understanding of relational databases, non-relational databases, ETL/ELT processes, Data Lake, and Data Warehousing in traditional and cloud environments (Amazon Web Services (AWS), Microsoft Azure, and Snowflake).

Hands-on experience on building and publishing advanced statistics, predictive models, and machine learning algorithms using various libraries available for Python.

AWS Certified Solutions Architect Associate, MicroStrategy Certified Architect (MCA), Application Architect (APA), Analyst (ANL), and Data Scientist (SCI).

Technical Skills

BI/OLAP: MicroStrategy, Tableau, SAS, Informatica, SAP BusinessObjects

Languages/Framework: VB.NET, C#, ASP.NET, Python, Visual Basic, VBA, Java

Database: Teradata, Oracle, MSSQL Server, MongoDB, PostgreSQL, DB2, MS Access

Other Tools: Visio, Project, Toad, Teradata Viewpoint, SQL Assistant, Studio

Professional Experience

Signature Consulting Group (SCG), Windsor Mill, MD Dec ‘13 to Present

MicroStrategy Solutions Architect, Technical Consultant

Developed and implemented Claims Summary Information (CSI) MicroStrategy reports through the One PI Portal using objects, cubes, freeform SQL, and logical views.

Identified reports for performance improvement using Intelligence Server statistics and execution statistics from the database. Improved report performance using Intelligent Cube, report scheduling, caching, optimizing SQL, and updating various VLDB settings at different levels to manage spool space, manage temp space, and eliminate CPU skew.

Actively participated in the development of data governance processes and procedure initiatives. Performed impact analysis and developed release schedules for required changes.

Presented CSI reports at the PIDUG User Group meeting and assisted users with issues.

Installed and configured SAS Studio, SAS Enterprise Guide and other SAS products and tools for ISC Research Analysts and assisted them with resolving technical and configuration issues. Updated and managed the licenses for various SAS products.

Developed workflows to capture the statistics for the file upload process to evaluate the performance of the Medicare Advantage (Part C) Risk Adjustment Data Validation/Central Data Abstraction Tool (RADV/CDAT) Modernization on Azure. Created different test files that can be used by the Independent Verification and Validation (IV&V) team for performance and anti-malware testing. Supported performance and regression testing for CDAT Modernization.

Developed workflows to perform automated verification of enrollee data, distributed workloads for manual validation to various team members. Created visualization dashboards utilized by management for decision-making purposes.

Part of the Adaptive Capabilities Testing (ACT) assessment team that developed the assessment plan, report, and CAAT file. Assessed Core Controls against relevant test methods listed in the Acceptable Risk Safeguards (ARS).

Worked with the Bundled Payments for Care Improvement (BPCI) Advanced Incentive Program team to support various task orders and assisted them in automating data extraction and verification processes. Developed a tool to create Participant Profiles (PPs) using Python and the .NET framework. Built setup and deployed the tool.

Worked with the Oracle DBA and business analysts to identify data elements for the Quality Measure Assessment Tool (QMAT) MicroStrategy reports. Designed and developed QMAT reports. Worked with the MicroStrategy admin team in implementing security filters and design mapping with user groups.

Technologies: MicroStrategy, SAS, SAS Viya, .NET, Python, Teradata, Viewpoint, Studio Express, MySQL, Azure, Oracle, Anaconda Navigator, JIRA

Maricom Systems Inc., a CSRA Company, Windsor Mill, MD July ‘09 to Nov ‘13

MicroStrategy Solutions Architect, Technical Lead, .NET Developer

Led a team of developers to build a MicroStrategy reporting project (CSI) utilizing the IDR database as the source and developed aggregated reports for the Medicare Parts A and B claims data.

Analyzed the Health Care Information System (HCIS) reports, databases, and ETL processes from the NCH and NMUD data streams. Investigated and documented the report usage pattern, prepared various metrics to identify crucial reports, and persuaded CMS to use a phased implementation approach.

Developed selected reports as part of the Proof of Concept (POC). Recommended an approach using Intelligent Cubes to eliminate legacy ETL processes and individual data marts. Designed and developed trending reports that allowed users to select metrics.

Worked with the MicroStrategy admin team, the EUA team, and other teams at CMS to implement specific role-based access control of user access to the CSI reports.

Presented a technical overview of the CSI project to the CMS Technical Review Board (TRB).

Designed and implemented a plan for object migration, project backups, and code isolation.

Worked with the MicroStrategy admin team and the IDR DBA team to understand resource availability for the project. Developed different versions of reports to collect statistics, justify resource requirement, and configure changes to best utilize the available resources. Negotiated the availability of compute, memory, and storage resources.

Created and maintained schema objects (such as attributes, facts, transformations, and hierarchies) and application objects (like filters, prompts, metrics, consolidations, and custom groups). Designed and developed drill down reports using drill maps and links.

Tested reports by running queries against the warehouse using Teradata SQL Assistant and compared results with the MicroStrategy report results.

Updated the HCIS front-end code, built setup, and performed the installation. Updated the physical and logical data model for the database changes. Prepared the architecture and data flow diagrams. Removed hardcoded passwords and implemented encryption to remediate security findings.

Updated the application code to allow for the adoption of Medicare Severity DRGs (MS-DRGs). Implemented changes in trending to allow all crosswalk codes to get incorporated into the final calculation of all claims submitted. Modified the HCIS front-end code to implement version 5010 of HIPAA standards as well as the NPI code for various claims.

Technologies: MicroStrategy, Teradata, Viewpoint, SQL Assistant, erwin, Visio, Project, Visual Basic, Oracle, Informatica, ADO, Data report, Map InfoX, MDAC, CAPICOM SDK, Oracle

Hornell Brewing Company Inc., Lake Success, NY Dec ‘08 to June ‘09

.NET Developer

Developed the interface to import, validate and convert data from various data sources. Created a utility to compare various data files (Excel, text) and presented color-coded data visualization to make the changes apparent. Generated reports and Excel files to identify data exceptions.

Developed the utility for data searches across multiple databases based on various parameters.

Technologies: VB.NET, ADO.NET, Oledb, Crystal Report, MS Access, Oracle, Foxpro (.dbf)

Bed Bath and Beyond, Union, NJ April ‘08 to Nov ‘08

.NET Developer

Modified modules to incorporate the changes required in Sign System HQ and store applications to make the product sign available based on the real-time product inventory at the store. Utilized price data from the DB/2 database and the local table to allow authorized users to perform required updates for sales.

Modified various modules to customize certain features for concepts (Bed Bath and Beyond, Buy Buy Baby, Harmon, Christmas Tree Shop) using configuration files and code changes.

Built setup for the HQ and Store applications, collaborated with support groups to roll out updates to stores, and used VBA with MS Access to create new sign formats for the libraries.

Technologies: VB.NET, C#, ADO.NET, DB2, AS/400, MS Access, VBA, TortoiseSVN, AnkhSVN

Liberty Medical Inc. (Medco), Port Saint Lucie, FL May ‘07 to Jan ‘08

.NET Developer

Developed design specifications for changes in existing applications. Created classes for VB.NET to interact with web services, create and update forms, and implement web services from SAP BusinessObjects to validate addresses against the USPS database. Implemented ArcGIS Web Application Development Framework (ADF) to analyze GIS data collected to better route the main-in orders and manage inventory at the dispense centers.

Created/modified tables, views, and triggers; implemented logic using stored procedures and functions for performance and flexibility. Worked with linked servers to allow remote data to be retrieved, joined, and merged with local data

Technologies: VB.NET, ADO.NET, ArcGIS, XML, XSLT, SAP Business Objects, MS SQL Server

Scanpoint Geomatics Limited, Ahmedabad, India Dec ‘04 to Feb ‘07

Senior Programmer

Team leader for the development of six application modules of IGiS, a platform for Geographic Information System (GIS) and Image Processing (IP).

Completely architected the application design and evaluated/recommended technologies (including PostgreSQL and Crystal Report). Involved in technology selection team, coordinated with the team members of various platforms and domains like VC++, VBA, IP/GIS. Prepared development methodology for the development of a library and six customized applications.

Designed prototypes of various modules. Developed the ActiveX timer control in VB 6.0 and used it in Excel to refresh data based on a time interval. Designed and developed the user interface in MS Excel using VBA and performed the initial testing of the application with NMEA raw string and GPS live data. Developed modules to allow input for various forms.

Technologies: VB.Net, C#, VB 6, DLL, SGL Library, .NET compact framework, PostgreSQL 8.1, MS SQL Server 2000, Crystal Report, InstallShield, Windows CE, ADO.Net, OLEDB, ODBC

Education

Master of Science, Information Technology

Bachelor of Science, Physics

Contact this candidate