Sr SAS Developer & Analyst

PARTHA S. ARUNAPURAM (PARTHA)

CONTACT : 609-***-**** / 609-***-**** Email : *********@*****.***

Objective: Seeking a Senior Consulting or Report Developer

Career Summary: 17 plus years of extensive experience in software project planning, system design, software development and management of information systems on mainframes and client-server platforms.

6+ years of experience in Business Objects Reporting

• Expertise in preparing report specifications to support the user requirements.

• Experienced in troubleshooting and analyzing production issues

• Experienced in coordinating and managing end users' expectations on projects

• Extensively worked/designed WebI Reports, Filters, Prompts, Drill Down, Ad-hoc Reports, and Scheduling reports.

• Academic experience in building Relational and Dimensional modeling (Star & Snowflake Modeling) in data marts / data warehouse

• Experience in Creating various Trending Reports (Weekly, Monthly and/or YTD)

• Data validation using TOAD 9.7.0.51

Have developed diverse commercial applications for manufacturing industries and is well-rounded software professional with the right balance of both technical and functional business application knowledge.

Over the years, reputation has been built for executing the projects in a timely and quality conscious manner. Played a vital role as a project leader and also a good team player. Possess excellent Marketing and Communication skills bundled with the leadership qualities.

Education

• Master Of Arts In Statistics, University of Pittsburgh, Pittsburgh, PA, USA

• Master of Science in Applied Statistics & Computer Science, Osmania University, Hyderabad, India

Technical Skills

BI Tools : Business Objects XI R3, R2, 6.5, 5.1, Business Objects WebI, DeskI and Info

View

Cognos 8.3, Impromptu, Powerplay Transformer, Powerplay

Reports, IWR, Upfront, Cognos Script, Cognos Query, Visualizer,

Crystal Enterprise Crystal Reports designer

Data Modelling : Architect, Framework Manager and Universe

Operating Systems : HP-UNIX, SCO-UNIX, AIX-UNIX, MS-Windows NT, AS/400

Language : MICROFOCUS COBOL, MICROSOFT COBOL, COBOL 400

ACU-COBOL, FORTRAN, C, CICS, JCL, VSAM, ISAM

HARDWARE : DEC-10, IBM mainframes, IBM PCs and SUN servers.

Database : ORACLE 8i/9i, DB2, Informix, MS-ACCESS, PL/SQL

GUI : Visual Basic 6.0, MS-Windows Related Utilities

OTHERS : Microfocus Work Bench / Animator, Clipper , FTP, Syncsort

Self-Learning : MS-PROJECT 2000

Trained in : SAP MM –MATERIAL MANAGEMENT: Master data, Purchasing,

Inventory Management, Valuation & account

assignment and Logistics Invoice Verification (LIV).

Knowledge : Xcelsius Dashboards

Applications worked on:

• Integrated Hiring Operations and Personnel ( IHOP ) – HR Access – Transportation Security Administration ( TSA )

• Financial Application, Payroll, Inventory, Order Entry and Processing

• Material Requirement Planning, Bill Of Material, Inventory, Order Processing

• Financial Accounting and Marketing Application

• Projects, Accounts Payables, General Ledger, Purchase Order, Labor, Travel

Professional Experience

Client: Large Defense Contractor, NJ BO Consultant Oct 2005 – To Date

Being a BI Consultant designed and created various reports and made changes to the Universe based on the requirementsand provided services in Production Support. Have developed reports for Integrated Hiring Operations and Personnel (IHOP) that uses various prompts, filters both at query level and report level, and made changes to the Universe based on the reports’ requirements using Business Objects

Responsibilities:

• Coordinate with project team and track progress of reports development.

• Validate the correctness of implemented reports in Production.

• Working as a report developer in Integrated Hiring Operations and Personnel (IHOP) - (HR Access – Transportation Security Administration)

• Gather, analyze and design reports based on Functional Requirement Document (FRD).

• Actively participated in Universe Building

• Extensively worked/designed WebI / DeskI Reports, Filters, Prompts, Drill Down, Ad-hoc Reports, and Scheduling reports.

• Based on FRDs, create queries and design reports in WEBI.

• Experience in Universe Development

