Sr. Power BI, Business Intelligence, ETL Developer, DW Specialist

REEPTHI GANGULA

Sr. Business Intelligence, ETL Developer, DW Specialist

609-***-**** ~ Remote or Onsite near Milpitas, CA

Summary of Qualifications:

oDeep expertise in a variety of fields over 12+ year period, with a wealth of understanding of implementing business intelligence initiatives while creating new business strategies and putting in place new data frameworks that enhance processes and meet complex and demanding business objectives.

oAnalytical and collaborative solution implementation professional who has developed and refined application vision & roadmaps in both functional and technical aspects of business intelligence solutions; successfully aligned business objectives and matured business intelligence capabilities.

oIn-depth knowledge of designing complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line chart.

oExpert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, data cleansing, data scrubbing, data migration and Power BI.

oExtensive experience in design and development of interactive dashboards and reports with Power BI.

oExtensive experience in complete life-cycle or end-to-end implementation experience of Business intelligence and Data warehouse applications using Oracle Data Integrator, OBIEE, Qlik, Informatica, and RDBM systems like Oracle, Teradata, DB2, Sybase and SQL Server.

oExpertise in Data Vault Modeling, Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snowflake schema methodology.

oProficient in DataStage server jobs and parallel jobs.

oExperience in Extraction, Transformation and Loading of data from multiple sources to Data Warehouse and creating Workflows with Worklets and various tasks.

oExperience in Oracle Data Integrator, DAC, Informatica, ETL and ELT architecture.

oGood knowledge in using ODI procedures, packages, load plans and knowledge modules.

oEffective in using Teradata SQL Assistant, Teradata Administrator, and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and exposure to T pump on UNIX/Mainframes environments.

oProficient in Oracle PL/SQL, SQL performance tuning, Sybase SQL, and Teradata SQL programming.

oExcellent interpersonal and communication skills, technically competent and result-oriented with strong problem-solving skills.

Technical competencies:

Business Intelligence: OBIEE 11g/10.3.1.x, Administration, Answers, Interactive Dashboards, Oracle BI Publisher, Qlik Sense Enterprise

ETL: Oracle Data Integrator, Informatica Power center 9.1/8.6, IBM InfoSphere DataStage

Languages: C, C++, Data Structures, SQL, PL/SQL, Perl, HTML, XML, Java, UNIX Shell Scripting

DW/RDBMS: TeradataV12/V14, Sybase, Oracle 10g/11g, SQL server 2000/2005

SDLC Process Models: Waterfall, Agile, Prototype Model

DB Utilities/ETL Tools: BTEQ, Fast Load, Multi Load, Fast Export, T Pump, SQL*PLUS, SQL*Loader, TOAD, Teradata Manager, Teradata Query Manager, Teradata Administrator, Teradata SQL Assistant, Sybase ASE ISQL

Scheduling Tools: DAC (Data Warehouse Administration Console)

Application Tools: Microsoft Visio/Projects/Power pointer/Access

Related course work: Database Systems, Information Networks, Internet Engineering

Operating Systems: HP-Unix, Linux, Windows 2003/2000/XP/NT

Professional Experience:

Client: State of California - Sacramento, CA Aug 2023 - Present

Role: Business Intelligence Developer, ETL-DW Specialist (Contractor)

oCollaborated with business stakeholders to gather requirements and design Power BI solutions that meet their needs.

oParticipated in all phases of SDLC methodologies throughout the project life cycle.

oPublished and shared Power BI reports and dashboards on the Power BI service, enabling access to insights across the organization.

oBuilt multiple data visualizations using Power BI in the form of interactive reports and dashboards; delivered different visualizations using Slicers, Lines, Pie Chart, Histograms, Maps, Scatter Plots, Bullets, Heat Maps, etc.

oPrepared Power BI reports for Internal and External audiences using Business logic and DAX.

oWorked in Power BI Desktop workbooks and data models that are created using Data Analysis Expressions (DAX).

oInvolved in developing and testing the SQL scripts for the report development, Power BI reports, Dashboards and handled the performance issues effectively.

oDesigned and developed complex PL/SQL scripts to extract, transform, and load (ETL) data from Oracle databases into Power BI for advanced analytics and reporting.

