PROFESSIONAL SUMMARY:

• Eighteen (18) plus years of experience in Information Technology (IT) working in multiple roles with strong experience in
• Expert in defining governance, implementing processes and frameworks. Hands on experience in establishing COEs and ODCs. Passion for Competency Building, Training & Mentoring.
• Working experience in service and product development organizations with on premise and SaaS models.
• Managing overall operations for executing projects involving scoping, design & architecture, resource mobilization, execution within cost & time parameters.
• Monitoring / tracking projects with respect to budgeted cost, demand forecasts, time over - runs to ensure timely execution of projects.
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
• Handling various technical aspects like system design & integration, coding of modules, executing test plans, project documentation, monitoring critical paths & taking appropriate actions for multiple projects.
• Managing Risks by risk identification, prioritization and plan mitigation.
• Addressing all the important issues & defining best practices for project support and documentation.
• Steering Delivery Management for technical deliverables of concurrent projects.
• Meeting deadlines without compromising quality norms and adhering to SLA.
• Design Entity Relationship(ER) models, Dimensional Models (Star and Snowflake) for large Enterprise Data Warehouse(EDW) and Operational Data Store(ODS) using industries best standards, Integration of data from multiple sources, create ETL Architecture, create ETL standards, Change Data Capture (CDC), perform Data Validation
• Design BI solutions to support Reporting, Analysis and Analytics.
• Data Profiling, Data Quality Analysis, Data Cleansing, Data Matching, Data Consolidation, Data Quality Monitoring, Data Quality Dashboard, Data Quality Checks
• Master Data Consolidation from various legacy systems
• Mapping documents, Cross Walk Documents, Erwin Models, Data Lineage
• Informatica/Datastage/SSIS - develop Workflows, Sessions, Mappings, Maplets and Error Handling, Performance tuning Confidential Mapping, Session, Source and Target level
• Cognos/MicroStrategy/Tableau - develop Reports, Cubes, Analytics
• Teradata - create Logical and Physical Data Models, create Capacity Plans, develop applications using BTEQ, FASTLOAD, MULTILOAD, TPT, FASTEXPORT, STATISTICS, JOIN INDEXES, ­TRIGGERS, MACROS, STORE PROCEDURES and EXPLAIN PLAN, Performance Tuning using Partitioning, Join Indexes, Secondary Indexes, compression techniques
• Oracle/SQL Server - Data modeling, SQL, PL/SQL
• Unix - Shell Programming, AWK programming, Job scheduling

SKILL:

Data Integration/ETL Tools: Informatica, Datastage, Ab initio, SSIS, Golden gate, IBM IIB, ESB, Data Power, WTX

Databases: Oracle(SQL, PL/SQL), SQL Server, Teradata, Vertica, DB2

Technologies: Data Warehousing, Business Intelligence, MDM, Data Quality, Big Data (Hadoop & Vertica), ERP, CRM

Reporting Tools: Cognos, Microstrategy, Business Objects, Crystal Reports, Oracle Reports, Oracle Designer, Tableau

Programming Languages: SQL, PL/SQL, Unix Shell Scripts, C++, Java

Tools: & Software: TOAD, Citrix, Visio, Rational Rose, ERWIN, QC, Tidal Scheduler, Salesforce, SAP ECC, BW, BOBJ

Operating Systems: Solaris/AIX/HP Unix, Linux, Windows NT/2K

Change Management: ClearQuest, Remedy, QC

Configuration Management: ClearCase, ClearQuest, CVS, PVCS, QuickR, Test Director, RUP Framework, SVN

Industries: Banking, Finance, Automotives, Telecom, Media & Healthcare

PROFESSIONAL EXPERIENCE:

Confidential

MDM/Data Quality Consultant

Responsibilities:

• Define existing process, identify gaps, propose solution to fix them permanently
• Facilitate sessions to explain the proposed solution to business and various stakeholders
• Once getting buy in from every group implement the proposed solution
• Generate reports to depict the data quality issues and present to management along with a proposal to address these data quality issues
• Identified gaps in the data flow between various systems like Informatica MDM, Salesforce, Integration tools and various legacy systems.
• Fixed the address related issues by upgrading to the latest version of Address Doctor
• Able to explain and convince the business and other stake holders that the data quality issues are not MDM related but related to the overall design of data flow between the systems.
• Developed test plans and test cases and participated in end to end testing.

