Data Analyst Warehouse

Name: Madhu Mohan Goguladinni

Email: ****************@*****.***

Contact: 612-***-****

SUMMARY.

• 4 years of total IT experience in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co-ordination and interpersonal skills for leadership.

• I am a Data Warehouse developer, Data modeler, Data Analyst with around 4 years of experience in all phases of Software development life cycle (SDLC) including System Analysis, Design, Data Modeling, Implementation and Support and maintenance of various applications in both OLTP and OLAP systems.

• Worked on creating dashboards in Tableau for reporting and data visualization, and guided business decision - making for multiple stakeholders.

• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities

• Extensive Experience working with business users as well as senior management.

• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.

• Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.

• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams and OLTP and OLAP System Study and Analysis.

• Extensive experience in Enterprise Information Management and Architecture technologies including Information Lifecycle, Master Data Management and Business Intelligence.

• Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, to forward and reverse engineering data models and publish data models to acrobat PDF files.

• Excellent leadership, organization skills and requirement gathering skills such as JAD.

• Strong experience in Database such as Microsoft Access, Oracle 11g/10g/9i/8i, SQL Server, DB2, Teradata, on Windows 2000/NT/98/95 platforms and latest.

• Experienced in writing Toad and PL/SQL Stored Procedures, Triggers and Functions.

TECHNICAL SKILLS:

Data Modelling Tools: ERWIN, Power Designer, Tableau.

Project Management: MS Project

Methodologies: SDLC, JAD Sessions, Ralph Kimball Methodologies

Databases: Oracle, MS Access, SQL Server, Teradata

ETL Tools: Informatica PowerCenter

Reporting Tools: BO, OBIEE

Languages: PL/SQL, SQL, HTML

OS: Windows

Others: MS Project, MS Office, TOAD

PROFESSIONAL EXPERIENCE:

OPTUM

Data Analyst Jan 2024 - Present

Responsibilities:

• Created and analyzed business requirements to compose functional and implementable technical data solutions.

• Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift, JSON and XML.

• Designed metrics for A/B testing, creating dashboards in Tableau to monitor test processes, analyzing test results, interpret and give recommendations to stakeholders.

• Identified integration impact, data flows and data stewardship.

• Created HTML, PDF and RTF reports using SAS ODS.

• Imported Datasets from Excel and flat files, Created SAS datasets, put them into SAS libraries.

• Created new data constraints and leveraged existing constraints for reuse.

• Created data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.

• Anticipated JAD sessions as primary models in expanding existing DB and developing new ones.

• Evaluated and enhanced current data models to reflect business requirements.

• Generated, wrote and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures.

• Consolidated and updated various data models through reverse and forward engineering.

• Compared different WFHM DB environments and determined, resolved and documented discrepancies.

• Analyzed DB discrepancies and synchronized the Staging, Development, UAT and Production DB environments with data models.

• Reviewed and revised data models for soundness of data structures and adherence to client standards.

• Restructured Logical and physical data models to respond to changing business needs and to assured data integrity using Power Designer.

• Created naming convention files and co-coordinated with DBAs to apply data model changes.

Technical Environment: Power Designer 15.0, Oracle 10g, Oracle SQL Developer, Tableau, Rational ClearQuest, MS Excel and Access.

Target

Data Analyst March 2023 - December 2023

Responsibilities:

• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.

• Involved in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.

• Created real-time dashboards in Tableau to visualize and monitor key metrics and A/B test processing using both external and internal data.

• Developed the SAS Macros for data analysis of clinical data.

• Outputted SAS reports and SAS outputs in the RTF, PDF and HTML formats using ODS.

• Performed Exploratory Data Analysis to identify trends using Tableau and Python (Matplotlib, Seaborn, Plotly Dash).

• Performed requirements gathering and design analysis for customer contact history for customer relationship management.

• Worked as business requirements analysts with subject matter experts to identify and understand requirements.

• Communicated key findings from data to multiple stakeholders to facilitate data-driven decisions using tools MS PowerPoint Tableau and Jupyter Notebook.

• Supported data warehouse projects with logical and physical data modeling in Oracle environment and assured accurate delivery of DDL to the development teams.

• Documented the data requirements and system changes into detailed functional specifications.

• Took ownership of Source to Target Mapping and tracked and maintained changes.

• Performed Extraction, Transformation and Loading (ETL) using Informatica power center.

• Designed and implemented data profiling and data quality improvement solutions to analyze, match, cleanse, and consolidate data before loading into data warehouse.

• Extensively used ERWIN to design Logical, Physical Data Models, and Relational databases and to perform forward/reverse engineering.

• Responsible in designing new FACT or Dimension Tables to existing Models.

• Implemented stored procedures, functions, views, triggers, packages in PL/SQL.

Technical Environment: ERWIN 4.0, Tableau, Oracle 8i/9i, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Informatica Power center.

Concentrix, India

Data Analyst Oct 2020- August 2022

Responsibilities:

• Identify business, functional and technical requirements through meetings and interviews and JAD sessions.

• Define the ETL mapping specification and Design the ETL process to source the data from sources and load it into DWH tables.

• Developed interactive dashboards and storyboards in Tableau to explore credit portfolios data and report insight to the manager.

• Designed the logical and physical schema for data marts and integrated the legacy system data into data marts.

• Developed new macros using SAS/Macro as per the customer’s requirement.

• Produced SAS Graphical reports and charts showing trend Analysis.

• Set up automated systems used Excel VBA to pull the data smoothly into Tableau platform to create reports and dashboards.

• Visualized data from MySQL and MS Excel using Tableau Dashboard to monitor email performance. connected to MySQL database using R package RMySQL and retrieving data for statistical analysis and visualization.

• Integrate Data stage Metadata to Informatica Metadata and created ETL mappings and workflows.

• Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings.

• Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.

• Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL.

• Developed Stored Procedures to test ETL Load per batch and provided performance optimized solution to eliminate duplicate records.

• Provide the team with technical leadership on ETL design and development best practices.

Technical Environment: Informatica Power Center v 8.6.1, Power Exchange, Tableau, IBM Rational Data Architect, MS SQL Server, Teradata, PL/SQL, IBM Control Center, TOAD, Microsoft Project Plan.

Education: -

Master of Science in Information Technology in Management, GPA: 3.84/4.0 Dec 2023 University of Concordia St Paul, MN, USA.

Bachelor of Engineering and Technology in Electronics and Communications Engineering, GPA 3.4/4.0 April 2021 PACE Institute of Technology and Sciences, Ongole, India.

Contact this candidate