SUMMARY:

• Around 9 years of IT Experience in all facets of SDLC like analysis, design, development, testing, system integration, implementation and production support as Database Designer, Oracle/SQL Server developer, ETL Development and Data Architect with diverse cultures and people in India and USA.
• Experience in Pharmacy, Financial, Insurance, and Health Care domain.
• Technical expert on Oracle/SQL Server Architect, Senior Oracle/Netezza development and working experience and understanding of implementing Informatica, Datastage, BI/BO, Oracle APEX, Oracle Reports & Forms and Web UI using Oracle Portal, CGI’s to present data for the business.
• Exposure of designing Logical & Physical Data Model in (RDBMS) Erwin and ER Studio.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Experience in working high transacted OLTP and DHW OLAP environment.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using SQL Server and Oracle tools like SQL*Plus, SQL Developer and Toad.
• Proficient in advance features of Oracle 11g and 12c for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Varrays, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, TKPROF, Explain Plan, DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
• Experience in MS SQL Server suite of products with Business Intelligence in SSIS 2005/2008, SSAS 2005/2008 and SSRS.
• Expertise in writingT - SQL Queries, sub-queries and complex joins.
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Experience inimporting/exportingdata from Oracle/Access/Excel using SSIS/DTS utility.
• Designed, created, implemented and monitored and supported ETL work flow with complex transformation to perform the routine full and incremental loads using Informatica and Datastage.
• Designed and implemented ETL framework to feed data to the main legacy warehouse.
• Hand on experience UNIX shell scripting and commands line for routine file navigation purposes.
• Familiarity with file moving tech to transfer data from active directory using FTP (File Transfer Protocol) and File Mover/Watcher.
• Suggested solution for Master Data and Meta Data Mart to streamline for better performance.
• Modified the CGIs to generatedynamic content on web pages andweb applications .
• Developed application using JDBC, Servlets, SQL injection, CCS, HTML 5, Jquery, Jscript.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner.
• Experience in Facets, EPIC (Clarity), ITIL, SOA Arch driven environment.

TECHNICAL SKILLS:

Operating System/Languages: LINUX, Sun Solaris 5.10/5.9/5.8 , HP-UX 11i 3/11i 2, IBM AIX 5.2/5.3, Windows 7/XP/2000/98SQL, PL/SQL, C, C++, UNIX Shell & PERL Scripting, Java Scripting, JAVA and .NET

Database/Database Tools: Oracle 12C/11g/10g/9i, Netezza 6.0, MS SQL Server 2008/2005, Oracle Enterprise Manager (OEM) 12C/11g, Oracle Forms & Reports 10g & 11gSQL*PLUS 9.2.0.3, Putty beta 0.63, TOAD 12.0, MobaXterm 3.2, SQL Developer 3.1, Erwin 8, VI Editor, Oracle Apex 4.2.3, Data Stage 8.1

Data Utilities/Reporting Tools: SQL Loader, Export/Import, Data pump, Explain Plan, Oracle WrapMS SQL 2008/2005/2012 , Oracle Forms & Reports 9i/10g, MicroStrategy, SAS, APEX, Clickview, BI/BO

Other Tools & Web Application/Automation Job/Batch Scheduling Tools: HTML 5, XML 1.1, UML 2.3, Filezilla 0.9.40, SFTP 6, WinSCP 5.1, Java SE 7, CSS 3Control - M 7.0, Cybermation 2.0, Autosys 11.3, Cron Jobs

PM Tools: MS Project 2013, IBM RUP 7.5.1, Requisite Pro 7.1, HP Quality Center, Rally

Methodologies: SDLC & AGILE

Modeling Tools: MS Visio 2010, MS Office 2010System Testing, Functional Testing, Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Test Plan, Test Scripts and Test Cases

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Data Architect

Responsibilities:

• Technical assistance to user session to gather & implement requirements in agile environment.
• Developed and maintained ETL framework for EDI Batch processing.
• Resolving issues related to Enterprise data warehouse (EDW), stored procedures in OLTP system and analyzed, design and develop ETL strategies.
• Developed standard Informatica reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Involved in projects to pull the required sources from EPIC and Clarity data to handle Confidential t info.
• Primarily worked in maintaining the data for backend table using SQL Server Queries, PL/SQL package, Function, Stored Procedure, and Cursors.
• Extracted data from Oracle, SQL Server and Clarity using Informatica to load it into a single data warehouse repository.
• Utilized features like Temporary Table, DB Links, M Views, External Tables, Bulk Collect/Bind, Partitions, Collection Methods, Pragma Autonomous Transaction and Dynamic SQL.
• PerformedSQL and PL/SQL tuningand Application tuning using EXPLAIN PLAN and assisted DBA with AWR Reports.
• Handled errors usingException Handlingand Java Script validation extensively for the ease of debugging and hence directing user to provide suitable data.
• Used Oracle HTP.P to deliver embedded HTML5, CSS3, Jquery and JScript to present web content.
• GenerateUImockups from paper-and-pencil concepts to actual technical prototypes that convey the interaction model.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Createdparameterized reports, Drill downandDrill throughreports using SSRS.
• Experience in using SSIS, SSRS and SSAS to present data.
• Supported ASP.Net migration projects to write pseudo code and technical spec.
• Enhanced functionality for the custom based UI written in Asp.Net.
• Experience in Microsoft TFS for version controlling modification.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, TOAD 10.6, Erwin 8, ER-Studio, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, Jquery, HTML 5, CSS, Java Script, Bootstrap, Remedy, EPIC/Clarity.

Confidential, Grand Rapids, MI

Solution Architect

Responsibilities:

• Interacted with client in Agile and supervised in preparation of the technical documentation.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports with SQL Server 2008/2005.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and DB2 Billing Systems.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in Informatica for existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly with proper fixes.
• Worked with heterogeneous source in Informatica to extract data from Oracle database, XML and flat files and loaded to a relational Oracle warehouse.
• Designed, implemented and modified ETL flow for the EDI File processing.
• Wrote SP Transformation for oracle work flow in the ETL processes for ODI.
• Enhanced & created DB objects like tables, views, sequences, synonyms, indexes.
• Extensively worked on Nested Tables, Varrays and PL/SQL records.
• Created Cursors and Ref Cursors to process the required data.
• Used Bulk Collect and FOR ALL to DML multi-row from table.
• Created interactive reports with constraints in APEX for users to manipulate the actual tables in DB.
• Loaded data from various databases using SQL *LOADER utility.
• Created UNIX shell scripts and scheduled Cron jobs.
• Modified CGIs in Perl which flashes the processed data on Web.
• Defined CSS scripts with custom classes and use them in HTML page to deliver on web.
• Wrote tech spec to support ASP.Net application for migrating Oracle UI.
• Used Microsoft TFS to maintaining the code.
• Utilized Java Scripts to generate dynamic views thru HTML scripts.
• Testing and debugging the existing Procedures, Packages and Reports.
• Involved in Sprint planning for iterations in Agile environment.
• Created interactive reports in APEX to provide direct access to the tables in DB.
• Created Oracle Forms and Reports using repeating frame.
• Assisted in documentation for DevTech Approach, UseCase Spec, Effort Estimation and Design Doc.
• Created automated and manual scripts for satisfying the testing purpose.
• Drill down the root cause of slow running processes & provided suitable performance technique.
• Used Oracle packages - DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
• Wrote Dev Test Plan, Design Doc & Code Review Doc as part of project deliverable.
• Worked and involved in projects implementing Facets and SOA Arch.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, MS Office Visio, TOAD 10.6, Putty Beta 0.63, Erwin 8, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, C++, Rally, Trizetto’s 4.7, WinSCP 5.1

Confidential, Collegeville, PA

Netezza ETL Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
• Modified and created tables, synonyms, sequences, views, stored procedures and triggers.
• Ensured conformance to code standards and documentation requirements.
• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and used various transformation to house the data in required tables.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Using reporting services (SSRS) generated various reports.
• Compiled Dev Test Plan, Design & Code Review Docs as part of the deliverable to the SDLC artifacts.
• Fixed performance issues and bugs with packages and stored procedures using DBMS PROFILER.
• Performed Unit Testing and ensured all the exceptions are handled according to the business logic.
• Developed complex join queries for Star Schema, Snow Flake Schema, Dimension and Fact table.
• Created B-tree, Bitmap indexes, Partition table for enhancing the performance.
• Used Hints and Generate Statistics command to enhance the performance.
• Created effective ETL work flows using PLSQL objects in ODI.
• Used HTML and CSS Scripts to show the tabular structure and web content.
• Scrutinize performance of long running scripts Using AWR reports, Explain Plan, SQL Trace, TKPROF.
• Wrote requirement for the Cybermation Batch Scheduling Process.
• Used Datastage for simple to complex load to Master Data Management.
• Wrote Unit Test Cases and Unit Test Scripts for Validated data from SAS to Oracle.
• Created and modified complex Oracle Reports and Forms.
• Loaded flat file using SQL*LOADER & NZLoad into database.
• Used TOAD and Netezza for querying and debugging application.
• Created and modified the file mover Perl Scripts.
• Written Cursors and REF Cursors for transaction processing.
• Implemented database triggers based on the business rules and requirements.
• Assisted in Functional Requirement Specification & Use Case Diagrams to streamline business flow.
• Wrote PL/SQL Rappers for maintaining data & code security.
• Worked in Facets driven Environments.