oExtract data from diverse sources, including databases, APIs, and flat files and implementing incremental data extraction for efficient ETL processes.

oOptimized PL/SQL queries and stored procedures to improve the performance of data retrieval and processing, resulting in faster and more efficient Power BI dashboards.

oDeveloped multitude of reports using multiple graphs, pie charts, slicers, maps, heat maps utilizing Power BI Desktop.

oDeveloped the Line, Bar, Bubble, Scatter, Waterfall, Funnel and Gauge charts in power Bi visualization.

oWorked on the Power BI gateway to schedule and automate the reports.

oCreated tables, views, and UDFs, according to the user requirements and maintained design structure (schema) by directing implementation of SQL standards and guidelines.

oDeveloped and deployed database objects such as stored procedures, triggers, indexes, views, and UDFs in SQL Server.

oGenerated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from SQL Server database systems.

Environment: Microsoft Power BI, Microsoft SQL Server Management Studio 12.0.2000

Client: T-Mobile - Seattle, WA Jan 2023 - June 2023

Role: Business Intelligence Developer, ETL-DW Specialist (Contractor)

oCollaborated with cross-functional teams to develop and implement strategies based on data-driven insights, resulting in improved marketing ROI and customer engagement.

oCleanse and transform data using ETL tool such as Informatica and applying business rules and logic during the transformation process.

oLoading transformed data into target databases or data warehouses and Implementing data loading strategies for optimized performance.

oDeveloped Python scripts for automating repetitive data tasks and implemented automation for data extraction, transformation, and loading.

oPerformed data analysis and profiling of source data to better understand the sources.

oConducted data mapping, exploratory data analysis, logical data modelling and gap analysis between source & destination systems.

oMaintained data integrity with the creation of constraints and DML triggers.

oUtilized top-down approach to create new data mart using data base from existing data warehouse for analysis and reporting.

oDesigned complex T-SQL queries, user defined functions; stored procedures and triggers followed by thorough analysis and testing of those database objects before deployment to the production server.

oCollaborated with data architects and database administrators to ensure seamless data flow from Oracle databases to Power BI, maintaining data integrity and consistency.

oIntegrated Power BI with various data sources, including SQL Server, Excel, and web APIs, to provide comprehensive reporting solutions and utilized Power Query to clean, transform, and shape data before loading it into Power BI.

oUtilized advanced DAX functions to create complex measures and KPIs for detailed analysis and designed custom visuals using Python scripts within Power BI to meet unique business needs.

oAltered existing workspace to add new members and provide required roles (Admin/member) on Power BI Services.

oManaged subscriptions and data alerts on Power BI dashboards with in Power BI Services.

Environment: Microsoft Power BI, Microsoft SQL Server Management Studio 12.0.2000, Oracle 12c, Informatica 9.1

Client: Garmin International Inc. - Olathe, KS Sep 2019 - Sep 2022

Role: Business Intelligence Developer 2, DW Specialist, ETL Developer (Full-time)

oWorked on Design, enhance and develop Extract, Transform and Load (ETL) and Business Intelligence applications written in Oracle Business Intelligence (OBI), Discoverer, Qlik Sense, Informatica, SQL, PL/SQL, or Linux Scripting as part of a structured Systems Development Life Cycle (SDLC) process.

oWorked closely with end users to customize, enhance, and support business intelligence and data warehouse solutions using software like Informatica, OBIEE and Discoverer, etc. to support Garmin business requirements.

oPart of the team to develop the process and implementation for migration from OBIEE to Qlik.

oProvided reliable solutions across 10+ departments by creating BI solutions using sound problem-solving techniques including ability to find root cause and corrective action for given problems, decreasing new errors by 35%.

oArchitected and designed data warehouse structures for global usage and 24/7 availability resulting in reduction of coordination times by 30%.

oWorked on maintaining, improving, and extending existing software.

oWorked on OBIEE cache purging, analyses troubleshooting, dashboard troubleshooting, agent troubleshooting, session logs, stop and start of OBIEE services, RPD upload to higher environments, 3-way RPD merge, creating connection pools in RPD.

oWorked on physical, logical and presentation layers of RPD.

oWorked on creating 25+ Streams, apps, creating App level security, Dynamic App security, restoring, and adding new data connections in Qlik.

