PROFESSIONAL SUMMARY:

• Over 14 years of Data Warehousing experience in the Design, Development and Testing of ETL methodologies in all the phases of the Data Warehousing and Data Migration life cycle using Informatica PowerCenter 10.2/10.1/9.5/9.1/8.6/ 8.1/7.1/6.2/6.1/5.1.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Excellent experience in data architecture, coordinating with data users, key stakeholders and external vendors to develop and achieve various long - term objectives for data architecture.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Excellent experience in creating and managing Conceptual, Logical and Physical Data Models.
• Significant experience in Dimensional and Relational database design.
• Excellent experience working with Amazon Web Services (AWS) and using various Services related to Storage, Compute, Database, Application Integration, Migration & Transfer, Networking and so on.
• Excellent experience working with Informatica Intelligent Cloud Services (IICS) and using Cloud Data Integration Services and Cloud Application Integration Services for performing Cloud development in Informatica Cloud.
• Experienced in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Significant experience in MicroStrategy Administration and MicroStrategy Report Development.
• Experience using Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) to perform Data Quality, Data Profiling, Data Validation and Data Cleansing.
• Expertise in Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions.
• Excellent experience in designing and developing Reporting System using MicroStrategy, Business Objects, OBIEE and SSRS.
• Excellent with PL/SQL, T-SQL, Stored Procedures, Packages, Database Triggers and SQL * Loader.

  Experienced in UNIX Shell Scripting and Perl Scripting.

• Excellent knowledge of operating systems and databases including Windows, UNIX, AS/400, Oracle, SQL Server, Sybase and DB2.
• Detail oriented with good problem solving, organizational, analysis and requirement gathering skills.
• Self-motivated and able to work independently and in groups.

TECHNICAL SKILLS:

Skillset: Informatica PowerCenter 10.2/10.1/9.5/9.1/8.6/8.1/7.1/7.0/6.2/6.1/5.1, PowerExchange 10.2/10.1/8.6, Informatica Intelligent Cloud Services (IICS), Amazon Web Services (AWS), Informatica MDM 9.7/9.5/9.1, IDQ, IDE, SSIS, SSRS, OWB, SharePoint, Erwin r9/V 8/7.3/7.2/4.2/4.1/4.0, Business Objects XI R3/R 2/6.5/6.1/5.0, OBIEE 11.1.1.5, MicroStrategy 10.4/9.4/8.1.1, Oracle 19c/11g/10g/9i/8i, MS SQL Server 2000/2005/2008/2014/2016, Sybase ASE 15/12.5, IBM DB2, AS/400, UNIX, Windows NT/2000, Mainframes Z/OS, OS/390, TOAD, SQL Navigator, UNIX shell scripting, Perl Scripting, PL/SQL, C, C++, COBOL, PVCS, ClearCase, Autosys, CSV and XML files, Oracle Exp/Imp, SQL*Loader utility, Microsoft Office.

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

Sr. Informatica Developer/Cloud Developer

Responsibilities:

• Worked on analyzing the requirements, studied the existing architecture and all the business processes involved in the current system. Analyzed all the source systems along with all the software programs involved in the ETL processes.
• Developed complex mappings in IICS by incorporating all the logic implemented in the PowerCenter mappings as part of the conversion project.
• Developed taskflows in IICS for all the corresponding workflows in PowerCenter by replicating all the sessions in series and parallel like in PowerCenter.
• Developed file-based taskflows for all the workflows with flat-files as sources and implemented all the underlying file-list and file-watcher logic.
• Extensively used almost all the transformations in IICS like Expression, Lookup (Connected and Unconnected), Filter, Router, Aggregator, Joiner, Sorter to attain the required business logic in the IICS mappings.
• Converted all the PowerCenter workflows that had mapping variables, session variables and workflow variables with pre-session and post-session variable assignments to IICS taskflows, by implementing the same logic using temporary fields and assignment tasks.
• Converted the PowerCenter workflows that use parameter files for passing parameters as arguments to scripts executed by command tasks at workflow level, by implementing an approach using dummy mapping and dummy mapping task in IICS which contain the required parameter values.
• Thoroughly tested all the converted mappings in IICS to make sure they are implementing the same logic as the on-premise PowerCenter mappings and working exactly as expected.
• Developed Synchronization tasks with appropriate task operations to synchronize data between multiple sources and targets between on-premise and cloud GBQ database.
• Created documentation of ETL development work with all the converted informatica mappings, sessions and workflows that are developed in IICS.
• Scheduled all the IICS jobs using Tidal Scheduler tool by maintaining all the job dependencies as implemented in PowerCenter on-premise jobs.
• Extensively involved in the production deployment activities by creating cutover plan and the list of assets that were deployed in each sprint. Validated the assets after deployment and performed post-deployment activities.

