Vamsi Krishna Batchali

Data Architect /DBA/ Data Modeler/Oracle Database Architect

acwzmt@r.postjobfree.com

678-***-****

An Oracle/Datawarehoue Architect /Data Architect /Data Modeler/Enterprise Data Architect & Oracle DBA with rich experience with maintain Databases of different sizes and voluminous transactions on 24/7 basis and also Design in ER-Modeling/Dimensional Modeling and also maintain data warehousing Databases for Design and support.

Professional Summary

Over 18 years of experience in Oracle/Datawarehoue Architect /Data Architect /Data Modeler/ Enterprise Data Architect & RAC Oracle Database Administration with extensive data architecture, database development and administration experience in full SDLC, designing and building relational databases in OLTP, OLAP, decision support (DSS), data mining (DM), client/server, data warehouse and multi-tier web based projects.

Experience in Data Modeling, Design, Testing, Development & Production support

Worked as chief architect of data repositories (warehouses, ODS, datamarts),

designer of schemas and of data flow within the organization

Analyze and document these architectures and designs

Lead our data governance body, and drive work in defining data standards, designing asset and portfolio classification taxonomies, developing data management processes, ensuring meta-data is documented, etc.

Frame the business case around complex architecture and design options

Manage vendor relationships to such 3rd party data management products and vendors as we utilize Systems analysis and design. Project planning and project management

Design and build using Erwin, Erwin& ER Studio & OWB Dynamic Information Warehouse technology

Design and build using Erwin, Erwin& ER Studio Master Data Manger technology

Skilled in logical and physical database design. Experienced in logical data modeling including business rules.

Worked on EDW/MDM Building Data marts

Excellent interpersonal and strong analytical, problem-solving and conceptual skills.

DBA activities include – Design and modeling using Oracle Designer. Development using the suite of ORACLE tools. Managed Installation, Configuration and Administration of Oracle 8i/9i/10g Databases. Created database, database objects like table, index, DB Link, table space, rollback segments, and views & Materialized Views and analyze relevant objects to collect statistics to tune the system performance. Tested and Implemented different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import. Defined backup procedures alert checking, and remote archive copying, monitoring and tuning databases. Golden Gate Implementation. Participated in the development and testing of backup and restore strategies for development and production system. Applied Oracle Software patches whenever required. Worked on Database Sizing, Rollback Segments and Queries. Performed STATSPACK tuning. Created and maintained UNIX scripts for Oracle maintenance and statistics. Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM (Oracle Enterprise Manager). Implemented multiplexing of control files and redo-logs for disaster recovery scenario. Monitored Rollback segments and its Space management. Installed, configured and administered Data Guard Environment. Developed the scripts for creating the Users and allocation of rolls to the users and maintaining system security. Checked Alert files and Trace files regularly. Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, patch runs, monitoring, performance tuning, restructuring of databases, trouble shooting.

Educational Qualification

Bachelor of Engineering (B.E) Computer Science & Engineering

Executive Program in Business Management from IIM-L

Technical Skills

HARDWARE : Pentium, RS-6000, RAC, RAID, SAN

Operating SYSTEMS : Windows NT, Sun-Solaris, Sco-Unix, HP UNIX, VAX/VMS, AIX

Languages : PL/SQL, C, C++, Pro*C, UNIX Shell Programming, Perl

Databases : Oracle 7.x/8.x/9.x/10g, Oracle Applications 11i, Ms-

Access, SQL-Server 2000, PeopleSoft

GUI : Developer 2000, VB

Tools & Utilities : RMAN, Quest.com, Oracle Enterprise Manager, RAC,

Erwin, Sybase Power Designer,

Domain Knowledge : Logistics, Banking, government, Insurance

Tools : Load Runner, SiteScope, BAC

Application Server : Oracle Application Server 10g.

Data warehouse Tools : Oracle Warehouse Builder, Informatica

Professional and Project Experience

Polaris Financial Technologies, Iselin NJ Aug ‘2012 to till date

Sr. Data Architect

Responsibilities:

•Identify and define the standard for data elements to create an analytical OLTP & OLAP system.

