We provide IT Staff Augmentation Services!

Principal Solution Consultant Resume

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

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
Confidential

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

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
Confidential

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
Confidential

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
Confidential

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
Confidential

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

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

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

Hire Now