Data Architect / Data Warehouse Architect / Senior Data Modeler / Data Analyst

Career Summary:

Confidential is a quick learner capable of understanding complicated logic quickly independent of his own experience. He has strong analytical, interpersonal communication skills. He can work in a team or as an independent performer with minimal or no supervision. He played key roles in projects where the team size varied from five to more than fifty. He has complete knowledge of information management and end-to-end data movement in an enterprise environment. He has demonstrated experience working and managing terabyte size datasets. He has participated and played key roles in multiple data migrations, upgrades, reverse engineering, data integration and information assurance/security projects. He has been with IT industry for nearly twenty years, worked more than a decade in data / information management. He has written many tools, processors and programs. Kannan has good knowledge and experience in Data Architecture. If you are looking for a candidate with good experience and expertise in data architecture/ management, Data Warehouse capabilities, he will be the best fit for the position. He can comfortably play the role of Data Architect / Data Warehouse Architect / Sr. Data Modeler / Sr. Database Administrator.

Skills Summary:

• Experienced in creating application logical architecture models and documenting the current state architecture for the enterprise
• Experienced in Entity Relationship diagrams, Conceptual, Logical Physical data modeling
• Experienced in relational and dimensional modeling using CA ERwin Data Modeler
• Experienced in distributed and mainframe applications
• Developed process, standards, best practices, naming standards for various data management environments
• Designed and implemented 24X7 available databases for business applications
• Designed and executed Disaster Recovery, Business Contingency/Continuity Plans
• Experienced in designing and building OLTP, Operational Data Store ODS , Data Mart and Data Warehouse OLAP environments
• Experienced in complete data management life cycle logical, physical data modeling, database design, development, implementation and monitoring, 24X7 production support, performance tuning, archiving/decommission
• Have strong knowledge and experience in Data Mart and Data Warehouse Architecture
• Experienced in managing large size datasets multi-terabyte data management and performance tuning
• Experienced in Database migration, Data migration, Data integration and reverse Engineering
• Experienced in MS SQL Server, Oracle, IBM DB2 for z/OS and LUW Database management
• Experienced in MS SQL Server Backup and Recovery, SSIS, MS SQL High Availability Disaster Recovery Solutions such as Mirroring, Log Shipping, Replication, Clustering, AlwaysON
• Experienced in upgrade/version migration activities and explored the opportunity to identify and utilize the improvements
• IBM Certified Solutions Expert and Certified Database Administrator for DB2
• Developed many in house tools to automate / ease /speed up the manual process
• Experienced in phased, agile development methodology, handling multiple projects at any given time
• Estimated, planned, scheduled, coordinated, executed/implemented and monitored database development to production for many business applications
• Migrated, supported and coordinated number of data management applications in an onsite offshore model for more than a year and achieved excellent client satisfaction
• Estimated, planned and executed/implemented data movement activity across multiple environments like production to development, quality assurance, system testing, integration, model etc.
• Experienced in end to end data flow in an enterprise environment, data movement/transformation/ integration, metadata, reference data management, information assurance/security
• Experienced in SOA, XML, Data Flow Diagrams, UML Data Modeling and Enterprise Application Integration EAI technologies
• Have knowledge on Netezza data warehouse appliance

Technical Trainings:

• Diploma in Relational Data Base Management System with Oracle 7.1 1996-97
• Completed formal training in Java, JavaScript, HTML, JSP, ASP and IIS 1999
• IBM DB2 Database Administration and Backup Recovery Workshop S/390 from IBM, USA 2000
• IBM DB2 Database Management Tool BMC S/390 from BMC, USA September 2000
• IBM DB2 Database Management Tool CA-Platinum S/390 from CA, USA May 2001
• IBM DB2 UDB Administration for Linux, UNIX Windows from IBM, India May 2005
• Trained on Informatica 9.x MDM Hub, PowerCenter, Data Analyst, and Data Quality 2013

IT Consultant / Sr. Database Analyst / Modeler / Administrator

