Data Manager
Resume:
SANDEEP SINGAL, PMP
** ********* **, *******, **, M2H 2E8, CANADA
E-mail:******.*******@*****.***
Career Highlights:
Over 33 years of experience in IT Services including 11 years with Ontario Public Service ( OPS ).
Well versed with OPS gating and architectural checkpoint approval process and familiarity with Ontario Government policy and regulations including PIA (Privacy Impact Assessment), TRA ( Thread Risk Assessment) and GO-ITS standards
More than 15 years of enterprise architecture and data integration experience like Data Modeling, Data Science including Data Wrangling/data Migration from AS400 and other legacy systems/ETL using native and open source technologies like Talend, Trifacta, Statistica
More than 10 years of project management and development experience in various modernization projects to implement business process re-engineering using new technological solutions keeping in view key business objective.
More than 10 years of development and support experience related to fieldworker/inspection modules including sector knowledge and data integration.
A team player who have been involved in planning, coordinating and supervising complex projects with tight deadlines, involving development/deployment/support, define project requirements and design and apply new operating procedures
Manage relationship with client; interface and maintain communications with business management to understand line of business and deliverable needs. Monitor business and technology developments and provide on-time response.
Technologies Highlights:
Quite hands on with Unix/Oracle/PERL/Python/R/Java/Open Source products.
Knowledge and experience in enterprise data center or cloud environment including AWS and GCP.
Design & development for Big-Data centric solutions inclusive of data ingestion, decomposition, processing and provisioning steps. (Self-learning).
Hadoop centric big data dumping and transforming the data into HDFS.
Good at converting business strategies and requirements into algorithms and appropriate solution designs
Experience in working with open source and other 3rd party big data and data integration (talend).
Very strong skill in business requirement analysis, OOAD, agile and waterfall development and UML
Extensive Experience of Enterprise Application Integration (EAI) using TIBCO Technology and Components.
Strong working knowledge of XML and web services using WSDL, SOAP, UDDI
Extensive oracle development skills & experience in writing stored procedures, functions and database triggers using SQL and PL/SQL
Extensive Application Server/Web Server working experience with Weblogic 5.x, 6.x, Websphere 4.x/5.0, Tomcat, Jboss 3.0, Apache, IBM HTTP Server, Glassfish open source Server
Extensive IDE/Tools working skills on using Netbeans, Eclipse, Load Runner, XMLSpy, ClearCase, CVS, SVN, REMEDY, JIRA and Confluence.
Extensive experience in database development and maintenance with Oracle 8i/9i, IBM DB2 7.2, MS SQL Server 7.0 and Progress 7.0
Strong operating System experience using IBM AIX 4.3.X, Sun Solaris/Linux, Windows.
Good experience with Content Management Systems including FileNet, Stellent and open source solution using Alfresco.
Employment History: (In Reverse Chronological Order)
Organization : Community Services Cluster, Ontario Public Services
Duration : Nov 2015 – Till Date
Designation : Technical Manager (Team size 30 )
Environment : PERL, Talend, AS/400, SQLServer, Oracle, PowerBI, PowerDesigner
Project Détails
Nov 2019 – Till Date: Project technical advisor/migration-specialist for Ministry of Children, Community and Social Services (MCCSS) Serious Occurrence Reporting Guidelines, 2019. The project phase-1 includes Serious Occurrence Reporting and Residential Licensing (SOR-RL) online tool and complement existing MCCSS Serious Occurrence Reporting legislation and policy. This role includes data migration, sync, reporting, reconciliation and exception handling
Feb 2019 – Nov 2019 : Senior technical expert for Ministry of Health, Long-Term Care Rate Reduction (ERRISA) modernization project. This project is a provincially regulated program, publicly funded on a cost-shared basis with residents. Home operators submit requests for rate reduction to the Ministry on behalf of residents.
Jan 2016 – Feb 2019: Project senior technical advisor/expert for Ontario private career college (PARIS) modernization project. The project phase-1 includes Licensing registration application with one key integration and user base in/out of Ontario. This role includes data migration audit, reconciliation and exception handling
Mar 2015 – Dec 2015: Project senior data analyst for ‘Ministry of Education, Childcare Survey data migration’ which includes serious occurrence, enrollment, staff, training, serious occurrences at childcare and other foster home site. Oracle OBIEE was used as centralized data store for reporting, analytics and dashboards.
All above projects are small to mid-size projects and it involves:
Working with key stakeholders within all business functions to align technology solutions with business strategies. Existing process decomposition and identify and eliminate redundant business process.
Gathered requirements from business units and translates those to programmers and developers
Lead discussion on Business, Logical and physical Data Modelling using PowerDesigner.
Showcase dashboard, reporting capabilities of functional requirements to business using PowerBI.
Manage other key activities like Change Management including release management to review & administer change control procedure.
All the projects include Freedom of Information and Privacy Protection Act and GO–ITS standards.
Provided technical expertise related to field worker/inspection modules, in developing and executing solutions to business analyst, architects and developers.
Participate with Architecture review board for approval. Prepared technical solutions and architecture documents. Present artifacts and participate with Architecture review board for approval.
Lead discussion with architects, technical leads on requirements on sensitive data security including encryption requirements.
Data wrangling and data migration using native sql scripts and third party tool like Talend
Present weekly progress status to business on progressive path of project along with identified risk to approach and possible mitigation
Provide solution to relevant stakeholders and participate in data reconciliation activities. Provide data mapping and data conversion methods, data migration, data integration, business analysis for various businesses applications across large application
Promote data across various environment following project cycles including field worker integration for most of the projects.
Strong line of business customer relationship management, interpersonal and communication skill. Liaison with Architecture for business solutions, Business Analysts, Production Support and other system development teams to provide technical leadership and identify risks and provide the appropriate mitigation strategies.
Use mix of SDLC and agile software development lifecycle. Use agile software development lifecycle for most part.
Strong line of business customer relationship management, interpersonal and communication skill. Liaison with Architecture, Production Support and other development groups.
Schedule Management: Manage the projects under tight deadlines and perform self-directed activities
Lead discussion with architects, technical leads on requirements and system design and data security including encryption requirements.
Review project plan with stakeholder to identify and mitigate risks.
Lead Proof of Concept to develop the EAI Integration Framework using IBM WID, WPS.
Scope out business process with well defined use-Case covering core-requirements for implementation using WID and iLog JRules engine.
Liaison with IBM, Technical Architecture, production support, Operations for technical evaluation and decision making.
Lead Implementation of data synchronization process between Legacy and Java application.
Ability to interpret UML / Use-Case analysis and specifications
Strong interpersonal and communication skill. Liaison with business to understand system requirements and current pain points for clear understanding of business and deliverable needs.
Budget Management: Monitor project expenditure and provide reports to steering committee on monthly basis. Assisted in development of various business proposal bids.
Manage the projects under tight deadlines and perform self-directed activities
Knowledge of Ontario Government policy and regulations including PIA (Privacy Impact Assessment), TRA ( Thread Risk Assessment) and GO-ITS standards
Directing weekly project progress/review meeting with business.
Review tasks and timelines on integrated project plan using MS platform for Office, including VISIO and MS Project, Word, Excel, Outlook
Review various OPS standard project related checkpoint artifacts (including PIA, TRA) with architecture team.
Organization : Toronto-Dominion Bank
Duration : Apr 2015 – Oct 2015
Designation : Big Data Project Manager (Level-3) (Team size 15)
Environment : Hadoop (Cloudera), Linux, Oracle, DB2, AS/400, PGP, Change Data Capture
Project Détails
Watchlist : The Global Anti-Money Laundering (Global AML) department of Toronto-Dominion Bank Group (TD or TDBG) was tasked with developing the strategies and policies to effectively manage anti-money laundering compliance for TDBG. The project interface new feed to Watch list management system via Hadoop.
HR Data & Analytics: Oracle OBIEE was used as centralized data store for reporting, analytics and dashboards for multiple HR subject areas. Hadoop was used as middleware storage.
Internal Fraud Monitoring: This project enables fraud agents to identify potential internal fraudulent activity (by internal employees) for further investigation and ultimate remediation. This is accomplished through integration from multiple applications used throughout the NACCMS domain. Data feeds from each of these applications are analyzed for potential suspect transactions which are ultimately loaded into the reporting tool and presented to the Fraud agent to perform their daily tasks.
Project FOCUS : This project about in-house telemarking activities Hadoop is ingesting Web Call feed and extracting data for DCTS Data & Reporting
RISE : Part of Enterprise risk management, the purpose of the RISE Golden Source project is to bring data elements required to produce Tier 1 and Tier 2 Credit Risk reports for US Commercial, US Retail and EWIP (Enterprise (ERM), Wholesale, Investment Portfolio) businesses into the Dimensional Model of BLDM. Hadoop is used as middleware to receive the data from various source systems and extract feed to given to various data warehouse.
All above projects are large size projects and it involves:
Use mix of SDLC and agile software development lifecycle.
Strong line of business customer relationship management, interpersonal and communication skill. Liaison with Hadoop Architecture, Production Support and other development groups.
Budget Management: Monitor project expenditure and provide reports to senior management on weekly basis..
Schedule Management: Manage the projects under tight deadlines and perform self-directed activities
Lead discussion with architects, technical leads on requirements and system design and data security including encryption requirements.
Review project plan with stakeholder to identify and mitigate risks.
Organization : Ministry of Education/Minister of Training, Colleges & Universities
Duration : Aug 2009 – Mar 2015
Designation : Project Manager Level-3
Environment : Solaris, PERL, Talend, Stellent, Websphere, AS/400, Oracle, DB2, Middleware
Responsibilities
Dec 2013 – Mar 2015: Project data analyst for 'Ontario private career college’, ‘Ontario Archeology’ licensing registration and ‘OSAP’ data profiling, migration and reconciliation. (Team size 3)
Manipulating, cleansing & processing data using Excel, Oracle, Access, SQL, AS/400
Responsible for loading, extracting and validation of client data.
Liaising with business and 3rd party product vendors
Analyzing raw data, drawing conclusions & developing recommendations
Using open source tools and native SQL scripts for data ETL and Change Data Capture (CDC)
Reporting statistical findings as part of reconciliation
ETL automation using UNIX and 3rd party products using Change Data Capture (CDC)
Jun 2013 - Dec 2013: Project Manager for Ontario private career college licensing registration application with one key integration and user base in/out of Ontario. This role includes data migration audit, reconciliation and exception handling. (Team size 25)
Sep 2013 - Dec 2013: Provided Technical guidance to system analysts teams for legacy data profiling and migration of childcare licensing registration application with one key integration and user base in/out of Ontario institution. (Team size 3)
Jan 2013 - Sep 2013: Project Planning and implementation of electronic Confirmation of Enrollment Management application with one key integration and user base (1500+) spanning in/out of Ontario institution. (Team size 10)
Mar 2012 - Dec 2012: Project Planning and Implementation for Ontario Graduate Scholarship program related to application entry, application processing/adjurations and payment processing. (Team size 12)
Aug 2009 - Dec 2010: Project Planning and Implementation for Institution, Programs and Program Costs Management application for Student Loan processing program. (Team size 20)
Jan 2010 - Dec 2012 : Project Planning and implementation of Image Management application with one key integration and user base spanning across Ontario institution (Team size 10)
Conducted requirements-gathering interviews to interpret UML/Use-Case analysis and specifications and wrote a Requirements Specification, a Feature Matrix and an Executive Summary presentation for a Image Management system.
Designed and implemented extract, transform and load process for 20m documents.
Managed the design and implementation of UI controls and underlying business logic and database structure used by functionality of custom pages.
Open discussion with business to capture image application integration requirements with boundary applications related to Loans, Scholarships.
Proposed, designed, implemented and maintained utilities for the Production department.
Lead Proof of Concept to develop the EAI Integration Framework using IBM WID, WPS.
Scope out business process with well defined use-Case covering core-requirements for implementation using WID.
Liaison with IBM, Technical Architecture, production support, Operations for technical evaluation and decision making.
Lead Implementation of data synchronization process between Legacy and Java application.
All above projects are large size projects and it involves:
Use agile software development lifecycle for most part.
Ability to interpret UML / Use-Case analysis and specifications
Strong customer relationship management, interpersonal and communication skill. Liaison with Technical Architecture, Production Support and other development groups, and with Operations Users and Technology Management
Budget Management: Monitor project expenditure and provide reports to steering committee on monthly basis. Assisted in development of various business proposal bids.
Manage the projects under tight deadlines and perform self-directed activities
Knowledge of Ontario Government policy and regulations including TRA ( Thread Risk Assessment) and GO-ITS standards
Directing weekly project progress/review meeting with business.
Review tasks and timelines on integrated project plan using MS platform for Office, including VISIO and MS Project, Word, Excel, Outlook
Review various OPS standard project related checkpoint artifacts (including PIA, TRA) with architecture team.
Lead discussion with architects on physical data model and suggested changes for better control and consistency.
Participate on database object layout and suggest solution for consistent and secure database design.
Proactively engage business to coordinate complex data mapping/conversion towards application end to end testing.
For integrated testing of data synchronization, review test cases with lead tester and business.
Review project plan with lead developer, lead tester and discussed risks.
Knowledge transition : Document standard operating procedure for support team
Organization : Headstrong Inc. (www.headstrong.com)
Duration : Dec 2002 – Aug 2009
Headstrong, formerly known as James Martin & Company, is a global consultancy providing clients with value-based solutions across consulting, application outsourcing, product development and business process outsourcing.
Various Projects Undertaken At Headstrong:
Client : Bank of America/Merrill Lynch
Duration : Nov 2008 – Aug 2009
Project : Reference Data (Client and Product)
Designation : Technical Manager (Team size 15)
Environment : Java/J2EE, Tibco BW, SOA, MQ, JMS, iProcess, Quickrules, Unix, Oracle, Sybase
One user interface was developed for client on-boarding and product reference data management system (MDM) that orchestrates other service invocation and provides reference data to enterprise. The reengineering project objective is to provide decoupling between workflow, rule management from application logic and integrate with legacy applications besides achieving better performance scalability.
Responsibilities
Direct, manage and deliver large reference data application development, support, bug fixes and enhancements
Manage relationship with client; interface and maintain communications with business management. Monitor business and technology developments and provide on-time response.
Prepared best practices document, knowledge transfer to team members and strategy to expand the environment.
Team Management: Direct, motivate, develop and manage performance of the team.
Cost Management: Establish, monitor and adhere to budget. Responsible for preparation of realistic schedule with estimation using function point analysis.
TIBCO Practice Lead at Headstrong responsible for business solution management.
Lead experience in Architecture, Analysis, Design, Development, Deployment and Integration of web based and Client/Server application. Project Lead for developing web services over SOAP/HTTP for legacy application integration using JMS/MQ.
Integrated business process and workflow process using Tibco components. Developed work queue and work items related interface using GI and integrated in Microsoft Outlook.
All above activities involves regular interactions with:
End users and different interfacing teams, to understand the business requirements and successful project execution.
Stakeholders, to perform earned value analysis and review project performance through dashboards and project trackers.
Customer, as relationship manager and communication
Other key activities like, Change Management including review & administer change control procedure, Process Management including establishing documentation and procedural standards for the execution of various tasks under the project scope were also part of my responsibilities. Comprehensive middleware development framework was developed under my guidance covering development and performance guidelines using various performance testing tools.
Client : Lehman Brothers
Duration : Mar 2008 – Nov 2008
Project : Prime Service Technology Infrastructure and Operations Audit
Designation : Project Manager (Team size 6)
Environment : 50 Solaris, Linux Servers, 15 Sybase servers, Autosys, Tibco messaging Bus
Project goal was to identify and resolve technical discrepancies or process gaps in delivery of IT service to business. Team developed a score card and/or production statistic for each infrastructure asset showing status or gaps as compared to baseline checklist and conducted technology landscape due diligence.
Responsibilities
Plan; estimate the resources to determine the project cost. Accountable for successful completion of project end-to-end including scoping, staffing, budgeting, execution, monitoring and control.
Work closely with business/application owner across the globe to ensure their availability for proper collection of data.
Ensured availability of resources for operations management audit based on ITIL framework
Analyzed the correlation of data due to interdependency in multi-tiered application.
Prepare and presented audit report showing technical discrepancies or process gaps and recommendation on top issues with mitigation that need tightening for high impact.
Client : OmniCare
Duration : Jan 2008 – Aug 2008
Project : Claim2Work
Designation : Technical Consultant (Team size 8)
Environment : Tibco BW, web services, JMS, Tibco iProcess (Staffware), General Interface(GI)
The project’s primary goal is to create an enterprise level prescription claim issue handling system which can integrate well with legacy system. The application is developed using the Tibco iProcess workflow engine. The BW service layer interacts with various legacy pharmacy legacy enterprise applications and databases via jdbc and JMS connections. Canonical data model was used for message bus architecture.
Responsibilities
Providing leadership in preparing the TIBCO development framework standardizing logging, exception handling, and metrics collection.
Established application performance measurement framework involving various message payload and accepted latency in messages.
Lead various business processes (publishing claim, updating the claim status, resending the claim) using Tibco business works components.
Successfully overcome challenges of working in multi-vendor environment.
Provided leadership in hand over of logical design of the solution from an external vendor and completed quality assessment of the deliverables.
Technical lead responsible for the development of application involving SOAP web services
Successfully managed complex data conversion and message transformation while handling integration with legacy applications using JMS trigger.
Involved in planning test cases with Tibco BW and Tibco GI.
Managed integration of case between Tibco BW with Tibco iProcess workflow.
Client : Netsuite Inc.
Duration : May 2007 – Apr 2008
Project : ERP/CRM Implementation
Designation : Engagement Manager (4 teams with total size 40)
Environment : Java Scripting, Data Migration using SOAP Web Services
With thousands of customers globally, NetSuite, Inc. is the leading provider of integrated business application software (CRM/ERP/e-business application) for small and midsize businesses. Under this engagement, the project teams include
QA Automation: This team is responsible for testing automation of NetSuite ERP/CRM web application and Web Services. (Team size 7)
Product Implementation: This team is responsible for handling customization and implementation of NetSuite system at various NetSuite end customer base according to their business needs. (Team size 8)
Integration and scripting: Both these teams are responsible for customization and integration of NetSuite system and legacy application using SOA. (Team size 16)
Data Migration: This team is responsible for facilitation and one-time data conversion/migration across NetSuite system from legacy applications according to their business needs. (Team size 9)
Responsibilities
Engagement manager for 4 project teams running multiple projects concurrently with lot of scope creep.
Involved in scope, cost, time, resource, and risk management of various projects from initiation to closure.
Created Incident Management and change management ( part of ITIL framework)
Customer Service
Handle escalations related to resource contention/customer satisfaction/project risks/planning.
Contract Management including Service Delivery, SLA Management, and Manpower deployment.
Promoted the development and use of reusable components library.
Interaction/Co-ordination with client end-users and partner network for service related issues.
Team Management
Draft overall and monthly/quarterly goals & objectives for team.
Analysis of team performance/skill and taking effective steps for further improvement.
Carry out annual performance/salary reviews and provide guidance for career path development.
Conduct trainings as needed and mentor/guide team members in all aspects of their work.
Develop and encourage communication and working together among functions.
Revenue Generation and Collections
Achieve targeted revenue generation from IT management Services Contracts.
Billing to and Collections from existing Services Projects.
Relationship Management during post-sales efforts for exploring other business areas for additional revenue.
Client : Sun Microsystems Inc.
Duration : Jan 2006 – May 2007
Project : SUN-ISV Program
Designation : Project Manager (Team size 10)
Environment : Solaris, Linux, C, Java, dtrace, Makefiles, PERL, Netbeans, SunStudio, Eclipse
The project provides professional services to ISVs. The service offerings include porting, performance tuning and optimization, benchmarking, sizing, Proof of concept. The projects include…
RDF Gateway: Porting RDF server database engine from windows to Solaris 10. There were major challenges related to platform and programming model
FUSE Filesystem : Porting Kernel modules (Filesystem and char device) from Linux to Solaris 10
Glimmer: Porting C++ Gene discovery program from Linux to 64 bit Solaris 10.
R-Systems: Porting Open source statistical and graphical system from Linux to 64 bit Solaris 10.
Jabber: Benchmarking exercise involving simulated tests of up to 1.8 million users
SurfNDevelopment: Code Optimization involving PERL to JAVA conversion
Memcached: Performance tuning and benchmark
Netbeans Plugin: Develop SAP B1 Netbeans plugin.
LRWP: Java implementation of LRWP protocol. Later Sun Microsystems claimed patent on IP.
Responsibilities
Involved in project management including scope, schedule, resource, and quality and risk management of projects from project initiation to closure.
Key role as point of contact with end clients understanding their business requirements and organizing meetings, technical discussions.
Successfully lead LRWP protocol reengineering project and Sun Microsystems got patent on IP.
Achieved high level of customer satisfaction using agile project planning and execution.
Handled customer escalations related to high complexity risks of the project.
Involved in recruiting consultants for new project.
Winner of “Best Quality Project Award” for implementing best of processes.
Client : Agilent Technologies
Duration : Dec 2002 – Dec 2005
Designation : Project Manager (3 teams with total size 40)
Environment : HP-UX, Linux, FileNET, Oracle, Tibco BW, Tibco RV for message BUS, Oracle ERP
The project is based on onsite-offshore model to provide Level-2 and Level-3 support to 8000 users worldwide and include TIBCO Applications and Oracle ERP/CRM.
Responsibilities
Consultant for FileNET content management re-architecture project. This project involves analyzing core business requirements and submit proposal for alternative product for better ROI.
Project Manager for 24x7 TIBCO infrastructures and application (L2 and L3 support and engineering) and 24x5 Oracle ERP L2 support.
Prepared Service Level Agreement and change management as part of service transition ( part of ITIL framework )
Handle escalations related to resource contention/project risks/planning and achieved high level of customer satisfaction.
Project Lead for enhancements solution on existing application using distributed message bus with multi-protocol support for Java Message Service (JMS), TIBCO Rendezvous and SmartSockets.
Responsible for Contract Management including Service Delivery, SLA Management, Manpower deployment.
Planned and migrated Middleware applications from TIBCO 3.x to 4.x
Achieved high level of customer satisfaction all along. Responsible for Incident management, Process management, Team management, Interaction with client.
Project earned value analysis for continuous improvement.
Performance and availability management. Developed dashboard for monitoring and reporting purpose.
Developed Java user interface for real time transaction monitoring and issue resolution.
Participated in availability management using High Availability, Disaster Recovery best practices.
Organization : Fidelity Investments Canada Limited
Duration : May 1999 – Jun 2002
Designation : Senior Technical Consultant
Environment : Solaris, Linux, Progress and Oracle database, FileNET, Control-M
Responsibilities
Project Planning and Implementation for data feed from Progress to Oracle database.
Volume Manager, Veritas File System, Veritas Firstwatch HA, SYMON
Designed, developed and maintained utilities for production support of FileNET.
Project Lead for Disaster Recovery including developing strategy for Advance Recovery Solution for Oracle and Progress database including security.
Technical Support for Solaris on Sun Enterprise level series and AIX on IBM System/6000 series.
Extended support to Oracle and Progress database administrator
FileNet (IMS) Imaging System for UNIX/NT system Administration
Worked in Pro C, C, UNIX shell Scripting, Oracle, PERL, SQL Plus and writing queries for data mining.
Availability Management and Capacity Management ( part of ITIL framework)
Other activities include writing ACL for Control-M scheduling, BMC Patrol
Organization : EDS
Duration
Contact this candidate