• Qualified professional has 8 years of extensive IT Experience in Data Warehousing and Business Intelligence applications in Retail, Financial, Health Care and Manufacturing industries.
• Proficient in Tableau 6.x/7.x/8.x Desktop, Server , OBIEE 11g, Micro Strategy 9.x/8.x Desktop, Intelligence Server, Narrowcast Server and SSRS.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Expertise in Teradata 13.10, Oracle, SQL Server, Informatica, SSIS, SSRS, SSAS, UNIX, Toad, Microsoft Office Suite.
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing UAT .
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post Production support.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

Confidential

Tableau Developer

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped..
• Worked on the backend SSAS cube development which was the source data for the tableau.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
• Extensively used calculated fields 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.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
• Participated in the retrospective meetings and next sprint planning meetings.
• Involved in Onsite Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau desktop 8.1/8.2, tableau server 8.1/8.2, OBIEE 11g, Microsoft SQl Server ,Google Big-Query, SSIS,SSAS, Salesforce, Talend.

Confidential

Tableau Developer

Responsibilities

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Used Autosys as Third Party Scheduling tool.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML references.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau 7.0/8.0, Teradata 13.10 , Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys , CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential

BI Analyst/ Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive SQL data models to get clear understanding of requirements.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Worked to ensure high levels of data consistency between systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement. and Involved deployment process.

Environment: MicroStrategy Desktop/ Server , Teradata 13.10, Oracle, SSIS, SSRS, Teradata SQL Assistant, Teradata Administrator, SQL Developer, Power Designer, MS Office Suite Word, Excel, PowerPoint .

Confidential

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 amp 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: MSSQL Server 2000/2005, MySQL, Lotus Notes, MS Access, MS Office Suite Word, PowerPoint, Excel , SSRS,SSIS