Data Analyst

Priya Kothari Email : *************@*****.*** Phone: 216-***-****

LinkedIn : https://www.linkedin.com/in/priya-kothari-621a2928/

Self-motivated professional with strong analytical and debugging skills.

Data champion and strategist. Extremely proficient working with Vertica, Oracle, DB2 and Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.

Sound 13 years’ experience in Data warehousing and BI.

Expert in informatica, Unix, HP vertica, Extensive data analysis and scripting through SQL and PLSQL Blocks, Gap analysis, root cause analysis, impact and risk analysis, very proficient working wih ADOBE analytics

Experience in dealing with Apache Hadoop components like HDFS, MapReduce, Hive. Big data and Big data Analytics. Exposure to Tableu reporting.

Oracle certified Associate

Expertise in maintaining data quality, data governance and organization, metadata and data profiling.

Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

ETL migration projects and Database migration projects (vertica, oracle)

Oracle (SQL/PLSQL) certified Associate

Mentored a development team of 15 members supporting PNC’s Enterprise Information platform.

Worked on power exchange, XML sources/ targets, SCD logics – captured change data control

Experience to Logical and physical data modeling using ERWIN and VISIO

Solid Expertise in Oracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data like Flat Files, XML Files, Oracle, DB2, Teradata, SQL Server into Data Warehouse/Data Marts using Informatica.

Good team player with high work ethics.

Technical Skills

Programming Languages: Unix Shell scripting, PL/SQL

Database & tools: SQL Server, Oracle, Teradata, DB2 and Vertica, ERWIN, TOAD, DB Visualizer

Big Data Technologies: Apache Hadoop Ecosystem, HDFS, Hive, AWS

ETL & Reporting Tools: Informatica Power Center 9.x, Tableau, IBM Cognos, Informatica power exchange, cognos

Project Management Tools: JIRA, Microsoft Visio, MS Office Suite

Scheduling: Tidal, AutoSys

Career Profile

Sr. Technical data analyst, Intuit Plano, TX May 2017 – Till date

Adobe Clickstream data automation and Data modeling using ERWIN for event driven analytics platform

Understand Adobe clickstream data and help develop and support business use cases through analytics

Build reporting requirements and tables, projections in HP vertica on click stream data and other sources.

Schedule Jobs through tidal to populate reporting tables for Tableu reporting

Analyze data and Develop data models in HP vertica on sources like clickstream, Sibel, Salesforce, Cassandra and EDW for efficient reporting

Code check in and check out through GITHUB

Load and query data in Integrated Analytical Cloud (Hadoop) data lake using Hive queries

Analyze data and build aggregates for Tableau reporting

Sr. CDI engineer /data analyst, Targetbase, Irving, TX Feb 2015 – Nov 2016

Analyze business requirements, designs and write technical specifications to design and redesign solutions.

Provide solutions through rigorous data analysis using ANSI SQL and EXCEL

Developing simpler Extract Transform Load – informatica solutions for the complex business logic

data mining and profiling using TOAD and SQL for all sources to find data anomalies and taking/guiding corrective measures

Designed and develop ETL mappings to load datamarts

Logical Data modeling for staging area using MS-VISIO for holding the calculative data and participated in Data modeling review for the target data marts

provide inputs based on the extensive data analysis and logical reasoning.

Impact analysis for identified changes while early in the development

Causal analysis for the defects, maintained data dictionary, Developed Business Object reports

Monitor and schedule jobs through Tidal, Production support

Presented findings and data to team to improve strategies and operations

Proposed solutions to improve system efficiencies and reduce total expenses

Unit testing of code & successful Implementations while supporting user acceptance tests

ETL estimates and assistance in project planning, Work with business to identify areas requiring decisions/clarity in order to define project scope and objectives/requirements.

Weekly development status reports, status calls and handover calls with project teams

Sr. ETL / Data Analyst, PNC Bank, Dallas, TX Nov 2013 to Oct 2014

Did data analysis for all 5 sources to find data anomalies and taking correcting measures using SQL

Designed and develop ETL mappings to load datamarts, Designed High level ETL for loading data from 5 different source systems till the population of the Datamart

Analyzed complex PLSQL procedures and converted them into ETL maps

data modeling for staging area for holding the calculative data and audit balance fields

Impact analysis for identified changes while in the build phase

Causal analysis for the defects

Extensive Teradata - SQL scripting Performed tuning and optimization of complex SQL queries using Teradata Explain.

Created Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.

coding of optimized Teradata batch processing scripts for data transformation

Unit testing of code & successful Implementations while supporting user acceptance tests

ETL estimates and assistance in project planning

Weekly development status reports, status calls and handover calls with onsite and offshore teams

Developed unix shell scripts and JIL scripts for Autosys scheduling

Logical data modeling us MS-VISIO

QA lead, Data Analyst Citi Financial Solutions, Irving, TX July 2012 to Oct 2013

Designing and developing Test plan based on the business and functional Requirement document

Designing test strategies and walkthrough for all involved parties (development team, BA, DA, PM)

Test cases / test scripts development and execution through extensive data analysis and requirement analysis

QA validations in SIT, UAT, production checkouts and business acceptance testing

Coding of optimized Teradata batch processing scripts for data transformation, aggregation

