SUMMARY:

• 8 years of experience in Analysis, Design and Development of various Data Warehousing projects using Tableau, Spotfire and SAP Business Objects .
• Good Experience with Hadoop and SAS.
• Strong understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
• Strong SDLC knowledge including entire life cycle of analysis, design, build, test and deployment.
• Strong business knowledge in Banking and Finance, Utilities and Pharma.
• Expert in documenting business requirements, functional, technical specifications and test cases.
• Capable of understanding the business environment and translate business requirements into technical solutions.
• Capable of working as a Team Member or individually with minimum supervision. Flexible to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Good Communication and Interpersonal skills with the ability to interact with end - users, managers and technical personnel.
• Experience in creating complex Tableau reports line charts, bar charts, pie charts, Combination charts, tree maps and Map charts.
• Good Experience with Level of detail expressions, filters, date functions, window functions and Table calculations, sets, groups etc.
• Strong experience in writing SQL and PL/SQL programs, stored procedures for the custom functions in Spotfire.
• Created complex statistical and financial reports, trend over time reports, ranking and forecast reports, Executive Dashboards using TIBCO Spotfire.
• Good Experience in customizing the Spotfire Dashboards using HTML, Python and Java scripting.
• Expert in designing Spotfire dashboards/reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Experience with Hadoop Echo system tools and databases HDFS, Sqoop and HIVE.
• Experience in creating Complex Tableau Visualizations and Spotfire Dashboards.
• Good Experience in Data analysis, data extraction using SQL.
• Experience in building data marts and Data warehousing.
• Experience with SAP HANA and HANA Studio.
• Experience with Microsoft reporting tools SSRS.
• Experience with PL/SQL procedures, Stored Procedures in Netezza, Functions and Triggers.
• Strong Experience with tableau server, security access, publishing the dashboards and access control.
• Expert in Writing SQL Queries on Oracle, Netezza, Microsoft SQL Server, Teradata, MS Access and DB2.
• Created various Reports using Tableau and involved in Performance tuning.
• Knowledge in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Extensively worked on Relational Databases like Oracle 11g/10g, Confidential Netezza, Teradata, MS SQL Server, Sybase, Access, DB2 and database access tool TOAD, Rapid SQL and Agility.
• Experience on ETL tools like Informatica Power center, workflow manager and workflow Monitor.
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau 6.0,8.1,9.1,10.3Tibco Spotfire Professional 3.2,3.3,4.0,5.5,6.5, Spotfire Web player, Business Objects X2, X3

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache).

Operating Systems: Windows 7/VISTA/NT/ XP/ ME/ 2000/, UNIX.

Databases: Confidential Netezza, SQLServer, Sybase, Oracle11g/10g, Teradata, SAP HANA, Hbase, Hive, MS Access and DB2.

Programming Languages: SAS, C, C++, SQL, PL/SQL, COBOL, XML.

Operating Systems: Windows 7/VISTA/NT/ XP/ ME/ 2000/, UNIX.

Databases: IBMNetezza, SQLServer, Sybase, Oracle11g/10g, Teradata, SAP HANA, Hbase, Hive, MS Access and DB2.

Programming Languages: SAS, C, C++, SQL, PL/SQL, COBOL, XML.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data and Reporting Consultant

Responsibilities:

• Gathered Business requirements and perform data analysis and reporting.
• Experience in creating Tableau Dashboards for Management as well as for Operations.
• Good Experience with creating line charts, Bar charts, Map charts, cross tables, Pie charts etc using Tableau.
• Experience with various agg functions, quick filters, context filters, sets, grouping, calculated fields and table calculations using Tableau.
• Experience in publishing the reports on to the tableau server and provide access depending on the type of users.
• Extract the data from RDBMS databases like Oracle, Netezza, MS SQL server using SQL and SAS.
• Good Experience with SAS Procedures, pass-through sql, proc report, drop, keep and various date functions.
• Experience with Tableau data extracts and packages work books.
• Experience with data blending, sets, context filters, parameters etc.
• Good Experience with Tableau server and access controls.
• Responsible for creating stored procedures in Netezza.
• Experience with Hadoop and Tableau integration and build reports on the data stored in Hive tables.
• Good Experience with Hadoop environment tools SQOOP, HIVE, HDFS and Pig for data storing and data transfer.
• Experience with Java and python scripting.
• Used HTML to custom visualizations in Spotfire.

Environment: SAS9.2, SAS EG, Tableau10.3, Netezza, Oracle, Toad, Aginity, Hadoop

Confidential, Cincinnati, Ohio

Senior BI Analyst

Responsibilities:

• Designed and developed Sales dashboards with different visualizations for marketing team like Bar Charts, Combination charts, Cross Table and line charts.
• Created information links, data elements using information designer and used custom SQL in complex information links.
• Experience with various functions, quick filters, context filters, sets, Grouping, calculated fields and table calculations using Tableau.
• Experience with Data blending and Data joining.
• Expert in creating KPI Dashboards to track the actual and expected models.
• Used property control, Action control within the score cards and scheduled through automation services for embedding the data.
• Dashboards are accessing data from various sources Excel file son share point, CSV on share drives and SAS data sets from SAS data source.
• Applied calculated columns and custom expressions within report to get informative data per business requirements.
• Extensively used Library Administrator to create folders for all developers and assign proper security within spot fire.
• Created performance score cards using combination charts, summery table and parallel coordinate plot.
• Created hyper link reports to make drill down reports for end users.
• Part of Spot fire version upgrade from 3.2.1 to 4.0.2, evaluated and resolved all impacted report issues
• Provided 24/7 support as part of on call support for production.

Environment: Spotfire professionals 3.2 and 4.0,Tableau 8.1, Spot fire web player, Spot fire enterprise player, Oracle10g, SQL Server 2008, TOAD, SQL, windows server.

Confidential, Kansas City, MO

Senior Data Analyst

Responsibilities:

• Gathered Business requirements and perform data analysis and reporting.
• Responsible for consolidating the reports and re writing the SAS programs.
• Extract the data from SAP HANA views, Teradata and various RDBMS data bases.
• Expert in writing the SQL quires against Oracle, SAP HANA, Teradata and DB2.
• Identified data anomalies and reported the issues for the business to correct.
• Created Hive tables, Partitioning and performance tuning.
• Utilized Teradata utilities Fast Load, Fast Export and Multi load for loading and Exporting data to Teradata tables.
• Extracted data from various data sources using Pass through SQL, created macros, exported and imported data into SAS, created PROC sort, email automation etc.
• Experience with various formats and date maupulations and sas functions.
• Build and enhanced Tableau dashboards and created and scheduled the data sources.
• Experience in SQL performance tuning.

Environment: SAS, SAS EG, Tableau 6.0, SAP HANA, Hadoop Hive, HDFS, SQOOP, Teradata, Teradata SQL assistant, SAP HANA Studio, DB2, Vertica, Control-M.

Confidential, Thousand Oaks, California

Business Objects Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Involved in developing new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created users, user’s groups and maintained user access rights by using CMC.
• Created reports containing all the information regarding the publishers, distributors and retailers using crystal reports XIR3.
• Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.

Environment: Business Objects XIR3, Web Intelligence XIR3, Xcelsius 2008, Crystal Reports XI, 2008, Oracle 9i (PL/SQL), Windows Server 2003.