SUMMARY

• 13+ years of extensive experience as a software consultant in IT industry.
• Strong experience on Base SAS and SAS/Macros, SAS/ODS and SAS/SQL in Windows Environment.
• Optimized performance using Data Validation and Data cleansing using Statistical procedures like PROC FREQ, PROC MEANS.
• Generated reports using DATA NULL and PROC TABULATE for customized report writing.
• Expertise in producing RTF, PDF, HTML files using SAS ODS facility.
• Experience in extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files, Oracle database, Access database using PROC IMPORT techniques and SQL pass through facility.
• Good knowledge of using SAS Enterprise Guide.
• Excellent ability in problem solving, data analysis, complex reports generation.
• Experienced in Visual Basic 6.0/5.0/4.0, CRYSTAL REPORTS 4.5/7.0/8.5, CRYSTAL REPORTS XI, ASP, JAVASCRIPT, VBSCRIPT, PeopleSoft, Cognos, EPIC, Quick Test Professional, Appforge and back - end ORACLE and SQLSERVER, PSP (Pl/SQL Server Pages), on UNIX & Windows platform and also extensively used tools like SQL Loader, PL/SQL Developer and TOAD.
• Highly motivated with ability to deliver under pressure, collaborate with teams and accomplish goals.
• Exceptionally good communication skills with the strong problem solving and troubleshooting skills.
• Significant skills in requirement analysis, specification, design and development of application software in Client/Server and Internet/Intranet Environments.

TECHNICAL SKILLS

SOFTWARE: VISUAL BASIC 4.0/5.0/6.0, CRYSTAL REPORTS XI/8.5/4.5, Developer/2000/6i (ORACLE FORMS, ORACLE REPORTS), MS Office 95/98/2000, Cognos, SAS (SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/ODS), SAS Enterprise Guide

DATABASE: Oracle 7.x (SQL, PL/SQL, SQL*PLUS), Oracle 6i,SQL Server, PeopleSoft

DATA WAREHOUSE TOOLS: Stage Designer 5.2, Data Stage Manager, Data Stage Director, Data Stage Administrator

INTERNET: IIS, HTML, PSP, Java Script, VB Script, and ASP

TOOLS: Shell Scripting, SQL Loader, PL/SQL Developer and TOAD

PALMTOP TECHNOLOGY: AppForge 2.0

HARDWARE: IBM Compatibles, SUN and HP workstations

OPERATING SYSTEM: Windows, UNIX, DOS and Macintosh

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Consultant

Responsibilities:

• Imported raw files in excel format in SAS and subsequently created SAS datasets and performed data manipulations on the datasets.
• Cleaned existing data and converted them into useful SAS datasets, merged datasets and created reports based on Ad-hoc requirements.
• Extensive use of PROC SQL to create subsets of data for further analysis.
• Extensive use of DATA STEP, PROC MEANS, PROC SQL, MACROS, PROC FREQ, PROC TABULATE, PROC SUMMARY.
• Used SAS - output delivery system ODS to format reports in HTML, PDF, XLS reports.
• Documentation, presentation, data reports and model/results to the team/manager.
• Developed various reports using Crystal Reports to meet client needs.
• Adept in using ODBC Connect to acquire data from EPIC Database and PeopleSoft.
• Authored various SQL queries in PeopleSoft to generate reports to meet client specifications.
• Developed and maintain CAP (Corrective Action Plan) application using MS Access for users to keep track of the status and also report to higher management.
• Extensively used macros using VBA in excel.
• Created various test cases and defects in QTP to keep track of user issues and solution on how the issue is resolved.
• Participated in monthly releases to verify the defects were successfully implemented in PROD environment.
• Trained on Cognos (CBT - Computer Based Training)
• Provided training to end users on PeopleSoft reporting tool on how to run and distribute canned reports and also on how to run Queries.
• Extensively involved in Weekly and monthly meetings.
• Acted as a liaison between IT and users.

Technical skills: Crystal Reports, EPIC, PeopleSoft, Visual Basic, MS Office, QTP, SAS (Data Sets, Macros, Proc SQL, ODS), Cognos

Confidential

Programmer/Analyst

Responsibilities:

• Supported existing Import 2000, Inventory Migration, validations using PL/SQL and Oracle Forms as per the user requirements.
• Created various functions, procedures, and packages using PL/SQL.
• Created various SQL reports for the clients to verify the data.
• Created various shell scripts in UNIX for running different scripts.
• Used SQL Loader to load files.
• Used Utl File to create files in SQL scripts.

Technical skills:Oracle Forms, Oracle Reports, MS-Office, PL/SQL, SQL Loader, UNIX, Shell scripts.

Confidential

Programmer/Analyst

Responsibilities:

• Created and modified existing reports using Crystal Reports 8.5 for ERP application where users can run and report to various stakeholders and higher management.
• Migrated Reports from Crystal 8.5 to Crystal XI.
• Supported existing Tool Cutting application in Access and Visual Basic as per user requirements.

Technical skills: Visual Basic 6.0, MS-Access, MS-Word and Crystal Reports 8.0, Oracle 9i, Crystal XI

Confidential

Programmer/Analyst

Responsibilities:

• Developed and support various forms and Reports using Oracle for Financials, HR and Distribution modules based on user requirements.
• Designed, developed and maintained various applications using Visual basic for users to look up data. Used ODBC to connect to Oracle and SQL Server.
• Designed and Developed PDA Applications using AppForge for Camp Jeep and Ford100 Events which was used for the Ford centennial event to keep track of how many were attended
• Created various custom forms in Outlook for users as to send a customized email to stake holders or higher management.
• Written various shell scripts to extract data from file and also used SQL loader to load file. Used FTP to transfer file to client.
• Involved in supporting existing PSP applications for Intranet application.

Technical skills: MS-Outlook 98/00/02,Visual Basic 6.0, Oracle Forms, Oracle Reports, MS-Office, Crystal Reports 8.0, SQL Server, AppForge 2.0, PL/SQL Server Pages, SQL Loader, UNIX, TOAD