Environment involved: Informatica 9.6, MDM 9.6, IDQ 9.6, Salesforce, Sterling Integrator, Java, Oracle, Tableau, MicroStrategy.

Confidential

Practice Lead/Solution Architect

Responsibilities:

• Support Sales in closing the deals. Play a crucial link between Sales, Customer and Delivery
• Technical and Business Consultant for the potential customer
• Prepare and assist in making proposals for RFPs and RFIs as well as SOW’s
• Prepare presentations and demos with the expert knowledge on Products and Solutions being offered
• Keeping big picture in mind - winning the deal for the company as well as customer delight
• Client liaison, managing cross-functional teams providing leadership and consulting
• As a Channel Partner Manager work with various Product companies to build relationships and become the preferred Systems Integrator and Value-added Re-seller. Work on the GoToMarket Strategies and do join marketing campaigns along with the Partners.
• Attend conferences and build relationships with Customers and help in business development.
• Build Center of Excellence & Practice for BI Reporting & Analytics

Practices involved: BI/DWH, Big Data & Analytics, Salesforce, Java & Open Source, BPM, Microsoft, QA/Testing, Mobility

Confidential

Delivery Manager/Solution Architect

Responsibilities:

• Onsite Delivery Manager for Kill Cognos Project
• Defined goals, expectations of the project; compiled project initiation document
• Facilitated sessions to define project scope & requirements
• Identified resources, functional teams & third parties important for the project
• Built and presented proposals with various levels of estimates
• Performed project planning; reported weekly project governance & status
• Organized workshops to identify risks, assumptions, issues & dependencies
• Tracked project finances and work orders
• Overseeing and managing offshore delivery teams from Onsite
• Review Solution Architecture for Global Data Warehouse (SAP BW, HANA) & Tableau Analytics and Reporting
• Propose and Review Solution Design for Data Management using Informatica Products (Powercenter, Cloud, DQ, MDM)
• Facing the Customer, Evaluating Requirements, Estimating Effort, Schedules Planning, Organizing meetings & Huddles, Evaluating Risks, Communicating with Senior Leadership etc.
• Interact with cross functional teams which include - Analysts, SAP Architects, HANA DB Architects, Tableau Developers, Salesforce Integrations, Oracle, PL/SQL Developers, Support Teams, ETL/MDM Developers, Application Developers, Functional Testing, UAT.
• Establishing Standards for Tableau, Informatica, ETL & MDM

Environment involved: SAP ECC, SAP BW, Tableau, Cognos, Informatica, MDM, DQ, Cloud, HANA, Salesforce, Oracle, SQL Server, MFT.

Confidential

Solution Architect

Responsibilities:

• Monitored and controlled project activities including scoping, estimate reviews, WSRs & steercom reviews
• Created project charter; defined goals, deliverables & the preliminary scope of the project
• Identified risks, assumptions, issues and dependencies; managed the same
• Developed proposals; planned, executed and monitored the projects
• Selected the resources and coordinated with cross-functional teams during project execution
• Managed finances; communicated and coordinated with Project Stakeholders & SMEs
• Architecting Solutions for BI/DWH/MDM/DQ (Informatica, Teradata, Microstrategy) & Technical Integration (IBM ESB Tools) Environment
• Developing Roadmaps, upgrade plans for Informatica Product Suite - PowerCenter, Data Quality, MDM, Metadata Manager, Business Glossary etc.
• Evaluating Products, Tools, Participating in Informatica World & other Conferences, bringing back value to the teams from the conferences.
• Responsible for delivering end to end projects for the Business/Customers. As a member of leadership team performed the following - Facing the Customer, Evaluating Requirements, Estimating Effort, Schedules Planning, Resource Hiring, Resource Performance Evaluation, Organizing meetings & Huddles, Evaluating Risks, Helping Senior Leadership with Reorgs, Communicating with Senior Leadership etc.
• Manage cross functional teams which include - Data integration Analysts, Data Profilers, Data Quality Developers, MDM Developers, Microstrategy Developers, Teradata DBA’s, Testers, IBM IIB/Data Power/WTX Developers.
• Establishing Standards for Data Integration, Data Quality, ETL, MDM & Scheduling Tools and define Data Retention Policies.
• Responsible for validating and testing the deliverables and participate in UAT before they go live.

