SUMMARY:

• Confidential has over 10 years of consulting experience in which he has worked mostly with the Informatica understanding the whole life cycle.
• His jobs roles are as follows: Informatica developer, Sr. Informatica Architect, ETL Lead and Informatica Administrator.
• He also worked as a Teradata consultant, Confidential possess a strong ETL background that will help identify solutions and implement technology to achieve the desired solution for most Data warehouses.
• Confidential is Teradata Certified Professional.

TECHNICAL SKILLS:

Skills: ETL Administration and Development 9 Years Informatica Power Center 7.1, 8.1, 8.6.1, 9.5 9.6.1 9 Years Oracle 9 Years SQL Server Integration Services (SSIS) 8 Years Unix Shell scripting 8 Years PL/SQL, Stored Procedures 7 Years Teradata 6 Years Hadoop 1 Year

PROFESSIONAL EXPERIENCE:

Confidential , Seattle, WA

ETL Lead/Technical Lead

Responsibilities:

• Admin work on all servers Prod, Dev, Test. HA(High Availability) implementation for Informatica Powercenter 9.6.1 MDM upgrade implementation to version 9.7.
• Technical documentation of the full deployment process of all Powercenter environments from Dev to Test to Pre - Prod and Prod. In charge of all SLA projects going on with my team and communications with PMs of all projects assigned.
• Writing up estimates for projects and getting resources from both off-shore and on-shore to complete the projects. In charge of all hours worked from team members.
• Understanding on a high level what projects each team member is working on and able to explain it to any PMs that need clarifications.

Confidential

ETL Developer/Engineer/Administrator/Lead

Responsibilities:

• Working at different Client locations to solve the ETL project issues they may have.
• Using Apache Hadoop on projects that have decided to use open-source software because it is less-expensive reliable, scalable than other sources out there.
• Scheduling jobs from Control M, Tidal and unix cron
• Deployments of nodes from DEV to UAT/TEST to PROD, folder to folder copy, export as xml files, server to server copy
• Repository creation - in UAT/ PROD through admin console.
• Repository backup - using PMREP for Informatica Command line, manual backup through admin console.
• Production support on call bi-weekly for monitoring Services of Windows Server and Unix Server.
• Developer mappings form different sources like
• Data Quality Administration to verify what kind of data gets loaded into the datawareouse.
• Using SSIS Wizard to quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.
• Writing batch scripts to FTP and IP address configurations
• Using Informatica scheduler including 3rd party scheduler like TIDAL, Autosys, Control M.
• Also Informatica upgrades of Hot fixes (8.6.1 / 8.6.12/ 8.6.14 ETC) and patches

Confidential, Chicago Illinois

ETL Lead/Administrator

Responsibilities:

• Educating the team on what the requirement is and making sure all access is available for them to start work.
• Talking with the executive team if we have any issue as hand that needs to be fixed immediately.
• Always on call if any tables fail and no one is available to help get the issue resolved before it gets escalated to another level.
• Working with the Informatica Power Center Administration Console to provide access to users the do their daily projects.
• Working on repositories that break down, doing a refresh of the current data and doing a “start and stop” of the repository.
• Tickets are sent by a system called Remedy for proper documentation of all work done for each group so as to charge the client appropriately.
• Production support helps early in the morning to help facilitate the runs for the night and make sure all servers and repositories are working in full capacity.
• UNIX log-in using the “super user“(SU) to log-in and work on servers and do refresh and migrations needed for continuous improvement.

Confidential, Des Moines Iowa

Informatica Developer/Administrator

Responsibilities:

• Interpret and comprehend business / data requirements and form upstream processes
• Attend weekly meetings with BA’s to ensure project is heading to the right directions and ask required questions for the project at hand.
• Design project using a data model for the development and gave best practice advice to Client on best way to improve performance.
• Document technical requirement specifications and detailed designs for ETL processes of moderate and high complexity
• Create and document source-to-target mappings and ETL specifications
• Design ETL processes for optimal performance

Confidential, Bartlesville OK

Sr. Informatica Developer

Responsibilities:

• A member of the Enterprise Application Integration (EAI) Team within Data Services that enabled integration across the global enterprise.
• Managing the transformation, delivery, and exchange of data between both internal and external business systems across all business units - Upstream, Downstream, Commercial and Corporate using Informatica.
• Working with team members to provide system support, documentation, and knowledge sharing of best practices
• Hand-on experience with Implementing Informatica Data Quality, Web Services, and Informatica Real-time
• Batch scripts for file management
• Worked on building data warehouses and working with an Enterprise Data Warehouse
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• An Oil and Gas Industry Experience.

