Lakshmi Akkineni

https://www.linkedin.com/in/lakshmiakkineni/

https://public.tableau.com/profile/lakshmiakkineni#!/

adken0@r.postjobfree.com

+1-608-***-****

Professional Summary:

10+ years of experience in Business Intelligence, Tableau, Power BI, Business Objects and Data Warehousing.

Developed Power BI dashboards as POC and converted Business Objects report to Power BI reports and good knowledge on Microsoft Azure.

Developed different charts types including Bar, Line, Stacked bar, Waterfall, Stacked Column, Cluster bar, Cluster Column, 100% Stacked bar, 100% Stacked column, Area, Stacked Area, Line & Stacked Column, Ribbon, Funnel, Scattered, Pie, Donut, Tree Map, Map, Filled Map, Score card, etc.

Involved in Development, Testing, Migration and Production Support on various platforms.

Expertise in Tableau Desktop versions 2018.x/10.x/9.x/8.x for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Involved in coordinating Tableau Upgrade from 10.5 to 2018.3, upgrade from 10.1 to 10.5 and upgrade from 9.x to 10.1.

Managing tableau project folder, Groups and content as Tableau Site Administrator.

Good hands-on experience on Tableau Trusted Authentication dashboard deployment process and Tableau site administration.

Experience in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Good knowledge on Alteryx and created Alteryx data sets.

Hands-on experience in Alteryx Designer, Alteryx Server, and Alteryx tools such as Predictive, Parsing, and Transforms.

Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool such as Tableau.