Environment involved: Informatica 10.0, Informatica 9.6, MDM, IDQ Teradata 14, SQL Server 2012, Microstrategy, HL7, EDI, Tidal Scheduler, IBM IIB, ESB, Data Power, WTX, MQ Series.

Confidential, TX

Data Delivery Consultant

Responsibilities:

• Understanding the Systems Manual, business requirements, data and various data elements
• Prepare design document to process the data from various source systems into the data delivery reporting environment i.e. EDW environment
• Translate business objectives into technical solutions
• Ownership of the data delivery projects and responsible for successful delivery on schedule
• Provide day to day updates on Data Delivery/EDW projects to senior management & directors
• Coordinate with the development teams
• Participate in meetings with Users/Customers, Business Analysts, Project Managers, Testing teams, Data Analysts, Developers

Environment involved: Teradata, Datastage, SQL, Bteq, Mload, Fast Export, Teradata SQL Assistant, ERWIN, UNIX, AIX and Shell Scripting.

Confidential

Data Architect

Responsibilities:

• Determined critical customer needs
• Performed technical designing and code reviews
• Resolved critical issues related to integration
• Conducted:
• Voice of Customer and Voice of Business
• Gateway reviews with stake holders
• Documented process Confidential every step; delivered code base and provided KT to the Support Team
• Scope the Teradata applications to be migrated to Vertica.
• Re-design Informatica and Teradata applications for Vertica.
• Create capacity plans, Logical and Physical Data Models for Vertica using Erwin tool & Physical database using Admin tools and Database Designer (DBD).
• Build semantic layer for Composite tool, which allows users to query on Teradata and Vertica objects.
• Monitor performance of Vertica queries and Tune the queries using customized projections and partitioning techniques.
• Perform data validation activities to make sure Vertica data match Teradata.
• Organize meetings with DBA, Data Strategists, Operations, Downstream app teams, Testing team, Reporting Team etc.
• Support deployment and testing activities.

Environment: HP Vertica 6, Teradata 13.10, Erwin 7.3, Control-M, SQL Assistant, Unix, Composite, Informatica 9.5.1, Business Objects XI R3.1

Confidential

DWH/BI/ETL Architect

Responsibilities:

• Architect & Build Confidential system for CODG (Client Onboarding Data Governance) and C&AD (Client & Account Data) teams to enable analytical reporting and operational reporting across a variety of data sources and to ensure data quality, consistency, flexibility and scalability.
• Manage ETL and Reporting teams (onsite/offshore) and responsible for all the overall development & quality of the product and responsible for delivering the product to business and end users within the budget and deadlines
• Participate in the weekly portfolio meetings and provide up to date status to the senior management on the development progress and pending issues
• Worked on developing the Master HUB (Client & Account domains) from various legacy systems using Informatica MDM tool.
• Manage the development effort across cross functional teams like Business Process Framework (BPF), Data Services (DSF/DSP), User Interface (UI) in the process of designing near real-time updates into the Data Warehouse
• Responsible for deployment and testing activities (UAT).

Environment: Datastage 8.5, Cognos 10, Informatica MDM (Siperian), Ab initio, Linux, Oracle 11g, Golden gate, DB2, Teradata, SQL Server 2005, SQL, PL/SQL, SQL Plus, Erwin, Autosys, SVN, and Sharepoint

Confidential

DWH/BI Consultant

Responsibilities:

• Manage the ETL/Reporting & Testing teams.
• Coordinate with Business Leaders and Project Managers to assure the solutions are complying with business strategies.
• Coordinate with infrastructure teams, operations teams, SA’s, release management and QA teams during upgrades, application delivery, deployment and releases
• Data Analysis & Data Modeling of Data Warehouse physical model (Dims, Facts) - star & snowflake schemas.
• Responsible for defining the complete data warehouse architecture (e.g. ODS, ETL process, Data Marts, EDW).
• Designed, Built & Tested Parallel ETL jobs to load data into dimensions and fact tables using DataStage & QualityStage Designer
• Generated and implemented Microstrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates
• Design & Execute Test plans during Unit Testing as well as UAT & provide production support for the projects

Environment: IBM Information Server 8.1, Ascential DataStage 7.5.x, Designer, Director, Manager, Administrator, Linux, Solaris UNIX, Oracle 10g, SQL,PL/SQL, SQL Plus, Erwin, Micro strategy, Remedy and SAP BAPI.