SUMMARY

• Senior Informatica Power Center expert, offering IT experience with above Ten years of Informatica PowerCenter and RDBMS experience in varied industries and streams such as Healthcare, Postal and Retail services, Finance and Education
• Results oriented leader who constantly evaluates current business processes identifying strength and weaknesses. Constantly leverages evolving BI technologies and trends and implements new BI strategies to empower and improve business analysis.
• Worked closely with product owners, senior management and business users to help identify business goals and manage the development and placement of personnel to successfully deliver Data warehouse projects for decision - making tools and dashboards for effective planning and forecasting.
• Led and managed complex projects and resolved significant business and systems issues by working with and managing support personnel in a dynamic and changing environment.
• Experienced in managing, coordinating and working with overseas development & support teams.
• Sound experience in all the phases of the Data warehouse life cycle involving design, development, analysis & testing.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale Enterprise data warehouses.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Logical and Physical design, Resource Planning, Coding, Testing and implementing business applications.
• Hands on experience in preparing User Specification Requirement, Software Requirement, Technical Documentation, and Test Plan.
• Extensive experience in developing mappings, configuration of sessions, creating workflows and workflow administration using Informatica client tools.
• Very Good experience in developing Logical and Physical Data Modeling, Star Schema and Snow Flake Modeling using Erwin 4.1/3.5.
• Extensive experience using SQL Plus, Unix Shell Programming/Scripting, C#, C, VB, Java, J2EE, HTML 4.0, DHTML, XML, Windows 2007/XP.
• Self-Starter who can adapt and learn fast with excellent communication and interpersonal skills. Recognized Team player with the ability to perform well in a group or individually and can cope well in a high intensity work environment.

TECHNICAL SKILLS

ETL TOOL: Informatica Power Center 9.6/8.1.1/7.1.1/6.2/5.1 , PowerCenter Designer, Workflow Manager, Monitor, Repository Manager, Data Profile, PowerExchange 8.1, SSIS, Visual Studio 2010.

Data Modeling Tool: Erwin 4.1/3.5.2

OLAP: Cognos EPSeries 7 - Impromptu, Power Play6.6/5.0, Impromptu Web Reports (IWR) 6.0

Languages: Java1.2, EJB1.1, JavaScript, HTML, XML, SQL, PL/SQL, Korn Shell, Cosort, C, C++ and VB

RDBMS: Oracle 10g/9i, MSSQL Server 2000/7.0, SQL Profiler, SQL Server Enterprise Manager, Teradata v2r4.1

Network Protocols: HTTP, FTP, SMTP and JMS Adopters

Tools: Oracle SQL Designer, TestDirector 7.2, Microsoft Visio. Microsoft Office Excel, PowerPoint, Word 2003

Application Servers: MS IIS 4.0 and BEA’s Weblogic6.1

Operating System: Windows XP/ 2000, UNIX, Sun Solaris, and AS/400, os/390, MVS

Others: MS Office, TOAD, PuTTY 0.55,MS VISIO Professional 2000

PROFESSIONAL EXPERIENCE

Confidential, Bloomington MN

Sr. Software Engineer

Responsibilities:

• Collaborating with key stakeholders to design and implement complex Data warehouse process as per the requirements for operations, marketing, finance and forensics.
• Created Requirements, Technical documents using MS Word and Excel spread sheets.
• Created process diagrams for data flow using MS Visio tool.
• Created Logical and Physical star schema data models using Erwin tool.
• ETL Design, development, coding and scheduling the jobs to load data from source to target table in a datawarehouse using ETL Informatica client tools Designer, workflow manager, Repository Manager and Workflow Monitor. Regression Testing and Migration of code to lower environments and production for the BI team. Monitoring performance, communicating functional and technical issues working with Configuration Team, Advance Technology Team. And database administrators to ensure that the data warehouse is tuned for optimal performance.
• Created Materialized views in oracle to BI reporting as per the client request.
• Design and develop SSIS packages to load data from the source SQLServer to Target SQL Server.
• Training and mentoring other developers in the team to develop and design ETL using Informatica and SSIS Tools.
• Supporting production Datawarehouse, following the completion of the life-cycle.
• Involved in several Informatica and SSIS software upgrades.
• Agile implementation, Scrum Meetings, Gap Analysis and documentation on the requirements

Environment: Informatica PowerCenter 9.6.1, Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Oracle11g, MS SQL Server 2012, SSIS, SQL Server Data Tools, Business Objects, MicroStrategy, MS Visual Studio 2010, Source tree 2.3.5, Git, Bitbucket, Version One, TeamCity Enterprise 2017.1.4 (build), IBM Urban Code Deploy 6.2.5, TOAD, PL/SQL, Erwin4.1, XML, MS Office2016, MS Visio, FTP, Linux, Windows 2007.