SUMMARY

• Analytical and resourceful professional offering 6+ years of experience in all aspects of data/business analysis, system analysis and design, development, testing, and implementation of BI/data warehousing projects using Tableau, and Micro Strategy across insurance, finance, banking, healthcare, and retail industries.
• Strong background in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check - In, Sprint Review & Retrospective
• Experience in modeling Star schema and Snow flask schema for data warehouse.
• Involved in Extracting, Transforming and Loading (ETL) data using Informatica along with ETL team.
• Extensively worked on Inman and Kimball approach.
• Experienced in conducting Joint Application Design (JAD) and Joint Requirement Planning (JRP) sessions.
• Experienced in Data mapping, Data transformation between sources to target data models.
• Excellent in building various logics to handle Slowly Changing Dimensions, Change Data Capture and Deletes for incremental Loads in to the Data warehouse and determining the Hierarchies in dimensions.
• Exported huge volumes of data from Teradata tables and views for processing and reporting, using Teradata Export Load utility.
• Strong Knowledge of SDLC methodology including analysis, design, development, testing and maintenance.
• Proficient in Normalizing and De normalizing techniques for optimum performance in relational and dimensional database environments.
• Experienced in generating and documenting Metadata, while designing OLTP, ODS and OLAP systems environment.
• Worked and extracted data from various database sources like Oracle, SQL Server, DB2, and Teradata.
• Loaded huge volumes of data into empty Teradata tables in the DataMart for the initial load, using Teradata Fast Load utility.
• Extensive knowledge in Data loading using PL/SQL Scripts and SQL Server Integration Services (SSIS).
• Involved in the critical Design review of the finalized database model.
• Extensively worked on SQL queries and PL/SQL stored procedures, triggers, functions and packages.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• Created UML diagrams from user requirements.
• Extensive experience in BI process using tools Congo’s, Crystal Reports, BO, OBI and SSRS.
• Conducted GAP analysis and User Acceptance Testing (UAT).

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, XML, HTML, UML

Databases: Oracle10g, Teradata2.x, Microsoft SQL.

DataModeling Tools: Erwin, ER Studio

ETL Tool: Informatica Power Center 7.1.1, 8.1.1.,DataStage

Reporting Tool: Tableau, Qlikview, Cognos 8, Crystal Reports XI, Business Objects XI, Oracle Reports, XML Publisher.

Operating System: Microsoft Windows Vista/XP/2000/NT, Sun Solaris, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential | San Antonio, Texas

Data Analyst

Responsibilities:

• Played a key role in establishing best practices for tableau reporting by conducting meetings with the clients and key stakeholders for gathering reporting requirements and to determine KPI's and developing POC Dashboards.
• Leverage strong expertise in analyzing and identifying business requirements, reviewing and communicating with business, and getting sign offs from business stakeholders. Employ Tableau best development practices in developing and formulating reports, dashboards, and SQL queries.
• Expertly designed and applied KPIs, Dashboards, and Operational Metrics using Performance Point Server and published them via Tableau to enable KPIs tracking in a real-time.
• Expertly created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
• Integrated Tableau server with SharePoint portal and setup auto refresh.
• Optimized reports performance by reducing analysis time from 1 hour to 4 minutes by converting excel spreadsheets into Tableau interactive dashboards.
• Produced Excel, Qlik View and Domo reports and managed the overall initiative of developing and documenting technical architecture, system design, performance test results, and other technical aspects of the implementation.
• Streamlined multiple performance issues and implemented best process distribution for different projects.
• Played a pivotal role in conducting Functional testing, Regression testing, Integration testing, Smoke testing, and UAT.
• Reduced analysis time from 2 hours to 4 minutes by converting excel spreadsheets into Qlikview interactive dashboards.

Confidential - Franklin TN

DataAnalyst/ETLDeveloper

Responsibilities:

• Have been a part of the Business Intelligence team and have been performing data analysis by translating business needs into business intelligence data sources and reporting solutions for different types of data consumers.
• Involved in Database Design, Data Integration, Modeling, Implementation, ETL (using Informatica & Alteryx) and Reporting in SQL Server and Oracle.
• Involved in Data Analysis on large datasets by designing and developing SQL Database objects such as Tables, stored procedures, Functions, Triggers & Views.
• Have extensively worked on Informatica Cloud integration, developing ETL jobs for supporting Data Extraction, transformations and loading heterogeneous source systems (SAS Applications like Salesforce.com, SAP BW, SAP Table Reader, Zuora and Oracle Eloqua) into target systems in ORACLE and SQL Server.
• Expertise in SAP BW, EDW, SAP Business Objects, SAP Table Reader systems and data integration from these sources using Informatica Cloud and Alteryx.
• Support ETL Applications planned maintenance, holding the scheduled jobs and releasing them as per schedule and support Data warehouse adhoc requests, reporting and troubleshooting on a daily basis.
• Keen understanding of SAP Functional areas like Accounts Payable, Accounts Receivable, General Ledger, Deferred Revenue and usage of corresponding transaction codes for report generation.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Involved in defect management by creating test cases and resolution using HP ALM Defect Management Tool.
• Used Alteryx & MS Excel widely in creating reports with Pivot tables, Graphs, Charts, Macros and dashboards.

Confidential

ETL Developer

Responsibilities:

• Developed and tested extraction, transformation, and load ETL Jobs in Informatica processes by utilizing transformations.
• Optimized workflow processes by using Workflow manager for session management, database connection management, and scheduling of jobs.
• Defined transformation process by working on Power Center client tools such as Source Analyzer, Target Designer, Mapping Designer, and Transformations Developer.
• Enabled re usability of business rules through user defined functions in the mapping.
• Utilized shortcuts to allow re usability of objects without creating multiple objects in the repository and inheriting changes made to the source automatically.
• Skillfully performed Unit Testing of developed mapping.
• Developed automation scripts in UNIX for testing purposes, consequentially reducing the duration of test cycles from 2 weeks to 1 week.
• Provided daily communications, scrum notes, sprint reviews reports, project retrospectives, and regular snapshots of project velocity and budget burn rate
• Advanced and optimized database queries and procedures in SQL improving application proficiency by 13%.
• Awarded as STAR Performer on basis of exceptional service delivery.

Confidential

SQL Developer

Responsibilities:

• Collaborated with business analysts to gather business requirements, as well as developed physical data models using Erwin and created DDL scripts to create database schema and database objects.
• Analyzed functional specifications and published user requirement documents based on analysis.
• Extensive experience in table creation, stored procedures, and performance tuning.
• Actively contributed in performing data conversions from flat files into a normalized database structure.
• Successfully developed source to target specifications for Data Transformation Services, and functions, views and triggers for automation process.
• Extensively utilized Joins and sub-Queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in production.