•Designs, develops, and implements BI services including reports, metrics, dashboards, and data marts through utilization of tools in the Epic business intelligence suite of applications•Develop, configure, maintain, and support data and analytics solutions in Microsoft Business Objects, SAP Crystal Report and Epic Cogito. •Works on SQL (Structured Query Language) relational and multi-dimensional database structures, schemas to create stored procedures, views, and queries.•Develop ad-hoc data extracts to support the needs of decision makers across the organization.•Facilitates system wide data integrity and standardization as identified by system leaders and/or functional quality teams.•Leads meetings with internal/external stakeholders from physician groups, nursing, information systems, clinic operations, management, executive leadership and reporting.•Consult with business executives and C-Suite management to create and manage roadmaps for teams of analyst, developers, administrators, and architects•Follows and leads formal best practices to validate and verify the solutions created meet end user's immediate clinical requirements and make corrections or optimize as necessary.•Reviews upgrade documentation related to Epic Cogito features and BI content to determine how to implement the changes.•Provides support when issues arise to maintain the integrity of the BI solution.•Documents testing and implementation of requested changes to Epic systems in accordance with current change management procedures.•Resolves incidents and requests independently within SLA timelines. Takes ownership and resolves incidents and requests with minimal dependence on other team members.•Documents main points, issues and key decisions and communicates project and team status to internal and external audiences.•Completed and maintaining technical training requirements, including Epic certifications and any additional third-party tools as needed.

• Serve as the data warehouse analyst for the Epic Cogito business intelligence suite• Designs, develops, and implements BI services including reports, dashboards, and data marts. • Responsible for validating and maintaining system functionality and performance during routine upgrades and quarterly patch updates• Responsible for validating and maintaining system functionality and performance during routing upgrades and quarterly patch updates• Responsible for data validation and identifying data gaps between source systems and the warehouse• Assist in the maintenance of data integrity, security, and privacy and minimizing data anomalies• Develops, maintains, and validates reports, scorecards, and dashboards in Business Objects and BI tools• Assist in the creation of documentation that defines data standards, requirement specifications, and business processes.• Assist in the development, customization, and maintenance of a training program for the warehouse, data models, and BI applications and participate in ongoing training of clinical end users.• Assist in the creation and support of a decentralized end user group by providing support, extensive interaction, and assistance in problem resolution.• Serves as a subject matter expert on the healthcare data warehouse and demonstrates a solid understanding of the Cerner PowerInsight data model. • Supports all aspects of the healthcare data warehouse business intelligence and analytics program.

• Implemented automated reporting and predictive analytics for Americas digital customer, digital partner, and digital seller• Worked on HDFS to store and access huge datasets within Hadoop and analyzing Hadoop cluster and different big data analytic tools including MapReduce, Hive and Spark• Collaborated with Customer Service teams to maintain CRM, Loyalty Programs, Return on Investment and 360 View of the Customer• Created, maintained and tracked multiple JIRA user stories for covering all use cases related to data cleansing, de-duplication, masking and data quality checks for incoming data• Maintained database via MS SQL Server and data visualization via Tableau to create dashboard data validation reports from clients’ marketing data, syndicated sources and economic data to inform expected econometric modeling results• Built and validated logistic regression models that used clustering methods for variable selection to assist the loyalty program in predicting future product buyer behavior using SAS

• Working in Office of Technology Management department that deals with the commercialization of technology• Optimize the process for patent submission system to reduce total time for research submission in the application• Analyze and create SSRS reports on the research data to present to the business stakeholders • Manage all site content including homepage, product pages, curated landing pages, A/B testing, and overall website optimization to improve conversion rate and user experience• Redesigned the website using WordPress, HTML, Java Script and created Google Analytics property to measure and track behavior.• Write sql queries to prepare reports out and merge information of the Central Database Repository• Update and maintain Oracle database information to handle patent research related information• Assist the department in day to day functional activities related to handling of disclosure forms, agreements and finances

• Design and development an effectual marketing strategy for the client BAMM!, a web based platform, by market research, market segmentation, customer profiling, identifying key features and marketing medium to promote the platform among UIC students• Planned and implemented the marketing strategy by market research, market segmentation and customer profiling using clustering• Developed marketing programs including web development, email marketing, online advertising/lead generation, mobile marketing, social media, and other affiliate marketing opportunities• Developed, executed, tracked and analyzed direct and interactive broad reach executing ROI-driven marketing campaigns across Chicago and evaluated results to optimize the effectiveness of the campaign• Proposed recommendations for distribution and roll out plan by assessing usage and conversion rate using regression and predictive modelling to ensure sustainability

• Building Database Management System using Microsoft Access-Office 365 tool which will help to store and fetch student’s information into the web based database that can be accessed across the organization• Designing the database that will allow to search item by any field. Also, provide an User Interface to add, update and fetch the information• Creating reports out of the Central Database Repository easily• Maintaining and updating the database by making necessary changes as per the new requirements

• Developed a publicly accessible, in-house managed, relational database system using MySQL for data organization & site architecture for the research center based on end user scenarios, technical constraints and business requirements• Installation, configuration and operational management of MySQL servers in High Availability Environment• Designed and developed a compatible front-end using PHP, Java Script, HTML to implement search functionality on existing resources in the form of articles, manuscripts, books and external links• Facilitate the new system with consolidating separate pages/documents on their website and implementing a keyword based search feature for users•Interacted with business owners to identify business system needs, proposed solutions for business problems and evaluated alternate methods to increase efficiency of the overall process.

• Analyzed the key business processes to find the optimal strategy for enhancing the online presence of the organization• Created an effective social media marketing strategy by performing competitor analysis, A/B testing and identifying key metrics to achieve the target sales figure

• Used SQL Server Management Studio and Report Services to develop and troubleshoot complex SQL queries, maintained reporting with SSRS and ETL development with SSIS toolset• Built efficient ETL packages with SQL Server Integrated Services (SSIS) to fetch, cleanse and transform data from several types of sources • Designed and built the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose• Generated various type SSRS reports that could be used to send information to different vendors, clients and managers• Monitored performance and optimized SQL queries for maximum efficiency and created dashboard using Tableau for the business • Identified clients’ needs and developed SQL queries to manage and create dashboard using Tableau for the business analysis• Requirement Gathering, Impact Analysis, Coding, Bug Fixing, Resolving Technical Issues and Testing of client specific applications.• HCL Spot Award to spearhead Six Sigma Project by automating the test cases that reduced the manual effort by 30% and customer benefit was more than $50,000• Worked with all phases of the software development life cycle (SDLC) with business process models: Waterfall & Agile (Scrum) methodologies. • Created Project Plan, executed and tracked Test Plan Documents, Test Cases, and Test Scripts• Performed various testing like sanity, smoke, regression, white box and black box testing• Ensured quality of the product by performing various audits and plays the role of Product Quality Analyst• Created Technical documents and business documents like Business Requirements Document (BRD), Functional Requirement Document (FRD) and Functional Specification Document (FSD)• Provided training to the new team members on emerging technologies and usage of various customer tools• Consistently achieved good customer satisfaction by efficiently translating customer needs to technical solutions