SUMMARY:

• 9 Years of experience in System Analysis, Design and Development and in the fields of Data Warehousing, Data Integration, Data Migration, RDBMS and Developing Client server applications using Confidential Info Sphere DataStage and Quality Stage, Confidential CDC, Oracle, PL/SQL, DB2, SQL procedural language and Shell Scripts.
• In Depth knowledge in Data Warehousing & Business Intelligence concepts with emphasis on ETL and Software Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling, E - R modeling. Involved in Designing Dimensional Model (Star Schema and Snowflake Schema).
• Good Experience in Dimensional Data Modeling, Fact and Dimensional Tables, Slowly Changing Dimensions.
• Around Five years of experience in ETL methodologies in all the phases of the Data warehousing life cycle
• In Depth knowledge in Data Warehousing & Business Intelligence concepts with emphasis on ETL and full Life Cycle Development including requirement analysis, design, development, testing and implementation
• Expertise in all the phases of System development life Cycle (SDLC) using different methodologies like Agile, Waterfall.
• Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling, E-R modeling. Involved in ODS/Designing Dimensional Model (Star Schema and Snowflake Schema) Designing logical and physical design data modeling with star schema using Erwin.
• Have good grasp of data warehousing fundamentals and have proven ability to implement them. Conversant with ETL processes.
• Handled Responsibilities including analyzing detailed business requirement in a technical prospective and developing and maintaining detailed project plans.
• Lead developers to develop clean, maintainable and efficient code.
• Strong analytical and problem solving skills.
• Used Quality Stage for Rules creation and Cleansing of Data
• Team player with ability to communicate at all levels of development process.
• Interacting with the end-users, business analysts, source system technical staff, the project DBA and the infrastructure architects to develop the most efficient method to extract source data.
• Analyzing the target database design and its usage so that the transformations which convert the source data into the target data structures are clearly documented and understood.
• Ensure the ETL design process is re-usable, documented and put under proper change control
• Good People Dynamics and Leadership.
• Ability to manage team, project owning capabilities.
• Effective task tracking, execution and reporting skills.
• Ability to meet timelines.
• Effective communication skills and good team coordination.
• Qualitative task delivery under stringent timelines and high pressure.
• Good verbal and written skills, Good explanation ability with patience.
• Good knowledge of data warehousing concepts, experience of full SDLC implementation of BI Application.
• Managing reports, analysis and decision-making for a change request.
• Ability of translating Business requirements to understandable IT systems requirements.

TECHNICAL SKILLS:

Data Warehousing: Confidential InfoSphere Information Server 11.3,9.1,8.1, 8.5, 8.7, Confidential WebSphere DataStage EE/7.0/6.0 (Manager, Designer, Director, Administrator), Confidential CDC 10.2.1, Cognos 6.0/5.x, Pentaho, Business Objects 5.1, Data Mining, Hadoop, DataMart, OLAP, OLTP, SQL*Plus, SQL*Loader

DimensionalData Modeling: Star Schema, Snow-Flake, FACT and Dimensions, Physical and Logical Data Modeling

Databases: Oracle 11g/10g/9i/8i/8/7.x, DB2, SQL Server 2000, 2005, 2008, MySQL 5.0, Ms Access 7.0, Teradata

Reporting Tools: Business Objects 6.5.1/5.1,Crystal Report 7.0GUI Visual Basic 6.0/5.0/4.0/3.0, FrontPage 7/98/2000, Excel, Power PointUNIX K Shell, Bourne Shell, AWK, VI, SED

PROFESSIONAL EXPERIENCE:

Confidential,MN

Sr DataStage Developer

• Interacted with End user community to understand the business requirements and identifying data sources.
• Designed and developed ETL processes using DataStage to load data from Teradata, Flat Files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Involved in performance tuning and optimization of DataStage jobs.
• Good experience in migrations and conversion
• Involved in design, source to target mappings between source and target.
• Worked on troubleshooting, performance tuning and performances monitoring for enhancement of DataStage jobs and builds across Development, QA and PROD environments
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs. Parameterize the jobs and creating Environment variables to facilitate moving of jobs between different environments
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Understanding of Web Services for Real-time integration.
• Built Teradata SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Exporting the jobs to Testing Environment from Development and then to Production and worked closely with DataStage Administrator on deployment.
• Work with external data providers and downstream application/users on addressing delays in data availability and job failure.
• Executed data fixes, added adhoc job requests and perform manual and automated execution and monitoring of Production jobs

