Sr. Data Consultant Resume
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