Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Rajesh Singamsetty

Summary

BI Consultant with overall 10 years of extensive IT experience across multiple domains like Retail, Healthcare, and Manufacturing with skills related to data warehousing. As a BI Consultant, involved in Extract, Transform, Load, and Reporting activities using different ETL and Reporting tools. Proficient in data analysis tools such as Python and SQL. Experience working with IICS concepts relating to data integration, monitor, Administrator, deployments, permissions, schedules. Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations, and partitioning sessions. Have excellent collaboration skills and ability to build strong, lasting relationships with both technical and non-technical staff. Have experience in translating data using analytical thinking into a wide range of visualizations to develop reports, KPI scorecards, and dashboards in Tableau, OBIEE, Power BI, and Incorta. Worked with customers to identify their reporting needs and transforming these into visually effective and meaningful reports that inform decision-making. Having experience in connecting data sources, importing data, and transforming data for Business intelligence. Involved in creating epics, user stories, raising issues in JIRA as per Agile Methodologies, and planning sprints and distributing tasks across the team as a scrum master. Highly experienced in analyzing and understanding the data flows from Source to target and possess sound knowledge of SQL and ETL framework concepts. Experienced in preparing Business Requirement documents, Functional specifications, and Source to Target Mapping documents. An effective team member with the ability to meet targets under constraints, a strong ability to grasp new concepts with ease, excellent presentation skills, an effective communicator: both verbal and written. Good customer service skills. Ability to deal with difficult situations/individuals gracefully. Ability to influence decisions/mindsets.

Overview

11
11
years of professional experience

Work History

Data Analyst

Cochlear
09.2022 - 08.2023
  • Developed and implemented data collection methods and procedures to ensure data accuracy and reliability, resulting in improved data quality and integrity
  • Created visually impactful visualizations and dashboards using Tableau, Power BI, Excel, OBIEE, and Python, effectively communicating findings and actionable recommendations to stakeholders
  • Utilized Python for data cleaning, filtering, and manipulation, enhancing data quality and facilitating accurate analysis
  • Developed complex calculated measures using DAX
  • Collaborated closely with stakeholders to understand their data visualization needs, translating requirements into effective Power BI reports that adhered to established business standards for visualization
  • Designed and built IICS mappings to extract data from SFDC, Oracle and loaded into Oracle/ Designed the ETL flows for generating flat file extracts as per the business need
  • Involved in enhancements and maintenance activities of the data warehouse
  • Handled configuration activities like setup run time environment and create connections, schedules, tasks, mappings, mapplets and components
  • Designed Mappings, Integration Templates, Bundles and Task flows
  • Used various transformations to extract data from different formatted files and relational source systems
  • Integrated Data Quality routines in the informatica mappings to standardize and cleanse the data
  • Developed dynamic dashboards using Tableau Desktop, showcasing insights from various data sets and enabling stakeholders to interact with real-time visualizations
  • Applied data modeling techniques and implemented Kimball methodology, ensuring efficient data organization and optimized data analysis processes
  • Involved in identifying the issues and worked closely with all business and technical stakeholders to fix the issues.

BI Consultant

WIPRO
08.2020 - 03.2022
  • Created Power BI and Tableau reports utilizing data to generate comprehensive reports for stakeholders
  • Facilitated communication between business and technical personnel to ensure a mutual understanding of processes and applications
  • Identified issues and collaborated closely with business and technical stakeholders to effectively resolve them, ensuring smooth operations
  • Extensively used Informatica power center, IICS to create mappings, sessions, and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sources systems (Oracle, Flat files)
  • Worked on Migrating Informatica Powercenter code to IICS
  • Experience integrating data using IICS for reporting needs
  • Developed custom calculated measures using DAX to satisfy business needs
  • Engaged in data modeling activities in collaboration with the onsite coordinator
  • Successfully implemented development processes, coding best practices, and conducted code reviews, resulting in improved code quality and development efficiency
  • Led the migration from Discoverer reports to OAC for Finance dashboards, enhancing reporting capabilities
  • Worked with business teams to document migration processes and completed gap analysis
  • Developed customized reports and Informatica mappings to meet client requirements
  • Identified and reconciled errors in client data, ensuring accurate business requirements and data integrity.

BI Consultant

Wipro
09.2019 - 06.2020
  • Work for migration from Discoverer reports to OAC on Finance dashboards of General Ledger, Account Payables and Account receivables
  • Work with business for migration document, complete gap analysis
  • Work for customized reports and informatica mappings as per the client requirement
  • Identifying and reconciling errors in client data to ensure accurate business requirements
  • Responsible in performing development, Quality testing, production and provide signoffs
  • Maintain communication channels and establish effective relationships with senior management and their teams across all business and Technology teams
  • Involved to prepare Business Requirement documents, Functional specifications, and Source to Target Mapping documents.

BI Consultant

