Lead BI/Solution Architect

KAUSHAL KISHORE

** ******** ***,

WESTFIELD, IN USA

Tel: 317-***-**** Email: ******@*****.**

CAREER OBJECTIVES:

A professionally challenging position like Database Architect that will require full use of developed skills and knowledge. This position will provide opportunities for continuing growth and advancement with an organization that recognizes and values individual contribution.

SKILL SUMMARY:

Comprehensive knowledge of Data Architecture, Data Modeling, Normalization, E-R Diagrams, Computer Systems Analysis, Oracle Enterprise Manager, Oracle Business Intelligence Enterprise Edition (OBIEE), AllFusion Erwin Data Modeler, Data Warehouse, Informatica Designer, Cognos, OLTP, OLAP, DSS, OEM, ASM, ODBC, JDBC, Import/Export, SQL Loader, TOAD, Crystal Reports, SQL, PL/SQL, OEM, Informatica Power Center, Designer/2000, Developer/2000, Procedure Builder, RMAN, Data Replication, Import/Export, Oracle 8i/9i, MS SQL SERVER 7 & 2000, C, C++, Java, Visual Basic. NET, ASP, Data Profiling, Data scrubbing, XML, XML SOAP.

Good exposure to the entire Software Life Cycle involving requirements data collection and other systems management activities. Having strong interpersonal skills with the ability to interact with end-users, managers, technical personnel, etc. Excellent work ethics and team oriented with strong analytical and leadership quality.

System- Application Software/Tools/Techniques:

SQL*Plus, PL/SQL, C, C++, Visual Basic. NET, Crystal Reports, HTML, XML.

System Analysis & Design, Software Engineering Methods and Database Design.

Database Environments/Operating Systems:

Multi-tier Architecture / Client Server Architecture.

Oracle 8i/9i/10g, MS SQL Server 2000, Windows NT/ 2000, UNIX, Linux.

EDUCATION:

Master in Computer Application: Client Server Technology, Software Systems Analysis and Design Methods, Application System Development, Object-Oriented-Programming.

Oracle Certified Professional Program (OCP-DBA) in Database Administration Trac (Ver. 8i) from Oracle Corporation: Database Architecture and Administration, Backup and Recovery, Performance and Tuning as well as Network Administration. In 2001 from Oracle Corporation.

EMPLOYMENT:

Eli Lilly & Company Lead BI /Solution Architect February 2014 – Till Date

(A Global HealthCare Company) Indianapolis, IN

Environment:

Informatica MDM/IDD/IDQ, Data Warehouse, DataMart, Business Intelligence, Informatica, IDD, IDQ, Big Data Apache Hadoop, Oracle 11g, MS SQL SERVER 2012, Power Designer, SSIS, COGNOS Reports, SQL Navigator, etc.

Responsibilities:

To provide technical and business leadership across the portfolio to anticipate and resolve key technical, operational, or business problems related to data that impact Information Management within the organization.

To lead development efforts related to extracting data from source systems, transforming that data, and loading it into integration platform.

Engage directly with IT and business personnel to solicit functional and strategic requirements and deliver solutions that meet their needs.

To lead development and maintenance of data model designs for information assets and the integration platform.

Guiding technology platform decisions.

Driving team to understand and evaluate the existing and potential items in the portfolio of work to align with LRL (Lilly Research Laboratories) business priorities and influence the execution of LRL (Lilly Research Laboratories) IT projects in collaboration with vendors, business partners, team and management.

CGI Head of Data Management Team September 2013 – January 2014

(An Information Technology solution company) Boston, MA

Environment:

Informatica MDM/IDD/IDQ, Data Warehouse, DataMart, Business Intelligence, Siebel CRM, CA Erwin Safyr ERP, Informatica, IDD, IDQ, Oracle 11g, MS SQL SERVER 2012, Power Designer, SSIS, COGNOS Reports, SQL Navigator, etc.

Responsibilities:

Responsible for the design & structure for persistent (online or offline) and dynamic data components in the system

Work with project stakeholders, and software vendors to communicate data models for persistent data and to design structure for dynamic data

Integrate Oracle MDM / Customer Data Hub to ensure no data duplication

Responsible for the deliverable expectation document, preliminary and final deliverables: Logical Data Model, Physical Data Model, Database Design, Data Management plan, contribute to the Technical Architecture diagram & Data Use / Data Exchange / Interconnection Security Agreement Deliverable

Responsible for the management of data through the initiation of testing lifecycle and throughout the testing lifecycle.

Coordinating and managing the data management team for all data management works.

Quintiles Senior Data Modeler/Data Warehouse Architect May 2009 – September 2013

