SASITEJA

754-***-****(M)

Email-Id: acquq2@r.postjobfree.com

SUMMARY:

* ***** ** ********** ** Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web-based Applications and Databases . 4+ years of experience of building impactful reports and dashboards using major BI toolsets with an emphasis on Tableau.

Experience in all phases of the SDLC lifecycle to include requirement gathering from business, design, architecture, development and delivery using Waterfall and Agile methodologies.

Provide guidance and insight on data visualization and dashboard design best practices. Develop visually informative dashboards, customized reports based on business requirements and UI specifications.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Tableau development skillset includes visualization development, use of parameters, and report optimization. Identified key business metrics measurements and developed methods to represent data in support of the measurements.

Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

Perform development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.

Responsible for analyzing customer’s clinical and business data, designing new analytics solutions and proposing new dashboard visualizations.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Extensive experience on building dashboards using Tableau.

Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons),Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas.

Self-directed, well organized, deadline driven. Excellent team player with strong communication, technical documentation skills and problem solving skills.

SKILLS SUMMARY:

BI Software/Programming Languages

Tableau Desktop, Tableau Server

Databases:

MS SQL Server 2000/2005/2012

Operating Systems:

Windows

Other Software’s

MS-Office, MS-Excel

WORK EXPERIENCE:

Advance America - Spartanburg, SC

June 2014 –April 2015

Tableau Report Developer

Advance America is a wholly owned subsidiary of Grupo Elektra, one of the largest Latin American providers of banking services, consumer finance and specialty retailing. Advance America complies with all federal and state laws and always presents its fees clearly and completely. They are a proud founding member of the Community Financial Services Association, which encourages fair and fully disclosed lending practices.

Roles and Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Conduct Tableau user training, analyze business process, gather requirements, and bridge the needs of the business with the use of Tableau visual analytics and systems best practice.

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

• Converted metric insight reports to tableau reports.

• Worked collaboratively with a team of developers to build ETL process needed for reporting.

• Created Tableau reports based on existing Excel reports. Effectively used data blending feature in tableau.

• Implemented best practices to improve dashboard visualizations.

• Administered user, user groups, and scheduled instances for reports in Tableau.

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

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

• Provided 24/7 production support for Tableau users. Executed and tested required queries and reports before publishing.

• Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting.

Environment: Tableau Desktop 7.0/8.0,8.1,8.2, SQL Server 2008/2012, Microsoft Excel, Tableau Server 7/8.0, Oracle 10g/11g.

Blue Cross Blue Shield - Topeka, KS

Feb 2013 – June 2014

Tableau Report Developer

BCBS is the largest and most experienced health insurance company in the state, providing more than 7.3 million members with comprehensive and affordable health plans. There are 37 Blue Cross and Blue Shield Plans throughout the United States. Each Plan is separate and independent but all Plans cooperate with other Blue Cross and Blue Shield Plans in the exchange of ideas, processing of claims and providing inter-plan services to customers.

The scope of this project is to create number of dashboards and the reports to help the business users to monitor the performance of their overall sales that deals with all the applications that the BCBS Universal is running on. This helped the business users to compare the Last Year Sales with the Current Year Sales and helped them to plan the budget for the future.

Roles and Responsibilities:

•Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

•Created Data Connections, published on Tableau Server for usage with operational/Monitoring Dashboards

• Administered user, user groups, and scheduled instances for reports in Tableau.

• Built complex formulas in Tableau for various business calculations.

• Created and assisted users in Tableau dashboard development

• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

• Developed business process and technical design documentation for each reporting service developed in this project.

• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.

• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.

• Created various complex SQL Queries, Stored Procedures, and User Defined Functions to implement the business logic.

• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 7.0/8.0, Tableau Desktop 8.1, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, Windows 7, SQL Server 2008, SQL BI Suite (SSIS, SSRS) /DBA, Oracle 11g, Toad, MS Office.

Satyam computer Services Limited-Parsippany, NJ

Aug 2011 – Feb 2013

Tableau Developer

Project 1: OPTUS

Project 2: MACBETH

Description: Satyam is an IT outsourcing company that recruits candidates to work for their clients around the world. In this project I worked on 2 projects based on Tableau platform for an Australian Telecom company OPTUS. MACBETH project had to clarify the problems arising in the Database when the new customers are purchasing a SIM card or existing customers upgrade their services .4G broadband service was also added in their services. Premium Voicemail is the project that dealt with new service of free trial period voicemail for new and existing customers and their upgrades after a month, if opt by customer.

Roles and Responsibilities:

Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.

Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.

Ensured projects were completed on time and within budget.

Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.

Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.

Worked with all levels of development from analysis through implementation and support.

Resolved end user reporting problems through collaboration with IT and Operations.

Environment : Windows XP, Windows 7, Tableau 7.0, Tableau Server,SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL,VB

Union Bank, Los Angeles, CA

Feb 2009–Aug 2011

SQLServer BI Developer (SSIS/SSRS)

Description: Union Bank is a full-service commercial bank, providing a broad mix of financial services to businesses and individuals. Among the bank's markets are consumer, small business, middle market, real estate, corporate, correspondent, and trade finance. The project scope was to assist the marketing and sales departments to categorize their customers based on portfolio of services like checking accounts, savings accounts, personal loans and also categorizing them demographically.

Roles and Responsibilities:

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Wrote efficient stored procedures for the optimal performance of the system.

Monitored performance and optimized SQL queries for maximum efficiency.

Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.

Created indexed views and appropriate indexes to reduce the running time for complex queries.

Generated custom and parameterized reports using SSRS.

Created reports that call sub reports in SSRS.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Responsible for creating datasets using T-SQL and stored procedures.

Created several packages in SSIS.

Scheduled the packages to keep extracting the data from OLTP at specific time intervals.

Used various transformation tasks to create ETL packages for data conversion.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Responsible for rebuilding the indexes and tables as part of performance tuning.

Used SQL Server Agent for scheduling jobs and alerts.

Performed Query optimization & Performance Tuning.

Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#,T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access.

ING Group, Hyderabad, India

July 2007 – January 2009

SQL Server Developer

Description: It is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. It maintains users checking and saving account information, allows users to make a payment, transfer funds.

Roles and Responsibilities:

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.

Validated change requests and made appropriate recommendations. Standardized the implementation of data.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.

Managed user access and Created new security accounts.

Performed Backup and restore of databases.

Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.

Updated the statistics information for both the old and new servers.

Assisted with various ad hoc query requests.

Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.

EDUCATION

Bachelors in Electronics and Communications Engineering

Acharya Nagarjuna University, India.

Contact this candidate