Environment: Business Objects XI R3, R2, 6.5, 5.1, Business Objects WebI and Info View

Client : AOL LLC, VA BO Consultant Jun 2004 – Sep 2005

Business Objects Reporting Analyst

BO Project: PRI (Project Reporting Interface) is a tool for analyzing daily detail time sheet for all projects and employees activities across departments and Line of Business. The project helps users to analyze reports for the past and current project time sheets, resource allocation and overhead time. It provides a trend over a year on a particular project or an employee and at times helps upper management to make an informed decision on critical Capitalization project. This tool is also used for international tax purpose.

Responsibilities:

• Mastered WebI report development.

• Created complex reports involving master/detail and cross-tab, combined queries and sub-queries.

• Linked multiple data-providers, filters and dynamic filters.

• Created drill down reports up to 3 levels or more. This gives users the facility to drill up on Project, Department and Resource.

• Coordinated with DBA and Business objects designer group in solving various technical issues.

• Used prompts in WebI/DeskI to create more interactive reports for running different kind of promotions.

• Scheduled Business Objects reports using Business Intelligence.

• Generated various report templates for standardizing the reports throughout the organization.

• Promoted WebI reports.

• Performed unit testing, and helped conduct user acceptances testing (UAT) for universe and reports

Client: MDC Vacuum Products, Hayward, CA Cognos Consultant Nov 2003 - May 2004

MDC is a leading manufacturer of high quality vacuum products.

As a part of Data warehouse team designed and created various Metadata models and packages, generated reports out of them and migrated and tested reports in Cognos ReportNet.

Responsibilites:

• Created various packages from the model and published catalog as Data Source

• Created packages from the model and published them into the ReportNet Portal

• Installed Framework Manager

• Reports tested against database and the Impromptu reports

• User documentation was created for users to generate simple reports in Query Studio using the particular package

• Users were trained to use Query Studio

• Created numerous reports in Report Studio by using filters, prompts and calculated columns based on the users’ requirements

• Responsible for Optimization of Catalogs and formatting existing Impromptu Reports

• Created PowerPlay cubes from the IQD’s using Cognos Transformer.

• Created user classes and a security matrix to allow selective access of reports and cubes

• Updated packages by adding Query subjects, Query items from the model and published it to the Report Net Portal.

Environment : ReportNet 1.x (Framework Manager, Report Studio, Query Studio), Cognos 7.x, Oracle 9i and Windows 2003.

Client: Lucent Technologies, NJ BI Consultant Sep 2002 to Oct 2003

As a Consultant worked extensively on Impromptu and PowerPlay Transformer

Responsibilities

• Created complicated catalogs with inbuilt prompts and filters at folder level

• Used Governors setting to control access to user classes

• Developed and maintained various reports for the users

• Published various report to IWR

• Created MDL files using Multiple data source,

• Generated model file using various data sources like IQD files, architect models, flat files etc...

• Designed simple but powerful Dimensions, Levels, Measures, Calculated Measures to create effective PowerCubes to answer more than 50 question like what, where, when, how from users using a single cube.

• Created drill Through connections to the other tools from transformer

• Integrated Currency Tables into the PowerCubes to make it currency compatible.

• Updated model files for accommodating changes in the source data by doing Check/Modify Columns

• Designed and developed PPR's and PPX (Powerplay reports/ Portable reports),

• Used Custom Exceptions and drill thrus to achieve various results for the users

• Worked on Reporter/Explorer models using Various Display options (Charts)

• created Rank, Swap, Currency conversion options and Various other formatting options ( Cross tab layout, categories, Styles etc )

Environment: Impromptu 6.0, Powerplay, PowerPlay Transformer, Oracle 8i and Windows 2000.

Client: Verizon, Stamford, CT Software Consultant Jun 2000 to Jul 2002

As a team member of the development team created catalogs and reports using Cognos Impromptu. Also participated in Cognos Administration.

Responsibilities:

• Design and Development of a Catalog using Impromptu Administrator, which involved the establishment of various Joins between tables, Organization of Folders, setting up of User Classes and Access Privileges.

• Design and Development of different types of Impromptu Reports to present important performance trends like YTD and QTD. These reports were presented in numeric as well as graphical representations, using various formats like Cross tab, Grouped list, Bar Charts, Pie Charts, etc

