Data Analyst Developer

Ashwini Sanikere Muddanna

Randolph, NJ ***** *************@*****.*** C: 973-***-****

Visa Status: Green Card

Summary

Over 10+ years of progressive expertise in Design, Configuration, Development, Testing and Implementation of Data warehousing and Business Intelligence Tools like Tableau Desktop and Tableau Server and certified in Tableau Desktop.

Solid understanding of Software Development Life Cycle (SDLC) process including requirement gathering, analysis, design, development, testing, release management & deployment.

Tableau Desktop Specialist Certified professional with extensive knowledge on the development of complex dashboards and reports.

Good understanding in Normalization and Relational Database Management Systems.

Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines calculated measures.

Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing

access levels.

Experience in Tableau report developing, testing, and deploying reporting solutions using Tableau Server.

Experience in Creating Users, Groups and Projects on tableau server.

Created Customized and interactive dashboards using multiple data sources.

Expert in developing different Data visualizations like Bar Charts, Scatter Charts, trends using Tableau.

Produced attractive visuals/dashboards to convey the story inside the data.

Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Experienced in generating BI reports in Cognos required for the Business Analysis or Management decisions.

Strong knowledge of ETL design with the Informatica tools. Worked on Informatica tool to perform the data migration from legacy system to the new contracting system. Proficient in using source qualifiers, transformation stages, mapping, etc.

Extremely proficient in Oracle PL/SQL including SQL query Performance tuning. Won award for tuning Unilever Thailand Database. Performed complex PL/SQL coding using advance features like dynamic SQL, analytic functions

Data Warehouse data modeling experience using all the principles of dimensional modeling.

Award-winning contribution across 3 different projects. Latest being the “Most Valuable Player” for independently handling the complete execution from requirements gathering to go-live for the migration project of ASP DW at J&J, NJ. The previous ones were for the Performance Tuning at Unilever Thailand DW and for Exceptional Data Modelling work at Wyeth Consumer Healthcare, NJ.

Excellent Team player with clear communication and interpersonal skills. Worked with third-party vendors and offshore development teams extensively.

Skills / Tools

Data Visualization: Tableau, Cognos, and SAP Business Objects

ETL: Informatica 9.1, Oracle PL/SQL

Modeling: Erwin, Kalido DIW/MDM 8

Databases: Oracle 9i, Oracle 10g and SQL Server 2005

Languages: SQL, PL/SQL, Windows DOS, Unix Shell Scripting

Tools: Business Objects, Cognos, HP QC, TOAD, SQL Navigator, Microsoft Office: MPP, PowerPoint and MS Excel (vlookup, functions, pivot tables, macros etc.)

Experience

Client: GenXPLM, NewJersey (Feb 2020 to till date)

Tableau Developer/Data Analyst

Tools and Technologies: Oracle 12c, Informatica 9.1 and Tableau 2019.1

Created the User Requirement Specifications and helped convert them to Functional Requirements and assisted the developers with System Requirement Specifications.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand the customer distribution and density.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.

Identified the mapping between the source PLM data source to the target Data Mart. The target Data Mart was built to support the reporting requirements like product adoption rate, supplier inventory, product/material samples tracker etc. in the retail space.

Led the analysis effort along with business users and technical team to bridge the gap between the master data and the transaction data. This involved cleaning and consolidation of data from different sources.

Deep experience with the design and development of Tableau visualization solutions.

Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.

Develop, organize, manage, and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Created effective analytical dashboards for business users in Tableau. Involved in creation of complex dashboard, worksheets, and stories.

Extensive use the Tableau features like filters, use groups, context filters and table calculations. The dashboards were tuned for the optimal performance.

End to End testing of the Reporting components. Involved in preparation, execution, and documentation of the test cases as well as test results.

Client: Johnson & Johnson, Piscataway, NewJersey (Sep 2012- Mar 2016)

Project: Commercial Contract Improvement

BI Report Analyst and ETL Architect – Wipro Consulting

Tools and Technologies: Cognos, Informatica 9.1.0, Oracle 10g, SQL Server 2005, Kalido DIW and UNIX.

.

