Intelligence Developer Data Manager

SUDHA RANI BATHALA

Mobile – 732-***-****

*************@*****.***

https://www.linkedin.com/in/sudha-r-bathala/

Skills

Data Ingestion: Apache NiFi, Alteryx

Data Transformation: IBM DataStage, Alteryx

Database: Teradata, SQL Server, Oracle, Vertica, Cassandra Reporting: Tableau, IBM Cognos, Power BI, SSRS, ThoughtSpot Data Lake: Big Data, ADLS

Data Modelling: Alteryx, IBM Cognos Framework Manager, IBM Cognos Transformer Ticketing: Cherwell, JIRA, Service Now, xMatters Deployments: IBM Urban Code deploy

Scheduler: Tivoli, Unix/Linux, Autosys, Cognos Event studio Other: GIT HUB, Reference Data Manager (attacama), Rally Languages: SQL, CQL, PL/SQL

Cloud: Azure, Azure Data Factory, Azure Data Explorer, Azure Data lake Education

Master’s in Business Administration and Management – Dallas Baptist University, Texas – 2014 Professional Experience/Projects

Bank of America, New York City, NY

Business Intelligence Developer (Contractor) 08/2020 – Till Date Part of Markets BI Team, supporting several business groups such as Research, Marketing and sales, QCC, Peer Analytics, Global Banking and Equities to deliver end-to-end data driven solutions using various tools and technologies.:

Responsibilities:

• Sourcing, Ingesting and Transforming data from various applications and databases using tools such as Alteryx and Tableau Prep

• Development of multiple pipelines to develop and create insightful data sets and host Analytical databases and datasets.

• Design and development of Analytical Alteryx workflows to blend, merge, logical processing and transform data from various Enterprise systems and Applications based on the BAU requirements

• Publishing and maintenance of the Alteryx Gallery/ server

• Building Powerful and Insightful data visualizations using Tableau and Cognos

• Creating tableau workbooks and dashboards using calculated metrics and business logics

• Creating Rich Graphic visualizations/Dashboards to enable users to get quick insights using historical and Realtime data using Tableau Desktop and Server

• Distributing and Sharing dashboard across enterprise using tableau server, Enabling permissions to users, Managing ownership and scheduling instances for reporting

• Automation of several data workflow using triggers and automated jobs using Autosys workload Automation

• Development and testing of Autosys JIL and scripts, development of Box, Command and file watcher jobs in AutoSys for scheduling multiple workflows and monitoring failures

• Development of re-usable workflows and datasets for self-serve reporting for business users

• Building Tableau data layers such as .tde and hyper files for reporting

• Data Analysis to determine to content, structure and Quality of the data

• Delivering data insights on ad-hoc basis to the key operational users by using PL/SQL, Vertica, Toad, Oracle

• Planning and execution of Disaster Recovery tests and resilience testing of BI platforms

• Version upgrades and performance testing of Tableau, Alteryx, Cognos and Autosys American Airlines, Fort Worth, TX

Business Intelligence Developer (Contractor) 08/2016 –07/2020 Part of Enterprise Business Analytics Team, supporting several business groups across organization to provide BI solutions and Data Insights using various tools and technologies. Teams included:

- Airport Technology

- Development and Maintained Tableau Reports and Power BI Reports. Migrated all Cognos 10 content to Cognos 11 – 800+ Reports, FM models, Cubes Maintenance and Production Support for Customer Planning & Enterprise Data Analytics Teams. (400 Reports)

- Enterprise Business Analytics

Provided BI solutions and Data Insights for Customer Experience Business group using various Tools and Technologies.

- SMS SSE Analytics

As a part of the SMS SSE Analytical database project, developed business solutions to connect various safety management applications across American Airlines and built a consolidated view of safety dashboards, reports and model for ad-hoc analysis.

- ETQ Upgrade

As part of ETQ Application upgrade, developed testing and debugged existing Tableau Reports, Cognos artifacts such as FM Model, Transfer Model, Reports and Dashboards.

- OSHA Trac