Environment: UNIX, Netezza 6.0, Cybermation EST 5.1, Oracle 11g, SQL*Plus 9.2.0.0, Sun Solaris 5.8, Putty Beta 0.60, Oracle Forms and Reports 10g, HPQC, WinCVS 2.0, HTML, MS Visio 2005, Data Stage 8.1

Confidential, Wilmington, DE

Oracle PLSQL/ETL Developer

Responsibilities:

• Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
• Made structural changes to database objects using Oracle tools like SQL*Plus and TOAD.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
• Used WinSCP for file transfer between different data base servers.
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
• Wrote complex Perl Scripts to handle pattern search for heavy data loads.
• Modify and made tables for the loading of data from different sources using SQL*loader.
• Used exception methods with pragma exception init to associate customized exception names.
• Used SP transformation for the Datastage Application.
• Handled XML Files for data loading purposes.
• Used UTL file package for automated ETL processes.
• Used APEX to develop end to end Web Application Development.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
• Involved in the designing of databases architecture and developed the ER Diagrams with ERWIN.

Environment: UNIX, Oracle 11g, PL/SQL, SQL*PLUS 9.2.0.3, SQL Developer 3.1, Toad 10.6, E, HP-UX 11i v3, IBM AIX 5.2/5.3, IBM RUP 7.5.1, HPQC, WinCVS 2.0, WinSCP 4.1, APEX, Data Stage 8.1

Confidential, Herndon, VA

Sr. Oracle PL/SQL Developer/BA

Responsibilities:

• Was involved in fast paced AGILE Environment.
• Prepared tech documentation for easy understanding by other developers.
• Created stored procedures, packages, generated triggers for security purposes using TOAD.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Created the Temp tables in the stored procedure for different applications.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS.
• Loaded data from flat files into Database using SQL*loader.
• Created Unix Shell Scripts for automating the execution process.
• Used DBMS SCHEDULER package for job scheduling.
• Created XML supported document.
• Fine-tuned the Java embedded SQL & PLSQL.
• Worked on Web application development with APEX.
• Involved in Unit testing, Integration test and writing the Test plan.
• Trained end users on the functionality and operability of the application.

Environment: Oracle 11g, Solaris 5.8, PL/SQL, SQL*PLUS 9.2.0.3, TOAD 10.6, SQL Developer 3.1, Oracle Enterprise Manager, HTML 5, Mercury Test Director 9, UML 2.3, MS Visio 2010, Data Stage 8.1.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with clients, Requirements gathering and designing.
• Developed packages, stored procedures and functions to implement business logic.
• Created Indexes and sequences for faster retrieval of the visitor information.
• Data was loaded from flat files into database tables using SQL* loader.
• Used Crontab to run PL/SQL Scripts and stored procedures.
• Involved in performance tuning with EXPLAIN PLAN and Indexes.
• Worked with Bulk Collect & Bulk Bind to improve the retrieval of multi row.
• Implemented Join conditions, group by functions, correlated subqueries, nested subqueries.
• Created procedures and functions for validation of transaction records into interface tables.
• Worked with different FTP client for loading data from the Windows to Solaris.
• Involved in writing technical documentation, and writing test plan.

Environment: UNIX, Solaris 5.9, Oracle 9i, TOAD 10.4, PL/SQL, SQL*Plus 9.2.0.1, SQL Developer 2.9, Oracle Enterprise Manager, FileZilla 0.9.40, UML 2.1, BugZilla 4.0.0, MS Project 2010.