We provide IT Staff Augmentation Services!

Senior Systems Analyst Resume

Atlanta, GA

SUMMARY

  • 10+ years of testing experience as a test lead and as a data analyst in a wide variety of environments.
  • Experienced with ITIL process workflow Incident Management, Change Management and Problem Management.
  • Manage the overall relationship between Business Process owners, Application Vendors and IT development to build, implement and upgrade on packaged systems or new software deployment.
  • Experience handling migration of large volumes of data from source to target based on business rules.
  • Good knowledge in Financial, Banking, Capital markets and Healthcare Business domains.
  • Experience in Test automation using QTP (11.0 Version) for functional and regression testing.
  • Extensively used database technologies like DB2, Oracle, SQLServer.
  • Diverse experience on multiple platforms (Windows and UNIX environments).
  • Good working knowledge with tools like Visio, ALM and MS Office.
  • Worked in Agile and Waterfall software development environments.
  • Ability to learn new languages and tools quickly and Extensive training in software testing theories.
  • Capability to apply wide technical and practical skills to manage and execute white - box and black-box tests.

TECHNICAL SKILLS

Scripting Languages: Shell (ksh and bash)

Operating System: Windows, Unix and Linux

Test Management tools: Quality Center 10.0(ALM), Version One, JIRA

BI Reporting tool: Power BI

Database Technologies: DB2, Oracle and SQL Server

Tools: SQL Server Management studio, Oracle SQL developer and DB Artisan

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Systems Analyst

Responsibilities:

  • Establish signoff among stakeholders with Business and Functional Requirement documents.
  • Expertise in working with MS SQL Management Studio, writing complex SQL queries and maintain MS SQL Server Performance .
  • Performed upgrade on SAS that was one of the GxP application and was involved in document signoff process.
  • Meeting with the customers and dealing with software vendor to optimize the implementation process.
  • Worked on the Upgrade on various GxP applications during the migration.
  • Worked on retirement of the legacy systems.
  • Support the full BI lifecycle from requirements gathering and analysis through design and development, and release and support/maintenance phases •
  • Design, develop, and deploy reports and dashboards using Microsoft BI technologies including SQL Server, Power BI, SSRS, etc.

Confidential, Charlotte, NC

Assistant Manager

Responsibilities:

  • Performed support to Business Partners during UAT for staging various transactions from FXOL.
  • Conducted defect triage calls regularly with offshore.
  • Built automated regression tests using QTP.
  • Hired and groomed new team members.

Confidential, Charlotte, NC

Consultant

Responsibilities:

  • Participating in Scrum ceremonies.
  • Performed Requirement analysis, test scenario preparation and test data preparation.
  • Used JIRA to log the tests, issues/defects and requirement changes.
  • Initiated and monitored the batch process using SUFTI for business reporting.
  • Handled large volumes of data migration from Source to Target as per the business rules.
  • Involved in production testing during releases.
  • Conducted backend testing by executing SQL Scripts Using SQL Server management Studio, Oracle SQL Developer and DB Artisan

Confidential, Charlotte, NC

Systems QA

Responsibilities:

  • Participating in scrum meetings and sprint planning sessions.
  • Created scripts to automate the test execution report in ALM for each project.
  • Used complex SQL joins to query the data for backend testing
  • Involved in the Test Case walkthroughs, assessment meetings
  • Created and executed automated scripts in QTP 11.0

Confidential, Woodland Hills, CA

Programmer Analyst

Responsibilities:

  • Analyze Business & functional necessity documents and recognized test scenarios.
  • Participated in implementing test-plans and test-cases built on high-level and detailed design.
  • Involved in the Test Case walkthroughs, assessment meetings
  • As Offshore test lead was involved in audit meetings and was a single point of contact between development team and testing team for iterations, testing and deployment activities.

Confidential, Alpharetta, GA

Technology Analyst

Responsibilities:

  • Preparing test plan, review of test cases, execution, defects logging, inerfacing with clients.
  • Responsible for System and Integration testing and preparation of test data.
  • Responsible for creation of UAT test strategy, testplan, testdata and provided support for UAT testing
  • Development of Perl/Bash based Test Automation framework for SBE QA team
  • Production implementation support.
  • Development of shell scripts to verify file manipulation and data loading procedures.
  • Status tracking/reporting and mentoring of team members.

Confidential, Sunnyvale, CA

Software Engineer

Responsibilities:

  • Defect analysis and verification
  • Clear quest updates and follow up to closure
  • Evaluated Business and Systems Requirement documents.
  • Contributed in developing each test plan and test case based on the high-level and detailed design.

Hire Now