SUMMARY:

• Over 19 years of experience in Information Technology, strategic planning, delivering projects and programs.
• Also has experience in planning, programming, designing, analysis and application development, automation of Object Oriented
• Programming and transition of applications involving custom development in various businesses and delivered projects & programs by using different delivery models.

TECHNICAL SKILLS:

Environment: UIX AIX/Solaris, Windows 95/98/NT/2000, IBM SP2 AIX 4.2 UNIX, HP UX 10.20, Compaq

Databases: Oracle 7.x - 11g, Oracle 7.3/8i (8.1.6), Informix 7.3, SQL Server 6.50 and SYBASE 11

Hardware: Pentium PC, VAX/VMS, Sun Workstations, IBM Compatibles

Automation: Selenium, QTP, Win Runner, Rational Robot, and Informatica

Tools: Quality Center, Test Director, PVCS, Clear Quest

Languages: SQL, PL/SQL, C, C++, Java, XML, HTML, JavaScript, ASP.Net.

Knowledge on BigData: Hadoop and other Ecosystems like Sqoop (data Exchange), Oozie, Workflow, Flume Log Collector, Hbase, Hive, Impala, Mongo DB, Casandra.

Note: Currently I am PMI member and preparing for PMP certification

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst/ Project Manager

Responsibilities:

• Gathered requirements and prepared business requirement documents (BRD).
• Acted as a liaison between Technology and Business for clear and better communication.
• Consulted with Systems Analyst to create Technical Specifications and development to assure traceability to Business Requirements Doc.
• Involved in reviewing business requirements and analyzing data sources from multiple database platform for design, development, testing, and production rollover of reporting and analysis projects with in Tableau Desktop.
• Created various templates for the benefit of the project such as Requirements Template, FRD, Status Report, Meeting Templates and Status Updates.
• Created and maintained Meeting Minutes/Issues Log and ensured timely resolution of all outstanding items.
• Captured Action Items, Issues, Risks and Dependencies during the JAD Sessions and coordinated with Lead and PM to manage and resolve.
• Experience in creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, Sequence, Activity diagrams.
• Analyzed Requirements and created Use Cases, User Stories, Use Case Diagrams, Activity Diagrams using MS Visio.
• Involved in documenting test cases, scripts and resolving User Acceptance Testing (UAT) concerns by coordinating with QA team.
• Managed 16 member team and Delivered multiple IT projects applying SDLC and project life cycle from end to end.
• Created and managed Sprints using MS Project for Agile Environment.
• Scheduled Sprints, Planned meetings and prepared project schedule in Agile Environment.
• Lead EMR project efforts and delivered to clients increasing annual revenue.
• Identify the required skill set resources and on-board them to ramp-up the Offshore team aligned with On/Off model agreed in the Statement of Work
• Overall delivery and performance project and related deliverables in line with agreed project plan, specification and budget
• Create project plans aligned to the transition milestones and time lines
• Ensure to follow the vendor transition methodology (starting from knowledge transfer to steady state), tollgate processes and deliverables
• Ramp up & on-board the resources in short span of time aligned with On/Off model Statement of Work
• Assign the roles and responsibilities for the on-boarded teams and map them to the respective knowledge transition associates
• Ensure that teams are completing the mandate client trainings and compliant with the HIPAA guidelines before onboarding in to the project
• Support the delivery team to meet the stringent knowledge transition completion and the signoff the outcome deliverables by all the key stake holders
• Upon completion of KT, define the SLAs for the critical applications and ensure that they meet during observation & replication phases as per the expectations
• Plan and execute the steady state and hyper care support within agreed time lines and minimizes the interruptions to the business critical applications
• Interactions with business group to understand their expectations and aligned team
• Project escalation process to address critical items (affecting resources, cost or schedule) as well as any potential critical items, and help resolve or escalate Project issues, as necessary.
• Meeting all project plans, Service Levels, Key Measures for the project
• Schedule the sprint demos for the implemented features to all the stake holders and seek the inputs, feedback and correct them earlier than later
• Track and report the team productivity to the stake holders and work closely with the team members to resolve technical/environmental issues if any
• Preparation of the weekly and monthly status reports to management and leadership teams
• Proactive risk mitigation plan for the both internal & external dependencies impacting scope, schedule and budgeted cost
• Manage Incumbent Vendor’s expectations by considering factors such as business-criticality of requirements, complexities of requirements, stability of requirements, offshore capabilities, available time, etc.
• Define the risk management plan for all the deliverables and share the same to the business users, technical and release management teams
• Alert/escalate to all the stake holders in case of any deviations to the deliverables due to any scope creep
• Involved in meetings to build and customized EHR/EMR modules based on the end user needs.
• Develop complex SQL queries using querying tools and SQL/T-SQL and relational database manipulation.
• Analyze data by using T-SQL’s, using pivot and adhoc functional tests in ODS (operational data store).
• Analyze the streaming data (Session shifting data) in backend for various clients, finding analogies/patterns with or without use of various clients, buying patterns, etc.

