PROFESSIONAL SUMMARY:

• Analytical and pro - active Data Architect with 9+ years of progressive IT experience in Government, Retail, Telecom & Media industry. Proficient in discussing & analyzing interpret detailed business requirements to assist in development of conceptual, logical and physical models, mappings, domains and data dictionaries.
• Acknowledged for in-time delivery of high quality data architecture in OLTP and OLAP environments adhering to compliance and confirming to project requirements using multi dimension modeling, ER diagrams, Star, Snowflake and Facts. Experienced in SDLC, agile, sprints and project management methodologies in complex large projects. Experienced in RDBMS such as, DB2, Oracle & Daytona.

TECHNICAL SKILLS:

Data Modelling: InfoSphere Data Architect, ERwin, RSA, Microsoft Visio, InfoSphere Data StudioDatabase/Systems OLTP, OLAP, E-R, Oracle,DB2, Daytona, Informix, Sybase, SQL Server, ETL, DW, MSIB, SSRS, SSIS

Quality: HP QC, ALM, RQM, Rational Team Concert

Database Tools: TOAD, SQL Developer, OEM, Oracle EBS

Operating System: Solaris, Linux, Windows, AIX

Programming: PL/SQL, Cymbal, C/C++, Shell Scripting

Others: Oracle Firms, Web Methods, VSS, Office, Microsoft Project, SAP, Siebel, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Data Architect & Sr. DBA

Responsibilities:

• Understand the E2E across applications, key systems, interfaces and document the data flow for the ETL data warehouse system.
• Conduct data profiling and define and document data quality checks.
• 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.
• Involved in design, development, implementation and support for MDM solution.
• Defined and develop data conceptual, logical and physical data model.
• Developed ER models and use normalization and de-normalizations in the logical models as required.
• Guide data initiative through product delivery lifecycle.
• Define, design and develop the data migration, initial loads processes.
• Design master data structures and meta-data definitions.
• Ensure the environments are in sync by harmonizing data across them.
• Managed information within the scalable data ecosystem with Oracle and DB2.
• Defined backup and recovery strategies to ensure high availability.
• Create the database and all required objects as per data model.
• Support and maintain existing data systems.

Confidential

Data Architect

Responsibilities:

• Authored micro and macro design documents for the ETL data warehouse, OLTP and OLAP systems.
• Chaired data model reviews with Clients and gap analysis to ensure client audits gates are passed.
• Identified security loopholes, established data quality assurance and addressed data governance.
• Discussed with clients to identify their needs, define detail requirements and outline the solution with a POC
• 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.
• Provided consultancy for new feature evaluation and product related issues/queries
• Implemented DB2 Blu analytics and migrated DB to improve performance exponentially.
• Defined of a data strategy and associated polices
• Configured and installed NOSQL for DB2 & Text Analytics
• Created database based on the design and ensure to meet the NFRs
• Coordinated with IT Analysts to reflect complete set of data entities.
• Established data assurance procedures and reported discrepancies to IT Staff
• Created the end-to-end logical & physical data model for JBMS and addressed data problems.
• Installed, created, configured and managed databases from scratch based on the physical model and ensured peak load level performance NFRs are met.
• DBA activities includes - Installation, Version Migrations, Instance configuration, Backup/Recovery, database consolidations, performance tuning and storage management.
• 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
• Daily support activities like maintaining backups, monitoring logs, thread activity, resolving job issues, locking issues and contentions, scheduling administration activities.

Confidential

Data Architect & DBA Team Lead

Responsibilities:

• Designed ER Diagrams, database integrations, analyzing cross platform compatibility
• Defined data models, architecture for including migrations and setups
• Developed star and snow flake schema models for OLAP data warehouse.
• Implemented SCD and Kimball methodology for data models
• 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 ETL data warehouse system and OLTP systems.
• Successfully Migration and Upgrading from 10g Oracle Forms Server to 11g on Win7 and UNIX framework.
• 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 Retail service.
• Developed Database Migration Cookbook containing steps and procedures with end-to-end migration details and steps to be followed.
• Leveraged the Oracle Enterprise Manager to monitor batch loads on Oracle databases server by accessing to the different features of database.
• Created and moderated Change Request in BMC Remedy, Oracle Metalink for physical infrastructure support for database tasks.
• Ensured good response and feedback to client with no slippage to SLA based on the application support level

