SUMMARY:

• Over 9 years in the software industry with major involvement into: Analysis, Design, Development/Coding, Testing, Maintenance, Production Support and Documentation of business application systems with strong emphasis on: Mainframe Cobol programming and SAS Programming for Reporting, Data analysis, and Data manipulation.
• Actively contributed to various Financial Services, Retail and Healthcare applications
• Expertise in using variousSASreport generating procedures like PROC REPORT, PROC FORMAT, PROC GPLOT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE and PROC TRANSPOSE.
• Thorough knowledge in creating SAS datasets and developing SAS Procedures, Macros, and application for data updates, cleaning, and reporting.
• Thorough work knowledge of using ODBC to connectSASSystem with relational database management systems to retrieve data and createSASdatasets.
• Worked with SAS components including SAS/Base, SAS/Enterprise Guide, SAS/Macros
• Generated reports using PROC REPORT, AND PROC TABULATE for customized report writing.
• Developed, maintained and supported applications on mainframes using Cobol Db2 and JCL.
• Developed Programs, tested, debugged and documented solutions to system design problems for clients.
• Developed ad - hoc reports, which containsSASprocedures, macros for the data warehouse project.
• Hands on with troubleshooting SAS issues related to programming errors/issues or connectivity errors.
• Good verbal and written communication skills. Ability to work collaboratively across project teams having capability to work independently or in groups.
• Fine tuned the programs and Queries developed by previous programmers to increase the performance and enhance the efficiency in CPU usage, execution times, control data storage space, and followed efficient strategies.
• Involved in software Analysis, Design, Implementation and Production Support and Reporting systems.
• Excellent Analytical Capability and written/oral Communication as well as inter personal skills

TECHNICAL SKILLS:

Languages: SAS/Base, SAS/Enterprise Guide, VB 6.0, SQL, Unix Shell Scripting,Cobol

Databases: DB2,Oracle,MSAccess.

Software: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/ODS, SAS/Access, SAS/Enterprise Guide, DB2, VB 6.0, DB2 UTILITIES, Crystal Reports, CRMTT, MS ACCESS,Visio

Operating Systems: WINDOWS XP,Unix

Hardware: IBM S/390, IBM PC

Applications: Healthcare Insurance (Cigna Healthcare, CT), Finance (Merrill Lynch, NJ) and Retail (Target Corporation, MN).

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Analyst, Onsite co-ordinator/TechLead

Roles and Responsibilities

• Comprehensive skills in working with SAS/BASE, SAS EG, SAS/MACRO, SAS/ACCESS etc. in windows and UNIX environment.
• Extensive use of SAS Macros in the creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Analysis, programming and creation of reports on existing strategies using SAS and SQL. Design, implementation, tracking performance trend on new strategies in a test vs. control environment.
• Design, coding, testing, debugging, and documentation of multiple SAS programs.
• Expertise in Data Manipulations usingSASdata step, procedures such asSASFormat/Informat, Merge, Proc Append, Proc Datasets, Proc Sort, and Proc Transpose.
• Wrote SAS code to perform data cleaning and quality control. Extract data from DB2 Tables, SAS datasets, Excel.
• Prepared detailed summaries and reports for the health claims data by writing commands in SAS Data step and various statistical procedures such as PROC SQL, PROCSUMMARY and PROC REPORT.
• Generated graphs usingSAS/GRAPH.
• Store and distribute SAS Enterprise Guide results in different formats such as HTML, Tagsets, PDF, WORD based on the user group requirement with SAS/ODS.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Involved in writing UNIX shell scripts, which are used as a source to run SAS batch programs and generate log files, list files and reports in desired directories by passing parameters.
• Provide Application support to CIGNA IT
• Using variousSASreport generating procedures like PROC REPORT, PROC FORMAT, PROC GPLOT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE and PROC TRANSPOSE while generating

ad-hoc reports

• Troubleshooting SAS issues related to programming errors/issues or connectivity errors.
• Involved in unit testing and quality assurance of client applications.
• Preparing Test Data and Testing programs.
• Used DB2 Utilities to load, unload DB2 databases
• Documented the developed process using VISIO
• Fine tuned the programs and Queries developed by previous programmers to increase the performance and enhance the efficiency in CPU usage, execution times, control data storage space, and followed efficient strategies.
• Worked with CED and CDB and warehouses: IM (Information Management), LTD (Life & Disability Reporting Database)

Confidential

Senior Systems Analyst, Onsite co-ordinator/TechLead

