- Consult stakeholders, manage, design and implement scalable data models into cloud or on premise data marts or warehouses.- Design ELT jobs and staging for data automated data pipelines.- Use SDLC best practices for testing and documentation to ensure efficient data governance. - Develop KPI’s, business intelligence dashboards online with business processes.

- Data architecture, ETL/ELT pipelines, schema design/dimensional modeling.- Develop dashboards in Tableau, capturing KPI's and providing impactful business insights for decision making.- Created google analytics set up for various campaigns solutions to shape business strategy, use API’s and a data science analytical approach to solve problems and display them graphically with our custom web design. - Full stack web design to back end database & reporting solutions.- Engineered automated ELT process to transform raw data to presentation level in a data warehouse.-Lead stakeholder meetings and mentor more junior developers.

- Contribute to SBA overall data maturity within the org by developing automated business intelligence and key performance indicators for decision management.- Produce & maintain analytics/automated solutions for SBA paycheck protection program data during covid PPP lending windows.- Develop data pipelines, ETL/ELT, metrics and reporting solutions in Tableau server for automated solutions.- Developed risk process control solutions and remediation sizing using Python via disparate data sources. - Create and maintain Tableau dashboards for SBA execs to monitor performance of programs and implement strategy around metrics.- Gather and document business requirements with stakeholders.- Additionally, use Jira, confluence and git for version control to adhere to Citi SDLC.

- Saved thousands in software licensing/legal fees by designing a data migration to Hadoop and reverse engineering the software system with Spark/SQL allowing non tech users an easy path to data. - Optimized and designed Hadoop/Hive data directories and tables for fast query processing. - Contributed to analysis and UAT. - Develop automated risk controls and metrics for Citi Mortgage control groups to ensure regulatory compliance and control accountability where regulatory audits are not automated. - Additional: data analysis for remediation's to identify populations and for regulatory mortgage requests.

- Used an analytic approach to identify financially harmed customers within WFHM remediation team by collaborating with various LOB team members to gather and document business requirements, design the analytic approach documents for story telling of the data mining and research, root cause analysis, project management within the data phase, - Create/design SQL/SAS queries to identify populations of financially harmed customers and present findings to remediation team for remediation execution of identified population.- Peer review code to assure quality of remediation strategy and alignment with business requirements.- Mentor junior consultants.

- Consult stakeholders, gather & document business requirements to develop KPI’s. - Completed analysis using descriptive or inferential statistical analysis ranging from Tableau reports to ad hoc analysis for deeper insights to business questions/problems. - Identify risk and automate future processes with Tableau via ELT process to RDBMS. - Contribute to UAT, schema and data design for consistently evolving data maturities.- Managed Private Mortgage Banking as a partner/stakeholder and completed all ad-hoc requests and projects for this LOB and contributed to other LOB's requests as well. Software used was Teradata SQL for data-mining, Tableau for visualizations, Excel for cube based OLAP and SAS for descriptive statistical analysis.

- Identify and quantify risk associated to borrowers based on credit request. - Create complex income spreads to identify debt to income ratios to mitigate risk. - Analyze credit, collateral, assets and characteristics of customers for credit approval. - Mentored junior underwriting associates.

Responsible for Retail consumer mortgage lending analysis which required a complete borrower risk mitigation which adheres to WFHM policy.

- Designed website and marketing solutions to improve business visibility.- Created an inventory tracking system and database solution for overall management solutions to drive revenue from business intelligence. - Developed key performance indicators giving a clear view of performance. - Designed and prepared weekly reports and analysis for business operations. - Analysis ranged from descriptive stats, sales trends to conversion analysis.