SUMMARY:

• 8 + years of experience as BI / System Analyst , Integration Engineer and Oracle Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience with IBM WebSphere Commerce 6 & 7.
• Expertise in Client - Server application development using Oracle 12c/ 11g/10g/9i/8i - PL/SQL
• Strong experience in Data warehouse concepts, ETL.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications (FRS), Software Requirements Specification (SRS), Software External Specifications (SES), Software Requirement Document (SRD), Workflows.
• Expert in developing, writing and maintaining gap analysis, business requirements and technical documentation.
• Expert knowledge in generating - Use Case Diagrams, Sequence Diagram, Activity Diagrams, Data Flow Diagrams and Process Models.
• Fluent with business process mapping, use case diagramming, sequence diagramming and activity state diagramming using MS Visio
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B-Tree, Bitmap and Function Based).
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Involved in creating mappings transformations in Informatica and tuning & monitoring workflows.
• Strong Knowledge in SSAS, SSRS, SSIS and Star Schema and Snow Flake Schema.
• Familiarity with BI, CRM and ERP tools (Oracle Reports, Oracle Forums, OBIEE, SAP, Crystal Reports).
• Experience working with versioning tools like CVS, SVN and Subversion.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Good experience in using batch scheduling tools such as Autosys and CA Workload.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Rich experience in Agile methodologies such as extreme programming (XP), Scrum, waterfall model and Test driven environment.

TECHNICAL SKILLS:

Programming Language : SQL, PL/SQL, T-SQL, MySQL, Java, C++, PHP, Unix Shell Script

Operating Systems : Windows 7/Vista/ XP/NT/2000,ScoUnix, Ubuntu, Solaris, Red Hat Server, UNIX, LINUX

Version Control : IBM Rational ClearCase 7.0/7.1, Tortoise SVN, CVS

UML Tools : Rational Rose, MS Visio, Lucid Chart

IDE : Eclipse 3.2, 3.6, 4.2, NetBeans, WSAD/RAD 6.0/7.0/7.5

Build Tools : ANT 1.4, 1.5, 1.6, Maven

Methodologies : Agile, Waterfall, RUP, Scrum, XP, Test Driven development

Protocols : TCP/IP, FTP, HTTP/HTTPS, RMI/IIOP, DNS, SOAP

Databases : Oracle 8i, 9i, 10g, 11g, 12c, DB2 9 & 10, SQL Server 2000/2005/2008 , MySQL 4.1,5.1

Database Tools : Toad and SQL Developer for (SQL Server, Oracle, MySQL), MS Access

Application Servers : Web Logic 6.1/7.0/8.1/9.0/10.1 , Web Sphere 6.0/7.0 Jboss 4.2.2/4.3, Apache Tomcat 5.5/6.0

ETL Tools : Informatica 8.6.1

Data Modeling Tools : Erwin 3.5.2,4.0

Reporting Tools : Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 9, OBIEE

Other Tools : AutoSys, Control-M, PVCS, WIN CVS, Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, IBM IIB, BTEQ, UC4 (Automic), Microsoft Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, West Chester, OH

Systems Integration Engineer

Responsibilities:

• Act as a go-to resource for solving critical technical issues when they arise.
• Mentor more junior level members of the team.
• Work with key stakeholders in engineering teams, product management teams, developer support teams, and technical writers to help plan and deliver key functionality to developers
• Collaborate with other teams, including Development, Operations, Product Management, and QA.  
• Build new and maintain existing integration solutions.
• Lead technical implementation and design of new systems and processes.
• Participate in vendor selection to ensure system compatibility with internal architecture and technology.
• Follow internal development standards and release management processes.
• Create technical and business user documents for integration solutions, including development and support related documentation.
• Testing of mobile sites (branding brand and mobify).
• Work closely with IT to ensure appropriate support model and knowledge transfer for implemented systems and processes.
• Analyze and prescribe solutions to issues impacting performance and/or availability within integration and commerce-facing applications.
• Participate in all aspects of the software lifecycle (analyze, design, test, implement, and support).
• Timely delivery of enhancements and fixes to meet ever-changing business requirements.
• Optimize solutions for performance and continuous (24x7) operation
• Provide on-call (24x7) support in a rotating schedule.
• Provide second level support for key systems and integrations.
• Testing/development/debugging of mobile app and mobile site on various platforms (iOS, android)
• Actively work with key business stakeholders from project inception to implementation, and support to ensure smooth integration of solutions.
• Involved in DB2 and Oracle database PLSQL development. Creating Procedures, Functions and Packages.
• Performed SQL tuning and created views and indexes for performance gain.
• Designed and developed web services Consumer and Provider in IIB/Message broker using SOAP and HTTP Nodes and exposure to ESQL.
• Involved in migration from IBM WCS 6 to WCS 7.

Environment: HTML, XML, JSON, JSP, PL/SQL, J2EE/JAVA, Oracle 10g, DB2 9 & 10, IBM Aqua Data Studio, Tortoise SVN, Subversion, Eclipse 4.2, WebSphere Commerce 6 & 7, Unix/Linux, UC4 (Automic), IIB Developer 10, JIRA, Confluence, Lucid Chart, Branding Brand, Mobify, SLI, Ecomtery, Commercial Warehouse, Monetate, Foglight.

Confidential, Augusta, ME

Sr. Oracle Developer/ Tech Lead  

Responsibilities:

