Rajkannan Kanagarajan

Home:

Nashville

•

734-***-****,

Cell:

TN

734-***-****

ac0zep@r.postjobfree.com

SUMMARY

Looking for Enterprise Director Position Driving broad business impact, positive change and higherperformance across a diverse group of people, and supporting the processes, applications,organization and technology to make that possible by Defining and supporting Best Enterprise DWand BI Practice ensuring that an organization is gaining maximum business value from itsinvestments. Fourteen years of experience in analysis, design, development and implementation ofsoftware applications with expertise in Business intelligence, database Architecture andmanagement, ETL Extensive experience in Enterprise Database Integration and Management.Expert in Enterprise Database Integration and Data Governance.

CORE ACCOMPLISHMENTS

Build IT team from the scratch for enterprise application development specialized in BI andDW.Built and Supported Enterprise applications to integrate business processes, Accountability,Operational Intelligence.Successfully Implemented Data extraction and Loading Process and implementation of OraclePartitioning environment using various ETL tools likeInformatics, SQL Loader and other ETLtools in the market.Implemented BI development Environment using Cognos, Oracle BI, Hyperion.Datawarehouse and BI environment for ERP and CRM Applications, financial Applications,Custom applications like Siebel CRM and JD Edwards configuration, Oracle Financialsetc.Environment: 5TB to 100TB and more Data Warehouse platform with 150 Instances Oracle,Verity, SQLServer, DB2.Implemented SSO using Oracle internet Directory and AD Using LDAP.Implemented SOXpolicies and Data collection methodologies for mission critical and business criticalapplications.Successfully implemented ESB with workflow process and dynamic document generation.Implemented Enterprise Integration application integrating manufacturing, Design andFinance department to cut costs and optimize production.Sucessfully inplement cloud based Data collection and Storage from digital and non digitalequipment for Green Project.Successfully implemented custom developed ERP integrating sales offices, Production Plants,ware houses with corporate Descision support systems, Pricing and Policy Systems.

EXPERIENCE

Lead DW and BI Architect, 12/2010 to Current

Department of Health Planning

Build Datawarehouse and BI system for Health care analysis and reporting.Data consolidation of all Insurance companies and Hospitals in State of Tennessee.Build BIDW based on Comptrollers office data related to Contracts issued by the StateGovernment.BI/DW help to analyzed the contracting costs and get correct federal and State match. Datamodelling, Database Administration and technical lead.

Created process flow, Datamodelling.Created and Implemented Data collection methodologies,.Coordinate outside vendor s to implement data collection process, Data validation process.Created ODS database, Implemented ETL process for load data in the ODS.Built aggregates, Dimensions and cubes.Evaluated and purchased database and BI software for the project.Guided developers in Data mining, BI reporting.Installed and configured BI software.Installed and configure Pentaho to develop BI reports, dashboards and graphs.Created table partitions.Develop BI plans using Agile and roadmap for delivery.Update Project manager, Health department head on the new developments.Execute projects in timely manner.Build cubes and dimensions.Assist executive management in creating budgets.Schemas for Eligibilty system for Program integrity Group.ETL process for Eligibility System using SSIS Environment : 5 TB, HP systems, RHEL, SAS,Pentaho, Hadoop,Microstrategy, Oracle 10g with partition option.,SSIS,SSRS, SQLSERVER2012, VISIO, Sdesigner, MS Project., Microsoft Azure, Oracle Cloud

Principal Consultant Descision Support systems and Datawarehouse Architect, 11/2008 to 12/2010

Hospital Corporation of America Nashville, TN

