Ashoke Kumar Sati
Brampton,ON
Summary
Dedicated and analytical Data Engineer, Scientist, and Architect with 15+ years of experience in data analysis, warehousing strategic planning, and quality assurance. Proficient in policy and procedure compliance to establish new data standards, mitigate risks, and enable ease of reporting. Experienced in database optimization, data migration, and problem solving to maximize data retrieval speed, transfer data sets, and meet business objectives.
Overview
25
25
years of professional experience
1
1
Certification
Work History
Data Scientist and Architect
Canadian Securities Administrator
11.2019 - Current
- Created Data Models for Source and Target Systems using Erwin for supporting data lineage, analysis, and standards.
- Established new data standard for exchange of broker data to enhance data quality.
- Build Complex ETL pipelines using Azure Data Factory for transferring of files to establish data repositories.
- As member of Data Governance Group, created Data Upkeep Process
- Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets
- Used data profiling to assess accuracy and effectiveness of new and existing data sources. to enable monitoring of data quality.
- Created Target and Future State Data Flows and Process using EA Sparx for establishing data platform roadmap.
- Designed Storage Architecture Solution using Azure for performant and cost effective data archival/retrieval.
- Built Power Shell scripts for transfer and storage of files to enable scheduled data ingestion on a daily basis.
- Administrator for CSA Azure Environment.
Data Analyst
Tarion
01.2005 - 11.2019
- Designed and developed Data Warehouse and Data Marts in a timely manner using Informatica 9.0 with SQL Server as backend to facilitate company-wide reporting
- Automated data mart validations to maintain integrity of reported data
- Collaborated with business-unit leaders to identify and prioritize problems
- Utilized data visualization tools to effectively communicate business insights
- Researched and resolved issues regarding integrity of data flow into databases
- Designed and developed complex Business Object reports and Universe using SAP BI for corporate reporting and decision-making purposes
- Successfully tuned and reduced Informatica job run-times from 12 hours to 6 hours
- Produced provincial and builder reports on major issues faced by homeowners using IBM SPSS Text Analytics through analyzing 5 years of data
- Implemented a predictive model on warranty form submissions using IBM SPSS in order to increase homeowner satisfaction
- Administrator for maintaining Informatica, Oracle Field Service Cloud and IBM Ibase applications.
Senior Systems Analyst
Accenture
11.2004 - 11.2005
- Providing Informatica subject matter expertise assistance to Accenture and CIBC resources in order to efficiently process and store data as part of Basel Project
- Designed error handling, status capturing, keying approach, and overall loading of ODS to meet Basel requirements and enable ease of reporting and decision-making
- Assisted with application and performance tuning to reduce Informatica job run-times
- Supported system and user acceptance testing.
Consultant
Telus
05.2004 - 10.2004
- Developed Informatica mappings and workflows to populate data marts for Voice IVR data
- Developed Unix scripts for both historical and daily loads to run process for loading data into Data mart for IVR
- Mentored programmers on Informatica and SQL
- Automated and documented batch process using Control-M.
Programmer Analyst
Canada Life
05.2002 - 04.2004
- Worked collaboratively with operational departments, system architects, third party vendors, project managers, and partner areas to gather requirements and analyze data
- Developed data requirements, source to target data mapping, transformation rules and summarization strategies for efficiently populating data warehouse
- Created front-end for screens using ASP and VB Based COM components to meet business requirements
- Created JCL's, Unix scripts, and COBOL programs for jobs and organized them in Mainframe scheduler to facilitate various company applications.
System Analyst
ACS International Resources
05.1999 - 05.2002
- Gathered requirements, system specifications, and documentation to build various web/B2B sites and intranet
- Tested and built several data-aware ASP/XML and Oracle applications to maintain intranet
- Built applications and COM components in C++ and Visual Basic to develop and maintain intranets for SLWK
- Created several stored procedures (PL/SQL), views, and implemented major database changes (Oracle/ SQL Server) to bring about increased web site functionality
- Made extensive changes to create portal functionality in site, which utilized XML and ASP to a large extent
- Developed comprehensive business analysis with cost, service, and benefit dimensions of proposed projects that are used at executive levels for funding and scope decisions
- Created an application for SLWK using Visual Basic 6 in order to retrieve information about the latest patents being issued from US, Japanese, and European Patent sites.
Education
Post Graduate Diploma - Management
IRMA - Anand
01.1992
Bachelor of Technology - I.T
B.H.U - Benares
01.1988
Skills
- Unix
- Windows
- MVS
- Python
- Power Shell
- SQL
- PL/SQL
- R
- Informatica
- Erwin
- ADF
- SAP Business Intelligence
- IBM SPSS
- IBM Ibase
- Control-M
- Orchestrator
- Oracle Field Service Cloud
- Azure
- KDB
- SQL Server
- Oracle
- DB2
- Access
Certification
- Azure Data Engineer (DP-203)
- Azure Data Fundamentals (DP-900)
- Azure Fundamentals (Az-900)
- Certified Designer (5, 6) – Informatica
- Certified Application Developer (Rel 2) – Oracle
- Certified Internet Application Developer – Oracle
- Certified Java Programmer – Sun
- Certified Azure Data Engineer
- Informatica Developer
Additional Information
- Data Science – John Hopkins (Coursera 6 months)
- Machine Learning – University of Washington (Coursera 6 months)
Personal Information
Title: Data Engineer, Scientist and Architect
Languages
English
Full Professional
Timeline
Data Scientist and Architect
Canadian Securities Administrator
11.2019 - Current
Data Analyst
Tarion
01.2005 - 11.2019
Senior Systems Analyst
Accenture
11.2004 - 11.2005
Consultant
Telus
05.2004 - 10.2004
Programmer Analyst
Canada Life
05.2002 - 04.2004
System Analyst
ACS International Resources
05.1999 - 05.2002
Post Graduate Diploma - Management
IRMA - Anand
Bachelor of Technology - I.T
B.H.U - Benares
Similar Profiles
Noel Nicholas DavidNoel Nicholas David
Sr. Risk Lead-ERM at Canadian Derivatives Clearing Corporation & Canadian Depository for SecuritiesSr. Risk Lead-ERM at Canadian Derivatives Clearing Corporation & Canadian Depository for Securities
Haripriya PrabhakaranHaripriya Prabhakaran
Application Developer at TMX Group(The Canadian Depository for Securities Limited)Application Developer at TMX Group(The Canadian Depository for Securities Limited)
ELDHO MATHAIELDHO MATHAI
Quality Assurance Analyst at Canadian Securities AdministratorsQuality Assurance Analyst at Canadian Securities Administrators
Upneet LubanaUpneet Lubana
Senior Fund Administrator, Hedge Funds at SS&C Technologies. IncSenior Fund Administrator, Hedge Funds at SS&C Technologies. Inc
Mayuri GourMayuri Gour
Integrated Solutions Documentation Engineer at KION GroupIntegrated Solutions Documentation Engineer at KION Group