Data Management Manager Resume
SUMMARY
- Extensive experience in Master Data Management, Data warehouse, Business Intelligence, application development for front end, back end and middle tier technologies.
- Extensive experience in Data Warehousing and hands on with ETL tools like Ab Initio & Informatica.
- Strong experience in PL/SQL, Shell Scripting and other programming languages.
- Excellent Master Data Management, Data Warehousing and Data Modeling knowledge.
- Lots of experience dealing with the business end users. Excellent ability to understand and implement projects from the management perspective.
- Excellent team building skills. Led and managed teams responsible for delivering/maintaining critical projects.
- Experience in working as a Developer, Designer and Team Lead and Manager.
- Good team player, hard working, self - motivated and self-learner with admirable interpersonal and communication skills.
- Demonstrate ability in grasping both technical and non-technical concepts.
- Excellent communication and interpersonal skills, with the ability to work independently and/or adapt to any team environment.
TECHNICAL SKILLS
Operating Systems: Windows 95/98/NT/2000, UNIX (Sun Solaris2.6/2.8, Linux 2.4, HP-Unix).
Master Data Management: Confidential Initiate 9.7
ETL Tools: Ab Initio (GDE1.15, Co>OperatingSystem2.15), Informatica, Power Mart 4.7, Power Center 7.1.x and 5.1.
Languages: SQL, PL/SQL, Unix Korn Shell, C, C++, JavaScript, VBScript, HTML, XML, ASP and .NET Framework
RDBMS: Teradata V2R5, Oracle 11g, SQL Server 7.0/2000, MS Access 97/2000
Scheduling Tools: Autosys, Control M
Database Utilities: Teradata SQL Assistance 6.1, Toad 7.5, SQL Loader, BTEQ Win
DSS Tools: Crystal Reports 8.0/8.5, Business Objects XI R3
CM Tools: Ab Initio EME Environment, PVCS, Visual SourceSafe 6.0, Harvest, Subversion
Testing Tools: Test Director 7.6, Clear Quest
PROFESSIONAL EXPERIENCE
Confidential
Data Management Manager
Responsibilities:
- Successfully managed a team of 15-20 resources (On-Site and Off-Shore) in CDI/MDM and ETL
- Successfully integrated ~150 M customer account records across 32 sources.
- Successfully implemented High Availability with 99.999% availability
- Developed Ab Initio Solution to load the data from different sources into CDI Master files and create deltas to be loaded into HUB.
- Successfully used IXM (Incremental Cross Match) to integrate the 8.9M customer account records within 10 hours into CDI.
- Successfully designed and implemented Initiate Algorithms for Person, Business and Household
- Successfully implemented in-house built Match Quality Operational Manual Review process
- Responsible for the management and implementation of the EDW and CDI/MDM solution
- Worked with Initiate Support, DBA’s, UNIX, Storage teams to tune and improve performance
- Successfully designed and deployed Inbound, Entity Management, Outbound broker processes
- Successfully lead several system conversions and delivered complex new business capabilities
- Strong Vendor Management skills: Confidential /Initiate and On-Site/Off-Shore Resourcing partners
Environment: Initiate MDS CDI/MDM Versions 7.5/8.5/ 9.7, Ab Initio GDE 1.15.7 Co-op 2.15, UNIX/Linux, Oracle, Teradata
Confidential
Senior Ab Initio Developer
Responsibilities:
- Involved in design and architecture of the whole application.
- Designed various IR2 modules for Loan Setup and Payment processing modules for various programs like 1MP, 2MP, HAFA, FHA and RDHAMP.
- Involved in various High level design and detail level design review meetings.
- Involved in designing the workflow for the whole project
- Involved in various handshake meeting between Confidential and external partners.
- Supported testing efforts in both system test and acceptance environments
- Supported various releases in Production as well as acceptance environments.
- Designed the file transfer B2B protocols with different recipients using Flex File Exchange
- Involved and supported Adhoc Database Modification and File Modification processes.
- Developed process for Cleaning up the ETL UNIX file system and BOXI Wintel file system.
- Developed Data Quality mappings using Informatica Data Quality tool.
- Scheduled the calendar jobs using the Autosys Scheduler
- Involved in process design as per Risk and Compliance Standards
Environment: ETL, Ab Initio (GDE 1.15, Co>Op 2.15), Ab Initio Enterprise Meta Environment, Mainframe, Oracle 10g, Clear Case, Clear Quest, Remedy, Autosys, UNIX, Business Objects XI R3, Informatica
SENIOR AB INITIO DVELOPER
Confidential
Responsibilities:
- Technical team lead and also responsible for leading the team, providing the technical solutions and also designing, developing, testing, and implementing the Mortgage backed Securities ETL processes and architecture.
- Responsible for understanding business and functional requirements and converting them into technical requirements and mapping documents.
- Involved as Designer and Developer for Guaranty Business System (GBS).
- Developed Ab Initio graphs and high level design and detail design document for data movement.
- Developed parameterized Ab Initio Graphs to load the data in to Oracle Staging Tables.
- Create cfd, pset, data, and ctrl files.
- Performed transformations of source data with transform components like Write Multiple Files, Run Program, Join, Dedup Sorted, Reformat, Filter-by-Expression and Rollup, etc.
- Unit testing of new and existing Graphs.
- Used Automated Test Framework to test the Ab Initio graphs.
- Write and modify several application specific Config scripts in UNIX in order to pass the environment variables.
- Writing Korn Shell Scripts in Aix UNIX to automate the ETL process.
- Scheduling the Graphs using Autosys Scheduler.
Environment: ETL, Ab Initio (GDE 1.13.3.2, Co>Op 2.13.1), Ab Initio Enterprise Meta Environment, Mainframe, Oracle 10g, Clear Case, Clear Quest, Remedy, Autosys, UNIX