Sql Server Data

Name: Harsha Battu

***************@*****.***

Phone: 773-***-****

PROFESSIONAL SUMMARY:

•7 years of IT industry experience in Tableau, MSBI (SSIS, SSRS).

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

•Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

•Extensive experience on building dashboards using Tableau.

•Excellent analytical, problem solving and Tableau and SQL debugging skills.

•Experience with creating the Tableau dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.

•Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.

•Expertise in Business Intelligence Solutions like ETL & Reporting using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.

•Expert at Scheduling jobs which execute the SSIS package according the mentioned schedule.

•Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Snow-Flake Modeling and Star Schema Modeling.

•Great experience in performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.

•Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations

•Experience in conversion of packages from legacy systems and migrating, deploying the packages across production environment.

•Generated various SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS 2005/2008.

•Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

•Expertise in Error Handling and Debugging issues and troubleshoot production environment issues Event Handler, and Custom Logging in SSIS Packages.

•Excellent understanding of Normalization /De-normalization and database design methodology.

•Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.

WORKING EXPERIENCE:

Motorola Mobility Inc. July 2014-Till Date

Chicago IL

Tableau Developer/BA

Motorola Mobility is an American telecommunications equipment corporation headquartered in Chicago, Illinois. It was formerly Motorola's cellular phone division, which was called the Personal Communication Sector (PCS) prior to 2004. It pioneered the flip phone with the StarTAC in the mid-1990s.This project dealt with building an application for the Procurement team for their analysis using tableau 8.1. This Project also dealt with gathering the requirements from the customer and documenting it for further reference.

•Responsible for interaction with business stake holders, gathering requirements and managing the delivery.

•Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

•Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

•Used Sheet filters to produce multiple chart types in a single view.

•Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.

•Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.

•Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

•Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

•Connected Tableau server to publish dashboard to a central location for portal integration.

•Connected Tableau server with Mobile analytical portal and setup auto refresh feature.

•Created visualization for logistics calculation and department spend analysis..

•Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: Tableau 8.2. SQL Server 2012, MS Excel, Windows 7

Blue Cross Blue Shield, April 2013 – Feb 2014

Detroit MI

Tableau Developer/Admin

The Blue Cross Blue Shield Association is a federation of 37 separate health insurance organizations and companies in the United States. Combined, they directly or indirectly provide health insurance to over 100 million Americans. Blue Cross and Blue Shield insurance companies are licensees, independent of the association (and traditionally of each other), and offering insurance plans within defined regions under one or both of the association's brands. The project dealt with Creating Dashboards for the HR department based on complete overview, new hire, terminations, changes, trends and employment compensation.

Responsibilities:

•Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

•Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

•Expert in infographics and Dashboarding for data visualization.

•Interact professionally with diverse group of professionals in the organization including managers and executives.

•Experience in standardizing Tableau for shared service deployment.

•Developed Standard Operating Procedures (SOP) for Monitoring.

•Extensively used data blending, embed functionalities in Tableau.

•Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

•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.

•Involved in license management SLA’s with Tableau support.

•Defined and created procedures to install Tableau desktop in silent mode.

•Defined best practices for Tableau report development.

•Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

•Provided 24/7 production support for Tableau users.

•Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

•Experience in converting OBIEE content into Tableau BI content.

•Experience in providing Tableau server and tableau desktop training.

•Experience with Teradata.

•Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.

•Experienced with trouble shoot of Teradata connection.

Environments: Tableau Server v6/v7, Tableau Desktop v6/v7, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Bank of America, Jan 2012-Feb 2013

Austin TX

Tableau Developer

The Bank of America Corporation is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. As of 2010, Bank of America is the fifth-largest company in the United States by total revenue, and the third-largest non-oil company in the U.S.

The Project dealt with creating dashboards for the Hedge funds liquidity. Interactive Dashboard was created based on the liquidity by payout days and exposure. The Performance of the Hedge Funds were also monitored over a period of time. Custom mapping and various bar charts were created based on exposure of GISC sector and allocation of GISC scheme to accomplish an interactive Asset allocation Dashboard.

Responsibilities:

•Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.

•Installation, maintenance and administration of Tableau Servers.

•Experience in Marks, Publisher and Security.

•Experience with creating Worksheets, Dash boarding and info graphics.

•Working with Multiple data Connections.

•Used Snow flake and Star Schema Designs for data modeling.

•Experience with troubleshooting.

•Experience in tableau created Rapid Analytics and Reporting.

•Experience with Tableau for Data Acquisition and data visualizations for client and customers.

•Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

•Involved in Custom Geocoding.

•Expertise in Tableau Analysis.

•Experience in BI interactive Dashboards and Tableau Publisher.

•Experience in developing Dashboard using OLAP cubes.

•Experience of Client-Interaction on onsite/Offshore.

•Involved in Test Evaluation, Summary Reports.

•Live, optimized connections to Teradata to leverage the investments.

•Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environments: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4

Max NewYork Life Insurance Dec2010-Jan2012

New York

MS SQL BI Developer

GLIC uses Transcend application for administering and servicing its Annuity line of products. The application is modular in design and comprises subsystems for policy administration, agent/agency management, financial systems, Document Control, Product, Activity Processors, etc.

The Project also dealt with reporting capabilities using dimension and data marts for Policy administration, Processing, Reports, Death Processing, Rider fee and Bonus calculation, Settlement Phase & Accumulation phase processing.

Responsibilities:

•Successfully installed and configured the MS SQL 2008.

•Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

•Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.

•Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data using SSAS.

•Implementing Facts and dimensions for providing views of large sets of data..

•Created drill down and sub reports from SSAS cubes that can be browsed on web.

•Developed report specifications, created and modified reports using SSRS 2008.

•Scheduled reports and exported in PDF, Word and Excel format.

•Created OLAP Cubes from the integrated data and generated reports on those cubes.

•Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.

•Design and develop SSRS reports for crystal reports.

•Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master, static etc.

•Worked on the dirty source data that resulted in errors.

•Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.

•Wrote Parameterized Queries for generating Tabular reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.

•Actively participated in meetings and checked for the development of the project.

•Documented the project work and process.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, Visual Studio 2008, Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS).

Capital One July 2009-Oct 2010

McLean, VA

MS SQL Server Developer

Capital One bank specializes in credit cards, home loans, auto loans, banking, and savings products. Project objective was to develop various kinds of reports for brokers and clients, to increase performance by writing different kinds of queries and to develop cubes or analysis.

Responsibilities:

•Actively involved in the design of the database schema.

•Designed tables, indexes and constraints to maintain data integrity and also ensured efficiency in data retrieval/manipulation.

•Designed a View based security model to restrict access to data by user.

•Worked on migration of SQL Server 2005 instances to SQL Server 2008.

•Installed all software upgrades for SQL Server 2008.

•Developed complex stored procedures to efficiently retrieve/manipulate data as per requirement.

•Used Ab initio to perform functions of four generation data analysis, data manipulation and GUI based.

•Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

•Used SSIS to implement the slowly changing transformation, to maintain historical data in data warehouse and migrated databases from development to production.

•Designed and developed dynamic SSIS packages to process queries and dynamically produce flat files at runtime. Used check points, break points and event handlers while running packages.

•Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.

•Created various DTS packages for data transfer and migration.

•Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

•Built complex multi-sectional reports with charts and drill-down capabilities.

•Scheduled cube processing from staging database tables using SQL Server Agent.

•Wrote MDX expressions to create name sets, calculate members and KPIs.

•Planned the complete back-up of various databases for disaster recovery scenarios.

•Working with Multiple data Connections.

Environment: MS SQL Server 2005/2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Report Services (SSRS). MS Excel, Windows 97/2000/XP, Toad.

Satyam Computers Services Ltd. Aug2007-June2009

Hyderabad, India

SQL Server Developer

Satyam is an IT outsourcing company that recruits candidates to work for their clients around the world. The five largest customers, on the basis of revenue, are General Electric Company and its affiliates, State Farm Mutual Automotive Insurance Company, Mega soft Inc., Caterpillar Inc. and NCR Corporation.

Responsibilities:

•Oversaw installations, upgrades of SQL 2005 to SQL 2008.

•Involved in Database design, creation and maintenance of Databases.

•Managing the use of disk space, memory & connections by monitoring.

•Created tables and views.

•Created functions, stored procedures, triggers and constraints using T-SQL.

•Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.

•Server & Application fine-tuning & trouble shooting.

•Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.

•Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.

•Recovered the backups of SQL Server production databases in test server environment.

•Refactored poorly performing SQL queries to improve application performance.

•Monitoring MS SQL Server performance and network issues.

•Coordinating with peer groups for Network, Infrastructure and Data center Operations.

•Performance monitoring and tuning of SQL servers.

•Used SSIS to load data from multiple SQL Server sources to a denormalized set of tables for analysis.

•Built SSRS report to support reporting needs.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML.

Contact this candidate