Data Design

Professional Experience

Profile

Mr. Ligade is a Sr. Consultant within IBM’s Global Business Services’ for Business Analytics & Strategy division. He is a member of the Enterprise Information Management practice which provides data integration, analytics and data warehousing solutions.

Mr. Ligade has vast experience in technology consulting in the area of Data Integration, Business Intelligence, and BI Reporting. He has implemented complex projects in Data Integration technologies using latest ETL & Reporting tools, & complex Data Governance projects, along with significant business analysis experience in Requirements Definition, Modeling, and Architecture Design, Schedule, Scope and Time management.

Before IBM, he has worked with CVS, Apple and Tata Consultancy Services.

Key Skills

Employer History

Informatica, Datastage, Ab Initio, Oracle, Teradata, Netezza, Cognos, Tableau, QlikView, SAP BO, Erwin, MS Project, SQL Server, SSIS

SR. BUSINESS INTELLIGENCE CONSULTANT • IBM • 02/2013– PRESENT

Designed and developed complex BI/Analytics solutions for multinational clients.

Architect, Design and Develop complex Data Models, ETL, Scripts, SQL & BI Reports

Developed KPI/Regulatory dashboards using rigorous data analysis, modeling & ETL

BUSINESS INTELLIGENCE ARCHITECT • CVS CAREMARK • 08/2012 – 12/2012

Performed ETL development and provide SME support for healthcare data warehouse.

Worked collaboratively to design solutions in Teradata SQL, Tableau, and Cognos etc.

REPORTING ANALYST • APPLE INC. • 03/2011 – 10/2011

Performed competitive analysis for top Apple product and suggested business strategies to increase market share.

Coordinated with architects to prepare Data Acquisition, Data Cleansing & Quality Plan.

Designed & Developed executive dashboard for iBook reporting team

BUSINESS INTELLIGENCE CONSULTANT • TCS • 05/2005 – 10/2010

Worked on the ETL Architecture, which primarily used Informatica to move data from varied source systems into targets.

Developed Source Target mappings, Workflows & Shell scripts

Experience Summary

ETL ARCHITECT • IBM • 03/2016 – PRESENT

Product Book of Records (Top HealthCare Insurance Client)

Perform extensive data analysis and coordinate with client teams to develop data model

Develop ETL/SQL code to load data from Raw stages to Staging to Target Netezza DB’s

Develop test plans & perform Integration Testing, QA & UAT to validate client deliverables

BUSINESS INTELLIGENCE DEVELOPER • IBM • 08/2015 – 02/2016

Loan Accounts Reporting Platform (Top Financial Services Client)

Analyzed the reporting requirements with the stakeholders and produced design documentation

Designed Informatica Mappings, Workflows and SQL code for all the ETL data flows.

Developed UNIX shell scripts to automate the ETL workflow initiation and execution.

Worked with the end user team to understand the reporting needs and develop the sql code to populate the data

Design data models and design solutions in Netezza, Informatica, Erwin and Oracle.

BI ARCHITECT • IBM • 02/2014 – 07/2014

Data Governance and Dashboarding (Top Credit Card client)

Enhance & Define Operational Dashboard Requirements & Design.

Pilot the Dashboard Widgets using Tableau/ Excel with real data

Document the design specs for reporting & ETL teams to build the database and ETL constructs needed for automating the dashboards

ETL DEVELOPER • IBM • 02/2013 – 01/2014

Online Marketing using BI/SAS Tools (Top Insurance/Financial Services client)

Worked on several technologies and with cross functional teams to gather business requirements, design solutions and perform rigorous testing.

Worked with the integration teams to design solutions involving message queues, message broker, java, SFDC and test them using Junit, Jenkins etc.

Worked with the ETL teams to design mapping documents and co-ordinate development using informatica, UNIX shell scripting, PL/SQL.

CVS Caremark • 08/2012 - 12/2012

BUSINESS INTELLIGENCE ANALYST

Performed data warehouse development and support for healthcare data warehouse.

Worked collaboratively with business and IT teams and design solutions in Teradata SQL, Tableau, Cognos and other analytical tools as needed, to address business needs.

Proactively ensured that the data warehouse SLAs are met and problems/issues are promptly identified and addressed.

Performed ETL, Reporting and Production Support fixes for the data warehouse operations

Tata Consultancy Services • 03/2005 – 05/2010

Sr. BI Developer

Determined criteria for technical and business data quality checks, error handling and reject reports.

Participated in all phases including data warehouse development life cycle.

Cleaned, transformed and integrated data from the 4 different sources into the ODS.

Developed SCD Type-I, Type-II and Type III mappings for changing dimensions.

Extracted data from legacy systems and uploaded into Oracle data warehouse.

Worked on ETL architecture and data models with client’s data warehouse architect.

Worked on the ETL architecture, which primarily used Informatica to move data from source systems using Oracle, SQL Server, and Flat Files into SQL Server targets.

Analyzed the various subject areas in database along with business analyst

Education

Qualification

Masters (Information Management) in General

Syracuse University, United States of America, 2012

Bachelor of Engineering in Computer Science

Viswersvaraya Technological University, Bangalore, India, 2004

Contact this candidate