SUMMARY

• More than 7 years of experience as a Data Architect/Modeler in IT, across various phases of development lifecycle (SDLC) including product design, development, re - engineering, and enhancement initiatives with expertise in the fields of Media & Entertainment, Payroll & Accounting and Banking domains.
• Extensive experience in Business Performance Management, Process Management, Business Process Reengineering, and Enterprise Application Integration.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and the smooth structural flow of the data.
• Experience in Data Transformation, Data integration, Data Migration, Data profiling, Data reconciliation, Data Loading, Modeling and Performance Tuning.
• Desensitize personal information using Optim test data management.
• Extensive experience of Installation, Configuration and Advanced Database Administration.
• Experience in database design & analysis, storage management and maintaining data, backup and recovery.
• Experience in performance monitoring & tuning and benchmarking.
• Immaculate ability in technical writing and documenting Business Requirements Document (BRD).
• Proficient in user requirements gathering, Use Case design and analysis, business processes, work flow diagrams and process flow
• Experience in database programming like stored procedure, triggers, cursors, functions etc.
• Experience in writing Data Mapping Documents and Data Dictionary for better understanding.
• Strong experience in data modeling and in building dimensional models using different modeling tools like ERWin, Infosphere Data Architect
• Experience with data warehousing methodologies, data mining techniques
• Extensive knowledge in concepts of OLAP, OLTP, ODS, RDBMS, Multidimensional Data Modeling schema, and Metadata Repository.
• Comprehensive knowledge of Incident Management, Change Management, Problem management and Demand Management.
• Expertise in working with data management performing data analysis and gap analysis
• Expertise in unix scripting on various flavors of Unix (HP - UX, IBM - AIX, Sun Solaris, Linux).

• Technical Lead
• Data Modeler/Architect
• Business/Data Analyst
• Database Developer
• Database Administrator
• Media & Entertainment
• Banking
• Finance, Payroll & Accounting
• Highly analytical
• Good problem solving skills
• Project Planning and Documenting
• Project Management
• Team Building
• Release Management

TECHNICAL SKILLS

Data/Business Modeling: MS Visio, Erwin, ER Studio, Infosphere Data Architect

Software Development /Change & Repository Management: Rational ClearQuest, Rational ClearCase, PVCS, StarTeam, Service - now, Mingle

Data Warehouse Concept: ODS, Star Schema, Snowflake Schema, OLTP, OLAP

Application Servers: Websphere Application Server, Weblogic Application Server, JBOSS

Third Party Tools: eVMI (Electronic Vendor Managed Inventory), D-series, CA workload automation tool, IBM data movement tool, Meet DB2, Command center, Toad, PL/SQL developer, SMITTY (IBM AIX), SAM (HP-UX), X-manager, HP open view data protector, Glance plus, Eclipse, I2 Demand Planning, Data Studio, Squirrel, Data studio, JD Edwards, Q-Replication

Databases: MS-SQL Server, MS Access, Oracle 10g/9i/8i, DB2, ISAM

Operating Systems: Windows NT/95/2K/XP/Vista, Unix(HP-UX, IBM-AIX, Sun Solaris), Linux

Languages: C, C++, Java, SQL, PL/SQL, MySQL, DHTML, UNIX, Shell Scripting, Perl, Visual basic, COBOL, XML,LUA, OPTIM programming

Data Masking software: Optim test data management tool

ETL Tools: WebMethods, Datastage

Performance Monitoring tool: DB2MON, Spotlight, Foglight, Optim Performance Manager, Big Brother

Quality Control: HP Quality Center

Business Skills/Process: Business Definition Requirements, JAD/RAD Sessions, Gap Analysis and Impact analysis, MS Visio, Waterfall model, Agile, Test Manager

PROFESSIONAL EXPERIENCE

Confidential, Burbank

Sr. Database Architect

Responsibilities:

• Design, develop and implement conceptual, logical and physical data models for applications and systems performance, scalability, data quality and privacy; create end-to-end vision on logical design translation into one or more physical databases, and data flow through the successive stages.
• Assess and determine data governance (metadata management), stewardship, and frameworks for managing data across the enterprise.
• Perform data profiling, understand source data and models data to accommodate any nuances.
• Plan and implement project level technical data architecture including management, storage, security, access, navigation, movement, transformation of data and test data management.
• Create strategies and plans for data capacity planning, data security/masking, life cycle data management, scalability, backup, disaster recovery, business continuity, and archiving.
• Reviewing and conduct performance tuning of anything connected to data systems, ensure efficient operations, and maximize resources to provide the best results;
• Validate database designs for accuracy and performance and optimization of database queries for a specific project
• Analyze, Optimize and derive conversion and migration methods for existing data, and developing automated conversion and migration methods including phased transition from ISAM (legacy system)/flat files to DB2 database
• Define archival /retention Strategy based on history data/replication requirements.
• Define Infrastructure strategy for ETL and Database to achieve high-volume data movement, data replication, data transformation and data integration, load-balancing & high availability and to support all project initiatives.
• Reverse engineer relational schemas, Identify and resolve inefficiencies in database designs recommend improvements and help team members build scalable database architecture.
• Analyze and evaluate applicable emerging technologies for adoption; Identify toolset to facilitate: mapping of data sources, master data management, data quality, data movement documentation, metadata management and data modeling.
• Implemented and maintained Master Data Management.
• Creating and implementing project level data backup and recovery architecture.
• Enforce semantic consistency across the enterprise;
• Provide first level operational support for development and production database systems
• Understand and communicate the data requirements of any future infrastructure needs, work with the IT architects to develop an approach that fits the current and planned needs.
• Acted as liaison between business architects and the database management team and software development/integration teams.
• Performed feasibility, adaptability study and risk analysis to identify critical areas for the proposed change request.

Technology:DB2, SQL Server, ERwin, MS Visio, Optim Test Data Management (TDM), Optim Performance Manager (OPM), IBM- Data Studio, Connx, Spotlight, DB2MON, Infosphere Data Architect (IDA), Datastage, ISAM, Toad, Linux, Q-replication, Rational ClearQuest, Rational ClearCase, Netbackup, JBOSS, Mingle

Confidential, Culver City, Los Angeles

Lead Application DBA/Developer, database architect

Responsibilities:

• Understanding the business requirement
• Study of data sources/systems
• Interviewed business users to create and understand requirements
• Capturing requirements and converting into architecture mapping document
• Participate in business development and strategy session as advisor
• Understanding technology limitations/features (including hardware, OS, database, multi-tier component and their interaction) and setting right expectations.
• Designing table structure based on business requirement and their use.
• Acted as Enterprise Consultant and Data/Database Subject Matter Expert
• Enforced Architectural standards like Security, Availability, Replication, Storage and configuration management.
• Enforced design standards and database development standard and process.
• Designed logical and physical data models, enterprise data dictionary.
• Defined Enterprise Metadata, Data sources, business rule, data rule, extract rule and transformation.
• Ensured data cleansing, data integrity and data quality and archive/purge standards.
• Create and manage trigger, stored procedure, cursor and view based on business requirement.
• Provide SQLs to web developer for development of screen.
• Providing technical expertise in infrastructure platform support throughout all phases of break-fix (problem identification, resolution, test, deployment, and turnover).
• Serve as primary contact between the application teams and IT support groups (DBA, Middleware, Application Change Control, etc.)
• Worked on the proposed database design, development, and creation of all file system layouts, database environments, referential integrity relationships/constraints, security environment roles etc.
• Assisted with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes).
• Perform capacity planning and analysis and implement required changes on the database server.
• Planned, designed and implemented MQT and Data partitioning for improving performance.
• Turnover stored procedures and rebind them as needed to support implementations.
• Created, maintained and implemented Stored Procedures and triggers in DEV, QA, and Production database system
• Writing and running self-security-monitoring shell scripts to ensure that right authorities and privileges assigned on users.
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Responsible for application SQL Query tuning, database parameter tuning, operating system tuning, memory tuning.
• Advise Business Systems Analysts, technical managers and business users to help them define business requirements and objectives in the implementation of specific area advanced technologies.
• Analyze past trends and make suggestions to meet future requirements with respect to capacity and performance.
• Use tools like db2advise, db2look, db2move and db2audit to monitor, analyze and make changes in the database.
• Migrate and/or coordinate the migration of application systems from test (for quality assurance) to production environments.
• Conduct performance analysis on application SQL code and assist in troubleshooting by providing solutions or directions that are consistent and effective.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates and table access activities.
• Taking Snapshots and gathering other information related to the database and the system during stress tests or performance tuning
• Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Plan and implement disaster recovery(HADR) and standard recovery testing using established documentation
• Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions.
• Work with DB2 IBM support on problems and questions.
• Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases.
• Maintaining and supporting Electronic Sales Planning and Forecasting (ESPF) and Electronic Vendor Managed Inventory (EVMI) for Home Entertainment of Confidential (VMI) for SBT(scan based trading ) and VMI (Vendor Managed Inventory) customers.
• Developed and support application to adjust seasonality index based on sales for various stores and allocate forecast to stores of all accounts based on their profiles.
• Supporting analyst to react to demand by overriding the forecasts, seasonal planning and promotional planning
• Managing master data like Store, sister stores, SKU, item, item constraint, bill of material etc. for various accounts.
• Ensuring the sales, on hand, cycle count and physical inventory are up-to-date in system.
• Maintaining and managing planograms(daily, new release, reset etc)
• Coordinating VMI analysts in plan creation (daily replenishment, auto replenishment, out of stock plan, reset plan, hot order plan etc.) for replenishments.
• Monitoring and ensuring that Purchase order creation and updates are smooth until orders are shipped from DADC.
• Coordinating to VMI Analysts in reacting to seasonal demands/out of stock demands through hot orders.
• Maintaining and supporting ticketing and pricing for various items.
• Facilitating Business planners and VMI analysts with various types of reports to be able to plan for demand.
• Setting up various kind of constraint (item level, DC level, order level etc.) for replenishments.
• Maintaining optimal stock-keeping unit (OSU) and various formulas and parameters for replenishments.
• Adjusting VMI profiles for customers based on customer’s requirement.
• Maintaining the data from back-end tables and managing the tables.
• Maintaining the health of key tables and batch-jobs.
• Providing on-call support in case of any abnormal functioning of system.
• Co-ordinate with the team members and ensure the Project Release is as per the mile stone designed and managing all deliveries.
• Communicating with customers, understanding their requirements and demands.
• Providing soft estimation(SWAGS) and hard estimates for any enhancements
• Preparing the managing release plans, weekly reports.
• Mentoring and managing offshore and onsite teams & managing all deliveries
• Adhering to SDLC Life Cycle for any enhancements in Confidential and maintaining the quality and standards of deliverables.
• Rich experience in Incident Management, Change Management, Problem management and Demand Management of Confidential using Service Now Tool and ITIL processes
• Experience in creating project plan, budget the effort in person hours and identify and allocate resources.
• Mentoring and managing offshore and onsite teams & managing all deliveries.

Technology:Electronic Vendor Managed Inventory (EVMI), Electronic Data Interchange (EDI), Erwin, Service-Now, MS Visio, WebMethods, DataStage, JDEdwards, JDA - I2 demand planning software, db2mon, TOAD, PHP, Java, Star team, Sharepoint, Websphere Administration Server(WAS), Unix (Solaris), Windows Server, DB2 9.5, D-Series, CA workload automation system

Confidential

Lead Database Administrator

Responsibilities:

• Data Maintenance, export & import of data(even from other RDBMS like oracle)
• Monitoring and optimizing the performance of the database, tuning database performance.
• Analyzing and evaluating the results of performance testing.
• Test data script modification and test data preparation
• Working with application team to minimize deadlocks.
• Analyze application SQL for performance improvement opportunities and work with IBM support on problems and questions.
• Planned, designed and implemented index and partitioning key strategies on multi-Partitioned DB to minimize data shipping between partitions for improving performance.
• Improved DB system and SQL performance by rewriting SQL and tuning partitioning key, buffer pool, sort area, active log files and temporary tablespace and by analyzing access plan for development, QA, UAT and Production environment databases
• Monitored and tuned DB system analyzing log files, Snapshot monitors and Event Monitors for Develop, QA, and Production environment databases
• Evaluating database server’s hardware & software.
• Allocating system storage and planning future storage requirements for the database system.
• Analysis & implementation of database structure.
• Planning and Implementing the Database Design.
• Migration of database structure which involved federation, tablespaces etc.
• Migration of database objects (Tables, Views, Indexes, Constraints, Synonym, Sequences, Packages, Stored procedures, Functions, Triggers, Sequences) from oracle 10g to db2 v9.7
• Migration of users, privileges and roles from oracle to db2
• Data migration from oracle 10g to db2 v9.7.
• Data maintenance through import, export & load
• Providing support to application team while code migration which involved unsupported error code of oracle in db2,unsupported functions, different max limit of datatypes and sequences in both RDBMS,JDBC connections, connection to database in script using clpplus.
• Mitigating deadlocks by tuning SQL, setting registry variables and database parameters.
• MCoordinated DBAs of other project to build large data warehouses on DPF(EEE) system
• Developed and implemented backup(online, offline), runstats, reorg, rebind, and tablespace capacity monitoring report using Korn shell scripts on DEV, QA(UAT), and PROD system
• Planned, Designed and implemented MQT and Data partitioning for improving performance
• Installing & configuring of DB2 on UNIX and windows servers.
• Ensuring compliance with DB2 license agreement.
• Simulation before any major activity (like up gradation etc.) on DB2 servers, database upgrade and applying fixpacks.
• Creating primary database structures (tablespaces, bufferpools, instances etc.).
• Creating primary objects (tables, views, indexes, sequences, packages etc.).
• Modifying the database structure, as necessary, after collecting information from application developers and based on statistics gathered.
• Enrolling users and maintaining system security, controlling and monitoring user access to the database.
• Collecting information about database resource, memory & CPU utilization, network usage and I/O contention in busy hours & idle hours and doing maintenance.
• Reorganizing tables and indexes, collecting statistics and rebinding of packages.
• Monitoring and optimizing the performance of the database, tuning database parameters, memory, bufferpools and SQL. Maintaining an optimum hit ratio for (bufferpool, catalog, package) etc.
• Planning for backup and recovery of database, table and schema level.
• Backing up and restoring the database included redirected store, configuring database to archive mode, maintaining archived data on tape.
• Replication and Migration of databases across heterogeneous platforms.
• Stand-by database management by configuring High Availability Disaster Recovery (HADR), Automatic client reroute(ACR),log shipping and applying, DR drills to ensure smooth working of Standby Database in event of disaster, switch-over and Q-replication.
• Handling database related production issues and troubleshooting database errors.
• Automating repetitive and mundane tasks, Managing and monitoring database scheduled jobs
• Developed “command center” tool for monitoring Tablespace utilization, Hit ratio of data buffers, CPU & space utilization of oracle database.
• Prepared and analyzed daily, weekly & monthly reports of database health.
• 24X7 on-call support and problem resolution.

Technology:DB2, Oracle 10g, COBOL, Java, SQL, Shell script, Meet DB2, IBM data movement tool, IBM content manager, Websphere application server(WAS), Weblogic application server, HP-UX, IBM-AIX