SUMMARY

• Over 8 years of total IT experience in software development, designing and implementing, with major focus on IBM Infosphere Master Data Management (MDM), ETL - AbInitio/Data Warehousing and Business Intelligence Applications in Banking/Retail domain
• Having 2+ years of experience as an IBM Infosphere Master Data Management developer
• Over 6 years of experience in design and development of data warehouse solutions using AbInitio 3.0/2.15/2.14
• Involved in various phases of a MDM Projects that include requirements analysis, Design and development for end-to-end solution offerings
• Extensive experience in customizing the Infosphere MDM Server using MDM Work Bench
• Hands on experience in creating the Data Additions, Extensions, Business Proxies, Composite XML Transactions, Batch Load, Notification Framework and Behavioral Extensions
• Sound knowledge in Req/response Framework, SPECS and External Rules Framework
• Exposure on Event Manager, Rules of Visibility and Suspect Duplicate Processing
• Deep knowledge in IBM InfoSphere MDM providing technical and Functional leadership to the team
• Solid working experience in Master Data Management initiatives with strong hands on experience on designing, modeling, implementing and testing the Services
• Experience in complete development life (SDLC) cycle from gathering Requirements, Technical Design, Development, Testing, Implementation and Post Implementation Support
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2 and type3
• Experience in creating RDD (Requirements Definition Document), HLDD (High level Design document), DDD (detailed design document) ETLMapping sheets and unit testing document
• Experience in Data Integration of various data sources from databases such as XML files, Oracle, Teradata, flat files and CSV files
• Experience in requirement analysis, client interaction, system design, development, testing, documentation and implementation with extensive coding standards
• Involved in UNIX to Linux migration of the set of projects
• Coded well-tuned SQL/PL-SQL scripts for warehouse instance
• Coded well-tuned Unix Korn Shell scripts, Wrapper scripts for high volume data warehouse instances
• Involved in the migration of PL-SQL code into AbInitio Graphs
• Prominent use of AbInitio in every walk of Development, testing and other phases
• Good knowledge in working with Relational database utilities like TOAD, DB Visualizer, SQL Developer
• Worked on scheduling tools like Maestro, Crontab and Autosys
• Worked on HP Quality Center to track the issues
• Provided on 24x7 Production support for daily, weekly and monthly incremental and complete refresh warehouse environment
• Sound knowledge in data warehouse concepts, STAR Schema, SNOW FLAKE Schema designs and dimensional modeling
• Experience in product migration and release management process
• Extensive experience in analysis of Source Systems, Staging area and Target Warehouse and Data Mart systems
• Exposure in Big Data, Hadoop - HDFS, Map Reduce and Hadoop eco systems like Hive, Pig, Sqoop and Flume
• Proven abilities at guiding, leading, mentoring, training ETL trainees inside the team and across different teams
• Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations
• Give presentations on the functionality of the Ab-Initio components, role of Ab-Initio in Data warehousing
• Excellent analytical and communication skills, ability to work independently and good team player

TECHNICAL SKILLS

MDM Tools: IBM Infosphere MDM Server 9.0

ETL Tools: AbInitio (GDE 3.1, Co-Operating System 3.1)

Application Severs: IBM WebSphere Application Server

Database: IBM DB2, Oracle, Teradata

Programming Languages: Java, JDBC, EJB, XML, HTML and Web Services

Repositories: CVS, Rational Clear case

Scheduling Tools: Maestro, Autosys, Cron Tab

Operating Systems: Unix, Linux, MS Windows XP/2003/2000/NT, MS DOS.

Concepts: OLTP, OLAP, Data Marts, Dimensional Modeling

Scripting Languages: SQL, PL/SQL, UNIX Shell Scripting (Korn)

Other Tools: RAD, DB Visualizer, Toad, Filezilla, Putty, Mercury Quality Center

PROFESSIONAL EXPERIENCE

Confidential

IBM MDM Architect

Responsibilities:

• Complete understanding of MDM Architecture and MDM Party Datamodel
• Installed and configured IBM Infosphere MDM 9.0.2 with RAD 7.5.4
• Interacting with the customer and gathering the requirements for new developments and major changes in existing services
• Created Data Additions - Adding Custom Tables for Attributes that does not fit in Data model
• Created Data Extensions - Extending the datamodel by adding new attributes
• Designed and implemented the Business Proxies for All customized services
• Developed Behavioral Extensions to the existing services to include custom logic
• Implemented the Composite XML Transactions to group one or more services
• Involved in Batch Framework for Initial and Delta load
• Implemented the Notification for updating the customers address
• Configured the Error handling and Logging
• Working in with Tivoli Workload Scheduler(TWS) team to create jobs for MDM batch loads and scheduling all related jobs for successful daily/ monthly loads from source to MDM
• Unit testing of the customized services
• Managing the MDM defects, analyzing the issues and fixing them
• Have theoretical knowledge on Notification framework, Rules of visibility and Specs
• Support production releases of new functionality / new source system introduction to MDM
• Knowledge transferring to new team members

