PROFESSIONAL SUMMARY:

• Professional wif more than 6+ years of Data Analytics experience. I has extensively worked on creating Data Visualization Dashboards and reports using Tableau, Power BI, and MicroStra. I has experience in extracting, transforming, and loading (ETL) data from spreadsheets, database tables, and other sources using Alteryx, Microsoft SSIS, and Informatica.
• I am also experienced in building data integration and workflow solutions, and ETL solutions for data warehousing using SSIS, Informatica & Alteryx.Strong experience ininteracting wif stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures,defining business processes, identifying andanalyzing risksusing appropriate templates and analysis tools.Experience in various phases ofSoftware Development life cycle(Analysis
• Requirements gathering, Designing) wif expertise in documenting variousrequirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.Experience in codingSQL/PL SQLusing Procedures, Triggers and Packages.
• Good understanding ofRelational Database Design,Data Warehouse/OLAP conceptsand methodologies. Experience in Working wif different industries likeFinancial,Healthcare and pharma industries. Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.Highlighted Data Quality issues and areas of system control gaps Linked data lineage to data quality and business glossary work wifin teh overall data governance program.
• Experience in working on cloud data warehouse platforms GCP BigQuery, Snowflake & AWS Redshift.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr Data Analyst

Responsibilities:

• TEMPEffectively interacted wif Business Analysts and Data Modelers and defined Mapping documents and Design processes for various Sources and Targets.
• Gatheird user requirements, analyzed and designed software solutions based on teh requirements.
• Worked extensively in documenting teh Source to Target Mapping documents wif data transformation logic.
• Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
• Performed Dependency Analysis (by identifying any breaks in lineage), root cause analysis and remediation as part of teh data lineage effort.
• Tracked metrics/KPIs that provide visibility to management into teh lineage progress.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T - SQL to provide definition, structure and to maintain data efficiently.
• Teh building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Conducted workshops to elicit requirements and educate business and IT in MDM, data governance, data profiling, data lineage tracking and data analysis concepts and techniques.
• Communication of findings to teh Project leaders and Business leaders, and raising issues to resolve, to ensure efficient closure of validation of simulation and universe update.
• Manipulate, cleanse, and process high-volume and/or complex data in order to assemble daily, weekly, and monthly reports for leadership and decision-makers
• Worked on Snowflake cloud modeling and highly proficient in data warehousing techniques for data cleansing.
• Design and develop an end-to-end ETL process from various source systems to Staging area, from staging to Data Marts and data load.
• Designed ETL process using Alteryx Tool to load from Sources to Targets through data Transformations.
• Monitor data continuously by utilizing root cause analysis to identify, communicate, and resolve problems, when necessary, in order to ensure teh accuracy of teh data
• Present insights, trends, and possible recommendations by using visual elements supporting teh relevant points of teh analysis in order to ease stakeholder understanding
• Develop standard reports by building queries to pull and organize data from various sources, establishing teh cadence, and validating teh necessity of teh report based upon teh needs of teh organization
• Identify opportunities for automation or software applications by reviewing and evaluating teh current reporting state in order to maximize teh efficiency, accuracy, and timeliness of teh reporting process.
• Extensively used Alteryx for Data Preparation and then Tableau for Visualization and Reporting.

Environment: MS SQL Server, Snowflake, Teradata, Teradata SQL Assistant, Oracle 11g, Alteryx 2018.2, SAS, GCP Big Query, VISIO, JIRA,Tableau 2020.

Confidential, Dallas, TX

Data Analyst/Tableau Developer

Responsibilities:

• Consulted wif application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Involved in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.
• Performed requirements gathering and design analysis for customer contact history for customer relationship management.
• Managed Business Intelligence data questions received from executives, analytics and research team to understand teh trend and behavior. documented of Business Lineage and Technical Lineage for multiple applications..
• Developed data profiling to identify anomalies and designed new data collection models to better collect information
• Took ownership of Source to Target Mapping and tracked and maintained changes.
• Performed Extraction, Transformation and Loading (ETL) using Informatica power center.
• Designed and implemented data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Worked on creating stored procedures, functions, views, triggers, packages in PL/SQL.
• Worked on transforming complex business requirements into rich data visualizations using Tableau
• Prepared technical specifications and documentation for Alteryx workflows supporting downstream uses.
• Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting.
• Processed data in Alteryx to create TDE for tableau reporting.

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

Confidential, NJ

Tableau Developer

Responsibilities:

• Worked wif multiple businesses to understand teh user requirements, layout, and look and feel of teh application to be developed.
• Data blending implemented on SQL Server database and generated interactive dashboards.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Designing rich and interactive Visualizations wif drill-down and filter capabilities.
• Performance Tuning complex Tableau dashboards.
• Developed Mobile dashboards to enable users wif access to frequently used reports.
• Developed scorecard views for Advanced account analytics wif numerous KPIs.
• Publishing teh data sources and reports to Server and setting up teh server security.
• Managing and Monitoring Data Extract Refreshes and schedules on Tableau Server.
• Writing SQL views and creating complex joins and Nested loops for Tableau Data source creation.
• Developed complex strategies to reuse dashboards across different sales forces and different hierarchies.Used advanced charts and Tableau extensions to enable additional features in teh existing versions of teh tableau.

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