SUMMARY

• Over 20 years of experience managing and delivered projects, with Agile and Waterfall methodology as a Solution Architect, Data Architect and Technical Project Manager. These projects spread across Capital Markets - Credit Risk & Finance, Consumer Lending, Retail Retirement Services, Annuities, Mortgage, Health Insurance, Property and Casualty Insurance, Vehicle Leasing and Finance, and Motor Vehicle Manufacturing, Taxation domains.
• Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps, blueprints and project plans.
• Proficient in data modelling, architecting BI/Data Warehouse applications with performance, availability, and reliability requirements, using tools like Informatica, Cognos, SSIS, Unix Scripting, and Oracle, SQLServer, Ingres, Azure cloud.
• Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development teams.
• Have managed Gamification applications and directed in UI/UX development.
• Have been trained on Hadoop concepts and ecosystem tools like - Sqoop, PIG, HIVE, Atlas

TECHNICAL SKILLS

ETL Tools: Informatica PowerCentre, Cognos Data Manager, SSIS, PL/SQL

Modeling Tools: ERwin 9.3, Oracle Designer 2000, Visio, Oracle SQL data modeller

RDBMS / ODBMS: Oracle 11 Exadata, Sybase, Ingres, SQL Server, Jasmine ODBMS

OLAP/ Reporting Tools: OBIEE, Cognos (Framework Manager, Report Studio, Analysis Studio), BRIO IR

Programming Languages: SQL, PL/SQL, T-SQL, Java Script, Shell Scripting, Java, TypeScript, .NET

Development Tools: Eclipse, VSCode, Visual Studio, SSMS, Oracle, Portals 9i, PDK, BIDS

Architecting Skills: Relational/ Dimensional Data Modeling, J2EE, SOA

Other Tools: Azure cloud, Amazon AWS, MS Dynamics 2011, MS Project, JIRA, TFS, u-Deploy, Anthill, XML, XSL, SVN, VSS, Harvest, TD, Bugzilla, Flash, Version One, ab-Initio

PROFESSIONAL EXPERIENCE

Confidential

Data & Technical Architect

Responsibilities:

• Analyze and identify data capture requirement from various Credit card systems and data sets which exists within the bank. Define a strategy to capture and collate required data from these.
• Data Analysis and profiling of source data and define data feed requirements in co-ordination with data sources systems. Define the data load and integration strategy and produced data model blueprint.
• Identify ETL process/tools and design data ingestion, logging and error handling, and control reports process. Provided inputs on the report design.
• Co-ordinate with System Architects and Infrastructure teams to define roadmap for technology architecture and server sizing requirements.
• Delivery - Lead development team, scheduling of development activities and provide critical inputs to project managers to update project plans.
• Co-ordinate with QA, DBA, Deployment, Infrastructure, Prod support teams on SDLC reequipments.

Environment: Visio / Oracle 12c on Exadata / Informatica 10.2.0 / Autosys / NDM / DTS / Channel Secure / Anthill / u-deploy

Confidential

Data & Solution Architect

Responsibilities:

• Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Created data warehouse & BI technology vision, roadmaps of the solution.
• Identify and scoped solution to align with the stakeholder vision, generate FSD and Solution design using BRD and Requirement Analysis done by BA and Data Analysts teams.
• Define solutions architecture, data architecture and models using ERWIN. Defined ETL strategy and detailed ETL design, high level UI framework. Translated business requirements into conceptual, logical and physical data models.
• Interacted with 40+ internal and external teams to conduct Data sourcing and data discovery activities to identify data requirement and create data model blueprint to conform to sourcing and solution roadmap.
• Work with external/internal data providers to identifying and finalize Master data from various external sources like Bloomberg, Morning Star, Reuters.
• Consulted SA to recommend server, system architecture and technology stack, confirm requirements and build system architecture specifications, identify server sizing.
• Directly responsible for driving Logical and Physical Data Model deliverables while managing deployment of production, development and validation environments. Designed Workflow and case management for compliance and BHCA reporting - Dashboard, incident creation, case management.
• Project management - Provided valuable inputs into project plans and schedules, undertook planning and allocation exercise with development team, worked with stakeholders to undertake release planning. Lead ETL and UI team during development and deployment phase.

Environment: Azure Cloud / Sql-server-2016 / Oracle / Informatica / SSIS /Ab Initio Metadata hub / Angular 6 / .Net / CD-NDM / Autosys

Confidential

Project Manager, Data Solution Architect

Responsibilities:

• Architected solutions, developed framework designs, data models feature, with performance optimization requirements and created a POC for the development team to implement the design.
• Executed performance analysis and implemented performance improvements in database and ETL processes including SQL tuning, to meet performance SLA.
• Project management - Scheduling and allocation of development items, release scheduling planning, daily scrum and status calls with business owners and other stakeholders.
• Co-ordinate with various teams for QA, deployment, dba, server teams over the development life cycle.
• Manage client relationship, maintaining contractual documents and status reporting.

Environment: SSIS/ T-SQL / BIDS / MS Sql-server / DB2 /Teradata / Autosys

Confidential

Project Manager, development lead, Client Partner

Responsibilities:

• Manage and Lead on-site and offshore development teams on the engagement.
• Attend scrum and status calls with business owners and other stakeholders.
• Co-ordinate with BA's and business users and translated business requirements to technical specs.
• Planning, allocation and monitoring of work of development teams.
• Co-ordinate with QA Managers and Business users for SIT and UAT.
• Co-ordinate with deployment/dba/server teams for release management.
• Ensure 24/5 production support SLA are met, managed investigation and resolution of production issues.
• Development teams service delivery SLA are met.
• Create and manage contractual documents and provide status reporting and inputs to the project plans.
• Accurately documented ETL strategy and documented detailed design specifications for the ETL process.
• Executed performance analysis, rearchitected database procedures and ETL for performance improvements, optimized Autosys job scheduling.

Environment: MS Dynamics/ Informatica 8x/9x / SSIS/ SharePoint / Oracle/MS Sql-server / Sybase / Flash / HTML5 / Autosys/ Unix / Windows / Java /.Net