SUMMARY

• Over 7+ years of experience as an Sr. Systems / Business Analyst 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 PMLC(Project Management Life Cycle) and SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expereinced in working Banking (Credit/Risk/Fraud/AML/Investment), Human Services, Public Sector (State/Federal), Healthcare (Medicaid/Medicare/insurance/ pharmaceutical/clinical), Telecommunication, Travel (Airline) domains.
• Knowledge of industry practices and regulatory expectations as they relate to commissioning, qualification, and validation programs.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL and Java/J2EE.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Full understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML).
• 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.
• Experienced in requirements gathering sessions, feasibility studies and Impact Analysis.
• Experience in identifying and gathering the information from useful sources and also prepared Requirement Traceability Matrix.
• 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).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• 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.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HI NTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos, OBIEE, SAP (BO) and Crsytal Reports.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Good expreience in using batch sceduling tools such as Autosys and CA Workload.
• Experience in configuring and maintaining Defect Tracking system using ALM.
• Expert in UAT and SIT using JIRA, HP Quality Center and HP QTP.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part ofa 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, Redhat Server, UNIX, LINUX

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

UML Tools: Rational Rose, MS Visio

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

Build Tools: ANT 1.4, 1.5, 1.6, Maven

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

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

Databases: Oracle 8i, 9i, 10g, 11g, 12c, Sybase 11.9/12.0/12.5, DB2, SQL Server 2000/2005/2008, MySQL 4.1,5.1, SAP Tables

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

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

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

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 2.5

Other Tools: AutoSys, Control-M,PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ

Testing Tools: HP QC, HP QTP, JIRA, LoadRunner, Bugzilla, FireBug, Jasmine, DotProject, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, Augusta, ME