•Discussed with clients to identify their needs, define detail requirements and outline the solution with a POC

•Chaired data model reviews with Clients and gap analysis to ensure client audits gates are passed.

•Documented Application Information Document to define the database architecture and flow of data across interfacing databases, applications and the framework underlying and contribute to define the enterprise level architecture for the Insurance service.

•Understand the E2E data flow across applications, key systems, and interfaces.

•Coordinate with multiple vendors and organizations to interview and gather the required information for to create the data-model and define the architectural requirements.

•Create architectural documents such as, the e2e data flow for the IBM Information data warehouse system. Identified security loopholes, established data quality assurance and addressed data governance.

•Defined futuristic Domain Models, Data Dictionaries and MDM

•Crafted Star and Snowflake models to address the business requirements.

•Implemented SCD, Kimball approach to ensure zero or minimal impact on the system.

•Creating an effective POC to meet expectations and bridge the gaps between expectations and reality.

•Create a strategy document to approach to re-engineer the process and re-designing of the system.

•Define conceptual, logical and physical models of the enterprise data system

•Conduct data analysis, profiling and define and document data quality checks.

•Guide data initiative through product delivery lifecycle.

•Ensure the environments are in sync by harmonizing data across them.

•Identify risks in design and device the mitigation strategy and plans to address the loop holes.

•Defined data governance process and document plans to address security and operations.

•Define, design and develop the data migration, initial loads processes.

•Design master data structures and meta-data definitions.

•Installed, created, configured and managed databases from scratch based on the physical model and ensured peak load level performance NFRs are met.

•Application development support activities including database design, optimizing SQL queries, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions

•Defined and Developed strategy for migration and up-gradation of enterprise wide Oracle databases (approx. 35TB +) from UNIX and AIX servers with 16 CPU * 4 Cores each for the data warehouse system and OLTP systems.

•DBA activities includes – Installation, Version Migrations, Instance configuration, Backup/ Recovery, database consolidations, performance tuning and storage management. Daily support activities like maintaining backups, monitoring logs, thread activity, resolving job issues, locking issues and contentions, scheduling administration activities. Managed information within the scalable data ecosystem with Oracle and SQL Server.

Environment: UNIX, Erwin, Meta Data, SQL Developer Data Modeler, Oracle/Cassandra/Hadoop

Wipro Technologies Ltd Hyderabad India July-2010- May2012

Data Architect

Responsibilities:

Helped the Client solve critical business needs by modeling and maintaining the business intelligence database environments.

Primary responsibilities were to logically and physically model source system and business intelligence databases and ensure the overall health and performance of the business intelligence database environment.

Expertly used modern data modeling concepts (star schema, - snowflake schemas, and highly normalized data models) and data modeling tools such as Erwin, Power Designer& ER Studio.

•Defined & developed physical data model in accordance to logical model for ensuring the merger is successful for the OLAP system.

•Developed data merger scripts to handle expectations during the transformation phase and ensure Seibel syncs to account for any changes in the logical and physical model.

•Handled database security and data governance.

•Analyzed business requirements, translate them to data requirements, and understand data relationships within a single domain and across domains.

•Significant collaboration with functional/product owners to understand the business requirements.

•Defined technical requirements and facilitated reviews with peers and lead architects.

•Provided high level design expertise in support of development team efforts to provide flexible reusable components to increase cost effectiveness, analyzes, designs and reviews design to ensure customer specifications are satisfied.

•Involved in production of detailed Logical/Physical model designs and design documentations.

•Leveraging enterprise data modeling constructs, methodologies and practices to ensure flexible, scalable, maintainable, and high performing physical databases.

•Performed extensive data profiling and analysis to validate the business rules and understand the relationships between the Operational data for the Data Model design.

•Creation of New Logical/Physical models and enhancement of existing models as per technical requirements.

•Mapping of Logical design to Physical design to align business requirements and source to target mapping (DW) with transformations.

•Involved with multiple scrum teams to maintain the Logical/Physical models as per the requirements.

•Reported to multiple project owners to help understand the integrity of the model and relationship between entities.

