SUMMARY

• Over 7+ years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applicationsin Retail, Financial, Health Care, Pharmacy and Manufacturing industries and the related Database Platforms.
• Extensive experience inTableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.1.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizationslikebar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Excellent analytical, problem solving and Tableau and SQL debugging skills.
• Experience in writing detailed business requirement and translating them into technical specifications and design.
• Organized Joint Requirement Planning sessions,Interviews and Requirement Elicitation sessions with end-users,clients, Subject Matter Experts and the technology group.
• In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Experience in designing 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.
• Good Communication and interpersonal skills.
• Versatile team player with excellent analytical and presentation skills.
• Strong logical, problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

ETL Tools: SSIS, informatica, Data Stage

Database: MS Access, Oracle 9i, MS SQL Server 2005 etc.

BI Tools: Tableau, Microstrategy, SSRS, Business Objects.

Data Modeling: Erwin, Visio 2003

Scripting Languages: SQL, T-SQL

OLAP Tools: SSAS

Programming Languages: HTML,SQL,PL/SQL,XML

Dimensional Modeling: Kimball &Inmon

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• 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.
• 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.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.

Environment: BI Applications, Tableau 8.1 Windows 8, SQL Server, and Excel. Oracle 11i, Sybase, C, Excel, JAVA, J2EE, Tomcat.

Confidential, Virginia Beach, VA

Tableau Developer

Responsibilities:

• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Design, development and deployment of tableau reports.
• Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.
• Installation and configuration of Tableau server in dev. and production environment.
• Authenticating the tableau dashboards before publishing to tableau server.
• Publishing the developed reports to production Tableau server environment.
• Security implementation to tableau server reports based on user community.
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Supported code/design analysis, strategy development and project planning.
• Created reports for the BI team using Sqoop to export data into HDFS and Hive.
• Performed the back up and restoration activity, server performance monitoring of Tableau server for environmental changes, change management, or for any software upgrades or patches.
• Tableau server API integration with MRCS 4.0 portal integration for trusted authentication.

Environment: BI solutions, BI environment, BI Applications, Tableau 8x BI toolkit\Product stack (Desktop\Server (Suite), Windows 8,Hadoop, SQL Server, and Excel.

Confidential, Austin TX

Tableau Developer

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, Dashboarding and infographics.
• Working with Multiple data Connections.
• Used Snow flake and Star Schema Designs for data modelling.
• Experience with troubleshooting.
• Experience in tableau created Rapid Analytics and Reporting.
• Experience withTableau 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 TableauPublisher.
• 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.

Environment: s: 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.

Confidential, Austin, TX

BI Developer/ Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Defined functional business requirements, analyzed client requirements, and generated workflow processes
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
• Designed, developed, and tested the jobs, using Data Stage
• Involved in the some part of performance tuning.
• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using MicroStrategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

SQL Server Developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server 2000/2005, MySQL, Lotus Notes, MS Access,MS Office Suite ( Word, PowerPoint, Excel).

Confidential

DWH Developer

Responsibilities:

• Team member of the BI module and involved in analysis of business requirements template, decomposition matrix, dimensionality modelling and ETL strategy.
• Understanding the Erwin ER diagrams.
• Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Worked on Microsoft SQL Server 2005 Tools-SQL Server Integration services (SSIS), SQL Server analysis services (SSAS) and SQL Server reporting services (SSRS).
• Responsible for extracting the data from different source feeds like Flat file, XML, OLE DB, and Excel.
• Created packages by using sources, destinations and transformations using SSIS designer.
• Connected to different types of sources to extract data and destinations to load the data using Connection manager.
• Defined the data Sources, data Source views, dimensions, cubes within the Business Intelligence Development Studio (BIDS) Using SSAS.
• Administration and development of data warehouse\data marts and OLAP cubes
• Used Business Intelligence Development Studio, Management Studio for developing SSIS, SSAS, and SSRS.
• Involved in the creation of SSRS reports using with\without wizards.
• Performed parameterized reports, reports bursting, and scorecards.
• Involved in performing drill down the data, calculations, sort the data, add groups, subtotals, and colour code the business data exceptions.
• Troubleshooting ETL, OLAP analysis and reporting process failures.

Environment: MS SQL Server 2005(SSIS/SSAS/SSRS), Windows