EXPERIENCE SUMMARY

• Over 18 years of experience in information technology as Database Modeler Architect with main emphasis on planning, designing and implementing end to end database solutions for various business needs.
• Experienced in designing and implementing N tier solutions
• Well versed with RAID and other storage technologies
• Good knowledge of various operating systems like Solaris, LINUX, AIX, windows including installation and configuration.
• Experienced in MPP and VLDB 25-40 tera bytes
• Planning backup and recovery strategies
• End to End performance tuning which includes application server, database server and web server
• Good knowledge of Application servers, java, web servers, LDAP, single sign on and other web technologies.
• Oracle Partitioning
• Data warehousing
• Data Modeling in Erwin, Designer, Power tools
• Capacity planning
• Database Replication
• Real Application Clusters
• Excellent Documentation skills
• Excellent communications/Project management skills
• Data Warehousing Tools Informatica, Brio, Cognos
• Experienced in star schema and its variants like snow flake and modeling slow changing dimensions
• Very Analytical minded and have great experience in designing business intelligence reporting.
• Data governance and quality using data lineage and profiling
• Healthcare Domain Knowledge
• Experienced with all phases of systems development cycle encompassing the Business Process Cycle including requirement gathering, features functionality specification, preparation and presentation of prototype models, quality assurance and preparation of user manuals implementation.

TECHNICAL SKILLS

• RDBMS : ORACLE 11g,10g, 11i, 9i, 8i, 8.0.4, 8.0.3, 7.3.X, 7.2, 7.0.16 ,
• SYBASE, DB2, MYSQL
• OPERATING SYSTEM : SOLARIS 2.8, 2.7 , LINUX, HP-UNIX, SCO-UNIX, AIX,
• WINDOWS, MVS
• SOFTWARE : OAS, Erwin, PL/SQL, SQL NET, SQL Plus,
• PRO C, WEBLOGIC, apache,
• Iplanet, SQL LOADER, OEM, Brio Query, QMF, COBOL.
• HARDWARE : SUN SPARC, HP-UX/Dell Servers, and IBM Mainframes

PROFESSIONAL EXPERIENCE

Confidential

Lead Solution Consultant

Description:

• Worked on an application that submits Medicare claims for Risk Adjustment and Calculation. Kaiser has 7 regions and data needed to be collected from all regions and then converted into standard 837 formats before it can be submitted to CMS.
• Lead solution consultant for evaluating existing architecture and technology and suggest new options to move to a better scalable solution while leveraging existing capabilities and processes.
• Collaboration with key stakeholders compliance, Enterprise Architects and business on solution architecture and future needs
• Responsible for gathering requirements from Business and converting them into detailed technical requirements for delivery team.
• Lead solution architecture for hardware, software and other vendor applications.
• Responsible for putting proper processes in place to ensure data accuracy and security as the data flowed through different aspects of the application.
• Collaborated with stakeholders on application thresholds, data retention and purging to gather data for capacity planning and then propose right hardware/software solution.
• mentoring new team members and bringing them up to speed with domain knowledge and Kaiser processes
• Responsible for proposing solution to move the data processing from CCF Kaiser format to industry standard 837 format
• Responsible for solutioning the changes to the existing Medicare application so that it can also handle Medi-Cal claims

Confidential

Sr. Data/Performance Architect

Description:

• Worked on a mobile security application that will provide parental controls and virus security for mobile users in enterprise and consumer market. Application also provides user with ability to backup data, contacts from the device and also provides the ability to send commands to the device from web interface for lock downs etc.
• Responsible for enhancing and modifying the design of the existing database to make it more performance and business oriented
• Responsible for scaling the existing application to millions of concurrent users
• Responsible for modeling new features and various reporting tables
• Responsible for profiling application for performance and scaling purposes
• Responsible for working with customer to gather business requirements and reporting needs.
• Responsible for prototyping various new features using sql and presenting it to team
• Responsible for evaluation of new technologies like mysql cluster and data encryption
• Responsible for performance tuning and working with QA/performance group to troubleshoot any issues in the application
• Responsible for upgrade plan and steps to upgrade mysql from 5.0 to 5.5
• Responsible for mining reporting data and advising business on analytical reporting.
• Responsible for profiling Linux hardware and storage for optimal performance.
• Responsible for writing functional specs for new features/design changes and getting it reviewed from business and management.

Confidential

Sr. Data Architect

Description:

• Responsible for designing and implementing a Data warehouse for mobile analytics. Also took over the role of data analyst to go through data to find interesting patterns and design algorithms to make the product more useful for the customers. Traveled all over the globe to gather requirements from the customers and troubleshoot performance issues in the field.
• Responsible for enhancing and modifying the design of the database to make it more performance and business oriented
• Responsible for creating a master data repository to track the source, various transformations, percentage of errors in order to maintain data integrity and accuracy.
• Responsible for ensuring Data lineage in the ETL and the database processes to ensure data quality
• Responsible for sampling and profiling data to ensure data quality and accuracy of different subscriber segments
• Responsible for validating parsing schemes of the data before it is loaded so that the data integrity is maintained through out the system
• Responsible for validating the data transformation logic to ensure accuracy of the resulting data.
• Responsible for documenting the transformation logic, sampling/profiling logic and validating the same with the business users.
• Responsible for going to customer locations and trouble shooting performance issues and doing capacity audit
• Responsible for migration of a 24 TB database from solaris to linux
• Responsible for migration plan to RAC which includes testing for performance and functionality issues
• Lead a team of 3 DBAs and a group of DB resources in India
• Responsible for designing the backup strategies for the database and provide input to production support and field whenever needed
• Responsible for helping the developers in writing and tuning various queries for performance and better resource utilization
• Responsible for working with product management to gather requirements and design the reporting needs
• Responsible for trouble shooting any performance/bug related issues and implementing fast and reliable solutions to fix them
• Responsible for upgrades of the product from 10G to 11G.
• Wrote lot of PL/SQL to implement various algorithms for business rules

Confidential

Sr. Database Architect/ Lead DBA

Description:

• Responsible for designing and implementing a Data warehouse and reporting database for SaaS/ecommerce business. Data is received from different clients daily and loaded into the database. Data sent include URL's of images, Videos and Animations. All the data is stored in MYSQL but later it was migrated to use Oracle Real application clusters.
• Responsible for designing the database from grounds up starting with gathering information from business and evaluating customer needs
• Responsible for coming up with a flexible design intended to work with TERA BYTES of data within budgetary constraints without compromising the quality and response times. MYSQL database was used for this purpose
• Responsible for managing all the development databases MYSQL and Oracle and keeping them up to data with latest patches and code changes
• Responsible for migrating to Oracle 10G Real application clusters
• Responsible for designing the archival and summarization of data for reporting needs
• Responsible for designing the backup strategies for the database and working with the 3rd party vendor doing the production support
• Responsible for helping the developers in writing and tuning various queries for performance and better resource utilization
• Responsible for working with Business to gather reporting requirements and communicating the same to the 3rd party vendor to implement these reports
• Responsible for trouble shooting any performance/bug related issues and implementing fast and reliable solutions to fix them
• Responsible for analyzing data and provide input to developers about the false positives and false negatives in order to ensure the data quality
• Responsible for automating the data loads using Unix Shell scripts and PL/SQL procedures
• Responsible for implementing queuing mechanism in the database for fast response time for end users using PL/SQL procedures and summary tables
• working with Java team to test the overall application for performance and bugs

Confidential

Sr. Data Architect/Technical Lead

Description:

• Worked for the group managing the Compliance and RMI database for regulatory requirements. The database is a 2TB oracle database and act as a warehouse for fraud monitoring/alerting application. Data is collected from different sources in the company on daily/weekly/monthly basis and loaded into the database nightly using SQL LOADER/INFORMATICA. Each night a batch is run to generate alerts and populate reporting tables. Brio is used by end users to view reports/run adhoc queries
• Responsible for overall architecture of the application including evaluating current and future hardware/software needs, Disaster recovery, Backup procedures, Security, Data validation and integrity
• Responsible for working with other groups in the company to ensure data governance and single view of customer data.
• Responsible for validating and testing the parsing schemes for various data sources to ensure data quality
• Responsible for validating the accuracy of fraud detection algorithms by creating a sample of data and running it through the algorithms.
• Responsible for creating a master data repository to track the source of data, transformations , errors and reporting to ensure quality, data lineage and integrity.
• Creating and maintaining documentation for different aspects of the application including architecture, ECP, enhancements, upgrades
• Providing support to other groups in the company for reviewing the data model, design architecture and provide documentation for the work being done by vendors.
• Lead the effort to migrate the application from Solaris to Linux architecture
• Supporting application team in designing and deploying database objects based on various business needs.
• Actively monitoring the application and batch for bottlenecks/Lack of automation/Fault tolerance and architecting solutions to rectify the same.
• Lead the upgrade from 8i to 9i and performance tuning effort of the database to resolve issues arising out of the upgrade of the database
• Troubleshoot problems in the database related to bugs/application issues
• Support batch related database and application issues
• Troubleshooting INFORMATICA and BRIO issues with the help of developers
• Designed a cost effective Disaster recovery solution for the application using NAS
• Participated in successful testing and implementation of the ECP procedures

Confidential

Tech Lead/Architect/Sr. DBA

Description: Worked for different clients listed below.

Confidential

Tech Lead/Sr. Architect

