Data Analyst
Resume:
Senthil Kumar Alwarsamy
Professional Summary:
** ***** ** ** ********** with extensive Enterprise Data Architecture experience in all different phases of SDLC, Agile Scrum methodology (Certified Scrum Master), Agile lean Kanban methodology (Certified), AWS (AWS Certified solution architect – associate).
Strong expertise in the area of Data Modeling (Certified), Data Profiling, Data Analysis, Data Migration using ETL tools and Data Architecture solutions. Strong hands-on experience in data governance process and data regulations such as GDPR.
Designed and managed Conceptual / logical / physical data models, data dictionary, Generate DDLs for deploying oracle databases. Proficient in successful implementation of Data Models for large scale projects.
Strong expertise in various data profiling techniques i.e., as Column profiling, address profiling, dependency profiling, redundancy profiling, uniqueness profiling etc.
Experience in migrating oracle databases to AWS RDS, designing Data Integration architecture and specifically hands on experience in ERwin r9.6, DB2, Oracle 12c, SAP Business Object Data Services, Informatica Power Center, SAP Information Steward, IDMS, Global Ids.
Strong fundamentals in RDBMS and experience in writing complex SQL queries for high volume report generation in investment banking applications using ORACLE 11g, PL/SQL, data regulations and compliance process.
Developed Enterprise Data lineage Meta Data Management from the scratch, defined the business process to keep this data in sync with project releases (using Graph database model in Neo4j).
Hands on experience in NoSQL database migrations from RDBMS. Oracle 10g (XML documents stored as BLOB) to Mongo DB migration, Oracle 9i databases to Neo4j.
Got trained in BIG DATA technologies such as Hadoop 2.0, Map Reduce, No SQL database technologies such as Mongo DB, Neo4j, RDF, SPARQL.
Knowledge in transforming the legacy source files, raw input extracts, various database storage to centralized AWS Data Lake.
Strong expertise in analyzing business requirements, interpreting UML representations such as Use Case diagrams, Sequence diagrams and component diagrams, translates them to data requirements, and develops conceptual, logical, and physical data models.
Experience in defining complex validation and data cleansing logic in Information Steward Tool.
Experience in creating and managing metadata about source files, data processing.
Experience in Query Performance Tuning, PL/SQL procedure creation, Source System Analysis (System and Data), Data Mapping.
Strong hands on experience in defining the Data Integration strategy and fluency in AWS cloud features.
Education
Degree and Date
Institute
Major and Specialization
Master of Science(Software Engineering, 5 years integrated) – 2005
Coimbatore Institute of Technology, Coimbatore, Tamil Nadu, India
Software Engineering
Employment Summary with Duration and Designation:
Name of the Employer
From
To
Duration
Designation
Cognizant Technology Solutions
07/01/2015
Till date
2 Years 1 months
Architect - Projects
Cognizant Technology Solutions
07/03/2011
06/30/2015
5 years
Senior Associate - Projects
Cognizant Technology Solutions
08/08/2005
07/02/2011
2 years 11months
Associate
Intel Technologies, Bangalore, India
10/15/2004
04/30/2005
6 months
Technology Intern
Malar Electronics, Chennai, India
05/12/2003
11/30/2003
6 months
Technology Intern
OVERALL TECHNICAL SUMMARY:
Software Methodologies
Waterfall model, Agile SCRUM, Lean KANBAN
Data Profiler Tools
SAP Information Steward, Global Ids
Languages/Frameworks Known
C, SAP Business Object Data Services (SAP BODS), PL/SQL, XML, SQL, Eztrieve, Big Data, Core Java, Python, Mainframe, Unix
Databases
Oracle, DB2, Integrated Database Management System (IDMS), AWS RDS, AWS Dynamo DB
Database Tools
ERwin 8.2.08, ERwin 9.6, SQL Developer 3.2, Stored Procedure Builder
Utilities
MSOffice, DFSORT,VSAM
Application Servers
Apache, Tomcat
Version Control and Config tools
Visual source safe, Endeavor, SharePoint
Domain Knowledge
Information Management
CERTIFICATIONS:
AWS certified solution Architect – Associate
Scrum Alliance certified Scrum Master
Team KANBAN practitioner
Cognizant certified Data Modeling – L1
Cognizant certified IDMS Database Developer
IBM DB2 UDB 700
IBM DB2 UDB 703
Cognizant certified DB2 UDB V8.1 developer
IBM System p Administrator
Cognizant certified SAS developer
A Snapshot of Significant Projects
Project Name
Client Name
Role
GDR-DDR-GLR Re-platforming
Dun and Bradstreet, USA
Data Architect
Intelligence Engine – Rules Automation, Globalization
Dun and Bradstreet, USA
Data Architect, Data Modeler
Linkage Discovery Engine
Dun and Bradstreet, USA
Data Modeler
Data Supply Chain Inventory Management (DSC)
Dun and Bradstreet, USA
Data Modeler
Maximize Customer Value (MAXCV) by Data Supply Chain – R1, R2
Dun and Bradstreet, USA
Data Analyst, Data Modeler
Global Input Handler
Dun and Bradstreet, USA
Data Analyst, Data Modeler
Source Profile Data Management
Dun and Bradstreet, UK
Data Modeler, Development Lead
Process control and Operational Efficiency Data Management
Dun and Bradstreet, UK
Data Modeler
Small Business Risk Insight Data Management
Dun and Bradstreet, USA
Mainframe Developer /
Data Analyst
Migration of Auto-Route to Common Data Transfer Services
Depository Trust and Clearing Corporation, USA
Technical Lead
Meta Information Storage Strategic Program
BNY Mellon, USA
Technical Lead
European Database Platform Re-engineering
Dun and Bradstreet, USA
Data Analyst, Data Modeler
Global Monitoring Solution Re-Plat forming
Dun and Bradstreet, UK
Data Analyst, Data Modeler
Portugal Migration for Europe Office System
Dun and Bradstreet, UK
Mainframe Developer /
Data Analyst
E-PORTFOLIO creation for Norway, Sweden, Denmark, Finland (NORDICS)
Dun and Bradstreet, UK
Mainframe Developer /
Data Analyst
Project Details
Data Architect - Cognizant Technology Solutions.
Project
GDR-DDR-GLR Re-platforming,
Data Supply Chain Re-Engineering,
DACoE GSRL Transformation Service
Client
Dun and Bradstreet, USA
Period
Jan 2016 – Till now
Description
This project is to migrate the GDR-DDR-GLR systems from HP Unix to Linux platform with upgraded Java (from 1.4 to 1.7), MQ (from 5 to 8), Oracle versions (9i to 12 C). The data flow architecture for GDR has been migrated from MQ – Transactional processing to Batch File processing. The Oracle databases are migrated from single node to two nodes architecture. As part of this project, a Proof of concept (PoC) has been implemented successfully to align that GDR system work with upgraded software / Hardware architecture.
Role
Data Architect
Contribution
Worked with Solution Architects / business / DBA team to consolidate the database hardware configuration requirements.
Data Integration Strategy documentation
Feasibility study on AWS migration for databases
Analysis on Data lake implementation for GSRLs as S3 objects
Worked to have Hybrid database environment (On-premise, AWS). Migrated database using AWS database migration manager.
Reverse Engineered and created data models
Analyzed AWR reports, OEM metrics for the database performance and Created Indexes for performance improvement.
Unit tested the Java modules, unix shell scripts, PL/SQL procedures for the upgraded platform.
Proposed the design for MQ Loader application and worked with Solution Architect team for review / signoff.
The performance of GDR system got improved more than 300% after this re-platforming.
The GLR system performance got improved more than 200%.
Team Size
6
Data Analyst, Data Modeler - Cognizant Technology Solutions.
Project
Intelligence Engine – Globalization, Rules Automation
Client
Dun and Bradstreet, USA
Period
June 2015 – Dec 2015
Description
This project is to extend the usage of Intelligence Engine (IE) system to new markets such as Mexico, India etc. The IE rule processing are manually coded in PL/SQL programs. So, minor rule changes ended up code changes. From Data Architecture team, new rules database is proposed to store rule configurations and automated the rules. Rule Configuration changes can be done any time in the database without any code change the system rules can be modified.
Role
Data Architect, Data Modeler
Contribution
Worked with business team to understand system’s functional requirements, interpreted the data requirements.
Delivered mapping specifications with accurate details for development team.
Delivered Data Model for Rule automation.
Review and signoff the changes in existing Logical / Physical Data Models for deployment.
Reviewed as well as created multiple Data Mapping Specifications for the ETL team to handle oracle database.
Worked on Erwin to create logical and physical data models for Integration and Data Mart layers.
Reviewed data dictionary that are created for logical and physical data model.
Data mapping with business requirements and Source systems data.
Identify the gaps in model by mapping existing systems model to model attributes.
Analyzed Legacy Source Data volumetric, performance.
Team Size
12
Data Architect, Data Modeler - Cognizant Technology Solutions.
Project
Linkage Discovery Engine
Client
Dun and Bradstreet, USA
Period
Dec 2013 – June-2015
Description
This project is to build a system which automates the processes such as Discovery, Curation and Synthesis that are involved in identifying the Business to Business relationships accurately. This system interacts with multiple systems to access business data and orchestrate linkage creation process. Linkage data is truly global and is represented as family trees. The Linkage data discovery is very complex as related business need to be linked, verified and aggregated.
Role
Data Architect, Data Modeler
Contribution
Worked with business team to understand system’s functional requirements, interpreted the UML diagrams shared by System Architects and identified the data requirements.
Created data management strategy based on data requirements, system architecture.
Delivered mapping specifications with accurate details for development team.
Review and signoff the changes in existing Logical / Physical Data Models for deployment.
Reviewed as well as created multiple Data Mapping Specifications for the ETL team to handle oracle database.
Worked on Erwin to create logical and physical data models for Integration and Data Mart layers.
Reviewed data dictionary that are created for logical and physical data model.
Define the XML control messages for Message Queue communication across systems.
Data mapping with business requirements and Source systems data.
Identify the gaps in model by mapping existing systems model to model attributes.
Analyzed Legacy Source Data volumetric, performance.
Team Size
18
Sr. Data Analyst, Data Modeler - Cognizant Technology Solutions.
Project
Data Supply Chain (DSC) Inventory Management
Client
Dun and Bradstreet, USA
Period
Oct 2012 – Dec 2013
Description
Dun & Bradstreet (D&B) is an information service provider and its customers can get all types of information about a company. Data Supply Chain is multiyear project initiated by D&B to modernize its processes such as collecting data from raw data providers, processing the data within D&B data repositories, delivering the data in D&B products. This project is to identify new raw data sources based on data quality, implement business rules to cleanse, transform data as per D&B standards. This project involved analysis of legacy data stores in IDMS, DB2 and the objective is to replace these legacy data stores with oracle database. This processed data will be exposed to services layer and deliver data in D&B business report products.
Role
Sr. Data Analyst, Data Modeler
Contribution
Managed 5 members offshore Data Analyst (DA) team and ensured all the DA deliverables are meeting the client’s data standards.
In-depth Data Analysis using the data profiling tool SAP Information Steward to calculate worthiness of raw data source.
Performed different types data profile techniques and understood data volumetric.
Understood UML Structural / Behavioral diagrams from system architects and defined the scope of data management.
Worked with solution Architecture team to corroborate data requirements and non-functional system requirements based on data volumetric.
Created data management strategy based on data requirements, system architecture.
Reviewed DDLs created by data analysts to ensure Data Analyst, Data Architecture standards in place.
Worked on Erwin to create logical and physical data models for Integration and Data Mart layers.
Defined the File Layouts, XML control messages for Message Queue communication across systems.
Team Size
12
Sr. Data Analyst, Data Modeler - Cognizant Technology Solutions.
Project
Maximize Customer Value by Data Supply Chain Seeding (MaxCV DSC Seeding)
Client
Dun and Bradstreet, USA
Period
May 2012 – Sep 2012
Description
The project MaxCV DSC Seeding is to transform the Data Supply Chain from the legacy data store to a new and enhanced data stores. Seeding is intended to populate the new topical repositories for data with existing legacy data thus providing the new data supply chain with the initial data needed for further training, testing, and migration of the data supply chain. All legacy data will have information source codes to denote that the data is legacy data. The legacy information source codes will be the last source available to provide data for the best view / Product Ready Data mart.
Role
Sr. Data Analyst, Data Modeler
Contribution
Worked with Legacy system CoE team to collect data requirements and non-functional system requirements based on data volumetric.
Created data management strategy based on data profile analysis, data requirements, system architecture.
Worked on Erwin to create conceptual, logical and physical data models for staging tables.
Performed different types data profile techniques and understood data volumetric and types.
Managed 3 member Data Analyst, Data Architecture (DA) team and ensured all the DA deliverables are meeting the client’s data standards.
Worked in Agile Methodology and defined a strategy to deliver DA artifacts for each iteration release.
Team Size
20+
Data Analyst, Data Modeler - Cognizant Technology Solutions.
Project
Global Input Handler
Client
Dun and Bradstreet, USA
Period
Jul 2011 – May 2012
Description
This project is to build a system called Global Input Handler (GIH) which will enable D&B to process all data sources (online or batch) through a common, flexible technology infrastructure, providing a single source of truth to our customers. It will process all inbound data collected by D&B and load Inventory Data Models. The primary output of the GIH will be pre-processed, standardized data, which will be available for consumption by the subsequent Topical Repositories.
The approach that will be used for this solution is to construct an environment where the Business owner can define a Source Profile, select the applicable Business Rules and the steps to follow (workflow) to process a source record group. Input Handling consists of four logical components:
a.Source On-boarding
b.Pre-processing
c.Identify Record
d.Routing
Role
Data Analyst, Data Modeler
Contribution
Managed 5 member Data Analyst, Data Architecture team and implemented inventory data models.
Designed the flexible configuration parameter driven tables for accommodating changes in business rules and thresholds.
Delivered File layout Specifications, Mapping specifications, XML schemas.
Created Metadata for the source files and performed the Data profile for all sources.
Defined Work Flows and Data Flows for some of the critical Loading components coded in SAP BODS.
Defined Data validation rules in SAP information steward.
Identified and documented the data mapping and complex transformation Logic for the ETL team.
Integrated rules repository where rules can be easily created, tested and debugged.
Interfaces to other components and applications (Match, Cleanse and Standardization, Staging databases)
Team Size
10+
Data Modeler - Cognizant Technology Solutions.
Project
Source Profile Data Management
Client
Dun and Bradstreet, USA
Period
Nov 2009 – Jun 2010
Description
This project is to create a centralized database and manage the meta data about source file details to Input Handler. D&B get hundreds of different source files across markets, topics. The input handler correspond to each market will process these source files and load the topic data mart. By having centralized database, the source files can be classified and processed more efficiently.
Role
Data Modeler
Contribution
Analyzed the source file’s metadata, existing data models used by Input Handlers, File Layouts, and System Interfaces.
Created conceptual / logical / physical data model for the source profile data management.
Created Mapping specifications for the User Interface fields to newly created table columns.
Delivered Logical data flow for the data entered in UI.
Delivered data dictionary for logical and physical data model.
Team Size
4
Data Modeler - Cognizant Technology Solutions.
Project
Process control and Operational Efficiency Data Management
Client
Dun and Bradstreet, USA
Period
Jan 2009 – Oct 2009
Description
This project is to enhance the performance of file input handlers by designing a centralized database for managing the input handler process. This database will control record processing based on the relative priority of the records, batches or the profile instances. It also records critical audit information (e.g., Start Process Timestamp, End Process Timestamp, Transaction Status, Transaction Result) for each loading process from the staging repository to the respective topical repository through Oracle Data Integrator (ODI).
Role
Data Modeler
Contribution
Analyzed the process details in each input handler, existing data models used by Input Handlers, File Layouts, and System Interfaces.
Created conceptual / logical / physical data model. .
Created Mapping specifications for the created table columns that need to be logged by input handlers while processing a source file.
Delivered data dictionary for logical and physical data model.
Team Size
2
Developer / Data Analyst, Cognizant Technology Solutions
Project
Small Business Risk Insight Data Management (SBRI)
Client
Dun and Bradstreet, USA
Period
Jun 2008 – Dec 2008
Description
This project is to get data feed from mainframe system and maintain in Oracle Data Mart. Small Business Risk Insight (SBRI) is a system in Mainframe environment to calculate the risk score for business. The scope of the project is to identify the elements that need to be maintained in ODS and create database for data management.
Role
Data Modeler
Contribution
Analyzed the data usage of elements in Mainframe DB2 database, existing data models used by SBRI, File Layouts, and System Interfaces.
Monitored the production system and implemented mainframe solutions for the production issues.
Team Size
5
Technical Lead, Cognizant Technology Solutions.
Project
Migration of Auto-Route to Common Data Transfer Services
Client
Depository Trust and Clearing Corporation, USA
Period
Jan 2008 – May 2008
Description
The goal of this project is to migrate the AutoRoute legacy system by incorporating all its functionality into the CDTS (Common Data Transfer Services) platform (as stated in the 2008 Stakeholder/Financial Corporate Goals). The AutoRoute system was in sourced from SIAC and was designed to provide a standardized way of distributing files and reports from NSCC, NYSE, AMEX, MBSCC, GSCC & SIAC applications. The existing file processing, monitoring, setup and maintenance functionalities are being modified by CDTS functionalities. All AutoRoute meta data is to be converted to Subscriptions, Profile, Destination & Node data. The source for all reports generated for AutoRoute is being modified.
Role
Technical Lead
Contribution
Requirements Analysis
Design document creation
Created Data Migration Strategy
Weekly Status Report Creation
Coordinate with QA Testing teams
2 member Team Management
Team Size
3
Technical Lead, Cognizant Technology Solutions.
Project
Meta Information Storage Strategic Program
Client
Depository Trust and Clearing Corporation, USA
Period
Jul 2007 – Jan 2008
Description
This project involves maintenance of CICS online transaction, which is used to maintain the Tax DB2 tables. The project follows the onsite-offshore model, which means the enhancement requested by clients will be worked on from offshore as well as onsite. The project includes analysis and solution proposition of service requests raised by business users. Service Request is basically a change or enhancement that is driven by business or another application.
Role
Technical Lead
Contribution
Service Request Analysis
Design document creation
Weekly Status Report Creation
Coordinate with QA Testing teams
3 member Team Management
Team Size
4
Data Modeler - Cognizant Technology Solutions.
Project
European Database Platform Re-engineering
Client
Dun and Bradstreet, UK
Period
Feb 2007 – Jun 2007
Description
European Database Platform Re-engineering (EDPR) Program is a system migration program from Mainframe environment to ODS. The scope of the project is to migrate the IDMS and DB2 databases in mainframe to Oracle Technology in Unix Platform. The database such as Public Notices (PNDB) and European Statements (ESDB) are using IDMS technology and contains events and financial information. The Granular Database (GRDB) in DB2 technology contains all the in-depth financial information about the European companies. The objective of the project is to move the daily input bulk load file processing system in mainframe to ETL in Data warehousing without impacting the other systems in mainframe. The data in mainframe databases are to be unloaded, transformed as per the proposed database model and loaded in the ORACLE ODS.
Role
Data Modeler
Contribution
Created conceptual / logical / physical data model.
Analyzed the data usage of elements in Mainframe DB2 database, existing data models used, File Layouts, and System Interfaces.
Created a Rules document to consolidate the validation and data transformation rules.
Created Mapping specifications for the legacy data source IDMS, DB2 elements to target ODS columns.
Delivered data dictionary for logical and physical data model.
Team Size
6
Data Modeler - Cognizant Technology Solutions.
Project
Global Monitoring Solution Re-Plat forming
Client
Dun and Bradstreet, UK
Period
Dec 2006 – Feb 2007
Description
Dun & Bradstreet’s (D&B’s) customers can monitor a business by registering in DBAI (online portal for customers). Global Monitoring System (GMS) is database system (DB2) in which the registrations to monitor the business are being maintained. The database contains details about the customers, business and the registrations. This system has COBOL – DB2 stored procedures and mainframe batch applications. The stored procedures were created to add /update registration, customer and business details. To improve the performance in this system, the DB2 database has been changed with the ORACLE with different data model. The mainframe batch applications were modified to act in accordance with the database change.
Role
Data Modeler
Contribution
Created a Rules document after analyzing the mainframe DB2-COBOL stored procedures. to consolidate the validation and data transformation rules.
Created Mapping specifications for the legacy data source DB2 elements to target ODS columns.
Created conceptual / logical / physical data model.
Analyzed the data usage of elements in Mainframe DB2 database, File Layouts, and System Interfaces.
Delivered data dictionary for logical and physical data model.
Team Size
8
Developer / Data Analyst, Cognizant Technology Solutions
Project
Portugal Transition
Client
Dun and Bradstreet, UK
Period
Feb 2006 – Oct 2006
Description
This project is to migrate all the Portugal business information from EOS databases (IDMS) to Oracle Data Store. The impacts of the data removal had identified on Batch applications as well as online transactions. The Batch applications which were dedicated to Portugal data processing had put into Pending status and the applications which process Portugal data along with other EOS countries data has to be modified to suit with the Business Requirement. The impacted Online Transactions were identified and informed to their respective Informa teams (D&B’s Partner) about its usage.
Position
Developer / Data Analyst
Contribution
Created Mapping Specification to map the legacy source data elements to newly defined Oracle Data Store columns.
Legacy Mainframe Data analysis.
Written C program to parse unstructured large data chunks and convert the data into delimited structured elements.
Uploaded the data into a warehouse through automated process
Automated the FTP flows using mainframe tools.
Team Size
3
Developer / Data Analyst, Cognizant Technology Solutions
Project
E-PORTFOLIO creation for Norway, Sweden, Denmark, Finland (NORDICS)
Client
Dun and Bradstreet, UK
Period
Sep 2005 – Jan 2006
Description
This project was to get the credit recommendation data from the E-PORTFOLIO (EPR) database and send it with the existing European Office System (EOS) extract data feed to other systems. This helped D&B to eliminate the manual work because of the data inconsistency in Credit control.
Position
Developer / Data Analyst
Contribution
Data cleaning, extraction, data exploration and analysis
Uploaded the data into a warehouse through automated process
Created PL / SQL procedures to automate some of the data analysis such as name match, address match etc.
Team Size
4
Contact this candidate