Software Engineering Sr. Analyst Resume

SUMMARY

Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Excellent expertise in Shell and Unix programming
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Proficient in Microsoft excel
Requirements analysis and design phases
Novice in SAS and Python
Worked in application support, development and application enhancement projects.
Experience in v-model and agile methodology
Winner of Confidential centre of excellence award in business operator category.
Oracle certified associate
Multiple times winner of performance awards in the project

PROFESSIONAL EXPERIENCE

Software Engineering Sr. Analyst

Confidential

Responsibilities:

Interact with Business Analyst and Client Partner to understand the Business Requirements and Functional Design for the SOW
Creation of Functional Design Documents, Standard Operating Procedure and Technical Design Documents
Follow complete Change Management process (Development, Test and Production environments) from RFC to change closure with necessary business approvals
Develop SQL queries, PL/SQL objects and UNIX Interfaces as part of multiple SOW on the areas MDM (Master Data Management) BO reports, Contract Data Warehouse (CDW) and Medicaid.
Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
Develop SQL queries for BO reports and tableau reports
Analyze data using excel to find discrpencies
Configure/Automate jobs using UC4 tool which are executed on timely basis
Creation of System test cases and UAT test cases.
System testing and creation of test proof documents.
Assist BO report and cognos report testing.
Work with Client for User Acceptance testing

Software Engineering Sr. Analyst

Confidential

Responsibilities:

Setting up development environment for development team
Co-ordinating test, load, pre-prod and prod deployments for each release
Maintenance of development environment
Monitoring JVMs
Performing health checks for test environment for smooth run of quality assurance testing
Maintenance and support of quality assurance test, bava test and performance test
Creation and maintenance of kintana packages and PVCS versions needed for each deployment
Co-ordinating the project teams through the go-live activities, code merge activities, migration of code/deliverables from environment to environment through the project life cycle ensuring overall quality.
Working with infrastructure team during each environment set up.
Maintain the list of package to deployed using excel
Along with onshore team brought process efficiency in managing the code merge activities, code migration procedures and release go-live procedures by rolling out the process (Code merge, build list, health check checklists and environment synchronization plan and tools like build automation etc.)

Software Engineering Sr. Analyst

Confidential

Responsibilities:

To develop and support Application, to interact with Client team, take Business Requirements and understanding the requirements.
To create and develop SQL scripts, PL/SQL packages (procedures, functions, triggers), UNIX shell scripts, and to make the required database changes.
Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
Wrote Shell Scripts for Data loading and DDL Scripts and automated shell scripts using crontab.
Provide support to the business users of the system (Scientists and Chemists) and resolve issues which come in the form of tickets.
To work on enhancement and bug fixing of code.
Involved in Unit Testing and Development of Test Cases.
To do performance tuning of Sql and Pl/Sql queries.
Responsible for Peer Review of codes, during different phases.
Defect Fixing/Optimization and providing support to client team during Production releases.
Data flow monitoring from different vendors like PDAM, Covance etc to CTMS and from CTMS to Cognos Reports. Reporting the failed jobs and issues in data flow and remediating the data if required.
Analyzing and Cleansing of patient and visit data
Conduct technical sessions for the team ensure everyone is aware of the technology being used.
Involved in Causal Analysis and Reporting (CAR), Root Cause Analysis (RCA), Metrics Report
Involved in the Confidential service management suite upgrade testing.