19+ years of IT experience including 13+ years in Business Intelligence / Data Engineering space.
Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.
Extensively worked in developing Strategies, Planning, Designing, Developing and Deploying Data warehouses / Data Marts with experience of both relational & multidimensional database design.
Strong Data Modelling experience with Snowflake Schema, Star Schema to cater Reporting requirements.
Lead the build of data streaming systems.
implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems.
End-To-End implementation of Data warehousing projects.
Build accessible data for analysis.
Strong Exposure to SQL, PL/SQL, RDBMS, Oracle 8i/9i/10g/11g/18c/19c and MS SQL Server 2000/2005/2008/2012/2014/2016/2018/2022.
Experience in developing and tuning ETL routines to make it more time and resource efficient to meet tight deadlines.
Tested data flows and scripts against sample data and real data.
Expert in Data Extraction, Transforming and Loading (ETL) using SAP Business Objects Data Integrator XI (BODI), SAP Data-Services XI 3.2, 4.2(BODS), Pentaho, MS SSIS.
Created projects, batch jobs, Real time jobs, workflows and data flows.
Document source-to-target mappings
Possess leadership qualities of leading the team, motivating and inspiring the team by recognizing the work by giving appreciations.
Develop business intelligence reports that can be reused.
Extensively utilized Business Intelligence Reporting Tools such as SAP Business Objects 4.x, SAP Business Objects XI 3.1, SAP Business Objects XI R1/R2
Extensive experience of gathering requirements, building universes and Webi / Deski reports.
Experience in providing SAP Business Objects XI2/ XI3/ XI4 and Qlikview training to other staff of company.
Experience in migrating data from Non-SAP Sources to SAP HANA.
Communicate with Technical consultants, Business executives, Developers and end users.
SAP Business Objects Support (1st line to 3rd line).
Experience in building Web Applications using ASP 3.0, ASP.net 2.0/3.0/4.0, C#, MVC.
Ability to work under pressure and to tight deadlines.
Domain expertise in Finance (Equity), Health Care, E-learning, Transport, Judicial.
APMG Prince2 Foundation Certified
ITIL Foundation Certified.
AWS Certified Practitioner.
Good Leadership and project management skills.
Enthusiastic team player and comfortable to work without supervision.
Worked in an Agile Environment.
SC Cleared.
Business Analytics Program from University ofCambridge Judge Business School (CJBS).
Education
Decision making using data from Cambridge Judge Business School