SUMMARY

• Over Ten plus years of full life cycle experience in analysis, design and development of Data migration and Data Warehousing applications.
• Translates complex business requirements into Technical Specifications for a highly scalable, large volume enterprise product or solution.
• Drives high - level architectural planning and proof-of-concepts to support important enterprise initiatives.
• Provides inputs to Enterprise Architecture regarding the data volumes, sizing metrics and concurrent end-user activity estimates to compute a capacity plan.
• Establishes standards and best practices for application implementation, tools and technologies.
• Maintains a repository of common or frequently used templates and promotes the usage of these where applicable.
• Data warehousing experience using Informatica with extensive experience in designing the Workflows, Worklets, Mappings, Reusable Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica PowerCenter 9.x/8.x.
• Well versed with the Offshore-Onsite project, Cross vendor work model & Service Management Activities.
• Thorough knowledge of the different stages of a project and aptitude for meeting deadlines, recognizing potential bottlenecks and taking the required corrective action.
• Managing end-to-end service level: controlling that the service meets the agreed performance in terms of the SLA and Operational Level Agreement (OLA).
• Experience in 4 full Life Cycle Implementations, production supports, enhancements and roll out projects.
• Experience in designing and implementing end-to-end BI solution for organizations.
• Strong Exposure in writingSimpleandComplex SQLs, PL/SQL Functions and Procedures, Packagesand creation of Oracle Objects -Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Proficient in writing complex stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
• Worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer and Query man.
• Has been involved in production and user support for Informatica related issues.
• Installed, configured, administered, upgraded and managed the Informatica 9.6.1 multi node grid environment with High Availability.
• Experience in creating Power Center Domain, Grid, Nodes and Services.
• Experience in security administration creating and managing users, groups and roles and assigning privileges.
• Reviews resource estimates for development projects, performs design reviews and assesses contingency/disaster recovery plans.
• Enforces project/solution architectural integrity with appropriate change control, design reviews, development standards and code reviews.
• Involved in folders migration between environments to follow SDLC.
• Has very good experience with Linux/Unix script.
• Handled 8-10 developers in an offshore and onsite model.
• Experience in command line programs such as pmcmd, infacmd, infasetup and pmrep.
• Experience in creating complex mappings using various advanced transformations for ETL needs.
• Used Informatica command line utilities and scheduling tools like Informatica scheduler, Control-M and CA7 to create, schedule and control workflows, tasks and sessions.
• Involved in Disaster Recovery Exercise, Data Archival process for Informatica Infrastructure.
• Good knowledge of Error Handling and Recovery strategies in Informatica ETL environments.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root cause analysis and corrective actions to meet short- and long-term business and system requirements.
• Excellent verbal and written communication skills with ability to interact at all levels of management.

PROFESSIONAL EXPERIENCE

ETL Technical Architect

Confidential

Responsibilities:

• Played the role of a Technical Architect/Lead and is responsible for designing the ETL Strategy & Architecture of the Project.
• Drives high-level architectural planning and proof-of-concepts to support important enterprise initiatives.
• Provides inputs to Enterprise Architecture regarding the data volumes, sizing metrics and concurrent end-user activity estimates to compute a capacity plan.
• Communicate with business users and source data owners to gather reporting requirements and to access and discover source data content, quality, and availability.
• Develop and maintain data architecture artifacts and standards, including data naming, data dictionaries, naming conventions, etc.
• Extraction of test data from tables and loading of data into SQL tables.
• Design automated processes to capture data quality and reasonability parameters of loaded data and for comparing those against baseline versions of data.
• Written PL/SQL stored procedures and Triggers to retrieve relevant information from various tables into intermediate tables.
• Accessed and communicated the impact of planned maintenance activities;
• Maintained documentation, relevant correspondence, customer service related documents and high level network diagrams and information;
• Provided customer training on web portal tools, fault management and escalations procedures, and product offerings;
• Created mappings in Informatica to process the source files and applied business logic rules on the data to load into the warehouse.
• Expertise in Data Modeling, Designing of Logical and Physical Data Models.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Experienced in designing and writing on-demandUNIX shell scripts.
• Enforces project/solution architectural integrity with appropriate change control, design reviews, development standards and code reviews.
• Created Unix Shell scripts to automate the data load processes to the target Data Warehouse.
• Developed SQL Scripts to validate the data after the loading process. Modified and tested PL/SQL stored procedures.

