SUMMARY

• About 6+ years of data analyst experience possess a strong background in quantitative analysis, data visualization, and database management. With excellent communication skills and a keen attention to detail, I am committed to delivering high - quality results that exceed expectations.
• Experience in Data Analytics, Data Modeling, Data Mapping, Data Extraction, Data Cleaning, Data Validation, Data Manipulation, Compliance Reporting, Data Quality and ETL Process.
• Experience in migrating SQL database to Azure Data Lake, Azure data lake analytics, Azure SQL database, Azure Data factory and Data bricks in building pipelines.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance and Metadata Management, Master Data Management and Configuration Management.
• Ability to work on various aspects of Data transformations and Data Modelling.
• Created SSIS packages to pull data from SQL Server and exported toExcelSpreadsheets and vice versa.
• Was responsible forETLand data validation using SQL Server Integration Services.
• Implemented various frameworks for Data Quality Analysis, Data Governance, Data Trending, Data Validation and Data Profiling.
• Proficient in data analysis using SQL, Tableau, and other data analysis techniques.
• Created ad hoc queries and reports to support business decisions SQL Server Reporting Services (SSRS).
• Extensive knowledge in all phases of Data Acquisition,Data Warehousing(gathering requirements, design, development, implementation, testing, and documentation),Data Modeling(analysis usingStar SchemaandSnowflakefor Fact and Dimensions Tables), Data Processing and Data Transformations (Mapping, Cleansing, Monitoring, Performance Tuning).
• Experience working with GCP Cloud services like GCP cloud dataflow,GCP Big Query, GCP Cloud Storage,
• Day to-day responsibility includes developingETLPipelines in and out ofdata warehouse, develop major regulatory and financial reports using advanced SQL queries in snowflake cloud Datawarehouse.
• DevelopedTableauvisualizations and dashboards usingTableauDesktop.
• Skilled in Azure cloud technologies like Azure Data Factory, Azure Databricks, Azure Data Lake Storage (ADLS), Azure Synapse Analytics, Azure SQL Database, Azure Analytical services,
• Writing complex SnowSQL scripts in snowflake cloud data warehouse to business analysis and reporting.
• Conducted Data blending, Data preparation using Alteryx and SQL for Tableau consumption and publishing data sources to Tableau server.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Informatica Power Center, Informatica Data Quality (IDQ), Informatica Analyst, Informatica Master Data Management (MDM), Informatica Meta Data Manager, Data Stage, SSIS.
• Used data analysis techniques to validate business rules and identify low-quality missing data in the existing Enterprise Data Warehouse.
• Created data mapping documents for incorporating the ETL strategy utilizing SSIS.
• Design, develop, and test dimensional data models using Star and Snowflake schema methodologies under the Kimball method.
• Working knowledge with Power BI, including the creation of reports with the software.
• Involved in the entire software development life cycle (SDLC) for the application, which included Agile and Waterfall approaches.
• Excellent communication and interpersonal skills, as well as the ability to operate effectively in cross-functional team contexts.

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Senior Data Analyst

Responsibilities:

• Strong working experience in theData Analysis, Business Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Working experience on interactive dashboard and Reports in Tableau for monitoring the operation performance on a day-to-day basis.
• Experience in creating Data Governance Policies, Business Glossary,Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
• OutstandingData analysisskills including Data mapping from source to target database schemas, Data Cleansing, and processing, writing data extract scripts/programming of data conversion, and researching complex data problems.
• Write complex SQL scripts to analyze data present in different Databases/Data warehouses like Snowflake, Teradata.
• Worked with the data steward and data owners in creating metadata, Lineage, Data Quality rules and guidelines.
• Developed ETL packages for pulling data from different source systems likeOracle, Teradata, flat files into SQL Server database.
• Gather requirements and develop various SQL jobs, scripts which involved extensivedata analysisand understanding of data warehouse and ETL processes. This project was run onagilesprint process of 2 weeks per sprint usingJIRAticketing tool.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintainingData Dictionaryand Interface requirements documents.
• Performed extensive system analysis to design data model which helped in loading data from multiple data sources. Performed statisticaldata analysisanddata visualization.
• CreatedPower BIData Quality reports/dashboards for multiple lines of business.
• Understand business requirements and provide workable technical solution throughAgile/Scrumsteps after testing and user acceptance.
• Involved in extensive DATA validation usingSQL queriesand back-end testing.
• Worked on Snowflake Schemas and Data Warehousing and processed batch and streaming data load pipeline using Snow Pipe andTalend.
• CreatedTalendflows to load and transform the data from various sources like flat files (delimited and positional),Oracle, MS SQL Server, MS Access and excel files.
• Expertise in collecting, analyzing, and visualizing the data by generatingLookerreports.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• PerformedData Analysisand Data validation by writing complex SQL queries using TOAD against theORACLEdatabase.
• Responsible for creatingData Discoverydocuments that involved extensivedata analysisby providing source data insights. worked on SQL query skills (Oracleand TSQL) in analyzing and validating SSIS ETL database data warehouse processes.
• Hands-on Experience inPower BIPower Pivot, Power integrated with Share Point and in creating dashboards inPower BIand Tableau visualization tools.
• Migrated data from SQL Server toOracleand uploaded as XML-Type inOracleTables.
• Responsible for Test Management inJIRA, providing Test Team with Test Strategy, Test Execution Schedule, reviewing and authorizing test cases.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Centre. Metrics reporting, data mining and trends in helpdesk environment using Access.
• Worked and extracted data from various database sources likeOracle, SQL Server, DB2, and Tera data/Big Data.
• Write complex SQL scripts to analyze data present in different Databases/Data Warehouses like Snowflake, Teradata.
• Strong knowledge of Database Management Systems like Oracle, SQL Server, and Snowflake.
• Experienced in all stages of software development life cycle (SDLC) including Business Process Analysis, Requirements gathering.
• Experience in GCP Dataproc, GCS, Cloud functions, Big Query.
• Proficient in data analysis using SQL, Tableau, and other data analysis techniques.
• Developed artifacts that are consumed by the data engineering team such as source-to-target mappings, data quality rules, data transformation rules, Joins etc.
• Extensively used Informatica PowerCenter, Informatica Data Quality (IDQ) as ETL tool for extracting,

