Data Architecture
Chitwan Sharma
Data Professional
Johannesburg
Summary
Accomplished Technical Architect experienced in comprehensive design and development of Data and Analytics infrastructure and architecture for software projects. Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet clients' technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables.
Overview
20
20
years of professional experience
Work History
Senior BI Technical Architect
Ulwembu
10.2022 - Current
- Collaborate closely with stakeholders to understand business requirements and translate them into technical solution using IBM Data Power, Power BI and Oracle as a backend
- Creating Algorithms for Development team for different methods for calculating the Amortization schedule including Goal Seek
- Conduct workshops and meetings to gather and refine requirements related to amortization and loan schedules
- Design integration solutions to receive data from various commercial banks using REST APIs and SFTP protocols
- Ensure seamless data ingestion and integration, adhering to security and compliance standards
- Create technical documentation including design specifications, data flow diagrams, and API documentation
- Establish coding standards and best practices for development teams involved in the project
- Architect solutions to interface with payment systems to retrieve transactional data relevant to loan payments and schedules
- Implement mechanisms to reconcile payment data with loan amortization schedules
- Design and develop reporting solutions to generate loan schedules, payment histories, and financial summaries
- Ensure reports meet business requirements and provide actionable insights to stakeholder
- Define and maintain master data sets related to customers, loans, and other relevant entities.
Senior Data Modeler
Nedbank
06.2021 - Current
- Ensuring data modelling deliverables are delivered according to project plan and budget to meet commitment to stakeholders
- Ensuring all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards
- Analysis of Legacy System and Copybooks to the new DB2 Structures
- Analyze and profile the source data to understand data quality issues, relationships, patterns, and rules in the data
- Structure data requirements into logical data constructs based on the Enterprise Data Model, including ERD models, Application models to ensure optimal implementation
- Compile Source to Target Mapping Specifications including the appropriate Transformation Rules
- Enabled physical implementation of the data structure by generating the first cut physical data model from the logical data model
- Dataflow understanding by collating dataflow diagrams outlining the flow of data across systems
- Designing data model and Structures for REST APIs interfacing Nedbank Common Model for Core banking system.
Senior Data Modeler
Nedbank
06.2021 - Current
- Ensuring data modelling deliverables are delivered according to project plan and budget to meet commitment to stakeholders
- Ensuring all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards
- Analysis of Legacy System and Copybooks to the new DB2 Structures
- Analyze and profile the source data to understand data quality issues, relationships, patterns, and rules in the data
- Structure data requirements into logical data constructs based on the Enterprise Data Model, including ERD models, Application models to ensure optimal implementation
- Compile Source to Target Mapping Specifications including the appropriate Transformation Rules
- Enabled physical implementation of the data structure by generating the first cut physical data model from the logical data model
- Dataflow understanding by collating dataflow diagrams outlining the flow of data across systems
- Designing data model and Structures for REST APIs interfacing Nedbank Common Model for Core banking system.
BI Consultant
Niraah
03.2021 - 05.2021
- Worked as technical resources to generate SSRS reports for Geneva, TIBCO systems for managing equities, Securities and Prime Broking
- Integrating Geneva Application with SQL
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managing communication and Client’s expectation with the Client and deliveries of the projects involved.
BI Consultant
Niraah
03.2021 - 05.2021
- Worked as technical resources to generate SSRS reports for Geneva, TIBCO systems for managing equities, Securities and Prime Broking
- Integrating Geneva Application with SQL
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managing communication and Client’s expectation with the Client and deliveries of the projects involved.
BI Consultant
Expeditus
03.2017 - 12.2020
- Worked as technical resources to design data model and implement data warehouse solution using Informatica as a ETL tool, Netezza as backend data and MicroStrategy for Reporting
- Developed MicroStrategy BI reporting and analytics applications
- Developed normalized Logical and Physical database models to design OLTP system for hospital applications
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managed end to end Datawarehouse ETL process designs in Informatica and Reporting tools.
BI Consultant
Expeditus
03.2017 - 12.2020
- Worked as technical resources to design data model and implement data warehouse solution using Informatica as a ETL tool, Netezza as backend data and MicroStrategy for Reporting
- Developed MicroStrategy BI reporting and analytics applications
- Developed normalized Logical and Physical database models to design OLTP system for hospital applications
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managed end to end Datawarehouse ETL process designs in Informatica and Reporting tools.
BI Consultant
Expeditus
03.2017 - 12.2020
- Worked as technical resources to design data model and implement data warehouse solution using Informatica as a ETL tool, Netezza as backend data and MicroStrategy for Reporting
- Developed MicroStrategy BI reporting and analytics applications
- Developed normalized Logical and Physical database models to design OLTP system for hospital applications
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managed end to end Datawarehouse ETL process designs in Informatica and Reporting tools.
BI Consultant
Expeditus
03.2017 - 12.2020
- Worked as technical resources to design data model and implement data warehouse solution using Informatica as a ETL tool, Netezza as backend data and MicroStrategy for Reporting
- Developed MicroStrategy BI reporting and analytics applications
- Developed normalized Logical and Physical database models to design OLTP system for hospital applications
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managed end to end Datawarehouse ETL process designs in Informatica and Reporting tools.
BI Consultant
Expeditus
03.2017 - 12.2020
- Worked as technical resources to design data model and implement data warehouse solution using Informatica as a ETL tool, Netezza as backend data and MicroStrategy for Reporting
- Developed MicroStrategy BI reporting and analytics applications
- Developed normalized Logical and Physical database models to design OLTP system for hospital applications
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managed end to end Datawarehouse ETL process designs in Informatica and Reporting tools.
BI Consultant
Expeditus
03.2017 - 12.2020
- Worked as technical resources to design data model and implement data warehouse solution using Informatica as a ETL tool, Netezza as backend data and MicroStrategy for Reporting
- Developed MicroStrategy BI reporting and analytics applications
- Developed normalized Logical and Physical database models to design OLTP system for hospital applications
- Provided optimal and cost-effective solutions to business teams in achieving business objectives
- Managed end to end Datawarehouse ETL process designs in Informatica and Reporting tools.
Data Analyst
ASK'D
01.2016 - 09.2016
- Involved in requirement analysis, ETL system design, database design, dimensional model and solution design activities
- Interpret data, analyze results using statistical techniques and provide ongoing reports
- Develop and implement databases, data collection solution, data analytics and other strategies that optimize statistical efficiency and quality
- Acquire data from primary or secondary data sources and maintain databases/data solution
- Identify, analyze, and interpret trends or patterns in complex datasets
- Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
Technical Engineer / QA Tester
Reverside Software Solutions Pty Ltd
09.2012 - 04.2013
- Involved in requirement analysis, ETL system design, database design, dimensional model and solution design activities
- Involved in the database design and analysis, writing complex T-SQL queries, store procedures, performance tuning & optimization
- Work on requirement specifications for the strategic KPI's that drive performance and profitability in the division
- Developed SSIS packages to handle business logic, to load the Datamart and operationally managed SSIS packages
- Designed dimensional data models, star & snowflake schema, factless fact tables, Type-1, Type-2 and Type-4 Slowly Changing Dimensions etc
- Developed and managed SSRS reports and QlikView dashboards
- Developed QlikView dashboards that served to track inventory and sales as well as to monitor various KPIs
- Provide post-implementation support for all deliverables
- Effectively working with Business Users and Product Managers to meet deliverable deadlines for various components and giving inputs on the same.
Analyst
Bateman Engineering (India) Pvt Ltd
09.2007 - 05.2008
- Developed organizational chart for the company hence assisting in Manpower planning
- Involved in generating Key Performance Areas (KPA's), Competencies, Skills for employees with relevant Functional Managers
- Involved in doing Performance Appraisals & Succession Planning
- Prepared presentations and manuals & Training calendars
- Trained new employees on how to use software programs
- Involved in various meetings with the vendors and stakeholders.
Trainee Developer
Swamy Design Solutions Pvt. Ltd
11.2004 - 08.2007
- Involved in the requirement analysis, design, and development as well as in the testing of this product
- Extensively involved in the development of the module, which involved multi-threading and GUI for this product, which was developed in Swing
- Involved in the database Design and analysis
- Involved in writing PL/SQL queries and Store procedures.
Education
Post-Graduate Diploma in Human Resource Management (MBA) -
Symbiosis Centre for Distance Learning, Pune, India
Master of Computer Applications (MCA) - undefined
Visweswariah Technological University, Mysore, India
Bachelor of Computer Applications (BCA) - undefined
CCS University, Ghaziabad, India
Skills
- Enterprise Architecture Design
- Client communications
- Technical Design Documentation
- Data Modeling
- Microservices Architecture
- Client Engagement
- Business solutions
- Technical Architecture Design
- Systems Engineering
- Problem-Solving
- Technical Analysis
- Analytical Thinking
- Analytical Skills
- Big Data Analytics
- Code Development
- Critical Thinking
Technical and functional expertise
- Skilled in architecting end-to-end solutions across diverse platforms, including cloud, on-premises, and hybrid environments.
- Designing comprehensive and scalable solutions that meet business requirements while considering factors such as performance, security, reliability, and scalability.
- Considering integration strategies and ensuring seamless interoperability between different systems using applications, and platforms within the enterprise ecosystem. Designing and Modelling for APIs in microservices architecture.
- Strong knowledge in database solution design, data integration through APIs, data sourcing and transformation. Developed normalized Logical and Physical database models to design OLTP solution.
- Strong knowledge of BI tools for Reporting, Data Integration and OLAP (SSRS, SSIS, SSAS and MDS)
- Strong in data modelling skills including normalization, de-normalization, performance tuning, indexing, etc.
- Strong in T-SQL/SQL development skills within Microsoft SQL Server and IBM Netezza
- Knowledge of KAFKA and event streaming architecture.
- Optimizing system performance by identifying bottlenecks, implementing caching mechanisms, load balancing, and tuning system configurations for optimal efficiency.
- Results-oriented with emphasis on expansion and application of business and technical knowledge
- Implemented logical and physical data models using a variety of data modelling methodologies and techniques including Inmon or Kimball, with this establishing the source for analytical reporting.
- Ability to think in terms of business outcomes / results.
- Ability to quickly switch roles, for example, from administrator to counsellor to negotiator.
- Excellent written and oral communication and presentation skills. Able to communicate effectively with all levels of the organization, external business partners and vendors.
- Ability to work in team of various cultural and educational backgrounds.
Work achievements
- Customized Performance Development Plan in Visual Basic for Bateman Engineering India
- Building Customised Amortization Schedule Project for SARB, Decoding the “Goal Seek” method for Amortization calculation.
Certifications & Training
- TOGAF, Enterprise Foundation and Practitioner level Certified, 2023
- DAMA, CDMP Data Management Practitioner level Certified, 2021
- Microsoft Education, Microsoft Azure fundamentals – AZ 900 Certified, 2021
- Microsoft Education, Analysing and Visualizing Data with Microsoft Power BI - Exam 70-778, 2019
- Informatica University, Training on PowerCenter for Developer Certified, 2019
- MicroStrategy University, MicroStrategy Certified Developer (MCD) Certified, 2017
- Microsoft Education, Microsoft Certified Technical Specialist - BI (MCTS) Certified, 2010
- Saptree Consulting Pvt Ltd, Bangalore, India, SAP/HR Functional Module, 2008
- Indian Institute of Management Bangalore – IIMB, Bangalore, India, Management Program for Women Entrepreneurs, 2007
Personal Information
- Gender: Female
- SAID Number: 8009021382182
- Nationality: Indian
Software
Data Modeling
Business Intelligence and Data Analytics
Data Warehouse
Data Engineering
Interests
Dancing
Singing
Reading
Timeline
Senior BI Technical Architect
Ulwembu
10.2022 - Current
Senior Data Modeler
Nedbank
06.2021 - Current
Senior Data Modeler
Nedbank
06.2021 - Current
BI Consultant
Niraah
03.2021 - 05.2021
BI Consultant
Niraah
03.2021 - 05.2021
BI Consultant
Expeditus
03.2017 - 12.2020
BI Consultant
Expeditus
03.2017 - 12.2020
BI Consultant
Expeditus
03.2017 - 12.2020
BI Consultant
Expeditus
03.2017 - 12.2020
BI Consultant
Expeditus
03.2017 - 12.2020
BI Consultant
Expeditus
03.2017 - 12.2020
Data Analyst
ASK'D
01.2016 - 09.2016
Technical Engineer / QA Tester
Reverside Software Solutions Pty Ltd
09.2012 - 04.2013
Analyst
Bateman Engineering (India) Pvt Ltd
09.2007 - 05.2008
Trainee Developer
Swamy Design Solutions Pvt. Ltd
11.2004 - 08.2007
Post-Graduate Diploma in Human Resource Management (MBA) -
Symbiosis Centre for Distance Learning, Pune, India
Master of Computer Applications (MCA) - undefined
Visweswariah Technological University, Mysore, India
Bachelor of Computer Applications (BCA) - undefined
CCS University, Ghaziabad, India
Similar Profiles
Nokukhanya MbathaNokukhanya Mbatha
IT Service Desk at Ulwembu Business ServicesIT Service Desk at Ulwembu Business Services
Mzomhle NkosiMzomhle Nkosi
IT Support Technician/Desktop Engineer at Ulwembu Business ServiceIT Support Technician/Desktop Engineer at Ulwembu Business Service
Habibatou DialloHabibatou Diallo
Waitress at Primi PiattiWaitress at Primi Piatti