Collaborated closely with external vendors, business teams, other cross functional I.T teams to implement health care applications for Membership, Claims, Encounters, Providers, Care management, Authorizations and Finance processes that operates for more than 2.2 million members.-- Lead requirements elicitation, business process, workflow mapping and data analysis using data capture and modeling technologies, methods and tools that include MS Visio, SQL, PostgreSQL, Advanced Excel and Informatica(ETL).Business systems analyst in implementation of data warehouse and effective business intelligence framework that consolidates data from all internal and external applications and conforms to data governance policies for data analytics, building reports to inform strategic and key decisions and support state or federal agency guidelines.* Used SQL queries, Tableau and OBIEE to perform advanced data analysis and develop reports/dashboards to provide business insight for various business departments.-- Improved Authorization turn around times by 25%-- Correct Submissions from trading partners by 30 %-- Assist Special investigations unit team to detect abuse and fraud-- Accurate and timely submissions of DHCS requirements avoiding huge penalties and fines.* Provide Self Service capabilities for Encounters business unit to monitor new Encounters application processing that improved overall operations by 26%.

Implemented Salesforce CRM platform for clients to handle Member and Provider Complaints and new Provider portal to track provider contracts.-- Lead requirements elicitation efforts to enable clients meet their goals.-- Performed Gap Analysis, root cause analysis, business process and technical analysis and documented workflows and processes to help plan, design and develop CRM solutions.-- Developed reports and dashboards in Salesforce to track agent metrics and productivity.-- Performed Salesforce administration and development of process builders, workflows, triggers and lightning components to build few functionalities.

IT Project Manager , Graduate Research• Analyzed the Business, Organizational and technology issues and applied project management body of Knowledge (PMBOK) guidelines and principles to manage the project effectively.• Developed the WBS and Project Charter using MS Project Management to calculate timelines, schedules, resources, costs and scope.• Designed the Risk Management policy to analyze, monitor and mitigate risks associated with the project.• Developed the Stakeholder Management Strategy and Used Gantt charts to update project progress.• Prepared a procedure for Integrated Change Control and Developed the Quality Assurance Plan for the project.

Predictive Analysis using SAS, Graduate Research• Applied supervised and unsupervised learning techniques with SAS E miner to perform extensive data analysis on crimes in Chicago. Performed analysis on Crimes in Chicago to predict crime prone community areas on weekdays, weekends and different times in a year.• Performed text mining, Cluster analysis, Regression analysis, Decision tree development, Memory based reasoning to predict crimes possibility.

Database Management Systems and Data Warehousing, Graduate Research• Implemented a Web based Reporting system based on 3-tired Internet architecture.• Designed the database and a user management policy for data access control using MS SQL and Advanced Excel.• Moved data efficiently from data sources to target using Microsoft SSIS, SSAS and SSRS package and tested the database integrity during the data migration process. Developed SQL Server Stored Procedures.• Designed ER Diagrams, Schema Definitions using MS Visio and Erwin Data Modeler.• Involved in developing web pages using JavaScript, HTML and web services using XML, WSDL and SOAP.• Involved in System testing and Unit Testing. Generated and Built Interactive Dashboards.

Build and maintained Business Intelligence dashboards for different departments to provide actionable insights for management which benefited in decision making and increased revenue by 17%.• Worked with cross functional departments in gathering requirements and determine Key Performance Indicators (KPI’s) for various operational and analytical reports/Dashboards.• Assisted BI and ETL developers with functional specifications for building Data infrastructure.• Developed various queries involving various tables to analyze data in source systems and resolve issues.• Defined and documented client requirements in structured formats and created data mapping.• Documentation from source to destination for new and existing clients.• Developed reporting solutions for large data sets (Big Data) using SQL, SSRS, and SSIS, Hadoop.• Extensively analyzed existing data models and provided insights for future projects.• Heavily worked on Data Quality Analysis, Data lineage and Data Standardization data structures, data. Base design, data warehouses, business intelligence/analytic tools, ETL, and data integration.