Environment: Informatica ETL, Tableau, SAS, ER-Win, SQL, Business Objects 5.0, PowerPivot, Big Data, MS Project, EHR/EMR, AGILE/SCRUM.

Confidential

Project Manager

Responsibilities:

• Working currently as an Enterprise Data Warehouse as a Project Manager and handling various projects and coordinating all aspects of the program, including planning and control, estimates, putting plans into action, keeping everyone informed of plans, progress and issues, managing the team and ensuring the quality of the deliverables
• Train, lead, motivate, coach, and manage a high-performing team of project and Quality Leads
• Represented QA in the planning phase and lead the QA team in gate 1 of the project
• Prepared test plan for gate 1 and created the test cases and sequence of testing, using business testers from client
• Conducted QA meetings, including kickoff meetings and test progress and defect management meetings
• Prepared the QA part of the project plan and created test strategy, including functional, integration, regression, inter-system testing and UAT. Also created test plans and test scripts and executed them
• Lead testing projects with 36 member team and budget of $3Million, including defining estimates, resource planning, capacity planning, establishing timelines, dovetailing testing with the overall project plan and managing the testing to adhere to established benchmarks and timelines
• Involved in Preparing Test data, Test log and Defect Reports
• Working with the project team to manage and prioritize bugs
• Participating in design and code reviews for development tasks internal to QA related to test tools for automation and test management
• Identifying key experiences from previous releases and building QA plans to address what was learned from those experiences
• Conduct meetings to coordinate processes and procedures both internal to QA and between departments
• Author and Review the test cases for use cases and analyze the test execution results. Generate the test case authoring and execution metrics
• Created User stories, story points and scheduled/executed sprints for EPICs in JIIRA, Agile environment.
• Managed Agile boards to track for project planning and project flow and status, Agile environment.
• Prioritized, Tracked issues and Involved in performing Regression testing and Unit testing, Agile environment.
• Review the defects on a daily basis and participate in the defect triage sessions and analyze the test execution results
• Analyze Business requirements, attended Change Request meetings to document changes and implemented procedures to test changes
• Assigning the tasks to team and monitor day to day activities
• Creating Test Phase Test Cases based on documented requirements from the customers and business analysts.
• Closely working with developers and System Engineers to nail down the technical problems.
• Verify the data loads by using ETL
• Experience in writing SQLs to validate the data that is coming from different source systems (MS SQL Server, DB2, Oracle and MySQL) into destination databases (MS SQL Server)
• Providing daily \ weekly status reports to the Directors
• Reviewing the deliverables and making the delivery in time

Environment: SQL Server, Oracle, ALM 11.0, ETL, Informatica Power Center 8.6\9.6, JIRA, SELENIUM, AGILE/SCRUM.

Confidential

Project Coordinator/Lead QA/Analyst

• Responsible for testing of Oracle Forms for Confidential, WIC group and automation of the whole testing cycle.
• Prepared test plans, test cases, test matrix and Coordinate Oracle Form designs with developers.
• Conducted QA meetings, including kickoff meetings and test progress and defect management meetings
• Prepared the QA part of the project plan and created test strategy, including functional, integration, regression, inter-system testing and UAT. Also created test plans and test scripts and executed them
• Lead testing projects in Agile environment including defining estimates, resource planning, capacity planning, establishing timelines, dovetailing testing with the overall project plan and managing the testing to adhere to established benchmarks and timelines
• Involved with DBA team in maintenance of test environment and setup WinRunner in the auto execution of test scripts daily.
• Maintained the TestDirector and supported the development and Management team with the TestDirector needs.
• Performed Regression testing, Integration testing, Adhoc testing, Black box testing and White box testing
• Prepared WinRunner TSL scripts for 18 Oracle forms and ran reports against the Oracle database to validate the data for WIC (Women, Infant and Child) project.
• Worked with Administration team in setting up environment, running end-of-day reports to validate the data, verify PVCS version manager is updated with version changes, and also validate the new “FMB” file is reflecting new changes.