• Gathering requirements from different groups as to there problems with the existing system, types of usage and peak times of usage
• Capacity planning and documentation
• Worked with Network groups to plan network bandwidth and review existing network settings like packet size.
• Planning and implementing the security for the application.
• Planning the Storage configuration and coming up with a solution as to which type of RAID will be used for different physical partitions.
• Worked with the Vendor to configure storage and install Oracle 9i RAC on 4 node cluster
• Planning the migration strategy to move the current application to the new hardware platform.
• Working with the DBA to migrate existing 8i database to 9i release 2 databases on both Windows and Linux environment.
• Planning and implementing the backup and recovery procedures for both front-end and backend servers
• Planning and implementing the daily monitoring of the application using oracle enterprise manager.

Confidential

Sr. Oracle DBA/Architect

• Gathering requirements and documentation
• Working with the Java Architect, SYSADMIN, Storage group to come up with optimal architecture
• Logical and Physical Designing of the Data Model/Schema using Erwin
• Troubleshooting performance issues for the application
• Planning and implementing the data migration strategies to move the data from different sources and legacy systems into the new environment
• Helping client plan capacity of the system for the future data requirements
• Created Data Migration procedures using INFORMATICA or SQL Loader or both wherever appropriate
• Improving the performance of the database by optimizing SQL statements,
• Sizing the database memory structures and Tuning the various init parameters for the Oracle Database
• Maximizing the Performance of the Database by using Oracle Partitioning for some of the bigger tables and using bit map indexes wherever applicable

Confidential

Oracle DBA/SYS Admin

• Installation of Solaris OS.
• Configuring SUN storage arrays with RAID 0 1 and 5
• Installation of Oracle Server 8i.
• Installation of Oracle 11i.
• Providing 24/7 supports for all production databases.
• Managing Standby Databases and logical/physical backup/recovery of the Databases as needed.
• Installed Oracle Application Server, Oracle Forms and Reports Server.
• Tuned the 9i OAS server for better performance for report generation and execution.
• Providing regular Oracle DBA and Solaris SYS Admin support to different groups.
• Improving the performance of the database by optimizing SQL statements, indexing tables properly and analyzing the schema on periodic basis.
• Analyze the database through scripts to collect statistics for future capacity planning
• Creating primary database storage structure tablespace and primary objects tables, views, clusters, indexes, etc., once the application has been designed
• Doing Performance tuning to improve the performance of database
• Working with integration group to make other softwares like Netegrity SiteMinder work with oracle.
• Helped setting up the Content Management Database.
• Applying patches to 11i .

Confidential

Oracle DBA,

• Installation of Oracle Servers 8i on Unix and windows.
• Configured Oracle to accept connections using IIOP protocol for Java and Corba Clients.
• Responsible for Logical and Physical Designing of Oracle Databases.
• Used Erwin as Data modeling tool to design schemas.
• Creating primary database storage structure tablespace and primary objects tables, views, clusters, indexes, etc., once the application has been designed.
• Implemented distributed environment using MTS as well as Dedicated server architecture
• Improving the performance of the database by optimizing SQL statements, indexing tables properly, using cost based approach wherever possible.
• Implemented several security measures like ORACLE Password utility, User Profiles.
• Responsible for logical/physical backup/recovery of the databases as needed.
• Coordinated with the programmers and system analyst in Database modeling.
• Analyze the database through script to collect statistics for future capacity planning
• Worked with Network administrators to enable remote clients access the Oracle services and identify network bottlenecks like Packet size.

Confidential

• Designed and implemented a data warehouse for Billing and Audit center.
• Installation/Upgrading Oracle Servers 7.3.x and 8.0.5
• Responsible for Logical and Physical Designing of Oracle, Sybase and DB2 Databases.
• Design the Migration plan to step by step upgradation of database from Oracle 7 to Oracle 8 along with strategy to revert back if needed
• Creating primary database storage structure tablespace and primary objects tables, views, clusters, indexes, etc., once the application has been designed.
• Implemented distributed environment using MTS as well as Dedicated server architecture
• Improving the performance of the database by optimizing SQL statements, indexing tables properly, using cost based approach wherever possible.
• Responsible for logical/physical backup/recovery of the databases as needed.
• Coordinated with the programmers and system analyst in Database modeling.
• Analyzing the database through scripts to collect statistics for future capacity planning
• Worked with Network administrators to enable remote clients access the Oracle services and identify network bottlenecks like Packet size .
• Writing shell scripts to automate various tasks
• Extensive use of SQL LOADER.
• Responsible for maintaining Sybase and DB2 Databases and fine tuning them.
• Upgradation of various Front end as per Y2k Compliancy
• Providing 24/7 support for all production databases
• Configuration of ODBC and Client connectivity