SUMMARY

• Over 8 years of Experience in the field of Information Technology as a System Analyst in Architecture, Analysis, modeling, designing, Insurance, Finance, Publication, Banking, Health Care and Telecommunication domains.
• Extensive experience in Business Performance Management, Process Management, Business Process Reengineering, Statistical Analysis System and Enterprise Content Management.
• Expertise in identifying, developing and documenting Business and Functional Requirements Specifications FRS , Software Requirement Specifications SRS , organizing discussions, Software Development Life Cycle SDLC and requirement elicitation sessions.
• Adept with industry standard methodologies like Rational Unified Process RUP , Object Oriented Analysis and Design OOAD , agile development and Iterative method.
• Extensive experience in creating and executing Test plans and Test Scenarios.
• Worked with architects developers using Teradata SQL Assistant executing SQL queries stored procedures.
• Experience in Data Migration, Data Conversion, Data Extraction, Transformation and Loading ETL using SQL SERVER 2000 and PL SQL Scripts.
• Extensive experience in interacting with business users to identify information needs and initiating process changes, gathering requirements and authoring Use Cases, Use Case diagrams, Sequence diagrams, Activity Diagrams based on UML methodology using tools like Rational Rose and MS Visio.
• Understanding of implementation of regulatory guidelines such as the Basel-II and Sarbanes Oxley act SOX .
• Have full life cycle experience throughout data modeling, data migration strategy and software application architecture.
• Good understanding of SAS and other statistical software packages.
• Experience in conducting Joint Requirement Planning JRP , Joint Application Development JAD and Rapid Application Development RAD sessions. Felicitated technical design sessions with DBAs, developers QA Team. Experience in leading multidisciplinary teams along with hands on expertise in Process identification, Project Coordination, direct customer interaction and leadership responsibilities.
• Experience in creating and documenting both business and technical Metadata documents from Metadata Repositories.
• Extensive experience in creating UML diagrams and creating mockups and wireframes for web navigation screens.
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts and documenting all phases of QA process with Hands-on experience in Manual and Automated testing using Win Runner, Load Runner and Test Director.
• Good understanding of Life Insurance Annuity.
• Extensive experience in working with Mercury tools like Mercury ITG IT governance center and Mercury Quality Centre Test Director . Also good understanding of Rational Suite including Requisite Pro, Rose, Clear Case, Clear Quest.
• Good understanding of Data Warehouse, Tera Data and Data Mart Systems.
• Good understanding in SQL, T-SQL, PL/SQL, Mainframe and Web Development.
• Exceptional written and verbal communication skills, Strong business acumen, strategic thinking, interpersonal and presentation skills.

SKILLS

EXPERIENCE

Confidential

Senior Systems Analyst

• Worked with Infrastructure Development team to measure the company's Intranet network performances, server application outages, server application availability and capacity by utilizing Uptime software.
• Engaged with stakeholders in project feasibility, kick-off meetings and stakeholder analysis
• Initiated discussions with the business stakeholders and Subject Matter Experts SMEs to understand and document business needs
• Assisted the Product Manager and Product Owner in getting the product features aligned with their Roadmap
• Tweaked the project plan that identified specific tasks to be executed and within the expected timeline
• Ensured the timelines are realistic and meet the project goals.
• Planned and coordinated efforts with both the On-Shore and Off-Shore development teams
• Discussed and recommended solutions to Sales Operations Personnel to help shape the front-end applications
• Interacted with 3rd party vendors to describe project goals and to get their commitment to the timeline
• Designed the front-end application GUI changes after discussions with the business and the Customer Delivery representatives
• Researched and created the As-Is and To-Be workflow diagrams for the Retail Applications that include the Front-End Customer/T-Mobile Representative facing applications such as Watson, POS, the backend systems, Middleware applications and credit systems
• Set up service monitors and service groups on Linux and Windows Networks to measure availability and outages.
• Developed a set of Key Performance Indicators for measurement and analysis by gathering requirements and facilitating meetings between various teams in the department.
• Developed dashboards and reports to show the performance of the networks, and the variance in compliance to the Service Level Agreements.
• Developed detailed reports on agent vs. agentless monitoring to show the possibility of network being exposed to attacks in case of agentless monitoring.
• Created packages using SSIS from heterogeneous sources like Access Database, Flat Files, Excel and CSV, SQL Server database sources handling Outbound Member Files, Inbound Claims File and Inbound Provider Files.
• Designed the application to meet users requirement document and also developed a web based database application for emergency communication based on webLogic , oracle.
• Worked with the developers to understand the ERD Entity Relationship Diagram and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
• Worked with the Business Objects developers to provide input for generating automated and adhoc Business reports.
• Designed SSIS Packages to transfer data between servers, load data into database on SQL Server 2005 environment and deploy the data.
• Experience in calling a Web Service, through SSIS Package through the transformation, and wherein you declare a variable with its URL link.
• Used SQLs to test various reports and ETL load jobs in development, QA and production.
• Involved in using BI tools like Import and Export Wizard for developing the packages.
• Created Project plans through Microsoft project.
• Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Use UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
• Developed, implemented and executed test methodologies and plans to ensure software product quality as per the Rational Unified Process RUP methodology.

Environment: MS Visio, MS SharePoint, HP Quality Center, MS Office, Rally, Windows, Web Services, Unix, Java,J2EE

Confidential

System Analyst