• Publishing impromptu reports on the web, using impromptu web reports (IWR) and administering access privileges to the report sets.

• Deployment of Powerplay cubes and reports on to the Upfront Portal.

• Maintenance and enhancements to an Impromptu Catalog. This involved the addition of new tables and folders, Joins, and calculations.

• Analysis of user requirements, to decide whether the requirement warranted an impromptu report, or a Powerplay Cube

• Created Data source connection for the Impromptu catalog, and maintained Logical database

• Worked on Conditions/Filters/ Joins/ Folders/Calculated columns, Prompts

• Created List Reports, Cross tab Reports and complex Sub reports

• Generated Drill Thru reports and complex Queries

• Worked on Various Catalog types, Formatting tools, Grouping /Sorting, User Profiles ( Governor settings)

• Created schedules using Scheduler

• Generated complex Cascading Prompts to filter data

Environment: Impromptu 6.0, Powerplay, PowerPlay Transformer, Oracle 8i and Windows 2000.

Client : IDS, NJ Software Consultant Nov 1999 - Apr 2000

Responsibilities

Involved in developing Inventory System using Microfocus COBOL, Oracle under UNIX

Environment.

Developed front-end screens using Microfocus Cobol.

Used MF COBOL Workbench extensively for debugging the data conversion.

Performed migration of data from DB2 to Oracle

Worked extensively in Embedded PL/SQL for updating and retrieving data from more than

10 tables in ORACLE Database and for generating various reports.

Environment: Microfocus COBOL, DB2, ORACLE, PL/SQL, HP-UNIX, Unix Shell Scripts and Windows 2000

Client : FISERV, NY Software Consultant Apr 1996 - Oct 1999

Responsibilities

Involved in developing Payroll, HR Package using Microfocus COBOL, Oracle under AIX-Unix

environment using CYBORG package for the clients such as Republic National Bank, Citi

Bank, CIGNA.

Written many UNIX shell scripts (Korn) for executing and generating various reports.

Basically, the ISAM files were retrieved using CYBORG and Tables were created/updated in

ORACLE Database.

Generated reports using Embedded SQL.

Performed debugging of the data using MF COBOL Workbench.

Used SYNCSORT for sorting the data.

Extensively used Alternate keys in order to retrieve and process data.

The main responsibility was to interact with CYBORG, rectify the redundancy/errors and fix

the bugs in the CYBORG and use the package to create / update tables in the ORACLE

Database.

Environment: Microfocus COBOL, DB2, Oracle 7.x, SYNCSORT, HP-UNIX, Korn Shell Scripts, CYBORG, ISAM, MF COBOL Workbench.

Client : REVLON, NJ Software Consultant Nov 1995 to Mar 1996

Responsibilities

Involved in setting up the environment for Microfocus Cobol compiler for compiling the

programs to download the Inventory data from DB2 to ORACLE database.

Wrote UNIX Shell scripts (korn) to execute the programs that maintain the ORACLE

database.

Environment: Microfocus Cobol, Oracle 7.x, Unix Shell Scripts, DB2.

Client : ASHLAND CHEMICALS, NJ Software Consultant Jun 1993 - Nov 1995

ORDER ENTRY

Involved in development of application systems for maintaining inventory, order entry, order log inquiry system, container tracking systems and Bill Of Materials using ACU COBOL (Equivalent to MICROFOCUS COBOL) under AIX-UNIX. The application program interfaces with the database server through Embedded SQL and Stored Procedures. The above systems were developed giving the facility to the users, the window like pull-down choices and menus along with the List Box for the selection of a required item from the files.

Responsibilities

To analyze the user requirements for enhancements to inventory control and container

tracking system

To design and specify screens, reports and programs to be used for the system

To design and specify modifications required to the inventory control system to interface

with the container tracking system

To develop, test and implement the systems

Did application programming using Embedded SQL

Bill of Materials was developed using Visual Basic 4.0 with MS-ACCESS as backend Database

(6 months project)

Environment: Microfocus Cobol, Oracle 7.x, AIX Unix, Korn Shell Scripts, Visual Basic

Contact this candidate