Lead Designer & Developer Resume

SUMMARY

Poses rich experience in providing strategic solution on Data Masking, Data Integration, Metadata Management and Data Warehousing projects.
Proficiency in building reusable custom software development.
Very Strong knowledge in RDBMS and file based data load optimization techniques.
Extensively involved in design and development of many data management projects using Informatica Power Center Tool, Unix and Perl scripting.
Possess good communication and interpersonal skills and ability to Lead multiple projects simultaneously
Discover new approaches, learning new methods and ideas and putting them into daily practice
Self - motivated team player with an interest of working in a team environment

TECHNICAL SKILLS

Operating System: Windows XP, SUN OS, Linux

Environment: UNIX Server environment, Windows client environment

Database: Oracle 10g, Tera data (Trained), DB2, DB2 - Mainframe, Sybase, MSSQL

BI/Data warehousing Tools: Informatica 8.6.x, Data Stage 7.x, Business Object 6.x, Cognos 8

Profiling Tool: Axis DMSuite 3.4, Informatica Data Explorer 9.0.x

Other: Erwin,, Perl

PROFESSIONAL EXPERIENCE

Confidential

Lead Designer & Developer

Responsibilities:

Interact with application’s owner to understand the upstream and downstream data sources.
Build RegEx Engines to identify sensitive data pattern based on data source metadata.
Design and develop new mapplets using Informatica Power Center tool
Develop custom tools and software for automation of data masking functional workflows using Shell and Perl scripting languages.
Deploy the data masking code into centralized repository using the Metadata Driven migration software specifically designed for data masking code migration.
Execute dry run against production system in order to ensure the software is working as expected in the production environment.
Transition the knowledge to support team on each data masking application and guide them for few weeks to make them understand the environment so that they can take it further and provide continues support and maintenance.
Design and develop monitoring software so that status of various data masking execution can be monitored from a single window by support team.

Environment: Informatica 8.6.1, DB2, Sybase, MSSQL,Teradata,File systesm, Linux and Perl

Confidential

Designer & Developer

Responsibilities:

Design and development on ETL Processes using Informatica 7.1
Develop PL/SQL code to load varies kind of data to EDW environment
Develop UNIX script to invoke Informatica workflow and PL/SQL codes
Perform varies type of Testing such as Unit Testing, Quality Assurance Testing etc..,

Environment: Informatica 7.1, Oracle 10g, UNIX.

Confidential

Developer

Responsibilities:

Environment: Informatica 7.x, Oracle 10g

Confidential

Developer

Responsibilities:

Perform Extraction, Transformation and Loading from source to target system using Informatica 7.1
Loading data from staging area to data warehouse by designing appropriate mappings
Responsible for designing, coding and testing the mappings
Responsible for tuning performance in mapping
Designing mapping with the use of slowly changing dimension

Environment: Informatica 7.1, oracle 9i, Windows XP

Confidential

Developer

Responsibilities:

Importing Source/Target tables from the respective databases and create mappings using Informatica designer Tool
Responsible for data Extraction, Transformation and Loading from source to target system using Informatica Power Center
Loading data from staging area to data warehouse by designing appropriate mappings
Perform various types of testing for Informatica mappings/workflows

Environment: Informatica 7.1, oracle 9i, Windows XP.