Confidential, Atlanta GA

Sr. Informatica Developer

Responsibilities:

• Using Informatica 8.1 Power Center for daily ETL Process and development of new data.
• Using a budget of $17million dollars to help design a new process of Data Integration and performance tuning.
• Creation of hundreds of mappings and extensive testing of data before data is sent to production.
• Peer review" to make sure all connections are correct and no accident are made to run on production before roll-out date.
• Use of past experience to maximize data flow, performance tuning, workflow performance, mapping performance, etc.

Confidential, Birmingham, AL

Informatica Administrator/Developer/DBA

Responsibilities:

• Convert identified Microsoft SQL Server 2000 DTS jobs to Informatica Power Center 9.x
• Support and troubleshoot existing Informatica Power Center workflows
• Support testing and deployment activities for Data Services
• Check/checkout in the mappings and changed the version of that mapping.
• Create stored procedures and cursors, for dropping indexes at target level
• Creation of Informatica Workflows, sessions and Run that Sessions to load into Target and done Debugging, Unit Testing of Mappings
• Schedule sessions and batch process based on demand, run time, run only once using Informatica Server Manager and Scheduled Multiple sessions
• Transformed data from one server to other servers using SQL Server Integration Services (SSIS)
• To interact with Offshore Team everyday using IM and Conference CALLS, and assign them work, based on the Remedy Tickets and to follow up with them for its progress

Confidential, Springfield, VA

Sr. Informatica (ETL) Architect

Responsibilities:

• Worked for the Confidential on a 3month contract and my job duties included the following:
• Responsible for technical design documentation
• Collaborate on technical solutions with application architects, product managers and architecture teams.
• Follow established enterprise development and design standards, guidelines and processes.
• Create high-quality technical documentation
• Interact with IT management and other teams at a highly professional and technical level
• Provide high-quality consultation to business partners and demonstrate keen aptitude in acquiring business domain expertise.
• Ensure deadlines are met, yet be forthright on progress and flexible
• Ensure that all best practices and enterprise standards are followed.

Confidential, Charlotte, NC

Data Specialist - ETL Informatica Lead/ Administrator

Responsibilities:

• Create new mappings and use mapplets for more mappings needed.
• Use SQL Server 2005 to query the system and check out the codes in case there any problems.
• Run workflow on a test environment to be sure everything is safe before heading to production.
• Use CITRIX for visual desktop in a remote location to carry out my daily duty. Responsible for Technical documentation of ETL Process.
• Served as ETL lead to help the development stage take shape as quick as possible.
• Join the team of developers every morning to find and fix daily problems that occur during the day on a live conference call.
• Interacted with business customer and gathered requirement based on changing need. Incorporated identified factor into Informatica Mapping to build Data Warehouse.
• Designed and developed Star and Snow Flake Schema in Data warehouse.
• Used Informatica Designer to create complex mapping using different transformation like filter, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformation to move data to a Data warehouse.
• Worked closely with the business analyst's team in order to solve the problem Tickets, Service Request.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extracting, Scrubbing and Transforming data from Flat Files, Oracle, SQL Server, and then loading into Teradata database using Informatica.
• Finance Business Sys Analyst (Data Mining)
• Planned and directed the analysis of complex business problems to be solved with automated systems.
• Evaluated systems and procedures to determine cost-effectiveness and documented all designs and modifications.
• Utilized Informatica for Data mining that was done 70% of the time to locate where potential losses were made and I typed up ways on how to prevent them.
• Created a new table for all items starting from 2007 so that this time proper documentation was done with the new team in-charge of inventory.
• Inventory was done from for all products leased or bought from Confidential s on items worth more than $2000.00.
• The final assignment was to bring a conclusion on how to account for what was missing and where they may be.

Confidential, Raleigh, NC

Data Architect/Administrator

Responsibilities:

• Transfer files from MS Access to Data warehouse using Informatica Power Center and Batch Scripts FTP process.
• Defined technical requirements, technical and data architectures for the data.
• Develop subject matter expertise (SME) on the applications and the business processes they implement.
• Defined key business drivers for the data warehouse initiative.
• Deliver a project scope that directly supports the key business drivers.
• Architect high-level, logical data warehouse and Business Intelligence solutions to meet business needs.
• Apply industry best practices to deliverables and approach.

Confidential

Informatica Developer

Responsibilities:

• Using Informatica 7.1 Power Center for ETL Process of daily input of users from Stores of customer activities.
• Using Informatica and SQL Server to access and update customer information for reminder filers and coupon.