Sonali Pal
Princeton Junction,NJ
Summary
Motivated and results-driven Engineer with a proven track record in data analytics and process mapping. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency. Seeking an opportunity to drive business effectiveness through making recommendations based on data findings.
Meticulous Analytics Engineer eager to provide holistic data acquisition and management services. Leverages novel techniques and technologies to squeeze maximum value from owned and acquired assets. Dedicated to exceeding business goals through careful exploitation of all available resources.
Overview
20
20
years of professional experience
Work History
Sr. Data & Analytics Engineer
Altice USA
04.2020 - Current
- Design and implement a data warehouse platform in BigQuery (Google Cloud Platform) to facilitate various business groups for data driven decision making
- To develop data pipelines to source data from various sources, using Python, SQL, Composer, Airflow
- To design and develop long term Data-warehouse solutions involving TeraBytes of data and complex business rules
- Design and development in migrating existing DW solutions from Oracle to BQ platform
- Maintenance and Enhancements of legacy DW solution on Oracle platform using sql, pl/sql and unix scripting
- To perform continuous analysis and provide insights to the users on various aspects like customers, products, call-centers activities, marketing and campaigns
- Continuous efforts on process improvements - design and implement modularized and reusable codes/process
Business Intelligence Lead
Depository Trust & Clearing Corporation
04.2019 - 04.2020
- Design and implement a data analytics platform to provide business users and IT management leads with various reports and dashboards on overall IT cost and expense for (Bill of IT)
- To provide a platform to enable the business and IT leads to unify their developments into a single portfolio as well as reports based on project objectives, costs and resources
- Data is collected from daily basis from HR system, Project management system and other finance teams and loaded in a Data warehouse (sql Server) through ETL (SSIS)
- Data from various systems are cleansed and integrated through pre-defined business rules
- Reports (Excel and Power BI) catering to various audiences, are refreshed after daily data loads
- To perform continuous analysis and provide insights to the users on their IT Demands and resource supply and expenses incurred
- Multiple KPIs are defined to compare actual cost incurred vs forecasted costs for the year vs approved budget
- KPIs defined to assess overall IT performance and risks and presented to IT Governance Committee
- Specific Power BI reports are created to enable data driven decision making for upcoming year’s IT budgeting
- Adhoc data analysis using SQL and Python data analysis modules
- Leading a team of 5+ across global locations
Business Intelligence Developer
Goldman Sachs
01.2017 - 03.2019
- Design and implement three stages of the framework - Data Onboarding, Data Quality analysis and Data visualization through series of complex sqls and Dashboard development in Tableau /spotfire
- Participated in requirements meetings and data mapping sessions to understand business needs
- Understand and analyze the source data, mapping to the audit requirements, also to calculate various KPIs(Key Performance Indicators) and KRIs (Key Risk Indicators) applying business logic
- Dealing with diverse upstream data sources - Datalake (HDFS), DB2, Sybase, Oracle, ElasticSearch, JSON payload through REST API
- Building Data analysis / Data transformation codes using various Python Data analysis modules (Pandas / numpy etc) and automation of the codes through proprietary ETL and scheduler tools
- Building Worksheets / Dashboards / Story, complex filters, runtime table functions, sets / groups in Tableau/Spotfire
- Develop complex sqls to join data from various upstream systems and populate de-normalized tables/ views for Dashboard
- To provide ad-hoc reports / Data sets in excel, need to represent data through Pivot, Graph or other visualizations
Regulatory Report Developer
Goldman Sachs
03.2015 - 12.2016
- Generating business reports in Tableau and OBIEE
- Understanding various Regulatory reporting requirements like Using AxiomSL and its components to fulfill regulatory requirements like FRY_9C, FRY_11, FR_2314 etc
- Monitoring, upgrading ETL logic to load data from upstream systems
- Creating or modifying AXIOM workflow to onboard data in AXIOM's DB (Oracle) and implement business logic and reporting the final aggregated values into the reports
- Scheduling jobs on Autosys, monitoring and resolving production issues
- Leading deployment of code in various environments (QA / Production) through SDLC
- Complete Axiom administration in UNIX environment
Market Connect Expansion- Lead Database Developer
Marsh & McLennan
11.2013 - 03.2015
- Participating in Database Design and architecting for the new Market Connect platform
- Coordinating with Application developers and Data management Architects to come up with performance efficient Database design and data governing policies
- Designing the Data migration plan from existing DB to the new one
- Migrating bulk data for Day Zero(0) through a combination of PL/SQL and Informatica code
- Designing and implementing ETL jobs in Informatica for Daily Data load
- Working closely with application developers and developing complex sqls and pl/sqls to support Database interactions from UI
- Producing daily/ weekly/ monthly progress reports
- Data quality monitoring and sanity checking in post-production environment
Lead Database Developer
BT Americas
12.2010 - 10.2013
- Understanding End-to-end Data flow and data integration rules Designing Staging, transformation and loading logic for ETLs as per Business requirement
- Writing Pl/sql blocks (Packages, procedures, functions) as per requirements
- Job involves Creating / Modifying Informatica ETL Jobs using all standard functionalities like Joins, Filters etc and calling PL/Sql blocks in workflows
- Needed to automate ETLs through Unix script and schedule it in Crontab in Unix (Solaris)
- Monitoring the performance in production and accordingly proposing upgrades/modifies in existing design like adding/deleting indexes in Tables, partitioning tables, replacing traditional extract logic with implementation of materialized views etc
- Regularly working on Various Data analysis requests and producing reports
- Writing complex sql (hierarchical etc) for the above data analysis to integrate data between Order-network-billing for various products
- Tuning of complex sql queries
- Providing various weekly and monthly reports Tools Used - Informatica, TOAD, Sql Developer Data modeler, .MS Visio , Business Objects XI R2, Clear Quest
DW Developer
British Telecom
01.2009 - 01.2010
- Requirement capture and analysis to build a new Data warehouse -to integrate and centralize Infonet Data
- Understanding the End-to-end Architecture of existing Infonet Business and each application and data correlation across systems
- Created multiple schemas in Development environment and produced final scripts for production schema building
- Developed data extract mechanism from source Databases - through materialized views
- Generated OWB 11.2 maps for establishing Relations among various Entities and thus designing the transformation and loading ETL logics
- Developed various Pl/sql blocks to re-create existing business reports from new DW
- Lead the overall delivery within a onshore-offshore model
Business Objects Report Developer
British Telecom
01.2008 - 01.2009
- Requirement capture and analysis of various reporting requirements like Monthly/Weekly SLA reports, various Usage and billing reports, Order details report etc
- Creating new BO Universes and maintaining and modifications of various Universes connected to Oracle 9i-10g, MySql databases
- Creating and scheduling reports in Crystal Reports 10
- Monitoring Business Objects XI R2 and Crystal Reports 10 in Windows Server 2003 Environment and maintaining Application Health throughout
Database Developer
British Telecom
01.2005 - 01.2007
- Wrote and maintained technical and functional specifications
- Creating PL/SQL blocks to update data across systems
- Interacting with system specialists to analyze the root-cause for mismatched data and deriving solution for bringing those in synch
- Providing daily/weekly reports to client to highlight cleansed circuits, revenue gaps etc
- Capturing requirements from client and communicating same to offshore team
Education
B.TECH - Electronics and Communication
Netaji Subhash Engineering College
06.2005
Skills
- GCP
- BQ
- GCS
- COMPOSER
- AIRFLOW
- SQL
- PL/SQL
- Python
- Tableau 10
- Power BI
- BO XI R2
- Spotfire
- AXIOMSL
- SSIS
- OWB
- Informatica Powercenter
- Microsoft Sql Server
- Oracle
- Sybase
- DB2
- Shell
- Agile Methodologies
- Visio
- PuTTy
- JIRA
- SVN
- Excel
- Powerpoint
- Sharepoint
Timeline
Sr. Data & Analytics Engineer
Altice USA
04.2020 - Current
Business Intelligence Lead
Depository Trust & Clearing Corporation
04.2019 - 04.2020
Business Intelligence Developer
Goldman Sachs
01.2017 - 03.2019
Regulatory Report Developer
Goldman Sachs
03.2015 - 12.2016
Market Connect Expansion- Lead Database Developer
Marsh & McLennan
11.2013 - 03.2015
Lead Database Developer
BT Americas
12.2010 - 10.2013
DW Developer
British Telecom
01.2009 - 01.2010
Business Objects Report Developer
British Telecom
01.2008 - 01.2009
Database Developer
British Telecom
01.2005 - 01.2007
B.TECH - Electronics and Communication
Netaji Subhash Engineering College
Similar Profiles
Shaun ThompsonShaun Thompson
Sales Specialist at Altice USA (Optimum)Sales Specialist at Altice USA (Optimum)
Adeline TorresAdeline Torres
Sales Enablement Manager at Altice USASales Enablement Manager at Altice USA
Qasim HarrisQasim Harris
Business III Field Service Technician at Optimum/ Altice USABusiness III Field Service Technician at Optimum/ Altice USA