Confidential

Confidential is working for IBM as a consultant/contractor supporting United States Federal Government healthcare client Centers for Medicare and Medicaid Services CMS . Integrated Data Repository IDR is a central Data Warehouse for CMS. It has around 600 terabytes of data, soon expected to grow into 700 terabytes. It has 800 tables and combined count of 15,000 columns. With Medicare Access Layer 1.1 reduced the tables down to 18 with 1,200 often used columns.

Tools Environment: CA Erwin Data Modeler r9.5, DB2, Teradata 14.0, SAS/EBI Web Report Studio, AMO, Enterprise Guide 5.1, SQL Assistant etc.

Responsibilities: Data Modeling, Data analysis for United States Federal Government client CMS.

IT Consultant / Systems Architect / Data Architect

Confidential

• Confidential is a nonprofit organization. Documenting the current state architecture will help transform the enterprise to respond to changes, new regulatory compliance or to create road maps for the desired future state. This is a major initiative for the organization to create the enterprise architecture model for efficient, effective IT and business governance. All the business functions and associated business processes were documented. Business process models were created and linked to business applications, database etc.
• Tools Environment: Business applications across the enterprise involving Microsoft Access, SQL Server, Oracle, Teradata and DB2 databases, customized vendor applications, infrastructure applications, software products and all their associated architecture across the enterprise, CA ERwin Data Modeler r7, Microsoft Visio, SharePoint etc.
• Responsibilities: Analyze all applications across the enterprise to create logical application architecture model with presentation, application, integration, data layers wherever applicable and document the current state architecture. The area of exploration involves all the applications running on mainframes, server and desktop environments across the enterprise digital landscape. Reverse engineered all the databases across the enterprise and data models were created using CA ERwin Data Modeler. Data models were associated with the respective application.
• Project achievements: More than 200 applications across the enterprise were analyzed and created application logical architecture model for every one of them identifying the all the integration touch points, data stores etc. per client standards, and guidelines. All the applications across the enterprise were categorized and standardized their naming. All the databases across the enterprise were reverse engineered data models were created using CA ERwin Data Modeler and associated with the respective application. Enterprise Architecture Repository with all the information and its relationship were created part of the project effort. All the linking between database-application-business functions- business process were established. The services definitions were created, enterprise level functional views were created for each business unit. Almost all the necessary information's were collected to create the enterprise data model for the organization.

Consultant / Sr. Database Administrator / Modeler

Confidential

Project: Confidential Perumal worked on multiple projects on demand and allocation for the Data Management Group. Environment: CA Erwin Data Modeler r4 r7 , MS SQL Server 2005, 2008 R2, Change Data Capture CDC , T-SQL Stored procedures, SQL Server Management Studio SSMS , SQL Server Profiler, IBM DB2 Admin Tool, IBM High-Performance Unload, OMEGAMON Performance Monitor , VT Transparency, Secure Data from Voltage, SQL, DB2 V8.1/10.1 on the z/OS V1.1, DB2 Connect, SAP Business Objects, Abinito, Visual Explain for DB2 z/OS, Oracle 10g/11g, PL/SQL Stored procedures

Responsibilities: Organize JAD session with the business users, stake holders to capture the business requirements and business rules to create conceptual models, get it reviewed, approved by the business, maintaining data models. Develop platform specific physical data model adhering to the client standards, install and configure Microsoft SQL Server database and provide database administration support create/alter/drop database objects , database monitoring, tuning, capacity planning, support non-production/production support for internal applications and COTS products, provide database support for DB2 database on the mainframes. Maintain data quality and integrity in databases. Help out the Business Intelligence team help setting up connection to the databases etc. Integrate metadata to ETL tools from CA Erwin data modeler

