SUMMARY:

• 5 years of experience as Data Analyst/Tableau Developer.
• Proficient in Data Analysis, Cleansing, Transformation, Data Migration, Data Integration, Data Import, and Data Export through use of ETL tools such as Informatica.
• Expertise in Business Intelligence, Data warehousing technologies, ETL and Big Data technologies.
• Experience in Creating ETL mappings using Informatica to move Data from multiple sources like Flat files, Oracle into a common target area such as Data Warehouse.
• Experience in writing PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Skilled in Tableau Desktop versions 9.x/8.x for data visualization, Reporting and Analysis.
• Developed reports, dashboards using Tableau for quick reviews to be presented to Business and IT users.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Expertise in writing complex SQL queries, m ade use of Indexing, Aggregation and materialized views to optimize query performance.
• Performed predictive Modeling, Pattern Discovery Market Basket Analysis, Segmentation Analysis, Regression Models, and Clustering
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks
• Experience in utilizing SAS Procedures, Macros, and other SAS application for data extraction using Oracle and Teradata
• Expertise in using Qlikview
• Cloudera certified developer for Apache Hadoop. Good knowledge of Cassandra, Hive, Pig, HDFS and Map Reduce.
• SAS Business Intelligence Certified from Confidential college of Business.

TECHNICAL SKILLS:

Programming Languages: C, C++, SQL, MySQL, PL/SQL, Core Java, SAS, Matlab

ETL Tools: Informatica Power Center 9.1/8.6 (Designer, Workflow Manager/ Monitor, Repository), Abinitio

Web Programming: HTML CSS, JavaScript

Testing Tools: HP QC, HP QTP, HP Load Runner, HP ALM, IBM Clear Quest, IBM RQM, Jira, MTM, SDLC

Database: Tools: Oracle SQL Developer, Toad, Oracle 10g/11g, Microsoft SQL Server 2005/2008, SSIS, SSRS

Big Data Technologies: Cassandra, Pig, Hive, HDFS, Map Reduce

BI: and Analytics Tools: OBIEE, Oracle Reports Builder, Tableau, Cognos, Excel, SAS, SAS Enterprise Miner, Qlikview

Operating: System/Framework: Windows, Macintosh, UNIX, Hadoop

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables

WORK EXPERIENCE:

Technology Data Analyst/Tableau Developer

Confidential, Atlanta, GA

Responsibilities:

• Gathering data and business requirements from end users and management. Designed and built data solutions to migrate existing source data in Data Warehouse to Atlas Data Lake (Big Data)
• Performed all the Technical Data quality (TDQ) validations which include Header/Footer validation, Record count, Data Lineage, Data Profiling, Check sum, Empty file, Duplicates, Delimiter, Threshold, CDC validations for all Data sources.
• Analyzed huge volumes of data. Devised simple and complex HIVE, SQL scripts to validate Dataflow in various applications. Performed cognos report validation. Made use of MHUB for validating Data Profiling & Data Lineage.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Analyzed the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web
• Scheduled the published dashboards from Tableau Server on weekly & monthly basis . Mentored business power users to create reports/dashboards using Tableau desktop
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports .
• Worked with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks

Senior Data Analyst/Tableau Developer

Confidential, Tampa-FL

Responsibilities:

• Gathered data and business requirements from end users and management. Designed and built data solutions to satisfy application requirements.
• Developed reports, dashboards using Tableau 8.3 for quick reviews to be presented to Business and IT users.
• Created Scatter Plots , Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps , Pareto charts according to deliverable specifications.
• Implanted the analyzed data into Tableau and show the regression, Trend and forecast in the dashboard for the classified industries which was considered.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Analyzed huge volumes of data. Experience with various ETL, data warehousing tools and concepts. Created data warehouse design.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Created source to target data mappings, business rules, and business and data definitions.
• Developed dimensions and fact tables for data marts like Monthly Summary, Inventory data marts with various Dimensions like Time, Services, Customers and policies.
• Used Informatica & SAS to extract, transform & load source data from transaction systems, generated reports, insights, and key conclusions.

Data Analyst

Confidential, Tampa-FL

Responsibilities:

• Involved in meetings with SME's, Data Architect and Data modelers in getting the Business Requirements.
• Extensively used both Star Schema and Snow flake schema methodologies in building and designing the logical data model in Dimensional Models.
• Designed and Developed data mapping procedures ETL- Data Extraction, Data Analysis and Loading process for integrating data using Informatica.
• Defined the relationship between primary and foreign keys in tables
• Performed statistical analysis using SQL, SAS and Excel
• Closely interacted with developers to understand application functionality and navigational flow and keep them updated about Business strategies.
• Designed and implemented basic PL/SQL queries for testing and report/data validation
• Import, clean, filter and analyze data using tools such as SQL, HIVE and PIG.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Participated in code reviews with team members and third party vendors . Lead and mentored junior level QA team .
• Effectively Communicated plans, project status, project risks and project metrics to the project team. Planned test strategies in accordance with project scope.

Senior Data Analyst, Tableau Developer

Confidential

Responsibilities:

• Devised simple and complex SQL scripts to check and validate Data flow in various applications.
• Performed Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through use of ETL tools such as Informatica.
• Devised PL/SQL statements - Stored Procedures, Functions, Triggers, Views and packages. Made use of Indexing, Aggregation and Materialized views to optimize query performance.
• Developed logistic regression models to predict subscription response rate based on customers’ variables like past transactions, response to prior mailings, promotions, demographics, interests and hobbies, etc
• Created Tableau dashboards/reports for data visualization, Reporting and Analysis and presented it to Business.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.

Confidential

• Analyzed business and system requirements, data mapping requirement specifications, and responsible for Documenting requirements.
• Managed Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Created mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregation, Joiner, Update Strategy and re-usable transformations.
• Created a predictive model to help price management to set up the appropriate product price
• Predicted price elasticity relationship between price and case volume using SAS regression
• Supported revenue management using statistical and quantitative analysis, developed several statistical approaches and optimization models
• Worked to increase the client base of the company through market analysis, PCA and logistic regression of existing customer data using SAS Enterprise Miner, which was immensely helpful for the company's sales and marketing campaigns

Associate Data Analyst Intern

Confidential

Responsibilities:

• Devised simple SQL scripts to check and validate Data flow in various applications.
• Preparation of data dictionary / business glossaries and also integrating Data dictionary into data models.
• Involved in Extraction, Transformation and Loading (ETL) Process .
• Understood Data Warehousing methodologies and concepts.
• Performed internal Cost Analysis of various stocks and equities of assigned client repository
• Analyzed data using advanced Excel functions such as Pivot Table, Charts, Graphs and Macros
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures
• Added value by providing innovative solutions, and delivering improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution