Sr SAS Developer & Analyst

SUMMARY

 Over * years of experience in System analysis, design and development of Data Warehouse and client server applications.

 Possess strong communication, leadership, team management, analytical and relationship management skills.

 Experience in Designing, Coding, Development, and Implementation of Business applications with Client/Server environment using DataStage, Informatica, Business Objects on UNIX and Windows platforms.

 Excellent experience as Data Architect and Design Analyst for designing and developing business data warehouses using DataStage.

 Technical expertise in all aspects of the SDLC involving Requirement Analysis, Design, Implementation, Testing, Enhancement, Troubleshooting and production support.

 Scheduling Data stage Jobs using Tivoli.

 Proficient in data profiling/cleansing using Quality Stage.

 Administered Datastage Server, like, creating projects, setting up their environment variables, and creating users per their respective privileges.

 Strong experience in Oracle PL/SQL Programming developing database Stored Procedures.

 Strong experience in Data Modeling with ERWIN and Visio

 Knowledge of creating reports using Business Objects.

 Proficient in Performance Tuning, Restartablity and Reusability at application, database, and system levels.

 Proficient in writing Shell scripts to run DataStage Jobs.

 Expertise in preparing transformation rules and running Mappings, Sessions/tasks, Workflows, Worklets, and Batch processes on Informatica server.

 Hands-on experience on Reporting, ORACLE and UNIX Shell scripting and proficient in developing Mapping Rules and Transformations on a complex, high-volume environment.

 Experience in working with different operating systems like Sun Solaris, UNIX and Windows NT/XP/2000.

 Working knowledge of database applications using Oracle 8i/9i/10g, DB2, SQL Server, Developer 2000 (Forms 4.5/5.0/6.0/6i), PL/SQL, Java.

Key Skills/Attributes

 Excellent communication and interpersonal skills.

 Emphasis on cooperation and teamwork.

 Adaptability to new challenges.

 Ability to work under high pressure and produce positive results.

 Sense of responsibility and commitment.

CERTIFICATIONS

Oracle Certified Professional

WebSphere DataStage Certified

Educational Qualification

Masters in Computer Applications

Technical Skills

ETL Tools : Information Server 8.0, Websphere DataStage

6.0/7.5.1a/7.5.2/8.0, Informatica 6.0

OLAP Tools : Business Objects XI R3

Data Modeling Tools : Erwin 4.0

Data Profiling/Cleansing : Quality Stage 8.0

Programming Languages : C, C++, Core Java, SQL, PL /SQL

ERP (SAP) : SAP Packs, BW, MDM, SAP 4.7E, ECC 6.0

Front End Tools (GUI) : SQL Developer, TOAD

Scripting Languages : Shell Scripting, HTML, JavaScript

Operating Systems : Sun Solaris, UNIX, WIN 95/98/XP/NT/2003

Databases : Oracle 8i/9i/10g, DB2 UDB, SQL Server 2005

CHRONOLOGY OF EXPERIENCE

Austin Energy, City of Austin, TX February 2008 to Till Date

Project Title: C&I (Commercial & Industrial) Customer Data mart

Description: C&I Data mart provides the ability for individual accounts to be accessed by customers. It provides key account customers an online portal interface with access to their historical billing data for electricity, water, wastewater, solid waste, drainage usage, miscellaneous adjustments and transportation user fees. The system provides the capability for identifying the customers, drill down to account level and identify all the details pertaining to usage, billing, payments, etc.

The purpose of this project is to gather the data related to key accounts from CIS (Customer Information System) database and load it into C&I data mart which would be used for generating reports. The data will go through few steps before it’s available for reporting. The source data will first be replicated into pre-staging tables. After the data is loaded into pre-staging, data is then moved to staging. While pre-staging is designed to reflect the source, staging is designed to ultimately ready the data for the data mart. Finally data will be moved from the staging database to the C&I Usage History Data mart.

Roles and Responsibilities:

 Involved in analyzing business requirements and design documents.

 Designed and developed jobs using Datastage/Qualitystage 8.0 for loading the data into Dimension and Fact Tables.

 Used Quality Stage to standardize names and addresses.

 Standardized customer dimension data and load into datamart.

 Implemented slowly changing dimensions using SCD stage and database sequences.

 Created PL/SQL procedures to implement complex business logic and calculations for loading the Fact Tables.

 Used Complex Queries for data extraction from Source and Staging.

 Responsible for preparing comprehensive test plans and thorough testing of the system keeping the business users involved in the UAT(User Acceptance Testing)

 Reviewed and approved code changes that are implemented as a part of releases or support activities.

 Design and developed jobs using Parallel Extender for splitting bulk data into subsets and dynamically distributing to all available nodes to achieve best Job performance.

 Designed DataStage sequences to specify Job execution order.

 Implemented Restartability and Reusability using Sequences and Shared Containers.

 Involved in Unit Testing and Integration Testing.

 Involved in Tuning and Performance Testing.

 Involved in Migrating the Datastage Project from Windows to AIX environment.

 Involved in creating BO universe for Customer Data mart.

Environment: Information Server 8.0, Data Stage 8.0, Quality Stage 8.0, DB2, Business Objects XI 3.1, Oracle 10g, Win 2003, SAP Packs and AIX.

General Motors September 2006 to January 2008

Project Title: Global Material Capacity Control (GMCC)

Description: The Global Material Capacity Control (GMCC) will provide a solution, which will integrate the Global Purchasing and Global Supplier applications. The strategic direction/approach is to develop and implement a standardized business process and supporting system to control suppliers (Shared or Unshared) part capacity across and within business units. The proposed solution will also support supply chain complexity driven by global program, enterprise flexibility, manufacturing foot print and supplier foot print optimization. The GMCC System has the following goals:

• Process to identify capacity shortfalls or issues, escalates and enables solution.

• Develop roles & responsibilities, data elements, interfaces & feedback loops.

• Develop global solution for collection of multi-lingual data.

Roles and Responsibilities:

 Detailed hands-on responsibility for business requirement gathering, analysis, testing and implementation of project releases and applications.

 Work with the team to collectively fulfill the system delivery responsibilities on project that have cross-functional inter-linkages.

 Responsible for gathering and documenting the functional requirements/change requests, and work with the business contact points for finalizations and signoffs.

 Manage tasks and effort for enhancement releases and other critical support activities.

 Involved in analyzing business requirements and design documents.

 Involved in interacting with business people on daily basis for better understanding and implementation.

 Design and developed jobs using Parallel Extender for splitting bulk data into subsets and dynamically distributing to all available nodes to achieve best Job performance.

 Designed and Developed Jobs to read/write/convert XML files utilizing XML Stages.

 Responsible for preparing comprehensive test plans and thorough testing of the system keeping the business users involved in the UAT.

 Review and approve code changes that are implemented as a part of releases or support activities.

 Design DataStage sequences to specify Job execution order.

 Developed Shell scripts for running the Jobs.

 Involved in Unit Testing and Integration Testing.

 Involved in Tuning and Performance Testing.

Environment: DataStage Parallel Extender 7.5.1a, Oracle 9i, SQL Server 2005, Win XP, SAP Packs, MDM, Sun Solaris 2.8 and Korn Shell Scripting.

General Motors Acceptance Corporation November 2005 to August 2006

Project Title: Incentive Audit & Reporting (IAR)

Description: The primary purpose of IAR Project is to build and maintain a system capable of supporting a common repository of incentive payment data and collaborative tools for audit analysis of incentive policy compliances within GM’s business processes. IAR will assist GMAS and NA Finance in monitoring the compliance of dealer operations with published incentive bulletins and rules. It will provide comprehensive incentive payment data and supporting external data in a single repository with a widely accessible user interface. It will have the ability to store audit results within the database allowing continued cooperation and future synergy between GM staffs. It comprises NA Finance Mail-Out Review, Deal Jacket Review, and GMAS Dealer Audit process. It automates the creation and delivery of dealer audit and notification letters with multiple delivery methods and revises existing utilization/payment reports.

Roles and Responsibilities:

 Design and developed jobs using Parallel Extender for splitting bulk data into subsets and dynamically distributing to all available nodes to achieve best Job performance.

 Developed Parallel Jobs and Shared Containers for implementing the Data extraction and Transformation logic.

 Involved directly with gathering business requirements, requirement documentation, solution definition and development, data architecture using ER and dimensional modeling (Erwin) for the staging, warehouse and associated data marts, system requirements documentation, hardware architecture and configuration.

 Developed sequences to specify Job execution order.

 Developed Shell scripts for executing the Jobs.

 Involved in Unit Testing and Integration Testing.

 Involved in creation of System Test Cases and System Testing of the Project.

 Involved in Tuning and Performance Testing.

 Migrated Datastage 6.0 version Jobs to 7.5 Version.

Environment: DataStage Parallel Extender 6.0/7.5, Micro Strategy 7i, Erwin 4.0, Oracle 9i, Win XP, Sun Solaris 2.8, Java

SunTrust banks Inc – Atlanta, GA September 2004 – October 2005

Project Title: Account Management System (AMS)

Description: SunTrust Banks, Inc., headquartered in Atlanta, Georgia, is one of the nation's largest commercial banking organizations. Its primary businesses include deposit, credit, trust and investment services. Through various subsidiaries, the company provides credit cards, mortgage banking, insurance, brokerage, and capital markets services. My foremost work involved the design and development of programs for the account management system at SunTrust. This system provides reports to the managers who use them in establishing, scrutinizing, appraising, developing and implementing strategies for new account acquisition, credit limit setting, account management and maintenance of account acquisition. Data is extracted from different sources like Oracle and SQL server and flat files.

Roles and Responsibilities:

 Developed the Dimensional modeling of the Data warehouse to design the business process, data representation, dimensions and fact tables using Erwin 4.0

 Collected the information about different Entities and their Attributes.

 Collected the information about the existing sources by reverse engineering them.

 Defined the relationships, cardinalities by identifying the connecting fields.

 Extracted transformed data and loaded into Oracle database according to the required provision using Ascential DataStage.

 Generated Surrogate Keys for the dimensions in the fact table for indexed and faster access of data.

 Created surrogate key tables to map the required dimensions.

 Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.

 Designed the mappings between sources external files and databases like Oracle, DB2 and XML files to Operational staging targets.

 Involved in creating more than 80 jobs using Datastage Designer.

 Used Datastage manager to manage the Metadata repository and import/export of jobs.

 Used PL/SQL processes to upload flat files using SQL*Loader.

 Database Extraction and filtering using Unix Shell Scripts.

 For better performance implemented parallel extender jobs using stages like Join, Merge, Sort and Lookup.

 Optimized job performance by carrying out Performance Tuning.

 Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.

 Created source table definitions in the Repository by studying the data sources.

 Created Log Tables containing data with discrepancies to analyze and re-process the data.

Environment: Ascential DataStage 6.0, Oracle 9i, DB2, XML Files, Erwin 4.0, PL/SQL, UNIX, Windows NT.

AllState Insurance – Northbrook, IL January 2004 - August 2004

Description: The Allstate Corporation is the nation’s largest publicly held personal lines insurer. A Fortune 50 company, with $149 billion in assets, Allstate sells 13 major lines of insurance, including auto, property, life and commercial. Allstate also offers retirement and investment products and banking services. Allstate has operations in 49 states and Canada. Allstate was founded in 1931 and became a publicly traded company in 1993. I was involved in implementing an enterprise wide data warehouse using the existing operational data for better decision-making and analysis.

Roles and Responsibilities:

 Involved in designing and development of data warehouse environment.

 Reverse Engineered the existing ODS for studying the metadata.

 Created the logical schema using ERWin 4.x.

 Created the physical model using ERWin 4.x and Forward Engineered the metadata to the data warehouse.

 Defined the Primary and Foreign keys for the Entities.

 Defined the relationships as the identifying and non-identifying relationships ensuring integrity constraints.

 Translation of Business processes into Datastage Jobs for building Data warehouse and marts.

 Worked with different Sources such as Oracle, SQL Server, DB2, Flat Files and COBOL files.

 Designed ETL jobs using DataStage 6.x for extracting data from heterogeneous source systems, transform and finally load into the Data warehouse.

 Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.

 Created source table definitions in the DataStage Repository by studying the data sources.

 Created re-usable components using shared containers for local use or shared use.

 Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.

 Tuned DataStage transformations and jobs to enhance their performance.

 Created PL/SQL procedures in Oracle for extracting as well as writing data.

 Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.

 Created jobs sequences.

 Created job schedules to automate the ETL process.

 Enhanced the job properties for performance tuning.

Environment: DataStage 6.x, Windows NT 4.0, UNIX, Oracle 8i, DB2, SQL Server 2000

Impact Software Solutions February 2002 – December 2003

Role: Jr. Oracle DBA

Responsibilities:

 Responsible for installing Oracle Database, setup Instance Creation, Database Space Management on Redhat Linux, Solaris Servers.

 Installed Patches and Upgrades for various bugs.

 Implemented traditional Hot and Cold Backups & Recovery.

 Distributed the data in different Tablespaces by table partitioning to get the high performance and I/O balancing.

 Performance tuning of Database, SQL queries.

 Performed Export/Import and full database scanning.

 Monitoring and resizing tablespace, relocating data files for better disk I/O.

 Maintained standby databases for production and staging environments.

 Created Roles and Users and Managed there privileges.

 Responsible for monitoring & resizing Oracle database objects (Procedures, Functions, Triggers, Tablespaces, Tables, and Indexes etc.)

 Responsible for managing Redo logs, Archive logs, Data files.

 Troubleshooting of the databases.

 Documented the problems and solution in the failures of production databases.

 Responsible for extensive use of SQL, PL/SQL, SQL*PLUS.

Environment: Oracle 8.x, SQL*PLUS, Performance Tuning, Import/Export, Sun Solaris, Linux, TOAD

Contact this candidate