Data Analyst Analysis

Professional Summary

•Comprehensive background includes 16+ years in Reporting & Analysis, Project Planning & co-ordination, Web based application development. Worked on CA Clarity PPM, CMDB Service Now, Microsoft .Net and SQL Server. Data analyst, Data Modeling, Dashboards on Excel and Data visualizing using Tableau.

•Experience in Creating Parameterized, Drill Down and AD Hoc Tableau Dashboard with interactive views, trends and drill downs along with user level security with quick/context/global filters, parameters and calculated fields on Tableau reports.

•Experience in developing Various Data Models to perform Data analysis in finding the cost out opportunities on Org level, Created Data Models to Optimize the process & create various financial dashboards. Created Data Models to drive Budgeting Process across the Organization. Performed Data Analysis and Developed Data models to convert & Optimize the Financial Application (MINT) to Tableau Dashboard which optimized the Monthly Execution process by 80%.

•Experience in developing and maintaining complex Financial Dashboards such as OPEX (Operational Expenses) Tracker, Headcount Tracker, Forecast & Budgeting Dashboards.

•Optimized the MINT Billing process by 90% by reducing the complexity in execution and increased the delivery speed by using Tableau Dashboards.

•Experience in Developing and designing Data analytics in Finance, Headcount, CMDB (asset Management), Purchase order and help reporting the cost out opportunities to the customer on regular intervals helping in Budgeting process.

•Experience in Creating Standard, Crosstab, Sub reports and Dashboards in tableau for Finance department, Cyber Security Teams.

•Experience in Creating various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

•Experience in Producing monthly reports using advanced Excel spreadsheet functions.

•Optimize Device utilization by Data Analysis on Device billing and Device utilization across Aerospace Cyber tech and security group in GE.

•A business-Oriented Manager ensuring enhanced customer experience through quality and on time delivery while maintaining company profitability and high employee morale.

•Experience in design, develop web-based (.Net) applications using Asp.Net, VB.net and C# in various domains such as Insurance, CMDB and Finance.

•Experience in Develop and design systems tests, programming, and validation procedures. Write up documentation for all completed installation projects.

TECHNICAL KNOWLEDGE:

Programming Languages

Asp.net, VB.net, C#, Java Script, C, C++

BI Tools/Reporting

Tableau, Spotfire

Cloud Technologies

Service-now (CMDB)

PPM Tools

CA Clarity PPM

Web Services

WSDL, SOAP/REST API

Databases

Oracle 10g, 11g, MySQL, Microsoft Access, SQL Server 2000/2005/2008

ETL/Integration Tools

Informatica

Collaborative Tools

GE Support Central, Smartsheets

Project Management

JIRA, Microsoft Excel

Education

Bachelors of Technology – Computer Science and Information Technology 2005

Scient Institute of Engineering and Technology Hyderabad, India

Awards

•Appreciation from CIO of GE Aviation for streamlining the process to take inputs for SII Budget 2017.

•Star Award for Contributions in GE Aviation Finance Planning & Analysis in Tech Mahindra in the year 2015

•Pat on Back award for my contributions on GE Aviation Finance Planning &Analysis in the year 2016

•Pat on Back award for my contributions on GE Aviation Finance Planning &Analysis in the year 2015

•Bravo award for my Contributions in Thomson Reuters PMO Project in the year 2014

•Pat on Back award for my contributions in Thomson Reuters PMO Project in the year 2013

•Star Award for Contributions in Thomson Reuters PPM & IT analytics in Tech Mahindra in the year 2012

•Award received for exceptional commitment and dedication by leading the Employee Engagement and CSR activities for Mphasis and AIGSS in the year 2011

Work history

GE Aerospace Lake Mary, FL

Sr BI Developer/Sr Data Analyst Mar 2020 – Current

Technology: Tableau, Spotfire, .Net, Oracle SQl Developer, PostgreSQL, DBeaver, GE Internal Tools, Service-now.com, Informatica 10.1.1, Microsoft Excel, Support Central.

•Design, develop and automate the process for OPEX tracker (PO Tracker) for CTR Metrics Team in GE Aviation.

•Define the process and develop high visibility financial reports presented to Executive level leadership (Core Business Enablers, PO Summary Dashboards, Organization performance reports)

•Developing and designing Data analytics in Finance, Headcount, CMDB (asset Management), Purchase order and help reporting the cost out opportunities to the customer on regular intervals helping in Budgeting process.

