SUMMARY:

• Over 10 years of total experience in IT and over 6 years of professional experience in Extraction, Transformation and Loading (ETL) experience using Data Stage 7.5/8.1/8.5/9.1/11.3 Parallel Extender.
• Expert Level experience in Data Stage Client components - Data Stage Designer, Data Stage Manager, Data Stage Director and Data Stage Administrator
• Extensively worked on Server Edition, Enterprise Edition (Parallel Extender) and Development of Data Warehouse/Data Mart Applications.
• Extensively made use of all stages Aggregator, Sort, Merge, Join, Change Capture, Peek stages in Parallel Extender job.
• Used Data Stage Manager to import/export Data Stage projects and jobs to define table definition in repository.
• Used Data Stage Director to debug, validate, schedule, run and monitor Data Stage Jobs
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using Data Stage Director, UNIX scripts.
• Expertise in writing UNIX shell scripts and hands on experience with scheduling of shell scripts using AUTOSYS. Knowledge in UNIX shell and have written shell scripts for automation of Job Flow, Scheduling Jobs.
• Optimized Data Stage job utilization Parallelism, Partitioning and Pipelining features of Parallel Extender.
• Advance Knowledge, excellent concepts and experienced in decision support system (DSS), querying and analysis, Extraction Transformation Loading (ETL) Data Stage and Data Warehousing.
• Worked with DB-admin to create appropriate Indexes on tables for better performance of Data Stage queries.
• Strong Knowledge of Data Warehouse architecture in Designing Star Schema, Snow Flake Schema, FACT and Dimensional Tables. Physical and Logical modeling using Erwin.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data to various sources into data warehouse and Data Marts using Data Stage.
• Expertise in Data Migration and Upgrading.
• Expertise in using ERWIN for data modeling.
• Involved in Performance Fine Tuning of ETL programs. Tuned Data Stage and Stored Procedures Code.
• Excellent experience in Relational Database (RDBMS), Oracle 11g,10g,9i, Microsoft SQL Server, Teradata Load and MultiLoad, SQL, PL/SQL, TOAD, Teradata SQL Assistance.
• Involved in Logical and Physical Design, Backup, Restore, Data Integration and Data Transformation Service and Creating Database Objects (Tables, Index, Triggers, Views, and Store Procedures).
• Experience as Database Administrator:
• Responsible for the administration of existing databases (ORACLE & SQL) and the analysis, design, and creation of new databases.
• Data modeling, database optimization, understanding and implementation of schemas, and programming Structured Query Language.
• Proactively monitor systems for optimum performance and capacity constraints.
• Establish standards and best practices for SQL.
• Interact with and coach developers in SQL scripting.
• Designing and implementing, SQL databases for further applications.
• Excellent communication skills.

TECHNICAL SKILLS:

ETL: IBM Ascetical Data Stage 8.x/7.5x2/7.x EE & SE Administrator, Designer, Director, Manager, Parallel Extender, IBM Web Sphere Information Server 8.0.1, IBM Info Sphere Information Server 8.1/8.5/8.7/9.1/11.3

Data Modeling: Dimensional, Logical & Physical Data Modeling, Star Schema, Snow-Flake Schema, Erwin Data Modeler r.9.6

RDBMS: Oracle 11g/10g/9i, DB2 9.x/7.x/14.7, SQL Server 2008/2005/2000, Sybase 15.4, Sybase IQ, Teradata 14.10

Programming: SQL, PL/SQL, Shell Script, VB Script, Java, DB Visualizer Pro, Interactive SQL,Facet, Teradata SQL Assistance

Reporting: Crystal Reports, report

Operating System: Unix, Linux, Windows NT/XP/2000/2003 Server, Solaris

Scheduling Tools: Autosys, Crontab Utility, Control-M, Tivoli (TWS), ASG Zena

Microsoft SQL Server: Exam 70-461: Querying Microsoft SQL Server 2

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Working with Business Analyst to understand and get business requirements.
• Taking part on Business Analysis Development Phase and collecting Requirement for TMSIS project (ODS) and working with Data warehouse Architect on translating business requirements into Data Mart Design.
• Participating on Data Mart meetings of planning and creating Data Warehouse by using data marts.
• Translating Business requirements into Data Mart design coordinating with team members Creating Fact, Dimensional and Loading into Data Warehouse tables.
• Writing Low level design document and Unit test Document.
• Developed many Parallel Jobs using various Development:
• Extract the data from MMIS database, Transformthe data according to the business requirements and load them intoOracle ODS Database
• It was my responsibility developing Data Stage Jobs, extracting data from TMSIS system and Loading it into the Dimensional and Fact Tables.
• Extract data from ODS database and apply business requirements and load them to Claims data mart.
• Creating fix length or Delimited Outbound files.
• Implementing Performance tuning of Data stage jobs with proper data stage partitioning techniques.
• Creating dynamic parameter file from data stage and using to pass parameters on subsequent jobs
• Creating Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing.
• Wrote Oracle SQL complex queries extracting data using tuning queries and “Explain” statement for better performance.
• Tuning Oracle SQL Extraction queries.
• Using Erwin Tool for creating Data mart Dimensions and Fact tables.
• Used Data Stage Director for Executing, Monitoring, and Analyzing logs.
• Use Autosys as a scheduling tool to handle event based scheduling and time based scheduling.

Environment: IBM Info Sphere Data Stage 9.5/11.3, Oracle, Toad, Oracle SQL DeveloperWindows Server 2008, Autosys, IBM AIX 6.1, Windows Server 2008, Erwin Data Modeler r9.6

Confidential, Chicago, IL

Data Stage Developer

Responsibilities:

• Working with Business Analyst to understand and get business requirements.
• Implement business requirements into flow diagram, explaining step by step how these business requirements will be implemented into data stage.
• Updated the current flow diagram based on changes that occurred during development process and was involved into updating/adding new steps at flow diagram
• Created Unit Test Cases and Integration Test Plan documents.
• Developed many Parallel Jobs using various Development:
• Extract the data from Text files, Transformthe data according to the business requirements and load them intoTeradata data warehouse.
• Extract data from Teradata Enterprise data warehouse tables and apply business requirements and Outbound the file to xferout folder, ready to be FTP to Vendor
• Creating fix length or Delimited Outbound files.
• Implementing Performance tuning of Data stage jobs with proper data stage partitioning techniques.
• Migration data stage 8.5 jobs to data stage 9.1 version, working with Data Stage Administrator to move, renames or deletes projects and deploying jobs from development to Test stage or from Test environment to Pre-Prod environment and from Pre-Prod to production.
• Creating Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing.
• Wrote Teradata SQL complex queries extracting data using tuning queries and “Explain” statement for better performance.
• Used Data Stage Director for Executing, Monitoring, and Analyzing logs.
• Use Zena as a scheduling tool to handle event based scheduling and time based scheduling.
• Edit Shell Scripts to fit our data stage job like email script, audit script, move file to archive etc.
• Involved in the Production On call Support during Migration event and production deployment.

Environment: IBM InfoSphere DataStage 8.5, 9.1, Teradata SQL Assistance 14.10, IMB DB2 9.7, MQ Visual EditIBM AIX 6.1, WinScp, Microsoft-Visio, Serena Dimension, ASG Zena Scheduling Tool.

Confidential

Data Stage Developer

Responsibilities:

• Working with Business and System Analysts to understand and get business requirements.
• Creating Technical Specification Document and Presenting to Business and get tech spec from business, architect, and system analyst approved.
• Updated the current Design Specifications based on the changes that occurred during development process and was involved in writing new design specifications.
• Implementing Change Control Design into existing tech spec and writing the code to implement Change Control for existing interface in production.
• Created Unit Test Cases and Integration Test Plan documents.
• Developed many Parallel Jobs using various Development:
• Designed the Data Stage jobs to FTP Inbound files to inbox data stage, FTP Outbound file to share folder using FTP script.
• Extract the data from Text files, Transformthe data according to the business requirements and load them intoFacet tables.
• Extract data from Sybase tables and apply business requirements and Outbound the file to respective share folder.
• Loading Inbound files using Schema files and Runtime Column Propagation to attach schema file at fix length file in the source.
• Creating fix length Outbound files or Outbound XML files.
• Implementing Performance tuning of Data stage jobs with proper data stage partitioning techniques.
• Creating parallel data stage jobs, for Inbound, Outbound for Facet and River Valley Facet, working with Common Frame Work to implement additional parameter required for the project.
• Creating Type 1 and 2 Change data capture job, insert, and update and delete records to Facet table.
• Working with Data Stage Administrator to creating privileges to users or user group, move, rename or delete projects and manage or deploying jobs from development to Test stage or from Test environment to Stage environment and from Stage to production.
• Working with (CQA) Quality Assurance team, to test project at test environment using MSRunJob script.
• Creating Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing.
• Wrote Facet SQL complex queries extracting data using tuning queries and query plan for better performance.
• Used Data Stage Director for Executing, Monitoring, and Analyzing logs.
• Used Tivoli as a scheduling tool to handle event based scheduling and time based scheduling.
• Edit Shell Scripts to fit our data stage job like run script, audit script, add trailer to fix width file and backup database schema script.
• Writing Unix script to load bulk data using BCP command “”isql” and LOAD TABLE command “dbisql”
• Involved in the Production On call Support during Migration event and production deployment.

Environment: IBM InfoSphere DataStage 8.5, 8.7, Datastage Import Export Manager, DBVisualiser Pro

Confidential, Chicago, IL

Data Stage Developer

Responsibilities:

• Working with Business and Functional Analysts to understand and get business requirements
• Preparing and Working on Mapping documents, Functional design and Detailed level designs
• Created Unit Test and Integration Test Plan documents
• Creating DataStage Environmental Variables at the Project Level.
• Developed many Parallel Jobs using various Development / Processing Stages (Transformer, Aggregator, Change Capture, Change Apply, Join, Lookup, Modify, Filter, Sort and Merge, Funnel, Remove Duplicate Stage) Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage).
• Designed the Data Stage jobs toExtract the data from Text files, Transformthe data according to the business requirements and load them intoDB2 tables.
• Creating fix width files to be delivered to Basel Process.
• Implementing Performance tuning of Data stage jobs with proper data stage partitioning techniques and Node configuration
• Shared container and local container were used on complex data stage job.
• Creating parallel data stage jobs, for Credit cards on Monthly bases, daily bases and Cycle bases.
• Creating Type 1 and 2 Change data capture job, load insert and update records to the DB2 table.
• Working with Data Stage Administrator to creating privileges to users or user group, move rename or delete projects and manage or publish jobs from development to production status or from development to UAT environment.
• Involved extensively on Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing.
• Wrote DB2 SQL complex queries extracting data using tuning queries for better performance.
• Used Data Stage Director for Executing, Monitoring, Analyzing logs and scheduling the jobs.
• Used Data Stage Director to run the jobs and investigate the Director logs for warnings if any during the job run.
• Used Control-M as a scheduling tool to handle event based scheduling and time based scheduling.
• Edit Shell Scripts to fit our data stage job like run script, audit script, add trailer to fix width file and backup database schema script.
• Involved in the Production On call Support during Migration event.

Environment: IBM InfoSphere DataStage 8.1, 8.5, DB2, IBM AIX 6.1, Sun Solaris 10, Mainframe, WinScpMicrosoft-Visio, Control-M.

Confidential - Pharmacy, Chicago, IL

Data Stage Developer

Responsibilities:

• Extensively worked with Business and Functional Analysts to get the appropriate Requirements
• Preparing Functional design, Detailed level designs and Mapping documents
• Writing Unit and Integration Test Plan documents
• Developing and maintaining Data Stage Parallel Jobs for 340B Complete Program.
• Coded a set of Data Stage jobs to extract, transform and load data from various sources (Oracle tables with standard and non standard Meta data, flat files) to create an allowed value lookup table.
• Performed code reviews of the developed jobs and fixed the identified defects in the jobs.
• Developed Parallel Jobs using various Development / Processing Stages (Transformer, Aggregator, Change Capture, Change Apply, Join, Lookup, Modify, Filter, Sort and Merge, Funnel, Remove Duplicate Stage) Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage).
• Created Master sequencers using User variable Activity, Job Activity, Execute Command Stage, Start Loop Activity, End Loop Activity, Nested Condition, Exception Handler Stages
• Created re-usable shared container and local container.
• Implemented the Type 1 and 2 Slowly Changing Dimension.
• Involved in developing Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing.
• Was involved and implemented in Performance tuning of Data stage jobs with proper data stage partitioning techniques and Node configuration
• Added Data Stage Environmental Variables at the Project Level
• Used the Data Stage Administrator to assign privileges to users or user group, move rename or delete projects and manage or publish jobs from development to production status.
• Used Data Stage Director for Executing, Monitoring, Analyzing logs and scheduling the jobs.
• Wrote Shell Scripts to handle pre and post job runs.
• Wrote SQL complex queries for implementing business rules and transformations.

Environment: IBM InfoSphere DataStage 8.1, Oracle 10g, Oracle SQL Developer, Toad, PL/SQL, IBM AIX 6.1Sun Solaris 10, Microsoft-Visio, Java J2EE, CVS, WinScp.

Confidential

Data Stage Developer

Responsibilities:

• Participating on Business Analysis Development Phase and Gathering Requirements. Working with Developer Department team for translating business requirements into Data Mart Design.
• Working with Database team for creating logical and physical Data Modeling process using Erwin and guide business group and users session.
• Taking part in planning and management of all Data Warehouse migration process.
• Involved in creating strategy for Star Schemas with Fact and Dimension Tables.
• Translating Business requirements into Data Mart design coordinating with team members Creating Fact, Dimensional and Aggregate Tables and Loading Data Warehouse tables.
• Responsible for getting the Data Dictionary, Designing and modifying the Data Stage jobs using Data Stage Designer, Created mappings based on Data Dictionary.
• Worked on Data migration from SQL Server 2005 and was responsible developing Data Stage Jobs, creating mapping for data transformation, extracting data from Oracle and Loading it into the Dimensional tables.
• Creating backups by using Data Stage Manager Exporting data stage components and packaging of projects.
• Implemented the Surrogate Key by using Key Management functionality for newly inserted rows in Data Warehouse
• Developed Shell Scripts for taking backup and recovery of database. Performed physical and logical backup.
• Used Autosys to schedule the Data stage ETL batch jobs on daily, weekly and monthly basis.
• Used Data Stage manager to import, create and edit the metadata.
• Used the Data Stage Administrator to assign privileges to users or users groups, move, rename or delete projects and manager or publish jobs from development to production status.
• Validated all applications and ran the jobs using Data Stage Director.
• Performed tuning of the repository and jobs for optimum performance.
• Prepared Test Plan and performed Unit Testing, System, Integration, Volume Testing.
• Extensively involved in writing Stored Procedures and calling the same through Data Stage Stored Procedure Transformation.
• Developed Server side functionality by using PL/SQL and UNIX shell programming.
• Constructed SQL Scripts to validate the data after loading process.
• Data Quality and validation using Quality Stage, Metadata capture and analysis using MetaStage.

Environment: DataStage EE 7.5/8.1ERwin 4.1.5,SQLServer 2005,Oracle10g/9i, PL/SQL,AutoSys, TOAD, UNIX, Shell Scripting

Confidential

DB Administrator & Programmer

Responsibilities:

• Installation of new versions of DBMS software, application software, and other software related to DBMS administration and test this new software before it is moved into a production environment.
• Take care of databases system replication, backup scheme and disaster recovery
• Configuration of hardware and software so that it functions optimally with the DBMS.
• DBA Security administration— Monitoring and administering DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.
• Data analysis— frequently analyzes the data stored in the database and to make recommendations relating to performance and efficiency of that data storage.
• Data modeling and optimization— optimize the system layouts to take the most advantage of the I/O subsystem.
• Responsible for the administration of existing databases (ORACLE & SQL) and the analysis, design, and creation of new databases.
• Data modeling, database optimization, understanding and implementation of schemas, and programming Structured Query Language.
• Establish standards and best practices for SQL.
• Interact with and coach developers in SQL scripting.
• Programming or editing current application with the programming team for the scope of implementing or upgrading application for the Albanian State Police
• Taking care of internal webpage and services included within.
• Consulting and taking decisions for contracts regarding with providers for services, acquaintance of licenses and other technological equipments.

Confidential

Responsibilities:

• Programming for Albtek clients, web and desktop applications.
• Designing and implementing Networks for Albtek clients.
• Designing and implementing, SQL databases for further applications.
• Building the company website and maintaining it for further.