Seattle, Washington, United States
Analytics professional with over a decade of experience across data spectrum - data engineering to business analytics - passionate to architect standardized, optimized and automated data frameworks to provide centralized and actionable data insights to cross-functional teams to improve processes and drive decisions • Techno-functional product owner and SME for data platform working in liaison with cross functional teams • Strategize and groom user stories Scaled Agile Framework (SAFe) based on collective organizational goals • Hands on experience in end to end software development life cycle (SDLC) • Ability to wear multiple hats - PO, developer, analyst, architect - and provide efficient and quick business solutions (tactical and strategic) • Collaborate with data stewards and data governance teams towards data quality control and monitoring • Proven track record - consistently exceeded expectations throughout career across different roles Expertise: Tactical and Strategic planning, Process Automation, Monitoring and Control, Cross functional collaboration Technical Skills: Azure Coud - SQL, ADFv2, ADLS, Blob, Cosmos NoSQL, PostgreSQL, MS SSIS/SSRS, Python, Hadoop Hive, AWS S3/Redshift, Presto Data Visualization - Tableau 10.0, Domo, PowerBI Statistical Modelling: Exploratory data analysis, Hypothesis testing, Regression, Multivariate, Time Series, Forecasting, Data Mining
- Own the roadmap of analytics platform, a go to tool for the CO+I leasing team - Create product requirements document for contract management tool to facilitate transparent and workflow driven contract management
• Techno-functional product owner and SME for data platform working in liaison with cross functional teams • Own the roadmap for the data and analytics platform • Strategize and groom stories with Agile SAFe model based on collective organizational goals • Work closely with Head of Data science and cross functional teams, and lead the PI planning and Sprint planning sessions of the Data work stream
- Optimized daily data ingestion process and improved the daily data load success rate in the analytics platform through controls and monitoring - Eliminated dependencies between different data sources through data reconciliation and updates - Stabilized downstream processes such as Policy fulfillment, payment retry, KPI process, and reporting to external partners - Advocated and implemented customizable, configurable, and automated data anonymization of PII/PHI data in Azure SQL
- Lead analytics project and mentored/trained analysts on DOMO, a business cloud ETL/Visualization tool built on AWS Redshift using PostgreSQL - Consolidate data from various sources such as in-house website/mobile app, web tracking platforms such as Google Analytics, AdWords, and social networking applications such as Facebook, Instagram, Twitter, Snapchat etc - Build visualizations in DOMO to draw insights on the marketing campaign reach based on various metrics such as impressions, conversions, demography, device, installs etc. - Build visualizations for the marketing team to evaluate the reach of the campaigns - Implemented from-scratch, automated, end-to-end deployment of the Analytics project in Programming Research team and integrated huge volume of TV Rating data (~70M rows) from Nielsen - Built visualizations, drill-down charts and reports in DOMO and collaborated with the analytics team to draw insights on audience viewership of TV programs based on the multivariate analysis and trends - Drafted documents on technical implementation, data governance and tracking, and risk handling (identification/ monitoring /mitigation) Value Ads: - Implemented automated quality check process in DOMO to reconcile the data between 2 different interfaces (NNTV and NPower) from Nielsen and trigger alerts to recipients on any discrepancy - Built scheduled data back-up (Quarterly, half-yearly, yearly) and purge process to secure the data - Optimization of data integration (~200%) : --> Replaced Magic ETL (point and drag) transform with more efficient Redshift PostgreSQL transform --> Developed Excel VBA tool to consolidate multiple excel files in a directory into a single excel file to reduce turnaround
- Led a technical team and implemented solutions to handle high volume, sensitive C3 financial data from multiple systems to provide analytical solutions to client - Collaborated with financial officers in providing data analysis by leveraging capabilities of relational database and BI tools - Led Agile ceremonies as a Scrum Master, and refined operational processes and delivery efficiency through continuous delivery - Drove the planning and estimation of project tasks with Paris counterparts, synchronous with the client’s expectations
Client: Societe Generale Bank, Paris, France - Techno-functional resource with ability to translate the data behavior functionally to the global banking clients - Took control of all aspects of project development cycle viz., requirement gathering, development, release and tech support - Built intelligent automated systems that increased the data availability to end users and senior executives via enriched reports - Instrumental in transferring the ownership of the application by winning the trust of the Paris counterparts - Led a re-engineering sub-project to decommission a legacy Access Database Tool by upgrading to relational database and BI tools which increased operational efficiency by 30%, reducing user dependency and mitigating operational risk