Environment: Teradata V14.01, DataStage 11.3, 9.1, 8.5, Teradata Sql Assistant, Tivoli Workload Scheduler, UNIX, HP ALM, Win SCP, Putty, Perl, Ultra Edit, Tortoise SVN, CLM

Confidential, IL

Sr DataStage Developer/Admin

• Provide technical assistance to team and evaluate all codes
• Design and analyze all ETL jobs
• Analyze work and implement all business regulations
• Review all functional business applications and specifications
• Design various block diagrams and logic flowcharts
• Analyze performance and monitor work with capacity planning.
• Document all program level and user level processes
• Good knowledge and understanding of Confidential CDC tool with administration and optimization skills
• Exposure to CDC Installation, Configuration, Maintenance, Trouble Shooting and Upgrade
• Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic to Slowly Changing Dimensions
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Involved in performance tuning and optimization of DataStage jobs

Environment: Confidential Infosphere DataStage 8.5 (Designer, Director, Administrator), Confidential CDC 10.2.1, Oracle 11g, Linux, Toad, Windows2000/2003/XP, FileZilla, SQL Server 2008, Erwin, TWS, HP ALM, Win SCP, Putty, Microsoft Visio, Control-M

Confidential, MN

Sr DataStage Developer

• Interacted with End user community to understand the business requirements and identifying data sources.
• Designed and developed ETL processes using DataStage to load data from Oracle, Flat Files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Involved in performance tuning and optimization of DataStage jobs.
• Good experience in migrations and conversion
• Involved in design, source to target mappings between source and target.
• Worked on troubleshooting, performance tuning and performances monitoring for enhancement of DataStage jobs and builds across Development, QA and PROD environments
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs. Parameterize the jobs and creating Environment variables to facilitate moving of jobs between different environments
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Built Oracle SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Exporting the jobs to Testing Environment from Development and then to Production and worked closely with DataStage Administrator on deployment.
• Work with external data providers and downstream application/users on addressing delays in data availability and job failure.
• Executed data fixes, added adhoc job requests and perform manual and automated execution and monitoring of Production jobs

Environment: Oracle 11g, DataStage 8.7, Toad, Tivoli Workload Scheduler, UNIX, HP ALM, Win SCP, Putty

Confidential, MA

Sr DataStage Developer

• Responsible for performing Impact Analysis on the system, to modify the existing ETL logic.
• Good development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling
• Data loading using PL/SQL
• Responsible for participating in project planning sessions with project managers, business analysts, and team members to analyze business requirements and outline the proposed IT solution.
• Responsible for participating in design reviews and provide input to the design recommendations and in corporate security requirements into the design and provide input to information/data flow.
• Good experience in migrations and conversion
• Developed parallel jobs using parallel stages like Transformer, join, lookup, merge, aggregator, change capture, funnel, filter and file stages including flat files like CSV, pipe delimited etc…
• Parameterize the jobs and creating Environment variables to facilitate moving of jobs between different environments
• Exporting the jobs to Testing Environment from Development and then to Production and worked closely with DataStage Administrator on deployment.
• Work with external data providers and downstream application/users on addressing delays in data availability and job failure.
• Manage Service request tickets through standard operating procedures.
• Work with external data providers and downstream application/users on addressing delays in data availability and job failure.
• Created ETL jobs using Pentaho
• Provided Post Production support, fixed production issues and worked on enhancements

Environment: Oracle 11g, Datastage 8.1, Information Analyzer, Metadata Workbench, PL/SQL developer, Tivoli Workload scheduler, Pentaho, UNIX, Mercury Quality Center

Confidential,IL

DataStage Developer

• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data
• Analyze the effectiveness of the current systems and procedures applied in the organization towards achieving the long term and short-term goals
• Assist the organization in planning and decision-making activities by considering the availability of resources, potentials risks, competition levels, etc.
• Wrote SQL, PL/SQL stored procedures, packages and triggers
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Created Materialized Views
• Developed SQL, PL/SQL stored procedures, packages and triggers for extracting data
• Developed parallel jobs using parallel stages like Transformer, join, lookup, merge, aggregator, change capture, funnel, filter, XML and file stages including flat files like CSV, pipe delimited etc…
• Parameterize the jobs and creating Environment variables to facilitate moving of jobs between different environments
• Developed user defined Routines and Transformations
• Exporting the jobs to Testing Environment from Development and then to Production and worked closely with DataStage Administrator on deployment.
• Manage Service request tickets through standard operating procedures.
• Work with external data providers and downstream application/users on addressing delays in data availability and job failure.
• Provided Post Production support, fixed production issues and worked on enhancements
• Experience using TSQL, BTEQ, FASTEXPORT, FAST LOAD
• Provided quality written communication and details of issues and incidents
• Used DataStage Director to validate schedule run and monitor the DataStage jobs
• Executed data fixes, added adhoc job requests and perform manual and automated execution and monitoring of Production jobs
• Perform data restore and back-processing, data archiving and data migration.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements
• Created batches and sequencers for running and controlling set of jobs developed