Achievements: Handled five to six projects that follow agile, standard development methodology. Created logical data models based on the user requirements, converting them to physical models per client standards followed by physical object creation and migrated the objects across the all development environments. Installed configured MS SQL Server database software, associated database tools. Done estimation and planning for disk storage requirements for database software, database files needs. Developed, tested implemented a robust database backup and recovery strategy. Identified large databases objects and included compression to save disk spaces. Set up log shipping, database mirroring to support high availability databases. Created data and Index partitioned large tables in SQL Server 2008 R2 in file groups. Performed data refresh across other non-production environments, performed database recoveries as per requirements. Designed and developed Operational Data Store ODS databases, information security PCI compliance database objects, architected 24X7 high-availability databases resolved database related application program problems and gave suggestion to improve efficiency. Worked with ETL developers to move data from the operational environment to Central Data Warehouse provided application database administration support for IBM DB2 on the z/OS environment, developed space utilization tracking using the database catalog information, designed and implemented high available 24X7 databases on the mainframe environment.

Consultant / Sr. Database Administrator

Confidential

Responsibilities: Database Administration support for pre-production development, UAT, Integration, System and QA and production environment for Child Support Enforcement CARES applications. Supporting Cobol/DB2 Stored procedures, QMF queries, data archival process and supporting the application team day to day activities. Participating in database changes for regular release

Environment: OMEGAMON, QMF, QMF for Windows, CA-Platinum suite of products, JCL, SQL, DB2 V8.1 on the z/OS, DB2 Connect, Visual Explain for DB2 z/OS, SQL Stored procedures, IBM DB2 Utilities Mainframe utilities

Consultant / Sr. Database Administrator Confidential

Project: General DBA support for pre-production development, UAT, Integration, System and QA and production environment for the application team.

Tools: OMEGAMON, IBM Data Studio, IBM SQL Q Replication.

Environment: z/OS, JCL, SQL, DB2 V9.1 on the z/OS, DB2 Connect, Visual Explain for DB2 z/OS, Cobol/SQL Stored procedures, IBM DB2 Utilities Mainframe utilities

Consultant / Sr. Database Administrator Confidential

Project: Confidential Perumal worked on multiple projects on demand and allocation for the Data Management Group. Tools Environment: CA Erwin Data Modeler r4, Microsoft SQL Server 2000/2005, SQL Query Analyzer, SQL Server Management Studio SSMS , T/SQL stored procedure, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Analysis Services SSAS , Microsoft SQL Server Reporting Services SSRS , DB2 V7.1/V8.1 on the z/OS V1.9, IBM DB2 Admin Tool, IBM High-Performance Unload, OMEGAMON, REXX, JCL, SQL, DB2 Connect, Cobol / SQL Stored procedures, Oracle 9i/10g etc.

Responsibilities: Work responsibilities includes but not limited to supporting multiple projects on multiple database environments such as MS SQL Server, DB2 and Oracle. Supporting database platforms and ensure database design, creation, and generation per client standards, processes, and procedures. Model, Design, develop and implement database solution for applications and develop database. Install / create / alter / drop database objects, support non-production/production environments for internal applications and COTS products, performance tuning, space monitoring, capacity planning, requirement gathering to create logical model, physical model and implementing database solution for applications and develop database. Provide support to the application all the way to production. Maintain data quality and integrity in databases. Provide support to the development team with design, performance related bottlenecks. Help out the business intelligence queries that connect to the mainframes, help to setup connection to the databases and generate the reports using SAP Business Objects etc. Establish processes, procedures, and best practices

