SUMMARY

• More than 3+ years of progressive experience in Data Analysis, Vendor Management, Data Management, Production Support and Business Intelligence in Banking, Pharmaceuticals, Travel & Leisure, Retail and Healthcare
• Experienced with Word, PowerPoint, Access; Experience with BI tools such as Tableau, Domo, and Cognos.
• Strong expertise on SQL; extracted, manipulated and retrieved data from relational databases with SQL; Adept in DW techniques and Data Management
• Solid understanding of Data Governance, Meta Data, Data Management and control; Adept in Data warehouse and Data mart architecture.
• Experience in Agile development methodology and User interface designing pertaining to Database related tools.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Solid understanding of writing user stories and acceptance criteria, authoring and executing detailed test plans and test cases.
• Strong background in data processing, data analysis with hands on experience in Excel, Access and Windows Servers in High - Availability environments.
• Proficient in creating UML diagrams such as Use Case Diagrams, Class Diagrams, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, State Diagrams, Deployment Diagrams and developed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
• Leading multiple Agile development projects in the capacity of SCRUM master/Agile coach
• Well-versed knowledge on SQL scripts on various Relational Databases.
• Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snow flaking etc. Worked with Star Schema, Data Models, E-R diagrams and Physical data Models.
• Worked on Tableau and created ad hoc reports and dashboards.
• Comprehensive knowledge of software development methodologies such as Waterfall, RAD, RUP andAGILESCRUM.
• Worked through the different stages of the software development life cycle such as Requirements Gathering, Analysis, Design and Functional Testing.
• Effectively facilitated Joint Application Development (JAD) sessions to gather requirements and to resolve conflicts.
• Experienced in data analysis, data migration and data modeling activities.
• Experience in Data Analysis, Data Modeling, Data cleansing, preparation of scenario based data and clarification of requirements with SME (Subject Matter Expert).
• Advanced level Oracle SQL skills with the ability to validate data model functionality and performance using SQL optimizing methods i.e. Running Explain plan etc.
• Proficient in Oracle PL/SQL skills with packages, procedures and triggers.
• Implemented data cleanup transformations, scripts and testing scenarios to unit and system test the deliverable.
• Defining, executing and delivering the analytical solution to business problems by implementing predictive models and statistical analysis using Python, providing strategies, recommendations and preparing final presentations.
• Hands on working knowledge in Base and Advance analytics of Importing and exporting data, Data Scrubbing, Handling and Manipulation.
• Working knowledge of data exploratory functions like table, levels, summary etc.
• Provided thought leadership regarding Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into transactional systems and data marts.
• Experience in managing large amounts of data in multiple formats from disparate sources.

TECHNICAL SKILLS

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data Integration and Migration, ETL Architecture and Design, Data Warehouse, OLTP, OLAP.

Databases: MS SQL Server, Oracle, Teradata, MS Access.

ETL Tools: Talend

Programming Languages: SQL, PL/SQL, Python (numpy, pandas, scikit-learn), VBA, SAS, SPSS, C#, HTML, CSS, C, PL/1, VBScript

Operating Systems: Windows

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake City, UT

Data Analyst

Responsibilities:

• Led business intelligence and data analytics workstream for 10+ SMB and consumer loan portfolios: launched end to end business reporting integration for 5 new partners in Q1 2022
• Used Python for extraction, cleaning and analyzing the data
• Automated 12 monthly asset quality and risk assessment reports; provided insights to executive leadership driving key business decisions
• Built Tableau dashboards for tracking credit performance and origination characteristics across consumer, SMB, and commercial portfolios

Confidential, Chesterfield, MO

Data Analyst/Database Developer

Responsibilities:

• Created SQL scripts indexes along with complex queries for data analysis thereby reducing query run-time by 60%
• Built predictive model for crop prediction analysis using N-P-K, temperature, humidity, rainfall, and pH value parameters to recommend appropriate crops and maximize agricultural yield
• Involved in Developing SAS macros for data cleaning, reporting and to support routing processing.
• Published and maintained critical weekly business review tableau dashboards and provided key KPIs to a team of 50+ mechanical designers

Confidential, Parsippany, NJ

Analyst Decision Technology II

Responsibilities:

• Built and automated forecast model for Avis and its subsidiaries (Budget and Payless) that helped business to estimate the impact of public holidays and natural calamities on everyday rentals
• Developed complex SQL queries for extracting and visualizing data from revenue management and fleet systems for end user analysis
• Preparing standard reports, charts, graphs, and tables from a structured data source by querying data repositories using Python and SQL.
• Wrote scripts to automate time-consuming manual tasks to help streamline end user business process by 50%.
• Worked with business users and operations in developing KPI’s that aid in renting cars everyday across all locations in US and Canada thereby helping the company to generate incremental revenue of $55 million USD.

Confidential, St. Louis, MO

Business Intelligence Intern

Responsibilities:

• Created the Clarity dashboard for senior management that displayed the projected vs the actual number of hours worked by each employee in the Business Intelligence team, thus providing better clarity to the senior managers during work allocation.
• Worked directly with physicians, data architects, business analyst and internal team members to understand reporting requirements, identified various KPIs and designed solutions to enhance business decision-making.

Confidential, St. Louis, MO

Programmer Trainee Intern

Responsibilities:

• Analyzed the effectiveness of the new JDA supply chain tool to place orders and achieve balanced inventory in the stores.
• Identified and analyzed key metrics on store and warehouse level to gauge the performance of JDA tool.
• Created dashboards based on dataset loaded to DOMO.
• Coordinated with business units to provide data driven analytics in the form of ad hoc analyses, reports.