Implement Latest BIDW methods and techniques to current BIDW environment.Implemented Partitioning option, reengineered exisiting table design to use partioning.Implemented new load methodologies, Partition maintence standards etc.Implemented usage of Oracle Parallel Processing to exisiting DW environment, fine tune.Existing queries to take advantage of Parallel processing, RAC etc.Implement Oracle OEM for enterprise wide database monitoring and tuning using AWR.Implemented latest RMAN backup techniques to change the current backup process whichConsiderably reduced backup size, time and tested recovery scenarios.Mentor and Train HCA DBA's in efficiently using Oracle latest features and improving serviceto internal and external stakeholders.DBA team's service to internal customers.Develop BI strategy using Sqlserver BI tools.Guide Development to use Business Objects for reporting.Business modeling, analysis and design, implementation, test, data encryption anddeployment to meet system requirements as stipulated by upper project management andRDBMS for Paper and EDI with TCP/IP or Web Services messaging to HL7.Developed around 250 SSIS packages with reference to DTS packages.Used the SQL Server migration wizard to convert the DTS packages to the SSIS packages.Analysis Services (SSAS) -- Creating data sources and data source views (DSVs), namedcalculations and named queries.Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs),perspectives, measure group partitions, partition aggregations, data mining models.Deploying and processing SSAS objects.Complex DTS packages are developed by BIDS (SQL SERVER INTERGRATION SERVICES)from scratch by understanding the DTS package business logic.Used the SSIS Configurations in the place of UDL files or Dynamic Properties Task in theprocess of migration.Replaced the For Each Loop Container or For Loop Container in place of active script in DTSpackages.

