SUMMARY

• Ability to work in self-directed environment and very good team player with excellent analytical and problem solving skills
• Worked closely with Business users in gathering the requirements for project documentation and generated reports. Involved in all stages of SDLC Software Development Life Cycle .
• Certified Base Advanced SAS Professional with 8 years of working experience in HealthCare, financial, insurance and Pharmaceutical industries.
• Have extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation.
• Ability to turn business requirements into Technical Design specifications and documents, SAS Programs, and SQL Queries related to quantitative, statistical and financial models. Capable of working with cross-functional teams to manage projects, determine prioritization, and create appropriate timelines.
• Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial and health care data and in the production of reports and tables.
• Primarily worked on Predictive modelling in financial and Medicare and Medicaid in HealthCare
• Experience in SAS/BASE,SAS/EG, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Developed new or modified existing SAS programs to load data from the source and create specific datasets.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting.
• Performed data analysis on the datasets using PROC PRINT, PROC SORT, PROC TRANSPOSE, PROC MEANS, PROC SUMMARY, PROC TABULATE , PROC UNIVARIATE AND PROC FREQ.
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
• Performed Data management like Merging, concatenating, interleaving of SAS datasets using MERGE,UNION and SET statements in DATA step and PROC SQL.
• Experience in using SAS to read, write, import and export to another data file formats including delimited files, spreadsheet, Microsoft excel and access tables.
• Worked extensively with SAS on UNIX, Windows and Mainframes, SAS Enterprise Guide, PC-SAS.
• Professional Experience with Import Various External Data Files into SAS Dataset, working with large datasets and business applications by Using SAS/ACCESS, SAS/INFILE, SAS/IMPORT, SAS/SQL.
• Extensively worked on various RDBMS like Oracle and SQL Server
• Extensive Experience in arranging and participating in meetings with Business Users, Managers and suggesting recommendations for improving system performance.
• Worked in Production support, Development, Technical project requests, Enhancement, implementation support, post-production batch monitoring and Client issues for all supported applications.
• Develop project plan, work-breakdown-structure, metrics, tasks lists, action items, Identify critical paths. Understand and define priorities and milestones.
• Proven skills in efficient processing of millions of records of data, optimizing SAS programs for better performance. ETL process design, Analyzing, Reporting and migrating Data from multiple platforms/databases using SAS,NDM and SFTP. Statistical distributions and calculations.
• Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
• Excellent working experience in tools such as INFOMAN, Maestro, Autosys, Resolve IT and ServiseNow.
• Involved in different server setups for new projects and accessing destination servers on various operating systems such as Unix, Windows and Mainframes.
• Have knowledge on HADOOP-HDFS, PIG, SQOOP, HIVE,HBASE and MapReduce.

• Windows 2007, MS-DOS, UNIX
• SAS Tools
• Base SAS, SAS/SQL, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide.
• Programming Languages
• SQL,PL-SQL C, JAVA,SQOOP,HIVE,MAPREDUCE,PIG
• Database
• Teradata, DB2, Oracle, MS Access, SQL server, HADOOP and Sybase.
• Application Software
• MS Office Word, Excel, Power Point, Access .
• Scheduling tools
• Maestro, Autosys
• Special Software
• Infoman, Resove IT, Autosys Work Load Center and ServiseNow
• Domains
• Banking, Insurance, Health Care and Pharmaceutical

Confidential