Environment: Informatica PowerCenter 10.2, Informatica Cloud, IICS Cloud Data Integration, IICS Cloud Application Integration, Google Big Query, GCP Buckets, Oracle 19c/11g, MS SQL Server 2016, Oracle SQL Developer, Flat Files, XML, JSON, Unix KSH, SQL, PL/SQL, Tidal Scheduler, Microsoft Visio, Windows 10/XP/2003.

Confidential, Owings Mills, MD

Sr. Informatica/Business Intelligence Developer/Cloud Developer

Responsibilities:

• Worked on requirements gathering, analyzing the requirements, transforming business requirements to technical specifications and creating Technical Specifications Documents, source to target mapping and transformation documents.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL Server and loading to Oracle target database.
• Performed all the steps required to deploy the developed code, Software Programs and Packages from development environment to higher environments with proper testing in each phase of the deployment.
• Involved in creating Shortcuts to shared folders to access reusable objects.
• Developed various Functions, Stored Procedures and Packages with all the necessary logic to calculate and populate metrics like Allocation Percentage, Fixed Income Turnover Percent, Equity Turnover Percent, Holding Count, Weighted Average Expense Ratios, Allocation Market Value Amount and so on.
• Extensively worked on identifying performance bottlenecks and in the performance tuning of existing informatics mappings.
• Developed Mass Ingestion Tasks in Informatica Cloud to transfer huge volumes of files between on-premise and cloud environments in Amazon S3.
• Developed and scheduled Replication Tasks in Informatica Cloud to create data backups in Amazon RDS instance with Oracle database.
• Created Taskflows in Informatica Cloud to move data from Amazon S3 to Amazon Redshift Data Warehouse for data analysis and Reporting purposes.
• Worked extensively in PL/SQL performance tuning by creating necessary indexes and hints wherever necessary and implementing parallelism.
• Gathered and analyzed the requirements for Reporting and developed Universes and Reports in Business Objects XI 3.1 as per the business needs.
• Developed User Prompts, Conditions and Filters for the reports. Created and maintained Universes using Business Objects Designer tool.
• Developed Web Intelligence and Desktop Intelligence reports in Business Objects. Also created reports by using dynamic SQL, database aggregate tables and lookup tables for improved performance.
• Scheduled all the ETL informatica jobs using Autosys as per the job dependencies provided in the requirement documents by implementing success and failure conditions.
• Scheduled all the Business Objects Reports using Scheduler Infoview and Central Management Console (CMC).
• As part of the Production Support team, provided support to the daily job run cycles in production and addressed any job failures with the appropriate steps as required.
• Implemented necessary steps for the smooth run of the scheduled jobs and automated the steps for job triggering across multiple applications.
• Created documentation of ETL development work with all the informatica mappings, sessions and workflows captured and Reporting development work with all the universes and reports captured per project basis.

Environment: Informatica PowerCenter 9.5/10.2, Informatica Cloud, IICS Cloud Data Integration, IICS Cloud Application Integration, Amazon Web Services (AWS), Amazon S3, Amazon Redshift, Amazon RDS, Oracle 19c/11g, MS SQL Server 2016, Business Objects XI 3.1, Oracle SQL Developer, Flat Files, XML, JSON, Unix KSH, SQL, PL/SQL, Autosys, Microsoft Visio, Windows 10/XP/2003.

Confidential, Baltimore, MD

Sr. Informatica Developer/Cloud Developer

Responsibilities:

• Worked as a Senior Informatica/Business Intelligence Developer and was involved in business analysis, requirements gathering, transforming business requirements and creating source to target mapping and transformation documents
• Designed Complex mappings using various transformations like Expression, Lookup (Connected and Unconnected), Filter, Router, Aggregator, Update Strategy, Joiner, Sorter, Normalizer to attain the required business logic in the mappings.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Connected, Unconnected lookup and Stored Procedure transformations and pre & post load SQLs and commands.
• Used Informatica Developer and Informatica Analyst for analyzing, profiling, validating and cleansing data.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• As a prototype for testing performance and functionality, created Masking tasks in Informatica Cloud to load masked data to Amazon RDS instance with Amazon Aurora database.
• Developed mappings and Mapping Tasks in Informatica Cloud to load data from multiple Oracle schemas to Amazon Redshift Data Warehouse which was used as a high performance DW for Reporting needs.
• Developed and scheduled Taskflows in Informatica Cloud containing Mapping Tasks, Synchronization Tasks and Replication Tasks.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Developed PL/SQL Procedures, Functions, Packages, SQL scripts, Materialized views, Sequences and Triggers.
• Extensively worked in SQL, PL/SQL, Query performance tuning, created DDL scripts, created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Developed Schema ObjectsFacts, Attributes, and Hierarchiesusing respective editors in MicroStrategy Developer tool.
• Created application objects like metrics, filters, prompts, templates and reports.
• Played key role in creating Advanced Prompts,Conditional, Transformation metricsand Level Metrics for creating complex reports.
• Created base formulas for all the metrics to make the metrics reusable for future use.
• Developed MicroStrategy Web Reports, Documents and Dashboards as per the reporting requirements.
• Created Report Services Documents out of existing reports and customized them to reflect the corporate logos and color palette.

Environment: Informatica PowerCenter 9.1/10.1, Informatica Cloud, IICS Cloud Data Integration, IICS Cloud Application Integration, Amazon Web Services (AWS), Amazon S3, Amazon Redshift, Amazon RDS, Amazon Aurora, MicroStrategy 10.4, Erwin r9, Oracle 11g, MS SQL Server 2014/2016, TOAD, SSIS, SSRS, SharePoint, Informatica MDM, Oracle SQL Developer, Flat Files, UNIX Shell Programming, Windows NT, Mainframes OS/390.

Confidential, Baltimore, MD

Data Architect/Sr. Informatica Developer

Responsibilities:

• Worked with data users and key stakeholders to develop and achieve various long-term objectives for data architecture.
• Worked on identifying and collecting all required data, validated processes and recommended improvements to corporate data.
• Analyzed the movement of data and administered mapping of all data sources to ensure appropriate quality of all data.
• Analyzed information flow and recommended appropriate technology to provide support to all business processes.
• As a data architect, developed key metrics for tests on data and ensured data integrity across all subject areas.
• Designed and developed the Logical and Physical data models using Erwin V8.
• Worked with Business Analysts and Domain Experts to get the business needs and analyzed the business requirements before implementing the ETL solutions.
• Developed complex mappings using Informatica PowerCenter 9.1.0 to load the data from various sources like flat files, SQL Server, Oracle into the target Oracle Data Warehouse.
• Developed reusable transformations, mapplets, sessions, worklets to make Informatica code very modular and to reuse as required
• Extensively used various transformations like Expression, Lookup (Connected and Unconnected), Filter, Router, Aggregator, Update Strategy, Joiner, Sorter, Normalizer to attain the required business logic in the mappings.
• Used tasks like Command, Decision, Event Wait, Event Raise, Assignment and Timer in the workflows and worklets to meet business requirements logic effectively.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Created Queries, Query Groups and packages in MDM Hub Console.
• Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
• Extensively worked on identifying performance bottlenecks and in the performance tuning of ETL Processes.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Worked closely with the OBIEE Reporting teamand Database Team to coordinate the Necessary Data movement.
• Involved in developing Reports and Dashboards in different Analytical Views (ticker, narrative, column selector, view selector, legend, funnel Pivot Table, Chart) to visualize data in different perspectives using OBIEE Answers.
• Involved in performance tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views and aggregate tables.

Environment: Informatica PowerCenter 9.1.0, Oracle Warehouse Builder (OWB), OBIEE 11.1.1.5, Informatica MDM, Erwin V8, Oracle 11g, MS SQL Server 2008, TOAD, Oracle SQL Developer, Flat Files, Unix KSH, SQL, PL/SQL, Microsoft Visio, Windows XP.

