Data Analyst Ms Sql
Resume:
Harpreet Kaur
Data Analyst
****************@*****.***
Professional Summary
An IT professional with 6+ years of experience in various roles which includes Data Analyst, research work, technology assisting,project building seeking for good opportunity. Python, Advanced Excel, SQL, C++, Pandas, NumPy, Plotly, Seaborn, Matplotlib, Tableau, MATLAB.
6+ years of Industry experience as Data Analyst with solid understanding of Business Intelligence, Data warehousing, Data Mapping, Data Validation, Data Integrity, Reporting, Data Governance and Data Modeling.
Experience as a Data Analyst in Banking and Healthcare domain and experience as a passionate business, process, and qualitative analyst with expertise in understanding business problems.
Strong experience in Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
Extensive expertise in SQL Server, including advanced query writing, database design, optimization, and performance tuning.
Proficient in developing and optimizing machine learning models using Python for predictive analytics.
Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
Expertise in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server.
Skilled in utilizing SQL, SSIS, and ETL processes to extract, transform, and load data from diverse sources.
Experienced in data cleansing, validation, and quality assurance techniques to ensure accurate and reliable data.
Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
Good Data Warehousing concepts including Metadata and Data Marts.
Strong understanding of data warehousing concepts and methodologies, including dimensional modelling and star schemas.
Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, MySQL, MS Access and Excel.
Expertise in data governance, data stewardship, data quality, data analytics and reference data management.
Proficient in creating interactive visualizations, dashboards, and reports using Tableau, adhering to data visualization best practices.
Competence in designing visually appealing reports and dashboards in Tableau
Strong experience in Business Intelligence technologies like Framework Manager, Report Studio, Query Studio, Business Objects Web Intelligence, Desktop Intelligence, Universe design etc.
Well Versed in creating automated Reports using Crystal Report and SQL Server Reporting Services.
Proven ability to gather and analyze large datasets to extract meaningful insights, identify trends, and discover patterns and anomalies.
Skilled in creating comprehensive reports, executive summaries, and data visualizations to effectively communicate findings to stakeholders.
Strong understanding of data blending, calculating fields, and parameterization techniques in Tableau.
Proficient in data modelling and transforming data into actionable insights using Power Query.
Expertise in planning, designing, and implementing application database code objects.
Proficient in reviewing and creating stored procedures, functions, and views to optimize database performance.
Skilled in scoping, planning, and executing data analysis projects within defined timelines and deliverables.
Ability to effectively communicate complex technical concepts to both technical and non-technical stakeholders.
Strong proficiency in collaborating with cross-functional teams, including business stakeholders, data engineers, and software developers.
Proactive in staying updated with the latest industry trends and advancements in technology and data analysis tools.
Demonstrated commitment to professional development through workshops, webinars, and obtaining relevant certifications.
Skilled in data blending techniques in Tableau to combine and integrate data from multiple sources for comprehensive analysis.
Competence in calculating fields and creating custom measures in Tableau to derive meaningful insights and support decision-making processes.
Experienced in designing and developing visually appealing reports and dashboards in Tableau, emphasizing user-friendly navigation and intuitive layout.
Proficient in parameterization in Tableau, allowing for dynamic filtering and interactive exploration of data within dashboards.
Strong understanding of ETL, reporting, business analytics (business intelligence) and data warehouse concepts.
Experience with reports and dashboards development for operational and analytical needs and exploring data using data visualization tools.
Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
Worked with BI/Reporting tools such as Tableau, Crystal Reports and Quick sight, having created various Visualizations using Bar/Line/Pie charts, Maps, Scatter Plots, Heat maps and client reports.
Experience in DBMS/RDBMS implementation using object-oriented concept and database toolkit.
Extensive experience with SharePoint, Visio, Power Point, Microsoft Project and Microsoft Office tools.
Executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
Published 3 research papers in reputable journals and presented findings at national conference like IEEE.
Technical Summary
Languages and Packages
Python, SQL, C++, Microsoft Office, MATLAB
Platforms
Windows
Database
SQL
Defect Management
Jira
Data Visualization Tools
Tableau
Certifications/awards
UGC Net Qualified.
Certified IBM DB2 Academic Associate.
Professional Experience
Zoetis Corporation Jan 2023 - Present
Data Analyst
Responsibilities:
Collaborated with cross-functional teams to analyze and interpret complex healthcare data using Python, providing valuable insights for informed decision-making.
Led successful Data Migration projects, ensuring a seamless transition of data from old to new systems while maintaining data integrity.
Ensured client processes aligned with HIPAA rules and regulations for EDI transactions by employing Data Source and Data Mapping techniques.
Performed data cleaning and manipulation using SQL Server, Excel, and Access, optimizing data for ETL processes.
Designed and delivered comprehensive reports and presentations using MS Word, PowerPoint, and MS Project, facilitating clear communication of project progress and insights.
Applied advanced Data Analytics techniques including Data Profiling, Exploratory Data Analysis, and Predictive Modeling using tools like R and SAS.
Collaborated with cross-functional teams in Joint Application Development (JAD) sessions to define and refine business requirements.
Played a key role in implementing and maintaining Data Warehouses and Data Models using Teradata and Snowflake.
Developed detailed Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) based on strong understanding of SDLC and Oracle Database.
Efficiently managed projects using Jira and Azure DevOps, ensuring smooth progress through the Software Testing Life Cycle (STLC).
Collaborated with Data Engineers and Operations Team to optimize SQL queries for Data Extraction and Integration, supporting effective ETL processes.
Utilized XML tools like Informatica and DataStage for seamless Data Extraction, Transformation, and Loading (ETL).
Effectively managed Oracle databases using tools like SQL Server Management Studio (SSMS), TOAD, and SQL Plus.
Resolved complex data issues with critical thinking, ensuring high Data Quality and Integration.
Adapted to Agile and Waterfall methodologies, meeting project milestones and adjusting to changing requirements.
Engaged in Data Governance working group sessions to establish and uphold Data Governance Policies.
Enhanced Data Visualization through the development and maintenance of interactive dashboards and reports using Tableau.
Conducted data analysis on large datasets of animals using SQL, Excel, and Python to extract valuable insights for various projects and clients.
Developed and maintained data pipelines to ensure the smooth flow of data from various sources into the company's data warehouse.
Collaborated with cross-functional teams, including data scientists, business analysts, and software engineers, to understand data requirements and deliver actionable insights.
Performed data cleansing, validation, and enrichment to ensure data accuracy and consistency.
Designed and generated interactive data visualizations and reports using tools like Tableau to present findings to stakeholders.
Identified patterns, trends, and anomalies in the data to provide valuable business recommendations for optimizing processes and decision-making.
Actively participated in team meetings and knowledge-sharing sessions to enhance analytical skills and stay updated on the latest industry trends.
Worked on the requirement gathering of the reports.
Analyzed the database tables and created database views based on the columns needed.
Extract, transform, and load data from various sources into a unified format.
Implement ETL pipelines using Python, Excel, or specialized tools.
Validate and verify data quality during the ETL process.
Implemented calculations and parameters wherever needed.
Published dashboards to Tableau server.
Warner Media February 2020 – December 2022
Data Analyst
Responsibilities:
Analyze large datasets using SQL queries, Python scripts, and Excel functions.
Create interactive and informative dashboards using Tableau to present data insights to stakeholders.
Identify trends, patterns, and anomalies in data to support business decision-making.
Handle missing values, outliers, and data inconsistencies using Excel and Python.
Develop automated data cleaning processes to streamline data preparation.
Perform exploratory data analysis (EDA) to uncover valuable insights.
Apply statistical methods and hypothesis testing to validate findings.
Build predictive models using Python libraries like Pandas, NumPy.
Create and optimize SQL queries to extract data from relational databases.
Design and maintain databases for efficient data storage and retrieval.
Ensure data integrity and security through data management best practices.
Collaborate with stakeholders to understand data requirements and reporting needs.
Generate periodic reports and automate report generation processes.
Provide actionable insights and recommendations based on data analysis.
Used Python and Scala to create pathways for data, making it easier to collect, change, and move around different types of information in the ECHO System.
Used Spark to study lots of data at once and find important information in the ECHO System, using smart methods to discover valuable patterns and insights.
Analyze complex healthcare data using tools like SSRS and Tableau to uncover valuable insights, aiding informed decision-making.
Implement Master Data Management (MDM) strategies for data accuracy and consistency across healthcare systems.
Use Informatica and ETL tools for seamless data integration and migration, ensuring data quality.
Collaborate with stakeholders to gather and document requirements using methodologies like JAD (Joint Application Development), and translate them into functional and technical specifications (FRD/BRD).
Create interactive dashboards and reports using Tableau and Excel to provide meaningful insights.
Perform statistical analysis with tools like SAS and R to identify patterns in healthcare data.
Collaborate with cross-functional teams using tools like Jira, ensuring timely and successful project delivery.
Ensure compliance with healthcare regulations like HIPAA 4010 and 5010.
Manage end-to-end ETL processes using SSIS and SSMS.
Provide expertise in data integration technologies, including SQL Loader, enhancing data flow across systems.
Support database administration activities, including Oracle DBA, SQL DBA, and PL/SQL for optimal performance.
Offer innovative solutions to improve data processes and healthcare operations.
Collaborate in Agile or Waterfall environments to deliver successful data-related projects, following SDLC methodologies.
Nokia Networks
Data Analyst March 2017- February 2020
Responsibilities:
Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
Generated portfolio analysis and P&L reports by performing risk analysis and risk management (Credit Risk, Market Risk, Reinvestment Risk, and Inflation Risk) based on the client investment objectives.
Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in house metrics.
Designed and developed MDM data model and integration of Web Sphere Process Server.
Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
Verified all aspects of Client Identification Program (CIP) and necessary account opening documents are provided and in accordance with know Your Customer (KYC) and Bank Secretary Act (BSA) standards.
Transformed project data requirements into project data models.
Worked with Data Analysis Primarily Identifying Data Sets, Source Data, Source Metadata, Data Definitions Data Formats, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.
Involved in Data Architecture Designing and development of a Central Data Repository of Static Content for Syndicated Loans business. Liaison with the Syndicated Loans team as well as downstream clients in the bank to define scope and requirements.
Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, Metadata, Data Profiling.
Produced functional decomposition and logical models into an enterprise data model.
Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
Analyze the Bank's data and business terms from a data quality and integrity perspective.
Delivered Enterprise Data Governance, Data Analyst, Metadata, and ETL Informatica solution
Assists ETL team to define Source to Target Mappings.
Daily Data quality checks and Data profiling for accurate and better reporting and analysis.
Exploits power of MS SQL to solve complex business problems by data analysis on a large set of data.
Strong Data modeling skills including Star Schema and Snow-Flake models and E-R modeling, Dimensional modelling.
Working knowledge of different data sources such as Flat files, Oracle, SQL Server, RDBMS, Teradata and have knowledge in Data extraction, profiling, identifying data quality issues.
Achievements / Research Work
My paper entitled “A Comparative Review of Various Illumination Estimation Based Color Constancy Techniques” is accepted by IEEE conference ICCSP’16 for publication.
Research paper entitled “An integrated CEA approach for color light source estimation” is published by MECS publisher in IJITCS journal, Pub. Date:2017-2-8, DOI:10.5815/ijitcs.2017.02.07.
Research paper entitled “A hybrid CEC approach for estimation of color light source” is published in ICCCN-2017 proceedings held at NITTTR, India.
Contact this candidate