• Line of business of the client
• Healthcare
• About the project
• CareSource was founded on the principles of quality and service delivered with compassion and a thorough understanding of consumers. As a non-profit organization its mission-driven to provide quality care to the members. CareSource Health Plans Inc. provides managed care services exclusively for government sponsored health care programs, focusing on Medicare and Medicaid.
• The project works in different Line of Buseness such as Medicare, Medicaid and Health Insurance exchange programs HIX .
• Caresource Medicaid, including families with low incomes, children, pregnant women, and people who are aged, blind or have disabilities. Ohio Medicaid also includes Healthy Start and Healthy Families.
• Caresource Medicare Advantage Special Needs Plan SNP , who are full dualeligible with Medicaid and Medicare benefits.
• The primary objective for the Marketplace request project is to develop new sas jobs to support the extended business in Kentucky, Indiana and enhance the existing projects of Ohio.
• The automated projects are developed in base SAS and scheduled in a TIDAL scheduler and all the Adhoc and on demand jobs are developed using SAS Enterprise Guide.
• Need to develop reports to help business for taking better decisions to improve the business.
• Three environments involved in Software development life cycle Development, Certification and Production region.
• All automated projects are developed in Base SAS and Manual and adhoc projects are developed in SAS EG.

• Activities
• Developed ad-hoc reports using SQL Pass through, libname Statements and PROC SQL to interact with different RDBMS like Teradata and SQL server.
• Converted existing SAS code into high quality SAS code that is efficient fast , automated, maintainable, and follows industry best practices.
• The main responsibilities in this position are to enable process and trend analysis and provide recommendations for the implementation of new/revised operational and/or reporting processes in Ohio, Kentucky and Indiana.
• Involved in requirements gathering, Estimation of Efforts,Coding Unit testing, RFC Creation, Cert Implementation and Production move.
• Classification of reports based on Carsource Advantage Model of Care which involves Enrolment, member, claims, finance, marketing, pharmacy, provider, service operations, authorization regulatory and utilities.
• Preparation of batch jobs, parameter files, log files, SAS jobs such as control, preparation, formatting, PULL, ETL and Report generation.
• Developed new or modified SAS programs and used SQL Pass through facility and Libname methods to extract data from the Teradata and SQL Server DBs and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Made recommendations on new automation opportunities and ways to enhance existing automation tools.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
• Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT.
• Analyzed data using PROC FREQ, PROC MEANS, PROC Transpose and proc univariate to effectively and efficiently coordinate quality activities and improve performance metrics of organizational goals.
• Extensively used ODS HTML, ODS PDF, ODS RTF to prepare, compile, review and submit monthly and quarterly reports for quality committee meetings.
• Used SVN tool to commit the new codes for prod implementation.
• Creation of RFC's with Implementation document with tagging of new and backout code, test case document and attending cab review meetings to explain the impact of new implementation.
• Preparation of detailed design and code change document for future reference.
• Technical Platform
• Operating system: Windows 7
• Languages/Tools: SAS/Base 9.3, SAS/EG 5.1,
• Database: Oracle, SQL Server and Teradata
• Tools: Tidal scheduler, SVN, Windows batch

Confidential

Project Name

• Line of business of the client
• REL,CFNA,CBNA and CARDS
• About the project
• The primary objective for the Non-Cards SB group is to provide rapid technology Solutions when a traditional IT solution is either not required or cannot be achieved within the timeframe mandated by business needs. Our team supports all lines of business, including Cards Private Label / FDR only , CFNA/One Main, UCCB and REL. The technology framework we operate within consists of primarily SAS and SQL code executed in a Unix environment, though we do have a small mainframe application that is still supported by our group.
• Project requests are received via a CCR project request. Once captured in that system the requests are routed to the CCLM repository where they are tracked during the project life cycle. Project status is updated routinely on that site where upper management in the Collections COE can view them. Simultaneously projects will have corresponding Planview requests and support tickets opened for tracking hours spent and for managing all required project artifacts during its lifecycle.
• Our products are delivered to our customer base using several methods, including NDM and SFT data transfers, SharePoint repositories loaded via SMTP transfers email and externally to vendors using CitiSFT via SFTP. The vendors we interface with today include Soundbite, ORCC, Venture, Convergys and Sapient.
• The team includes 3 in Offshore and 5 at onsite.
• The technologies used for the Project are SAS, Oracle, SQL Server, Unix ,NDM scripting and Secure File Transfer SFT