Replication of existing OSHATrac Web Application to Cognos reports/dashboard and IOSA Reporting development. Developed Adhoc Cognos FM Model and Reports. Responsibilities:

• Worked with both structured and unstructured data to create ad-hoc BI visualizations.

• Served as a point of contact for several BI projects and planned, developed, managed all the activities from development, testing, production, release and maintenance of the product.

• Development of analytical solutions by creating Dashboards, Visualizations and Reports using IBM Cognos, SSRS, Power BI, Tableau, and Microsoft SQL Reporting Services (SSRS).

• Developed Power BI reports using DAX calculations and queries.

• Developed reusable data sets or models using data flat files, cloud sources.

• Developed custom visualization in Power BI.

• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.

• Used Power BI service and Power BI app for sharing, building dashboards and consumption of reports and visualizations.

• Used Alteryx tool to cleanse and transform the data.

• Experience in Tableau Desktop, Tableau Prep. Tableau server, Tableau online, Tableau Reader and Tableau public.

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Experience working on load expressions, parameters, filters, calculations, cross-joins, blending, creating visualizations.

• Worked with multiple data sources such as Oracle, SQL Server, and Teradata.

• Developed Data Ingestion flows using Apache NiFi, Apache Kafka to load data into Data Lake (Big Data).

• Experience in ADF (Azure Data Factory), ADX (Azure Data Explorer), Data bricks, Azure Data Lake, NoSQL Data base Apache Cassandra.

• Development of Multiple ETL jobs using IBM Data Stage to Transform and load both Structured and unstructured data in to Data Ware house.

• Scheduling ETL jobs using IBM Tivoli Workload Scheduler and Use of IBM UCD (Urban Code Deploy) for automated deployment of code in Dev, Test, Cert and prod environments.

• Creating Cherwell Incident Tickets, JIRA’s and working on xMatters for deployments and production support Items.

Anda Inc., Fort Lauderdale, FL

Business Intelligence Developer (Contractor) 10/2015 – 07/2016 Responsible for development and testing of data marts, data dictionary, business views and analytical layer to support the existing business and to enhance the usability of the environment for BI Reporting, dash boarding and analytical activities for the sales/pricing domain. Responsibilities:

• Created Reports and Dashboards using Report Studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Up and Drill Down).

• Worked closely with Data Warehouse Team in Design, Development and Implementation of the project.

• Worked on POC by extracting, transforming and modelling the data using Cognos Data Manager

• Analyzed the Database Tables and views and extracted the sql for creating Framework models and packages according to business requirement.

• Developed Cognos Reports and Dashboards.

• Ran test scripts and documented the defects in JIRA.

• Generated reports to discuss the defects and hosted handoff meetings with developers.

• Worked with multiple Application and the Data teams in Fixing the Bugs.

• Designed and implemented the folder structure for Cognos in DEV/PROD.

• Demonstrated BI reports to show the functionality and different flavors of the tools.

• Created List reports, Charts and Cross-tab reports using Cognos Report Studio.

• Developed Dimensional modeling using Framework Manager and generated reports using Analysis Studio and Report Studio.

• Created securities for different user groups at package level for read, write and execute permissions.

• Created multiple dashboards on Operations, Sales Trending etc. Saxon Global, Irving, TX 01/2013 – 09/2015

BI Analyst

Responsibilities:

• Designed and implemented workflows using UML modules for logistics process.

• Created ad-hoc reports to users in Tableau by connecting various data sources.

• Analyzed the database tables by writing the SQL queries.

• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

• Coordinated with the offshore team in delivering the requirement, in design and development of Reports and Cubes.

• Installed database clients for SQL Server 2005 and Oracle, established and tested database and content store connectivity on the Cognos Production environment.

• Created Executive Level Dashboards in Cognos showing various high level key performance indicators.

• Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.

• Created SOP for migration of Framework Manager Packages, reports, Data Manager Packages, fact builds, dimension builds and the job streams.

• Created reports such as Job Size, Port Warehouse Inventory Management, Gross Margin Reports against the finalized Freight and non-finalized freight factors present in the cube.

Contact this candidate