SUMMARY

• Overall 9 + years of IT experience in Business Analysis, Data analysis, software development, testing and maintenance of BI/Data Warehousing environment.
• Designed the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non - relational or source relational to target relational.
• Expertise in designing and creating Analytical Reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Well versed in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Advanced charts like Waterfall, Bubble, Gantt, Pareto, Histograms etc.
• Create Data Extracts connecting to Teradata database, writing Free hand SQL queries using SQL assistant.
• Excellent understanding of Data modeling (Dimensional & Relational) concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications.
• Involved in Performance Tuning by analyzing and comparing the turnaround times between SQL and Tableau.
• Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive knowledge of all phases of the Software development life cycle (SDLC), in waterfall and Agile (Scrum) methodology
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Involved in business presentations, reviewing and organizing data, with the help of Tableau desktop.
• Good in conveying information through e-mails, discussions, meetings, etc and make sure that everyone stays on same page avoiding ambiguities.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop, Tableau Server, Qlikview

ETL Tools: SSIS, Alteryx

MS Tools: MS Excel, Word, PowerPoint

Databases: Teradata, Oracle, SQL Server, MS Access

Defect management tool: HP Quality center

SQL Languages: T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton FL

Lead Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data from data sources like Excel/SQL Server/Teradata for design, analysis, development, and production rollover of reporting withinTableauDesktop.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Work closely with E-mail Campaigning and Marketing team to understand their needs and creating visualization on Tableau.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata views) using data blending.
• Developed complex T-SQL queries such as Joins, Stored Procedures etc to get the relevant data to Tableau Environment.
• Create calculations including string manipulation, advanced arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Extensively worked on advanced chart types Like Box Plots, Pareto charts, Waterfall charts, Word Cloud, Funnel charts, Bump Charts and Control Charts, etc.
• Created Parameters, customized Calculations, Conditions and Filters for various analytical reports and dashboards.
• Used statistical techniques to describe data using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
• Utilized Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Utilized advance features of Tableau for linking data from different connections together on one dashboard and to filter data in multiple views at once.
• Create and modify Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Combine visualizations into interactive dashboards and publish them to the web.
• Creating New Schedules and checking the tasks daily on the server,maintaining server activities, user activity, check security configuration and customized views on Tableau Server.
• Prepared presentations for strategy meetings that address issues involved with top line and bottom line and provide insights as and when required.

Environment: Windows Server 2012,TableauDesktop 9.0/8.3,TableauServer, Teradata, SQL Server 2008/2012, MS-Access, MS Excel and JavaScript.

Confidential

Data Analyst

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Developed SSIS packages to extract data from multiple sources and load them into SQL server.
• Involved in creating views to improve the performance of Tableau Dashboards.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Blended data using multiple data sources (flat files and relational tables).
• Designed and Developed Complex reports and Dashboards with different data visualizations using Tableau desktop on customer data.
• Published Workbooks and Dashboards to theTableauserver.
• Develop, derive and clarify functional specifications and Use cases.
• Extensive knowledge in creating different visualizations with Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Created best visualizations reports as per the business requirements using Tableau desktop.
• Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Build rapid prototypes and visualizations of proposed solution to expedite end user input and increase chances of solution adoption and acceptance.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Used SQL Server Integration Services (SSIS) to integrate data from different sources like flat files (Excel, CSV, Text etc.), Oracle 11g to the target SQL Server 2008R2.
• Developed, deployed and monitored SSIS and created log files for SSIS packages.
• Used various transformations like conditional split, merge, look up, sort, fuzzy lookup, derived columns and data conversion etc for cleansing data .
• Used execution plan, SQL profiler to optimize queries and enhance the performance of databases.
• Ability to correspond with clients, responding to their questions and concerns with detailed information, while adhering to company’ Confidential policies and procedures.
• Can adapt to a changing environment and circumstances and Identity potential show stoppers and escalate to the senior management.
• Good in conveying information through e-mails, discussions, meetings, etc and make sure that everyone stays on same page avoiding ambiguities.

Environment: TableauDesktop 8.2/8.0/7.0, Tableauserver, SQLdeveloper, SQL 2008 R2, Oracle 11i, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform

Confidential

Business Analyst

Responsibilities:

• Involved in developing Bankruptcy transaction prototype based on in-house research, technology and client development teams' feedback.
• Interacted with user groups to derive the functional requirements.
• Involved in documentation during various phases of development life cycle.
• Create Use Case diagram and Activity diagrams through MS-Visio and Smart Draw thus defining the data process.
• Designed cohesive platform interface for Bankruptcy and Buyback databases, with inputs from Technology and Design Teams.
• Actively led the testing of the new and enhanced features and designs for back-end and platform.
• Performed manual/functional testing by executing test cases prior to automation.
• Handled post launch testing after each launch to ensure that no new bugs affecting other transaction or non-transaction datasets.
• Prepared process and training manuals on different aspects of transaction datasets under supervision.
• Good MS-Excel, VBA and SQL database skills, with proven ability to multi-task, prioritize, and with strong attention to detail.
• Adept at preparing business presentations, reviewing and organizing financial data, and developing qualitative and quantitative analysis.
• Impart training session for new recruiters, educating them with work process, research skills & issues and implement them in day to day functional process as applicable.
• Work in close coordination with various functional and technical teams for related issues and solutions.
• Documentation handling, functional testing and working on change requests related to products like Celsus and Deal Track.

Environment: Agile-Scrum, Oracle, SQL Server 2005, MS Access, MS EXCEL, MS Visio, MS Office Suite.