Worked on different versions of Business Objects 4.1/4.0/XI 3.1/XIR2 (CMS, Info View, Launch Pad 4.0/4.1, Designer, IDT 4.0, Desktop Intelligence, Web Intelligence, Import Wizard, Xcelsius and Dashboard Design.

Extensively worked on SAP BI 4.1/4.0(SAP BI Launch Pad, SAP Web Intelligence, SAP IDT, SAP UDT and SAP Dashboard Design).

Created Universe with @Functions, PROMPTS, Filters, Cascading Prompts and Context.

Technical proficiency in creating interactive dashboards and scorecards using Xcelsius 4.5/2008. Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius.

Strong skills in Requirements gathering, Analysis and proficient in preparing mockup and technical specifications.

Proficient in full-client and web-based (WEBI) reports development and universe design, troubleshooting, scheduling, publishing and security

Expertise in Designing, Developing and managing the complex universes. Highly skilled in creating Adhoc/Canned Reports, Complex Reports using predefined conditions.

Generated Desktop intelligence, Web intelligence reports using Drill down and Drill up features in Business Objects. Implemented Alerts and Break on all types of Reports.

Worked on different phases of project life cycles including Requirements gathering, Designing, Developing, Distributing and maintaining Universes with SAP BI/BW as a data source.

Created reports in cross tab, master detail format and transformed them in 2-D, 3-D Column, Line, Area, and Pie charts for graphical analysis

Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tools (Repository Manager, Designer, Workflow Manager and Workflow Monitor).

Experience in integration of various data sources like Oracle, DB2, SQL Server, Teradata, Flat Files, Mainframes and XML files into Data Warehouse, Data Cleansing, Data Transformation and Data Loading.

Experience in implementing update strategies, incremental loads and change data capture (CDC).

Strong experience in Data Warehousing and ETL using Informatica Power Center 9.X/8.x.

Experience in developing Mappings, Sessions and Workflows using Informatica Power Center.

Experience working with various transformations like Source Qualifier, Expression, Joiner, Filter, Aggregator, Router, Update Strategy, Sequence Generator etc.

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing data warehouse schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.

Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.

Good experience with various SDLC Methods like Waterfall, Agile & Scrum methodologies.

Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent interpersonal and communication skills with a sense of ownership.

Experience in defining Unit Testing, System testing User Acceptance testing (UAT) scenarios and execution.

Good knowledge on Python language.

Technical Skills:

Business Intelligence/

Reporting Tools

Tableau 2020.x/2019.x/2018.x/10.x/9.x/8.x/7.x,Power BI Desktop, Power BI server, SAP Business Objects 4.2/4.1/4.0/3.1/XIR2 (CMC, Designer, Information Design Tool, Info View, Launch pad, Import Wizard, Upgrade Management Tool, Promotion Management, Web Intelligence, Desktop Intelligence, QAAWS, Explorer, Live Office, Crystal Reports 2011/2008/XIR2/10, Xcelsius 2008/4.5

Utilities

Erwin 3.5, Visio, TOAD, SQL * Loader, SQL Developer

Operating Systems/Platforms

Windows XP/NT/2003/2000, UNIX

Database/Data Warehouse Servers

Oracle11i/10g/9i/8i/7.3, MS-SQL Server 2008/2005, DB2, Teradata, MS Access

Programming Languages

SQL, PL/SQL, C, Java, .Net, HTML, XML, Java Script

ETL Tools

Informatica Power Center 9.1/8.6.1, Alteryx

Educational Qualifications:

Bachelors of Science

Professional Experience:

Bank of the West, Tempe, AZ Mar 2020 – Till date

Business Reporting Analyst/Developer (Power BI/Tableau/Business Objects)

Description: Bank of the west is a regional financial services company, headquartered in San Francisco, California and It is a subsidiary of BNP Paribas. It has more than 600 branches and offices in the Midwest and Western United states.

Responsibilities:

Interacted with Business SMEs to gather and analyze the Business Requirements in developing and modifying and building the reports & data visualizations using Power BI & Tableau.

Developed Power BI dashboards as POC and converted Business Objects report to Power BI reports.

Developed different charts types including Bar, Line, Stacked bar, Waterfall, Stacked Column, Cluster bar, Cluster Column, 100% Stacked bar, 100% Stacked column, Area, Stacked Area, Line & Stacked Column, Ribbon, Funnel, Scattered, Pie, Donut, Tree Map, Map, Filled Map, Score card, etc. using Power BI Desktop.

Involved in setting up SME SBA, etc. Power BI server folder structure on Power BI server.

Generated numerous Tableau internal Data Visualizations/reports like Ad hoc, Daily, Monthly, Quarterly and Yearly reports.

Created mockup visuals to speed up requirements & development for visualization.

Created action filters like Page Level, View level and calculations/formulas using DAX for dashboards.

Created PowerBI Data Visualizations against Flat files and Databases like Oracle, SQL Server, DB2 and using SharePoint site.

Created rich visuals to the Underwriting, Case Management processes for better monitoring and case processing.

Created various Data Visualizations for Executive management to monitor important key performance Indicators like Underwriter queue, Doc Deficiency, COVID vs SME Impact, PPP Loans, Deferrals, etc.

Created Prompts, customized calculations, conditions and Filters (Local, Global) for various analytical reports and Data Visualizations.

Involved in Trouble Shooting and Performance tuning of PowerBI reports and dashboards.

Created channel wise, product wise dashboards for Management, created customer and case details dash boards and reports.

Worked on dashboards to monitor performance across business including portfolio, Small Business loans,etc.

Involved in migrating data from multiple sources to target using Oracle SQL Server and ETL tool.

Environment: Business Objects BI4.2, Tableau Desktop 2020.x, Tableau Server 2020.x & Power BI Desktop, Power BI Report Server, Tableau Reader, SQL Server & Oracle.

Invesco Ltd., Chicago, IL Jul 2015 – Feb 2020

Sr. Business Intelligence Developer (Tableau/Business Objects/ETL)

Description: Invesco Ltd. is an American independent investment management company that is headquartered in Atlanta, Georgia, United States, and has branch offices in 20 countries. Its common stock is a constituent of the S&P 500 and trades on the New York stock exchange.[5] Invesco operates under the Invesco, Trimark, Invesco Perpetual, WL Ross and Power shares brand names.

Responsibilities:

Interacted with Business SMEs to gather and analyze the Business Requirements in developing and modifying Universes and building the reports using Tableau & PowerBI.

Developed different charts types including Bar, Line, Stacked bar, Waterfall, Stacked Column, Cluster bar, Cluster Column, 100% Stacked bar, 100% Stacked column, Area, Stacked Area, Line & Stacked Column, Ribbon, Funnel, Scattered, Pie, Donut, Tree Map, Map, Filled Map, Score card, etc. using Power BI Desktop.

Involved in coordinating Tableau Upgrade from 10.5 to 2018.3, upgrade from 10.1 to 10.5 and upgrade from 9.x to 10.1.

Managing tableau project folder, Groups and content as Tableau Site Administrator.

Played key role in implementing Tableau Trusted Authentication and embed/deploy Tableau dashboards on web pages or with in the .NET applications.

Developed different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Deployed Tableau Data Visualization using Trusted Authentication and embed dashboards right in the .NET applications.

Generated numerous Tableau internal Data Visualizations/reports – Life, annuity, Claims, region wise, product wise.

Created mockup visuals to speed up requirements for visualization.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets.

Created Tableau Data Visualizations against Flat files, XML and Database Sources.

Created rich visuals to the Underwriting, Case Management processes for better monitoring and case processing.

Created various Data Visualizations for Executive management to monitor important key performance Indicators like region wise sales, product wise sales, etc.

Worked on complex formulas in Tableau for various business calculations and reports.

Created Prompts, customized calculations, conditions and Filters (Local, Global) for various analytical reports and Data Visualizations.

Good knowledge on Alteryx and created Alteryx data sets.

Hands-on experience in Alteryx Designer, Alteryx Server, and Alteryx tools such as Predictive, Parsing, and Transforms.

Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool such as Tableau.

Involved in Trouble Shooting and Performance tuning of Tableau reports and dashboards.

Created channel wise, product wise dashboards for Management, created customer and case details dash boards and reports.

Worked on dashboards to monitor performance across business including marketing analytics, sales trends, case reports, and customer profiles.

Involved in Universes development by defining joins, cardinality between tables, derived tables, creating prompts and filters.

Developed multiple universes for Policy Data warehouse.

Developed back end functions, procedures, tables, views required by the BO universes

Responsible for creating Dynamic Filters and Dynamic conditions in universe level as per Business rules.

Improved performance and reduced the coding with the reuse of @functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes.

Developed custom List of Values (LOVs) for better understanding of prompts by end users.

Developed Tableau reports, created charts and graphs for quick analysis of policy data by regions, category, product wise, face amount ranges from various systems.

Developed Dashboards and Scoreboards for detailed analysis using Tableau.

Worked on Universes, Reports, Users and User Groups. Worked on migration from Development environment to Testing and Production environment by using import wizard

Involved in Test cases and test data preparation for testing

Worked on queries performance and created indexes.

Developed Power BI dashboards as POC.

Prepared Unit Test Cases and System Test Cases for both Universes and Reports and executed the test cases using HP Quality Center.

Environment: Business Objects XI R2/XI3.1/BI4.1, Xcelsius 2008, Tableau Desktop 10.x & 9.2, Tableau Server 10.x & 9.2, Tableau Reader, Teradata

Roche Pharma, U.K Mar 2013 – Jun 2015

Sr. Software Engineer – Business Intelligence (Tableau/SAP BO/Informatica)

Description: Roche Pharmaceuticals is focused on translating excellence in science into effective medicines for patients. It combines cutting-edge research at Roche, Genentech in the US, Chugai in Japan and over 150 partners worldwide with global scale and reach in clinical development, manufacturing and commercial operations. Thanks to the Pharmaceuticals Division’s broad-based portfolio, Roche is one of the world’s leading providers of clinically differentiated medicines.

Responsibilities:

Coordinated with Business team to gather and analyze the Business Requirements in developing and modifying Universes and building the Tableau reports.

Developed different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Developed Universes by defining joins, cardinality between tables, derived tables, creating prompts and filters.

Created prototypes of the reports for user presentation in the process of requirements gathering.

Worked on various reports and Data Visualizations to show customer profiles by industry, geography, company size, product assets, revenue and other important attributes.

Created new users in using Central Management Console and set restrictions, assign privileges based on their profiles.

Created multiple universes for customer’s data.

Worked on functions, procedures, tables, views required by the business objects universes

Defined Customized Hierarchies in Universe level.

Developed WEBI reports, created Graphs and Charts for quick analysis.

Created Report Level Variables, Objects and Formula to create new columns based on the result set.

Preparation of Critical, Master Detail, Sub Reports, Cross Tab and Summary reports using Crystal Reports, features includes functions, running totals, parameters and conditional formats.

Created and shared Universes and Report documents to the Repository as part of the production deployment and made them available to the users.

Implemented Dashboards and Scoreboards for detailed analysis using Xcelsius.

Involved in training materials preparation and training for end users.

Developed data base views at data base level for reports generation

Involved in queries tuning for improving the performance by creating indexes at database level

Created Technical Specification documents for Universes and Reports.

Prepared Unit Test Cases and System Test Cases for both Universes and Reports and executed the test cases using HP Quality Center

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

Worked on Dimensional modeling to design and develop STAR schemas using ER-win 4.0, Identifying Fact and Dimension Tables

Extracted and integrated data from other financial systems, inventory systems to target database for reports generation.

Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.

Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy and Sequence generator.

Created procedures to truncate data in the target before the session run.

Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.

Designed Logical and Physical Data-marts using Dimensional Modeling (Star/Snowflake schemas) for Management Information systems and Decision support systems

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.

Stored reformatted data from relational, flat file, XML files using Informatica (ETL).

Created various batch Scripts for scheduling various data cleansing scripts and loading process.

Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.

Knowledge of Oracle PL/SQL and ability to write complex logic to manipulate data, create functional specifications for ETL mapping, mock up for Dashboard and Visualization frames.

Load historical and intraday trades, settlements, positions, and product data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyze liquidity generating performance of IMCL products.

Created, optimized, reviewed, and executed Complex SQL queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.

Environment: Business Objects XI R3.1/4.0/4.1, Informatica Power Center 8.6.1, Toad, SQL, PL/SQL, Oracle 10g/11i, Teradata, HP Quality Center, Window 2008, Linux

Lloyds Banking Group,U.K May 2010 – Feb 2013

Sr. Software Engineer – Business Intelligence (BO /Tableau/Informatica)

Description: Lloyds Bank is the largest retail bank in Britain,[8] and has an extensive network of branches and ATM in England and Wales (as well as an arrangement for its customers to be serviced by Bank of Scotland branches in Scotland, Halifax branches in Northern Ireland and vice versa) and offers 24-hour telephone and online banking services. As of 2012 it has 16 million personal customers and small business accounts

Responsibilities:

Worked with Business SMEs to gather and analyze Business Requirements in developing Universes and building the reports.

Developed Universes by defining joins, cardinality between tables, derived tables, creating prompts and filters.

Developed different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop and converted couple of xCelsius Data Visualizations to Tableau.

Worked on functions, procedures, tables, views required by the business objects universes

Developed WEBI reports, created Graphs and Charts for quick analysis.

Developed reports using Crystal Reports that include functions, running totals, parameters and conditional formats.

Created and published Universes and report documents to the Repository as part of the production deployment and made them available to the users.

Implemented Dashboards and Scoreboards for detailed analysis using Xcelsius.

Involved in creation of functions, Procedures and data base views

Worked on queries tuning for improving the performance by creating indexes at database level

Involved in preparation of Unit Test Cases and System Test Cases for both Universes and Reports and executed the test cases using HP Quality Center

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

Extracted data from SQL Server database, Flat files and Excel sheets and staged into a single place and applied business logic to load them in the central SQL Server database.

Worked on different Transformations like Router, Aggregator, Joiner, Expression and Lookup, Update strategy, Sequence generator and Stored Procedure.

Extracted data from other inventory systems, XML files to target database for reports generation

Used Toad utility for preparing and executing SQL scripts

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Designed Logical and Physical Data-marts using Dimensional Modeling (Star/Snowflake schemas) for Management Information systems and Decision support systems

Stored reformatted data from relational, flat file, Excel files using Informatica (ETL).

Created, optimized, reviewed, and executed complex SQL queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.

Environment: Business Object 3.1, Web Intelligence, Universe Designer, Crystal Reports, Informatica Power Center 8.6.1, MS SQL Server 2005, MS Visio

Contact this candidate