Sr. Business Intelligence Developer July 2017 to CurrentUCare
SAP Business Objects XI R4.2, SQL Server 2012 Description: Capitation is a payment arrangement for health care service providers such as physicians or nurse practitioners.
It pays a physician or group of physicians a set amount for each enrolled person assigned to them, per period of time, whether or not that person seeks care for the providers.
This project involved creating data marts and reports necessary for calculating capitation payment accurately for the providers who contracted with UCare and bursting out reports to each provider in the provider portal.
Responsibilities: Involved in Full project life cycle from requirements gathering to implementation phase.
Analyzed data flow and business requirements to create High and Low Level Design documents.
Guided the ETL developers on how to bring certain data into data warehouse for flexible reporting.
Designed and developed Business objects universes and many complex reports as per the business users need.
Created business objects publications to burst out a single report to multiple vendors.
Performed data validation by developing and executing test plans.
Assisted business users in validating data during user acceptance testing.
Migrated universe, reports and publications from Test to Prod using promotion manager in CMC.
Created custom events in CMC and scheduled publications and reports based on the custom events.
Involved in production support, maintenance and enhancement of the BI Reports.
Sr. Business Intelligence Developer March 2016 to June 2017UCare
SAP Business Objects XI R4, SQL Server 2012, MS Access Description: Reporting analysts generated disenrollment reports every month by manually processing data from multiple source systems.
This project involved decommissioning manually generated reports and re-creating them in data warehouse to operate more efficiently.
This was a high complex project and the reports were distributed to CEO, CFO and other senior managers every month to provide disenrollment summary and detail information.
Responsibilities: Interacted with business users and Subject Matter Experts to gather information to identify and develop business requirements.
Translated business requirements into technical specifications.
Worked with former data analysts to understand the process used in generating the data displayed in the report.
Performed data analysis and deducted special scenarios that need to be addressed differently.
Built SQL Procedures and Functions to manipulate, cleanse & process the data from the source system and stored the data in the analytical database.
Developed recommendations to the ETL team regarding how the data needs to be stored in the data warehouse for data accuracy and for auditing purposes in future.
Created Business Intelligence reports by combining data from data warehouse and analytical database.
Performed data validation by developing and executing test plans and supported user acceptance testing.
Outlined the process to ETL & BI Team on how to maintain the data in the data warehouse and in analytical database for future maintenance.
Rolled out this complex project to production with zero issues.
Involved in production support, maintenance and enhancements of the BI reports in production.
Business Intelligence Developer September 2015 to February 2016UCare
SQL Server 2012, T-SQL, Business Objects 4.0 Description: Project focused on generating reports for auditing vendors.
This project involved implementation of high complex business logic in the reports to meet criteria provided by Department of Human Services (DHS).
Responsibilities: Responsible for translating business requirements into technical specifications.
Engineered several tools and technologies to find the right tool that met business requirements.
Performed data analysis and developed recommendations for business users.
Created several SQL procedures to handle huge volume of data and high complex business logic.
Created business objects reports that address various reporting needs.
Created File and System based events and scheduled the report to run off of the events.
Migrated universes and reports to production using Business Objects CMC.
Project : ICD9 to ICD10 Conversion.
Business Intelligence Developer March 2015 to August 2015UCare
SAP Business Objects XI R4, SQL Server 2012, Java SDK Description: Project focused on converting claims and services data from using ICD9 to ICD10 codes and redesigning existing BI reports according to the change.
The project involved identifying impacted data marts, universe and reports due to ICD 10 changes and modifying them to accommodate new codes.
The transition to accommodate ICD-10 codes enabled users to get detailed level information about patient's medical condition and hospital inpatient procedures.
Responsibilities: Interacted with business stake holders to gather the reporting requirements.
Gathered data requirements needed for the report and designed report layouts for the business to review.
Conducted impact analysis on hundreds of reports in business objects environment by creating java program using Java SDK.
Redesigned the metadata layer and BI reports as per the user specifications.
Discovered discrepancies in the data while developing the reports and brought it to attention to the ETL team.
Assisted business users in validating the data in the reports as well as in the data warehouse.
Involved in migrating the reports and universes from Test to production.
Getting Started with SAP Lumira - issued on 04/19/2018 by SAP.
Bachelor of Engineering : Electronics & Communication, 2007Electronics & Communication
Over 10 years of experience in Information Technology with strong work experience as Business Objects Developer. Extensive experience in Business Objects enterprise Products (Universe Designer, Web Intelligence Rich Client, BI Launchpad, CMC) and its deployment. Proficient in developing Dashboards using Xcelsius with QaaWS and BI WebServices. Strong experience in writing T-SQL Queries and Stored Procedures. Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report. Experience in training and supporting end-users in Business Objects and T-SQL. Experience in ETL projects by creating mappings, mapplets, tasks and workflows in Informatica ETL Tool. Significant experience in SDLC involving Requirements gathering, Data Analysis, System design, Development, Testing, Implementation and application maintenance & enhancements. Very good understanding of Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies. A result-oriented and innovative team player with excellent leadership, communication, analytical, problem solving and inter-personal skills.
SAP Business Objects (4.2,4.0,XI R3, XI R2)
SAP Dashboard Designer, Xcelsius
SQL Server 2008/2012
Microsoft SQL Server 2008
Informatica Power Center 8.1
MS Access July 2014 - February 2015
Role : Business Intelligence Developer
Technologies : SAP Business Objects XI R4, Dashboard Manager, Live Office, QAAWS, SQL Server 2012, Visual Basic (Excel Macros) Microsoft excel using macros saved 5 hours every month.
Project : UCDATA01 Reports Conversion
Company : UCare
Duration : July 2012 - June 2014
Role : Business Intelligence Developer
Technologies : SAP Business Objects XI R4, SQL Server 2012, MS Access Nov 2011 - June 2012
Role : Sr. Developer/Lead
Technologies : SAP Business Objects XI R3, Teradata, Informatica 8.1
Description: Project involved in bringing additional tax data into data warehouse and building reporting solution to enable self-service reporting for Tax business users to provide more insight into the tax details for auditing. SAP Business Objects XI R3, Teradata, Informatica 8.1 Dec 2009 - June 2010
Description: Service Bench is the leading provider of web-based service management solutions to help customers deliver best-in-class service with effective, efficient, and accurate exchange of information between channel partners in every transaction. The objective of this project was to bring Service Order GL, Claim GL & Claim audit data from Service Bench application to the Enterprise Data Warehouse and to make sure the data was available for reporting. NBC Universal Sales Portal
Duration : Nov 2007 - Jun 2009
Role : Developer
Technologies : Business Objects XI R2 (Universe), QAAWS, Adobe Flex, Action Script, Oracle 9i
Description: The objective of this project was to build a sales portal to accommodate all the Sales information to the key business users. This involved creating dashboards and scorecards to help the users to track key business metrics.
Involved in Full project life cycle (SDLC).
Translated business requirements into system design specifications.
Created user interactive Dashboards by using Adobe Flex 3.0 and Action Scripts.
Designed reports, dashboards and scorecards using Xcelsius and Adobe Flex.
Gathered user requirements for dashboard enhancements and new report developments.
Created Ad hoc reports for clients and accounts managers based on request.
Analyzed, diagnosed, and provided solutions and/or workarounds to software product problems/questions.
Involved in production support, application maintenance and enhancements of the dashboards and scorecards.
Adobe, Ad, auditing, basic, develop business, BI, Business Intelligence, Business Objects 4.0, Business Objects, concept, conceptual design, Conversion, Client, clients, customer satisfaction, data analysis, validating data, data validation, data warehouse, database, Dec, ETL, senior management, Fast, Finance, Forecasting, frame, functional, GL, ICD 10, ICD10, ICD-10, Informatica 8.1, Informatica, Java, logic, Macros, Maestro, access, MS Access, Microsoft excel, Excel, exchange, Office, share point, Migration, Enterprise, Oracle 9, Oracle, Oracle database, Developer, PL/SQL, Performance Management, processes, project planning, promotion, publications, Quality Assurance, reporting, requirements gathering, Sales, SAP, SDLC, Scripts, Script, specification, Microsoft SQL Server, SQL, SQL Server, system design, system analysis, tables, Tax, user documentation, Teradata, T-SQL, translating, UNIX, UNIX shell scripts, Visual Basic, Web Intelligence
Top Hat Award (2015 September - UCare) - Awarded for best service, team work and for going extra mile.
Top ranker in objected oriented programming and PL/SQL (2008 February - IGate) in the training given by IGate.