PAVAN KUMAR

734-***-****

ade42p@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Over 6+ years of IT experience in the field of Data analysis, ETL, and Data Modeling.

•Strong experience in Business and Data Analysis/ QA., Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.

•Detailed understanding of SDLC methodologies (Agile, Scrum, RUP, Waterfall)

•Experience in working with project managers and cross functional teams during various project implementations

•Extensive experience in requirements analysis including Gap, Ambiguity and Risk analysis.

•Attended and led JAD sessions as a QA analyst.

•Experience in creating Ad-hoc reports, data driven subscription reports by using SQL.

•Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

•Expert in Data Conversion, Normalization, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

•In-depth knowledge of RDBMS concepts with expert knowledge of constructing Relational Database according to business requirement.

•Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.

•Proficient in Quick Test professional (QTP) utilizing Object Repository, Object Spy, Object Identification, Regular Expression, Checkpoints, parameterize values, Descriptive Programming, Exception handling, and using Recovery Scenarios,

•Extensive experience in writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

•Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.

•Good experience in development of reports using Crystal Reports, Business Objects, SSIS, SSRS, Tableau and Data Reports.

•Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.

•Proficient knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS

BI Tools: Tableau 10.x,9.x,8.3/8.2/8.1/8.0/7.0, SAS, SSRS, Salesforce, Crystal Reports 9.0/8.5,OLAP, Power BI

Databases: SQL Server 2012, SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g

Languages: UML, C, C++, HTML, Java, Oracle ETL, SQL, PL/SQL

Application Packages: MS Visio, MS Project, MS Access, MS Office Suite, RDBMS: Oracle 11g

Data Warehousing ETL Tools and Environment SSIS, Teradata, Hadoop, Snowflake.

WORK EXPERIENCE:

Comcast, Pittsburgh PA Jan 2020 – Present

Role: Data Analyst

Responsibilities:

•Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.

•Involved in documenting the business processes by identifying data required for analysis from multiple sources and the method of obtaining and storing data.

•Involved in gathering and documenting the requirements, for building OLAP environment for generating banker reports

•Analyzed the Business Specification and created the test plan, test cases for functional and GUI testing

•Categorized the test cases, test data and maintained separate test sets to execute various real time transactions

•Performing Data validation on OLAP cubes by running MDX Scripts and T-SQL Scripts

•Comparing Data from multiple environments

•Maintaining project schedule for the QA activities by constantly reviewing the project schedule and prioritizing the QA activities

•Involve in documenting the source to target data mappings, business rules and data definitions

Perform in depth analysis of data & prepare daily reports by using SQL, MS Excel, MS PowerPoint and share point.

•To test performance issues involved with the web application and to figure out the bottlenecks and bugs related to Servers and Load balancer while testing each web page of the UI and integration of web application with other components.

•Generating business reports on Tableau.

•Document data quality and traceability documents for each source interface

•Establish standards of procedures.

•Wrote SQL queries for database testing and to create request XMLs for SoapUI requests.

•Generate weekly and monthly asset inventory reports.

•Evaluated data profiling, cleansing, integration and extraction tools.

•Assisted in preparing BRDs, FRDs, and Test Cases.

•Performance tuning and Optimization of large database for fast accessing data and reports MS Excel UNIX, Oracle, Teradata being used for data transformation.

•Responsible for defining the functional requirement documents for each source to target interface.

•Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.

Environment: SQL Server, Visual studio, SSAS, SSIS, Tableau, Quality center 10.0, QTP 10.0, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Business Objects, Power Designer, IBM Data Stage.

PNC Financial Services, Pittsburgh, PA Nov 2018- Jan 2020

Role: Data Analyst

Responsibilities:

•Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.

•Interact with the SME's to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system

•Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information.

•Performed Data Driven Tests by parameter zing the fixed values to read from various Text, Excel and Access files for regression testing. Involved in writing Test plan to perform system testing.

•Performed data driven testing using excel file in QTP, Developed test scripts using QTP to perform smoke, functional and regression testing

•Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.

•Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.

•Enforce standards to ensure that the data elements and attributes are properly named,

•Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.

•Support development teams creating applications against supported databases.

•Provide 24 x 7 problem management supports to the development team.

•Document various Data Quality mapping document, audit and security compliance adherence.

•Perform small enhancements (SOR element additions, data cleansing/data quality)

•Create various Data Mapping Repository documents as part of Metadata services (EMR)

•Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.

•Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.

Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Manual Testing, Quality Center, Power Designer, Data Stage, UNICA 6.4

Occam Technologies, Hyderabad, India June 2014 – Aug 2018

Role: Data Analyst

Responsibilities:

•Tracked various campaigns, generating customer profiling analysis and data manipulation.

•Provided R/SQL programming, with detailed direction, in the execution of data analysis that contributed to the final project deliverables. Responsible for data mining.

•Utilized Label Encoders in Python to convert non-numerical significant variables to numerical significant variables to identify their impact on pre-acquisition and post acquisitions by using 2 sample paired t test.

•Worked with ETL SQL Server Integration Services (SSIS) for data investigation and mapping to extract data and applied fast parsing and enhanced efficiency by 17%.

•Developed Data Science content involving Data Manipulation and Visualization, Web Scraping, Python programming, SQL, GIT and ETL for Data Extraction.

•Designing suite of Interactive dashboards, which provided an opportunity to scale and measure the statistics of the HR department which was not possible earlier and schedule and publish reports.

•Provided and created data presentation to reduce biases and telling true story of people by pulling millions of rows of data using SQL and performed Exploratory Data Analysis.

•Applied breadth of knowledge in programming (Python, R), Descriptive, Inferential, and Experimental Design statistics, advanced mathematics, and database functionality (SQL, Hadoop)

•Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS)

•Involved in defining the Source To business rules, Target data mappings, and data definitions.

•Performing Data Validation / Data Reconciliation between disparate source and target systems for various projects.

•Utilized a diverse array of technologies and tools as needed, to deliver insights such as R, SAS, Tableau and more.

•Used T-SQL queries to pull the data from disparate systems and Data warehouse in different environments.

•Worked closely with the Data Governance Office team in assessing the source systems for project deliverables.

•Extracting data from different databases as per the business requirements using SQL Server Management Studio.

•Interacting with the ETL, BI teams to understand / support on various ongoing projects.

Environment: Data Governance, SQL Server, Python, ETL, MS Office Suite - Excel (Pivot, VLOOKUP), DB2, R, HP ALM, Agile, Azure, MDM, Share point, Data Quality, Tableau and Reference Data Management.

EDUCATION:

PG Diploma in Data Science, IIIT Bangalore, India

Master of Science in Industrial Management, USF, Florida

Bachelor of Science in Metallurgical and Material Sciences Engineering, NIT Jamshedpur, India

Contact this candidate