•Design Data forms in Support central which will be an entry point for monthly forecast for each purchase order and all used to collect the actuals from ledger tables in finance data lakes which eliminates manual way to pulling the actuals into excel sheets

•Create data models for developing tableau reports on analysis for Purchase orders

•Create various analytics reports on Tableau for Purchase orders such as report for New PO’s coming up in the space, Ytd actuals vs Ytd forecast, Sow End dates vs Ytd actuals, Vendor Summary, etc.

•Design & develop the process to move from traditional excel sheet (OPEX tracker) to Tableau OPEX tracker

•Schedule Meetings with all the stakeholders in requirement gathering and to report the status on the deliverables.

•Design and Implement Cost out model for CTR Metrics in GE Aviation.

•Performing Cost out analysis in Hosting Billing, Device Billing, Network Billing, Cloud billing, Purchase Orders and other areas. Create various visualization to show the cost out opportunities for the leadership to help drive their budget accordingly.

•Design & develop various metrics reports (Vulnerabilities metrics, Operations dashboards, Compliance Dashboards, EVM Dashboards, CIO Details Dashboards, Cyberframework KPI Dashboard, Export control metrics reports) on Spotfire for Cyber security group in GE Aviation.

•Work with Finance Team (FP&A’s) and Create workflows on Support Central (GE Internal Tool) for collecting Inputs from Various Teams.

•Develop SQL queries in Oracle SQL to pull the Actuals data from Finance Data Lake to the data forms that are designed for populating actuals for purchase orders on monthly basis.

Tech Mahindra Americas Lake Mary, FL

BI Developer Project Coordinator Mar 2015 – Mar 2020

Technology: Tableau 10.x., Spotfire, .Net, Oracle SQl Developer, PostgreSQL, DBeaver, GE Internal Tools, Service-now.com, Informatica 10.1.1, Microsoft Excel, Support Central.

•Project coordination with Finance teams (Customers) which includes requirement analysis, Report reviews and manage end to end deliverables.

•Monitoring project progress and creating project status reports for project managers and stakeholders.

•Assisting with resource scheduling so that team members have the resources they need to complete their tasks.

•Scheduling stakeholder meetings and facilitating communication between the project manager and stakeholders throughout the project life cycle.

•Managing project management documents such as the project plan, budget, schedule or scope statement, as directed by the project manager.

•Develop and test unit code to meet business requirements for Web-based Finance applications/ Metric Dashboards in Spotfire/Tableau

•Perform Data Analysis on Device billing and Device utilization across ACTR

•Developing and designing Data analytics in Finance, Headcount, CMDB (asset Management), Purchase order and help reporting the cost out opportunities to the customer on regular intervals helping in Budgeting process.

•Lead development team involved in developing web-based billing tool (MINT) for GE Aviation for liquidating monthly bills across GE Aviation.

•Lead Data migration process from corporate instance to MINT using ETL/Informatica.

•Design various advanced fields like Pick list, Custom Formula Fields, Field Dependencies, Validation Rules, Workflows, and Approval Processes for automated alerts, field updates, and Email generation leading to effective Web-to-Lead communication with customers.

•Design and develop tools for Collecting SII Inputs and monthly forecast from Various teams across GE Aviation

•Involve in migration of data from existing Oracle DB to AWS Athena and PostgreSQL DB and developing similar functionalities in Spotfire environment

•Design develop various metrics reports (Vulnerabilities metrics, Operations dashboards, Compliance Dashboards, EVM Dashboards, CIO Details Dashboards, Cyberframework KPI Dashboard, Export control metrics reports) on Spotfire for Cyber security group in GE Aviation.

•Generate python scripts to connect to Finance data lake in GE Aviation.

•Work with Finance Team (FP&A’s) and Create workflows on Support Central (GE Internal Tool) for collecting Inputs from Various Teams.

•Provide support for code promotions and implementation

•Debug using Debug Logs and System Log Console to catch Exceptions and execute SQL queries.

•Troubleshoot, code and test bug fixes

•Planning, analysis and defining process for developing Tableau Report having Dashboards for Forecasted Values for 2019 by various Leaders across the organization.

•Create Dashboards for Inputs given on Investments for 2019.

•Create Dashboards on Analytics for the data collected for 2019 and roll out to the group

