Technical Consultant Resume

SUMMARY

Experience designing and developing solutions for Data Analytics and Business Intelligence.
Experience managing and leading several Data projects and cross functional team of Data Analysts and Data Engineers.
SAS, Teradata, SQL - Server, Informatica, Hadoop, Hive, Tableau, SAS VA, Python, Spark and Linux.
Amazon, Google and Microsoft cloud services, develops, agile and data governance.

PROFESSIONAL EXPERIENCE

Technical Consultant

Confidential

Responsibilities:

Translate complex CRM and Profitability data into actionable metrics for incentives, client interactions and coaching.
Lead technical design and development of data integration layer and metric development for consumer datasets.
Build and implement complex data pipelines using Teradata, SAS, SQL-Server, Shell Scripts, NAS, DataStage, ThoughtSpot and Tableau.
Create data models, schema design, physical models, Indexes and query tuning in Teradata, SQL-Server and SAS.
Perform data analysis on big datasets (billion+ rows) in Teradata and provide recommendations to business/IT.
Reengineer business processes to increase efficiency and eliminate human interventions/errors.
Provide solutions on dashboards design, data driven security, and Tableau API automation using Python.
Prepare and present documents for data analysis findings, BSTM, ETL design, and IT production support.

Team Lead - Data Analytics

Confidential

Responsibilities:

Led design and development of mortgages and credit card DataMart to support reporting, analytics and campaigns.
Worked with team members to design user stories, schema design, physical models, data flows and UAT testing.
Built data flows involving several technologies such as SQL Server, DB2, HIVE, SAS, Python and Shell scripts.
Developed actionable reporting from large datasets and created high-value presentations for key stakeholders to support business objectives.
Built complex interactive dashboards, with row level security, LOD calculations, BAN, scatter plot, heat maps, etc.
Led a technical team to design and develop integration and consumer tables in Data lake for lending products.
Created roadmap and business memos for new Confidential projects and participating in POCs to test new technologies.