Application Developer Resume
Chicago, IL
SUMMARY
- Extensive and diversified IT experience of 6+ Years in Analysis, Design, Development, Testing, Implementation and Support life cycle for Data Warehouse, Database Technologies & Extraction Transformation and Load (ETL) methodologies using IBM InfoSphere Information Server 9.1 & 8.5, IBM Info Sphere DataStage 8.1.0, IBM Websphere DataStage 7.5.2/7.5.1, Altova Mapforce 2012 R3/R2 and development of Data Warehouse/Data mart Applications for Banking, Manufacturing, Finance industries.
- Profound knowledge in Full Software Development Life Cycle (SDLC) in Collecting requirements, Design, Coding, Unit Test Plan Preparations, Integration Testing, Performance Testing, System Testing and Project documentation.
- Strong Knowledge of Data Warehouse Architecture in Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical/Logical Data Modeling, Data Flow Diagrams, E - R Diagrams, Data Diagrams, Table Structures using Erwin and Visio.
- Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Data Integration, Performance Tuning.
- In-Depth experience in dealing with different stages and good experience in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancements, using shared containers and RCP.
- Extensive experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like source, target, and mappings.
- Experience in Data integration of various data source like Teradata, Oracle. Excellent working knowledge on multiple platforms like Windows NT/2000, UNIX (Linux, IBM-AIX)
- Developed UNIX shell scripts using Korn Shell for the Scheduling sessions, automation of processes, pre and post session scripts.
- Strong knowledge Clear Case/Clear Quest, SVN for the versioning and migration of code to production
- Excellent Communication, Interpersonal, Presentation, Documentation skills and understanding of Business Procedures.
- Strong ability to work as an individual and as a Team player.
- Profound Knowledge in dealing with Change request, Emergency ITSM’s for Production, WRM.
- Demonstrated ability in problem solving, troubleshooting with Analytical knowledge in resolving Priority 1, 2 and 3 peregrines (Production tickets) promptly meeting all the SLA’s.
TECHNICAL SKILLS
Data Warehousing: IBM Information Server (DataStage) 9.1 & 8.5, IBM Information Server (DataStage) 8.1, IBM WebSphere DataStage 7.5.xAscential DataStage EE 7.X, Altova Mapforce 2012 R3/R2
RDBMS: Oracle 8i/ 9i/ 10g/11g, Teradata
Database Tools: Oracle SQL Developer, Terada SQL developer, SQL* Plus 9.2Toad
Programming: SQL, PL/SQL, UNIX Shell ScriptingOther Tools TOAD, SQL*Plus, SQL*Loader, Clear Case, SVNMSOffice,Control-M
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
Application Developer
Responsibilities:
- Interacting with users to understand and resolve the data related issues in application
- Involved in fixes for bugs identified during production runs within the existing functional requirements.
- Troubleshooting the causes of daily production job failures.
- Debugged the root causes and resolution for many existing production defects.
- Solely worked on a special project of Defect prevention Exercise from L3 and organized presentation to the team with the common type of errors which were repeatedly happening, and prepared a check list to all the developers.
- Interacted with Business and Functional Analysts to get the proper Requirements.
- Worked on Functional design, Detailed level designs and Mapping documents. Prepared the Technical design document and Participated in source to target mapping design document.
- Involved in High level data separation design and specification documents.
- Created Unit and Integration Test Plan documents
- Analysis to all the levels of peregrines is been provided by gathering information from L2 and product.
- Worked on various defect fixes across all the processor files, including AML Fortent, TS2, TSYS, HP and Airplus.
- Worked on Creating UNIX directories, access according to best practice guide lines
- Worked with Oracle DBAs to add the tns entries for the interaction of DataStage with Oracle database.
- Added DataStage Environmental Variables at the Project Level
- Used different Parallel job stages like Join, Merge, Lookup, Filter, Col and Row generator, Transformer, Modify, Aggregator, Remove Dup, External Filter, External Source and Target Stages, Oracle and ODBC Stages, Stored Proc Stages, Custom Wrapper Stage etc.
- Worked on new State of the Art Transformer Looping using DataStage v8.5
- Created Master sequencers using User variable Activity, Job Activity, Execute Command Stage, Start Loop Activity, End Loop Activity, Nested Condition, Exception Handler Stages
- Created Custom Wrapper Stage and used UNIX shell scripts to utilize the Data stage Parallel engine to handle large volumes of data
- Used Control-M as a scheduling tool to handle event based scheduling and time based scheduling.
- Defined Best ETL Data Stage practices and naming conventions as well Followed and implemented New Oxygen-4 (M27) Global DataStage Standards
- Was involved and implemented in Performance tuning of Data stage jobs with proper data stage partitioning techniques and Node configuration
- Involved in the Production On call Support during Migration event
- Used Quality Center/ALM Quality Center to track defects and updated the status as and when the changes are done
- Developed low complex custom objects with Altova Mapforce to generate the XSLT code
- Created custom code when required to merge different data types (XML and Oracle) with different schemas using XML Parser
- Worked with XSL editor to modify the XSLT code generated in Mapforce and the XML editor to view the data sets and generated output file
- Responsible to ensure efficient identification and monitoring of suspicious activities and transaction in the Bank and ensure timely reporting of suspicious transactions to the Anti-Money Laundering department.
- Raised EURC, WRM requests to get the required access for various tools, worked on Emergency ITSM during night shifts.
- Good knowledge in understanding Customer Business Requirements
- Worked closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process in a timely manner.
- Updated the status of the testing to the QA team, and accomplished task for the assigned work to the Project Management team regularly.
- Performed Regression testing of the fixed issues in the new build until no new issues are identified.
- Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
- Submitted Final Test Report and required documentation for the entire project within the assigned time frame
- Used Clear Case and Clear Quest to check in the Data stage code and Proper change management.
- Used SVN as a latest version control tool and using Hudson deployed the code and promoted to higher environment.
Environment: IBM Infosphere Data stage 9.1 & 8.5, IBM InfoSphere Data stage 8.1.0, Oracle 11i/10g, DB2, AIX 6.1,Linux, TeraData, Teradata SQL Assistant, SQL,PL/SQL, TOAD, SQL Developer, Microsoft-Visio, UML, Hyperion-Essbase, TSM, Lotus Notes, TMW Maestro, ClearCase 6.0, Windows XP, Control - M, SVN, Hudson.
Confidential, Greenville, SC
ETL DataStage Developer
Responsibilities:
- Participated in SDLC, all phases of the project i.e. Business Requirement Gathering, Client Interaction, Design, Coding, Testing, Deployment, Support and Documentation.
- Worked on Gap Analysis, converted requirements into High Level Design Documents, Low Level Design Documents, High Level Mapping Documents and Low Level Mapping Documents.
- Extensively involved in project with contributors from France, Mexico and Canada.
- Designed and developed data stage jobs to load data into Dimension and Fact tables of different Data marts by extracting data from Data warehouse tables and to send the fixed width files to mainframe application by Pelican transfer.
- Designed Parallel, Server Jobs, Job Sequencers and Batch Jobs.
- Used QualityStage plug in with in DataStage.
- Created and verified Quality stage jobs for Match and unduplication.
- Developed parallel jobs using parallel stages like Merge, Join Lookup, Aggregator, Switch, Column Export, Column Import, Modify, Column Generator, Row Generator, Remove Duplicate, Dataset, Sort, Transformer, Change Data Capture stage, Oracle Enterprise Stages etc.
- Experience on Complex flat file to handle Mainframe files.
- Developed Master Sequences using Activity Stages like Execute Command Stage, Terminator Activity Stage, Exception Handler, Nested Condition, Sequencer, Terminator, Start loop and End loop activity stages.
- Worked on Datastage admin activities like creating ODBC connections to various Data sources, Server Start up and shut down, Creating Environmental Variables, Creating Data Stage projects and Message Handler files.
- Involved in Preparing and Executing a Test plan effectively to reduce the bugs to minimal level.
- Involved in various phases of testing including Unit testing, Integration testing, Qualification testing and User acceptance testing
- Created Shell scripts to run the Master Sequence on UNIX AIX box.
- Created shell scripts on UNIX for Maestro Scheduler to run Datastage jobs at a scheduled time also created Axway InterPel scripts to transfer the files to Mainframe applications.
- Worked with IBM in deployment of ETL Package in Local Acceptance and Production Environments.
- Well versed in Off-shore On-site Model and Managed a team of 8 members from Off-shore.
- Worked with Manage now and JIRA tools.
- Was involved 24*7 production support (effectively handled Sev1, Sev2 and Sev3 tickets) involve in On-Call for CDW Operations.
- Worked on Software Configuration Management tool i.e. Clear Case
- Worked on Document Management system i.e. Clear Case
Environment: IBM InfoSphere Datastage and Quality Stage 8.1.0, IBM Web Sphere Data Stage 7.5.1 (Enterprise Edition) (Designer, Manager, Director), SQL, PL/SQL, VISIO, TeraData, System Testing, MDM, Tivoli, Clear Case 6.0, IBM DB2, Erwin 4.1, Oracle 10g, AIX 5.3, TOAD 7.3, Win 2000, SQL Developer, Unix Shell Scripting, Maestro