SUMMARY

• Over 8 years of experience in software development, database management, system management and administration, Data - modeling, implementing entire SDLC, system Analysis, Design and development, strong data Warehousing, Data Integration & Migration and developing business applications using IBM Info sphere Information Server (8.1/8.0.1), Ascential Data Stage (7.5.2/6.0/5. x/4.x) Manager, Designer, Director and Administrator) extensive experience with both Data Stage Parallel Extender (EE) and Server Editions, Oracle, PL/SQL, DB2, SQL
• Involved in full life cycle of software development including system analysis, design, development, testing, implementation and training.
• Expert level knowledge of DataStage development and administration and comfortable with leading initiatives and mentoring team members. User creation, removing locks, database connectivity, product licensing, logs management, server monitoring, reporting, backup and recovery of Projects and security compliance as per company policies
• Extensive experience resolving technical issues using Data Stage tool.
• Specializes in Data Analysis, Data Mapping, Data Conversion, Data Integration, Business Analysis, Data Quality Analysis, Functional Design, Technical Design and different aspects of data/information management.
• Excellent Knowledge in DW concepts and Architecture using fact tables, dimension tables, star and snow-flake schema modeling (Kimball and Inmon approaches).
• Works directly with clients and management to resolve conflicts and issues that may arise. Has worked extensively with SQL, including performing Query Optimizations.
• Handles Complex Systems, Project Integration, and Technical Designs. Possesses design, plan, and team coordination expertise.
• Document processes necessary to maintain and expand the ETL processes to support future needs.
• Strong understanding of business processes & interface with IT. Multilingual, highly organized, detail-oriented professional with strong technical skills.
• Excellent experience in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancements.
• Write System test cases and perform system and integration testing.
• Installation and Executed data mart techniques that include using an export data source to populate from an existing cube to another data mart.
• Extensive experience in reading and writing data in heterogeneous environment including Oracle, DB2, Teradata, SQL Server, Sybase, CSV Files, XML Files, DOS and UNIX Sequential Files.
• Excellent experience working with SQL Server, Oracle, PL/SQL and writing stored procedures.
• Create ETL processes to ensure data integrity (error handling) and document appropriate procedures.
• Expertise in Implementation of SQL Queries, PL/SQL Packages, Stored Procedures, Functions and Triggers using Oracle SQL.
• Extensive experience interacting with Cross-Functional, global teams and communicating project information to multiple levels in an organization.
• Skilled in planning, coordination, and execution of system applications and engineering projects.
• Excellent track record as team player with effective communication skills.
• Maintaining accuracy and interest in detailed work, ability to work under pressure, have high degree of mature judgment and discretion in the handling of confidential matters. Record of successfully completing projects on time and within budget, while focusing on complete customer satisfaction.

TECHNICAL SKILLS

ETL: DataStage (IIS8) 8.1 (including Information Analyzer, Qualitystage, Metadata RepositoryMetadata Workbench, Business Glossary and other Infosphere products).

O/S: Windows NT, UNIX (SCO, HPUX, Sun, AIX)

RDBMS: Oracle 11.g, Teradata 2.01, DB2 8.1, SQL Server 2003

OTHER: UNIX shell script(KSH/CSH), SAP BW, SyncSort 2.x, Humming Bird Exceed & BI QueryAutosys, Control M conversion, BTEQ, Queryman, shell scripts (KSH/CSH), Oracle Enterprise Manager, Developer 2000, SqlPlus, PL SQL, C, Erwin, Toad, AQT, PVCSDataStage Version Control, MVS JCL COBOL, Selenium, SCRUM, MS Office OLAP Business Objects, Microstrategy, Cognos OLTPCICS

PROFESSIONAL EXPERIENCE

Confidential - New York City

ETL Datastage Developer

Responsibilities:

• Work closely with users, business analysts and team members to understand business requirements and then design technical solutions using Ralph Kimball’s Dimension model
• Used Web Sphere DataStage to Design, Execute, Manage and Deploy DataStage jobs.
• Used Designer client for basic, advanced search and impact analysis and to import and export components for moving jobs between different environments.
• Worked extensively with different stages in Datastage like Join, Funnel, Transformer, Surrogate Key Generator, SCD, Range and Case Lookup.
• Used Information Analyzer Profile Stage to configure different data sources and create projects and attach imported metadata to projects in IBM IS Console.
• Performed Column Analysis for business analyst's review before designing jobs in console.
• Created Data Connections and Parameter Sets or Environment Variablesto use them for the project across dev, test and production servers.
• Used Director Client to Validate, Run and Schedule the jobs that are run by WebSphere DataStage server.
• Created, optimized, reviewed, and Executed Teradata SQL test queries to validate transformation rules used in target mappings/source views, and to verify data in target tables.
• Involved in Migration of jobs from Datastage 7.5x2 to Datastage 8.1 version.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Used IBM FastTrack to create source-to-target mappings and automatically generate jobs.
• Used Autosys to schedule jobs and e-mailed the status of jobs to operations team daily.
• Create Unix shell scripts in ksh for calling dsjobs/sequences, crons jobs for scheduling, and somes other ksh scripts on an adhoc basis.
• Create Best Practices document and enforce ETL standards, ensure that the ETL requirements are adequately understood and documented.
• Perform benchmarking, evaluation of new functionality of IIS8(Qualitystage and Information analyzer) and mentor team members.

Environment: Information Server (DataStage 8.5)Parallel Extender/Qualitystage/Information Analyzer, UNIX Sun Solaris OS 5.8, Oracle 11, PL/SQL, SAP BW, SQL Server 2003, DB2, CSV and XML Files, Business Objects, Autosys 4.0.

Confidential, Brooklyn, NY

ETL Datastage Developer

Responsibilities:

• Extensively involved in different Team review meetings and conferences with remote team.
• Worked on the logical and physical design of the Data warehouse. Identified sources/targets and analyzed source data for dimensional modeling.
• Implemented dimensional model (logical and physical) in the existing architecture using Erwin.
• Extensively involved in designing and developing of Star Join Schema.
• Developed various Server and Parallel jobs using Oracle, ODBC, FTP, Pivot, Hashed file, Aggregator, STP, Filter, Funnel, Copy, Change Capture, Merge, Look up, Join, Sort Merge, Lookup stages.
• Extensively worked on various QualityStage stages like Standardize, Match, Investigate and Survive stages to validate the data according the business requirements.
• Performed Unit Testing and tuned for better performance with updates on data warehouse tables using DataStage Director for jobs Monitoring and Troubles Shooting.
• Created shared containers to use in multiple jobs.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.
• Developed PL/SQL Procedures, Functions, Packages, Triggers, Normal and Materialized Views.
• Worked with Reporting team for extensive reporting using Data mart
• Defect Tracking, defect reporting, analyzing results and documentation.
• Performed functional, load, Integration, testing, User Acceptance testing, End to End testing.

Environment: DataStage 7.5/8.5 Parallel Extender, AIX 5.3 environment, Oracle 9.i, DB2 8.1, SQL Server Erwin, Business Objects, Autosys 4.0

Confidential - New York City

Datawarehouse ETL Developer/Admin

Responsibilities:

• Studied data sources and targets to setup node pool / configuration file.
• Identified bottlenecks in existing system and tuned transformations to enhance performance.
• Developed QualityStage jobs (CASS and Standardize) to standardize and clean name, address, phone number, dob and SSN fields.
• Created Unix scripts to replace batch files.
• Created Job Controls to call multiple instances of data extraction jobs.
• Handle source files (SFA- Sales Force Automation ) from IMS/NDC pharma data and assesses the quality of the data in the source and target data stores and then design the logical data model and ETL for the target data stores including the data warehouse and data marts
• Collaborate with the solution architect and business intelligence architect to tailor the data architecture as needed for specific requests
• Work closely with the business managers at Confidential to tailor the models to meet specific data migration and cleansing needs and gather user requirements and create Business Requirement Reports and Technical Design documents.

Environment: DataStage 7.5A Parallel Extender, Sequential, CSV and XML Files, Unix.

Confidential, Boston, MA

DataStage Developer

Responsibilities:

• Work closely with users, business analysts and team members to understand business requirements and then design technical solutions using Ralph Kimball’s Dimension model
• Lead the team in developing logical and physical datamodels as well as DataStage jobs, UNIX shell scripts, SyncSort, BTEQ, Fastexport, and Autosys Integration
• Involved in the full system life cycle of a Datawarehouse project and responsible for designing, coding, testing, implementing and supporting the ETL processes for data warehouse solutions and related data marts
• Participate in data architecture design, performance monitoring, product evaluation, and buy vs. build recommendations
• Setting Environment Variables.
• Identified bottlenecks in existing system and tuned transformations to enhance performance.
• Worked with Reporting team for extensive reporting using Data mart
• Performed functional, load, Integration, testing, User Acceptance testing, End to End testing.

Environment: Ascential DataStage 7.5 Enterprise Edition/Parallel Extender, Teradata, Oracle 9i, SQL Server 2000, Sequential Files, CSV Files.

Confidential, NY

ETL Data Stage Developer

Responsibilities:

• Interacted with the business managers to understand their requirements.
• Wrote the Technical specifications.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.
• Identified 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 surrogate key tables to map the required dimensions.
• Creation of hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local and shared use.
• Developed the DataStage Jobs.

Environment: Ascential DataStage 7.0/6.1 (Designer, Director, Manager, Parallel Extender), AUTOSYS, PeopleSoft 8.8 (PeopleTools, PeopleCode, Application Engine & SQR), ERwin 4.1, Teradata, IMS, DB2, Oracle 8i, PL/SQL, SQL Server, MS-Access, CFS, dbase3, DOS and UNIX Sequential Files, CSV Files, XML Files, Excel, VBA and CPIP/VoIP under Windows and UNIX.