(A Clinical Research Company) Indianapolis, IN, USA)

Environment:

Data Warehouse, Datamart, Oracle 9i/10g, MS SQL SERVER 2000, Erwin Data Model, SSIS, Informatica, COGNOS Reports, SQL Navigator, etc.

Responsibilities:

Created database, design, develop and maintain data structures, data models, ETL process for bringing data from different sources to achieve team's strategic goals.

Coordinated with service development team to meet their requirements and continuing additional research and exploring international/industry resources. Formalizing the data quality processes like data profiling, data cleansing.

Created Physical Layer of a Repository, Business Model and Mapping layer of a Repository, built a Dimension Hierarchies and after a Business Model was created then tested and validated a Repository using Oracle Business Intelligence Enterprise Edition (OBIEE)/Siebel Analytics.

Designed, developed and created Enterprise OLTP Data Models in 3rd Normal Form.

Designed, developed and created conceptual, logical and physical Database Models (Star Schemas/OLAP)) for Data warehouses and Datamart as per the end-users requirements for patients, investigators, clinical studies, drugs departments for trial related clinical research

Reviewed and changed the database design according to business requirements.

Performed feasibility analysis and preliminary planning resulting in the successful migration of real-time data capture and contract recharge and billing system from one divisional data center to another.

Designed, coded and implemented data migration procedures for source to target using Informatica ETL database system procedures.

Coordinated with Business Analyst, developers and other key functions of the organization.

Praxair Surface Technologies Data Warehouse Architect April 2008- March 2009

Indianapolis, IN, USA

Environment:

Data ware house, Datamart, Erwin Data Model, Oracle Discoverer, Oracle 11i application, Oracle 9i/10g Database,, Data Modeling,, SQL Navigator, etc.

Responsibilities:

Designed, developed and created conceptual, logical and physical Database Models (Star Schemas/OLAP))

Created analytical reports using for Data warehouse Oracle Discoverer for Sales/Order/Inventory/Shipping

Interacted with different users/customers in company’s plants which are all over the world for gathering their needs and requirements for creating Oracle Discoverer new reports

Developed archiving strategy for Data Warehouse and code migration

Analyzed and interpreted data using Oracle 11i application for user requirements

Organized several Business Intelligence sessions for IT staff to describe over all analytical/historical reports in Data Warehouse environment.

The HealthCare Group Data Modeler/Data Warehouse Architect February 2005- March 2008

(A HealthCare Insurance Company Mplan) Indianapolis, IN, USA

Environment:

Data Warehouse, Datamart, Oracle 9i/10g, MS SQL SERVER 2000, Erwin Data Model, Informatica, COGNOS Reports, SQL Navigator, etc.

Responsibilities:

Created analytical applications, dashboards, full ad hoc queries and Integrated with any data source, extraction, transformation and load (ETL) tool, and major business application using Oracle Business Intelligence Enterprise Edition (OBIEE)/Siebel Analytics.

Created Physical Layer of a Repository, Business Model and Mapping layer of a Repository, built a Dimension Hierarchies and after a Business Model was created then tested and validated a Repository using Oracle Business Intelligence Enterprise Edition (OBIEE)/Siebel Analytics.

Designed, developed and created Enterprise OLTP Data Models in 3rd Normal Form.

Designed, developed and created conceptual, logical and physical Database Models (Star Schemas/OLAP)) for Data warehouses and DataMarts as per the end-users requirements for Enrollment/Claims/Premium Billing/Benefits/Marketing departments for the HealthCare Insurance.

Reviewed and changed the database design according to business requirements.

Performed feasibility analysis and preliminary planning resulting in the successful migration of real-time data capture and contract recharge and billing system from one divisional data center to another.

Designed, coded and implemented data migration procedures for source to target using Informatica ETL database system procedures.

Coordinated with Business Analyst, developers and other key functions of the organization.

Information Technology Partners, Inc. Data Analyst May 2004 - Dec 2004

Benton Harbor, MI, USA.

Environment:

Data Warehouse, Datamart, MS SQL SERVER 7/2000, Cognos Reports, Crystal Reports, Enterprise Manager, Query Analyzer, SQL*Loader, Import/Export, Data Replication, Diagnostic and Tuning pack, etc.

Responsibilities:

Interacted with clients to process data to meet their expectation.

Reviewed existing systems to enhance design of database using the method of data modeling, normalization for Enterprise Data Models for OLTP and OLAP databases.

Conceived, designed, and developed database models for warehouse architect.

Created and modified various kinds of Crystal Reports for end-users.

Created stored procedures, cursors, views, and indexes to manipulate data using TSQL.