• Participated in activities related to consulting with end users e.g., clients, internal customers, etc. to determine the scope and objectives of proposed programs and enhancements in the application.
• Assisted with identifying requirements utilizing end user feedback write test scenarios and cases for new and existing programs based on detailed design specifications and given requirements while adhering to established policies, procedures, and deadlines.
• Developed detailed Test Cases against the Use Cases, and the Functional and the Technical Specification documents.
• Wrote detailed test cases clearly and show the steps necessary to execute the tests, and the expected results associated with each step.
• Appropriately name and place step numbers for each step in the test case and provide accurate details for clear execution of the test cases.
• Prepared and gathered the test data necessary for the test execution in the QA environment.
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams DFDs , ER Diagrams and Web Page Mock-Ups using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Created training plans, prepare training materials and deliver training to internal and external users for new and existing tools and processes.
• Executed the written and approved test cases against the delivered applications into the test environment and enter the test results with Pass or Fail criteria.
• Communicated with the development team on any issues that arise from the execution.
• Worked with QA and Development staff to report, verify and close the defects and resolve any issues that arise during testing.
• Participated in defect triage, prioritization and review meetings on a daily basis.
• Ensured that the reported defects in Quality Center get fixed by the development team and get retested in the test environment.
• Updated worked with the business team to recommend appropriate training, communication and scheduling as systems are deployed into development, test production.
• Updated the status of the bugs by either closing or rejecting the bugs appropriately. Ensured that the defects are properly retested and marked in Quality Center with appropriate statuses and comments based on the Defect Management methodology document. Ensured speedy closure of the defects.
• Provided support to other divisional staff as they perform QA testing of enhancement and features by providing in-service QA support.
• Helped the User Acceptance Testing UAT team with the design of their test cases at the business level, and support the UAT team to meet their objectives.
• Worked with the Customer Support group and help in reproduction of the defects in QA, and the closure of the reported defects.
• Participated as a member of Software Development Life Cycle SDLC development teams from project initiation through implementation as assigned.
• Worked as a QA member of the Scrum team running in an agile methodology.
• Adhered to the overall QA processes and ensure that the processes are followed by all members of QA and the development. Be a QA champion and educate the staff with the methodology.
• Provided input to the technical writing staff by reviewing the documentation.
• Reviewed all Technical and Functional specification documents and give technical feedback to the Business Analysts to ensure that the documentation meets the QA testing objectives for more thorough testing.
• Created automation test scripts using HP Quick Test Pro for the regression testing purposes.
• Followed the automation methodology and ensure that all scripts are written clearly and enough comments have been placed in the code for other members of the team to understand the code.
• Consistently recognized for excellent problem-solving and analytical skills by programmers, project managers and supervisors

Environment: MS Visio, MS SharePoint, Oracle, Teradata, SAS-MA, Epiphany, MS Office, Windows, UNIX

Confidential

Business Analyst

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Met with client groups to determine requirements and goals. Utilized Rational Unified Process RUP to configure and develop process, standards, and procedures and create a Business requirement Document.
• Experience with ATG application framework
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Assigned tasks among development team, monitored and tracked progress of project following agile methodology.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Worked with various vendor groups to gauge the effectiveness of their solution
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Created wireframes and storyboards
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Experience as an external e-commerce solutions provider.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Upgraded e-commerce web site engine by managing resources and responsible for installing new software version to increase site uptime by 3 .
• Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, RUP, Agile, Rational Rose 2002, ATG, Rational Clear Quest, Rational Clear Case, Rational requisite pro, rational test manager, Rational Robot

Confidential

Software Engineer

• Conducted Requirement Gathering sessions with key business area Subject Matter Expert's to collect business requirements and business process information to update the Business Requirement Document.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Created and reviewed business requirements, functional specifications, project schedules, documentation and test plans.
• Development of prototypes with BO XI strategy planning data mart, strategic projects control data mart .
• Created Use case scenarios and wrote them according to specifications and Implemented UML methodologies to design Context Diagram, Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and ER Entity-Relationship.
• Analyzed research on operational procedures and methods and recommend changes for improvement with an emphasis on automation and efficiency.
• Articulately interacted with developers, discussing the Specifications provided by the Analysts and the changes and the discrepancies in the application in order to gather user requirements, co-coordinating business meetings and generating monthly status reports etc.
• Created ETL mappings in Informatica to load data into Oracle 8i data mart from legacy systems.
• Performed Integration testing, Build Verification testing, System testing manually.
• Involved in generating Test Plans and Test Specifications as per Business requirements in conducting Manual and automated testing at various phases of the project development.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Collected test metrics weekly from database that reflected the current status of the test execution and the state of the defects. Tracked defects using Test Director.
• Conducted Regression Tests on different builds for GUI and Functionality Testing using automated Test Scripts and performed Web Testing for verification of Broken Links, HTML Images, and HTML Content.
• Reported and tracked testing progress in the customized bug tracking system and worked with the IT Groups to fix the problems.
• Developed site map, navigational rules, screen layouts and GUI elements. Programmed registration and search functions in Active Server Pages. Designed and developed table layouts, frame based navigation and forms in HTML/JavaScript.
• Analyzed and translated editorial and visual content for web channel.
• Developed database queries and updated capabilities for the components using Active Server Pages, VB Script. Forms provided custom reporting on database dataset via Active Server Pages ADO component.
• Enhanced User experience by using session management via cookies and server-side state management in ASP.
• Developed HTML, DHTML, JavaScript templates for interactive elements and navigation components.
• Developed reporting screens for management using ASP and HTML pages. Developed dynamic custom report creation forms for maximum flexibility in report generation and querying against database.
• Defined Validations to be built into applications per the functional requirements. Developed JavaScript/VB Script function library for client side validations and server side user validations.