Harika Paleti

Email: actdv5@r.postjobfree.com

Ph: 724-***-****

Professional Summary:

Over 6 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.

3 years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.x, 8.x and 9.x as a Developer, Analyst and Site Administrator and 4 Years in Business Objects, Web

Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Worked on the development of Dashboard reports for the Key Performance Intelligence, Crystal reports and Xcelsius.

Experience in interacting with various business stakeholders and able to gather the business specifications and translate into data visualizations for effective decision making.

Created various views in Tableau (Pie Chart, Bar charts, Line charts, scatter plot, Maps)

Experience includes technical support, troubleshooting, report design and monitoring of system usage.

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameters in Tableau.

Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.

Indicators for the top management.

Wrote various T-SQL stored procedures and Triggers to carry out various tasks in SQL Server 2000/2005 and 2008 platforms.

Good knowledge of Database installation and configuration principles.

Installed, administered and updated oracle database tools and systems.

Well experienced in defining, designing, integrating and reengineering the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle with multiple Terabytes of size and various levels of complexity.

End to end experience in designing and deploying data visualizations using Tableau

Designed and maintained Qlikview applications.

Maintained user guidelines for Qlikview applications

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and maintaining the Tableau sites.

Experience working in Business Objects Web Intelligence and Xcelsius Dashboards.

Provide Technical support for troubleshooting and fixing of Business Objects issues.

Has ability to learn quickly and adaptable to new environment.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like SQL server, Oracle and flat files

Created many Drill through and Drill Down reports using SSRS.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

Worked on converting SSRS reports to crystal reports.

Exceptional understanding of Business intelligence and Data warehousing concepts.

Education Summary:

Masters in Management Information Systems, UIS, Springfield, IL (2009)

Technical Skills:

VIZ Tools : Tableau Desktop 7.x, 8.x, 9.x, Tableau Server, Business

Objects Xcelsius 2008, Google Analytics, Qlikview

Reporting Tools : Business objects Webi, Crystal Reports, SSRS, CCL

Languages : SQL,C,C++,HTML, TSQL

Database : SQL Server 2008/2012, Excel, SQL, Oracle, My Sql

Operating System : Windows7,XP, Server 2008/2003

ETL : Informatica, SSIS

L- Brands Columbus, OH Oct 2012 to Nov 2015

Role: Tableau Dashboard Developer

Projects Description:

Working for Enterprise Analytics Team which provide the services to multiple business partners on different applications. It gives me the opportunity to work on multiple projects related to Logistics, Forecast, Cost Savings, Brand Analysis, Work Progress and Freight Analysis Dashboards.

Key Responsibilities:

Worked with various business stakeholders to gather the business specifications and translate into data visualizations for effective decision making.

Worked on Collaborating with the business users / business analysts to understand the requirements and demonstrate aesthetic data visualization options.

Created dashboards by Extracting or connecting Live data from different Data sources.

Participated in design / data modeling / requirements analysis / debugging discussions with technology team to find optimal solutions.

Involved in ETL process of getting the data from Legacy systems, Transforming that using SAS and loading into newly created tables as per the dashboard requirements.

Profile data (SQL, Excel, Reporting tools), create source data queries, joining data from multiple sources to satisfy reporting requirements.

Worked on Requirement gathering and creating Mockup's for Business partner approvals

Developed Tableau Dashboards using Different kinds of Charts and Maps.

Created dashboard using parameters, sets, groups and calculations.

Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Created calculated fields, mapping and hierarchies to meet specific user needs.

Created drill through reports in dashboard and also worked on creating buttons to switch across multiple dashboards using Dashboard actions.

Worked on data blending and linking in case of merging different sources.

Created a dual-axis chart with multiple measures and Synchronize the scale as per the need.

Performed Tableau type conversion functions when connected to relational data sources.

Created incremental refreshes for data sources on Tableau server.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Used Google Analytics to track activity of different applications and to improve performance.

Worked on pulling Google Analytics data into Tableau in automatically scheduled refreshes.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Created report schedules, data connections, projects, groups in Tableau server.

Embedded Google maps with Tableau to make it seamless to users to navigate.

Created Dynamic screen displays for different groups, based on their access levels.

