SUMMARY

• Having 7+ years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence.
• Extensive experience inTableau Desktop and Tableau Server in various versions of Tableau 7 and Tableau 8
• Involved in Requirements gathering/analysis,Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Experience inInstallation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• 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.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Extensive experience in database tuning, server logins and database permissions.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.

Data Visualization: Tableau, Qlikview, PowerPivot, Excel, SSRS,SSAS, Visual Analytics, Business Objects XI/4.0

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access.

Tools: and Packages SQL Server Management studio, Toad, Microsoft Visual StudioLanguages SQL, PL/SQL, C, C#, ASP.Net, HTML, XML

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Senior Tableau Report Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Creating calculatedfields,groups, sets and hierarchies etc.
• Creating data blending in case of merging two different datasets.
• Understanding of relational database structures, theories, principals, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content dat is being communicated
• Develop, organize, manage and maintain graph, table, slide and document templates dat will allow for efficient creation of reports.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Working noledge on Tableau Server / Administration.

Environment: Tableau Desktop 6.02, 7.0,8.0 Tableauserver / Administrator, tabcmd, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Java, Microsoft office 2007.

Confidential, Bentonville, Arkansas

Business Intelligence and Reporting Developer - Tableau

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Program
• 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.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• 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.
• Worked on several complex visualizations dat all had to do with improving the programs offered to various schools in NYC.
• Developed business process and technical design documentation for each reporting service developed in dis project.
• Designed and developed reports such asDrill down, Drill Through usingMicrosoft Reporting Services.
• 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, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 7, Tableau Desktop 7, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Visual Studio 2010.

Confidential, McLean, VA

MS SQL Server/SSIS/SSRS/SSAS Developer

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 dat 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 dat 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).

Confidential, NYC, NY

MS SQL BI Developer

Responsibilities:

• Created SQL Server Reports using SSRS.
• Identified the Data Sources and defined them to build the Data Source Views.
• Developed Query for generating drill down/drill through reports in SSRS.
• Used SSAS data mining wizard to do the market timing.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance
• Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Developed, monitored and deployed SSIS packages.
• Used most of the controls and features in SSIS for transforming data from different sources.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and defined Key Performance Indicators (KPIs) in SSAS.
• Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cubes as backend and provided integration between MS Excel/SSRS and SSAS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created various types of reports like Dashboard, Variance, Forecast and client active reports.
• Enhanced reports by using a series of features like Highlighting report values using conditional styles, applying a report template, format report objects, focus the scope of a report using filters for accuracy of the equity rewards and Incentive grants.
• Created Scorecards, Calculated, Analytical reports for sales and Metrics using Metric studio.
• Implemented different types of constraints on the tables.
• Designed and applied entity and attributes description and definition for the models.

Environment: MS SQL Server 2000/2005/2008 , T-SQL, SSAS, SSRS, SSIS, MS Access.

Confidential

MS SQL DEVELOPER

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2005, MS Access Databases (using DTS, Stored Procedures and Views.
• Involved in developing the SQL code for the application.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Identified and worked with parameters for parameterized reports in SSRS.
• Created ad hoc T-SQL Queries.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed the Reports, Tables and ETL process.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.

Environment: T-SQL, MS SQL Server 2005, SSAS, SSRS, SSIS, XML, Windows 2000/2003/NT/XP, MS-Excel.