Environment: Oracle 6i, Oracle Forms, TestDirector 7.2, WinRunner7.5, Windows XP/NT, LoadRunner7.0, AGILE.

Confidential

Lead QA/Analyst

• As a Lead QA/Analyst, I was responsible for analyzing business requirements system requirements, data model and design documents, designing testing strategy, developing test cases and testing migration of legacy system ACAP’s data to CAPSTONE.
• Worked with cross functional teams on credit assessment and scores, analyzed data.
• Prepared test plans, test cases for Bulk Load phase 1 testing, understood the flow of Ab Initio graphs and tested the data storage process at CSA from all downstream systems.
• Trouble shooting test harness issues with developers, maintaining stable testing environment during the testing cycle and validated code from earlier releases promoted didn’t affect the current release.
• Used Rational Clear Quest Web tool to track defects and ran both manual and automated test cases in Test Director.
• Did integration, test harness, bulk load, regression, monitoring and performance testing during different phases of testing cycle.
• Performed Manual as well automated Testing of the Applications in Agile Environment.
• In Agile environment, Worked with Ab-Initio developers to resolved the data redundancy issues, included in meeting with Architects and Project Managers.
• Carried out the full Functionality and System Test both manually and using WinRunner.
• Involved in creating, loading and testing of different Confidential applications and validating the data integrity by using different Confidential tools.

Environment: Oracle 8i, HP- UNIX, Windows - 95/98/NT, Test Director6.02, Rational Clear Quest, WinRunner6.0, HNC CWS Software, HNC AWS Software, Compuware Corporation File-AID/CS Converter 02.02.00, Ab-Initio, TOAD, XManager, AGILE.

Confidential

Lead QA/Analyst

• As a Lead QA/Analyst in STATUSPRO, responsible for Analyzing, Designing, Developing and testing of Legacy systems with in WORLDCOM.
• Prepared test plans, test sets, and also prepared and ran test scripts manually using SQL, PL/SQL, SHELL and automatically using WinRunner and tracked defects using both Test Director and PVCS Tracker.
• Used TOAD to connect to ORACLE database and prepared scripts in PL/SQL to verify data manually.
• Analyzed and verified SQL scripts during migration of code from testing to production environment and was working with developers during implementation phase.
• Worked closely with developers during data in copy books were triggered and ensured the data was successfully transmitted between different environments.
• Involved in teamwork, did performance, stress and regression testing of code during different phases.
• Involved in detail, regression and alpha/beta testing of STATUSPRO front-end and backend reports.
• Designed mapping between tables and loaded feed files from source to target from different source systems using Informatica.

Environment: Oracle 8i, IBM SP2 AIX (4.2) UNIX, Windows - 95/98/NT/2000, Test Director7.2, PVCS Tracker, Informatica5.1, WinRunner7.01.

Confidential

Lead QA/Analyst

• As a Programmer/ Lead QA/Analyst in METIS, responsible for analyzing, designing, developing and testing of reports in local systems information warehouse for Confidential a Telecom Company using ORACLE and INFORMIX Databases.
• Prepared test Plans, test Cases, verified reports for consistency, which are critical in providing Information to operational groups for local systems within the Telecom Company.
• Verified data generated using SQL, PL/SQL, PRO*C, ESQLC, 4GL, SHELL scripts against INFORMIX, ORACLE Databases and used warehouse tools BRIO and METACUBE in extracting data.
• Involved in extract data, which is summarized and aggregated to generate reports in user requested formats such as MS-Excel Spreadsheets, MS-Access, Flat Files.
• Involved in integration, validation, system and regression testing of all the MCI legacy systems.

Environment: Informix (8.2) XPS, Oracle 7.3.4, IBM SP2 AIX (4.2) UNIX, HP - UX 10.20, Windows - 95, MS Office - 97, Brio Explorer 6.0, Metacube.