Provided lot of custom solutions to the users to meet their requirements like downloading the full data set from Tableau easily by proving the Handy buttons on dashboard.

1 click export of dashboard data to csv using the customized solution.

Supported team and end-users as a Visualization Subject Matter Expert (SME) through troubleshooting, recommending solutions and identifying opportunities to solve business problems through BI.

Consulted on Tableau server performance enhancements; upgrades from version 8.0 to 8.1.5 and server reconfiguration based on workbook complexity and data extraction

Customized the Tableau landing page with site listing as icons and descriptions

Environment : Tableau 8.x, 9.x, Tableau Server, SQL server, Google Analytics, Oracle, SAS Packages.

Credit Suisse, Manhattan, NY June 2010 – Aug 2012

Role:Tableau/Business Objects Xcelsius Dashboard Developer

Responsibilities:

Gathered requirements from functional users, extracting data, building universes, designing reports and dashboards as per the business requirements and co-ordinated across different teams for integration.

Converted the gathered info from users into reporting requirements, and did gap analysis against database and come up with Strategic approach of the dashboard using Xcelsius.

Developed Xcelsius/Tableau dashboards for presentations, live data dashboards with alerts, Calculators,

Historical data comparisons, what if analyzers for real time understanding of changes in business and embedding of dashboards into webpage.

Worked and coordinated with different users and businesses in EMEA, Singapore and India.

Very good experience working with multiple Team / Onsite / Offsite work model.

Created different dashboard with KPI’s of Interest Claims, Bank Charges, Brokerage, Equities and Cash securities.

Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.

Created Live data Xcelsius dashboards using QaaWS and Live Office.

Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.

Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports in webi.

Extensively worked on drill mode to view data in different Perspectives.

Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.

Prepared Test Cases and Test Scripts for Unit Testing.

Involved in Unit testing, System testing and User Acceptance Test (Dashboards and Reports) throughout migration process.

Created Operational Dashboards, Tactical Dashboards and Strategic (Scorecards) Dashboards for various requirements with QaaWS and Live Office data feed.

Opendoc has been created to allow the users to access the dashboard directly without navigation thru the info view portal.

Worked on Creating Groups and giving access to users up on approval of the access.

Worked on migrating the reports across the different Envi’s

Provided production support for the Dashboards.

Worked on complete end-to-end tactical solution of a dashboard where queried data is loaded into database with a Flag representing the time where the reporting and the dashboard filters based on this time flag.

CCL, Power insight, and business objects report development.

Used Remedy for all ticket tracking purposes.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like SQL server, Oracle and flat files.

Worked on Converting Existing SSRS Reports in to Dashboards.

Installed and Created Tableau Dashboards using different charts and worked on multiple POC’s.

Used Tealeaf Analytics to capture the customer site activity to find site errors or issues and understand the impact on the business process

Environment : Tableau Desktop 7.x, Tableau Server 7.x, BOBJ XI R3.1 (SP2) Enterprise, Xcelsius 2008, CCL, Power insight, SSIS, Informatica Power center 8.6, Tealeaf Analytics, Oracle 10g,

AOPC Harrisburg, PA June 2009 – May 2010

Role: Business Objects/Crystal Reports

Responsibilities:

Analyzed existing model and customer requirements.

Extensively worked on crystal reports for Elections and Addendums in modifying the existing templates and in creating new ones and also worked on the functionality to reduce the number of crystal reports needed to a minimum.

Created pages for the purpose of selecting particular addendums and contractors from the list that comes up for a particular department.

Worked on integrating the crystal reports with the client’s web application using JRC as an individual component.

Analysis of customer specifications and custom design of applications.

Wrote various T-SQL stored procedures and Triggers to carry out various tasks in SQL Server 2000/2005 and 2008 platforms.

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports.

Designed Views /Stored Procedures to be used in the reports for better performance.

Worked on troubleshooting of different database connectivity, performance tuning.

Worked on converting SSRS reports to crystal reports.

Designed and maintained Qlikview applications.

Maintained user guidelines for Qlikview applications.

Developed reports with Parameters, Sub-reports, Cross-tabs and Charts based on Stored Procedures and Queries by using crystal reports.

Environment : Business Objects XI, Crystal Reports 10/XI, C, SSRS, Qlikview 9.0, MySQL.

Contact this candidate