DATA ANALYST

Krishna Kachariya

Souderton, PA

Phone- 917-***-**** Email – ad3niy@r.postjobfree.com

Summary:

• Around 5 years of strong experience in Business and Data Modeling/ Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration, and SQL

• Expertise and Vast knowledge of Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT) and Business Intelligence.

• Skilled in implementing SQL tuning techniques such as Join Indexes (JI), Aggregate Join Indexes (AJI's), Statistics and Table changes including Index.

• Experienced in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.

• Extensive experience in development of T-SQL, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.

• Responsible for architecture design, data modeling, and implementation of Big Data platform and analytic applications.

• Experienced in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.

• Sound knowledge on SDLC process - Involved in all phases of Software Development Life Cycle - analysis, design, development, testing, implementation, and maintenance of applications.

• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and Teradata databases.

• Experienced in Creating and Maintaining documentation such as Data Architecture/Technical/ETL Specifications.

• Strong exposure in writing simple and complex SQL, PL/SQL queries.

Technical Skills:

ETL Tools:

SSAS, SSRS, SSIS, Sybase Scripting SQL

Programming Languages:

JAVA, Python, HTML, SQL, PL/SQL, XML, MySQL, Java

Reporting:

Tableau, Power BI, Cognos Reporting, Business Objects, Oracle Reports, MS Excel Reports, MS Access Reports

Tools:

Tableau, R, Teradata, SQL Developer, Informatica, TOAD, Jira and HP QC, HP ALM

DQ Tools:

Informatica Analyst, Developers Client (IDQ), Informatica B2B Data Transformation

Others:

Microsoft Access, VBA, Macros; SQL (QBE), Excel (VLOOKUP, HLOOKUP, PivotTable), Word, Outlook, PowerPoint

Work Authorization: H4EAD

Education: Bachelor of Commerce from J. Z. Shah Arts & H. P. Desai Commerce College, Surat, India (2015)

Professional Experience:

PNC Bank Aug 2021 - Present

Associate Data Analyst

Responsibilities:

Analyzed Business user and technical requirements for proposed projects system solutions.

Interacted with various business team members to gather the requirements and documented the requirements.

Utilized various software and research tools to accomplish the daily tasks such as Morningstar Workstation, Morningstar Direct, Spreadsheet and database applications (Excel and Access).

Worked actively in data profiling, data scrubbing and data cleansing for Data Warehouse.

Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.

Develop new processes for better practices within the MDM department.

Analyzed data by creating SQL queries and identified fact and dimension tables.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in SQL Server

Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures in SQL Server.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different data transformations (DTS) using SSIS.

Writing T-SQL scripts to manipulate data for data loads and extracts.

Worked on validating regional data warehouse data and performed data validation by creating macros.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures.

Involved in tuning SQL Server Databases using available tuning methods like index tuning wizards, profiler and execution plans.

Worked in troubleshooting production servers for user and application issues. EDUCATION Masters in Computer Science, University of Texas, Dallas

Virginia Department of Health Jan 2020 – Aug 2021

Data Analyst

Responsibilities:

The project scope is to move the Legacy Data from mainframe, source system to SQL Server is Target changing to MDM using Informatica Data Quality empowers to managing data quality across the enterprise.

Worked with Stake holders and Business Analysts to gather business requirements and create requirements mapping document from source to destination.

Extensively used agile methodology and utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling.

Interacted with business stakeholders to understand their decision-making parameters, analysing the available data to build Tableau Dashboards and managing the deliver

Participated in Transition management assist users and educate them on tableau ad-hoc reports.

Performed SQL tuning to improve the performance of the queries.

Highly proficient in creating indexes for fast retrieval of data, views, triggers, stored procedures and User defined functions.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Performed data analysis using advanced excels functions like v-lookup, pivot tables, charts, excel macros, etc. and reported the findings to the team.

Generating various capacity planning reports (graphical) using Python packages like NumPy, Matplotlib, SciPy.

Scheduled jobs and alerts using SQL Server Agent and configure database mail for job failure.

Worked in data integration into a data warehouse from heterogeneous and homogenous data sources including SQL Server database, Oracle database, fixed width / delimited flat files, XML files, and other sources.

Developed the required data warehouse model using Star and snowflake schema for the generalized model.

Optimized the performance of SQL queries using SQL profiler and SQL server database engine wizard.

Created SQL datasets for Power BI and Ad-hoc Reports.

Developed Profiling for Customer data validation in Power BI to produce valid data and helped in visualization using Power BI.

Analyzed Business Requirements from Black Box testing perspective; reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability, and security requirements.

Contact this candidate