oWorked on creation of security rules in Qlik Management Console (QMC) and assigning users as Consumers, Authors, Advanced Authors and Champions based on the data requirements.

oAssisted new Qlik users in using Qlik Continuous Classroom training.

oContributed to technical research on new technologies.

oWorked on subject areas, execution plans, resetting the dates to run as initial and incremental loads in DAC, creating and applying patches in DAC.

oWorked on stopping and starting OBIEE, DAC and Informatica services for weekend maintenances.

oProvide OBI and Discoverer administration functions and serve as the primary administrative support resource for On-Call OBI, Informatica and Discoverer issues.

oMentored onsite and offsite resources, with different time zones and assigned tasks resulting in accelerating development schedules by 25% within 5 months.

Environment: OBIEE 11.1.1.5, Oracle BI Publisher, DAC 10.1.3.4.1, Informatica 9.1, Qlik Sense Enterprise, Qlik Management Console (QMC), Discoverer, Oracle 11g

Client: United States Department of Agriculture - Kansas City, MO May 2015 - Aug 2019

Harmonia Holdings Group, LLC

Role: BI, ETL Developer / DW Specialist (Full-time)

Project: Enterprise Data Warehouse

oEffectively worked in Agile/Scrum team environment.

oWorked on CERT and PROD support for Operations and Maintenance.

oCreated DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Copy, Modify, Filter, and Change Data Capture.

oWorked on Task Order 2 EDW 1.0 FSA Org and Crop Foundation for MRT and CVS sources and Task Order 7 EDW 2.0 Business Partner Reports for MRT source, EDW 4.0 for CARS source, Task Order 10 EDW 7.1 Conservation, Maintenance and Payments sources, Task Order 14 Data Act.

oAnalyzed Functional and technical design documents and created mapping documents in the form of CSV files to load data into metadata tables using Oracle Data Integrator 11.1.1.

oWorked with multiple sources such as Microsoft SQL server, DB2 and Flat files like CSV, Txt for Extraction, Transforming and Loading data into target tables of Oracle database.

oWorked on Data Vault modeling concepts including Business keys and descriptive attributes.

oWorked on all Data Vault related tables named Master Hub, Reference Hub, Link, Master Satellite, Link Satellite and Reference satellite.

oExtensively worked on ODI procedures to load the data from different sources to staging and then to Data Vault tables.

oWorked on loading the data from Data Vault tables into different DataMarts consisting of Dimension and Fact tables.

oWorked on creating CSV outbound file from Data Vault tables related to Data Act source and send it to external agencies.

oExtensively used ODI designer, Topology, Operator and ODI Tools.

oInvolved in design, development, unit testing, regression testing and CERT support.

oWorked on the deployment of EDW 1.0, EDW 2.0 and EDW 4.0 into production.

oAttended the DataStage training on server jobs and parallel jobs.

Environment: Oracle Data Integrator 11.1.1, Microsoft SQL Server Management Studio 12.0.2000.8, Toad 9.7.2.5, IBM Data Studio 3.1.1 Administration Client, Oracle SQL Developer 1.1.3, IBM InfoSphere DataStage, QualityStage 9.1

Client: WellPoint, Inc. / Rapid IT, Inc – Richmond, VA Jun 2014 - May 2015

Role: BI, ETL Developer / DW Specialist

Project: Amerigroup Provider Integration

oEffectively interacted with the end users for requirement gathering and defined requirement specifications document.

oDeveloped Technical Design Document based on Business System Design.

oInvolved in CDW and Mart design meetings. Created Technical design documents.

oCreated ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.

oCreated ODI interfaces for loading the data from Teradata to CDW and from CDW to different Marts.

oUsed SQL*Loader to import data from large Flat files and Excel sheets to Oracle tables.

oExtracted large volumes of data from DB2, MS SQL Server, Oracle, Flat file systems to target Teradata database.

oUsed Informatica Power Center 9.1 for extraction, transformation, and load (ETL) of data in the data warehouse.

oDeveloped complex mappings in Informatica to load the data from Flat Files.

oUsed Informatica Power Center Workflow manager to create sessions, workflows, and batches to run with the logic embedded in the mappings.

oExtensively used Power Center Monitor to monitor status of workflows, log files, sessions, and session stats.