Managed the requirements through the project lifecycle by establishing and maintaining agreements between the customer and the project team. Primary modules impacted in the migration were orders, direct/indirect sales along with the corresponding master data.

Gathered and documented business requirements for migration of analytical reports and ETL components for ASP DW and HCS DW. Participated in requirements meetings and data mapping sessions to understand business needs and gaps.

Conducted the gap analysis between the existing source systems against the new CCI system. This involved changes to the data model, Informatica mappings and BI reports. Documented the detailed changes in the Technical Design Document.

Created effective Business Intelligence (BI) solutions and analytical reports for business users in Cognos.

Led the design, development and testing of the Cognos Reports impacted in the migration.

Ensured UAT cycles are completed within the release timelines in HPQC. Extensive collaboration with the business teams and QA teams.

Constant communication with the PMO team to provide the status updates and to mitigate any risks across multiple systems that were involved directly and indirectly during the migration.

Owned the complete production cut over plan during the go-live.

Management of offshore team in Bangalore to communicate the code changes for the Informatica Mappings, SQL Procedures and BI reports.

Awarded “Most Valuable Player” by Wipro for independently leading end to end implementation for ASP Data warehouse.

Client: CIT, Livingston, NJ

Project: Data Management Program DMP (Aug 2007-Nov 2009)

Onsite Technical Lead – Mindtree Consulting

Tools and Technologies: Oracle 10g, DataStage 6, SQL Server 2005, Unix

CIT is the 100+ year old company which primarily focus on the financing the small business. The project involved building a corporate data warehouse to support the reporting requirements. It involved extracting the source data from various internal and external source systems (32 sources), conforming them to the enterprise standards using conformed dimensions and building the enterprise warehouse.

Worked with the business users to collect the requirements for the corporate warehouse.

Worked on building the data model for the warehouse as well as the data mart. This involved building various base staging tables for landing data, dimensional tables for the conformed dimensions, fact tables for storing the measures defined by their corresponding dimensions, summary tables for report performance.

Designed and developed DataStage jobs to handle the transformations. It involved usage of various datastage stages and routines. The datastage jobs were also controlled and scheduled in the Unix environment using shell scripting.

Designed the mappings between sources to Operational staging targets. Define reference lookups and aggregations. Perform data manipulation using BASIC functions and DataStage transforms & routines.

Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Merge, Join, Lookup, Sort and Containers (Server, Parallel) for developing job.

Create master controlling sequencer jobs using the DataStage Job Sequencer.

Designed and Development of a generic PL/SQL procedure along with the metadata framework to code the ETL transformations in a extremely short time. The number of sources was high and for every source a separate procedure or datastage job would otherwise be required.

Exhaustive use of PL/SQL along with the advance features like analytical functions, Dynamic SQL, etc.

Managed offshore team of 8 in Bangalore, India. Established processes and communication from onsite to offshore.

Worked on procedural coding in SQL Server 2005 to perform transformation at the various source systems/UDB.

Understood the Insurance and Finance Process (Leasing, Lending, Actuarial, Insurance) business processes.

Client: Wyeth Consumer Healthcare, Madison, NJ (Sep 2006-Jul 2007)

Project: Retail Supply Chain

Business Analyst / Senior Designer and Developer – Mindtree Consulting

Tools and Technologies: Oracle 10g, Kalido, DOS

Wyeth is a world leader in the R&D of health care products. The reporting environment was limited in its ability to provide enterprise level business processes. Information to support macro decisions resided in multiple places and required manual consolidation. The objective of the project was to a create centralized, integrated data warehousing solution that provided visibility to the end-to-end Retail Supply Chain, including shipments, inventory, and retail sales including competitor sales from IRI across the enterprise. The Project involved the analysis for strategic architecture for building the enterprise warehouse conforming to client requirements. The project was a pure consulting work.

Data modeling for the staging and Data Warehouse tables after gathering the business requirements, analyzing the existing MS Excel reports.

Performed the role of BA to understand the user requirements, competitor data and the supply chain KPIs.

Developed the warehouse in Kalido DIW V8.3 for Retail Supply Chain.

Advanced coding in PL/SQL to accomplish the transformation on the data before loading it to Kalido warehouse.

