Deepak K Lal

*** * *** ** #***, Euless,TX *****, Ph. 732-***-****(M) . 732-***-****(H) . act6u8@r.postjobfree.com

Linkedin Profile : http://www.linkedin.com/pub/deepak-lal/9/696/720

Objective: Seeking Fulltime position allowing me to use my skills in the fields of computer science and management information systems to lend my expertise to an organization looking to grow with an emphasis on Senior Database/Data Warehouse Engineer

PROFESSIONAL SUMMARY

Over 16 years of extensive experience In Data Architect, Data modeling, Business Intelligence (BI), Operations and Infrastructure, Project management with agile methodology in Morgan Stanley, Lehman Brother (Currently Barclay) and CITI Group. Extensive knowledge base of Database Design Methodologies, Database engineering and Tools

Managed and coordinated numerous Projects execution by off-shore resource, Data security compliance and auditing Sarbanes-Oxley (SOX compliance) to ensure IT infrastructure and Equity Data is secured, Worked as a team member and interacted with Internal Auditors and participated in different efforts by our team helping Internal Auditors in identifying controls,Database Security ( database and object) level, Data access method through WEB based client, locating evidence where applicable, related to Sarbanes-Oxley (SOX) remediation effort which involved extensive analysis and documentation to ensure the existing security policy and way to control and correct the data security weakness.

Developing technical concepts and solution, Process design, Business and Technical liaisoning and coordination.

Designed and Implemented OLTP as well as OLAP (STAR) Data Mart application. It includes conceptual, Logical (E-R Diagram) and physical modeling. Database Design review, ensuring referential integrity, Identifying Attributes, Relations, cardinality, Primary and Foreign keys. Maintenance and creation of Business and Technical metadata, Data dictionary, Documentation of business rule and information requirement of Business area. Experience in Kimball Data warehouse design.

Analyzed and designed the conformed Dimension and Facts across different Independent Data marts for their consolidation.

Requirement analysis for Master Data management (MDM) to analyze and identifying custodian of source for different master Data across the firm.

Highly proficient in top down SDLC methodology .Business Intelligence design and development.

Expert knowledge on SQL, SQL optimization and Root cause analysis of performance issues and implementation of corrective measures.

In depth knowledge of Performance tuning using Oracle Explain Plan, Sql trace, TKProf utility, ability to understand explain plan.

Involved exploring the possibility and use cases for Big Data within LOB for feasibility and justification implementing big Data technology stack.

Successfully executed and managed the key module of R&D Project which involved major Data architect design, Requirement gathering, OLAP AND OLTP modeling, Technical and Business Metadata creation, extensive inter group interaction to deliver the proof of concept for Database Platform architecture and performance benchmarking of Oracle, Teradata UDB DB2 and Sybase.

Technical lead, Designed and proposed Business Continuity Plan strategy for the group to ensure the system is highly available for the controllers and end users.

Actively participated on CMM (Level-2) certification program by Morgan Stanley. Worked by adopting the norms set by Quality control in whole project life cycle phase, Monitoring standard and existing procedure.

Extensive Experience on Service support and Service Delivery (ITIL Service management) process improvement.

Executed support model design, Knowledge transfer, mentoring, presentation and coordination with offsite resource

VISA STATUS

U.S. Citizen

4GL /RDBMS/Database Product

Netezza Appliances, Oracle 10g/11g,,Sybase 11.x/11.5.x/11.9.x/12.x, Sybase IQ, UDB DB2, MS-ACCESS, MS SQL Server, Sybase Replication server(12.5), direct connect for MS SQL server, Component Integration Services (CIS)

DATABASE FRONTENDS and TOOLS

DBArtisan, TOAD, DB2CONNECT, MS Sql server visual studio, APT 5.2.2, PowerBuilder 5.0,IBM SQLBACKTRACK(4.0),RCS Version control, autosys, HTML

CASE TOOLS IBM InfoSphere Data Architect, Erwin, ER/Studio, Visio, Excelerator 2.0

SYSTEMS AND LANGUAGES

UNIX, Linux, SunOS, Shell, HP-Unix, AIX 4.x, VMS 5.5, DOS 6.2 OS/2 Version 2.21, TCP/IP, DECnet, WINDOWS XP/NT,JAVA (JSP), Korn/C shell, Perl, XML

HARDWARE

Dell Enterprise Linux servers, Sun ultra-Il, Sun Enterprise sparc Server (E6500, E4500, E420),IBM RS-6000, IBM PS/2,VAX 3400,Macintosh, Quantel System-40,i486/Pentium

Professional Summary

Morgan Stanley

Data Architect(VP)

June'2013-Till date

JP Morgan Chase

Data Architect

April'2012-May’2013

Citi Group

Vice President(Technology)

Sept’2009- March'2012

Citi Group

