We provide IT Staff Augmentation Services!

Business Analyst Resume Profile

San Antonio, TX

Summary

  • Self motivated dynamicBusiness Analystover7years of experience in the Software Development industry on variety of projects ranging in both size and scope involving design, development analysisand an in-depth understanding of the business process models underlying these domains.
  • Extensive work experience working in Insurance and Banking domains likeForeclosure, Mortgage Insurance,Insurance Financial Systems, Alternative Investments, merchant services, bankruptcy, equities, debt instruments, trades and Telecom domain retail billing line of business with COTS package.
  • Experienced inApplication Development, Application Maintenance, Production Support, and Application Reengineering and Legacy Migration, quality assurance.
  • Excellent work experience in MS Project, MS Word, MS Excel, MS PowerPoint, MS Access.
  • Performed Business Analysis related activities like scope identification, requirements gathering and analysis, feasibility analysis, gap analysis, risk analysis mitigation plan, release management and Training to end users.
  • Expert in conducting Requirements workshops, Personal Interviews, Questions Answers, JAD and JAR sessions for requirements generation.
  • Excellent experience in creating Business Requirements, System Requirements and GAP Requirements for Web, Mainframes and Client server applications.
  • Adept in managing requirements using requirement management tools like Telelogic DOORS, Rational Requisite Pro and Quality Center. Experience in Agile/Scrum methodologies with epics, user stories.
  • Knowledgeable in Creating Data Change Request in Production for any kind of errors in data loading
  • Created many quality requirements for Legacy, Bottom up or Redesigning applications
  • Expertise in creating Business Use Cases, System Use Cases and Data Flow diagrams to gain better understanding of the Business Flows and Processes
  • Excellent leadership skills to partner with project management team in leading the project to successful completion
  • Proficiency in Software Development Life Cycle and Testing Methodologies, hands on experience with Spiral, Agile, Waterfall, Solution Delivery, Bottom Up and Reverse Engineering methodologies
  • Performed various roles includingSr. Software Developer, Designer, Team lead, Module leader,Support analyst, Subject matter expert for about 5 different projects.
  • Good experience in extraction, transformation and loading of data directly from various data sources like flat files, Excel and other databases and oracle Forms/Reports and procedures for reporting.
  • Excellent work experience in Oracle 11g/10g/9i/8i, SQL Server 2008, PL/SQL and database tools as PL/SQL Developer, UTL File, SQL Loader, SQL Server Management Studio and TOAD.
  • Good development experience in C , ASP.NET, HTML, VB, JavaScript, IIS, web services
  • Extensive experience in developing complex queries,Packages, Stored Procedures, Functions, Triggers, tables, viewsusing PL/SQL and T-SQL.
  • Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
  • A multi tasking analytical thinker with the ability to work on fast paced work Environment.
  • Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.

TECHNICAL SKILLS AND EXPERTISE

RDBMS: Oracle 8i/9i/10g/11g,SQL Server 2005/2008, MySQL, MS Access

Tools: SQL Plus, SQL Loader, TOAD, Oracle Developer 6i/9i, SQL ServerManagement Studio

Languages: SQL, PL/SQL, ASP .NET, C , PHP, VB.NET/6.0, Core Java

Scripting Languages:UNIX Shell Scripting, Perl Scripting, JavaScript,VBA

Web: Web Services, HTML/DHTML, CSS, Ajax, IIS 5.0/6.0

OS: UNIX/SUN Solaris, Windows 95/98/NT/2000/XP, Mac OS, MS DOS

PROFESSIONAL EXPERIENCE:

Confidential

Title: Business Analyst

