SUMMARY

• Certified Collibra Developer/Architect with expertise in driving end to end Collibra implementations and adoption. Design Operating Models, Develop BPMN Workflows and Implement Collibra Connect.

TECHNICAL SKILLS

• Collibra DGC, Collibra DGE, Informatica MDM, Informatica Power Exchange, SqlServer Management Studio 2012/2008, Dimensional Data Modeling(StarSchema Modeling
• Snowflake Schema Modeling, FACT, Dimensions Tables), SQL Navigator, DB Artisan, Cognos, Oracle BI tools, OBIEE 10.1.3.1, Siebel Analytics
• Business Objects (Web - Intelligence 2.5, Designer 5.0, Crystal, reports and Developer Suite & Set Analyzer 2.0), SQL, PL/SQL, T-SQL
• C, VB 5.0, Java, Unix Shell Scripting, Oracle 10g/9i/8i, MS SQL Server 2012/08/05, Teradata, IBM DB2, MS Access, TOAD 8.6, SQL plus, Query Analyzer, SQL Assistant

PROFESSIONAL EXPERIENCE

INFORMATICA METADATA DEVELOPER/LEAD

Confidential

Responsibilities:

• Create operating model (Asset Types, Attributes and Relations) and define DG roles and responsibilities.
• Trained Stewards and business users on Collibra Data stewardship.
• Customize dashboards, Customizing UI, Logo and Styles, Email templates for approval workflow, notification email styles.
• Develop/customize BPMN Workflows as per the client requirements. to customize and leverage issue management workflow in Collibra
• Develop IMM2DGC connectors to extract data lineage from Informatica or IBM and link to business assets in Collibra.
• Extract data quality rules, DQ results, profiling results and score carding summary and populate in Collibra.
• Responsible for capturing end-to-end data lineage for CCAR related data elements, Lease and Loan related Key data elements.
• Working on setting up Informatica Metadata manager and co-ordinate with IT/Admin to load databases required for creating metadata links.
• Responsible for building automated data lineage in Informatica Metadata Manager tool and create links between data elements.
• Create and update documentation for end to end Metadata Management process flow.
• Reverse engineer the databases and capture trace
• Create Data Dictionary for all required CCAR FRY 14Q schedules and obtain Business Description of CCAR Metrics.
• Validate Business Metadata, populate Metadata in Collibra. Migrate Metadata to Test and work with QA team to validate in Test, migrate Metadata to Prod.

INFORMATICA DEVELOPER/LEAD

Confidential

Responsibilities:

• Involved in translating business requirements to integrate into existing data mart design.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
• Built Siperian Informatica MDM Hub to generate the Master copies of business data and configured IDD using SIF API's to make these Master records available for downstream applications.
• Migration of siperian objects from Dev to QA and to Production environments.
• Migrated the Oracle Pl/SQL backend siperian Packages, Procedures and Functions from Siperian XU Patch B to Siperian 9.1
• Involved in System analysis, Estimations and design for enhancements.
• Leading as a technical lead by providing ETL Technical/Functional documents.
• Troubleshooting and fine tuning of mappings for maximum.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
• Interacted DBA team to make sure application data base and also created all necessary data base objects for our project in Dev and Test Environments.
• Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
• Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
• Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
• Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
• Working on Informatica Developer(Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
• Worked on writing Pl/Sql procedures in Oracle and captured those by using Informatica stored Procedures.
• Generated Scorecards based on profile results
• Done single table structure profiling, cross table structure profiling.
• Created Data quality mappings (plans) and exporting those to power center as mapplets.
• Created Rules on profiled data and used the same to data quality mappings.
• Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.
• Developed BI reports comprising line and pie charts, trend analysis reports and sub-reports according to business requirements, using SQL Server Reporting Services (SSRS).
• Developed several stored procedures using T-SQL for data manipulation.
• Upgraded Informatica 9.5.1 Standard Edition to Informatica 9.6.0 Advanced Edition successfully without any defects/issues for 4 Environments. Configured Repository Service, Integration Service, Web Service, Model Repository Service, Data Integration Service, Analyst Service, Content Management Service, Metadata Manager Service.
• Developed database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Environment: Informatica MDM 9.7.1, Hierarchy Manager, Informatica Data Director, Informatica Metadata Manager, Informatica Developer9.0.1, Informatica Analyst9.0.1, SQL Server, SAS. Informatica 9.6.0 & 9.5.1, SSRS, SSIS, Informatica Data Quality 9.6.0 & 9.5.1, Oracle 11g, UNIX, MS SQL Server, MDM, Teradata, MS Access, PL/SQL, My SQL and flat files, HP ALM.

ETL Developer

Confidential

Responsibilities:

• Analyzed the systems, architecture, met with end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 6.x.
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load the data from Staging area to DW.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data.
• Responsible for creating DLL for report design in HTML format and calling them from ASP pages to provide more security for Crystal Reports.
• Involved in the Performance Tuning.
• Created and ran sessions and workflows using Workflow Manager.
• Monitored the sessions and workflows using Workflow Monitor.
• Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.

Environment: Informatica PowerCenter 7.1 (Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 9i, DB2, Sybase, Cobol files, MS SQL Server 2005, TOAD, UNIX, PL/SQL, SQL Loader, Windows 2000/XP

Database Developer

Confidential

Responsibilities:

• Written SQL Queries for handling data in the database.
• Maintaining the data coming from the OLTP systems.
• Tuned the database queries to improve the performance of the query and indexing strategies.
• Coded database triggers to record the changes made to the database objects.
• Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
• Document the work performed each day.
• Helped coding shell scripts for database scripting.
• Establishing an application's security measures during development of Application in collaboration with DBAs.
• Involved in Physical schema implementation, objects like table-space, table rollback segments.
• Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security.
• Maintained system security, control and monitor user access to database
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Oracle 9i, SQL Plus, PL/SQL, T-SQL, Windows XP