•DBA activities include -Work independently and ensured that the databases are operating efficiently and ensure proper backup methods are maintained. Created and maintained Oracle 10g, 11g R2 development and test databases based on the requirements. Applied CPU patches and upgrading the Oracle database. Performed migration from Oracle 9i to Oracle 10g Release 2.Performance tuned by creating and analyzing explain plan, creating outlines, FBI’s (Function Based Indexes), Collecting and locking statistics using TOAD & SQL Developer. Performed configuration, maintenance and support experience in oracle SYSADMIN role. Use of OEM for troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system and session waits that were occurring.

Environment: UNIX, Erwin, Meta Data, Visio, Oracle

Saints Church, Salt Lake city UT USA Feb 2009- June’2010

Sr Data modeler

Responsibilities:

•I was the Data Architect responsible for all aspects of the database systems used for this very fast paced high profile project. The database was narrowly focused on the internet search domain and was several terabytes in size with multi-billion row fact tables. There were unique challenges due to the size of the data sets, the high cardinality of search data, the short time frame involved, and the requirement to do deep analysis of the “long tail” of end user search requests. Duties over the course of the project included:

•Data modeling – Kimball, star schema design

•Implementing the physical data model to adequately manage multi-billion row fact tables using Microsoft based products on standard hardware

•Setting analysis strategy for individual client deliverables

•Implementing processes for data profiling

•Developed Corporate data models for the clients

•Worked on Meta data with reports extraction in VisioServed as a Senior Business Intelligence Solution Architect in defining, developing, and enhancing of two separate custom DW/BI systems for the corporate loans and investment business units.

•Primary responsibility include but not limited to coordinating, planning, and conducting interviews with various business users in identifying and capturing business requirements,

•Defining and developing project scope/plan, creating and developing two separate multi-dimensional data models using the Ralph Kimball methodology, performing source-to-target mapping, building database schemas in an Oracle8i environment which included creating scripts and procedures for production migration, and building two separate ETL batch processes using Oracle Integration Services (SSIS).

•Additional tasks include the creation of a custom analytical application using Oracle Analysis Services for the investment services in order to track primary and secondary commission by region and salesperson, the migration of the original reporting solution to Business Objects Enterprise (BOE) XI R2, the creation of the migration procedures for installing and configuring BOE in a production environment, performing BOE software upgrade and patch installation in the development environment.

•DBA activities include -Working with the database administrator to design disaster recovery processes for multi-terabyte Oracle databases. Identifying performance bottlenecks and tuning SQL queries

Environment: Oracle 8.x/9.x/10g/11g,RAC,UNIX, Erwin, Meta Data, Visio

Varolii Seattle WA USA Feb'2008- Jan 2009

Sr Data Modeler

Responsibilities:

Served as a Data Warehouse Architect/Consultant in the enhancement and development of a SAP Business Warehouse application at Pitney Bowes Corporation. Responsibilities included but not limited to conducting intereviews with executives, senior managers, SME's, business analysts, and technical staff in capturing and understanding business requirements, and defining project scope; performed detail data analysis of both data elements requested by the business and data source (IMS and SAP R/3), and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart.

Translated business requirements into dimensional data model to support the billing/invoice data mart using Power Designer communicated and/or provided knowledge transfer to consultant (SAP BW Developers), both on and offshore, in the development and support of the project (SAP BW). The following tools and/or technologies were used in the development: MS Windows 2000, Sun Solaris, Oracle8i, SAP BW, Power Designer, and Qualiware.

Primary data architect responsible for the design of master data management application using Erwin technology to bring together data from multiple applications into a single master data repository for consistent use, supporting both operational and analysis requirements. In the initial phase, this cross-functional repository was comprised of 150 categories integrating information from SAP, Oracle ERP, HRIS and a number of legacy applications.

Primary data architect responsible for the design of a cross-functional enterprise data warehouse the data warehouse itself was built using Informatica on an Oracle database with Cognos as the BI Reporting tool. Confirming requirements with business representatives. Defining the ARTS Data Model. Designing and writing back end ETL processes specifications for both reference and transactional data, drawing information from multiple sources including Oracle ERP, Manugistics, and custom applications.Consultant engaged to assist in the modeling and design of a financial data warehouse using ER Studio with Cognos as the BI Reporting tool.

