Pratik Kumar Email & Phone Number

Bothell, Washington, United States

United States

In my role as a data analyst, I have been involved in a wide range of projects encompassing data modeling, regulatory compliance, fraud detection, and data quality improvement. I've contributed to the creation of fact and dimension tables in Star Schema models, ensuring data accuracy and relevance to meet specific project requirements

United States

In my role as a data analyst, I have played a pivotal role in multiple projects across various domains, including data testing, risk management, asset management, and data migration. I have been responsible for creating comprehensive test data and test case documentation for unit, integration, and regression testing, ensuring the quality and accuracy of reports being developed.

Maharashtra, India

Designed dashboards using Tableau and Power BI and presented before clients.Worked on customer requirement analytics and improved overall customer satisfaction.Created various profiles using Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ), from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.Performed ingestion strategy and data acquisition with incremental data load in Hive.Implemented an MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.Performed root cause analysis on smaller self-contained data analysis tasks that are related to assigned data processes.Created Data Quality Check templates to track and improve data quality in Teradata Enterprise Data Warehouse, crucial for procurement and sourcing decision-making.Used SAS ODS to create output files in different formats including PDF and RTF.Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.Used Hive and Sqoop to build tables and pull data from transactional data bases to NoSQL data bases (Accumulo- Hadoop Big table).Gathered and analysed the data related to the project or initiative, including financial data, customer data, market data, and other relevant information. They use statistical tools and techniques to identify patterns and trends in the data, and to make projections about the potential costs and benefits of the project.Provided insights and recommendations to senior management about the financial viability and feasibility of the project. They also help to identify areas where costs can be reduced, and where benefits can be maximized.Identified meaningful insights from chargeback data.

India

Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ERWIN.Assisted in the design of an efficient, reliable ETL mechanism.Developed several Type 1 and Type 2 dimension mappings.Developed error trapping and email notification mechanisms.Provided performance tuning, analyzing query plans, indexes, and locking behavior to ensure efficient processes are developed to meet systems performance requirements.Maintained the existing ETL processes to accommodate changes in source systems and business requirements.Developed test requirements, plans and scripts and supported the testing and ETL code promotion processes.Provided daily support, troubleshooting and established/maintained strong partnership with technical counterpart and Operations user community.Provided representation at end-user meetings and technical meetings.Coordinated and assisted technical analysts with design solutions for application modifications, interfaces and reports.Continuously monitored and improved all aspects of production system architecture focusing on efficiency and reliability of data extraction, system integration, error handling and process automation.Actively collaborated with supporting teams such as DBA*s and System/Data Architects.Maintained concise documentation of all development logic and subsequent amendments.Developed ad-hoc reports using Cognos Impromptu.Mentored the development team.Environment: ETL Informatica Power Center 7.1.4, Oracle 9i, Teradata, MS SQL Server 2000/7.0, DB2, Toad, SQL, XML, Windows NT/2000, HP-UX.