• Activities
• Involved in requirements gathering Estimation of Efforts.
• Design Preparation.
• Interact with assigned business analysts and project managers to perform work outlined
• Assigning the projects to the team based on capacity.
• Follow-up with the team and making sure the work done on time.
• Successfully completed more than 20 development projects.
• Developed SAS code and SQL's for Data Extraction and Loading into flat files.
• Reviewing Unit Test cases to make sure testing is done properly.
• Conducting Final Inspection Audit.
• Working with large datasets and business applications
• Regular Status meetings with the clients and TCS Managers on the progress of tasks.
• Sharing of Knowledge with the team members.
• Tracking and updating the project status by using the CCLM repository.
• Technical Platform
• Operating system: Windows Server 2000/ UNIX
• Languages/Tools: SAS, UNIX, NDM, SFTP, SSH Tectia, Infoman, Maestro, Autosys and Resolve IT.
• Database: Oracle, SQL Server

Confidential

Project Name

• Line of business of the client
• REL,CFNA,CBNA and CARDS
• About the project
• The prime objective of Solutions Bridging production support team is to offer quick solutions unlike any normal development team. The team includes 4 in Offshore and 1 at onsite.
• The primary function of the Leveraged Solutions Bridging Production Support team is to identify any production issues and work those issues through to resolution. The issues should be resolved within a 24 hour period for processes running daily. Those processes running less frequently would generally need to be dealt with in 24 to 48 hours depending on the job in question.
• Notifications are received when jobs fail for any reason but can also be triggered by non-fatal issues that should be investigated. LSB has two means of receiving notifications for job failures/alerts. The first notification is usually via an automated email. The second means of notification is via the command center. Often both notifications are delivered but not always.
• UNIX script errors are generally trapped by Maestro. Maestro has a web tool that can be used to view any error messages trapped from an abended process.

Team Lead

• Activities
• Involved in presenting induction to the new joiners in the project
• Worked as primary point of contact for all the Production support jobs
• Resolved all the abends on time and achieved the customer confidence
• Developed SAS code and SQL's for Data Extraction and Loading into flat files.
• Regular Status meetings with the clients and TCS Managers on the progress of tasks.
• Automating the Job failures/alerts notification process by using the UNIX Scripting.
• Resolved the abends as soon as received a call from command center.
• Technical Platform
• Operating system: Windows Server 2000/ UNIX
• Languages/Tools: SAS, UNIX, NDM, SFTP, SSH Tectia, Infoman, Maestro, Autosys and Resolve IT.
• Database: Oracle, SQL Server

Confidential

Line of business of the client

• CITI CARDS
• About the project
• In CITI Cards Collections, DRI - Diversified Resolutions Incorporated is a default application when a loan becomes default for a user the account gets in to the collection/ default processing system. It is a system where the loan account gets the default processing service done. The project recreates the existing default system of CITI and merges it in to a single GUI application and integrates all the modules on a single sign on system.

Team Member

• Activities
• Requirement Analysis
• Create and review the design documents both HLD and LLD
• Development and Coding
• Test script Preparation
• Unit and System Testing
• Reviewing and Delivering
• Bug Fixing
• Conducting Final Inspection Audit
• Sharing of Knowledge with the team members
• Regular Status meetings with the clients and TCS Managers on the progress of tasks.
• Published the knowledge based documents into Knowmax.
• Published code snippets in Mighty for automation which avoids re-work.
• Prepared implementation Documents for Production implementation by Maestro Team.
• Technical Platform
• Operating system: Windows Server 2000/ UNIX
• Languages/Tools: SAS, UNIX, NDM, SFTP, SSH Tectia, Infoman, Maestro, Autosys and Resolve IT.
• Database: Oracle, SQL Server

Confidential

Team Member

• Line of business
• Credit Cards, Banking
• About the project
• The goal of the initiative is to produce a number of data extracts from the BACARDI database which will be fed to the IAF - COLLECTIONS platform by way of the JMS subsystem. The programming language used to produce these extracts will be SAS.
• In addition to the daily scheduled extracts and transfers, a one-time full extract for each feed will need to be produced in order to initialize the IAF - COLLECTIONS platform. The SAS extract programs should be written such that they can produce either this full extract, or the normal nightly delta feed based on a passed parameter