Created SSIS packages for data reconciliation process and executed the data reconciliationprocess for the source to data warehouse reconciliation.Created the SSIS packages by using the BIDS corresponding to the existing SQL Server 2000DTS Packages.Configured Oracle Portal, implement SSO using Oracle identification Pacakages.Interacted with Top management to analyze organization FITS and existing gaps in thebusiness processes, Interacted with business analysts to understand Business Requirementsand functional specifications.Provide suggestions for Health care applications and best implementation practices.Provide 24/7 support for Production, QA and Development systems and DatabasesEnvironment: 30 TB ERP,Business Objects universe, Healthcare Applications and DataWarehouse platform with 150 Instances, Business Objects, Informatica,SQLServer SSIS, SSAS, DTS (Data Transformation Services,Sharepoint, Oracle 11G,Oracle Portal, Oracle10G,Application Server, Unix Shell Scripting, Linux, OEM, TOAD, Designer 2000, Rapid-SQL,OWB, OLAP, Oracle Diagnostics Pack, 10G RAC, ASM, Net 8, SQLLoader, ProC, TKPROF,ERWIN, SQLPlus, 10.x, AIX, Windows 2003.

Enterprise Intelligence Lead, 04/2007 to 10/2008

Fidelity National Information Services St Pete, FL

Lead Team size of 9 members.Lead Database Adminstrator and Architect Oracle responsible for the implementation andBackup and recovery policy for large (15TB) Data Warehouse environment.Responsible for Database design, ETL Process design.Responsible for maintaining 4 node Oracle10g RAC BI Databases.Responsible for implementation back up and recovery of Oracle 10G Mission Critical Datawarehousing,.Parsing high-level design spec to simple ETL coding and mapping standards,.Coordinating with source system owners, Day-to-Day ETL progress monitoring and Datawarehouse target schema Design (Star Schema) and maintenance.Project coordination, End User meetings.Responsible for Project Planning, execution and Post implementation reviews.Requirements gathering, scope definition and risk analysis.Architected and Implemented Oracle10g RAC for production and development environments,Architected enterprise applications using Oracle 10g Application server.Evaluated and reviewed third party tools which will assist in monitoring the databaseenvironments.Build partitions, Materialzed views to assist Data retrieval for Hyperion.Assist Hyperion developers and ETL developers in data extraction process and reporting.Identify new reporting projects and pitch to executives.Create new Projects road map.Manage day to day activities of the team.Appraisal and rewards for the team members.Merge the newly developed projects as features to resale the reports to banks.Design and implement new hardware architecture to manage the growing database.Installed, configured Informatica on clusters.Bulk ETL processing using informatica Environment: 20TB Data Warehouse platform with 10Instances, SQLServer SSIS,,Sharepoint, Oracle 11G, Oracle10G, Oracle 10g content database,Suite 10g, Oracle 10G Application OWB, Hyperion, Informatica, Discoverer Oracle 9iApplication Server Unix Shell Scripting, Linux, OEM, TOAD, Designer 2000, Rapid-SQL,OWB, OLAP, Oracle Diagnostics Pack, 10G RAC, ASM, Oracle Replication Manager, Net 8,

SQLStation, SQLLoader, ProC, TKPROF, ERWIN, SQLPlus, Sun Solaris 2.7, HP-UX 10.x,HP-UX 11.x, Windows 2003.

Database Consultant, 04/2006 to 03/2007

Caterpillar Financials Nashville, TN

Consultant Enterprise Business Intelligence and Data Architecture.SR BI responsible for the implementation and Backup and recovery policy for large 5TBDatabase environment.Architected and Implemented 3 node Oracle10g RAC for production and developmentenvironments.Architected enterprise applications using Oracle 10g Application server.Designed and Developed Browser based Enterprise Project management System for FPD usingOracle 10G application server architecture.Successfully implemented enterprise database management and monitoring using Oracle 10gGrid control, Built DASH BOARDS.Implemented Oracle identity management and Oracle 10g Application server infrastructure.Implemented Enterprise Content Management Database using OC4J, SSO, OID,Oracle 10gAS, Oracle Data guard and RMAN.Create enterprise content db directory structure including roles, groups, admins and users.Presented solutions to the management team to replace existing content managementArchitecture.Responsible for Logical and Physical database design using ER model.Mentored various development and support teams in fine tuning the database developmentprocess and supported Web based applications and Business intelligence Products.Supported oracle financials, Siebel CRM, JD Edwards, CatUsed, COGNOS, Oracle Discoverer,and Financial express.Successfully developed ETL strategy for financials application to generated decision makingreports for the executive management.Developed around 250 SSIS packages with reference to DTS packages.Used the SQL Server migration wizard to convert the DTS packages to the SSIS packages.Complex DTS packages are developed by BIDS (SQL SERVER INTERGRATION SERVICES)from scratch by understanding the DTS package business logic.Used the SSIS Configurations in the place of UDL files or Dynamic Properties Task in theprocess of migration.Replaced the For Each Loop Container or For Loop Container in place of active script in DTSpackages.Created SSIS packages for data reconciliation process and executed the data reconciliationprocess for the source to data warehouse reconciliation.Created the SSIS packages by using the BIDS corresponding to the existing SQL Server 2005DTS Packages.Responsible for preparing the Test Plans for Application and executed Test Plans, test casesbased on SRS documents and verified expected and actual results.Configured and implemented XML publisher for reporting.

Principal consultant Data warehouse and BI, 07/2001 to 04/2006

Lear Corporation MI

ASM, Oracle Replication Manager, Net 8, SQLStation, SQLLoader, ProC, TKPROF, ERWIN,SQLPlus, Windows 2003 Managed Team size of 6 members.Responsible for the implementation and Backup and recovery policy for large (4TB) OracleERP and Data Warehouse environment.Responsible for Database migration to oracle from Progress and sqlserver

databases.Responsible for maintaining 2 node Oracle10g RAC production Databases.ETL using informatica Version 6,6.1, 6.2 Powercenter 7.1 and 8.6.Responsible forimplementation back up and recovery of Oracle 10G Mission Critical Production Databases(24X7), Data warehousing, Oracle Applications and Development environment including SAPPeopleSoft and MFGPRO.Responsible for Project Planning, execution and Post implementation reviews.Requirementsgathering, scope definition and risk analysis.Implementation and Backup and recovery policyOracle Data Warehouse environment.Guide team to implement SSIS/SSRS tools for enterprisereporting.Manage Data warehouse team all the activities.Architected and Implemented Oracle10g RAC for production and development environments,Architected enterprise applications using Oracle 10g Application server.Evaluated and reviewed third party tools which will assist in monitoring the databaseenvironments.Managed Data warehousing team to successfully build enterprise Data Warehouse with datafrom ERP systems.Implemented business intelligence tools to provide reports and graphs forcorporate management.Tools included ESSBASE, SQLLOADER, COGNOS, andOWB.Complex DTS packages are developed by BIDS (SQL SERVER INTERGRATIONSERVICES).Modifying the SSIS packages according to the Business requirements.Scheduling the jobs andmonitoring jobs.Working with SSRS development teams reconcile the monthly, quarterly andreports.Data migration using BCP and DTS from Oracle/MS Access databases and flat files.Responsible for Oracle 10G Installation, Database Backup, Recovery, Trouble Shooting,Database Monitoring, and Administration and on call support.Responsible for DevelopingTools for Database Maintenance and Monitoring.Installation and configuration of OracleDiscoverer and SQL server databases.Migrate applications in Access to SQL server Database.Installed and configure .netapplications developed using asp.net and vb.net.Responsible for Logical and Physical Datamodeling for custom developed applications and Data marts in Data Warehouse.Architected and Managed Oracle Application server Farm hosting Lear global browser basedApplications.Configure and setup Oracle 10g Grid control, Install, Configure, upgrade andmaintain Oracle Application server components.Managed Vendor relations and SoftwareLicensing.Established information security policy's and implemented it successfully.Environment: 4TB ERP, Business objects,Custom Developed Applications and DataWarehouse platform with 50 Instances, Oracle10G, Oracle 10G Application Server, 10.

BI Data Conversion Lead, 07/2000 to 06/2001

Sonoma Technology Petaluma, CA

Involved in Oracle installation and configuration for 200GB Database environment.Maintained the database running in Oracle and SQL Server.Installed Oracle front end tools.Responsible for transformation of image data and Load in the environment Protection agencydatabase.Migrated the Environmental Protection Agency Database from SQL Server to Oracle 8i usingthe Migration Workbench.Involved in the Logical and Physical design of the database, backup of databases.Performance measurement and tuning, documentation and user training.Environment: Oracle 8i, SQLSERVER, PL/SQL,Migration work bench, SQL Loader, OEM,Windows NT 4.0/2000.

04/2001 to 06/2001

Invisible Worlds Petaluma, CA

Lead Oracle Data warehouse Architect.Designed Datamart and BI reporting for Logistics using SQLserver tools.Project proposals and New development initiatives.Build the DW and Database team.Responsible for coding sqlstore in C, and writing dtdparse in TCL, which parsed the XMLDTD to generate the relational table format of Managed Team size of 4 members.Managed Oracle Data Warehouse environment called "Space Server".The Space Server does the fetching or storage of data in the form of blocks in Data Warehousesin the database.Product Managed is based on the XML based BEEP protocol, (BEEP protocol is an XML basedprotocol for ETL).Responsible for setting up Oracle environment to aid in accessing the actual data by storing themetadata.Lead and mentored database management team of four.Maintained Oracle 24x7 Production Databases from 100GB to 300 GB.Responsible for Oracle installation and configuration.Responsible for Database design, back up and recovery, and DTD.Responsible for Performance Measurement and tuning of queries generated by the SpaceServer.Involved in installation and configuration of Oracle 9i Application Server, Data miner.Evaluated Oracle 9i products and Documentum Server.Designed and implemented ETL process to use space server to extract data From Legacysystems into Data Marts using XML.High-speed Bulk data processing.Project Planning, execution and Post implementation reviews.Requirements gathering, scope definition and risk analysis.Documentation of processes.Set standards and policies.Designed the Configuration Structure for the Space Server.Set up the server environment.Modified all the server components to take the parameters from the global array.Designed the Data Document for the config file using XML.Adhoc query tuning and analysis.Extensive Data modeling Data Warehouse to build data marts and mv's.Created and Designed the Database Interface Module with three Component sqlstore,interface and indexing.database.Used Control file for loading XML blocks into the data ware house.

BI Lead, 02/1996 to 02/2001

Reliance Petrochemicals

Managed Team size of 24 members.Designed and built enterprise Database Warehouse Replication environment across differentbusiness lines for the Organization.Maintained and upgraded the 100/200 GB Oracle databases, tools and related products.Created overall project plan and milestones for the project and made sure they are achievedand got signoff from the client.Translated logical data models into physical Oracle database structures.Involved in Database Migration and Data Conversion.Designed logical and physical schemas for the databases.

Involved in Object Oriented Database Design.Performed benchmark testing in a UNIX development environment.Created Test and Production Databases and processes documentation.Allocated storage space and planned the future growth of the database.Performed Backup and Recovery of the database, Query Optimization and Database Tuning.Involved in application maintenance, trouble shooting, user creation and security.Database design and data modeling for products and custom developed applications.Distributed database allocation and integration.Successfully implemented enterprise ERP Application built on 3 tier architecture.Using Oracle Forms, reports, Windows 2003 server and HP Unix.Conducted Performance reviews of Database and development team members.Trained the client management staff, Database administration staff to manage the applicationand the databases.The strategy was based on the system requirement and distributed database features availablein Oracle.Planned the transaction flow between locations, set of distributed environment, sequence oftransaction transfer, refresh frequency for the transactions and centralized data repository.Created Snapshots based on the Transaction Flow.Also worked on product development efforts for manufacturing and material managementmodules.Environment: Oracle 8i/8.x, PL/SQL, Shell Scripting, Oracle Parallel Server, Developer 2000,Windows NT, HP-UX 10.2, Sun Solaris 2.6.

Application Database Administrator / Developer, 07/1999 to 02/2000

Nuclear Power Corporation

Involved in the installation of 100/200 GB Oracle database and related tools on HP UNIX.Developed and installed IMPACT Product.Involved in Logical and Physical design of the database.Involved in data mining and data migration.Planned and implemented the Backup and Recovery Policy.Performed database tuning and created the "Standby" database.Provided user training and documentation.Involved in application maintenance, security and auditing.Environment: Oracle 7.3, Developer 2000, PL/SQL, Shell Scripting, Designer 2000 OracleParallel Server, Windows NT, HP-UX 10.2.

EDUCATION AND TRAINING

Master's: Computer Science

Computer Science

Certification in Leadership and Business Management.

SKILLS

Expert in XML data and using XML for wireless Protocol. Expert in Agile developmentmethodology. Expert in creating and managing BI and DW team Extensive experience in SQLserver andOracle managing 11G/10G/9i/8i/8.x/7.x., SQL server 2005/2008 and Progress on windows andUnix platforms.Ten years of Extensive experience in supporting BI and ERP Application Databases. ExtensiveExperience in BI design using ETL tools including ESSBASE, Executive Viewer, SSIS, SSAS,Oracle Warehouse Builder, Oracle Discoverer, BI/XML Publisher and Actuate Reporting.

Extensive Experience in Bulk data processing, Datamovement, Data marts, Datastaging, XMLParsing. More than 10 years Extensive experience in data modeling for products and customapplications .Architected and Implemented Oracle10g RAC for production and development environments.Extensive experience in Oracle Application server 10g, Oracle Portal and Oracle Contentmanagement 10g in building enterprise content management system.Extensive experience in Building and managing enterprise wide Application using 3 tier and 2tier architecture. Working knowledge of Open source BI tools like Hadoop, Pentaho *Expertisein understand business BI reporting requirements at all levels of the organization.Experience deploying systems using SAP's ASAP Methodology *Six years of Experience insupport SAP for large Manufacturing environment. *Excellent knowledge in Various BI toolsincluding SAP BO. *100% Success rate in building DW for Automotive, Finance andHealthcare domains. Experience in transforming data from one server to other servers usingtools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.*Experience in creating complex DTS Packages for Data Migration and Transformation.Experience in data migration from Oracle/Access/Excel Sheetsusing SQL Server IntegrationServices.Experience in SQL Server Reporting Services (SSRS). Experience in SQL Server AnalysisServices (SSAS).Excellent knowledge on MS SQL Server 2008. Excellent working experience in ManagementStudio, Enterprise Manager and Query Analyzer *Accomplished mission critical tasks in widevariety of Environments and Domains. *Managed budgets of exceeding 2 million dollars peryear. *Expert in Team Building, Excellent Presenter and speaker.Experienced in Mircrosoft, Oracle, AMAZON and other cloud technologies including Azure,Oracle Cloud.Experienced in using wireless protocol for Digital Data transfer.Experienced in using XML based solutions in cloud.Experienced in setting up and managing infrastructure for cloud.

Contact this candidate