SUMMARY

• Around 11 years of experience in Data Modeling, Data Quality, Data Analysis, Business Analysis, Data Governance, Data Warehousing, Master Data Management (MDM) and Data Mining, specializes in Erwin, IBM Infosphere DataStage and Quality Stage 8.5/8.7/9.1, IBM Infosphere Information Analyser 8.5/9.1, SPSS Clementine, Oracle Data Miner 11g and Collibra DGC 4.5 with databases such as Oracle, DB2, TeraData and emphasis on designing, development, testing and analysis tools and technologies.
• Experience in Data Life Cycle Process like data modeling, data quality, data cleaning, data architecture, data integration, data transformation (ETL Process), data mining (pattern recognition), data governance, reporting, database testing, pattern recognition, predictive modeling and knowledge presentation.
• Experience in Insurance, Finance, Banking, E - Commerce, logistics, Retail Domains and In-depth understanding in Business Intelligence, Data Warehousing, Data Mining and RDBMS.
• Experience in working in Agile Scrum methodology of SDLC. Experience in planning and execution of Sprint and in-depth understanding of JIRA, Wiki and Confluence.
• Experience in requirement gathering, requirement analysis, creating user stories, business requirements, business rules, and converting the requirements to draft technical specification.
• Experience in designing conceptual systems through data modeling by creating Use Case Diagrams, UML Diagrams, Workflow Diagrams, State Chart Diagrams, ER Diagrams, Schemas (Star, Snowflake, Galaxy), Sequential Diagrams and Deployment Diagrams using ERwin and MS Visio.
• Experience in creating Project Plans, Resource Utilization and Occupancy Reports, Source to Target Mapping Documents, Business Requirement Documents, Technical Design Documents, Interface Design Documents, Test Plan Documents and Test Execution Documents.
• Experience in creation, manipulation and updating huge voluminous databases, stored procedures, database partitions (fragmentation and integration), SQL queries, aggregate functions and load data into data warehouse through PL/SQL, Oracle Developer and ETL tools like IBM Infosphere DataStage and QualityStage.
• Experience in designing/modeling and developing Data Mining techniques like Regression, Association Rules, Decision Support System, Market Basket Analysis and K-means clustering using Oracle Data Miner 11g R2 and SPSS Clementine.
• Experience in creating reference data and master data repositories to facilitate MDM, Experience in Data Lineage and Data Governance by developing and deploying workflows in Eclipse and Collibra DGC 4.5.
• Experience in Stakeholder management, setting up of Steering committees, Data Governance Stewardship and Ownership.
• Experience in Research and Development in Data Mining and Data Warehousing to gather, design, analyze, simulate and propose efficient algorithms for the given scenario.
• Experience in Data Profiling (Column Analysis, Primary Key Analysis, Foreign Key Analysis, Referential Integrity analysis, Cross Domain Analysis) and creating Rules and Rule sets using IBM Infosphere Information Analyzer.
• Experience in creating Jobs, Sequencer and Master Sequencer for data integration and data transformation using IBM Infosphere DataStage and QualityStage.
• Experience in managing team under different phases of Software development life cycle.
• Delivered Knowledge Sessions on various concepts of Data Warehousing, Data Mining, Business Analysis, Business Environment, Market Analysis, Consumer Behavior, Market Positioning, Product Development Life Cycle, Software Development Life Cycle, etc.
• Work with Business end-users to draft reporting functional design and implementation of activities for a specific business process.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, J2EE, C#, PL/SQL.

Database: Oracle 9i/10g/11i, MS Access 2007, IBM DB2, TeraData.

Operating System: MS Windows 98/200/XP/Vista/7, LINUX (Redhat 8).

ETL Tools: IBM Infosphere DataStage and Quality Stage 8.5/8.7/9.1.

Profiling Tools: IBM Infosphere Information Analyser 8.5/9.1.

Governance Tools: Collibra DGC 4.5, IBM Infosphere Business Glossary 8.5.

Analytical Tools: Oracle Data Miner 11g R2, SPSS Clementine.

Simulation Tools: MatLab 6.5, Weka.

Scheduling Tools: Cisco Tidal Scheduler.

Other Tools: ERwin, MS Office 97/2000/2007 , MS Project 2007, MS Visio 2007.

PROFESSIONAL EXPERIENCE

Sr Data/Business Analyst

Confidential, California