Responsibilities

• Analyzing the Business Requirements and System Specifications to understand the application.
• Involved in presenting induction to the new joiners in the project
• Developed SAS code and SQL's
• Automation of run book preparation for support related activities after implementation.
• Prepared implementation Documents.
• Involved in Creation and review of test Scenario and test Case based on requirement and design document
• Interacting with onsite coordinators and clients.
• IQA EQA activities in the project and preparing defects log
• Customizing the existed components to work for the newly created
• Creation of New Jobs Schedules for Info quest.
• Code fixing, testing, tracking all the documentation and code through IPMS tool mapping and following the standards defined in TCS-IQMS.
• Monitoring and fixing production jobs during batch run.
• Capturing of requirements for enhancement projects, coding,
• Unit testing and System testing of the modules.
• Languages
• SAS, UNIX, SQL SQL SERVER.
• Special Software
• IRIS, SCCS.
• Tools
• IPMS, IQMS, EXPEDITOR, CHANGEMAN, FILEAID, INFOMAN, ELIPS, TSO SAR, REVINE, ASA, TCA, ASSENT

Confidential

Team Member

• About the Project
• The Metered Sample Hub MSH is the corporate HUB for the Metered Sample data that is collected through the MSM application. The Metered Sample Hub archives household and persons characteristics for metered samples. MSH replicates data from MSM and A/P Collection Facility systems to its stage database throughout the day. It also serves as a history database for the A/P Collection Facility. The MSH close process, every day, transfers the replicated data to the elemental database in MSH HUB. MSH transforms some of the data to the legacy Descriptor Control Database DCDB format for Active Passive and Mark II metering technologies. The transformed data is stored in MSH Summary and loaded to the DCDB. The Elemental data is used to serve MSH clients such as MVD, IVA, Tracking, ELDB, FMDS, NDDS, National NPower , HHR, A/P Crediting. This project comprises of maintenance and production support activity.

• Understanding and Capturing of requirements.
• Involved in the preparation of high level/low level design documents.
• Involved in the Analysis, Development and testing phases of the project.
• Involved in Analyzing and providing the resolution for the bugs raised.
• Involved in the Unit testing and User Acceptance Testing.
• Involved in the Resolution of technical issues while testing.
• Production Support Dedicated .
• Worked on Control-M tool for keeping the system healthy and to make the jobs of various environments to run as per the schedule.
• Creating our own region for testing modelling the UAT regions.
• Adherence to IQMS Integrated Quality Management System by
• Following quality procedures like IQA Internal Quality Assurance .
• EQA External Quality Assurance and FI Final
• Inspection for all the deliverables.
• Adherence to IPMS by entering efforts and logging defects.
• Adherence to SPEED by achieving goals periodically.
• Languages
• SAS,UNIX,SQL-PL/SQL
• Database
• SYBASE
• Special Software/Tools
• PVCS for source code control , WSFTP, Control-M, Remedy, Remote desktop

Confidential

Position

Developer

• Prudential Output Systems is the doorway through which prudential communicates to its customers. DAP- Document Automation Platform is used to produce the policy package and customer communication letter. The System interfaces with the policy administration system AOS. Documents are composed from images using the DAP Tool. The tool will produce print files in either metacode or Print Control Language PCL . The former is used in production environment and the later in development environment.
• Responsibilities
• Analyzing the Business Requirements to understand the application.
• Prepared implementation Documents.
• IQA EQA activities in the project and preparing defects log
• Code fixing, testing, tracking all the documentation and code through IPMS tool mapping and following the standards defined in TCS-IQMS.
• Capturing of requirements for enhancement projects, coding,
• Unit testing and System testing of the modules.
• Languages
• SAS,UNIX,SQL SEVER,Mainframes Cobol.
• Special Software/Tools
• DAP Tool.