oCreated Informatica maps using various transformations like Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, stored procedure, Aggregate, Update Strategy, Joiner, Filter, and Router.

oExtensively worked on BTEQ scripts to load data into tables and various data and control files in UNIX and WellPoint Internal tools like WLM for scheduling of jobs.

oWorked on PL/SQL stored procedures, tables, views and scripts in Teradata and performance tuned and optimized various complex SQL queries.

oExtensively used Database query logs (DBQL), DBC views, Explain Plan and Collect Statistics in the optimization of queries.

Environment: Oracle Applications 11i/R12, Teradata V12, OBIEE 11.1.1.5, Oracle Data Integrator 10.1.3.4.7, Informatica 9.1, DAC 10.1.3.4.1, UNIX, PL/SQL, Oracle BI Publisher (Oracle XML Publisher Builder 5.6.3), PL/SQL, SQL*Loader, Putty

Client: American Express / Rapid IT, Inc. – Phoenix, AZ May 2012 - May 2014

Role: BI, ETL Developer / DW Specialist

Project: Merchant Finance

oWorked on various projects of Merchant Finance involving Accounts Receivable (A/R) Bank Migration Project, Split Funding Project, Teradata Base Migration Project, Eligibility Expansion Project, and Sybase to Teradata Migration Project.

oEffectively gathered requirements from business analyst and formatting them according to the business needs, identify tables required for data model.

oWorked on complete software development life cycle experience (SDLC) from gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning, deployment, and documentation.

oDeveloped PL/SQL stored procedures, tables, views, scripts, and triggers for data load and transformation, and data extraction in both Sybase and Teradata environments.

oWorked extensively in the migration of Sybase to Teradata database.

oWorked on Oracle Data Integration Suite (Oracle Data Integrator (ODI) and (OWB) Oracle Warehouse Builder) to Extract Load and Transform (E-LT) for high performance and faster responsiveness.

oExtensively used MLOAD (MultiLoad) on UNIX and windows environment and DATAPUMP to export and import data between different databases.

oManaged and customized the ETL loads according to the reporting needs of the client.

oOptimized high volume tables in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.

oWorked on planning, schedule, assigning work to offshore team and trained them on Client Proprietary tools.

oExtensively used Database query logs (DBQL), DBC views to notify the users of their space usage and skew ratio.

oExtensively worked on Teradata performance optimization and brought down the queries to seconds or minutes from spool out and never-ending queries by using various Teradata optimization strategies.

oWorked on the creation of EBCDIC and ASCII files in UNIX environment and transfer to Mainframe server using FTP Perl script.

oExtensively used .dat scripts to execute stored procedures and Perl scripts for the creation of files.

oExtensively used AMEX Internal tools like Magellan and Event Engine.

oMaintained CVS on UNIX to check in codes and create packages for code release.

Environment: Oracle 10g, Oracle Data Integrator, OBIEE, Teradata V12, Teradata SQL Assistant, Sybase IQ, Sybase ASE, BTEQ, MLOAD, DB2, Informatica 8.6, PL/SQL, TOAD, Mainframe, UNIX, Perl, Event Engine, Magellan, CVS

Academic Projects:

School of Information & Telecommunication Systems - Athens, OH Jan 2012 - May 2012

Department Graduate Assistant

oAssisted the advisor in his research.

oAchieved great success in the programming of Programmable Logic Controller (PLC) device using Siemens Totally Integrated Automation Portal.

oDesigned and tested the Human Machine Interface (HMI) of the Smart Grid Controller using Siemens WinCC flexible runtime simulator.

oCreated the connection between PLC and HMI and controlled the PLC device remotely.

School of Information & Telecommunication Systems - Athens, OH Apr 2010 - Mar 2011

Department Graduate Assistant

oAssisted professors in compiling research papers for technical presentations.

oDeveloped a research project based on the analysis of FCC reported switch outages from 1999 to 2009 which addresses the difference in voice switch hardware failure outages experienced in urban and rural settings.

Education:

oMaster’s Degree in Communication Technology and Policy (Graduated in 2012)

Ohio University - Athens, OH

oBachelor’s Degree in Electronics & Communications Engineering (Graduated in 2009)

SR Engineering College - Hyderabad, India

References: Available upon request.

Contact this candidate