Responsibilities:

  • Conducted actively interactiveJoint Application Development JAD sessions alongside with business users to understand the requirements as a business analyst and createddesign specifications
  • Participated in database modeling and database design for the enhancements received.
  • Created use cases using Unified Modeling language UML and managed the entire functional requirements life cycle using Rational Unified Process RUP
  • Involved in designing and creating UI pages and preparing layout for the system
  • Tested the initial system to the developed purchase module from the client perspective
  • Analyze and verify the logs for all in and out transactions
  • Reviewing all the test work products using Review Automation Tool RAT
  • Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project
  • Interacted extensively with development and testing team to make sure that the developed system matches the client requirements
  • Provided realistic estimates and updates of the work necessary to complete all relevant deliverables, and complete all tasks within targeted timeframes.
  • Verified Claim system for transmitting information back and forth
  • Used Unified Modeling Language UML in preparing business requirements and diagrams
  • Drafted training documents and provided training to end-users.
  • Provided periodic reports to the management explaining status, risks, plan of action, dependencies, criticalities
  • Contributed to implementation of CMMI and ISO 9001:2000 standards in the Organization.
  • Performed database modeling and designed the program specs for all database objects involved keeping performance stand points in view and Implemented database objects stored procedures, functionsand packages to achieve the required functionality
  • Actively analyzed and implementedperformance tuning of existing database objectsand performed duties such as Tuning, Backup and Restore.
  • Developed interface scripts using Unix shell scripting and invoking PL/SQL procedures to pull and load data into the systems.
  • DevelopedASP .Net modules with entity framework and created web services for data flow for downstream systems.
  • Constantly monitored and enhanced the performance of offshore and onsite team and motivated the team for better performance and on time delivery
  • Proactively communicated issues in the application to clients thereby suggesting value adds to the application

Environment:

UML, RAT, Oracle 11g, ASP .Net with entity framework, C , JS, HTML, Unix, Team Foundation Server, Telelogic DOORS, MS Project, MS Visio, UML, OBIEE

Confidential

Title: Technology Analyst

Responsibilities:

  • Gathered business requirements from interviewing Subject matter experts SMEs and documented in a format that could be reviewed and understood by both business and technical teams
  • Played a key role in the preparation of Project Plan and got a detailed understanding of business functionality
  • Designed the business requirement gathering approach based on the project scope and SDLC Methodology.
  • Conducted interviews with key business users to collect requirement and business process information
  • Prepared BRD and other documents by conducting workshops, JAD sessions and by brainstorming
  • Hands on experience with project management, reporting tools and working with different levels in the organization
  • Part of the SME Workgroup of Facets Electronic Data Interchange standards Business Process Flows for defining testing strategy that need to comply with the Medicaid guidelines.
  • Maintained a good rapport with all teams at different levels and involved in the group workshops and JAD sessions in the Software Development Life cycle SDLC
  • Developed database migration scripts for data movement from Bank to First data system.
  • Optimized the existing code to enhance the performance of the database objects thereby enhancing the overall application performance.
  • Interactive communication with the clients to understand the requirements and assisting the users in user acceptance testing.
  • Used TOAD, SQL developer and SQL yog to run SQL and PL/SQL code to manipulate the databases in all environments
  • Implemented business functionality to handle merchant services issues using PHP and MySQL.

Environment:

UML,Rational RequisitePro, Oracle 10g, UNIX, ASP .net, MySQL, PHP, Harvest, SharePoint

Confidential

Title: Technology Analyst

