SUMMARY:

• Over 15 years of experience in Software Development Life Cycle, ETL and Data quality, Trading systems, business requirements analysis, application design, development, data modeling, testing of Data ware housing, database systems, SAP and Informatica Cloud services for various projects/clients from conceptualization to implementation. Shorten ramp up time on projects and initiatives by providing proven solutions, a methodology and best practices
• Over 12 years of experience in Financial Industry in Investment Management (Equity and Fixed Income), Asset Wealth Management, Retail Financial Services, Consumer Business Banking and Data Governance Lines of Businesses.
• Experience with data architecting, data mining, large - scale data modeling, data integration and business requirements gathering/analysis for data quality.
• Strong expertise in installing and configuring the complete Informatica MDM suite (Informatica MDM Hub Server, Hub Cleanse, Platform engineering, Resource Kit and Cleanse Adaptors like Address Doctor).
• Proficient in the development of solutions using Informatica MDM Hub
• Created a single, verifiable, consolidated source of data which can be referred across the organization and subsequently to have a single point of entry for all data within the organization into this single source .

TECHNICAL SKILLS:

• RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000, MS Access 9.0/7.0, Teradata 12/13, Sybase, UDB DB2, My Sql
• ETL Tools: Informatica 10.1/10/9.6/9.5.1/9.5/ 9.1/9.0.1/8.6/8.1/8.0/7.1 products (Power Center, Power Exchange, Data Explorer, Data Analyst, MDM,Data Transformation Studio/Informatica Developer, Work Bench, Metadata Manager and Informatica Lifecycle Management),Proactive Monitoring, Ab Initio (GDE, Co-Operating System and Metadata portal Hub), Talend
• BI/OLAP Tools: Cognos 9.0/8.0, Business Objects XI, Hyperion Essbase, Tableau, Oracle Reports.
• Operating Systems: UNIX (AIX, HP/UX), Windows NT/ 2008/2000/2003/ XP/Vista/7
• Data Modeling: Logical/Physical Data Modeling, IBM Rational Rose, ERWIN 7.3.10, Microsoft Visio 2004, 2007,2010
• Languages: SQL, PL/SQL, C, C++, Java, C-shell, K-shell, Perl
• Methodologies: ETL Methodologies/Processes- Data Profiling, Data Quality, Data Services, Change-Data-Capture (CDC), Push Down Optimization (PDO)
• Version Control: Tortoise SVN, Visual Source Safe and Win CVS
• Schedulers: Control M, Autosys, Maestro and Cron
• Other Tools: Toad, Oracle SQL Developer, Embarcadero Rapid sql, Putty, Winscp, Telnet, SFTP, FTP, NDM process, MS Project Planner, Citrix Environments

EXPERIENCE:

Confidential, Irving, TX

Informatica Developer Tool / Data Analyst/IDQ/IDE/Data Quality Lead/ Data Modeler / Solution Architect

Responsibilities:

• Administration: Installation, configuration and administration of all the above products of Version 9.6/9.5.1 on UNIX platform and then applied Hotfix3.
• Metadata Manager: configured Metadata Repository to create the lineage for Erwin data models, Databases consisting of Teradata, Oracle, Sql Server, Power center ETL objects and Business Objects reports.
• Business Glossary: defined and created business terms and categories, rules, usage, data stewards, owners for business terms and finally associated them with data object and produced the lineage.
• Hands on experience using Informatica to integration with SAP HANA.
• Security: Configured users, groups, roles privileges and assigned them to each user group, handled data Securities and automation of schedules and LDAP configuration to sync up with Microsoft Active Directory.
• Created Metadata manager Service, Reporting Service and Table Manager Service in ISP Admin Console to effectively use Metadata Manager.
• Worked on cloud to cloud and on -premise to cloud integration.
• Customization of standard Informatica Meta Model to accommodate a full range of metadata as defined for the collection and storage of Enterprise Metadata.
• Data Quality: Configured, profiled and applied out of box data quality rules provided by the product and helped them in understanding the process along with data.
• Data Dictionaries: Installed and configured content based data dictionaries for data cleansing, parsing and standardization process to improve completeness, conformity and consistency issues identified in the profiling phase.
• Address Doctor: Configured Address doctor content on both PC and IDQ servers and helped users in building the scenarios.
• Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter and Created various data quality mappings in Informatica Data Quality tool and imported them into Informatica powercenter as mappings, mapplets.
• Analyst Tool: Configured Analyst tool (IDE) and helped data stewards or business owners in profiling the source data, create score cards, applying inbuilt DQ rules and validating the results.
• TDM: Configured persistent data masking & Subset to mask the sensitive data.

Confidential, Carrollton, TX

Informatica MDM Architect /Informatica Developer Tool / Data Analyst/IDQ/IDE/Data Quality Lead/ Data Modeler / Solution Architect

Responsibilities:

Responsibilities:

• Installed and Configured Informatica MDM 10.1 hub on Jboss application server
• Worked as an Informatica MDM Architect to install and configure Informatica and MDM suits
• Establish POC of new ideas
• Evaluate Proof of Technology(POT) for new architecture and tools
• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.
• Involved in all phases of the project SDLC planning, design, documentation, configuration, testing activities and code migration..
• Configured Base Object Tables in schema and relationship tables in hierarchies according to data-model
• Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub
• Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse and address doctor functions.
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Working with Hierarchy Manager to develop to Hierarchies as per the business needs.
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Developing Put and Display packages for both Hierarchy Manager and IDD Application.
• Defining the Match and Merge Rules in the MDM 10 Hub by creating Path components, Columns and rules.
• Configured the Automation process for Land, Stage and Load Process (Batch Process)
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase
• Worked closely with the Business in gathering the Match rules and created the Match rule document
• Used Informatica data quality tool to cleanse and standardize the data while loading to staging tables.
• Ran the Match and Merge set up and fine-tuned the Match rules
• Worked Security Access Manager (SAM) for creating roles and assigning users.
• Executed MDM stored procedures and batch groups for MDM hub.
• Apart from the above, we also configured IDD, Reporting & Dashboard services for future utilization of the client needs.
• Integration of MDM Hub with external applications using SIF APIs.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.

Environment: Informatica Platform 10.1,10.0,9.6,9.5.1,Oracle 12G,SQL Server Management studio, SQL Plus, Windows XP and AIX UNIX, Agile Methodology, HP Quality Center, MS Sql Server, SAP Version: 3.1.H, Flat Files, PL/SQL and Unix Scripting.

Confidential

Informatica Cloud implementation

Responsibilities:

• Built the platform to implement Informatica Cloud to extend the advantages of enterprise cloud computing.
• Veeva CRM was built on Salesforce.com to extend the value of their CRM investment through the platform.
• Developed Apps that handles the tasks to perform Data Replication, Data Synchronization, and Data Mapping with Data Transformation logics and scheduled them to run on reoccurring basis.
• Worked on cloud to cloud and on -premise to cloud integration.
• Used my experience of Data Quality techniques in building the Apps with Data Assessment, Scorecards and Data Masking.
• Used available transformation to build complex mappings to load the data into salesforce analystics.

Environment: Informatica 9.6, MDM 10 and 10.1, Cloud, Oracle 11G, Agile Methodology, MS Sql Server, Flat Files, SAP, Informatica Cloud Services.