Data Manager

Sukhwinder Singh

Email:*********.***@*****.***

Phone:614-***-****

PROFESSIONAL SUMMARY:

Over 10 + years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 8.0.1/7.x/6.x/5.x (Info Sphere Information Server, Web Sphere, Ascential Data Stage).

Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.

Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Complex flat file, Modify, Aggregator, XML.

Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.

Experienced in integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, XML and MS-Access) into data staging area.

Expert in working with Data Stage Manager, Designer, Administrator, and Director.

Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.

Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.

Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.

Proficient in writing, implementation and testing of triggers, procedures and functions in PL/SQL and Oracle.

Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling (Star Schema modeling, and Snowflake modeling).

Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.

Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.

EDUCATIONAL QUALIFICATION:

Masters in Computer Science,

TECHNICAL SKILLS:

ETL Tools

DATA STAGE- IBM Web Sphere Data stage, Ascential Data Stage, SQL server 2005, Data Integrator.

Operating Systems

HP-UX, IBM-AIX 5.3, Windows 95/98/2000/ NT, MS SQL SERVER 2000/2005/2008& MS Access

Scheduling Tool:Zena

WORK EXPERIENCE:

Huntington National Bank, OHIO JAN 2012 – December 2019 Sr. Datastage ETL Designer and Devoloper

Hunitngton Bank is the leading Mid West Bank dealing with mortgages,consumer loan and commercial loan.Worked on different Projects to load the data from different source systems to Enterprise Data warehouse which is used for reporting purposes and the reporting is done using the Microstratgey Tool.

Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software .

Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.

Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.

Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE,DB2 database.

Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.

Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.

Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.

Extensively worked with sequential file, dataset, file set and look up file set stages.

Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.

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

Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.

Creation of jobs sequences.

Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables..

Coordinate with team members and administer all onsite and offshore work packages.

Analyze performance and monitor work with capacity planning.

Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Participated in weekly status meetings.

Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.

Environment: IBM Web Sphere DataStage 9.1 Parallel Extender, Web Services, 9.1, (Designer, Director, Manager), Microsoft Visio, IBM AIX 4.2/4.1 IBM DB2 Database, SQL Server, IBM DB2, ORACLE 11G, Data Studio,Unix, Windows.

Prudential, PA Jan 2011 - Dec 2011 Sr.Datastage Designer and Developer

Project was to design and develop enterprise data warehouse. Extract data from heterogeneous source system, transform them using business logic and load in to data warehouse.

Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.

Extensively used ETL to load data from different oracle,Flat files Source to DB2 Database.

Involved in analysis, planning, design, development, and implementation phages of projects using IBM Web Sphere software .

Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.

Created queries using join and case statement to validate data in different databases.

Created queries to compare data between two databases to make sure data is matched.

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 shared container to incorporate complex business logic in job.

Created and modified batch scripts to ftp files from different server to data stage server..

Created Job Sequencers to automate the job.

Create parameter set to assign a value to job at run time.

Standardized the Nomenclature used to define the same data by users from different business units.

Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.

Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.

Providing the logical data model design, generating database, resolving technical issues, and loading data into multiple instances.

Environment: IBM Web Sphere DataStage 8.0.1 Parallel Extender, Web Services, Quality Stage 8.0, (Designer, Director, Manager), Microsoft Visio, IBM AIX 4.2/4.1 IBM DB2 Database, SQL Server 2000, IBM DB2, ORACLE 11G, Data studio, Unix, Windows

Global Infotech systems,Jan 2009 - Dec 2010 Datastage Designer and Developer

Project was to extract data from different source system, transform them using business logic and load in to data warehouse.

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

Extensively used ETL to load data from different Source files to Db2 Database.

Developed jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.

Used the DataStage Director to run the jobs.

Created Job Sequencers to automate the job.

Create parameter set to assign a value to job at run time.

Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.

Environment: IBM Web Sphere DataStage 8.0.1 Parallel Extender,(Designer, Director, Manager), IBM AIX 4.2/4.1 IBM DB2 Database, SQL Server 2000, IBM DB2.

Contact this candidate