Sr. System Analyst / 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).
• SCRUM development process was used for the product life cycle management
• Agile methodologies were used during the development phase
• 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.
• Involved working in Medicare and Medicaid projects.
• Tested different functionality of the application like Medicaid eligibility data, state available funds program, Medicaid claim processing etc.
• Responsible for testing Medicaid Claims for the Confidential using MMIS.
• Conduct high level requirement walkthrough with Tech Managers to come up with Preliminary Estimates
• Conduct Technical Analysis on System enhancement to determine feasibility with Tech Managers
• Prepare SAD (Solution Approach Document) in collaboration with Solution Architect/SME's based on business requirements.
• Assess the impacts on HUB System and Middleware ((Business Process Layer (BPM), Data Services, Rule Engines), and other external systems.
• Prepare detailed level HLD (High Level Design) Specifications, Process Flow, Use Cases, and Wireframes for various projects
• Coordinate and conduct Business, Systems Requirements analysis meetings with Business and technology partners.
• Perform Data Analysis using the Data Verification Tool and Legacy Systems.
• Provide and recommend alternative methods of implementation or presentation to best meet the Business clients' needs, and to provide user-friendly solutions.
• Document, follow up and resolve issues related to each assigned project.
• Review and validate Test Plan, Test Scenarios, and Test Cases with Testing Team and provide final approval.
• Participate in the Defect Resolution process by tracking and managing defects that are entered by testing teams
• Track and Manage Defects
• Work with UAT Team to prepare User Acceptance Testing.
• Participate in Status review and reporting meetings.
• Working on multiple projects in a high-stress environment under aggressive deadlines.
• Exposure to maintaining warehouses metadata, naming standards and warehouse standards for future application development.
• Created product documentation, including online help, printed user manual and training materials.
• SVN repositoryfor version control
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in the continuous enhancements and fixing of production problems.
• 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.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL*plus.
• 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, HP Quality Center, JIRA, HP QTP, LoadRunner.

Confidential, Dallas, TX

Sr. Systems Analyst / Business Analyst

Responsibilities:

• Involved in various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements (BRD) using Rational Requisite Pro.
• Worked as a System/Business Analyst as well as an Assistant Project Manager to guide the team through the conversion process employing SDLC models, Iterative model, RUP concepts, Agile Model and UML.
• Collaborated with team across regions from various facilities of the company to gather business requirements by leading bi-weekly meetings and created status reports and presentations for the same.
• Facilitating JAD session follow-up for Project Plan updates, gained consensus for User Acceptance Testing and System Integration Testing requirements.
• Created and maintained the process documents for the project to be used for collaboration with developers, project manager, etc on SharePoint.
• Executed daily SCRUM and Sprint planning.
• Created and maintained data mapping documents.
• Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Project Manager.
• Used MS Word, MS Excel, MS Access, MS Project, MS Visio for documentation and analysis reports among other project management and reporting tools.
• Organized project tasks, managed team workflow and project scheduling using Team Foundation Server.
• Involved in various stages of code conversion in Workbench including Development, Testing, Stage and Production.
• Initiated GAP analysis by analyzing as-is and to-be conditions for the project at the beginning of the conversion process.
• Created test cases, test plans and performed ETL.
• Documented the mapping used in ETL processes.
• Sharing and managing assembly codes and data files.
• 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.
• Extracted data from the XML file and loaded it into the database.
• 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.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Fix defects as needed during the QA phase, support QA testing, troubleshoot defects and identify the source of defects.
• Oracle 10g/11g database was used.
• Documentation of common problems prior to go-live and while actively in a Production Support role
• Used JUnit Testing Framework for performing unit testing

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, Cyrstal Reports MS Sharepoint.

Confidential, Houston, TX

Sr. Systems 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
• Performed in-depth analysis of enhancements requests, defects, and other compliance, regulatory and business process issues in order to enhance existing product suite.
• Conducted business requirements gathering session to elicit clear, concise requirements from various clients.
• Analyzed business requirements, validated said requirements against regulatory/compliance mandates, as well as overall product suite direction to create the business requirements specification.
• Created various documentation deliverables including, but not limited to: Functional design document, user stories, data mapping documents, business process flow diagrams, and requirements traceability matrix.
• Created wireframes, prototypes and mockups iteratively in consultation with business.
• Assisted in testing activities as requested by the Quality Assurance Supervisor/Manager.
• Supported and reviewed UAT and SIT test plans
• Supported the implementation and configuration of major system enhancements as per client needs.
• Participated in post-release defects review meetings.
• Assisted implementations team in smoke testing and configuring UAT environments
• Ensure business requirements / application functionality is consistent with regulatory mandates from Dodd-Frank Act; SEC Issued Proposed Regulations.
• Analysis and review of Dodd-Frank Title VII and EMIR record keeping regulation.
• Analysis of the current state, existing trade reporting policies and procedures on record keeping to gather information and identify gaps.
• Conducting education sessions with stakeholders to present gaps and provide key points for subsequent project focus (downstream).
• Researching and presenting for stakeholder review key points from DF and ESMA covering OTC Derivatives, CCPs and Trade Repositories.
• Automated (through spreadsheets) regulatory filing notifications for international compliance team, producing significant time savings for group.
• Performed application validation after production deployment
• Interfaced with Implementations team to provide single point of contact for product.
• Provided support during Go Live. Run daily Post Go Live verification calls for monitoring production escalate issues and work on scheduling fixes when required during warranty period
• 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.
• 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.
• Communicated effectively with both business unit colleagues, clients, and technology team members in support ofSAP - Business Object environment planning, deployment, and operational support
• Responsible for creating a new data mart for reporting and analytics and also finalized the new data elements.
• Helped in generating the reports with Business objects XI (BI).
• 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.
• Created both Logical and Physical Data models
• Maintaining different versions for DDL extract of schemas and applications files (version control) using Tortoise SVN.
• 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
• Used Subversion (SVN) for software configuration management and version control.

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

Confidential, Chicago, IL

Business System Analyst

Responsibilities:

• 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
• 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.
• 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 variousdatabases.
• Performance tuning of Oracle Databases and User applications.
• Developed a DAL (Data Access Layer- PL/SQL Package).
• 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
• Trained team members with project knowledge and business processes.
• Coordinated Integration and smoke testing
• Worked with developers to resolve Issues and Production Incidents using Quality Center.
• Performing end-to-end testing, SIT (System Integration testing), UAT (User Acceptance Testing) and regression testing and Validate test results
• Conducted walkthroughs and defect meetings periodically to assess the status of the testing process and discuss areas of criticality.
• Worked with QA’s to develop Test Plans and Test cases, detected bugs in the system, prepared the Defect reports using Test Director and interacted with developers for Debugging
• 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, HP Quality Center, UML.

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