SUMMARY:

• 8 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications across various domains including Pharmaceutical, Insurance, Manufacturing, Retail and HealthCare.
• Certified Tableau Desktop 9 Qualified Associate with extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x, 8.x, 7.x and other BI technologies like Business Objects, OBIEE, Teradata etc.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Experience in conducting Joint Application Development (JAD) sessions with Business and IT Groups.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience in creating different visualizations using Bars, Lines and Pies, Donuts, Pareto, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Motion Chart, and Highlight tables .
• Mastered ability to Preparing dashboards using calculated fields, parameters, calculations, groups, sets, hierarchies, advanced functions like Level of Detail (LOD) Expressions, and Localization in Tableau.
• Experience in Administering user, user groups, and scheduled instances for reports in Tableau.
• Extensive experience in conducting Requirement Analysis, Use Case Design, Designing Test Plans and designing database schemas based on the logical models.
• Good Experience with designing and verifying databases on Teradata, Oracle and SQL Server RDBMS using Entity - Relationship Diagrams (ERD).
• Experience in building OBIEE Repository (.rpd file) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer).
• In depth understanding of the As-Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Expertise in analysis, design and implementation of data warehousing applications using Tableau, Teradata, Google Analytics, Informatica, Unix, DB2, Oracle, OBIEE technologies.
• Proficient in designing Entity-Relationship diagrams, Star/Snow Flake Schema using Kimball and Inmon methodologies.
• 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.
• Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports generated from various ETL sources.
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Analytical Tools: Tableau (Desktop/ Sever/ Reader), Alteryx, OBIEE, Business Objects, Crystal Reports, Cognos, Google Analytics (Adobe Site Catalyst).

ETL Tools: DataStage, Informatica, SSIS

Databases: Teradata, Oracle, DB2 UDB, MS-SQL Server, Netezza, Sybase

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: Documentum, Visual Source Safe, Share point, Ultra Edit

Defect Management tool : HP Quality Center

Methodologies: Kimball/Inmon, Agile, Iterative

Data Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Languages: SQL, PL/SQL, javascript, HTML, Perl, XML.

Operating System: Windows, UNIX (HP-UX, Solaris, AIX), AS/400

Scheduling Tools: Control M, AutoSys, ESP Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan IL

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Worked with users and coordinated with Business Objects developers to understand and capture data/reporting requirements.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Worked with Tableau Administrator in installing and upgrading of Tableau server and server performance tuning for optimization.
• Worked with power users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Teradata, Oracle, SQL Server).
• Effectively used data blending, filters and hierarchies.
• Built reports against Single Table, Multiple Tables and also built formulas in Tableau for various business calculations.
• Preparing Dashboards using calculations, parameters in Tableau.
• Built complex calculations using advance functions such as ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, LOOKUPs and Quick Table calculations.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Creation of packaged workbooks (.twbx) for end-users.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Worked with offshore teams to accomplish timely release objectives.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.

Environment : Tableau (Desktop/Server) 9.x/8.x, Alteryx, Business Objects, Teradata, SQL Server, Oracle, Toad, SQL developer, PL /SQL, Windows Server, java 1.5 platform, SharePoint.

Confidential, Boston, MA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in end-to-end implementation and enhancements on Confidential mobile app data starting from requirement gathering and dashboards development in Tableau Desktop.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile App's by importing and blending data from Adobe Marketing cloud (.TDE files), MS Excel and CSV files along with Teradata Database.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server, which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Incorporated Tableau workbooks into SharePoint though API’s and Web parts.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop/Server) 8.x, Teradata, Adobe Marketing Cloud, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project, HP Open View, Java API, MS Visio.

Confidential, Plano, TX

Data Analyst/Tableau Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Extracted the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau. 
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. 
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Used Groups, hierarchies, sets, localization to create detail level summary report and Dashboard to cater users from different countries.
• Worked with tableau administrator in Creating users, groups, projects, Data connections, settings.
• Defined best practices for Tableau report development. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards. 
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems 
• Coordinated database middleware issues with DBA's, system performance with System Architects. 
• Maintained server activities, user activity, and customized views on Server Analysis.
• Implemented data security by creating user filters.
• Provided 24/7 production support for  Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop. 
• Created SQL Queries for testing the tableau Dashboards.

Environment: Tableau (Desktop/ Server), Oracle SQL Developer, SQL Assistant, HPQC, Oracle 11g, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, SFO, CA

Data Analyst/ BI Analyst

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Participate in the Business and Specifications requirements gathering sessions and convert it into Design specifications. The Design specifications ranges from High level Design to Application level designs and (Cross) Application Interface agreements specifications.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• 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
• Developed business, functional and/or technical requirement specifications adhering to standard requirement templates.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Actively involved in the design, development and testing phase and conducted detailed Data Modeling for the database to be developed.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Designed and created sessions and workflows for the source to staging data flow and staging to Target loading.
• Implemented Type II changes for different Dimensions.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Created ragged hierarchies for the organizational structure to enable the drill down feature.
• Performed unit testing and system testing of all components of OBIEE Finance Analytics using EBS source.
• Designed and developed various weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Present and propose solutions, and alternatives, to requirements with an eye to scalability, flexibility, ease of maintenance and time to delivery, which often requires a phased approach and understanding of release schedules.

Environment: Requisite Pro, OBIEE 11g, MS SQL Server, SSIS, Oracle 10g/11g, HP-UX, Unix, AutoSys, MS office Suite ( Word, Excel, Power Point, Visio).

Confidential, Columbia, MD

Business Systems Analyst/ Data Analyst

Responsibilities

• Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements.
• Assisted project manager in defining the Scope, Schedule, Business Change Management, Develop Feasibility Study Report for Preliminary Study of the Project, and Budget of the Project
• Participated in JAD/RAD sessions (Work Sessions) with the stakeholders and the technical units for business requirement gathering followed by (Agile Scrum) approach
• Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document.
• Involved in designing databases with extensive use of ERDs, DFDs for Data Modeling, Data Conversion, Data Migration, Data Validation, and reference Data Analysis.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements.
• Applied SQL for cross checking Data Validation for Referential Data in SQL Server.
• Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users
• Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements' values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values
• Customized Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Created presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Created Users and Groups and managing the object level and data level security.
• Managed the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table, Column Selector, Compound layout.
• Involved in fine tuning the reports by working extensively on the Caching Strategy.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Developed and created Stored procedures using PL/SQL for queries
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.
• Prepared code migration document and worked with release team in migrating the code (Informatica Objects, SQL Scripts, UNIX Scripts & DAC jobs) from Development to Test, Stage, Production Servers

Environment: OBIEE 10.1.3.3.1 ,Informatica 8.1.1, Oracle 10g, SQL Server, PL/SQL Developer, Oracle SQL, Windows XP, Solaris, Shell Scripts, ER Studio.

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model and Mapping Layer and Presentation Layer in a Siebel Analytics Repository.
• Configured analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions).
• Configured and created repository using Siebel Analytic Admin Tool.
• Developed different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Created connection pools to retrieve data from Siebel LDAP layer, real time Siebel OLTP data and data from Oracle Database.
• Managed day-to-day repository (rpd), scheduler, and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Involved in setting up Delivers to configure iBots based on the threshold value to the users.
• Developed UNIX and PL/SQL scripts for pre & post session processes to automate daily loads.
• Created iBots and Delivers to send Alert messages to subscribed users.

Environment: Siebel Analytics 7.7.1, Informatica Power Center 6.1, Oracle 8i, TOAD, UNIX