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
• Experienced in designing MPP and VLDB (50 - 400 tera bytes)
• 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.
• Data warehousing
• Data Modeling in Erwin, Designer, Power tools for OLTP, Data marts/warehouse and OLAP solutions
• Capacity planning
• Excellent Documentation skills
• Experienced in Designing/implementing central repositories for Master Data and Meta data management.
• Excellent communication/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 analyzing data and designing business intelligence reporting. Very strong in SQL.
• Data governance and quality using data lineage and profiling
• Working knowledge of No-SQL technologies like hadoop, MongoDB
• Working knowledge of Text indexing tools like SOLR
• Experience with Oracle tools like Warehouse builder, Golden gate, Data integrator, data miner, OBEEI

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, Teradata

OPERATING SYSTEM: SOLARIS (2.8, 2.7), LINUX, HP-UNIX, SCO-UNIX, AIX,WINDOWS, MVS, Red hat Linux

SOFTWARE: OAS, Erwin, PL/SQL, SQL, Oracle Designer

HARDWARE: SUN SPARC, HP-UX/Dell Servers, and IBM Mainframes

PROFESSIONAL EXPERIENCE:

Confidential

Principal Solution Consultant

Responsibilities:

• Responsible for end-to-end solution design and architecture
• Collaboration with key stakeholders (compliance, Enterprise Architects and business) on solution architecture and future needs
• Responsible for meeting healthcare business managers to gather input and requirements
• Responsible for creating the necessary solution design, requirement and compliance documents.
• Responsible for modeling the xml and database schemas for submission and claim status tracking
• Responsible for modeling the reporting and auditing schemas to enable various business reports and data lineage.
• Responsible for modeling the central repository (master data) to keep track of sources(true source)
• Responsible for porting the application to Mysql Cluster.
• Responsible for ensuring that the Data model, ETL and processes meet the HIPPA regulations.

Lead Solution Consultant

Responsibilities:

• 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 and ensuring that the proposed and current solutions meet the HIPPA and privacy requirements.
• 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 performance tuning PL/SQL and Informatica
• Responsible for solutioning the changes to the existing Medicare application so that it can also handle Medi-Cal claims
• Responsible for creating prototype reports using tableau for business presentation and proof of concept

Sr. Data/Performance Architect

Responsibilities:

• Responsible for enhancing and modifying the design of the existing schema 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 data 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 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.

Sr. Data Architect

Responsibilities:

• 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 porting the Data warehouse to Vertica and document the pros/cons of using Vertica over Oracle.
• 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
• Participated in creation of prototype to use Hadoop for Data processing
• Participated in creation of prototype to use DataStage for ETL

Sr. Database Architect/ Lead DBA

Responsibilities:

• 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

Sr. Data Architect/Technical Lead

Responsibilities:

• 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.
• Worked on a migration project to move the enterprise data warehouse from oracle to Teradata.
• 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
• Participated in migration of oracle data warehouse to Teradata solution

Tech Lead/Sr. Architect

Responsibilities:

• 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.
• Worked on a team responsible for migrating an Oracle Data warehouse to Teradata.

Confidential

Sr. Oracle DBA/Architect

Responsibilities:

• 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
• Planning and implementing the data migration strategies to move the data from different sources and legacy systems into the new environment
• Troubleshooting performance issues for the application
• 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

Oracle DBA/SYS Admin

Responsibilities:

• 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 .

Oracle DBA

Responsibilities:

• 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.

DBA cum Architect

Responsibilities:

• 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