Saravanapriya Soundararajan
Phone : 612-***-****
Email : ac8wxu@r.postjobfree.com
Summary
* ***** ** ******** *********** experience with the strong background in Mainframe technologies and SQL
Extensive Experience in handling both Batch and Online Mainframe modules
Domain Expert in Healthcare and Retail industry
Performed data analysis and data profiling using SQL on DB2
Strong knowledge in DB2 and SQL queries
Developed various Integration tools using REXX
Knowledge in Agile development environment with scrum process
Possess extensive experience in analyzing the Business Requirement Documents, Functional specifications and Technical Specifications
Experienced in Test project management activities like testing strategy development, test plan creation, tracking test execution, defect management, test reports & metrics, level of effort estimation and capacity planning
Highly accurate in providing the Level of Effort (LOE) for upcoming projects which helped the upper management to plan the cost and effort more efficiently.
Specific Software Skills
Operating Systems
Mainframe, Windows
Programming Languages
COBOL, SQL,JCL,CICS
SDLC Methodology
Iterative, Agile
Databases
DB2
Testing Tools
HP-Quality Center 10
Mainframe Tools
TSO/ISPF,File-Aid, Expeditor, SUPERCE, SPUFI,Debug Tools, IBM File Manager, IBM File Manager DB2,SORT Utilities, Ice Tool, SEARCH Utilities, REXX
Educational Qualification
Master of Science (Information Technology) June 2001 – May 2006
Periyar University, Salem, Tamil Nadu, India
Certification
IBM Certification : DB2 UDB V9 Fundamentals
Cognizant certified in COBOL, DB2
Cognizant certified in Healthcare Management
Work Experience
Worked as Associate in Cognizant Technology Solutions between Feb,2007 and June,2011
Working as Billing Operations Specialist in Reqroute beginning Oct’2018
Company: Reqroute Inc
Client: Cognizant Technology Solutions /Centene Oct 2018 – Till Date
Position: Billing Operation Specialist
Centene has operated government-sponsored healthcare programs that save money and improve medical outcomes. We deliver results for our stakeholders, including state governments, members, healthcare providers, individuals and families, and other healthcare and commercial organizations. We know that each state, individual and family is unique and that collaboration is key to removing barriers to health and providing access to the best care.
Responsibilities:
Gather and interpret business requirements and monitor data trends to proactively identify issues
Execute data changes and update core systems as needed
Handle Billing projects and timelines effectively and communicate risks and issues to manager regularly.
Collaborate with internal team and external client to research and resolve any disputes or discrepancies in billed amounts and/or payment transactions
Reconcile member accounts as needed
Maintain low volume in assigned error queues within the billing system
Company: Cognizant Technology Solutions
Client: RadioShack Jun 2009 – Jun 2011
Position: Lead Developer
Perpetual data's like short and long are received from the different stores with the inventory details. The long and short perpetual files are processed when the received store and stock number are valid. The validations include checking for store number, open date, close date etc. The processed stores details are fed into the database on a daily basis. If the store received is having the close date greater than 10 years from the current date the store is updated as closed store and it will be removed from the database, so that it will not be available for processing in the future. It also involved in migrating perpetual and financial accounting for regular retail store inventories which are not fully integrated from mainframe to RETEK systems. Integration included any changes needed to fully track inventory movement and book all financial journal entries related to inventory movement and disposition. Major migration activities include Journal entries to be created on RMS for a variety of merchandise adjustments, Stock ledger to support the physical inventory recap process similarly, decommission the existing Mainframe flow in the stores
Responsibilities:
Team of 11 people, 3 at onshore and 8 at offshore handling multiple modules at same time involving architectural design implementations.
Actively involved in Interpretation of business requirements by clients for preparing the artifacts from Dev and QA perspective.
Verified the results both using SQL and also through GUI.
Perform data loads and routine updates on an ongoing basis
Work with business analyst groups to ascertain their database reporting needs.
Create system test plan which explain the approach to be followed for different types of testing.
Performed System Testing/Integration/Regression/UAT testing.
Generate traceability matrix automatically from QC and identify gaps.
Reviewed all deliverables done by developers before it has been given to QA for System Testing
Resolve issues and adhoc requests from onsite, Involve in ongoing maintenance issues, Analyze and develop fixes for the enhancements, preparation of Requirements document.
Work closely with Users to resolves issues related with application code or functionality during different UAT phases, in order to accommodate last minute changes or updates in the requirements
Company: Cognizant Technology Solutions
Client: United Health Group Feb 2007 – Jun 2009
Position: Developer
Uniprise FSG application development is one of the biggest application under the UHG vertical.
The project involves development and maintenance of their legacy applications. The project is mainly an enhancement and development project for the Uniprise Small Group health insurance.
FSG is a complex system, which takes care of all financial related applications. It includes 18 applications, out of which 4 to 5 are complex; most of the projects done are under those applications. Apart from that, enhancements and maintenance are done on various requests from other departments of Uniprise.
Responsibilities:
Interacting with clients to understand more about the system and leverage the projects that were driven by Cognizant Technology Solutions.
Involved in the requirement gathering meetings along with the business and development team.
Interacting with clients to understand more about the system and leverage the projects.
Involved in all the phases from analysis of the business requirements, preparing the Design documents, completion of the coding & unit testing, Testing, Cycle executions in system/User acceptance testing, pre-deployment activities, deployment and getting signed off on the project.
Created test plan which involve creating test cases using Mercury Test Director for different testing like Sanity, System, Regression and Intersystem.
Update the requirement status to manager and track the milestones for requirement completion
Developed traceability matrix to ensure all the requirements are covered for testing.
Executed the test cases from test lab and documenting Test procedures.
Defects are tracked until it goes to a closed state.
Participated in the daily status call to provide status to the lead.
Take part in the process related activities.
Create simple tools which to automate the job executions in various levels of testing, which reduced the manual work and help in saving time during testing using REX.
Create REX tools to load, Unload, back up DB2 tables of different applications