The data was collected from IRI which is 3rd party competitor data. This involved lot of integration challenges which required to map and conform it to the standard Wyeth master dimensions data before loading the data.

DOS script to execute the Kalido loader jobs to load the data using windows scheduler and autosys.

Awarded by Mindtree Consulting for the excellent consulting work done single handedly at the client location.

Client: Unilever Asia Pac, Thailand/Singapore/Japan (Feb 2005-Sep 2006)

Project: Unilever Kalido

Role: Designer and Developer - Mindtree Consulting

Tools and Technologies: Kalido DIW 7 and Kalido DIW 8, Oracle 9i, Business Objects V6, UNIX

The objective of the project was to implement the Sales and the Supply Chain system for the reporting and Analytics of Plan/Make/Sell KPI for each country in the Unilever Asia Pac region. The Key objective is to replace all the country specific local systems with a standard warehouse solution. This enables each country to have the consolidated view of the data to enable critical business decisions based on the KPIs. The consolidation of each country’s data could provide for the corporate level reporting by Unilever London.

User requirement gathering along with the business analyst at Thailand, Singapore, and Japan.

Built the data model in Kalido for the end user reporting requirements.

Performed migrations and purges using the Kalido checkpoint utility.

Performed upgrade from version 7 to version 8.3. Involved with the Kalido Consulting Services from UK for upgrades.

Performance Tuning of the Kalido loading jobs to improve the load time.

Building of the various summary tables for tuning of the BO report performance and for the consolidated data for the corporate warehouse.

Performed all the ETL transformations using the PL/SQL complex procedures.

Building the universe in Business Objects V6. Used all advanced features like avoiding Fan and Chasm traps, aggregates.

Performance tuning of the database by enabling the star transformation using bitmap indexing on the fact tables along with the scheduled analysis of the tables for the right amount of the stats collection. Improved the loading time of Kalido by changing the database environment variables.

Awarded by Mindtree for the performance tuning of the Unilever Thailand Database. This was particularly challenging since the Oracle tables conformed to Kalido architecture and could not be easily modified.

Excellent understanding of the Supply Chain KPIs and business.

Client: Hindustan Lever Limited, Bangalore (Oct-2003 – Feb 2005)

Project: IMAGE -Information Management as Growth Enabler

Role: ETL Developer - Mindtree Consulting

Tools and Technologies: DataStage 5, Oracle 9i, Erwin

IMAGE is a custom warehouse built to meet the sales, supply chain and Claims business intelligence reporting requirements of Hindustan Lever Limited. The model for the HLL included complex KPI calculations completely handled in the warehouse. The loading pattern of the data into the warehouse is also complex with heavy updatable transactions with no clean Master data available.

ETL development using DataStage and Oracle Pl/SQL

Exhaustive DataStage jobs development using ODBC, Sequential files, Hash, Sort, Aggregate & Link Partitioning features.

DataStage Sequencer were used to control the flow of the DataStage jobs.

Complex routines were built in datastage jobs to control the error handling and other complex transformations.

Tuned the DataStage lobs to improve the performance of loading heavy data.

Oracle Pl/SQL coding to accomplish the loading of huge data using the generic fact loader framework.

Scheduled the jobs using Windows Scheduler.

Client: Blue Cross Blue Shield Reporting on FACETS (Aug 2002- Jun 2003)

Role: Business Objects Report Developer - Cognizant Technology Consulting

Tools and Technologies: Business Objects V5, Sybase, Unix

The project involved the design and development of the business intelligence reports for the HMO-BCBS Michigan on FACETS. Included the design and development of the data marts used for the specific reporting requirements

Built the business object reports bases on the design document from onsite technical leads.

Worked closely on the processes to establish a smooth onsite-offshore co-ordination

The challenge was to understand the health care product FACETS and the underlying complex business model and data model of the product.

The reports used various features of the Business Objects to develop reports that were simple to highly complicated like multiple data providers, linking of the objects, nested hierarchies, etc.

Coded procedures in Sybase to load the data from warehouse to data marts.

Education

Bachelor of Engineering – Specialization: Computer Science PESIT, Bangalore, India

Contact this candidate