Environment: Confidential Infosphere DataStage 8.1(Designer, Director, Administrator), Oracle 11g, Linux, SQL Developer, Windows2000/2003/XP, FileZilla, SQL Server 2008, Erwin

Confidential,NC

DataStage Developer

• Developed parallel jobs using parallel stages like Transformer, join, lookup, merge, aggregator, change capture, funnel, filter, XML and file stages including flat files like CSV, pipe delimited etc…
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Parameterize the jobs and creating Environment variables to facilitate moving of jobs between different environments
• Experience working with DataStage SAP PACK R/3.
• Fine-tuned DataStage jobs and routines for optimal performance.
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage
• Used DataStage Sequencer jobs extensively for batch scheduling to control and efficiently manage server resources
• Along with designing mappings from scratch, re-wrote existing code to enhance performance and trouble-shoot errors in DataStage jobs.
• Submit change control requests and documents.
• Provided Post Production support, fixed production issues and worked on enhancements.
• Provided quality written communication and details of issues and incidents
• Interact with source team for Source data changes, trouble shoot and fix in the areas of errors in Oracle database

Environment: Confidential Infosphere DataStage 8.5 (Designer, Director, Administrator), AutoSys, DB2, Erwin, Aqua Data Studio 8.1, AIX UNIX, Windows 2000/2003/XP

Confidential

Sr DataStage Developer

• Built SQL for extracting source and target data from DB2 database.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries
• Developed Shell scripts and SQL control files to load data through SQL Loader
• Developed parallel jobs using parallel stages like Transformer, join, lookup, merge, aggregator, change capture, funnel, filter, XML and file stages including flat files like CSV, pipe delimited etc…
• Along with designing mappings from scratch, re-wrote existing code to enhance performance and trouble-shoot errors in DataStage jobs
• Worked on ETL DataStage Manager for importing and exporting metadata and dsx files
• Created Shell Scripts and worked with batch files which will in turn, call the DataStage jobs with all paths to Source and targets and even with connection information.
• Used Shell Script to run and schedule DataStage jobs on UNIX server.
• Experience using Ralph Kimball methodology for building data warehouse.
• Extensively worked on performance tuning of DataStage jobs by eliminating back to back transformers and by proper partitioning, sorting data etc
• Provide daily and weekly reporting of operational status, data issues and data fixes
• Created a Master Sequencer to run the ETL jobs checked the log for abort/failed conditions, fixed the same and reset/restart the sequencer.
• Provided Post Production support, fixed production issues and worked on enhancements
• Interact with source team for Source data changes, revisit the mapping and coding, trouble shoot and fix in the areas of errors and also in DB2 database and SQL Server
• Participate in on call-support Rotation
• Parameterize the jobs and creating Environment variables to facilitate moving of jobs between different environments
• Exporting the jobs to Testing Environment from Development and then to Production.

Environment: Ascential DataStage 7.5.3 EE (Designer, Manager, Director, Administrator), AutoSys, Oracle 9i, AIX DB2, TOAD, Erwin, Aqua Data Studio 8.1, AIX UNIX, Windows 2000/2003/XP

Confidential

Programmer Analyst

• Preparation of Technical documents.
• Maintained comprehensive information on all inventory items, gave up-to-date status on their availability, usage, receipts, on-order, pending inspection, committed quantities, etc.
• Attended several Business sessions with the Business users and created Views and altered some of the dimensional tables to satisfy their reporting needs.
• Involved in the Requirement Analysis and Preparation of System Requirement Specification Document.
• Involved in the Database Design Preparing the Codification Schemes. Preparing the Data Dictionary.
• Involved in Coding Using Stored Procedures and Database Triggers.
• Involved in Unit Testing and Integration Testing.
• Involved in Acceptance Test by the Customer.
• Designed screens for billing module.
• Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.
• Developed Oracle Forms and Reports.
• Generated reports from the sales and distribution package such as sales analysis report, profile wise reports etc.
• Written Procedures and Functions of calculation of Receipts.
• Provided Post Production support, fixed production issues and worked on enhancements
• Work closely with DBA team on fixing the Production issues.

Environment: Oracle 8i, PL/SQL, Oracle Forms 6i, Reports 6i, Windows NT