Confidential, New Jersey

Data Architect & DBA Team Lead

Responsibilities:

• Developed Star models for ETL data warehouse databases and successfully added new dimensions to the OLAP models
• Implemented SCDs to handle data updates along with processes and rules for governance.
• Created data model and databases for OLAP systems and to support COGNOS report generation.
• Subject Matter Expert on Oracle, Daytona and DB2 databases.
• Performed the successfully the migration of all the 8 applications in Oracle databases in GCP on UNIX and Sun Solaris Platforms using C and Perl.
• Defined and developed ETL process for data warehouse and OLAP systems
• Provided complete creation, management, deployment and enhancement for Dev, IT, ST, UAT and Production databases using the OEM, ERwin and Toad.
• Performed business requirement analysis with clients, designing solutions, performing Unit Testing, performing Integration Testing, performing Deployment and doing Approvals, till Go-Live in production environment.
• Provided Knowledge Transfer to new resources on the 16 applications and 64 databases of GCP Daytona and Cymbal Technology - 4th generation language.
• Followed and explained the SCME version control to new joiners, to keep the code consistent across generics and releases.
• Build, enhance and maintain existing and new applications and databases in Development, Integration Test, System Test, User Acceptance Test and Production environments.
• Moderated tickets through completion and deployment using the Rational Clear Quest.

Confidential

Data Architect & Sr. DBA

Responsibilities:

• 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.
• Created shell scripts to enable general users to startup, shutdown databases, automate export, backups using SQL and PL/SQL to automate tasks and setting up cron jobs for database monitoring, maintenance and database backups.
• Created and maintained Oracle 10g, 11g R2 development and test databases based on the requirements.
• Applied CPU patches and upgrading the Oracle database.
• Improved and streamlined Confidential Customer Relationship Management (CRM) tool.
• Performed migration from Oracle 9i to Oracle 10g Release 2.
• Performed cloning, logical and physical backups of the databases.
• Oracle server and client installations and configurations using OEM (Oracle Enterprise manager).
• Performance tuned by creating and analyzing explain plan, creating outlines, FBI’s (Function Based Indexes), Collecting and locking statistics using TOAD & SQL Developer.
• Provided technical support to application developments teams.
• Work independently and ensured that the databases are operating efficiently and ensure proper backup methods are maintained
• Performed configuration, maintenance and support experience in oracle SYSADMIN role
• Use of OEM for troubleshooting like adding space in datafiles, rebuilding indexes, check alert log file and monitoring of system and session waits that were occurring.

Confidential

Database Administrator

Responsibilities:

• Installed, configured & managed Oracle 9i databases and Informix Dynamic Server 10.
• Maintaining and creation of Roles, Users and Users profiles.
• Efficient on-site coordination with the correct scripts and documents for implementing the changes into Production using Rational Clear Quest, Rational Req Pro, Rational Portfolio Manager and Quality Center.
• Provided technical knowledge to developers and testers on DBA issues.
• Received appreciation from the clients and team members.

Confidential

Intern

Responsibilities:

• Successfully coded and implemented the concept of i18n (internationalization) so that the software can be internationalized to enable it for the input of Japanese i.e. non-English characters, which are multi-byte characters. The input can be given in Japanese language and the output too can be obtained in the local language.
• Coded the wrapper functions that are used for the mapping.
• Coded x-curses and the modules specified were used to build and update the code for the multi-byte characters.
• Successfully implemented the mapping from the front-end to back-end.

Confidential

Trainee

Responsibilities:

• Learned about SAPinst is the standard SAP installation tool, covering a broad range of platforms and products and both the ABAP and Java technology.
• Learned General Administration like SAP - MM, Stationary management, Asset management, Time and Attendance system from the SAP HR system.
• Learned about strategic migration from single to multi-entity business model in SAP.