Data Architect

July’2008-August’2009

Lehman Brothers

Senior Data Architect

July’2007 – June’2008

Morgan Stanley, NY, U.S.A.

Database Team Leader

Nov.1999 – June 2007

Pearson Education,OldTappan,NJ,U.S.A.

Sr. Database Engineer

June 1998 – Oct. 1999

Morgan Stanley

Vice President (Data Architect) Wealth Management 2013 –Till Date

Roles and Responsibilities

Engaged in Requirement analysis and Technical design for Liquid access Line

Built Logical Model, Physical Model, Data Dictionary and implemented Data governance process.

Implemented Physical Model, Database optimization with DBA’s, Data Quality and Validation process

Worked with several upstream systems to streamline Data Integration project, ETL strategy for Data warehouse, designing and delivering for several downstream system extract for reporting and BI

Successfully lead the ETL team for Lending service Data warehouse.

Monitoring database performance, code review, Architectural approach review and recommended improvements for operational efficiency.

Assist in capacity planning, space management and data maintenance activities for multiple DB2 database system

Contributed and worked very closely with Centralized data analytic team for Analytics and BI deliverables.

Environment : Teradata, Sybase, UDB DB2, Microsoft toolset,Erwin, Power Designer, UNIX, Linux, Informatica

JPMorgan Chase

Data Architect Liquidity Risk 2012 -2013

Roles and Responsibilities

Working in Liquidity Risk Infrastructure (LRI) program that is a firm-wide, 'mission critical' effort to enhance our liquidity risk

management monitoring and reporting capabilities, which will include a redesign of the related supporting technology and

infrastructure.

Designing the overall Logical and Physical Data Model for the Results ODS

Coordinating the design of the LRI Results Operational Data Store/ Reporting Mart

Contributor and Reviewer of all LRI Functional Specifications for consistency and mapping into the Results ODS

Working closely with the LRI Application DBA's to ensure that the Logical Data Model

gets translated properly into the physical database objects

Environment : Oracle, Microsoft toolset, Erwin, Power Designer, UNIX, Linux

Citi Group

Vice President (Technology) 2009 - March'2012

Roles and Responsibilities

Working as Equities Middle Office Data Architect.

Engaged in Data Modeling, Data Architecture, Model Governance and Integration project.

Designing Relational Unified Logical Model for Equities Middle office which includes Order, Block, Allocation and Trade entities.

Consolidated and streamlined all Fix (CitiFix) tags required for Equities for all Fix Message type supported.

Developing and delivering Data Strategies, Data warehouse and Data Mart for Equities Middle Office.

Defining Technical requirement for the business, Planning, Engaging Delivery team, Project tracking and Risk tacking and assessment

Leading technical team of Database Architects, ETL developers and BI Developers to Design, Consolidate and integrate, multi-terabyte, high performance, scalable Global Information Warehouse.

Leveraging my extensive Database experience to identifying bottleneck and optimizing the throughput using tools and techniques in DB2 for LUW versions 8.2 – 9.5 and Oracle 10G.

Served as Technical lead for Major Integration project and Infrastructure management of commercial Cards division.

Environment: Netezza, UDB DB2, Oracle 10g, AIX, SunOS, Erwin, TOAD for DB2 & Oracle, JAVA Hibernate

CITI GROUP July’2008-August’2009

Data Architect (Consultant)

Roles and Responsibilities

Working as senior database and data architect for their Asset management system (GWM), historical position, transaction and performance unification for their 25 million account globally

Researched, Data Modeled & developed fund unification system. Included complete system functionality, specifications and E.R. modeling.

Creating data flows and conceptual models defining the informational needs of projects, providing leadership in Logical/physical modeling (OLTP and OLAP) and design identifying systems of records that leverage strategic data assets, building Facts-Dimension matrix creation, extensive user’s interaction and JAD session engagement.

Developing and maintaining data architecture, data management, modeling standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards.

Created technical, Architecture and Model documentation, publishing the model. Reviewed and analyzed the existing model recommending new entities and their attributes with third level normalization.

Responsible for validating physical Database change, impact analysis for the schema change request, synchronization of logical and physical Data Model

Extensive DBA interface to optimize Index selection, Data Partitioning and physical placement of Data for optimum throughput in UDB DB2 environment

Business Intelligence experience analyzing Business object universe design and reporting strategy for Business users.

Database Design and Architecture for the placement, access strategy, partitioning and indexing strategy.

Environment : SQL, UDB DB2,Microsoft Visual studio, DB2 Control center, Erwin, MS Project, UNIX, Linux, Oracle 10G/11G

LEHMAN BROTHERS (Currently Barclays ), Exchange place, NJ July’ 2007 – June ‘2008

Senior Data Architect, Equity Finance

Roles and Responsibilities