Responsibilities:

• Responsible for gathering requirements from various supporting systems like the finance, legal, marketing, sales, procurement, operations and the customer insight departments.
• Analyze the current business process and create Use Cases, Context Diagram, Sequential Diagram to define the future state objectives.
• Responsible for achieving Data Lineage and Data Governance by developing and deploying workflows in Eclipse and Collibra DGC 4.5
• Responsible for organizing daily scrum calls to monitor the progress and to identify the road blockers.
• Responsible for designing and executing the sprint deliverables and grooming the associates for code development process.
• Performing impact analysis on supporting sub systems.
• Defining Business Terms, Domain, Attribute, Relationship, Community, Business Line of Business in Collibra DGC 4.5 and Designing workflows process using Eclipse Activiti.
• Document Data Governance process, Steering Committee findings. Set up Data Governance council, identify Data Stewards, Data Owners and Business Owners and defining the roles and responsibilities.
• Responsible for felicitating stakeholder requirements in identifying the current state business process and designing the future state objectives and execution process.
• Responsible for coordinating between onshore and offshore teams.
• Responsible for creating Assets, Attributes, Domain, Community, Relation Types, Business Processes, Business Terms and Business Users.
• Perform Completeness, Conformity, Validity, Accuracy and Uniqueness dimensions on Source data.
• Actively participating in management meetings to streamline software development life cycle and mitigating risk.

Project Lead

Confidential

Responsibilities:

• Responsible for gathering requirements from onsite Delivery managers.
• Responsible for analyzing source data, perform pre-perquisites for Data Profiling and creating a project in IMB Infosphere Information Analyzer version 9.1.
• Responsible for guiding the associates to perform Column Analysis, Primary Key Analysis, Foreign Key Analysis, Referential Integrity Analysis in IMB Infosphere Information Analyzer version 9.1.
• Designing and developing Business Rules in IMB Infosphere Information Analyzer version 9.1 on source data to attain Data Quality Dimension Scores for Critical Data Elements.
• Perform Completeness, Conformity, Validity, Accuracy and Uniqueness dimensions on Source data.
• Responsible for delivering and presenting Data Quality Dimension Scores, Compliance and Non-Compliance Reports to the Delivery Managers and Project Owners.
• Responsible for designing Master Sequencer and jobs for data integration and data transformations using IBM Infosphere Data Stage and Quality Stage 9.1.
• Responsible for designing workflows in Eclipse and deploying the workflows in Collibra DGC 4.5 to achieve data governance process.
• Conduct Knowledge Transfer sessions to the associates on Data Modeling, Data Warehousing, Data Quality, Data Governance and Data Mining.
• Responsible for creating Assets, Attributes, Domain, Business Terms, Business Users, Community, Referential Data Accelerators, Code Lists and Code Values in Collibra DGC 4.5 for various business process.
• Responsible for migrating Assets, Relationships, Attributes, Domains and Communities from Collibra DGC 4.5 to IBM Infosphere Business Glossary 8.5 under various environments.
• Creating reference data and master data repositories to facilitate MDM process.
• Responsible for monitoring Data Linage to achieve business MDM functionality for reporting needs.
• Perform Quality Analysis using Unit Test Plan and Negative Testing on data to check data consistency after integration at various levels of Data Transformation.
• Responsible for peer review of Assessed data and perform IMR analysis as a part of Root Cause Analysis for redundant data.
• Responsible for reviewing Data Quality Dashboards using QlikView to demonstrate the column profiling and assessment results to the Business Owners.

Senior Data Analyst

Confidential

Responsibilities:

• Designed Master Sequencer in IMB Infosphere DataStage version 8.7 to automate the process of data load and data transformation form source systems.
• Designed jobs inside Master Sequencer to load data from various sources, integrate and transform data based on STTM document provided by the business.
• Design and draft the workflow and data flow sequence diagrams at conceptual level and guide the associates about the process.
• Perform Data Profiling on the source data using IBM Infosphere Information Analyzer 8.7 to analyze the data.
• Build Master data and reference data repository as a part of MDM process.
• Develop scheduling platform using Tidal Scheduler to automate the DataStage jobs for loading the source data in regular intervals.
• Responsible for migrating the data in different environments and audit the data consistency during migration process.
• Creating Data Modeling using ERwin to build an enterprise structure for data warehousing.
• Perform Quality Analysis using Unit Test Plan and Negative Testing on data to check data consistency after integration at various levels of Data Transformation.
• Create master data linage felicitating MDM functionalities as a part of reporting process.
• Identify the Business Assets, Business Domains and Business Process and set up the Data Governance standards for business approved terms of CAT Insurance using Collibra DGC 4.5.
• Input Community, Domain, Assets, Attribute and Relationship in Collibra DGC 4.5 anlso set up of Reference Data Accelerator to achieve business glossary.
• Create Terms and Linage in IBM Infosphere Business Glossary 8.7 to build uniqueness and bonding of business terms over enterprise level.
• Manage metadata in IBM Infosphere Metadata Workbench 8.7 to create a cross functionality metadata platform for all tools in IBM Infosphere suite.
• Actively participating in management meetings to streamline software development life cycle and mitigating risk.

Assistant Manager

Confidential

Responsibilities:

• Setup and follow Agile Scrum methodology. Organized daily and weekly scrum calls. Initiated and executed Spring plan.
• Setup meeting with various business partners to gather the business requirements and business model.
• Responsible for guiding the team to profile and analyze the source data using IBM Infosphere Information Analyzer version 8.5.
• Performed the root cause analysis on the quality of the source data and generated dashboard reports capturing the completeness, conformity, validity, accuracy and uniqueness of the data.
• Delegate different roles and responsibilities necessary to ensure timely completion of the projects analyzing the possibilities of resource and system risks.
• Gather requirements, draft STTM, design schemas, create databases and populate databases with appropriate data for various line of business.
• Design and Develop functions, stored procedures, data cubes, data marts, databases and materialized views for both OLAP and OLTP process of E-Commerce business partners.
• Develop efficient statistical models in Oracle Data Miner 11g and SPSS Clementine such as Association Rules, Regression, K - Means Clustering (based on the Test Condition) to analyze the Online Transactional Process.
• Responsible for predicting and forecasting business trends based on outcome of analysis reports from R2 using Regression and Correlation Analysis.
• Responsible for creating test plans, test cases, Unit Testing, System Integration testing, User Acceptance Testing and reviewing the deliverables.
• Identify potential market segment, market needs and demands, consumer behavior and propose business plans and business proposals for business partners based on the analyzed data to position the product in the market.
• Analyze and predict the future trends in Product Development Life Cycle and guide the associates in analyzing the market trends.

Data Warehouse Analyst

Confidential

Responsibilities:

• Perform pre - processing data techniques like data cleaning, data evaluation and data profiling on the transactional database to achieve data quality for statistical analysis of data.
• Perform aggregate functions (sum, average, count, minimum and maximum) on the database and generate data cube reports to analyze the business.
• Design conceptual and logical Data Warehouse schemas using ERWin.
• Responsible for Normalizing and de normalizing of the databases to felicitate data integrity and data synchronization.
• Create Materialized Views by fragmenting the Data Warehouse to generate Data Cubes.
• Develop Data Cubes to analyze the business pattern by slicing and dicing based on parameters like location, time and geography.
• Creating Data Marts for Credit Risk Line of Business and inspecting the quality of data in the marts to felicitate analysis.
• Identify the Target Class and analyze the interesting knowledge in the target class based on various aspects such as region, income range, loan period, pay frequency, returns, etc.
• Generate periodic reports (weekly, monthly, quarterly and yearly) on the target class to calculate the predictive analysis on Return On Investment (ROI) of the company.
• Actively participate in meetings with the management to explain the statistical analysis results and to streamline the company process.

Assistant Research Analyst

Confidential

Responsibilities:

• Perform requirement analysis, identify the use cases, create Use case models and sequential models.
• Identify the problem definition in existing process, perform gap analysis, create problem solution objectives as a part of solution for future state process.
• Pre-process data by profiling the data and cleaning anomalies and redundancy.
• Design, develop and deploy methodologies to generate optimal solutions by analyzing the pattern in the historical data.
• Design predictive and descriptive statistical models and evaluate the performance of the model.
• Perform Association rules techniques (Market Basket Analysis), evaluate Decision Support Systems (Decision Trees), AB Testing, Regression Testing using SPSS Clementine and Oracle Data Miner 11g.
• Create Data Cubes based on business requirement variables using MSBIDS.
• Document the proposed methodology for publication at various research conferences.
• Participate actively in International Conference and present research ideas.