Washington DC-Baltimore Area
Result oriented data analyst with 7+ years of experience implementing Data warehousing and Business Intelligence Solutions. Independently motivated team player with a proven record of succeeding in high pressure and faced paced environments, in addition to improving efficiency and promoting process improvement. TECHNICAL SKILLS: Domain: Business Intelligence, Data Analytics, Data Warehousing, ETL, Agile, ITIL, Quality Management Systems. Core Skills: SQL, ETL, Data Visualization, Python Tools: SAS EG, SAS DI, Informatica, Risk Solver Platform, Adobe, Business Objects Databases: SAS, Teradata, SQL Server, DB2 Microsoft Office: MS Word, MS Excel, MS Power point, MS Visio, MS Access, MS Visual Studio. Operating Systems : Windows XP, Windows 7,8 , Unix.
• Managed team of four to drive customer requirements and develop ETL pipelines using SQL, Tableau and Alteryx for depletable asset transaction reports for large Financial Services client reducing manual effort by more than ~40% and saving the client close to $10MM over 2 years. • Collaborated with cross functional teams including product managers, data scientists and business analysts to engineer architecture for data transformation layer involving generation of common data model, data cleansing and curation of denormalized data warehouse to create standard inputs for all fraud machine learning models, thus improving standardization by ~50% and market readiness by ~25%. • Oversaw the strategy and commercialization for PwC’s Fraud Analytics Products including managing relations with third party solution vendors, project plans, budgets and roadmaps for future releases and go to market. • Directed product lifecycle for Fraud Graph Data Analytics tool including driving product vision, market research, use case prioritization, prototype development, commercialization and user training plan. • Designed BI roadmap for implementation of B2B Commerce Fraud Detection for large Healthcare Provider including identification and resolution of critical data quality issues and simplifying data enrichment processes to increase efficiency by 65% and save more than 1000 hours of manual review to identify fraudulent transactions and accounts.
Ashish Chandwani is a Senior Consultant with the IBM Global Business Services in a variety of roles including Business Analyst, Data Analyst, Technical Lead, Database Analyst and working on IBM technologies like Datastage and Netezza. Project 1 : ETL Consultant " Designed dimensional data warehouse using star schema for Patient, Diagnosis and Encounters subject areas based on IBM Unified Data Model for HealthCare for Thomas Jefferson University Hospital in Philadelphia, PA. " Developed IBM Datastage ETL jobs between Clarity(Epic) DB, Data Staging Area and DataMart for implementation of Type1 and Type2 loads. " Formulated Source to Target mapping from existing Clarity(Epic) DB to DataMart using IBM Infosphere Fast Track Client. Project2: Data Warehouse Consultant: " Data warehouse development Lead for BIS Implementation at Blue Shield of California. " ETL development on IBM Netezza using SQL and Unix. " Source to target mapping between the existing ODS and designing transformation logic for the Datamart and assisted in Data Modeling using ERWIN. " Single point of contact for development progress for IBM Team and also responsible for mentoring junior developers. Project 3: Proposal Consultant: " Worked on Proposal and Strategy of a revamped Coca Cola IT Help Desk. " Coordinated with the various solution areas SME's including Watson, Salesforce and Interactive experience to get the pricing numbers and implementation information for implementing this proposed new help desk. " Developed pricing model to incorporate all these numbers to shows year by year projected costs. " Presented POV of existing knowledge to contribute in understanding the challenges to help each team develop their numbers. Project 4: Business Analyst " Working on Systems Configurations, Requirement Analysis and Testing of the Sterling OMS and Toshiba POS Implementation for Petco Animal Supplies.
1. Collating data from various client sources and performing data cleansing before loading into comprehensive Oracle database. 2. Collecting client requirements and communicating with product teams for development and testing of JDA Demand software. 3. Examining client data to perform data profiling for JDA Labs to develop pricing and inventory management algorithms.