Sr. Business Intelligence Developer Resume Example
Love this resume?Build Your Own Now
SR. BUSINESS INTELLIGENCE DEVELOPER
Experience
Sr. Business Intelligence Developer
July 2017 to CurrentArthur J Gallagher & Co.
July 2017 to CurrentArthur J Gallagher & Co.
- 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 2017Arthur J Gallagher & Co.
March 2016 to June 2017Arthur J Gallagher & Co.
- 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 2016Res-Care, Inc.
September 2015 to February 2016Res-Care, Inc.
- 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 BusinessObjects CMC.
- Project : ICD9 to ICD10 Conversion.
Business Intelligence Developer
March 2015 to August 2015Res-Care, Inc.
March 2015 to August 2015Res-Care, Inc.
- 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.
Accomplishments
- Getting Started with SAP Lumira - issued on 04/19/2018 by SAP.
- https://open.sap.com/verify/xobov-hyrin-ryvuc-rolup-lolid.
Education
Bachelor of Engineering : Electronics & Communication, 2007Electronics & Communication
Summary
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.
Highlights
|
Skills
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
Additional Information
- Achievements: 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.
- Linkedin Profile: https://www.linkedin.com/in/dhana-sivaraj-kumar-60945648?trk=nav_responsive_tab_profile_pic
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Word choice
- Length
- Strong summary
- Typos
Resume Overview
Job Titles Held:
- Sr. Business Intelligence Developer
- Business Intelligence Developer
Degrees
- Bachelor of Engineering : Electronics & Communication , 2007
Similar Resumes
