Devendra Patel Email & Phone Number

Buffalo, Ny, Us

Greater Minneapolis-St. Paul Area

- Involved in Requirement Gathering and Business Analysis and created tech specs for ETL process.- Developed a Design document from business requirement document. - Created and reviewed maps, maplets, sessions and workflows from the offshore team. - Handle the Migration process from Development, Integrated Test, and Production Environments.- Played a technology lead role in the multiple projects. Managing 5 team members. - Coordinate with the offshore team regularly in sharing the project details and build status.- Involved in design, development, and maintenance of database for Data warehouse project.- Worked as a senior resource to support/maintain the Enterprise Data Warehouse (EDW) consisting of 30 plus upstream & downstream applications and various inbound/outbound data feeds. - Support IBM MDM application for six months for regular monitoring, failure recovery, ad-hoc processing.- Provided production support and resolved the issues promptly. Also worked on maintenance/enhancement items, and defining the process/standards of code migrations to production.- Involved to resolve data quality tickets, production failure tickets, data validation and maintenance of current ETL processes.- Scheduled jobs as per the requirements using Workflow Manager along with Zena Job scheduler.- Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre, and post stored procedures to drop and build constraints.

Buffalo/Niagara, New York Area

- Developed Data Flow diagrams to create Mappings and Test plans. Specifically these data flow diagrams ranged from OLTP systems to staging to Data warehouse. - Responsible for identifying reusable logic to build several Mapplets which would be used in several mappings. - Created mappings to extract and de-normalize (flatten) data from XML files using multiple joiners with Informatica Power Center. - Worked on performance tuning by identifying the bottlenecks in Sources, Targets, Mappings and Transformations and enhanced Performance for Informatica session using large data files by using partitions. - Designed and developed complex interactive OBIEE reports, including prompts, filters, different views (charts, views, filters, tables and bins), drill-down capabilities, navigation links, detailed designing and developing of custom dashboards including customized appearance. - Designed and developed Informatica Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Lookup, Aggregate etc.- Created Unix Script for ETL jobs, session log cleanup and dynamic parameter.- Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.- Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.- Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.- Installed and Documented the Informatica Power Center setup on multiple environments.

Hartford, Connecticut Area

- Involved in design & development of operational data source and data marts in Oracle.- Involved in analyzing source systems and designing the processes for Extracting, Transforming and Loading the data. - Involved in Data Model Design and used best approaches to configure Physical and Logical model. - Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to Oracle. - Worked extensively on bug fixing of the existing mappings, performance tuning for better performance with best performance techniques and making existing objects to adhere to standards set up for the project. - Handled Slowly Changing Dimensions (Type I, Type II, Type III) based on the business requirements. - Reviewed source data and recommend data acquisition and transformation strategy.- Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse.- Designed ETL process using Informatica designer to load the data from various source databases and flat files to target data warehouse in oracle.- Optimized mappings using transformation features like aggregator, filter, joiner, expression and lookup.- Created daily and weekly workflows and scheduled to run based on business needs.- Involved in developing test automation scripts using Perl/Python.

Bothell Wa

- Developed complex Informatica mappings using various transformations - Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.- Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.- Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse.- Extensively used Informatica to load data from MS SQL Server into the data warehouse.- Developed mappings between multiple sources such as flat files, oracle and multiple targets.- Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data. - Created client/server Perl scripts to automate routine processes to check for new incoming data.- Developed Informatica mappings for Slowly Changing Dimensions.- Extensively worked on creating and executing formal test cases, test plans for functional, system and regression testing.

Charlotte, North Carolina Area

- Involved in creation of Technical, Application Interface and User Guide documentation. - Designed, developed Informatica mappings using Informatica 8.5, enabling the extract, transport and loading of the data into target tables and loading into the Teradata.- Work directly with non-IT business analysts throughout the deployment cycle and provide Production Validation Testing and post-implementation support and investigation of data and report issues identified by customers. - Involved in Triage and Outage calls and ensuring the application always available in production environment. - Used Informatica - repository manager create new users, repositories. - Used Informatica Designer for mappings and coding it using reusable mapplets. - Scheduling the session's tasks comprising of different mappings for data conversion, extractions in order to load data into the database. - Created multiple job-aids for recovering the informatica workflow failures. - Implemented effective error handling strategies.

Greater Philadelphia Area

- Extensively used ETL to load data from different relational databases, XML and flat files.- Handle the Migration process from Development, Test and Production Environments.- Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development. - Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations. - Created various UNIX shell scripts for Job automation of data loads. - Extensively involved in the analysis and tuning of the application code (SQL).