Data Tableau

Kiran Kopperla

E-mail address: *************@*****.***

Phone # : 404-***-****

EDUCATION:

Thangavelu Engineering College

Madras University Chennai, India

Bachelor of Engineering (Computer Science) Aug 1996 to May 2000

WORK EXPERIENCE:

Skills : Tableau . SQL, Python, ML and AI (beginner)

Trainings: Python, Machine Learning, Blockchain, AWS Associate Architect

Deloitte Consulting LLP (i-Lab) Atlanta, GA

Sr Product Engineer May 04, 2015 – Present

At Deloitte innovation lab, developing a pricing product for all customer needs where showing the data with more visualizations by providing user to see granular data and quickly to make decisions by comparing competitor products in the market. This product compromised with Pricing, Profitability and Promotions modules where client can see a snapshot of his products on dashboard with alerts of revenue, profit and ROI and by comparing with last year’s performance to move on detail analysis. This product is developing to fulfill all customer needs and will be customized for each customer based on needs

Design and Develop Tableau visualization reports using data extracts from SQL to understand granular data by prviding options of filters and parameters to view charts with multiple options with KPIs and metrics by highlighting with colors. Publishing these reports on Tableau server to integrate with UI using API

Performing Tableau Server administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.

Understanding and translate business needs into data models by working with the Application Development team to implement data strategies, build data flows and develop conceptual data models.

Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

Applying data modelling techniques, writing stored procedures, preparing required tables / views before consuming data on Tableau.

Executing all phases of SDLC using Agile for cloud-based software and advanced analytics products in a distributed environment by using Jama and Jira tools for user stories and defects.

Integrating Tableau Dashboards on web using Java scrpit, HTML and REST API.

Provided innovative solutions to the client so that the source code block in the target transaction can be captured without copying the entire code block.

IBM Hyderabad, India & Atlanta, USA

Client: SunTrust, Atlanta Dec, 2012 – Apr, 2015

Treasury & Payments work stream The Large Cash Reporting System (LCRS) is a comprehensive solution product to support all Bank Secrecy Act compliance processing needs developed by Check Free Corporation and hence not an In-hose application of Sun Trust Bank.

Customer information system, where will maintain the customers data from different consumer channels stored in DB2 and Oracle databases

IT Specialist

Worked with the SunTrust organization as a Reporting / Data Analyst to assess client requirements and creating dashboards for stakeholders to assess their market strategy region level and forecast reports on costs and revenue for future growth.

Interact with business users for gathering requirements for BASV Projects to compliance with federal regulations.

Prepared use cases and design documents with all possible filters and parameters on axis to see data / charts in different ways .to understand the reports which would be helpful to understand business.

Extract the data from multiple data sources and creating a view using SQL queries which would feed data for developing dashboards on Tableau

Presenting to dashboard reports with senior executives and sales representatives every weekly /monthly help to understand business

Providing in-depth analysis and recommendations on branch and region level reports to managers to take actions for better performance

Generate Tableau dashboards for e-bills and paper bills comparison to bring down the cost of organization

Publish workbooks by creating user filters so that only appropriate teams can view it instead of sending large files to each stakeholder

Use filters, quick filters, sets, parameters and calculated fields on Tableau reports.

Perform incremental extracts for OLAP database to refresh updates every night so all reports are up to date

Create actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter.

Review peer reports and calculations before publishing on to server

Environment: Tableau, DB2, Oracle, ETL, Data modelling, SQL Server, Java script, HTML, CSS

IBM Hyderabad, India

Client: SunTrust, Atlanta Nov, 2008 – Oct, 2012

SunTrust Banks, Inc. fraud detection application is Fraud Image Analysis (FIA) system is to identify fraudulent checks based on their images and reduce ASI 16-FraudLink On-Us false positive results. Fraud Image Analysis solution consists of multiple components: Item Feeder, Image Analysis Engine Sereno, Message Broker (Controller), FIA Operational Database, PEGA Rules Engine, BI Tableau Dashboards and SunTrust Exception Portal (STEP).

IT Specialist

Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Data blending implemented on EMPI databases and generated interactive dashboards.

Created adhoc reports to users in Tableau by connecting various data sources.

Handled Tableau admin activities granting access, managing extracts and Installations.

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

Analyzed the source data and handled efficiently by modifying the data types.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Generated context filters and used performance actions while handling huge volume of data.

Resolutions of the production problems within the Service Level Agreements (SLA’s) defined and ensure system availability with on call support and providing fixes in cases of failure. And also providing the necessary follow up on the production issues

Coordinate and manage response to production outages/problems for applications related to fraud image analysis and check image retrieval systems.

Application performance tuning and optimization

Application GAP analysis, Support Daily Operational Meetings and Weekly

Environment: Tableau, Microstrategy, Qulikview QDB2, ORACLE 9.0, PEGA, DB2, MIDDLEWARE MB 0, Harvest, Endevor, Mainframe, CPCS-CICS.

IBM Hyderabad, India & Toronto, Canada

Client: Bank of Montreal, Canada Mar, 2006 – Oct, 2008

The Investment Products System (IPS) is a GIC Term Investment product manufacturing & administrative system. Its main function is to set up and maintain the customer’s savings, GIC and term deposit products.

This application is interconnected with numerous other BMO applications and its design pattern supports both online and offline transaction streams. Currently, IPS is supporting the following Investment plan types.

Software Engineer

Analyzed system to make sure that all programs run in sequence to update database and generating reports

Monitoring all complex jobs and providing solutions for abended jobs immediately so system would be up and running for all queries

Gathered required information from Business analysts and preparing technical design documents and coming up with estimates

Preparing release documentation plan and sending across all impacted stake holders for their support and concurrence on code changes

Created new data base tables as per requirement

Deliver new and complex high quality solutions to clients in response to varying business requirements

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer and onsite coordinator.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Utilize in-depth knowledge of functional and Technical experience and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: IBM Mainframe 3090, MVS 3.0, COBOL, CICS, JCL, QUIKJOB, IMS DB, DB2.

Tata Consultancy Services Mumbai, India

Client: Merrill Lynch, USA Apr, 2004 – Feb, 2006

Merrill Lynch (ML) is a leading global financial management and advisory company with a Global presence in several countries across six continents. It serves the needs of both individual and institutional clients with a diverse range of financial services. The Account Billing and Control System (ABCS) is the primary system used by Merrill Lynch to bill Proprietary and Non-Proprietary Fund Groups. It calculates the commission, which is paid by the fund groups to the FDS for providing the services of transfer agency. First all the fund groups sign agreement with the FDS for providing the services of the transfer agency. For a fund group different type of invoices could be generated. Each invoice type is associated with different with different fees depending on the services provided. Each fee could be account based, transaction based or asset based

Developer

Understood billing process, generated billings as per requirement

Exporting all invoices on to web for viewing

Designed and developed Reports with SAS.

Enhanced existing code as per the new requirements by the client

Performed Unit testing and system testing

Supported applications 24/7

Worked with Business analysts on requirements and created technical design documents.

Environment: MVS, CICS, COBOL, JCL, DB2, VSAM, Endevor, File-AID, Xpediter, IMS DB

Contact this candidate