Achievements: As a database administrator installed Microsoft SQL Server 2000/2005 on new window 2003 servers, migrated data from old windows server to the new server. Created new database, file groups, users, altered, added data files, scheduled database backups and recovery plans, converted Oracle, MS Access databases to SQL Server, designed and developed DTS packages and scheduled to data pull from Oracle and other database. Developed a detailed process plan to redesign / repartition 24X7X365 terabyte size critical table with less than five minutes down time which was earlier planned to take the database table offline for more than a day. Designed and developed an automated process using REXX/JCL skeleton to truncate list of mainframe DB2 pre-production tables which had non-public information in them. Developed logical, physical data models and got them implemented in pre-production environments and successfully moved to the production environment in SQL Server and DB2 database environments. Kannan provided application database administration support for IBM DB2 on the z/OS environment. Designed and developed 24 X 7 X 365 availability tables with near zero down time for many projects which has complete data load everyday load replace . Participated in BEA Aqua Logic Service Bus installation process where the tables that were installed on the database now Oracle Service Bus/Oracle ESB tables in the database tables. BEA Aqua Logic Service Bus allows the interaction between services, routing relationships, transformations, and policies. Designed and implemented 24X7 high-availability databases in DB2 on the mainframes. Provided database access control, created naming standards resolved database related application program problems and provided suggestion to improve efficiency. Done performance tuning - Tuned many stored procedures, SQL queries for batch and online. Designed and developed the first SQL procedure process in the DB2 for z/OS mainframe environment converted from the Teradata stored procedures and set it up without any off the shelf tools like IBM Stored Procedure Builder or Data Studio. Participated and helped metadata repository tool ASG-Rochade installation.

Consultant / Data Warehouse Architect / Administrator Oracle Financial Services Software Limited / Deutsche

Confidential

Tools Environment: SQL Explain, DB2 Connect OMEGAMON, COBOL, REXX, JCL, DB2 V7.1/V8.1 on the z/OS V1.4, DB2 8.1 on LUW, SQL Stored Procedures, CA Data Management tools.

CTM helps in compliance monitoring of all the transactions made through Deutsche Bank all around the world. All transaction data from various transaction systems are integrated and loaded to the Central Data Warehouse CDW via ETL batch process. CDW helps the compliance department executives and regulatory authorities to check for the compliance of all the transactions for any illegal activity such as anti-money laundering ATM . Business Intelligence reporting tool IBM Cognos generated reports for the compliance officers.

Responsibilities: Responsibilities includes but not limited to architecting the data warehouse, implementing and supporting the physical database, manage new change requests

Achievements: Involved in architecting the data warehouse, ETL process, implemented the star schema model. Done performance tuning on many batch programs, data warehouse report queries and showed good improvement. Designed and developed a tool to make rough comparison between database objects across different environments. Involved in database version migration and suggested improvements. Resolved data movement issues, providing suggestion for improvement, regular SQL review for reports, performance tuning etc. Data refresh activity across different regions in pre-production environments etc. Administered the physical database, maintained the data model and implement the change requests. Tuned data warehouse query that involved four tables with 800 million records and one table with billion records that brought down the Cognos server and got it run under three minutes.

Systems Engineer / Database Engineer / Data Modeler / Onsite coordinator Confidential

Tools Environment: CA Platinum, RC/Migrator, RC/Query, RC/Update, RC/Extract, CA Database Analyzer, CA Plan Analyzer, CA-Log Analyzer, CA Detector, CA-7, CA-Endevor, CA Insight Performance Monitor, CA-Erwin 4, SQL Explain, OMEGAMON BMC's Catalogue Manager, DASD Manager, Recovery Manager, BMC Logmaster, COBOL, Datastage, Change Data Capture CDC , CLIST, REXX, JCL, SQL, Easytrieve, VSAM, IMS, DB2 V5.1 on S/390, DB2 V7.1 on the z/OS Data Warehouse Edition

Kannan, as a Lead Database Engineer working for the data engineering group supported pre-production and production environments. Under GSSM umbrella designed, built and supported Data Marts and many OLTP databases. GSSM had many ODS, OLTP applications such as Vehicle Order Management VOM , Vehicle Order Generation VOG , Vehicle Information Database VID , Customer Delivery Report CDR , Dealer Information Database DID , fleet forecasting etc. Kannan participated in building the Data Mart to analyze Vehicle Order management and fleet forecasting.

Responsibilities:

• Organize business user meetings, understand the business requirements, create the conceptual modeling with Entity-Relationship diagrams, get it reviewed and approved them model from the business. Create logical data model followed by physical database specific models and development of physical objects, database access management, solve database related application program problems and give suggestion for improvement, SQL query tuning, maintain database integrity, data refresh across different regions such as from prod to test or model office, performing proper backup and if required performing recovery, plan and participate in disaster recovery drill, hardware/software migration validation, participate in application implementation, proactive and reactive run time improvements for production transactions / application programs, create source to target mapping, document the database information in application documentation etc. for all applications under the Global Sales Service and Marketing umbrella.
• Database Software Services: Testing tools both internal / external and provide ongoing support. Create, implement, promote, document Internal Standards for the enterprise
• Production database maintenance: Performing regular health check like space allocation, fragmentation, performance monitoring and tuning, creating disaster recovery plans participating in disaster recovery drills to validate the recovery strategy. Advise and assist in application database recovery whenever required. On call support 24x7, backup, recovery on request. Create, promote, schedule in CA7 and support DBA maintenance jobs

Achievements: Analyzed and redesigned the job scheduling to reduce the database maintenance window reduced the database downtime. Designed and implemented data refresh/migration activity across multiple environments like production to development, quality assurance, system testing, integration, model office etc. When a fellow team member caused an outage the client removed the individual and wanted someone else to take the responsibility immediately. Kannan took over the application and made many modification and process improvements to get good name for the team. Given data modeling, data management training for juniors in the shop and mentored them. Designed, documented and implemented new process to change the existing monthly data purge/archival process which saved thousands of dollars and reduced the purge window. Designed and implemented a new process to change the existing database reorganization process and changed database reorganization schedule. The new approach not only improved the performance for many application programs/ transactions it also narrowed down the maintenance window and saved several thousand dollars per year for the client. Managed, supported and coordinated number of data management applications in an onsite Troy, MI offshore Chennai, India model for more than a year and achieved excellent client satisfaction. Effectively utilized Change Data Capture CDC option to extract data changes and used them for data propagation purposes. Optimized the database size and saved thousands of dollars for the customer. Designed and implemented performance monitoring report dash board for the critical application to show the transaction response time / get pages from mainframes SMF output.

Information Analyst Confidential

This was part of the technology refresh project for GM. The goal of the project was to convert the entire application codes under existing Software Configuration Management SCM tool CHAMP to the industry standard SCM Tool CA-Endevor. Part of this project effort he configured / implemented Endevor environments for various GM applications across General Motors.

Tools Environment: S/390, CA-Endevor, TSO, JCL, VSAM, REXX, CLIST and CA-Easytrieve

Achievements: Designed and implemented complex CA-Endevor processor for package shipping logic across the mainframe machines. Designed, developed and implemented self-written tools to automate couple of crucial steps in the conversion process. Manual work for these steps would have taken a day or two for a moderate application and nearly a week for a big application. With the tool developed it just took max 10 minutes even for any large sized application. It gave consistent output across all applications which the SCM team appreciated very much. It avoided lots of manual work and potential human errors. Kannan held a lead member position in the technical core team.

Programmer Analyst / Database Administrator

Confidential

Environment: MF COBOL, COBOL, JCL, REXX, CLIST, Easytrieve, SQL, IMS DB, OS/2, VSAM, DB2 V5.1 on S/390, SQL Server 6.5, T-SQL , Oracle 7.1, PL/SQL, Forms, Reports etc

Achievements: Involved in analysis, design and development of COBOL/DB2, COBOL/IMS DB programs, Y2K conversion projects Worked with Oracle 7.1 to develop application programs using T-SQL, PL/SQL, Forms, Reports Worked on problems involving the evaluation of specifications for complex business requirements and processes new, enhancements, maintenance and designed programs Performed and lead analysis efforts, planning. Participated in Unit, System, Integration and UAT testing Supported and implemented the application changes into production Installed, configured and Administered MS SQL Server 6.5, Oracle 7.1 databases, worked as Microsoft SQL Server / Oracle database developer / administrator.