Sr SAS Developer & Analyst

JENSY THAKKAR

************@*****.***

Ph: 630-***-****

OBJECTIVES

• Obtaining a quality environment where my knowledge and experience can be shared and enriched.

• Challenging and contributing career opportunity in the area of Application programming and Database Applications.

• Willing to work in any phase of Software Development Life

Cycle, including Design, Programming, Testing

PROFESSIONAL PROFILE

Five years of experience in IT Industry involved in Analysis, Design, Development, Integration, Maintenance, Design Document, Reports and Testing.

Extensive experience supporting complex database/data warehouse systems and/or decision support systems

Experienced with ETL tools and applications such as Abinitio and Datastage

Expert in solving complex queries by tuning queries in oracle

Excellent communication skills and ability to work independently and be highly motivated.

Enthusiastic, Honest and Hardworking

Accomplished for sustained effort and hard work in successful completion of oracle upgrade project.

PROGRAMMING PROFICIENCIES

Operating System: Windows 98/NT/2000/2000 Server/XP, UNIX, Linux.

Databases: MS SQL Server, MS Access, Oracle 9.i/10g,

Application Tools: Abinitio, Crystal Reports, Datastage, Business Objects, Cognos

Presentations:

Papers: Hyper threading Technology

- In convergence 2003 at U.V. College of Engineering.

Stegnography

- In convergence 2004 at U.V. College of Engineering.

Certifications:

DataStage: IBM Learning Services

Abinitio : IBM Learning Services (hosted by Walgreens Corporation)

Education: B.S. Computer Engineering - U.V.P.C.E. College, Gujarat India

July 2001 to 2004 July.

GPA: 3.84 / 4.

PROFESSIONAL EXPERIENCE

Client: Walgreens Corporation, Deerfield, IL Nov 2006 – Present

Programmer/Analyst A:

• Design, Implement and test ETL code using Ab Initio, data stage.

• Develop, maintain and support driver scripts in Unix for the ETL processes.

• Work closely with data architects and business analysts to understand system and business requirements

• Analyze business requirements as well as develop and execute test cases for ETL.

• Develop alternatives and recommendations for proposed solutions for complex business problems to enhance our BI/DW solution using both front end and backend tools like Business Objects and Abinitio.

• Provide maintenance and 2nd-tier production support for a large data warehouse and business intelligence environment

• Develop, troubleshoot and fine tune various ETL jobs.

• Wrote complex SQL s validate target data based on the business requirements

• Communicate with users via face-to-face meetings, conference calls and written correspondence on a periodic basis in order to clarify issues and obtain user acceptance.

• Lead and coordinate ETL design/development effort across on-shore and off-shore teams.

• Created various high level and low level design documents for any data extract request or project request with appropriate test cases and fallback plan.

• Worked on overall project development life cycle, and participates in all phases of the project.

• Utilize SQL and Oracle PL/SQL to effectively identify and report defects, create testing data sets and assure data quality.

• Worked closely with DBA’s and Systems Engineer on Oracle database upgrade from 8i to 10g environment testing both backend and front end environment for huge data warehouse.

Environment: Abinitio 1.14, Data stage, UNIX, Oracle 8i/10g, Business Objects, Toad.

Client: CTS technology, Chicago, IL, Aug 2005- Nov 2006

Ab Initio Developer

• Designed high performance ETL and Data Warehousing solutions.

• Developed transformation logic and business rules for ETL purpose

• Used Abinitio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases

• Developed test cases and planned to complete the unit testing.

• Developed shell scripts for many purposes and automation of environment setup and wrapper

• Performed data validation before moving the data into staging areas using Abinitio built in functions

Environment: Abinitio 1.13, UNIX, Oracle 8

Client: Covenant Services Worldwide, Bolingbrook, IL Nov 2004-July 2005

Report Analyst

• Creates reports for finance/operations using reporting tool from various software vendors such as Cybershift/Ceridian

• Meets with users to define and understand reporting needs. Develops functional requirements and technical specifications

• Maintains data integrity by running queries and analyzing data.

• Supports weekly, monthly, quarterly and annual reporting needs for division

• Reviews, tests and implements software upgrades and changes to enhance existing database applications consistent with division standards.

• Troubleshoots report issues.

• Performs other related duties as required

Environment: Ceridian Reporting tool, Inetsoft Reporting tool, Valiant payroll system, crystal reporting tool, sql server.

Client: TCIL (Telecommunication consultant India ltd), India Apr 2003- Jan 2004

Support Network analyst/ Programmer

• Thoroughly and detail study of GSWAN

• To understand IP scheme used in the network

• Efficient management of IPs in network and allocation of new IPs in judiciously .

• Giving access rights to different users.

• To practically work on wireless network equipments.

Environment: ASP.NET, ADO.Net, MS SQL Server 2000, IIS 5.0, Flash MX 2004, HTML

Contact this candidate