Objects Developer Data Analyst

Jyothi Modugu

TEL : +1-972-***-**** E-Mail: **************@*****.***

Profile

7.2 years of experience and proficient knowledge in Business Intelligence and Data Analyst with a demonstrated history of working in the Food and Agri -business, pharma industry. Strong professional skilled in SAP Business Objects, Tableau, Informatica, SAP BODS, Oracle, SQL Server & Data warehousing in Food and Agri-business and healthcare Domains.

Primary Skills

Having more than 7+ years of experience as business intelligence analyst and Developer role in Food and Agri-business, healthcare domains.

Experience with developing and deploying Reports and Dashboards using tool such as SAP Business Objects and Tableau.

Designed and developed mappings to move data from multiple sources Flat files, oracle, DB2 and SQL server into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, and Update Strategy from varied transformation logics in Informatica.

Extensively worked on creation of Informatica mappings, Mapplets, sessions, worklets, workflows, parameter files, Mapping parameters, Mapping variables and batch processing in varies layers like Stage, TEMP, ODS, Datamart and DWH.

Expertise in writing complex SQL queries, views and materialized views, created stored procedure for data analysis.

Experienced in Star Schema and Snowflakes schema modelling, facts and dimension table design. Extensively worked in large scale data loading from text files.

Very good experience on SAP Business Objects XI 3.1 SP1 Designer for Design, Development and Maintenance of the Universe and Business Objects Info view, Web Intelligence Rich client and DeskTop Intelligence Reporting components for Development of Desk Intelligence and Web Intelligence Reports and also experience in SAP Business Objects Business Intelligence 4.1, Crystal Reports.

Experience in scheduling of Web Intelligence reports in InfoView and Central Management Console. Row level Authorization and Object Level Authorizations security model in Universe Designer

Experience in CA workload Automation(CA7) scheduling tool to schedule ETL jobs and monitoring the jobs

Experience in 24*7 Production support and issue handling technics which involves debugging the reports and ETL jobs to resolve the issues with in SLA time

Having good exposure in Power BI and snowflake (Cloud Datawarehouse solution)

Technical Skills

Data Visualization/Reporting: SAP Business Objects, Tableau and Power BI

Database: Oracle, SQL Server, Snowflake

ETL tools: Informatica, SAP BODS

Software and Programming Languages\Scripting: SQL, PL/SQL

MS Office Tools: Word, Excel & PowerPoint.

Education Qualification

Bachelor Degree, B.Tech (ECE) from JNTU University, Telangana, India

Work Experience

IBM, System Engineer, Oct 2015 — Oct 2018

Client: OLAM

Project: OLAM AMERICAS INC - Cocoa Divestiture

Olam International is a leading agri-business operating from seed to shelf in 70 countries, supplying food and industrial raw materials to over 16,200 customers worldwide. Our team of 62,500 employees has built a leadership position in many businesses including cocoa, coffee, cashew, rice and cotton. IBM supports Cocoa business

Role: Senior Developer

Performed analysis and design by translating business requirements and developing reporting solutions that yield relevant business information in a user-friendly format by collecting, analyzing and leveraging data to solve business problems.

Created new reports, dashboards and modify existing reports using SAP Business Objects and Tableau.

Involved in support of Crystal reports, Desktop reports, schedule the reports and monitoring

Involved in testing the reports results by comparing the SQL query results in Business objects and database

Responsible for testing of all the mappings to ensure that data is populated correctly and ensured the quality of data based on the requirement and populate the data into the BI reports.

Process the data from different source systems which involves extraction, transformation and loading of data from various heterogeneous sources like Oracle, SQL Server, Flat Files and loaded into Data Marts using Informatica

Batch processing from different source to Stage, ODS and BI layer

Enhance the existing reports and ETL based on the Business requirement

Handing All KTLO activities such as Production Failures, Production Issues (Incidents/SRs) and Adhoc Requirements/Analysis from Business

Generate Adhoc reports based on the business request

Handing the security and access control management

Generated complex user interactive objects in Universe using @prompt and CASE functions using the Designer.

Environment: SAP Business Objects XI 3.1 SP1, Informatica 9.6, SQL Server 2008, Oracle 10g, Flatfiles, Tableau 3.2, CA7 scheduling tool, Service now.

IBM, System Engineer, Dec 2012 — Oct 2015

Client: Eli Lilly, UK

Project: BOLDER-Business Objects for LIMS Data Extraction and Reporting

ELI LILLY is a pharmaceutical company having offices in US, UK and Europe. IBM handles LILLY product manufacturing and Laboratory testing and Quality units’ data. This account provides support for LILLY by Problem Management, Change Management and some development work.

BOLDER is a project closely handling LIMS (Laboratory Instruments and Manufacturing Systems) data. Bolder has 14 standard DESKI (Desktop intelligence reports) and 52 WEBI reports. This application reflects EuroLIMS transactional data. EuroLIMS data is transformed into a BOLDER Oracle database.

Role: BI Developer

Created new reports, dashboards and modify existing reports (Dashboards, Drill Through Reports, Master detail reports and Cross tab) using Business Objects - Web Intelligence, Crystal reports and Universe Design tool.

Defect fixing for existing reports and perform impact analysis

Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data and develop integrated information delivery solutions.

Create and leverage analytical approaches to perform analysis of domain specific source data to provide accurate statements and conclusions.

Performed cleansing, de-duplication, and harmonization of data across various systems.

Testing the reports before user validation by comparing the Business Objects generated SQL and Native SQL.

Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.

Participated and provided technical leadership in all phases of BI projects starting from discovery and planning through implementation and delivery.

Migrated bolder 3.0 to bolder 3.1 universe for webi reports

Handing the deployment and migrations from lower environment to higher environments

Environment: Crystal Report Enterprise 2011, SAP Business Objects XI 3.1 SP1, BW 7.3, Informatica 8.6, SQL Server 2008, Oracle 10g, Flat files,

IBM, System Engineer, Aug 2011 — Nov 2012

Client: Medtronic, USA

Project: Medtronic SI implementation

Medtronic is the global leader in medical technology developing and manufacturing a wide range of products and therapies with emphasis on providing a complete continuum of care to diagnose, prevent and monitor chronic conditions. It has headquarters in Minneapolis, Minnesota, USA and operates in more than 120 countries. IBM supports Medtronic in various process areas for implementation, support, development and maintenance.

Role: Support Analyst

L1 support activities

Monitoring the ETL jobs, scheduled SAP BO reports

Performed admin tasks like monitoring BO server running

Involved in Formatted webi reports and scheduled them to be bursted as pdf to web server

Verify the data issues which raised by user and communicate with ETL team to fix the issues

Generate the reports from service now for all the incidents and SR’s

Perform the Low-level changes/Enhancements in webi report and ETL jobs

Impact analysis and documentation

Environment: SAP Business Objects XI 3.0, SAP BODS, SQL Server 2008, Oracle 10g, Flatfiles, Service now.

Contact this candidate