SUMMARY:

• 11+ years of IT experience in design, analysis, development of Oracle and Oracle based software application systems.
• Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• Extensive hands on experience using Oracle 9/10/11g, Sybase, IBM DB2 and SQL Server databases and several of its tools.
• Management and implementation of database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.
• Solid experience translating business requirements into conceptual, logical, and physical data models.
• Implement best practices and methodologies in data analysis, design and modeling.
• Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms, Sybase to Oracle VLDB databases and flat files.
• Management and development of an enterprise tailored taxonomy. Categorized internal and external data collections and ensure users find the information they need with speed and precision.
• Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.
• Design standards for using normalized data structures, de - normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships.
• Provide guidance and work leadership to less-experienced staff members.
• Excellent teamwork skills, good oral, written communication and presentation skills.
• Highly analytical thinking with demonstrated talent for identifying, scrutinizing, improving, and streamlining complex work processes.
• Innovative problem-solver who can generate workable solutions and resolve complaints.
• Resourceful team player who excels at building trusting relationships with customers and colleagues
• Enthusiastic, knowledge-hungry learner, eager to meet challenges and quickly assimilate new concepts.
• Facilitated and participated in Joint Application Development (JAD) sessions for requirements gathering and analysis.

TECHNICAL SKILLS:

Languages: PL/SQL, C, C++, Java, HTML, SQL, UNIX shell Script

Platforms: UNIX System, Sun Solaris O/S, Windows 98, Windows 2000, Windows NT, Windows XP, MAC, Oracle Virtual Machines, Oracle Apex

Databases: Oracle 7.x/8/ 9i/10G, Ms-Sql Server, Ms- Access, Sybase, IBM DB2

Software: Visual Basic, Oracle Designer, Oracle 10/11g Developer Suite, Oracle JDeveloper, PL/SQL Developer, TOAD, Oracle SQL Developer, SQL Navigator, MS Office (Word, Excel, PowerPoint, Project), Eclipse 3.3

SCM: MKS, SVN, TFS

App Servers: Web Sphere, JBoss

Modeling and ETL Tools: Erwin, All fusion Model Manager (Data Mart), TOAD, ER-Studio, Oracle Designer,Visio, Rational Rose Data Modeler, UML and Rational DA

PROFESSIONAL EXPERIENCE:

Confidential,Albany,NY

Sr. Technical Architect

• Provide support in database architecture of the organization through database design, modeling and implementation
• Develop plans, strategies and standards for data within the enterprise
• Understand the end-to-end scope of work and design architectural solutions accordingly
• Integrate all data in the data management platform enabling accessibility
• Ensure that the database base is secured and updated
• Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice
• Oversee that the database back-up and recovery system are available in the enterprise for current and future use, including a potential crisis time
• Control and maximize the data resources and processes within the organization
• Use database design and database modeling concepts to ensure data accessibility and security
• Understand the future requirements and model database concepts accordingly
• Support the organizational data warehouse through appropriate utilization of ETL tools
• Will adhere to Confidential 's application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards and the IT governance process.

Environment: /Tools: Oracle 11g, PL/Sql Developer, Microsoft .NET, TFS.Toad 11.1

Confidential,Bothell,WA

Sr. Oracle Consultant

• Streamlined management of clients, policies, rates and plans.
• Fully-integrated system with enterprise-grade support for multi-office brokerages.
• Benchmarking tools to deliver more valuable business intelligence.
• Easily and efficiently track revenue and commissions.
• RFP tools to gather more options and negotiate with carriers to create the best rates and plans.
• Unlimited online access to a comprehensive compliance library with HR and benefits information.
• Personalized web portals so employers and employees can access their plan data, 24/7.
• Involved in new Re-Architectural data layer design framework to support the current app tier model for the business contingency. Participated in extracting, transforming and loading (ETL) data using Informatics along with the ETL team. Adept in data mapping and data transformation between source-to-target database schemas, data cleansing and processing with strong data analysis skills. The current model followed legacy way of design.

Environment: /Tools: Oracle 11g, Oracle Data Modeler, Toad, Microsoft .NET, Linux, SVN, Korn Shell, Secure SSH Client, PuTTY.

Confidential,St Louis,MO

Oracle Consultant (Sr.Data Engineer)

• Involved in process like design solution, technical advice and post project Review for projects of varying scope. Contribution included both Functional & Technical like Analysis, Designing, Providing solution & Development code Review. Also designed data cleaning and migrating legacy data from 3rd party vendor into WFA standard.
• Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Wrote several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Extensively used UTL FILE to read and write files that are located on the server.
• Generated UNIX Shell scripts to automate jobs and loading process for staging, transformation and loading of the data into base tables.
• DBMS utilities were used to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database to generate a data file, DBMS SQL to write Dynamic SQL etc.
• Heavily involved in tuning of queries using tools like Explain Plan, Trace and TK- Prof and concepts like Parallelism, partitioning, hints etc.,
• Experience with Oracle 11g new features such as Pivot and Unpivot operators and analytic functions