Environment: Informatica PowerCenter 9.6.1, UNIX, Oracle, Shell Scripts, XML format files, Amazon RedShift, REST/SOAP, JSON/XML format files, Salesforce, Microstrategy.

ETL Technical Architect

Confidential

Responsibilities:

• Played the role of a Technical Architect/Lead and is responsible for designing the ETL Strategy & Architecture of the Project.
• Drives high-level architectural planning and proof-of-concepts to support important enterprise initiatives.
• Translates complex business requirements into Technical Specifications for a highly scalable, large volume enterprise product or solution.
• Drives high-level architectural planning and proof-of-concepts to support important enterprise initiatives.
• Provides inputs to Enterprise Architecture regarding the data volumes, sizing metrics and concurrent end-user activity estimates to compute a capacity plan.
• Accessed and communicated the impact of planned maintenance activities;
• Maintained documentation, relevant correspondence, customer service related documents and high level network diagrams and information;
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Provided customer training on web portal tools, fault management and escalations procedures, and product offerings;
• Captures metadata in the Metadata Tool Repository after the project has been delivered.
• Involved in end to end POC from Installing the product to talking to business unit to gather requirements on product information
• Designed the ETL flow for extracting data from legacy systems.
• Installed and configured Informatica grid and high availability.
• Created mappings in Informatica to process the source files and applied business logic rules on the data to load into the warehouse.
• Expertise in Data Modeling, Designing of Logical and Physical Data Models.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Experienced in designing and writing on-demandUNIX shell scripts.
• Enforces project/solution architectural integrity with appropriate change control, design reviews, development standards and code reviews.
• Created Unix Shell scripts to automate the data load processes to the target Data Warehouse.
• Coordinated tasks with onsite and offsite team members.
• Provided 24x7 production support. Trained end users on application.
• Establishes standards and best practices for application implementation, tools and technologies.

Environment: Informatica PowerCenter/Exchange 9.6.1, DB2 on Mainframe, VSAM, Shell Scripts, IBM-AIX, XML and Flat Files.

ETL Technical Lead/Architect

Confidential

Responsibilities:

• Played the role of a Technical Architect/Lead and is responsible for designing the ETL Strategy & Architecture of the Project.
• Translates complex business requirements into Technical Specifications for a highly scalable, large volume enterprise product or solution.
• Drives high-level architectural planning and proof-of-concepts to support important enterprise initiatives.
• Provides inputs to Enterprise Architecture regarding the data volumes, sizing metrics and concurrent end-user activity estimates to compute a capacity plan.
• Performed Data Model updates and enhancements to existing Oracle Designer data models as required using CA/ERWIN tool.
• Accessed and communicated the impact of planned maintenance activities;
• Maintained documentation, relevant correspondence, customer service related documents and high level network diagrams and information;
• Provided customer training on web portal tools, fault management and escalations procedures, and product offerings;
• Extraction of test data from tables and loading of data into SQL tables.
• Involved in end to end POC from Installing the product to talking to business unit to gather requirements on product information
• Creating assortments items, hierarchies, classifications, import/export, etc.
• Designed the ETL flow for extracting data from legacy systems.
• Installed and configured Informatica grid and high availability.
• Created mappings in Informatica to process the source files and applied business logic rules on the data to load into the warehouse.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Experienced in designing and writing on-demandUNIX shell scripts.
• Enforces project/solution architectural integrity with appropriate change control, design reviews, development standards and code reviews.
• Created Unix Shell scripts to automate the data load processes to the target Data Warehouse.
• Developed SQL Scripts to validate the data after the loading process. Modified and tested PL/SQL stored procedures.
• Provided 24x7 production support. Trained end users on application.
• Establishes standards and best practices for application implementation, tools and technologies.

Environment: Informatica PowerCenter/Exchange 9.6.1, DB2 on AS/400, UNIX, SQL Server 2008, Windows 2000, Shell Scripts, Salesforce.

ETL Technical Lead/Architect

Confidential

Responsibilities:

• Played the role of a Project Technical Lead/ETL Architect and is responsible for designing the ETL Strategy & Architecture of the Project.
• Developed full SDLC project plans to implement ETL solution and identify resource requirements.
• Created production, development and UAT domain, which had integration, services.
• Involved in performing Informatica upgrade from 8.6 to 9.1.
• Involved in Resource management. Monitor and manage resources associated with the Informatica environment
• Utilized the CA/ERWIN Case modeling toolfor dimensional Data Marts.
• Conducted several Logical Data Model Reviews for IT projects.
• Involved conceptual, logical and physical data modelling.
• Proficient in Forward engineering and backward engineering of data modelling in Erwin.
• Provide POC for Various Client’s for PowerCenter, IDQ and DVO
• Created and Modified the Perl Scripts according to Change Requests.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Configured Informatica PowerCenter servers to connect to various databases like Sybase, DB2.
• UsedOracle PL/SQLfor implementing business rules and do performance tuning procedures.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Coded variousstored procedures, packagesandtriggersto in corporate business logic into the application.
• Created multiple nodes, integration service, repository service, assigned integration service to grid.
• Created folders, user management, groups and permissions, as well as privilege management
• Involved in Informatica issue resolution, folder migration, Administration and served as the first line of support internally for any Informatica issues raised by the project teams.
• Maintain a library of best practices in order to support knowledge sharing between Informatica architects and developers.
• Responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Involved in Software upgrades plan and manage Informatica software patching and upgrades
• Interface with the support team for enterprise scheduler in order to schedule and monitor Informatica production jobs.

Environment: Informatica 9.1/8.6, Salesforce.com, DB2 UDB version 7, UNIX shell scripts, Control-M scheduler, Power Exchange 9.1, MQC,VSAM, SQL Server 2008, Sybase 15/12.5, Oracle 11g/10g, CA Erwin.

Lead Systems Programmer Analyst

Confidential, Maryland

Responsibilities:

• Played the role of a Project Technical Lead and is responsible for designing, develop and lead the project.
• Designed and implemented HA and DR strategy in line with Informatica standards.
• Involved in performing Informatica upgrade from 8.6 to 9.5.
• Worked on shared platform integration with LDAP.
• Created or updated documentation or webcasts for Best Practices, Policy, User Guides, Security guidelines, and Getting Started.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Coded UNIX awk and sed shell scripts for data migration for the Department of Warehouse Database.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Validating the Archive process to purge the data that meet the defined business rules.
• Assisted setting up capacity management framework (process/tools/metrics).
• Managed/Promoted shared platform for new and existing projects; migrated existing projects to shared platform helping retire kit/save costs/repatriate licenses.
• Established methodology to profile new and existing projects migrating to the shared platform.
• Used Pre session and Post session PL/SQL scripts to drop and recreate indexes on the targets to improve session performance.
• DevelopedPL/SQL Packages, ProceduresandFunctionsaccordance with Business Requirements for loading data into database tables.
• Organized Internal and/or External training sessions; ensured minimum training level for all projects using shared infrastructure. Identified and implemented process to “certify” Shared Platform developers to ensure minimum level of knowledge.
• Helped projects with metadata management, data quality and data profiling needs.
• Also involved in product demos, project performance reviews and design/architecture reviews.
• Member of on call team for Production support.
• Involved in analyzing and solving the production issue tickets.
• Updating weekly status report, Creating Quality related reports etc.

Environment: Informatica PowerCenter 9.5/8.6, Oracle 10g (SQL, PL/SQL), Toad, PL/SQL Developer, SQL Server, UNIX, Flat files (delimited, fixed width, XML), UNIX Shell Script, CA7.

ETL Consultant

Confidential

Responsibilities:

• Worked as an Informatica Consultant.
• As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Created Informaticamappingsusing thedesigner, respectiveworkflowsandWorkletsusing theWorkflow manager toextract, transformandloadsource data from various heterogeneous sources to the associatedFactsand Dimensions.
• Experience in nodes, Repository services and Integration services.
• Create, backup, restore for Informatica Repositories.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Monitoring the Jobs and sever space availability and CPU Process.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Teradata Macros BTEQ, MLOAD, FASTLOAD, FAST EXPORT
• Reviewed Informatica mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful
• Preparing weekly and monthly progress report.
• Involved in Security administration. Managed Informatica users and roles in order to enforce data security, while making sure all users have the necessary access to perform their tasks.

Environment: Informatica Power Center 8.x/7.1, Teradata V2R5, SQL Server, Flat files (delimited, fixed width, XML), Solaris UNIX, Microsoft Visio 2000, Cogno’s, ANSI SQL, XML.