DIVYA KATHURIA

*** ****** **** ** ********, OH ad2m31@r.postjobfree.com 614-***-****

SUMMARY

I am an IT consultant with 10+ years of experience in Fortune 50 companies. I bring expertise in Analytics, Business Intelligence and Data warehousing solutions, based on roles including project management, architecture and solution management. I am looking for assignments to leverage my strategic and technical skills to implement smart technology solutions.

Specialties: Agile Development, Data warehousing, Business Intelligence. Tableau, Teradata, Informatica, Oracle 10g, Oracle 9i, SQL, UNIX, and testing tool - Watir. Have functional knowledge on Life sciences, CRM, and Telecommunications domain.

SKILLS

IT Professional with 10+ years of diversified experience in architecting solutions in different aspects of software development and design.

Good understanding on OLTP and OLAP based data.

Ease in dealing with end users while working on KPIs, Requirements and detail designs.

Experience in Design and Development of Tableau Dashboards, Data Warehouse, and Business Intelligence applications.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Strengths include excellent communication, client interaction, interpersonal skills and problem-solving capabilities.

Experience in handling huge databases with millions of rows refresh methodologies

Expertise in implementing business logic in Teradata using Views, Materialized views.

Experience in UNIX/Linux shell scripting for job scheduling in Autosys/Informatica.

Outstanding abilities in improving all aspects of development lifecycle, - including coding, testing, debugging and final rollout.

Analysis, Designing, developing, testing and implementation of BI dashboards, Operational Data Store/ Data Warehouse/ Data Mart), and support/maintenance.

EXPERIENCE

Full Time Parent May 2018 - current

Had the opportunity to spend more time with my kid.

Completed online training in Tableau from Edureka, and Business Analysis from Udemy and LinkedIn learning.

Fitrax, Columbus, OH Dec 2015 – Dec 2016

Data Consultant

Collaborate with Business users to understand KPIs and High & Low Requirement Documents, develop data mappings and detailed design documents.

Supporting User Acceptance Testing and validating the generated Tableau reports in collaboration with Business Users.

Accenture, Westminster, CO and Collegeville, PA November 2010 – December 2015

Project Leader

Led a team of four software engineers to achieve success in design, development and deployment activities, delivering annual cost savings of $29M for one of the world's largest global pharmaceutical companies.

Prepared cost analysis to determine financial feasibility of a project. Gather requirements from clients and implementing the Operational Data Store.

Led onshore and offshore team of developers to implement business requirements and ensured successful implementation of projects in production within the schedule and budget as proposed to the clients.

Suggested, developed, and automated the analysis reports that measure Marketing Effectiveness Threshold and Significant Loss Threshold. This enabled the users to automate the adhoc reports, which were previously created/ maintained manually.

Prepared adaptors that change the format for the data coming from the upstream to the PCIA application to conform to the industry standards.

Infogain, Noida, India [HQ: Sunnyvale, CA] January 2005 to July 2010

Associate Consultant

Responsible for design, creation and maintenance of database objects for Data Warehouse projects.

Extensively worked on ETL tool to extract data from various sources, including relational sources and messaging systems such as Oracle, Teradata, and Flat Files.

Worked on Performance tuning of sources, targets, mappings and sessions using Informatica

TECHNICAL SKILLS

RDBMS : Teradata 12, TD13, TDM, Oracle 10/11 g

Business Intelligence : Tableau 8.3

Programming : SQL, MySQL, PL/SQL, UNIX Shell

DB Tools : Teradata SQL Assistant, TOAD 8.0, BTEQ, SQL*Plus, SQL

Loader, BTEQ, SQL Server

Tools : Informatica Power Center 8.x, 9.x

Scripting Languages : Shell Scripting, Ruby

Hardware/OS : Windows, Linux, HP-UX.

Scheduling Tools : Autosys, Informatica Scheduler

EDUCATION

Master of Computer Application, Punjab University, India July 2006

Contact this candidate