Environment: /Tools: Oracle 11g RAC, Toad, Microsoft .NET, Oracle Data Modeler, Linux, IBM DB2,Sql Developer, Synapse Workbench 5.4 (Rule Engine), Korn Shell, Autosys, IBM Data Studio, WinSCP, Secure SSH Client, PuTTY

Confidential,Beaverton,OR

Oracle Sr. Data Engineer/Design

• Creation and development of Oracle PL/SQL packages, stored procedures, functions, anonymous blocks, views and used them for report design
• Developed and tuned the complete complex reporting architecture and data flow involving up to 20 variable inputs right from scratch under tight deadlines
• Performed complex scripting and querying in the development, testing as well as the production environment.
• Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Developed PL/SQL Packages, Procedures, Functions for validating the calibration of customer data.
• Developed the Request sets that are scheduled to submit concurrent programs in a desired sequence as per the functional document. Extensively used global temporary tables and ref cursors to store and process data.
• Created functions for complex data parsing of multiple input parameters in Oracle.
• An expert in complex PLSQL programming using iterative processing with loop, CASE statement process flow, exception handling, records, collection, DML operations, data retrieval using cursor /ref cursor and BULK COLLECT / FORALL, collections, packages, database triggers etc.
• Set up and monitor Oracle Jobs using the Oracle DBMS Job package.
• Documentation of all modules for user level and system level maintenance.
• PL, SQL, SQL Development and Tuning Skills, Process Automation using Shell Scripting
• Created unit test cases and performed unit testing on developing projects before clearing code for User Acceptance Testing.
• Supporting development, testing (Generate test case for unit testing, integration testing, System testing and user acceptance testing).
• Have strong knowledge from the front end also.
• Version Control code repository to maintain version of the code, used SVN tortoise.

Environment: /Tools: Oracle Exadata, Oracle 11g RAC, Mac OS X, VM-Win Xp, Toad, J2ee, Eclipse Java EE IDE for Web Developers, JDK1.4, JBoss, Apigee Middleware (Web service), Oracle Data Modeler, Sun Solaris. Oracle coherences

Confidential,SJ,CA

Oracle Consultant (IT Analyst/Tech Lead)

• Involved in entire Phase of Software Life Cycle process like Biz engagement discussion, requirement gathering, project planning, Resources and cost Estimation, solution design, technical advice and post project Review for projects of varying scopes. Handling varies other multiple Projects and teams.
• Contribution included both Functional & Technical like Requirement gathering, Analysis, Designing, Providing solution, Code Review and end product delivery.
• Engaging Biz level of Conversation/Meeting for the requirement.
• Providing Solution for the end users/Partners/customer/Biz threshold case/issue.
• Working with DBA team to analyze and support QA Team for Testing (UAT)/prod databases, performance and third-party resources to create, manage, and tune information feeds from various sources
• Evaluates system specifications for business requirements. Refractor existing programs to perform better operational.
• Develops and implements the most efficient and cost-effective solutions.
• Works closely with management to prioritize business goals and information needs

Environment: /Tools: Oracle 10g, Win Xp, FTP, Toad, SMPT Concept, J2ee, Eclipse Java EE IDE for Web Developers, JDK1.4, Java- Web services, SOAP, JAXB, XML and Cisco Service Development Framework, SFDC (Cloud Computing),Oracle 11i EBS (SRM,OM), Financial Management Solutions (FMS)

Confidential,CA

Oracle Consultant (Sr. Data Performance Engineer)

• Actively participated in project planning, solution design, and post project reviews for projects of varying scopes
• Responsibilities included analysis, Designing, coding, creating test plans, gathering test data, and end user support.
• Trouble shooting for the end users requirement and Optimizing database
• Tuning application using tools like Explain plan etc… other tools for high efficiency.
• Developed Complex Pl/SQL Procedures and packages to do the validation as per the requirement.
• Worked with DBA team to analyze and support Dev/Test(UAT)/prod databases, performance and third-party resources to create, manage, and tune information feeds from various sources
• Documentation of Technical design and Test cases from Functional design document.
• Refractor existing PL/SQL program to perform better operational.
• Created Lot of SQL loader process to transfer data from Iseries (AS400 system) to Oracle DB.
• Wrote Shell script to automate the nightly load job process across multiple Applications.
• Writing a Cronjob Script to execute Batch Processing
• Also create Cognos Report Net Model for Business user to support financial decision making process.
• Also wrote complex PL/SQL function, Materialized View to accomplish certain Web screen related task.

Environment: /Tools: Oracle 9i/10g, Win Xp, FTP, Toad 9.0.1, SMPT Concept, AS400(Iseries), Java 1.6, Eclipse Java EE IDE for Web Developers, Visual Source safe, VB Macro, Putty, SunOS 5.8, Solaris 8,SQL Loader, Cognos Report, Oracle Web Logic Server

Confidential, Lorain,OH

Oracle Consultant (Sr. Data Designer)

