December 2018 to Present
Functional Architect/Integration Analyst Manager – Enterprise Data and Integration
Employer: Allegis Group Inc, Hanover, MD
Integral role on a diverse and specialized team focused on process improvement initiatives. Impact business objectives by developing solutions, creating algorithms, and providing cost-effective data and process solutions.
- Managed the team of 5 developers, 2 QA Engineers, and 2 Systems Analysts for their day-to-day priority, direction, and career growth onshore and offshore.
- Responsible for integrating the enterprise data from multiple sources to a single endpoint (APIs) and providing data on request with top-notch security, quality, and reliability.
- Communicated with the business of various domains and technical team to translate the “Business Needs” to technical interpretation and sharing the “Technical Approach/problems” in the “Business Speak.”
- Integrated various data science process with front office (Salesforce CRM) and back office (Peoplesoft ERP) with real-time or near real-time data exchange.
- Triaged and managed any production related issues and escalate and communicated through right channels.
- Managed data cleansing process via Informatica MDM and Address Doctor services for data science, front office and back office.
- Created and maintain the technical specifications like process flow chart, architectural diagram, exception, and normal data flow.
- Defined the Program Increments and broke large epics to sizeable portfolios and user stories that could be quantified and measured in multiple dimensions.
- Overtook the responsibilities that include supporting cloud platforms, crafting data models, and defining strategic data standardization that increased the team throughput and improved the quality of the data.
- Made webservices on MuleSoft Platform as a crucial process for the company by delivering efficient designs of real-time or Near-Realtime data needs for the complex systems.
- Initiated new data quality initiatives such as talent dedupe based on parsed resume, Unique ID across multiple platforms.
- Spearheaded Data Quality, MDM, team for the enterprise integration projects across the organization.
- Determined the Critical to Quality (CTQ) data elements to optimize the quality validations to focus on process needs.
- Worked with internal users to resolve quality issues and develop reports to present status to management.
- Created new webservices integration from Data to flow from one system to multiple systems with rules including initial load and event or time-based data exchange with complex rules.
- Trained in Agile and Scrum processes like Kanban, SAFE and Agile 2.0 Manifesto.
June 2017 to December 2018
Lead Business/System Analyst – Enterprise Data and Integration
Employer: NorthPoint IT, South Lake, TX | Client: Allegis Group Inc, Hanover, MD
Focused efforts on functions that included designing process and data flow for a solution. Maximized results by collaborating with architects, developers, SAs, and stakeholders. Supported organization-wide objectives via preparing materials for design reviews and assisted in targeted technical support.
- Streamlined processes for the Analyst and Project teams on getting and finishing deliverables in time.
- Developed and implemented standardization on multiple steps of the Analyst team.
- Lead for the integration System Analysts group for their deliverables and performance.
- Determined the priority for the intake work for the team based on leadership and deliver leadership insight.
- Communicated and discussed the needs of business, technical teams, and processes to provide better solutions and an effective approach to achieve the goal.
August 2013 to June 2017
Lead Data Quality – Claims and Provider Data
Employer: Anthem, Inc, Columbia, MD
Coordinated strategic processes were centric to ensuring smooth data deployment and production release. Utilized data models to ensure efficiency is not compromised. Affected departmental success by validating data model conflicts, ensuring quality control, and determining CTQ data elements.
- Helmed the creation of a Data Quality team as an essential part of the organizational process that saved nearly a quarter of processing time with production runs.
- Created a data lineage tool to provide business users with vital data quality information to make correct decisions.
- Recovered potentially $2M in loss from poor quality by generating standardized tracking methods.
- Saved $5M annually by automating processes to review exception reports.
- Created various flows to define the Business, Process, and Data that streamline the understanding across the board.
- Took ownership of data cleanup, standardization, and governance efforts across departments.
- Used complex SQL in MS SQL and IBM Netezza to analyze the data by slicing and dicing and presented in reports that are easy to read.
- Worked with internal users to resolve quality issues and develop reports to present status to management.
- Established an on-going process to maintain quality data and define data quality control mechanisms, and data quality audit processes.
- Created an automated tool that provides dynamic data specification for department’s needs.
- Created automated process to monitor daily on quality metrics to proactively identify issues related to data.
- Determined the Critical to Quality (CTQ) data elements to optimize the quality validations to focus on process needs.
- Reviewed, analyzed, and ensured the quality of data loaded into the database system by utilizing MSSQL, Netezza SQL and SAS EG-7.1.
- Used statistical process controlled charts (SPC) to be able to determine go/no-go decision for 3 standard deviation variance.
- Responsible for data integrity checks, report anomalies; coordinates with development, clinical, and product teams for resolution.
- Analyzed complex end user needs to determine optimal means of meeting those needs.
- Documented specific business reporting requirements to address complex business needs.
- Created and maintained documentation, reported to Executives for metrics results and informed decision.
- Engaged with programming staff to ensure requirements will be incorporated into design and testing.
- Created written narratives, table charts and graphs to display data. User Stories and product backlogs.
- Performed business process analysis and implemented business process re-engineering techniques.
- Involved in providing technical expertise to define defect remediation process for QA team and provided detailed estimates for the change control process and identified resources and allocated tasks to maximize resource utilization.
- Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
- Involved in conducting UAT to make sure that all the user requirements are catered by the application.
- Worked as a production support as a part of DCU (Data Correction Unit).
September 2011 to August 2013
Technical Business Analyst – Enterprise Data Management
Employer: Inovalon Inc, Bowie, MD
Oversaw Client Data Onboarding functions including data gap analysis, detailed client walkthroughs, data validation, and testing, and managing the client data process flow. Administered oversight on monthly data quality checks. Consistently ensured accuracy and that deadlines were met.
- In charge of Client Data On boarding process for the new clients which include
- Performing Gap Analysis of the Client Data and Data Warehouse requirements.
- To provide Detail Walkthrough clients to the data dictionary and the data requirements.
- Mapping of Client Data for the client to Data warehouse.
- Validating and Testing the Data for Pre and Post Integration process using advance SQL.
- Providing the Product teams client specific Business and Data rules for the client.
- Managing the Client data process flow for timeliness, accuracy and integrity Month over Month.
- Provide HEDIS and Star Rating product data team with Enterprise Data Warehouse guidance.
- Leads data meetings engaging the clients and product teams for any Client Data or Product data related issues. Liaison between Client’s Business/Data team and Inovalon Product team for all the data related issues.
- Validate and perform the Monthly Client Data quality checks to make sure that the product teams have best quality data for their business use based on business analytics.
- Perform research and analysis on any Data warehouse related issues ranging from data analysis of data integration to making sure how the best quality data is made available to the products based on their business need.
- Analyze and integrate various types of HealthCare data file like Member information file (Including CMS MMR files), Member Enrollment file, Provider file, Medical and Rx Claims file, and Lab data file.
- Gather and Document requirements for the new tables for product teams to be used.
- Provide Standard UAT and Documenting for the Change Control Board.
- Discuss with Product team and Technical team to create new tables, table structure and data process flow.
- Manage Vendor data transmission setup for initiation and regulate operations time to time.
- Gather and Document Requirements for in house ETL product upgrade.
- Create process and work flows.
- Create Product Backlog Items and Groom it in the sprint planning meeting.
- Create precise user stories/epics for agile team.
- Provide Acceptance Criteria for dev and QA team.
- Ensure that the team is fully functional and productive and enable close cooperation across all roles and functions.
- Remove barriers and ensure that the process is followed, including issuing invitations to daily scrums, sprint reviews, and sprint planning.
- Facilitate the daily scrums.
May 2010 to September 2011
Sr. Business Analyst – Assurance Advisory and Quality Review
Employer: Asta CRS Inc., VA | Client: Ernst & Young, Cleveland, OH
- Updated scope document during the pre-initiation stage for project approval by the management.
- Conducted the review meetings for scope document sign-offs with SMEs, stakeholders and involved in project planning, project monitoring and control.
- Developed UML diagrams using Visio, UI screen shots and conducted JAD sessions with business team and IT team.