Confidential, Newark, NJ

Sr. Informatica Developer

Responsibilities:

• Involved in the conversion of Customer Accounts and associated contacts from Confidential Legacy Order Management and Billing systems to SAP during multiple Waves of implementation of B2CC.
• Involved in the Conversion of Open AR from Confidential Legacy AR systems to SAP during multiple Waves of implementation of B2CC.
• Designed Complex mappings using various transformations like Expression, Update Strategy, LookUp, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Normalizer and Transaction Control.
• Extracted data from Oracle, Sybase databases and also from flat files to produce the target files which were termed as the Golden Files that were loaded into SAP.
• Developed Data Quality Plans in Informatica Data Quality Workbench with all the Data Sources, Operational Components and Data Sinks to perform Data Quality and Profiling.
• Analyzed and resolved issues to solve problems in Extraction, Transformation and Loading (ETL) Processes, especially in transformation and mapping development.
• Proposed changes to the existing ETL transformations, mappings, programs and procedures for meeting the business requirements more effectively with very efficient overall performance.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs.
• Identified performance bottlenecks and resolved those issues by Query optimization, dropping Indexes and Constraints, bulk loading.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Used Normalizer transformation to split data (single rows with multiple columns into multiple rows of data) and thereby creating perfectly aligned fixed width target files that are suitable for SAP Custom program to load data into SAP.
• Developed Error Handling mechanism in Informatica using Lookup, Expression, Normalizer and Filter transformations by generating Error Codes and Error Messages for various error scenarios and passed clean data into the next level.
• Loaded data into SAP using SAP Custom Programs and Transaction codes.
• Involved in preparing high-level design, testing and ETL Mapping Specification documents.

Environment: Informatica PowerCenter 8.6.1/9.0.1, Erwin 7.3, SAP Front End, Oracle 11g/10g, MS SQL Server 2005, Sybase ASE 15, TOAD, Aqua Data Studio, Control-M, Oracle SQL Developer, Flat Files, Unix KSH, SQL, PL/SQL, Microsoft Visio, Windows XP/2003.

Confidential, Rockville, MD

Sr. Informatica Developer

Responsibilities:

• Worked with Business Analysts to identify business rules for data migration and parsed design specifications to simple ETL coding following mapping standards.
• Performed impact analysis, identified gaps and code changes to meet new and changing business requirements.
• Involved in the installation, configuration and maintenance of Informatica on Unix environment to provide various ETL solutions to support business requirements.
• Designed and customized data models for Data warehouse supporting data from multiple sources in real time.
• Populated data into staging tables, dimensions and fact tables using type-1 and type-2 SCD strategy from flat files, XML sources and Relational Sources and applied business logic in the mappings for inserting and updating records.
• Worked with Connected, Unconnected lookup and Stored Procedure transformations and pre & post load SQLs and commands.
• Used tasks like Command, Decision, Event Wait, Event Raise, Assignment and Timer in the workflows and worklets to meet business requirements logic effectively.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization and Explain Plan utilities for Optimum Performance.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Applied appropriate field level validations like date validations and default values for cleansing the data and Involved in designing an error handling strategy for data validation and error reporting.
• Involved in developing test plan cases, documented test cases and test plan queries for all the tables involved. Also, involved in preparing migration checklists in a timely manner meeting conversion schedules for effective cutovers.
• Involved in labeling and migrating the mappings and workflows from Development to QA and Production environments using pmrep.
• Used Informatica Scheduler and UNIX cron tab to schedule and run workflows using PMCMD.
• Assisted Support team in completing design and code review and worked with production support team in solving complex technical issues.

Environment: Informatica PowerCenter 8.6.1/9, PowerExchange 8.6.1/9, Erwin 7.3, Oracle 10g, MS SQL Server 2005, TOAD, Oracle SQL Developer, DB2 UDB 8.1, VSAM files, Flat Files, Control-M, Unix KSH, SQL, PL/SQL, Microsoft Visio, ClearCase, Windows XP/2003, IBM Mainframe.

Confidential, Weehawken, NJ

Informatica Developer

Responsibilities:

• Involved in gathering the business requirements from the business team and developing the data model comprising all the required entities and attributes.
• Involved in developing the logical model using Erwin 7.3 based on the requirements given.
• Involved in developing the physical model with all the required data types and necessary subject areas.
• Created all the required fact, dimension and lookup tables in the data model.
• Developed mapping document to map the source and the target columns and various transformations required from source to target.
• Developed the required Datamaps using PowerExchange Navigator with the associated Mainframe files and copybooks.
• Imported the PowerExchange Datamaps as source definitions in Powercenter Designer and created the necessary mappings.
• Created mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created complex Slowly Changing Dimension (SCD) mappings to insert new records, insert changed records and update changed records using Lookup, Router and Update Strategy transformations.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Involved in creating Shortcuts to shared folders to access reusable objects.
• Used Workflow Manager and workflow Monitor for creating, running and monitoring workflows and worklets.
• Involved in fixing invalid Mappings, Unit testing and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Involved in scheduling the Informatica jobs using Autosys by preparing the necessary Autosys JIL files with all the job dependencies and file watchers.
• Used PL/SQL programming to develop stored procedure functions and Database Triggers including standard packages.
• Collaborated with various project teams like the Architecture team, Development team and the Release team, providing inputs on design recommendations, developing plans to execute effective transition and migration to QA and Production environments.

Environment: Informatica PowerCenter 8.6.0, PowerExchange 8.6.0, Mainframe files, Oracle 10g, IBM DB2 UDB V8.2, MS SQL Server 2005, Erwin 7.3, COBOL, PL/SQL, SQL * Loader, PVCS 8.2, Autosys, UNIX Shell Programming, UNIX (Solaris), Windows NT, Mainframes OS/390.

Confidential, New York, NY

Informatica Developer/Data Modeler

Responsibilities:

• Worked closely with Business Analyst and Domain Experts in order to establish and document business needs for data.
• Involved in transforming business requirements in to Conceptual, Logical data models.
• Conceptualized and Designed Logical and Physical Data Models for the reporting requirements which integrated both Thomson and Reuters using Erwin 7.2.
• Created super type and sub type entities and Category entities.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Assisted in the Design and Development of Data Warehouse and Operational Data Stores utilizing Dimensional Data Modeling, OLAP and ETL concepts.
• Involved in installing and configuring of Informatica on Unix. Also involved in backup, recovery, tuning of application, stopping and restarting the services.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Extracted data from different sources like Oracle, SQL Server and Flat files, implemented business logic and loaded into the target Warehouse (Oracle).
• As the project was about Thomson and Reuters integration, data from Reuters used to come in flat files, which was loaded into the staging area, followed by the load of combined Thomson and Reuters data into the facts and dimensions for reporting purposes.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Defined Target Load Order Plan for loading data into Target Tables.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Involved in designing and developing Reporting System using Business Objects XI R2/R3.
• Created and maintained several custom reports for the client using Business Objects.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica PowerCenter 8.1/8.6, Flat files, Oracle9i, MS SQL Server 2005, Erwin 7.2, PL/SQL, Business Objects XI R2/R3, SQL * Loader, UNIX Shell Programming, UNIX (Solaris), Windows NT.

Confidential, Atlanta, GA

Data Modeler/Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
• Designed and developed the Logical and Physical data models using Erwin 7.2 based on the reporting requirements given.
• Defined aggregations required and granularity available and required in DW.
• Developed entity and attribute descriptions and definitions for the models and ensured that conflicts in descriptions and definitions are resolved.
• Defined the PK’s and FK’s for the Entities.
• Involved in the up gradation of Informatica PowerCenter 7.1 to 8.1.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations and aggregation.
• Worked on Informatica Power Center 8.1 - Used Source Analyzer and Target designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in error checking and testing of ETL procedures and programs using Informatica session log.
• Tuned performance of Informatica sessions for large data files by implementing Pipeline partitioning and increasing block size, data cache size, sequence buffer length, target-based commit interval.
• Involved in designing and developing Reporting System using MicroStrategy 8.1.1.
• Created prompts, metrics, facts and hierarchies at the MicroStrategy level in order to create the ad-hoc reports.

Environment: Informatica PowerCenter 7.1/8.1, Flat files, Oracle10g, MS SQL Server 2000, Erwin 7.2, PL/SQL, TOAD, MicroStrategy 8.1.1, UNIX (Solaris), Windows NT.