MANJARI KALRA
Naperville,IL
Summary
Accomplished Senior Systems Analyst with a proven track record at Blue Cross Blue Shield Association, adept in BI/DW Management and fostering team leadership. Spearheaded multi-million-dollar Data Warehousing initiatives, achieving over 90% customer satisfaction through innovative solutions and performance optimization. Expert in Agile methodologies and process improvement, demonstrating exceptional adaptability and system analysis skills.
Overview
20
20
years of professional experience
Work History
Senior Systems Analyst
Blue Cross Blue Shield Association
09.2010 - Current
- Responsible for defining, analyzing, designing, and delivering several large-scale muti million-dollar initiatives that are Data Warehousing/Business Intelligence applications with several terabytes of claims data received from 33 BCBSA’s plans all over the country enabling them to query their data in real-time using BI applications
- In depth understanding on handling every aspect of the project from requirements gathering, data analysis to working with development teams and test plan execution, achieving, and maintaining 90% customer satisfaction
- Thorough understanding of the healthcare industry including Eligibility, Enrollment, ITS/B2 Transactions, Claims, MMI, and conversion of ICD-9 and ICD-10
- Responsible for ensuring that policies and practices comply with HIPAA laws and regulation when implementing a selected system, implementing best practices, and providing the relevant solutions roadmap
- Proficient in all the SDLC stages of Agile methodology using Rally/JIRA, with input from Business (JAD, Problem Framing, Ideation Techniques), System Architect/Engineering, and other stakeholders
- Elevated scrum team execution, boosting customer confidence and satisfaction
- SME in requirements gathering, data analysis, development, testing, and implementation of BI reporting solution that support Inter-Plan Data Solutions (IPDS) group that leverages data assets and provides Plans with decision support to effectively compete in the National Account marketplace
- SME on supporting Consortium Health Plans (CHP) business practices by helping reduce multiple data feeds from plans to CHP to support Blue Plan National account sales and marketing goals
- Working on Blues System of Intelligence (BSI) platform that integrates key strategic data assets from the existing solutions like the National Data Warehouse (NDW), Master Member Index (MMI), Blue Provider Data (BPD), and a broad array of BHI data assets, into a single, flexible architecture to leverage advanced analytical tools and generative AI
- Working on the fast Healthcare Interoperability resource initiative
- Maintaining IG for FHIR using Trifolia and converted plans proprietary formats into HL7 FHIR layouts
- Integrating clinical data through CCD messages from the Clinical Data Exchange into MMI Services
- This will improve the system’s standards-based interoperability which will enable improved member healthcare experience and support Plan compliance with CMS interoperability regulations
- Strong ability to define problems, collect data, establish facts, and draw valid conclusions in a variety of situations by staying quality focused, proactive, persistent, and highly organized
- Provided expertise in response to complex data problems /situations for the enterprise including timely completion of ad hoc reports and customer consultation requests enabling data driven decision-making for senior leaders
- Lead positive and trust-based relations with business partners, Blue Plans, Blue Health Intelligence [BHI], managed service vendors and other partners
- Single point of contact, and subject matter expert for all customer tickets and enhancement requests
Lead Programmer Analyst – Global Data Warehouse
McDonald’s Corporation
03.2007 - 08.2010
- Managed a cross functional team of developers and product verification professionals
- Supervised activities of the analytics team members and ensure they provide completed and accurate information to stakeholders
- Held discussions with the business managers to document the current business baseline, preparing of future process model and reporting requirements
- Analyzed business requirements, performed data analysis using TOAD, and strategies to understand business needs
- Revitalized the use, and promoted the importance, of data derived insights, at different units of analysis, to support strategic planning and tactical decisions
- Stressed the need for the creation and use of metrics/KPIs
- Led teams across different areas for successful migration from DB2 to Vertica platform and achieved 85% improvements in reports runtime and query performance
- Redesigned a DW/BI process that includes data cleansing
- Data profiling, ETL, metadata repositories creation, and report generation reducing the operational/overhead cost by 20%
- Systems and process improvements which reduced average monthly defect count from 170 to 30
- Developed initiatives with a focus on organization growth based on operational data and digital solutions
- Worked extensively with Teradata database v12.0, Multiload, Fastload, and BTEQ scripts to load data
ETL Specialist
UPP Technology (Client - Anheuser-Busch)
05.2006 - 03.2007
- Responsible for handling 'high profile' projects which are often complex in nature, with vague or no business requirements and always time critical
- Worked with the Project Manager in creating Statement of Work and Project Scope Statement, detailing all the project exclusions, constraints, and assumptions
- Worked with the technical team in getting estimates for the work required
- Created project plans using Microsoft Project
- Created a supportive team environment that was defined by collaboration and knowledge sharing, high retention rate within the team
- Oversaw Technology Naming Standards committee that defined and established new server, computer, and user naming standards region-wide
- Analyzed one of our most complex packages surrounding customer contacts then applied new business rule architecture to make it more flexible and easier to modify
- Coached Jr
- Team members on internal system knowledge as well as technical skills related to performance tuning, organization, readability, and usability
- Using Ascential DataStage Enterprise Edition designed the procedures for getting the data from all systems to Data Warehousing system
- Implemented Type 2 slowly changing dimensions
Senior Programmer Analyst
Cogent Infotech (Client - Aon Corporation)
05.2005 - 05.2006
- Hired as a lead to align business strategic initiatives for operations department
- Standardize & streamline companywide financial systems including ERP, data warehousing and BI system
- Conducted In-depth technical analysis of all systems including architecture and disaster recovery and business continuity
- Created work breakdown structures and developer assignments
- Involved in all aspects of requirements, development, data extract, load, transformation, and presentation of information
- Lead development of all operational support programs and processes, which contributed to securing long term business, optimizing levels of productivity, and sustaining overall project success
- Met delivery dates, collected status in weekly status meetings, identified issues and solved problems
- Assisted team in creating DataStage jobs, batches, job sequences and tuned them for better performance
- Worked extensively with TOAD for Oracle and Sql Server to test data, create tables, define keys, incorporate foreign key constraints, and give grants
ETL Consultant
ATOS
07.2004 - 04.2005
- Used Ascential DataStage to design the procedures for getting the data from all systems to Data Warehousing system
- Analyzed Business Requirements, Analytics, and strategies to improve the business
- Designed and developed the data warehouse environment
- Created DataStage jobs, batches, job sequences and tuned them for better performance
- Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
- Used Toad for writing extensive sql queries to analyze data, identify production issues and help answer business questions
- Conducted knowledge sharing sessions within the teams to better understand business & domain which are the essential factors to drive & develop the project
Education
Master of Science - Computer Sciences
Illinois Institute of Technology
Chicago, ILBachelor of Engineering - Computer Science
Aurangabad University
IndiaSkills
- BI/DW Management
- Problem Framing
- Process Improvement
- Communication Skills
- Agile/Scrum Methodologies
- Innovation
- Performance Optimization
- System and Data Analysis
- Planning & Prioritizing
- Adaptability
- Requirements Gathering
- Team Building & Leadership
Professionalaffiliationsandcertifications
- AWS Certified Cloud Practitioner
- Certified SAFe 5 Agilist
- Agile Scrum Master Certified
- Project Management Certificate
- From Ideas to Action course from IDEOU
- AHIP Healthcare Management (AHM250) certified
- Attended HL7 FHIR Connectathon
- Attended HL7 FHIR Fundamental training
- DataStage Essentials for Enterprise Edition Training by IBM
- Database/Data warehouse and Internet technologies
- Member of Indian Institute of Computer Science Engineers
- Completed Developing a Global Mindset (DGM) course from McDonald’s Hamburger University
- Completed MicroStrategy Project Designer Track
- Active in attending Teradata and Datastage user group conferences including the Infosphere
Timeline
Senior Systems Analyst
Blue Cross Blue Shield Association
09.2010 - Current
Lead Programmer Analyst – Global Data Warehouse
McDonald’s Corporation
03.2007 - 08.2010
ETL Specialist
UPP Technology (Client - Anheuser-Busch)
05.2006 - 03.2007
Senior Programmer Analyst
Cogent Infotech (Client - Aon Corporation)
05.2005 - 05.2006
ETL Consultant
ATOS
07.2004 - 04.2005
Master of Science - Computer Sciences
Illinois Institute of Technology
Bachelor of Engineering - Computer Science
Aurangabad University
Similar Profiles
Joel SalrinJoel Salrin
Production Support Analyst II at Blue Cross Blue Shield Association, BCBSAProduction Support Analyst II at Blue Cross Blue Shield Association, BCBSA
Emily SloanEmily Sloan
Executive Assistant at Blue Cross Blue Shield AssociationExecutive Assistant at Blue Cross Blue Shield Association
Crystal BrownCrystal Brown
Business System Analyst at Blue Cross Blue Cross Blue Shield of Tennessee (Facets Billing)Business System Analyst at Blue Cross Blue Cross Blue Shield of Tennessee (Facets Billing)