Summary

• 14 years of Experience as Technical Architect in the areas of DWH/BI design, development, administration support of business applications.
• Currently working with Atos as Senior Technical Architect in Information management space.
• Primary areas of technical expertise include MongoDB, Qlikview, Hadoop, Oracle Business Intelligence Enterprise OBI , Informatica PowerCenter 8.1.1, Oracle 9i/10G
• Worked with top-tier clients across Insurance, Financial HR domain. Worked with clients like Credit Suisse, Aviva, Friends Provident etc.
• Extensive experience in end-2-end solution of decision supporting systems using Data warehousing tools and databases
• Architected BI systems involving requirements analysis, database designing including logical data modelling translating it to physical data structures ETL architecture
• Designed data source agnostic systems ingesting data from across various sources into a common data model
• Proficient in Informatica, Oracle PL/SQL, performance tuning and overall optimisation of database
• Broad depth of knowledge in emerging data technologies including Bigdata, NoSQL databases and various visualisation tools like OBIEE, Qlikview, Tableau etc
• Successfully implemented, deployed and maintained HR Analytical Reporting BI system for Credit Suisse, Corporate Systems
• Excellent managerial interpersonal skills, motivated energetic team player with demonstrated proficiency for learning new tools and business environment
• Experience in Software Development Life Cycle SDLC using Agile Scrum and Iterative life-cycles.
• Result oriented and skilled in providing solutions to complex systems.
• Excellent communication skills, coupled with very positive user interaction team spirit

Core Competencies

• Information Management
• MongoDB, Big Data technologies, MDM, SNA, Information syndication
• Reporting and Analytics
• Qlikview, knowledge of Tableau R
• RDBMS
• Oracle 9i/10G, MySQL, PL/SQL, SQL and DWH Tuning
• ETL tools
• Informatica PowerCenter 8.1.1, knowledge of Talend
• OLAP Tools
• Oracle Business Intelligence Enterprise
• Operating Systems
• Windows NT/XP, Solaris 8, Unix Shell Scripting
• Data Modeling Tool
• Erwin 4.1
• Scheduler
• Oracle Data warehouse Administration Console DAC

Project Profile

Confidential

Senior Technical Architect, Build offerings for Atos Consulting with custom bundles as per maturity matrix, business operating model and evolution strategy

• Responsibilities: Key IT Consulting Offerings using both open-source and licensed products
• Big Data Program: Responsible for building Bid Data Strategy for Atos Consulting
• The program includes various stages an organisation goes through while implementing Big Data projects like BD Awareness, Advisory, BD ecosystem, pilot, post pilot, Market go to strategies setting up of Big Data COE etc
• Provide thought leadership guidance in best practices design of Big data programs
• Define Big data maturity structure tools to assess clients maturity across various dimensions
• POC on Big Data: Customer profiling, segmentation RFM analysis
• Information Syndication Services aka Information object on demand
• MDM through an Automated Clearing House
• Social Networks in an Enterprise
• Email free Organisation

Confidential

Senior Technical Architect

• iTOM is a data source agnostic solution for performance analytics on 'IT Finance, Services Security' operational data.
• Responsibilities:
• Collaborated with stakeholders for gathering requirements, assessing business rules, source-to-target data mapping
• Provided high level design based upon technology evaluation study
• Designed meta-data driven solution to fetch data from MongoDB into common data model based after customer requirement
• Designed high level ETL design and reporting specs
• Responsible for installing and configuring technology stack consisting of MongoDB cluster, MySQL, Talend
• Provided team with guidance related to load large sets of structured, semi-structured and unstructured data coming from a variety of data sources into MongoDB
• Supported code/design analysis, strategy development and project planning.

Confidential

Senior Technical Architect

• Reducing unsaleables linked to product damage requires a structured process to determine the root cause of the damage - whether it occurred at the warehouse, in transit or during manufacturing, or is a defect.
• Britannia's product damage analysis uncovers the causes of your unsaleables problem and recommends corrective measures.
• Responsibilities:
• Collaborated with stakeholders for gathering requirements, assessing business rules
• Provided high level design based upon technology evaluation study
• Responsible for delivering various artefacts of projects e.g.: FSD, HLD etc
• Responsible for installing and configuring technology stack consisting of Hadoop HDFS, Hive integrating R with it
• Data ingestion into HDFS and providing ad-hoc reporting based on Hive

Confidential

Onsite Project Lead

Responsibilities:

• Worked as an Onsite Project Lead Data Warehouse consultant for a project which is more than CHF 2 million
• Part of the responsibility was also to work as an Business Analyst
• The role involved detailed understanding of the business requirements and translating them into the solution architecture in line with organisation strategy and guidelines. The solution architecture is used as a baseline for estimation and planning.
• Stakeholder interaction requirements gathering
• Understanding and Analysing PeopleSoft system HR Workforce analytic
• Scope management and estimation
• Data modelling and formation of Star schema for OBI
• Developing and performance tuning of PL/SQL packages
• Informatica ETL design and development
• DAC implementation
• Work products creation and reviews
• UAT Release management coordination

Quotes Support Maintenance

Confidential

Onsite Project lead

Responsibilities:

• Worked as Work Product Manager
• Completely responsible for major releases which included regulatory changes in UK insurance market for Pension simplifications and HMRC tax changes for Retirement Annuity Contracts RAC . Handled end-to-end project activities
• Stakeholder interaction, requirement gathering and feasibility study of requirements
• Scope management Estimation
• Design and analysis of the requirement
• Data modeling and interface design
• Prepared CMMi 5 compliant artifacts such as project-specific process handbook, configuration management plan, risk management plan, project status reporting, disaster recovery plan, defect prevention plan, etc.

Confidential

Onsite Co-coordinator/Module lead

Responsibilities:

• Complete responsibility of handling APR's application problem report and SDR's software development requests
• Provided solution for migration of the application from IE5 to IE6
• Stakeholder interaction and requirements gathering
• Design/Development
• Scope management and estimation
• Configuration manager

Confidential

Onsite Coordinator/Module Lead

Responsibilities:

• Managed all major releases and handled end-to-end project activities
• Stakeholder interaction and requirements gathering
• Design/Development
• Scope management and estimation
• Configuration manager

Confidential

Project Engineer

Responsibilities:

• Mainly involved in analysis, design, coding, unit testing, system integration testing of PAC and IFA extranet
• User interaction
• Scope management and estimation
• Release management

Confidential

Project Engineer

Confidential

Module Lead

Responsibilities:

• Worked as a module leader
• Requirements gathering
• Design and development

Testing

Implementation

Confidential

Software Developer

It was an ERP system for small and medium scale companies. It consisted of various modules like Materials Management, Production Planning, Quality Management, Financial Accounting, HR, Excise Tax and Management Information System.

Responsibilities:

• Worked as a project engineer
• Writing Oracle Stored procedures
• UI Design and development
• Testing