• Actively participated in project planning, solution design, and post project reviews for projects of varying scopes.
• Responsibilities included analysis, Designing, coding, creating test plans, gathering test data, and end user support.
• Trouble shooting for the end users requirement and Optimizing database
• Tuning application using tools like Explain plan etc… other tools for high efficiency.
• Used STATSPACK, OEM, and AWR in oracle 10G(RAC).
• Developed Complex Pl/SQL Procedures and packages to do the validation as per the requirement.
• Worked with DBA team to analyze and support Dev/Test/prod databases, performance and third-party resources to create, manage, and tune information feeds from various sources
• Recommended and participated in the development of database standards and best practices for the organization
• Documentation of Technical design and Test cases from Functional design document.
• Wrote PL/SQL automated DMBS Scheduler Job to Create and Drop Partition DB and also include Mail Notification of Job status.
• Also wrote complex PL/SQL function to accomplish certain Web screen related task.

Environment: /Tools: Oracle10g(RAC), Win XP, Erwin, FTP, Toad 9.0.1, Oracle Collection Objects, PL/SQL Developer, UTL, SMPT Concept, Mainframe, C#, J2EE, JSP, JDK1.5, Eclipse 3.3, DB2, Visual Source safe, Web Sphere Application Server, Version 6.1

Confidential,Louisville,KY

Oracle Consultant (Sr. Data Engineer)

• Implemented sort logic to pickup latest records from platforms and push it to other recipients.
• Created packages and procedures that load payroll data into Star Schema from staging tables.
• Implemented utilities that use DBMS scheduling to scan relational database tables for updates at specified intervals.
• Implemented special precautionary measures to avoid duplicates while scanning multiple tables for changes.
• Extensively used oracle packages, Stored procedures, sequences, ref-cursors, dynamic queries, UTL files, bulk inserts, exception handling, DB Links etc.
• Worked on UNIX shell scripts to generate daily reports from the database.
• Closely interacted with testing team to address issues and defects on the timely manner.
• Fixed defects and addressed issues in payroll feed application that is critical to Humana.
• Created several procedures and packages to clean the data mart and other staging tables.
• Created packages and procedures to implement the reprocessing of the missing flow of records to ensure data quality

Environment: /Tools: Oracle10g, Win XP, Erwin, FTP, MS-Office, Sql*Plus, SQL * Loader, Toad 9.0.1, Oracle Collection Objects, PL/SQL Developer, UNIX (Korn Shell), UTL, SMPT Concept, Mainframe, ASP.NET

Confidential, Lowell, MA

Oracle Consultant (Sr. Data Engineer/ Database Architect)

• Participated in JAD sessions for client specific development of existing database management tool
• Gathering Business (user) requirement from the client and processing into the technical doc.
• Created and submitted line-level code changes for business requirements.
• Wrote database PL/SQL procedures, Function, Packages to provide
• Backend security and data Consistency.
• Trouble shooting for the end users requirement and Optimizing database
• Tuning application using tools like Explain plan etc. other tools for high efficiency.
• Developed Complex Pl/SQL Procedures and packages to do the validation as per the requirement.
• Wrote a PL/SQL interface program that imported customer data from a legacy system using interface tables. SQL * Loader /UTL FILE was used to populate into temporary tables, from where PL/SQL program validated and loaded the data into open interface.
• Coordinating and scheduling changes to database based on requirements.
• Also did First Level Testing: Unit Testing and Integrated Testing with multiple Components.

Environment: /Tools: Oracle10g, Win XP, Erwin, FTP, MS-Office, Sql*Plus, SQL * Loader, Toad 9.0.1, Oracle Collection Objects, J2EE, JSP, JDK1.5, Eclipse 3.3, JBoss 4.0.5, Business Object,MKS

Confidential,MD

ORACLE CONSULTANT (Sr. Data Engineer/Production Support)

• Participated in JAD sessions for client specific development of existing database management tool
• Gathering Business (user) requirement from the client and processing into the technical doc.
• Created and submitted line-level code changes for business requirements.
• Wrote database PL/SQL procedures, Function, Packages to provide Backend security and data Consistency.
• Trouble shooting for the end users requirement and Optimizing database
• Tuning application using tools like Explain plan etc… other tools for high efficiency.
• Developed Complex Pl/SQL Procedures and packages to do the validation as per the requirement.
• Wrote a PL/SQL interface program that imported customer data from a legacy system using interface tables. SQL * Loader /UTL FILE was used to populate into temporary tables, from where PL/SQL program validated and loaded the data into open interface.
• Coordinating and scheduling changes to database based on requirements.
• Also did First Level Testing: Unit Testing and Integrated Testing with multiple Components.
• Production Support for Live Data. Interacting with the End client
• Writing a Cronjob Script to execute Batch Processing.
• Design and Developed Regression testing database tool to Test use Case scenarios and system level performances.

Environment: /Tools: Oracle9i/10g, WinVer2000/Xp, Erwin, FTP, MS-Office, Sql*Plus, SQL * Loader, Toad, Gentran Server, Sun Solaris, Oracle Collection Objects, EJP, JSP, Jdeveloper, Web Logic, Sql Developer,