Environment: Data Dictionary, Metadata management, Data Discovery, Data Quality, Data Profiling, Data Governance, Data Validation, Business Analysis, Requirements gathering, Data Steward, Data Governance Council, Power BI, SQL, SSIS, Talend, Excel, Agile, JIRA, Snowflake, Azure Data Factory, Looker

Confidential, Dallas, TX

Data Analyst

Responsibilities:

• Worked on multiple databases, analyzing data-warehouse data, data governance, data validation, Data Profiling, testing applications.
• Have worked on ETL tools like SSIS for Data Collection and updating Longitudinal Databases and
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Experienced in data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Have considerable expertise in Metadata Management, Data Analysis, Data Integrity, Data Acquisition, Data Steward, Data Mining, Data Profiling & Quality, Data Governance and Master Data management (MDM).
• Used JIRA for issues and bug tracking and added several options to the application to choose algorithms for data and address generation.
• Writes SQL Stored Procedures and Views and performed in-depth testing of new and existing systems.
• Used Data Integrator to load data from various sources such as MS Access, MS Excel, CSV files to MS SQL Server.
• CreatedPower BIData Quality reports/dashboards for multiple lines of business.
• Worked on the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
• Experienced in implementation and support of SQL Server Database Systems, Reporting Services (SSRS), and Integration Services (SSIS) and drill down reports, partitioned views, and large datasets.
• Worked in Various stages of Data warehousing life cycle of development database logical and physical design, ETL process, performance tuning on Windows.
• Excellent knowledge inData Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Used Data Integrator to load data from various sources such as MS Access, MS Excel, CSV files to MS SQL Server.
• Extracted data from SQL Server database tables andOracledatabase tables into flat data files and Excel sheet
• Used SQL Loader and SQL Developer to load data from flat data files and excel sheet intoOracledatabase.

Environment: SQL Tableau, Data Quality, Data Profiling, Data modeling, Data Integration, SSIS, Excel, Data validation, Stored Procedures.

Confidential, Dallas, TX

SQL Analyst

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
• Manage Departmental Reporting systems, troubleshooting daily issues, and integrating existing Access databases with numerousexternal data source including (SQL, Visual Studio 2010, Excel, & Access).
• Performed data analysis and data profiling using SQL on various sources systems.
• Conveyed the key insights the data reveals in a visual format that is grouped, summarized, or formatted to be easily understood.
• Involved in extensive Data Validation by writing several complexSQLqueries and involved in back-end testing and worked with data quality issues.
• Experienced in data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Performeddata miningon Claims data using very complex SQL queries and discovered claims pattern.
• Identified patterns and anomalies in the data to understand their implications.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server.
• Collaborated with end-users to interpret data results and analyzed the potential impact on the business.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Familiarity with agile development methodologies and experience in working in agile development teams.
• Used Data Integrator to load data from various sources such as MS Access, MS Excel, CSV files to MS SQL Server.
• Performed data analysis and data profiling using SQL on various sources systems.

Environment: SQL, MS Excel, T-SQL, Agile, SQL Server, MySQL, Data Analysis, Data Profiling, Data Modeling, Data Mapping, Data Integration, Data Validation, Data Warehousing, Visual Studio.