Data Analytics Consultant Resume

TECHNICAL SKILLS

Database/Data Management Tools: SQL Server, Teradata SQL, Erwin Data modeler, Alation

Data Visualization and BI Tools: Tableau

PROFESSIONAL EXPERIENCE

Confidential

Data Analytics Consultant

Responsibilities:

Involved in testing, debugging and maintaining of thousands of lines of codes written in Teradata SQL.
Experienced in prepping large volumes of cluttered, incomplete POS transaction data, and Channel Engagement data by evaluating existing data, identifying missing fields, and making code corrections wherever necessary; all with the end goal of providing data quality, accuracy and usability.
Worked closely with business partners which resulted in retail pricing team able to accurately tag vendors and their products with appropriate billing codes
Action resulted in material business impact by identifying several weeks of understated company default vs its actuals.
Helped resolve a recurring issue with retrospective report pull, by modifying existing ETL code to use stored procedures.
Independently lead and resolved a data quality problem that involved duplication caused by same data flowing into Teradata data lake from multiple source systems.
Experienced in taking abstract reporting requirements from business partners, analysts and other non - technical audience and converting them into a usable end product.
Gathered requirements were documented and translated to visual drafts that would later become usable Tableau dashboards.
Wrote SQL ETL codes from scratch to build data models that support Tableau dashboards. These were used by senior executives, category managers, and other business partners.
Built self-service dashboard for the business, that helped them understand customer behavior, and how to target their personalized marketing campaigns to promote customer loyalty and increase revenue.
Followed data modelling best practices with focus on optimal storage consumption; ran fortnightly reports to recycle/purge unused tables.
Automated ETL Testing using Stored Procedure; writing a cursor to compare source and target data’s count, accuracy and elimination of any data redundancy.

Confidential

SQL Developer

Responsibilities:

Built data model on top of many years’ worth of audit and application logs to understand end user behavior such as logins, logouts, clicks, keyword, department functions, with the objective of finding how the knowledge worker is benefitting from utilizing the software.
Developed a data model that will take invoice, expense, billing and payment data from staging table to a final table that would later on be used as the go-to ADHOC analytics database.
Proposed and implemented SQL Server In-Memory OLTP feature for faster data processing.

IT Consultant

Confidential

Responsibilities:

Independently performed a complete upgrade of the business’s offshore IT facility and acted as a single point of contact for all IT needs.
Acted as a liaison between technical resources on-shore management and clients off-shore.
Lead a team of data quality analysts and developers, consistently identifying errors in data capture before they reached the customer.
Worked as a travel and work on site consultant for small businesses helping them resolve data capture issues.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship