SUMMARY

• Over 5 years of experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services.
• Expert in writing SQL queries and optimizing the queries in Oracle, MS SQL Server, and Teradata.
• Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting. Processed data in Alteryx to create TDE for tableau reporting.
• Design complex Dashboards like Executive, KPI and Strategic by using Tableau.
• Performed Data Profiling, Data Cleansing, Data Quality by importing Data from multiple sources using Alteryx.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Experienced in building data integration and workflow solutions, and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Services.
• Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
• Linked data lineage to data quality and business glossary work within the overall data governance program.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Extensively worked on creating Data Visualization Dashboards and reports using Tableau, Powerand MicroStrategy.
• Utilized Alteryx analytics software to process sophisticated cost models and SQL data conversions.
• Involved in facets system implementation, electronic claims and benefits configuration set - up testing, inbound/outbound interfaces and Extensions, Load and Extraction programs involving HIPPA and proprietary format files and reports development.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logicalentities.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Excellent knowledge of Software Development Life Cycle (SDLC), Adhered to standards/guidelines throughout the development life cycle and maintenance of the models.
• Ability to interact and coordinate with internal stakeholders in the projects, IT groups, business analyst groups, user acceptance groups, operations groups, third party vendors, change management groups and production support groups.
• Expert in creating and using Stored Procedures, Views and User Defined Functions.
• Hands on experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Proficient in extracting, transforming, and loading data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by Informatics/SSIS.
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical data modeling and data warehousing.
• Recreated existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment.

TECHNICAL SKILLS

Operating System: Windows NT/XP/2003/2007/Vista, Windows Server 2008R2/2012, UNIX

Language: T-SQL. PL/SQL, HTML

Data Warehouse Tools: Business Intelligence Development Studio, TOAD

Database: MS Access, MS SQL Server2008/2012, Oracle10g/11g and Teradata.

Tools: Utility Enterprise Manager, SQL Server Management Studio (SSMS), SSIS Informatica, BizTalk Services, SharePoint

Reporting Tools: Excel, SQL Server Reporting Services 2012 (SSRS), Tableau and Alteryx.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr Data Analyst

Responsibilities:

• Worked extensively Data Profiling, Data Cleansing, Data Quality by importing Data from both Relational and NO Relational databases using Alteryx.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
• Utilized Alteryx analytics software to process sophisticated cost models and SQL data conversions.
• Actively involved in understanding the business requirements, collecting data, performing data analysis and data migration as per the business needs to maintain data warehouse/data mart.
• Involved in extensive data validation by writing several complexSQLqueries and involved in back - end testing and worked with data quality issues.
• Performed analysis on enterprise data/report integration and provided functional specification to the development teams to build the Enterprise Reporting Systems.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design
• Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Analyzed and researched the data quality issues and drove them to resolution with external partners and customers.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database
• Built and maintained strong relationships with the business and external customers.
• Experience in various phases ofSoftware Development life cycleAnalysis, Requirements gathering, designing with expertise in documenting variousrequirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Worked closely with the developers and the testers to ensure the requirements and functional designs were translated accurately into working technical designs and that the test plans scripts served the customer s needs.
• Responsible for the creation of several Informatica mappings, session and workflows to load data from other databases to Teradata database according to the requirement.
• Provided guidance and issue resolution on testing plans, provided timely and accurate data quality reconciliation reports to the customers.
• DesignedTableau and Power BIdashboard which give a visual representation for the users on site selection, Visual analytics on location, map etc.
• Extensive Experience working with business users/SMEs as well as senior management.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Improved data quality by providing consistent codes and descriptions, flagging or fixed the bad data.
• Helped to restructure the data so that it delivered excellent query performance, even for complex analytic queries, without impacting the operational systems.
• Migrated data from traditional database systems to Azure databases.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Environment: Tableau 10.x/2018/2019, Alteryx 2018.2, Erwin 9.1, DB2Teradata, Teradata SQL Assistant, Oracle 11g,SAS, Google Big Query, VISIO, JIRA, MS Office Suite (Word, Excel, PowerPoint).

Confidential - Dallas, TX

Data Visualization Developer

Responsibilities:

• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Involved in creating a dual - axis bar chart with multiple measures.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Experience in design and development of Tableau visualization solutions.
• Working on generating various dashboards in Tableau server using various sources such as SQL Server/Teradata/Oracle.
• Understanding of relational database structures, theories, principles, and practices.
• Preparing Dashboards using calculations, parameters in Tableau.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Prepared proof of concept for best practices in Tableau deployment.
• 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.
• Developing a Dashboard and preparing ad-hoc Reporting.
• Created drill down and drill up in worksheets in tableau.
• Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Environment: Tableau Desktop 10, Tableau Server, MS Office Suite, Oracle SQL Server R2, Teradata, MS Excel.