Data Analytics Business Intelligence
Resume:
April **** - Current
Sonali Pal
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.
WORK HISTORY
Sr. Data & Analytics Engineer
Altice USA, NJ
Business Intelligence Lead
Depository Trust & Clearing Corporation, NJ
Princeton Junction, NJ 08550
***********@*****.***
WWW: Bold Profile
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
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) SKILLS
GCP
BQ
GCS
COMPOSER
AIRFLOW
SQL
PL/SQL
Python
Tableau
Power BI
BO XI R2
Microsoft Sql Server
Oracle
UNIX
SVN
Excel
EDUCATION
B.TECH in Electronics and
Communication
Netaji Subhash Engineering College, Kolkata
June 2005
January 2017 - March
2019
March 2015 - December
2016
Business Intelligence Developer
Goldman Sachs, NY
Regulatory Report Developer
Goldman Sachs, NY
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
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 November 2013 - March
2015
December 2010 -
October 2013
Market Connect Expansion- Lead Database
Developer
Marsh & McLennan, NJ
Lead Database Developer
BT Americas, NJ
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
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
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 January 2009 - January
2010
January 2008 - January
2009
DW Developer
British Telecom, INDIA
Business Objects Report Developer
British Telecom, UK
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
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 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 January 2005 - January
2007
Database Developer
British Telecom, India / UK
Monitoring Business Objects XI R2 and Crystal Reports 10 in Windows Server 2003 Environment and maintaining Application Health throughout
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
Contact this candidate