Responsibilities:

  • Analyzed the project business requirements by interacting with the clients andbusiness/system analysts to understand the end user perspective and implemented the system from end-to-end
  • Conducted extensive interviews and discussions with business users identify user requirements.
  • Implemented Rapid Application Development SDLC model driven testing methodology.
  • Provided realistic estimates and updates of the work necessary to complete all relevant deliverables, and complete all tasks within targeted timeframes.
  • Participated in defining scope of the project and approach for project execution
  • Used Unified Modeling Language UML in preparing business requirements and use case diagrams
  • Performed feasibility analysis to understand proposed system's capability to suit business requirements.
  • Worked ondatabase modeling and database designand prepared program specifications for PL/SQL Procedures and Functions for functionality implementations.
  • Created various Oracle database objects such as Tables, Views, Materialized views, Functions, Procedures, Triggers, Packages, Records and Collections
  • Developed batch jobs for loading database tables from Flat Files using SQL Loader and handled pre processing and post processing of data received.
  • Developed user friendly web pages in ASP .NET which involved invoking of web services
  • Excellent .net code debugging capabilities for root cause analysis and problem solving
  • Excellent domain knowledge on alternative investments and different categories of funds.
  • Handled production support issues with high proficiency without missing any SLA provided.
  • Played key role as a team lead and managed offshore and onsite teams effectively thereby maintain harmony and ensuring that all the deliverables were delivered on time with 100 testing and bug free.

Environment:

ASP .net, C , Oracle 10g,Unix, MS Visual Studio 2008, Team Foundation Server, JIRA.

Confidential

Title: Technology Analyst

Responsibilities:

  • Facilitated collection of functional requirements from system users and preparation of Business Requirements Documents BRD and Functional Specifications FSD , using RUP methodology, which provided appropriate scope of work for technical team to develop a prototype and the overall system
  • Facilitated Joint application Development JAD sessions for defining business requirements and user acceptance testing standards. Also conducted JAD session follow- up for Project Plan updates and gained consensus for User Acceptance Testing requirements
  • Worked with the Database Analyst to generate Crystal Reports for the analysis of numerous customer portfolios
  • Developed Test Plans and Test Scripts, using automated and manual testing tools, for Functionality Testing of the enhanced applications
  • Developed optimized oracle interface scripts for data migration from Wachovia to Wells Fargo systems.
  • Participated in database modeling and database design for Wells Fargo systems
  • Prepared program specifications for the data migration and conversion
  • Created Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections for implementing the pre processing and post processing of data as a part of migration.
  • Participated in Performance Tuning using Explain Plan and Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL
  • Developed web pages in ASP .NET for Bankruptcy application involving workflows for each bankruptcy chapter.
  • Developed VB.NET pages to manage the asset tracking system.
  • Developed authorization code in VB.NET to facilitate the authorization process for global users.
  • Excellent .net code debugging capabilities for root cause analysis
  • Developed interface scripts for data uploading and downloading from upstream and downstream systems.
  • Handled production support with excellent efficiency by resolving the support issues on time within the SLA and suggested the best optimized solutions.
  • Interacted effectively with the deployment engineers, DBAs and QA team during the code releases thereby ensuring that all the deliverables were deployed and tested properly.

Environment:

VB.Net, Oracle 10g, ASP.Net, C ,UNIX, Harvest, Autosys, Cronjobs

Confidential

Title: Software Developer

Responsibilities:

  • As a support analyst provided excellent support on the production issues raised. Root cause analysis and solutions were provided within the stipulated time duration.
  • Developed scripts to facilitate various products introduced as a part of VOIP and Normal Telephony.
  • Developed UNIXshell scripts to support the invoice generation on a monthly basis and as well as bi weekly basis based on the user configuration.
  • Monthly bill run activities were handled effectively with no issues thereby ensuring that all the invoices are generated successfully by 2nd of every month.
  • Involved in the business requirements gathering thereby providing useful inputs to the business analysts for the new products introduced.
  • Gained excellent knowledge on telecom billing, which includes retail billing, invoice generation, order management and payments.
  • Developed user-friendly oracle reports relative to the billing information of customers.
  • Created database design as a part of Progressor to Kenan system migration
  • Prepared program specifications for PL/SQL Procedures and Functions for the data migration and conversion
  • Created Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections
  • Ran batch jobs for loading database tables from Flat Files using SQL Loader
  • Performed Unit test, Integration Test and created the test plans for unit and user acceptance testing, provided technical documentation.

Environment:

UNIX, Oracle 9i, Java, Visual Source Safe, SSH client, Toad, Remedy

Hire Now