Defect raising and tracking in HP Quality Center

Daily stand up with offshore, Weekly development status reports, project calls and status meetings, Scrums

Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.

Rigorous Requirement analysis to develop test plans

Data analysis and finding possible impacts and issues due to agile changes

Source to target mapping analysis Vs functional requirements to ensure data quality and applicability

Worked on optimizing and tuning the Teradata views and SQLs / PLSQL blocks to improve the batch performance and response time of data for users.

Prepared low level technical design document and participated in build/review of the BTEQ Scripts, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.

Capacity planning template design, effort estimation template design, actual effort tracking

Daily, Weekly, Monthly management reporting, cost and resource head count reports, Actual effort Vs plan view allocation reports

Sr. BI developer/ Analyst, Santander Consumer USA, Dallas, TX January 2012 to July 2012

Worked with complex SQL queries and PLSQL procedures/functions to test the data generated by the ETL process against the target database

understanding and certification of basic Auto financing business

Developed High level ETL Design and Architecture for the origination system enhancement module

Requirement analysis, Source data analysis and target data validation to ensure end results for dashboard reporting

Design and develop ETL mappings to load datamarts

Root cause analysis and lesson learnt documentation for identified defects. Validating defects logged into HP Quality Center and resolving same as applicable

Worked with XML sources and targets in informatica mappings. Validated and Analyzed XML Sources

ETL estimates and assistance in project planning

Developed and redesigned unix shell scripts

Working with offshore team and onsite coordination

Weekly development status reports, daily hand off with offshore, project stand up meetings and status calls

PNC Bank, Cleveland, OH July 2010 to December 2011

High level ETL Architecture for 360 degree view of a customer (Credit card, Mortgage, DDA, saving, money market, debit card etc) from EIP and other source systems by transforming as per functional specs and loading into Integrated Customer Data Mart which will provide a complete view of the customers.

Logical and physical Data modeling for Staging area using MS – VISIO, Developed Visio diagrams for ETL Architecture and design

Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives

End to end ETL solution starting from source system analysis to data load in datamarts

Presenting proposed ETL solution to the management and Stakeholders

Developed SQL queries and PLSQL blocks for the complex business requirements

Provided ETL Estimates and Impact analysis estimates

Done Impact analysis for Identified Changes, finding risk and ETL cost associated with the changes

Lead, Handled, managed and cross trained team of 15 resources located onsite and offshore with 7 active projects at a time

Design ETL mappings to load data warehouse and data extraction from various source systems.

ETL estimates and assistance in project planning. Tracking and monitoring ETL status to ensure timelines

Weekly development status reports, daily hand off meetings with offshore, project stand up meetings

Attend and Facilitate checkpoint / status meetings. Onsite coordination and offshore leverage

PNC Bank, Cleveland, OH Aug 2009 to June 2010

Developed source to target mapping documents

High level and Detailed ETL Design specifications documentation

Develop ETL mappings to load EIP data warehouse and data extraction from various source systems viz. WNS, WMDB and ODS.

Design and develop data maps using power exchange

Performed tuning and optimization of complex SQL queries using ORACLE Explain plan.

Defect analysis and resolution

Developed Unix Shell scripts.Developed SQL scripts and PLSQL – cursors, triggers and stored procedures

Created Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in ORACLE.

Unit test case preparation & unit testing, Offshore leverage to reduce project cost of utilizing offshore strength to the max

Facilitate and attend checkpoint / status meetings with other development teams and project managers

Monitoring and controlling the progress of work

Sr. ETL module lead, National City Cooperation (PNC Bank), Pune India Mar 2008 to Aug 2009

Code migration from Version 7 to Version 8, Backup and restore of shared objects

code documentation for complex implementations and upgrades

Preparing detailed design specifications. Unit testing & Debugging, Health-Checks after every release.

Defect assignment in QC, Version management using Serena Change Man DS.

Design and development of ETL mappings. Source to target mapping documentation

Change data control / slowly changing dimensions mapping development.

Defect tracking and creating Defect log.

ETL / PLSQL Developer, National City Cooperation (PNC Bank), Pune India Oct 2006 to Feb 2008

Requirement gathering and data modeling.Preparing detailed level design specifications.

Mapping Development, Unit testing & Debugging. Defect tracking and data fix using IBM-Rational.

Development of SQL scripts and PLSQL blocks for complex business logic

Job monitoring in informatica for performance, Resolving and Triaging the defects.

Code documentation, Unix Shell scripting.Version management using Serena Change Man DS.

SQL PLSQL Developer, IBM India Pvt. Ltd, Turin, Italy Apr 2006 to Oct 2006

PLSQL code Development as per detailed design spec, Unit Testing and validations, Defect resolutions

Code Optimization to improve performance to bring down execution time from 12 hours to 5 hours

Deployment in production environment

Developer Kinetic Engineering Limited, Pune India December 2003 - Feb 2006

SQL and PLSQL code Development, Unit Testing and validation. Code Optimization

Code Deployment and post implementation validation

Educational Credentials:

Master of Computer Science (M.C.S) with Distinction from Pune University in JULY 2004.

Bachelor of Computer Science (B.C.S) with Distinction from Pune University in JULY 2001.

Contact this candidate