Environment: IBM Infosphere 9.0, RAD 7.5.4, Websphere V7.5, DB2, DB Visulizer, Java, J2EE, XML and XSD

Confidential

IBM MDM Architect

Responsibilities:

• Understood Functional Specifications documents for the assigned services
• Installed and configured IBM Infosphere MDM 8.5 with RAD 7.0
• Developed the Data Additions by adding the custom Tables for Attributes that are not provided in Data model
• Understood of MDM Party Datamodel
• Developed the Data Extensions by adding new attributes
• Created the Business Proxies for customized services
• Unit testing of the services
• Worked with TWS team to schedule the batch Jobs
• Have knowledge on Notification framework, Rules of visibility and Specs
• Fixed the issues by debugging the developed code

Environment: IBM Infosphere V8.5, RAD V7.0.0.6, Webshphere V6.1, Oracle, Toad, Java, J2EE, XML

Confidential, TX

ABINITIO Developer and Lead

Responsibilities:

• Involved as designer and developer for Commercial Business Group data Ware House (CBGDWH)
• Requirement gathering and analysis, prototyping, Interface Design Document and High level design document creation
• Development of source Data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements
• Consolidated the code developed by all team members and making the deliverables as per schedule
• For Salesforce project Analyzing relationships between Salesforce Objects
• For Salesforce project Developing the graphs using Salesforce connector components and XML components
• Created technical design documents, Source to Target Mapping sheets and Unit test case scenarios
• Used different AbInitio Components like Partition By Key and Sort, Dedup, Rollup, Scan, Reformat, Join,Normalize,FBE and fuse in Various Graphs
• Fixed existing application bugs/runtime issues to ensure uninterrupted application processing
• Used components like run program and runsql components to run UNIX and SQL commands in Ab Initio
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited
• Wrote several Unix Control Scripts specific to application in order to pass the Environment variables
• Worked closely with functional and Business team to resolve post-production defects
• Lead and closely monitored the development team providing the required guidance and worked on enhancements and project integration
• Involved in Project Promotion from Development to UAT and UAT to Production
• Used different EME Air Commands in Project promotion like air tag create, air save, air load, air project export
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Interaction with client on daily basis for requirement gathering and status update
• Validated the data consistency after migration
• Addressed code related issues raised during all the phases of the project

Environment: AbInitio 3.0, UNIX, Oracle SQL/PL-SQL, TWS Maestro, Teradata, Microsoft Visio Auto Sys, Xml, Windows 7, Mercury Quality centre, Shell Scripting

Confidential, NJ

ABINITIO Developer

Responsibilities:

• Understood the Business requirements, co-ordination with developers and Business Analysts directly
• Involved in requirements gathering, worked out the designs, prepared the technical design document by attending meetings with the client
• Developed the technical specifications and pseudo logic including test plan and test cases
• Developed graphs which are complex in nature by leveraging the various advanced XML components like XML Split and Read XML
• Wrote several Unix Control Scripts specific to application in order to pass the environment variables
• Worked closely with functional and Business team to resolve post-production defects
• Code reviewed for the other developers and made performance improvements
• Involved in the Technical design documents, Application Support Guide of the projects
• Involved in unit testing of the graphs
• Compilation of test results in the form UTR (Unit Test Results) Document
• Reviewed the code to ensure client standards

Environment: AbInitio 2.15, UNIX, Oracle SQL, Shell Scripting, TWS Maestro, Xml, Windows XP

Confidential, NY

ABINITIO Developer

Responsibilities:

• Understood the Business requirements, co-ordination with developers and Business Analysts directly
• Involved in requirements gathering, worked out the designs, prepared the technical design document by attending meetings with the client
• Developed the technical specifications and pseudo logic including test plan and test cases
• Wrote several Unix Control Scripts specific to application in order to pass the Environment variables
• Worked closely with functional and Business team to resolve post-production defects
• Code reviewed for the other developers and made performance improvements
• Involved in the Technical design documents, Application Support Guide of the projects
• Involved in unit testing of the graphs
• Compilation of test results in the form UTR (Unit Test Results) Document
• Reviewed the code to ensure client standards

Environment: AbInitio 2.14, UNIX, Oracle SQL, TWS Maestro, Shell Scripting, Windows XP

Confidential

ETL Developer

Responsibilities:

• Understood the Business requirements, co-ordination with developers and Business Analysts directly
• Involved in requirements gathering, worked out the designs, prepared the technical design document by attending meetings with the client
• Developed the technical specifications and pseudo logic including test plan and test cases
• Wrote several Unix Control Scripts specific to application in order to pass the environment variables
• Worked closely with functional and Business team to resolve post-production defects
• Code reviewed for the other developers and made performance improvements
• Involved in the Technical design documents, Application Support Guide of the projects
• Involved in unit testing of the graphs
• Compilation of test results in the form UTR (Unit Test Results) Document
• Reviewed the code to ensure client standards

 Environment: AbInitio 2.14, UNIX, Oracle SQL, TWS Maestro, Shell Scripting, Windows XP