SUMMARY:

• 17+ years of IT experience in with multiple full lifecycle projects in Data Warehouse, Business Intelligence and business critical Application Systems
• Worked at the capacity of data architect, data modeler, enterprise consultant, business analyst, data analyst as an individual contributor and at the lead roles
• Designed and developed operational on - line transactional processing (OLTP) system for real time business processing using 3rd normal form
• Designed and deployed multiple online analytical processing (OLAP) models using Inman and Kimble principles
• Hands on experience on the Azure cloud platform with HDInsight Big Data solution, Data Lake and Azure Machine Learning
• Hands on experience of acquiring data, apply statistical analysis and prepare visualization using excel and/or Power BI
• Worked for leading global Banks, Insurance, Financial Institutions and media companies in multiple geographic locations
• Good experience of working with Executives, IT and Business Stakeholders, Product Owners and End Users
• Extensively worked with cross functional, multi-vendor, multi-location teams with using Agile Scrum, Waterfall, Hybrid and IT Service Management Framework
• With enterprise architecture framework ( Confidential ) and project management ( Confidential ) accreditation I have ability to quickly grasp enterprise perspective and contribute towards the goal

TECHNICAL SKILLS:

Tools and technologies: worked on or familiar with through recent or past projects

Modeling: Erwin 9.8, Cognos 8 Framework Manager, SQL Designer, Power BI

ETL/Integration: SSIS, Informatica, SAS Data Integration Studio, Azure Data Factory

Scripting/Language: Azure Machine Learning, SQL, HiveQL, C#, VB.NET, JSON/XML

BI Reporting: Cognos BI Reporting, MicroStrategy, Power BI, Excel

Tools: MS Office, Visio, SharePoint, Jira, Confluence, Blueprint, Prezi

Database & Related: Teradata, SQL Server, Oracle, DB2, NoSQL (Cosmos DB), Toad/SQL Asst

Framework: Enterprise Architecture ( Confidential ), SOA, Lambda, Hadoop, CMMI Level 5, PMBOK

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr Business Data Analyst/Architect

Responsibilities:

• Act as an interface for business stakeholders to analyze BRD (business requirement document) and prepare solution proposals
• Develop conceptual solution design and proposals, conceptual and logical data model (LDM), business and functional requirements BRD/FRD
• Perform in-depth data and requirements analysis by writing simple, medium or complex SQL queries for Marketing data warehouse in Teradata
• Work with data integration team for batch processing of inbound data from streaming channels and vendors
• Acquire personally identifiable information (PII) from upstream systems, apply making and/or eliminate them from the feed to vendors
• Manage stakeholder’s expectations for business, IT development and quality assistance throughout the solution delivery phases
• Maintain business requirements matrix and ensure goal is followed while migration into enterprise wide slenderized model
• Work on data integration from mapping, cleansing, define ETL rules to meet the project requirements and present it to business stakeholders

Environment: Teradata Data Warehouse, SQL Queries, Visio, Erwin, Office, Kafka, JSON

Confidential

Sr Consultant/ Business and Data Analyst

Responsibilities:

• Work with stakeholder from multiple LOBs on regulatory and compliance data lineage analysis
• Scope definition, solution roadmap, define and maintain data catalog, definition
• Workshops with external vendors, internal IT team and business stakeholders
• Conceptual solution design and proposals, logical data model, business and functional requirements BRD/FRD
• Liaise with Abinitio (vendor) product team for development, testing and implementation of project requirements
• Analyze database objects from Oracle that includes tables, views, stored procedures, ETL for metadata lineage
• Acquire personally identifiable information (PII) from application flow, define them and apply masking before enabling them for other in-house applications
• Conduct post deployment Quality Assurance and assist user community for UAT
• Implement Agile methodology and work with product owner to create stories for sprint and backlog

Environment: Abinitio Metadata, Oracle 11g Toad, ALM, Jira, Clarity, MS Office, Visio

Confidential

Sr Consultant

Responsibilities:

• Work closely with client executives and IT delivery teams to participate and define the roadmap for ‘ Confidential
• Prepared application portfolio and heat map to facilitate run the back and change the bank strategy
• Lead and collaborate with subject matter experts and executives for proactive solution and response to RFP and tenders
• Conduct workshops with business stakeholders and multi-location IT delivery teams

Environment: BI/DW, MS Project, SAS, MS Office

Confidential

IT Project Manager

Responsibilities:

• Work with vendor consultants and client to prepare credit scoring system implementation roadmap for 9 countries
• Ensure enterprise architecture, data governance and SOA followed throughout then implementation
• Lead data mapping, reconciliation and set goals for credit bureau integration (TransUninon, Compuscan), operational data store (ODS), Data Warehouse and MIS
• Maintain data integrity and stream needs for extraction, processing, analysis and storage
• Guide team to document source to target data mapping for multiple systems (CRM and BPM) integration with the scoring system
• Ensure that the scoring data extracts from in-country ODS is loaded into headquarter data warehouse for executive reporting and analytics
• Provide guidance to business analyst for business cases and functional specifications, presentation to stakeholders for signoff from sponsors
• Maintain relationship and coordinate with in-country credit teams for users training and user acceptance testing (UAT), parallel-run, downtime and decommission of old system

Environment: Oracle ESB, ERWIN, Teradata, SAS, Informatica, Core banking solutions (Finacle, T24, Bankmaster), IBM BPM, MS Project, MS Office, Clarity

Confidential

Enterprise Consultant

Responsibilities:

• Analysis of legacy applications and prepare logical view of the integrated systems for transition plan
• Develop heat map of the IT portfolio for parameters of database, usage of in-house built ESB, Java and .NET applications for business functions
• Work with IBM, implementation partner, to understand new implementation roadmap and align legacy systems migration plan
• Prepare conceptual, logical view and present them in weekly review meeting for executives to understand the plan and status of migration plan

Environment: Visio, SharePoint, MS Office, Mindmap, IBM Stack, JAVA/JBOSS

Confidential

Enterprise Consultant

Responsibilities:

• Participate in strategic planning and trailblazing for Guidewire Policy Centre implementation
• Work with and for Chief Technology Officer (CTO) to align parallel running programs to mitigate integration risk and cost escalation
• Ensure data movement and key module implementations are sequenced accurately in parallel running programs
• Scrum master from architecture group to participate in multiple program’s scrum of scrums
• Conduct scrums, create epics and user stories for architecture team

Environment: Rally, Visio, Guidewire Policy Centre, Erwin, Tibco, MS CRM, SharePoint

Confidential

Business Service Lead

Responsibilities:

• Re-engineering of 10+ years old legacy insurance systems into modern age technology for Emerging Market & US
• End-to-end execution from source system analysis to new solution design, development and deployment
• Lead and guide team of business and systems analysts for reverse engineering of the existing functionalities and workflow from quote to claim settlement
• Conduct workshops for requirements gathering, gap analysis, key challenges, key success factors as per users
• Work on and review DFD, ERD and Use Cases for functionality mapping
• Ensure that existing rich functionalities along with 10+ years old data has been transformed/migrated into new platform with no loss to the business
• Ensure that new data model is highly parameterized and configurable to cater to multi geography business needs
• Work with analyst to ensure that new architecture delivers business process improvement through effective workflow by reducing human intervention
• Engage with business area owners to review data migration error report and get their feedback/cleansing/correction on poor quality of data at the source
• Coordinate users training and acceptance testing (UAT), parallel-run, decommissioning

Environment: .NET (WCF, C#, AJAX), VBA, Delphi, SQL Server 2008, Crystal Report, SSIS, Erwin

Confidential

Data Architect

Responsibilities:

• Create and analyze DFDs, ERD from the existing systems that consist of 4700+ tables
• Create LDM and Physical data model for optimized new data model that address scalability and future business needs in the new data model
• Engage with sponsors and other stakeholders to present them the new model
• Design conceptual, logical and physical data models (relational, normalized)
• Establish and control governance for development team
• Guide team to build proof of concept on new data mode

Environment: SQL Server, Visio, Erwin, Mindmap, MS PowerPoint, .NET

Confidential

Business Intelligence Consultant

Responsibilities:

• Design and develop Logical Data Model (LDM), ER
• Design and develop dimensional data models in Cognos Framework Manager
• Develop and publish package for BI Reporting
• Design and develop Reports, peer review, UAT, end-user training

Environment: COGNOS 8 (Framework Manager, Cognos Connection, Report Studio, Access Manager), SQL Server

Confidential

Lead Data Analyst

Responsibilities:

• Maintain inventory of source systems to import data from into EDW for credit risk systems
• Lead and coach data analysis, data profiling, metadata repository, data cleansing and MDM
• Lead extract transformation and load (ETL) for source to staging and then staging to EDW
• Ensure that data governance is followed, and reference & metadata are up-to date

Environment: SAS Enterprise Guide, SAS DI Studio, MS Project, EPM, DB2