Roles and Responsibilities

• Comprehensive skills in working with SAS/BASE, SAS EG, SAS/MACRO, SAS/ACCESS etc. in windows and UNIX environment.
• Extensive use of SAS Macros in the creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Analysis, programming and creation of reports on existing strategies using SAS and SQL. Design, implementation, tracking performance trend on new strategies in a test vs. control environment.
• Design, coding, testing, debugging, and documentation of multiple SAS programs.
• Expertise in Data Manipulations usingSASdata step, procedures such asSASFormat/Informat, Merge, Proc Append, Proc Datasets, Proc Sort, and Proc Transpose.
• Wrote SAS code to perform data cleaning and quality control. Extract data from DB2 Tables, SAS datasets, Excel.
• Prepared detailed summaries and reports for the health claims data by writing commands in SAS Data step and various statistical procedures such as PROC SQL, PROCSUMMARY and PROC REPORT.
• Generated graphs usingSAS/GRAPH.
• Store and distribute SAS Enterprise Guide results in different formats such as HTML, Tagsets, PDF, WORD based on the user group requirement with SAS/ODS.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Involved in writing UNIX shell scripts, which are used as a source to run SAS batch programs and generate log files, list files and reports in desired directories by passing parameters.
• Provide Application support to CIGNA IT
• Using variousSASreport generating procedures like PROC REPORT, PROC FORMAT, PROC GPLOT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE and PROC TRANSPOSE while generatingad-hoc reports
• Troubleshooting SAS issues related to programming errors/issues or connectivity errors.
• Involved in unit testing and quality assurance of client applications.
• Preparing Test Data and Testing programs.
• Used DB2 Utilities to load, unload DB2 databases
• Documented the developed process using VISIO
• Fine tuned the programs and Queries developed by previous programmers to increase the performance and enhance the efficiency in CPU usage, execution times, control data storage space, and followed efficient strategies.
• Worked with CED and CDB and warehouses: IM (Information Management), LTD (Life & Disability Reporting Database)

Confidential

Onsite co-ordinator and Programmer Analyst

Responsibilities:

• Single Point of Contact for Offshore and Clients.
• Co-ordination and active participation in Telecons between onsite and offshore team along with clients
• Work on Production support activities, Enhancement requests as required by business users.
• Work on Statement inquires, Statement corrections, fix production problems
• Assigning work items to offshore and reviewing the same for quality and functionality apart from coding and testing.
• Expertise in Data Manipulations usingSASdata step, procedures such asSASFormat/Informat, Merge, Proc Append, Proc Datasets, Proc Sort, and Proc Transpose.
• Used SAS procedures like PROC SQL to extract data from different relational database management systems.
• Worked with SAS components including SAS/Base, SAS/Enterprise Guide, SAS/Macros
• Provide post-implementation support.
• Ensure the Quality standards as per the CMM Level 5 standards

Confidential

Onsite co-ordinator and Programmer Analyst

Responsibilities:

• Single Point of Contact for Offshore and Clients.
• Co-ordination and active participation in Telecons between onsite and offshore team along with clients
• Work on Adhoc requests as required by business users.
• Requirement gathering and preparing Higl Level Design Document and Low level Design Document.
• Assigning work items to offshore and reviewing the same for quality and functionality apart from coding and testing.
• Expertise in Data Manipulations usingSASdata step, procedures such asSASFormat/Informat, Merge, Proc Append, Proc Datasets, Proc Sort, and Proc Transpose.
• Worked with SAS components including SAS/Base, SAS/Enterprise Guide, SAS/Macros
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems.
• Provide post-implementation support.
• Ensure the Quality standards as per the CMM Level 5 standards
• A vehicle by which data is captured at the 8-digit account and transaction level for all applicable drivers
• A web enabled reporting tool to view drivers by Branch, Account Type, Household/Account/Wealth Segments, Product Type, and BU/Channel.

Confidential

Programmer Analyst

Roles and Responsibilities:

• Single Point of Contact for Offshore and Clients.
• Gift Registry System (GRS) System Application Owner
• Recovery and Resolution of Problems and Client Issues reported by IBM, CSC, and PSR.
• Gained Business and Technical Expertise in GRS System and it’s Interfaces.
• To Support/Coordinate the offshore team for production support with PSR/Clients.
• Undertake the change request on assignment.
• Ensure the Quality standards as per the CMM Level 5 standards.
• Coordinate with the PL, Clients and the team.