Sanjana Kumar Email & Phone Number

Connecticut, United States

1. Enterprise Data Warehouse and BI Development:• Designed, developed, and deployed scalable EDW and BI applications.• Facilitated data and information exchanges between various source and target systems.2. Database Design and Modeling:• Designed and modeled databases, data marts, and cubes.3. Automation and Process Development:• Created and automated processes using AppWorx.• Developed functions, complex procedures, and views on MS SQL to process data.4. Testing:• Developed test cases and performed functional and regression testing.• Coordinated with QA and business teams to test code in UAT environment before production.5. ETL Operations:• Performed ETL operations and integrated data from multiple sources.• Worked on ETL processes and mappings to build a data warehouse.6. Business Intelligence and Data Visualization:• Developed visuals using Power BI for management decision-making.• Identified and resolved variances in reports by fixing issues at the source.7. Performance Optimization:• Optimized the efficiency and quality of SSIS packages and SQL procedures, resulting in a 25% performance improvement.8. Data Quality and Governance:• Ensured data quality and data integrity in compliance with data governance standards.• Gathered and documented requirements for the EDW and web applications related to healthcare.9. Agile Development:• Worked closely with the Business team to encapsulate evolving requirements in an Agile environment.10. Ad-Hoc Analysis and Feasibility Study:• Conducted ad-hoc analysis for custom reporting.• Conducted a feasibility study to integrate Azure Data Factory components into the product.

East Brunswick, New Jersey

Alert Testing of Non-Triggered Alerts:1. Validate Client Systems: Replicate alert rules not triggered by BSA/AML source systems to assess system robustness.2. Rule Creation: Responsible for creating rules for alert tracking systems based on conditional parameters provided by banks.3. Pattern Identification: Identify significant cases, red flags, and patterns associated with the laundering of illicit funds.4. Root Cause Analysis: Perform root cause analysis for triggered alerts, analyzing reasons monitoring systems may have missed alerts.5. Stored Procedures: Develop and execute stored procedures against transactional data to perform iterative tests, eliminating false positives.Risk Assessment and ETL Reporting:1. Report Development: Develop reports assessing Customer risk, Geographic risk, and Products-Services risk.2. Risk Mitigation: Perform Risk Assessment, Data Validation, and Governance to help clients minimize risk and adhere to OFAC standards.3. KPI Definition: Define Key Performance Indicators (KPIs) like 'Cash Intensive Business' and 'Transaction Amount' to understand customer population and risk.4. Visualization Dashboards: Develop Tableau dashboards for stakeholders to identify population trends and key business insights.5. Automation: Develop stored procedures and macros automating report generation, improving processing time by 96%.6. KPI Review: Review and analyze KPIs for AML/BSA/OFAC compliance, identifying areas of potential risks or non-compliance.BSA System Validation:1. System Validation: Validate client systems and rule sets by querying transactional data up to 12 million records.2. Data Modeling: Define data modeling processes and manage ETL to incorporate client data into Governance, Risk, and Compliance (GRC) systems for analysis and reporting.3. Root Cause Analysis: Perform root cause analysis to identify data issues and adhere to best practices and applicable local, state, and federal regulations.

Rutherford, Nj

1. Restaurant Partnership Analysis:• Analyzed data from primary and secondary sources to identify the best restaurants for partnerships.• Utilized trend analysis to make informed decisions on restaurant collaborations.2. Demand Forecasting:• Performed demand forecasting to estimate the number of orders per week.• Determined the required delivery personnel for different locations based on demand analysis.3. Gender-Specific Taste Analysis:• Conducted analysis to identify gender-specific tastes for take-out orders.• This analysis contributed to an 18% increase in sales, indicating a targeted and effective marketing strategy.4. Tableau Dashboard Development:• Developed Tableau dashboards to visualize trends and provide recommendations.• The insights from these dashboards contributed to a 30% increase in the number of users.5. Translation of Requirements:• Translated business requirements to the development team.• Provided recommendations to ensure an optimum transition and operational stability for tracking vendors using Salesforce.

New Jersey

IMDB Movie Data Visualization on Tableau •Developed Tableau dashboard stories to derive trends and KPI for 5000 movies and performed data mining, data cleansing and ETL•Derived actionable insights pertaining to movie budgets, genres, popularity, revenue and duration•URL: https://public.tableau.com/profile/sanjanakumar#!/vizhome/FactorsaffectingBoxOffice/FactorsaffectingBoxOfficeUI Prototype of a Recommender System •Developed a prototype website that helped students make informed decisions related to university and course selection •Developed primary and secondary personas to highlight activity and analyze worst case scenarios •Performed requirement gathering and designed site process flow to include professor ratings, discussion forums and live chat •Used Agile methodology to develop the prototype application on AxureRP and developed documentation for the prototype•URL: https://yj7b56.axshare.com/#g=1&p=main_page (Works best using Google Chrome)Amazon Virtual Reality Scoping Project•Reengineered the business processes of Amazon by proposing virtual try feature, online chat systems and video reviews •Studied AS-IS processes related to challenges faced by customers and proposed TO-BE solutions to eradicate inefficiencies•Developed scoping diagrams to present a high-level overview and used MS Visio to create process flow representation of the system•Improved customer satisfaction related to sales for sunglasses, clothes, shoes and accessories by 65% and reduced returns by 40%

Master'S Degree, Information Science/Studies

Bachelor Of Engineering - Be, Information Technology