Providing strategic solution for their Equity Data Warehouse in order to Manage Performance, Optimizing Active Data, Database design issues, Data referential integrity, Study of existing Logical model.

Improving existing Data model and ensuring Data and referential integrity for the existing system

Involved in Data Architect role for Equity Data warehousing project which needs detail investigation and analysis of reporting Environment which includes Data Validation check, recommending Appropriate Indexing strategy for the various reports, Demonstrating the proof of concept in order to enhance reporting throughput, Writing Stored procedures, Improving Query performance and Optimization

Providing strategic solution for Sybase HA

Environment :Sybase, UDB DB2,Microsoft Visual studio, DB2 Control center, Erwin, MS Project, UNIX, Linux

MORGAN STANLEY DEAN WITTER, NY, U.S.A Nov. 1999 – June 2007

Data Architect/Team Leader, Finance Controllers Data Warehouse group

I was Involved In different Critical projects which were developed, in 3-tiered architecture with 35 terabyte of production data stored in 105 servers. Worked as Data Architect and providing extensive range of Reports to around 3000 Firm Controllers globally. This system consists of Equity Data, Risk, General ledger FX, REPOS and Balance sheet and Fixed Income

Roles and Responsibilities

Responsible for Data Architectural design, Business requirement gathering, Process Data modeling, Dimension Data Modeling (Star Schema),Logical model, Physical model, Model validation, Data normalization,Data dictionary creation Implementation of slow changing dimension, Data extraction and Integration .

Reverse-Engineer numerous existing financial database schemas, GAP Analysis, and created Informational Data Models explaining the existing business, including processes, Business Rules, Rules/Decision Logic, and ETL and Data Flows.

Capacity planning. Performed extensive analysis on Data partitioning on different nodes (dimension and Facts), performance benchmarking data collection on different heterogeneous DBMS Product mainly DB2 UDB, SYBASE. And Oracle. Assisting in the process of sourcing, mapping and definition of data elements.

Worked closely with enterprise level architecture team to stream line Data standard, Architecture and data governance.

Designed and Implemented slow changing dimension, involved in Data mart consolidation.

Requirement analysis for MDM (Master Data Management) for identifying and qualifying master data for the Line of Business

Writing T-SQL queries for Reporting and Data Manipulation

Design, Development and execution of Data Migration project from Sybase to UDB DB2 which includes Data architect, Use of surrogate keys, Data consolidation, extensive Shell and Perl scripting, Execution and testing of Data integration, around 1.3TB of Data migrated successfully with accuracy.

Executed successfully on several RnD project as bench marking and Proof of concept for DB2 UDB vs. Sybase vs. Oracle, data modeling, performance tuning and monitoring for our Adhoc reporting environment as team Leader.

Worked as a team member and interacted with Internal Auditors and participated in different efforts by our team helping Internal Auditors in identifying controls,Database Security, Data access method, locating evidence where applicable related to Sarbanes-Oxley (SOX) remediation effort .

Worked in Data warehousing project writing extensive shell,PERL scripts for the Data Extraction Transformation and Load (ETL) design and striping the data load from Mainframe, Data validation,Data integration, making data available for Reporting by creating complex views and monitoring the jobs on 24x7 days support environment.

Involved in different Financial Data warehousing project as well as other Customized project mainly Real Estate and Greatplain. Actively involved in Analysis, Design, Writing Business logics, unit test, Integration check, Writing Views for the reports and Data delivery mechanism, History Data migration, Source control

Actively participated on CMM (Level-2)-Capability Maturity Model certification program by Morgan Stanley. Worked by adopting the norms set by Quality control in whole project life cycle phase, Monitoring standard and existing procedure.

Managing Operation team of our Group responsible for Planning Business Continuity Plan (BCP), Capacity planning for the group, interacting with different Core group within the firm as Unix Engineering group, Storage Engineering group, Global Data Architect and Engineering Team for strategic plan and implementation of Firm Standard within the Group.

Environment : Oracle 9i/10g, MS SQL Server 2005,Sybase, Replication server, SQL BACKTRACK, UDB DB2, SQL, T-SQL, PL/SQL,SQL*Loader, SQL*Plus, TOAD, Microsoft Visual studio, DB2 Control center, Erwin, MS Project, UNIX, Linux, K-Shell, Perl, JAVA, JSP, RCS Version control, autosys

Education:

Master Of Computer Application (MCA) From Regional Institute of Technology, Jamshedpur, India

Professional Training

Advance database administrator, Database design and SQL optimization by SYBASE Inc.

Advance Database design and performance tuning by IBM in DB2 UDB, Advance Sybase SQL performance tuning by Sybase Inc., Data Modeling technique by SAP in Power designer

System Analysis and Design by CSI India, Data analysis and Modeling Techniques by SAP in Power Designer

Contact this candidate