Performed feasibility analysis and preliminary planning resulting in the successful migration of real-time data capture and contract recharge and billing system from one divisional data center to another.

Designed, coded and implemented data migration procedures for source OLTP to target ODS (Operational Data Store) using Sql/Server database system procedures.

Designed and coded stored procedures, triggers, and views to control the ETL application data into the DSS. Process also written using: Sql/Server job scheduling, linked servers, e-mail and alerts.

Coordinated with System Administrators, developers and other key functions of the organization.

Ontario Institute of Information Technology Data Analyst / Administrator Jan 2000 Apr 2004

Toronto, Canada

Environment:

Oracle 8i /9i, MS SQL SERVER 2000, Enterprise Manager, Query Analyzer, AllFusion Erwin Data Modeler, Crystal Report, OEM, SQL*Loader, Import/Export, TOAD, RMAN, Data Replication, Diagnostic and Tuning pack, Sun Solaris, Linux, Windows 2000, JavaScript, XML, Visual Basic.NET, Crystal Reports, HTML, XML etc.

Responsibilities:

Designed, developed and created conceptual, logical, and physical database models for clients.

Created Reviewed existing systems to enhance design of database using the method of data modeling, normalization for Enterprise Data Models for OLTP and OLAP databases

Used multidimensional data analytical processing (OLAP) to create an advanced data analysis environment for report generation in Crystal Report.

Participated in the review, selection, installation and testing of Ad-hoc/Warehouse Query tools. Researched and recommended the use of MS/OLAP (Online Analytical Processing) services, Cube designs, updates of slowly changing dimensions etc.

Assist with implementing Certificate/Application Data Mart to supplying feeds for external reporting feeds and processing. Investigated and tested the use of SQL/Server Replication technology to support current ODS as well as future Data Mart projects.

Perform database modeling for the DSS, maintain data models and did object creation. Assist developers with database object changes, and performance issues and query path analysis. Coded (VB/Script) SQL/Server DTS (Data Transformation Services) Packages to migrate data from an Oracle accounting application into the DSS database.

Using bcp (bulk copy program) for transferring blocks of data into or out of SQL SERVER, BULK INSERT utility for importing data, DTS (data transformation Services) utility for import, export, reformat and modify data, and REPLICATION utility for automatically transferring selected data between database servers.

Utilized Linked Server operations for data access with remote servers for applications that require distributed transactions and queries.

Used T-SQL clustered/non-clustered indexes for managing and tracking rows in a table or an indexed view for improving performance.

Managed the maintenance and optimization of database through management tools like, Query Analyzer, DBCC (database consistency checker) and SQL profiler. Running database maintenance plans through wizard to make SQL Agent run on regular basis for database integrity checks, update database statistics and backups. Used the database Maintenance Plan Wizard to configure the log shipping for the backup of transaction logs in standby SQL SERVER 2000 automatically.

Set up linked Server (OLE DB). Periodically tuned SGA to avoid fragmentation of shared pool and memory structures.

Designed and implemented backup and recovery strategies using RMAN features.

Grant the necessary system, user, and object privileges to the respective users and roles

Create data storage structures Data Tablespaces, Index Tablespaces, Rollback Tablespaces.

Xpert Processors Pvt. Ltd. Developer/Database Administrator Jul 1990- Dec 1999

Patna, India.

Environment:

Sun Solaris, HP-UX, AIX, Windows NT, Oracle 7.2.3 to 8.1.6, Oracle Enterprise Manager, Server Manager, RMAN, ODBC, PL/SQL, SQL* PLUS, SQL*Net, Telnet, FTP, C++, Visual C++, Visual Basic, Crystal Reports, HTML, XML etc.

Responsibilities:

Developed new techniques and estimated costs associated with new or revised programs and utilities, taking into consideration personnel, time, and hardware requirements.

Made trade-off analyses, developed general and detailed documentation describing system specifications and operating instructions and revised existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage.

Involved from the preliminary database-design stage to physical stage.

Allocate system storage and plan for future storage requirements for the databases.

Configuring SQL*Net i.e. setting up listener.ora and tnsnames.ora.

Installed and maintained many application program products.

Monitored system performance and retune the system as necessary like tuning parameters, rebuilding indexes, restructuring table, etc.

Modify/Alter the database storage parameters, Redo Logs, Archive Logs, and Dynamic Buffers.

Monitor and administer DBMS security like adding and removing users, administering quotas, auditing, checking for security problems.

General trouble shooting and performance tuning of Database and SQL.

Created Stored Procedures, Functions, and Triggers.

References available upon request

Contact this candidate