DBA activities include -Updradation of databases.Installation of Flash Back Recovery.OLAP Databases Design. Usage of Recycle Bin. Usage of Online Segments Shrink. Online building indexes. Usage of iSQL-PLUS.Implemented ASM Features in 10g.Usage of Oracle Streams which allows data sharing between Oracle databases and between Oracle and non-Oracle. Normalized Views. Refreshed development and test databases from production database using Exp/Imp to provide the latest data is available in the development/test database for the developers. Installed, configured and administered Standby Database. Cloned databases for testing. Loaded data from flat files to Oracle databases and migrated from older Oracle versions.

Environment: Oracle 10g, RAC, UNIX, ER Studio

Fennie Mae, Bethesda MD USA Oct'2007- Jan 2008

Sr Data Modeler

Responsibilities:

Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.

Expanded Physical Data Model (PDM) for the OLTP application using Power Designer.

Experienced in IDEF1X and IE data modeling methodologies.

Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.

Created rationalized domains to bring consistency in the tables.

Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping. Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Served as a Data Warehouse Specialist/Consultant in the enhancement and development of an enterprise data warehouse/business intelligence application for the automotive services at Automotive Finance Corporation. Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator tool. Additional tasks included the creation of schema objects (tables, views, indexes, packages, triggers, etc.) in an Oracle8i environment, the expansion of a single dimensional data model (star schema) into multiple star schemas, source to target mapping, storage capacity planning and the support and maintenance of the Cognos EP Series 7 reporting environment. The following tools and/or technologies were used in the development: MS Windows 2000 Server, Sun Solaris, Oracle8i, Sunopsis, PL/SQL, Cognos EP Series 7, Erwin, and Oracle Enterprise Manager.

Interaction with customers; identification of business process requirements and information architecture; system design; data modeling; workflow definition; metadata management. (Erwin, Power Designer; ER Studio)

Top-level contribution into creation of software design documents (SDD); definition of data architecture standards; change control mechanisms; technical design reviews; team mentoring and technical leadership in big distributed development teams of system and software engineers.

Design of efficient database architectures; definition of strategy in building database structures; manage data population and migration architecture for application upgrades.

Implementation of data warehouse using ER Studio. This very large project involved a number of resources from multiple consulting firms including ER Studio. Implementing non standard ER Studio processes to support very large dimensions (normally more than 1000 entities).Also involved in optimization and tuning with the application DBAs.

Support the ER Studio implementation of a reference data hub. The reference data hub is designed to feed dimensional data for a number of data warehouse applications.

Use of ER Studio in building a data warehouse application. The work focused on their processes for code control and promotion as well as managing their development and test environments.

DBA activities include -Implementation of complex business logic via triggers and stored procedures; development of ETL procedures. (Oracle PL/SQL,shell scripting - sh, sed, awk, perl). Database administration experience in high availability (Data Guard), clustered (Oracle RAC), large-scale (>10TB), distributed (VPN) and heterogeneous (Informix; Oracle, Sybase) 24x7 production environments; performance tuning; backup and recovery strategies (RMAN); replication; security; capacity analysis; exposure to system administration (Sun Solaris, VERITAS; Linux, SCO Unix, Windows). Combination of OLAP & DSS Systems. Objects sizing Strategizing Backups including usage of RMAN Database Recovery, Involvement in Database Migrations. Snapshots creations. Strategizing and troubleshooting

Environment: Oracle 10g, RAC, Windows, UNIX, ER Studio, Erwin

HCL America Milwaukee WI USA Jan'2007- Oct’2007

Oracle DBA

Responsibilities:

Served as a Lead Data Warehouse Architect in the development of a web-based Enterprise Customer Relationship Management (eCRM) reporting application for the eCommerce department at J.Crew. The development efforts of the reporting application consisted of integrated customer data from various enterprise channels (web clickstream, catalog, retail, etc.), thus providing a consistent view of the customer. Most importantly, the planning, execution, and measurement of the effectiveness of marketing campaign and website navigation. Tasks included conducting requirement analysis, designing and developing of a data model (star schema), the creation a Oracle8i database, coding of ETL procedures (PL/SQL, Perl and Informatica), designing of Cognos Impromptu and PowerPlay reports, software installation, and the automation of production jobs. The following tools and/or technologies were used in the development: MS Windows NT, Sun Solaris, Oracle8I, PL/SQL, Perl, Unix, Essbase, Cognos, Erwin, IIS, and shell scripts.

Supporting 300 Databases which includes production, test & development.

Working in a small dynamic team of software engineers, I am developing data mining solution - an innovative improvement to existing behavioral targeting advertising network. This “machine learning” branch of development is using SAS and ODM on Oracle and Netezza databases.

Being in a small team, I contribute a lot to a production line of development, which is a heavy ETL / OLAP distributed application (>10TB). ETL part processes web logs to produce targetable segments of visitors. OLAP part build cubes for reporting. ETL application is built on IBM, Linux & Oracle 10g platform.

Participate in system design brainstorm sessions – sketching up system design, database models and basic algorithms.

Wrote shell scripts to backup, restore database and automate daily activities.

Installed Oracle RAC with Data Guard implementation for disaster recovery.

Used Erwin, for physical ARTS Data Model design.

Database Design, Backup & Recovery, Design/Code reviews & Materialized Views. Development of PL/SQL.

Revisit existing ETL processes improving many stages by more than 10x times - usually achieving best improvement by tuning algorithms and application logic.

Tune parallel SQL, physical schemas and system parameters

Primary data architect responsible for the design of a data warehouse projects with Oracle ERP and an ER Studio data warehouse for the Client.

Responsible for the analysis and design, using Erwin/Informatica, followed by the co-ordination of implementation, of a data warehouse of sales information. The database was implemented in Oracle 8 under SUN/SOLARIS. Although a variety of analysis tools have been used against the warehouse, it was also built to support direct RAM access from Oracle OEM. The application to maintain and support the warehouse was written using Developer 2000 and 6i tools.

Design and implementation of Oracle form libraries and templates to allow consistent form development across multiple applications. Applications were able to be implemented under Windows, MOTIF or on the web using the Oracle 9iAS server.

Responsible for the analysis and design, using Erwin/Informatica, followed by the co-ordination of implementation, of a national system to collect sales, distribution and production data from multiple sources, and organize it for sales forecasting and production scheduling. Actual forecasting and production scheduling was done outside of the database using a number of analytical applications. The Oracle database and application was designed to support measurement and analysis, including functions to assist in supply chain management.

Excellent interpersonal and strong analytical, problem-solving and conceptual skills

This project is in study phase which has to be implemented in 3 tier architecture.

This project Installed oracle 9i & applied patch set on development & production server.

Setup the advanced replication for a single master site & a snapshot site in development & production.

Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.

Environment: Oracle 10g, /11i, RAC, UNIX

Indian soft Technologies Hyderabad, TE India Aug 1998 to Jan'2007

Database Designer & DBA

Responsibilities:

Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project. Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users. Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along with deeper

Understanding of business rules and data integration checks. Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse. Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.

Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.

Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.

Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions. Worked on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team.

Worked on Mercury Quality Center to track the defect logged against the logical and physical model. Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.

Worked with client and off shore team to make sure that the reports and dashboards are delivered on time. Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System.

Worked with the test team to provide insights into the data scenarios and test cases. Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.

Analyzing the Database/Database Maintenance, Data warehousing/Database Design, Design and Development Of database design

Data modeling using Erwin, Power Designer, Database (SQL) design, installed database in Sun Solaris on staging server.

Software design of medium/large business applications/Design methodologies

Tuned database parameters and applications for optimal performance.

Responsible for support of the databases and database servers which includes performance monitoring, performance tuning, optimize programming code/ SQL, troubleshooting and client support.

Environment: Oracle 9.x, UNIX, Shell Scripts, DB2, SQL-Loader

Contact this candidate