•Dealing with new data pipeline consumed by accounting systems, processed to the centralized cloud-based data warehouse (Salesforce ncino), and pushed to downstream application ODS layers in Oracle and Enterprise Data warehouse Presentation Layers in Teradata.• Analyzing data flow from ultimate source systems to the final presentation reporting views, business requirements, creating functional and technical specifications, maintaining data integrity and quality to reduce costs and time• Implementing change data capture and slowly changing dimensions (Type 1 & 2) for load strategy and automating the processes /reconciliation reporting by developing reusable codes, integrating the platform system• Building star and snowflake schema, dimensional data modeling, fact, and dimensional tables along with the expertise in writing complex SQL Queries to populate the required data• Creating Data Lineage Document and Data flow diagrams for data migration to datahub project for 11 different banking products like Lease, Loan, Credit Card, etc.• Designing, developing, and implementing ETL processes of EDW and Commercial Lending systems for initial loads, daily and monthly data load strategy, creating acceptance criteria-based Test cases using Gherkin code for data validations/testing• Developing UNIX Shell scripting for data feed files for making ready-to-be-processing as per system and scheduling jobs in CA7 and CA Automic and querying in and exporting data files from Salesforce ncino as part of ad-hoc processes/data cleanup activities for running data loaders in Salesforce.

• Conducted analytical support, competitive and market metrics, Key Business Insights, cause-effect relations, transactions on Oracle Opera Property Management System from historical sales data. Created pricing and cost saving strategies.• Developed 2 data-driven models with accuracy of 80% in R to forecast revenue and MS Excel (VLOOKUP, Conditional Formatting, Pivot Tables, Macros) to predict customer behavior for each season and control/manage inventory/supplies. • Leveraged dashboards and analytical reports on Tableau and Excel identifying return on investment, forecasted future sales, guest ratings, invoices, performance trends, seasonal events for the CEO to provide data driven decision making.• Transformed findings into 2 actionable business opportunities to support decision making and recommend potential business solutions by market trends analysis and BI reporting; increased profitability by $50,000, efficiency by 20%.• Consolidated daily reporting of brand mentions and reputation and analyzed feedback to prevent negative comments from customer on Tableau and Excel; improved customer experience score and social media rating by 1.5%.• Prepared Human Resource plan to include training and managing using objective accomplishment.

• Maintained University equipment check-in and check-out, Titan Card Validation websites on Visual Studio and SQL Server• Programmed on .NET Framework, C# and MVC as front-end and SQL to fetch and store database

• Established ETL Routines for data extraction and transformation on SSIS, for reporting data validation.• Devised unit test cases for PWC audit manager web app in .Net Framework (bootstrap and PL/SQL), C#, MVC. • Implemented SDLC, requirement analysis, process mapping, Agile software development processes, for developing app. • Articulated business requirement, adhered to SLAs, performed troubleshooting, ad hoc reporting, root cause analysis, server/security audits, system backup and recovery procedures by company’s disaster recovery strategies on MS Access. • Resolved CRM services related problems, requests, priority-wise incidents/tasks for user groups, clients on ServiceNow.• Managed 6-member group of new hires, ensured smooth training process and explained business policies and guidelines.Generic Training:• Python• Relational Database System- MySQL• Data Structures• Object-Oriented ProgrammingStream Training:• NET Framework• C#• ASP.NET using Web forms• MVC 5• Entity Framework• SQL Server Connections