• Participating in user requirement sessions to gather business requirements
• Involve in Analysis, Design, Development, Integration and Testing of application modules
• Involved in analysis and design phases of software development life cycle (SDLC).
• Involved in projects related to Medicare, Medicaid and HL7.
• SCRUM development process was used for the product life cycle management
• Involved in Data modeling of the product.
• Conducted JAD sessions to define the project and to reduce the time frame required to complete deliverables.
• Created business process flow diagrams and charts using MS-Visio.
• Involved in project management, developing project plans, setting project schedules and milestones, scheduling tasks and activities using MS Project.
• Played a key role in the planning (UAT) User Accepted Testing and implementation of system enhancements and conversions.
• Created product documentation, including online help, printed user manual and training materials.
• Agile methodologies were used during the development phase
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in Migration from 10g to 11g to 12c and development of Oracle Reports.
• Involved in PHP development for the front end of the product.
• Documentation of common problems prior to go-live and while actively in a Production Support role.

Environment: HTML, XML, PHP, PL/SQL, Oracle 10g/11g/12c, Toad, PL/SQL Developer IDE, Tortoise SVN, Subversion, Eclipse 3.1/3.2, Subclipse 1.0, Weblogic 9.2.0/11, Shell Scripts, Unix, Solaris, Oracle Reports/Forums, OBIEE.

Confidential, Dallas, TX

PL/SQL Developer/ Sr. System Analyst

Responsibilities:

• Participating in user requirement sessions to gather business requirements
• Involved in Analysis, Design, Development, Integration and Testing of application modules
• Agile methodologies were used during the development phase.
• Requirement gathering and preparation of business requirement documents (BRD).
• Interaction and gathering of all the necessary information from various companies and necessary records to create and provide an error free software solution.
• Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Participated in change and code reviews to understand the testing needs of the change components.
• Worked on troubleshooting defects in timely manner.
• Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SDLC.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages (ETL) for Data warehousing.
• Designed and developed Oracle forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Involved in the continuous enhancements and fixing of production problems.
• Fix defects as needed during the QA phase, support QA testing, troubleshoot defects and identify the source of defects.
• Documentation of common problems prior to go-live and while actively in a Production Support role

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting., SAP BO, Crystal Reports.

Confidential, Houston, TX

Sr. System Analyst/ BI Analyst

Responsibilities:

• Involved in analysis and design phases of software development life cycle (SDLC).
• SCRUM development process was used for the product life cycle management
• Conducted routing Internal inspections of regulated systems (GMP, GCP, GLP) to assure validation procedures have been followed in compliance with company, divisional and departmental policies and predicated rules.
• Authored OQ and PQ test scripts to challenge all regulatory and security requirements.
• Reviewed models and studied in detail the functionality of multiple regulatory reporting models of various departments.
• Designed and developed Risk engine rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
• Facilitate product/content reviews for assigned projects to ensure accuracy and market sensitivity of programs.
• Perform project management duties for internal service management and client reporting initiatives and other projects as needed, inclusive of the entire project management lifecycle.
• Managed Cross Team Collaboration and Offshore Testing team.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Documenting High Level Requirements as per the business users and converted them in to Detailed Business Requirements.
• Responsible for creating a new data mart for reporting and analytics and also finalized the new data elements.
• Helped the business analyst in generating the reports with Business objects XI (BI).
• Use to write Use Cases, Business Flows, Process maps and Work Flows Diagrams for effective plan
• Worked with DBA to implement compression on Database tables.
• Worked with DBA to set up Oracle Streams  that streams data from OLTP to DWH database.
• Monitoring Autosys  jobs in QA, DEV and production.
• Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Worked on Power Exchange to create Mappings, workflows that loads the data from Flat files coming from source system to Oracle database.
• Monitored Informatica workflows using Informatica workflow monitor.
• Involved in Implementation and end user training.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, SQL Developer, SQL Navigator, Tortoise SVN, HP Project and Portfolio Management, Windows XP, UNIX, Secure Shell Client, Business Object, Crystal Reports.

Confidential, Chicago, IL

Business/ System Analyst

Responsibilities:

• Understanding business objectives and implementation of business logic.
• Involved in various phases like design and development of Software development life cycle (SDLC).
• Facilitate requirements gathering and business process mapping sessions.
• Coordinated with Developers and ALM/Quality Center to ensure flawless and timely implementation of credit policy.
• Involved in validating SOAP XML specifications as per the standards.
• Tested the various Service Oriented Architectures (SOAs), REST service validation and spanning across various web services using SOAP and WSDL across various applications
• Performing end-to-end testing, integration testing, UAT (User Acceptance Testing) and regression testing and Validate test results
• Performed Web Service testing using SOAP UI
• Created process flow diagrams, Integrate process flow diagrams to show one end-to-end business model and process mapping exercise including swim lanes.
• Preparation of Requirements Document, AGILE Story cards.
• Running queries against databases to verify the correctness of XML response
• Updated the existing business process diagrams and created new business process diagram.
• Coordinated Integration and smoke testing
• Worked with developers to resolve Issues and Production Incidents using Quality Center.
• Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved in Logical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• Developed a DAL (Data Access Layer- PL/SQL Package).
• Provided user training and production support.
• Using Agile Methodology, the entire project was broken into sub tasks which were performed in parallel.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Maintained the source code versions in CVS repository.

Environment: JDBC, XML, LDAP server, DB2,UML, Rational Rose, CVS, VB 6, Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential, Rockford IL

Oracle/ Java Developer

Responsibilities:

• Involved in various Software Development Life Cycle (SDLC) phases of the project.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key
• Constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Developed the different components of application such as JSP, Servlets, and EJB using websphere studio application developer and used CVS for version control.

Environment: Java, JDK, EJB, Struts 1.2.4, Servlets 2.1, XML, SOAP,JDBC, JavaScript, UML, HTML, CVS, WebSphere app server 5.1,Oracle 9i/10g, UNIX shell scripting, SQL *Plus, SQL Developer, Erwin 4.1, Toad.