Navjot Saini

acumk0@r.postjobfree.com

704-***-****

Senior Business Systems Analyst

** ***** ** ********** ** IT and Management experience in Software Development Life Cycle (SDLC) and Project Life Cycle working as Business Analyst/Quality Assurance of Business applications. Have experience in requirement analysis & management, business process mapping, business case development, functional consulting, and stakeholder management with experience of multiple end to end project implementations for various Health Care and Insurance Systems.

A perfectionist for incorporating defined best practices and project methodologies with a reputation for applying existing technologies to discover unconventional solutions, with expertise in.

Primary Skills:

PL/1, Cobol, REXX, SAS, JCL, CICS, TSO/ISPF, Websphere MQ

Secondary Skills:

SQL, SAS, VB/VBA, CSF Designer 8.5, VSAM

Database:

DB2, Oracle, MS SQL Server, MS Access

Methodologies:

Agile, Waterfall

Others:

SPLUNK, Rational Clear Quest, Service Now, Clear Case,

Crystal Reports, SharePoint, Service Center, Quality Center

Over 8 years of experience as Lead Systems Analyst in system analysis, design, data modeling and development across various Life Insurance and Healthcare projects using waterfall & agile methodologies

Worked closely and effectively with all levels of management to satisfy project/productivity requirements and demonstrates commitment to leadership/teamwork through positive contributions in streamlining systems and providing superior customer service

Have experience in business analysis, data profiling, data analysis, process defining, system design and process implementation in Insurance and Engineering functional area

Experience in Root Cause Analysis, GAP analysis and preparing Requirement Traceability Matrix

Extensively worked on SQL queries, Development, Reverse Engineering, Maintenance, Data warehousing, Business intelligence, Reporting and testing types of project areas across all the SDLC phases

Requirement gathering through interviews, Joint Application Development (JAD) sessions with clients and referring to existing documentation and procedures, defining strategic solutions to business problems in a multiple project environment

Experienced in developing functional and non-functional specifications, sequence diagrams, user interface designs, data flow diagrams and field level descriptions

Expertise in translating user requirements into System Specifications and mapping the process design, work flows for SDLC with documenting and managing business requirements

Experience in working as a Lead in onshore-offshore model and teams located across different geographical locations efficiently in both independent and team work environments

Enthusiasm to adopt and learn new tools, techniques and approaches

Excellent communicator with strong investigation, problem-solving and decision-making skills, combined with a pragmatic approach and sound business acumen

Senior Business Systems Analyst

Aetna Inc - Burlington, MA

May 2012 to Present

Aetna is a managed health care company, which sells consumer directed insurance plans and related services, such as medical, pharmaceutical, dental, behavior health, long-term care, disability plans, and employee benefits through employer-paid insurance benefits program and through Medicare. My project was to customize and implement a web-based application for healthcare payers to expedite and verify Patient Eligibility Information, Submission of Claims, Patient Statement Transfer and Claim Status Checking.

Lead planning, gathering and documentation of business requirements. This involves both interfacing with clients as well as the development team. Guide peers to best possible solution, utilizing existing processes where possible.

Consult with clients and Implementation team to identify current processes, clarify business objectives, and to establish technology requirements.

Participate in system/database design or enhancement and communicate results effectively. Collaborate with Technical Lead on data model.

Documentation will include: Technical Specs, Business Requirements, Process Flows, Change Requests, and Data Audit Reports.

Created data extraction rules for new reporting attributes, analyzed stored procedures in the absence of mapping documents and then successfully documented database mapping for existing reports.

Guide clients in business rule development. Implement business rules in database.

Test, maintain, and monitor data and list prep processes for building and maintaining the client database and Support client in UAT process

Perform high level quality assurance on: data processing, data loads, reports etc.

Assist Project Manager to develop initial project plan including scope, cost and schedule.

Work with client, Implementation team and all related IT departments to achieve solution-oriented results.

Provide support to the QA and Technical Writing resources to write test scripts and provide content review for necessary training and user manuals

Ensure stabilized customer database implementation, and take ownership for ongoing minor change requests.

Technologies: Rexx, DB2, SQL, COBOL, VBA, JCL

Business Analyst

Northwestern Mutual - Milwaukee, WI

April 2009 to April 2012

Schedule A is used to report annuity servicing fees, life insurance commissions paid to financial representative, and total premiums paid during the plan year. NM depends on the employer/plan administrator to request the information and create these reports manually. This project involved automating the reporting for Schedule A contracts that are not pension plans.

• Analyzed business requirements and defined the functional requirements as workflow, wireframes

and use cases

• Worked collaboratively with business stakeholders for eliciting the business requirements and

facilitated the requirements elaboration sessions

• Documented data requirements and conduct data analysis for integration and conversion effort

• Documented functional requirements, data mapping and data conversion rules, system

requirement and business rules into the requirements traceability matrix

• Lead the requirements walk through sessions with third party vendor for review and sign-off.

• Wrote reports and widgets specifications for various business area

• Performed testing to review test data extracts for integration with internal systems.

• Developed professional print to mail documents to communicate information to its policyholders

(E.g. bills, statements, notices, letters, policies etc).

• Designed interface programs and developed new Schedule A forms and reports including the

barcoding, automatic mailing and printing.

• Producing high-level and detailed technical and functional requirements and design

documentation.

• Conducted QA reviews with multiple business groups, management and end-users.

• Documents were created using CSF Designer and Legacy CSF by applying the business needs

into a professionally designed document while incorporating the company's Brand Management

standards.

• Review test plans and monitor the testing process to ensure that business results are adequately

tested.

Technologies: CSF Designer, DB2, SQL, Pl1, JCL, CICS

Senior Software Engineer

Northwestern Mutual - Bangalore, India

July 2006 to March 2009

The project involves development and production support of Policy Owner Services. The POS services insurance products for architects, engineers and design consultants. The application integrates with existing underwriting database support various policy transactions that includes Loans, Accumulations, Surrenders, Lapse, and Reinstatements.

• Architected, designed, documented, and built the automation of an existing manual process where

DB2 binds were done to Cobol-DB2 programs. It involved development of 10 new ISPF Panels

screens, 8 new batch jobs and 2 EOS reports

• Designed and developed front end for the batch process and system using REXX, ISPF

• Provided system support and client enhancements in PL1, CICS, DB2 and JCL

• Handled various projects that involve optimization/development of new systems, automating

internal processes and improving performance

• Automation of the backfill process saved more than 300 hours of work and had an annual cost

avoidance of 500 million

• Managed project scope, schedule and lead in the design, development and building of

environmental initiatives

• Used an Agile approach to managing the lifecycle

• Designed and tested SQL queries using QMF batch and Workstation

• Created ad-hoc reports using SAS

• Engaging to troubleshoot technical issues and co-ordination for a resolution

• Analyzing data to identify trends and taking pro-active steps to resolve issues

Technologies: SAS, ISPF, DB2, SQL, Pl1, JCL, CICS

Personal Projects

Code Environment cleanup automation (Status: Closed)

It’s about Building the tool which can perform automated cleanups of the obsolete code in all

test environments and LPARs. This tool was developed using Rexx and ISPF Panels.

It basically extracts the program names from a PDS and compares the code base timestamp of

the Database Request Module in test region against production. For all mismatched code it

flags the code and writes to report to free the corresponding bind from DB2 Catalog.

Achievements

1.Received Global Excellence Award for innovation and automation.

2.Selected as lead by management, based on my extensive knowledge on

building Tools and Automation.

Education Details

Bachelor of Technology (Computer Science & Engineering), Punjab Technical University

(June 2002-Aug 2006) GPA: 76

Contact this candidate