•Planning, analysis and defining process for Collecting Forecast Inputs from Various teams and rolling a report for Leaders.

•Create Data Models for Data Mash Ups using SQL queries in Oracle DB & PostgreSQL DB & Microsoft Excel and loading the data into SQL Data tables.

•Design, develop web-based tool(.Net) for PO Tracker (OPEX tracker), automate pulling actuals from Finance data lake using Custom queries in GE Support central using input/output form.

•Create automated jobs (SQL Queries, custom mapping) in GE Support Central to pull/insert data from or into the oracle & PostgreSQL dB for PO Tracker application.

•Design develop Tableau Dashboards for PO Tracker data and develop various analytic reports for Purchase order group by gather detailed use cases and requirements from the teams.

•Perform and maintain CMDB Asset management using Service-now.com for GE Aviation, which includes Create, delete, update Assets(servers) and asset information (applications, Owners, Relations on CMDB)

•Follow defined processes such as change control, time tracking, and weekly status reports

•Create Reports and Dashboards track Opportunity pipeline/Stage reports with Tableau for management visibility.

•Provide estimates of development effort for project deliverables and provide considerations for

development requests.

•Work on change requests, and performing impact analysis and providing the estimation for changes required

•Provide technical reviews for solutions

•Utilize commercial application development experience, with a focus on serving enterprise customers and building highly scalable solutions.

•Gather detailed use cases and requirements through virtual meetings and customer Advisory board sessions

•Lead communication with various stakeholders at different levels/groups on Workflows, Process, Data Issues and Tableau Report

Tech Mahindra Hyderabad,

Associate Business Consultant Aug 2011 - Feb 2015

Technology: CA Clarity PPM, Microsoft Excel

•Provide functional and technical support for CA PPM – Portfolio management, Timesheets Management, Project Management and Resource Management.

•To support all kinds of CA Clarity PPM Tool Configurations·

•Handling the complete contractor’s data, queries and reports for team Pontoon.

•Creating the projects and also handle issues related to Projects using CA Clarity PPM tool.

•Shall Extract data from Clarity Database and provide various reports on contractor data.

•Shall provide support in updating existing process documents

•Incident ticket analysis and coordination for closure.

•Creation and deactivation of accounts in clarity.

•Addressing Access related issues in CA clarity.

•Performing weekly and monthly data quality checks ·

•Responsible for overseeing the Quality procedures related to the project.

•Involve in Various reports for Forecasting and Analysis of data.

•Consolidating the forecast data every week.

•Creating the consolidated Master report for all the resources in IP & Science Partition, every week.

•Creating the different slide decks for Forecast and Actuals data representing different business units of IP &

Science Thomson Reuters.

•Knowledge Transitions on clarity for the non-technical team.

•Defined clear targets and objectives and communicated them to other team members.

•Monitored timelines and flagged potential issues to be addressed.

•Involved in Closure activities (Updating OPAs, releasing resources.) for CA Clarity Support project.

•Analysis of the specifications provided by the clients ·

•Prepare business requirement document by conducting detailed interviews with business users, stake holders and Subject matter experts ·

•Analyze business requirement document to convert it into functional requirement document ·

•Communicate with the Business teams from various locations and understand the requirements.

Mphasis Chennai, India

Delivery Senior Software Engineer Jul 2007 - Apr 2011

Technology: ASP.NET 2.0, Vb.Net 2.0, PL/SQL, Microsoft TFS, SSIS, XML, Service-Now.com, Jelly Script

•Design, develop Reports Module using VB.net, Asp.net for the Portal

•Design, develop logic for the architecture to generate the reports

•Design develop Complex reports like Ad-hoc and Activity Calendar using XML and ASP.net.

•Support the team members by creating user interface components for the application.

•Generate RDLC reports and Scheduling tasks in SQL Server.

•Communicate with customers and do the analysis of the specifications provided by the clients

•Handled Resource Management, Stakeholder management for DRE Module of VALIC

•Technical lead and involve in coding for DRE Module

•Configuration management using Microsoft TFS.

•Customize & create workflows in Service-now.com using jelly scripts.

•Created Test cases for a Service requests on Dev, QA environments.

•Followed the process of creating web requests, DB request, CMNA’s and for moving the files from Dev -> QA and QA -> to prod.

•Regularly update OPA's, Project documents which helped to coordinate with other modules of the project.

Contact this candidate