Senior Consultant Resume
SUMMARY:
- Experienced IT professional with 7.5 years of experience in Application Development.
- Experience in analysing information system needs, evaluating end - user requirements, custom designing solutions, troubleshooting for complex information systems management.
- Experience in Informatica MDM (XUSP2,9.1,9.5.1).
- Experience in Informatica Power Centre (9.1,9.5.1).
- Experience in Informatica Data Quality (9.1,9.5.1).
- Experience in Informatica Data Control.
- Experience in B2B Transformation.
- Experience in Address Doctor (4.1,5.3).
- Experience in IDD (Informatica Data Director).
- Experience in HM (Hierarchicy Manager).
- Experience in SIF (System Integration framework).
- Hands on experience Oracle9i/10g/11g.
- Good knowledge on modeling, ETL, BI DWH modules.
- Have undertaken the whole SDLC in various projects.
- Worked with transformations in informatica like expression, Lookup, Joiner, Router, Transaction Control, Filter, Aggregator, Update Strategy, Rank, Sequence Generator transformations
- Extensively worked on mappings, mapplets, sessions(reusable and non reusable),Workflows
- Good knowledge of ETL standards and used advanced features of informatica like pre and post variable assignment, passing mapping variables from one mapping to different mapping and running workflows concurrently with different parameter files to achieve some complex tasks
- Experience in Data Conversion.
- Experience with Netezza and Teradata.
- Experience with DATA STAGE.
- Experience with Visio (Designing tool by Microsoft).
- Experience using UNIX command and Shell Scripting.
- Experience in for improving performance of the applications.
- Experience in analyzing Data flow Diagram, ER Diagrams Query Optimization, Debugging and Tuning.
- Experience in using OEM.
- Experience in Oracle Streams.
- Experience in DBA Activities like (Tablespace Management, User Management Monitoring, Backups, and Tuning).
- Competency in manual testing of User acceptance testing.
- Experience in using Version Manager (SVN, PVCS, and CLEAR CASE, CVS).
- Experienced in all phases of the data base life cycle (DBLC)
- Strong interpersonal skills, ability to interact with people at all levels, and working with offshore/onshore development model. Good communication and presentation skills.
- Experience in implementing project onsite.
- Managing requirement gathering, system analysis & finalization of technical / functional specifications.
- Designing, developing, troubleshooting and debugging of the software.
- Engineering test cases design / strategies for design verification / product validation.
- Preparing / reviewing the functional requirement document.
- Conducting tests & maintaining required documents.
- Reporting project progress; rendering technical guidance to project team.
- Supporting senior database administrator in regular DBA activities.
- Delivering & implementing project as per scheduled milestones. Ensuring compliance to quality standards.
- Providing post-implementation, application maintenance and enhancement support with regard to the product / software application.
TECHNICAL SKILLS:
Langages: SQL, PL/SQL, TSQL,Java
OS: Windows,UNIX
Data base: Oracle 9i/10G/11G
ETL Tools: Power Centre(9.1,9.5.1)
Data M dling: MS Visio 2005,ERwin
MDM: Informatica MDM(XUSP2,9.1,9.5.1,9.6.1)
Data Quality: Informatica Data Quality(9.1,9.5.1)
Querying Tools: SQL Plus, TOAD, SQL Navigator, Query Analyzer, Oracle Developer
Versioning Tool: JIRA, PVCS, SVN, CVS
Scripting: Shell Scripts
PROFESSIONAL EXPERIENCE:
Confidential
Senior Consultant
Responsibilities:
- Gathering functional and technical requirements as inputs into the overall solution design.
- Worked as a Team Lead for a group of 2 members.
- Understand the business rules on match and merge
- Convert business match rules into MDM configurations
- Configure Security settings based on roles to restrict access to specific features in MDM HUB
- Designing the data modal
- Enriching Dun and Bradstreet Customer Data.
- Develop match rule set.
- Add New Source Systems in MDM HUB.
- Created new Staging table In MDM HUB side.
- Created new base objects in MDM HUB.
- Define Relationships in MDM HUB for drill downs.
- Create New Cleanse Functions and Cleanse List In MDM HUB.
- Create new mappings in MDM HUB for stage load.
- Configure Trust settings in MDM HUB w.r.t to the business logic.
- Define Validation Rules in MDM HUB to handle the trust score.
- Define Match Rules & Match Merger Configuration.
- Define Merge configurations in MDM HUB from multiple ORS schemas.
- Extract MDM configurations into XML for deployment using MDM HUB.
- Code promotions from one environment to other using MDM HUB change list.
- Implementing SIF packages to create and consume MDM web services.
- Tuning the match and merge rule set.
- Creating scripts (PL/SQL) for the migration of data from MDR files to landing table.
- Writing User Exits (UE) using PL/SQL.
- Installation & Configuring the Address Doctor.
- Tuning the Pl/SQL packages.
- Used DVT tool for validation.
- Refreshing of QA and Dev by Prod metadata.
- Running the Test cases against the new changes.
- Installation of HF1 and HF2 (Patch).
- Installation of MDM 9.0.1 on Dev and QA environment
- Participated in Assessment (MDM 9.0.1 to MDM 9.5.1)
- Participated in upgradation (MDM 9.0.1 to MDM 9.5.1)
- Design/Develop Scripts and utilities to aid performance analysis to benchmark the application performance in various instances.
- Done data profiling using IDQ.
- Involved in production support activities of MDM.
Tools: Oracle 11g, Sql Developer, OEM, Shell Scripting, Cron Tab, CVS, Erwin, Linux, Informatica MDM 9.5,9.1,XUSP2,DVT,Power Centre,IDQ
Confidential
Senior Consultant (Informatica MDM/DBA/Oracle Developer)
Responsibilities:
- Gathering functional and technical requirements as inputs into the overall solution design.
- Estimating and planning work for all phases of the software development lifecycle.
- Providing consultancy to install Informatica MDM 9.1 and associate Software like JBOSS, Oracle client.
- Participating in process and functional design activities, carrying out application design, build, test, and deploy activities for Siperian MRM and all integrating applications.
- Created MDM HUB from the scratch taking all the inputs from the business people.
- Created base objects, stage tables, landing tables in MDM HUB.
- Created Validation rules w.r.t to the source system.
- Added new source system in MDM HUB.
- Create New Cleanse Functions and Cleanse List in MDM HUB.
- Create new mappings in MDM HUB for stage load.
- Created new set of match rules in MDM HUB for data consolidation.
- Worked on IDD configuration.
- Create New Subject Area Group.
- Create New Subject Area.
- Add Dependent SAGs.
- Configure Display Settings, Required and Hidden settings Subject Areas.
- Configure IDD Cleanse Functions.
- Configure Match Rules and Cleanse Function settings in IDD.
- Configure Dashboards in IDD.
- Configure new IDD Display Packages & Queries in MDM Hub.
- Create new roles.
- Configure Security access settings as per the business requirements.
- Populate data in IDD controls from database based on conditions.
- Customize external custom Java routines and call them from IDD interfaces.
- Done data profiling using IDQ
- Invoke IDQ AddressDoctor Components from IDD applications.
- Driving user acceptance test planning and execution.
Tools: Oracle 11g, Sql Developer, OEM, Shell Scripting, Cron Tab, CVS, Erwin, Linux, Informatica MDM 9.5. Power Centre, IDQ
Confidential
Lead Oracle Developer/ETL Architect /Oracle DBA
Responsibilities:
- Requirement gathering from client side.
- Preparing technical specification.
- Worked as a Team Lead for a group of 3 members.
- Developing Data modals using Erwin.
- Created Interface using Package, procedure and function.
- Created external table for loading the flat file into the data base.
- Used Bulk Collect feature of oracle for speeding the process.
- Used Oracle Partition feature to improve the performance and parallelism.
- Created and reviewed database objects.
- Created Star schema using Fact and Dimension tables.
- Perform DBA Task like creating table space, taking the backups, Creating the objects, role.
- Develop interface for batch logging and error logging.
- Tuning of Database and PL/SQL Packages.
- Worked extensively on providing detail Database analysis in terms of sizing( Capacity Planning).
- Implemented Disaster-Recovery techniques
- Performed SQL tuning by using Explain Plan and Tkprof.
- Mentored in-house DBAs to assume higher levels of responsibility.
- Analyzed Database Performance based on Statspack and AWR report results
- Created Shell Script for calling the interfaces into LINUX Environment.
- Automated the whole process using cron tab
- Copy data from legacy oracle databases to Netezza (NZ) databases.
- Created interface using nzsql.
- Loaded flat files using nzload utilities or External table.
- Developed ETL scripts using nzsql.
- Preparing test cases for unit testing purpose.
- Generating script for the load test plan.
- Bug fixing in the existing code.
- ResponsibilitiesResponsible for understanding Business Process and managing with Business users to meet specific client requirements.
- Responsible for documenting functional and technical requirements and translated requirements into system solutions.
- Worked as a Team Lead for a group of 6 members.
- Identified the Facts and Dimensions using Erwin Data modelling tool to represent the Star Schema Data Marts.
- Worked on Erwin for Logical / Physical data modelling and Dimensional Data Modelling.
- Develop processes for cleansing, transforming, extracting, integrating and loading data with use of Data stage.
- Responsible for using different types of Stages such as Capture change Joins, Hashed File, Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs.
- Extensively used Teradata SQL Assistant to extract data from Data warehouse.
- Worked on Teradata insert, Update and Upsert SQL to transform and Load Summary tables built on Core Data Warehouse using BTEQ.
- Developed BTEQ scripts to extract data from the detail tables.
- Responsible for setting up jobs to load data into the warehouse.
- Extensive use of Teradata Utilities - MultiLoad, BTEQ, Fastload.
- Run explain on SQL scripts to analyze query performance and take actions as needed.
- Created tables, temporary tables and views as required.
- Performed field level compression on tables.
- Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences.
- Extensively worked on the Performance Tuning of mappings, ETL Procedures and process.
- Bug fixing in the existing code.
- Worked closely with Testing team and helped in testing the mappings, workflows and writing the scripts.
Tools: Oracle 11g, TOAD, Shell Scripting, MESTRO, clearcase, Linux.
Confidential
Oracle Developer/Oracle DBA
Responsibilities:
- Requirement gathering from client side.
- Preparing technical specification.
- Created Interface using Package, procedure and function.
- Tuning the pl/sql procedure (Performance Tuning).
- Used analytical function to populate data (LAG AND LEAD).
- Created Partition of tables (Range, List).
- Created and reviewed database objects.
- Used Bulk Collection.
- Created Triggers on table to force constrain.
- Extracted data into Oracle table using SQL*LOADER and external tables.
- Used Erwin for data modelling.
- Created Shell Script for calling the interfaces into LINUX Environment.
- Worked with the materialized view (Fast Refresh).
- Creating Technical Specifications for the project.
- Used Oracle Stream for replication of data (only DML).
- Used Dblink to connect with remote machine for data transfer.
- Used UTL FILE for creation text file and.
- Automate the process by using MESTRO.
- Perform DBA Task (like creating tablespace, Space Management, Monitoring).
- Used OEM for managing the database.
- Creating Universe (Business Object).
- Resolving loop issue in Universe.
- Bug fixing in the existing code.
- Preparing test cases for unit testing purpose.
Tools: Oracle 11g, TOAD, Shell Scripting, MESTRO, PVCS, Erwin, Linux..
Confidential
Oracle Developer / Oracle DBA/ETL/Data Integrator
Responsibilities:
- Requirement gathering from client side.
- Preparing technical specification.
- Used Erwin for data modelling.
- Writing PL/SQL Block (Function, Procedure and Package) to implement business logic.
- Used materialized view.
- Created Partition of tables (Range, List).
- Created flat file using UTL FILE package.
- Tuning the data base and pl/sql procedure (Performance Tuning).
- Worked extensively on providing detail Database analysis in terms of sizing( Capacity Planning).
- Implemented Disaster-Recovery techniques
- Performed SQL tuning by using Explain Plan and Tkprof.
- Mentored in-house DBAs to assume higher levels of responsibility.
- Analyzed Database Performance based on Statspack and AWR report results
- Created Shell Script for calling the interfaces into LINUX Environment.
- Automated the whole process using cron tab
- Used OEM for managing the database.
- Taking Backups of database using RMAN.
- Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
- Designed database schema including design of tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
- Created and reviewed database objects, developing PL/SQL Packages Procedures, Functions, Bulk Collection, Triggers, Views and Batch Process.
- Extracted data into Oracle table using SQL*LOADER and external tables.
- Used Perl Script.
Tools: Oracle 10g, SQL Developer, Shell Scripting, MESTRO, SVN, Eclipse, OEM, Linux.
Confidential
Oracle Developer/ETL Developer/Oracle DBA
Responsibilities:
- Requirement gathering from client side.
- Preparing technical specification.
- Worked on EXTERNAL TABLE.
- Created PL/SQL Block using (Function, Procedure and Package,triggers) to implement business logic.
- Creating Data Dump using impdp/expdp and Data pump.
- Used Oracle Stream for replication of data (only DML).
- Installation and creation of the databases.
- Creation, altering users and granting them appropriate privileges.
- Applications Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files, etc.
- Taken Backup of database using RMAN.
- Tuning of PL/SQL Package and Database.
- Performed SQL tuning by using Explain Plan and Tkprof.
- Mentored in-house DBAs to assume higher levels of responsibility.
- Analyzed Database Performance based on Statspack and AWR report results
- Created Shell Script for calling the interfaces into LINUX Environment.
- Automated the whole process using cron tab
- Used OEM for managing the database.
- Used Shell Script.
- Preparing technical specification documents.
- Writing PL/SQL Block (Function, Procedure and Package).
- Created Trigger for auditing table changes.
- Configured RMAN (Recovery Manager) for database backup.
- Restore and recovery operations
- Performance Tuning.
- Designing the tables as per the requirements.
- Bug fixing in the existing code.
- Preparing test cases for unit testing purpose.
Tools: Oracle 10g, SQL Developer, Shell Scripting, Cron Tab,OEM, Linux.
Confidential
Oracle Developer/Oracle DBA
Responsibilities:
- Writing PL/SQL Block (Function, Procedure and Package) to implement business logic.
- Tuning the data base and pl/sql procedure(Performance Tuning)
- Worked on EXTERNAL TABLE.
- Worked on Materialized VIEW.
- Performed SQL tuning by using Explain Plan and Tkprof.
- Mentored in-house DBAs to assume higher levels of responsibility.
- Analyzed Database Performance based on Statspack and AWR report results
- Created Shell Script for calling the interfaces into LINUX Environment.
- Automated the whole process using cron tab
- Used OEM for managing the database.
- Worked on UNIX Shell Script to automate the process.
Tools: Oracle 10g, SQL Developer, Shell Scripting, Cron Tab, OEM, Linux.