TCS (Stratosphere IT Services)
06.2019 - 08.2019
  • Involved in the upgrade and migration of OBIEE from version 11g to 12c, ensuring a smooth transition and leveraging new features and improvements
  • Worked on tableau and Power BI reports development and enhancement, as well as ETL mappings, aligning them with business requirements
  • Integrated Data Quality routines in the informatica mappings to standardize and cleanse the data
  • Reviewed ETL code and worked with development teams to correct problems, run test scenarios, and prepare for deployment solutions, ensuring accurate and efficient data processing
  • Maintained and tuned DWH databases to optimize system performance and data retrieval
  • Prepared unit test plans and conducted unit testing, ensuring the quality and functionality of developed components
  • Provided support during system testing, Product Integration Testing, and User Acceptance Testing (UAT), ensuring successful implementation and user satisfaction
  • Developed and enhanced reports on both Power BI and OBIEE reporting tools, catering to diverse reporting needs
  • Maintained industry best practices of data security, ensuring data confidentiality and compliance
  • Debugged and identified bugs in existing mappings by analyzing data flow and evaluating transformations, improving data accuracy and processing efficiency
  • Developed SQL queries to validate data, including checks for duplicates, null values, truncated values, and ensuring accurate data aggregations, ensuring data integrity and reliable analysis.

BI Consultant

TCS (Future Focus infotech Private Limited)
02.2019 - 06.2019
  • Work for report development and enhancement on ETL mappings as per the requirement
  • Work for Source, staging and target mappings like SDE, SIL and PLP in ETL
  • Work for enhancement on Finance reports like General Ledger, Account Payables and Account receivables
  • Work for both Power BI and OBIEE reporting tools
  • Maintain industry best practice of data security Debugging and identifying bugs in existing mappings by analyzing data flow, evaluating transformations
  • Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

BI Consultant

Tarant Software Pvt Ltd
06.2017 - 01.2019
  • Built and published customized OBIEE reports and dashboards as per the requirement
  • Work for ELT Mappings and Knowledge modules
  • Involved in OBIEE upgradation and Migration from OBIEE 11g to 12c
  • Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server
  • Created Tableau scorecards and dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts and other Visualizations
  • Work for new business requirements into technical designs.

BI Consultant

CES Global
07.2016 - 06.2017
  • Analyzed the SQR files and convert it into SQL queries
  • Creating BIP reports using converted SQL queries
  • Involved on technical specification document along with Business Analyst
  • Involved in ETL Daily, Weekly and Monthly Monitoring using Autosys
  • Providing solutions to enhance existing functionality as per user requirements
  • Built and published customized OBIEE reports and dashboards as per the requirement
  • Work for ELT Mappings and Knowledge modules
  • Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server
  • Created Tableau scorecards and dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts and other Visualizations
  • Work for new business requirements into technical designs.

BI & ETL Developer

Infosys Limited
06.2012 - 05.2016
  • Involved in enhancements of informatica mappings, BIApps dashboards and Power BI reports as per business requirements to fit the gaps identified
  • Involved in OBIEE upgradation and Migration from OBIEE 11g to 12c Perform system troubleshooting in a production support environment
  • Assist users in solving both functional and system issues within agreed-to service level agreements (SLAs)
  • Provide end-user instruction, training, and support to resolve application issues
  • Analyze the Problems raised by the business user, identify the root cause, and provide solution
  • Involved in Data modeling and applied on Kimball methodology
  • Providing permanent fixes via changes for resolving recurring issues by creating problem tickets
  • Involved in developing job automation process, Performance tuning
  • Involved in end-to-end Activities related to the project
  • Preparing or updating technical specifications and Source to Target Mapping documents based on requirement changes
  • Working closely in enhancing OBIEE and Power BI reports based on business requirements
  • Involved in production support activities using job scheduler tool DAC and Autosys.

Education

Skills

  • Reporting Tools: OBIEE 11g and 12c, Power BI, Tableau, and Incorta
  • Database: Oracle, Teradata
  • Programming: PLSQL, Python
  • ETL Tool: Informatica IICS, ODI
  • Utilities: Autosys Scheduler, DAC, Redwood, and Autosys
  • Operating System: Windows XP, Windows 7, Windows 2000 Server, Unix
  • Other Tools: Toad, SQL Developer, Kintana, PVCS, HP Quality Center, PUTTY, Service now, Oracle support, JIRA, Github

Timeline

Data Analyst

Cochlear
09.2022 - 08.2023

BI Consultant

WIPRO
08.2020 - 03.2022

BI Consultant

Wipro
09.2019 - 06.2020

BI Consultant

TCS (Stratosphere IT Services)
06.2019 - 08.2019

BI Consultant

TCS (Future Focus infotech Private Limited)
02.2019 - 06.2019

BI Consultant

Tarant Software Pvt Ltd
06.2017 - 01.2019

BI Consultant

CES Global
07.2016 - 06.2017

BI & ETL Developer

Infosys Limited
06.2012 - 05.2016

Rajesh Singamsetty