OBJECTIVE:

DWH with extensive experience in Analysis,designing, coding, testing, Implementaion and supporting of Confidential Solutions and Business Intelligence

PROFILE:

• Flexible and versatile - able to maintain a sense of humor under pressure. Poised and competent with demonstrated ability to easily transcend cultural differences. Thrive in deadline-driven environments. Excellent team-building skills.
• Having 11 years of strong Data Warehouse experience using Informatica 10X/9X/8X (Informatica Administrator and Repository Manager,Workflow Manager,MappingDesigner,Mpplet Designer,Workflow Monitor)
• Extensive Experience in Banking Domain and having complete Business Knowledge.
• Good Understanding of Data warehousing Life Cycle.
• Good Understanding of Dimension modeling, which is adopted to build the Data warehouse.
• Well versed experience on Star Schema & Snowflake schema.
• Experienced in OLTP/OLAP systems and having good knowledge of relational Database concepts,Normalization and Denormalization.
• Proficiency with in Developing SQL with various relational Databases like SQL server and Oracle.
• Expertise in working with various types of data sources like Flat Files and RDBMS products like SQL server,Oracle.
• Extensively used major transformations using powercenter Designer like Lookup, Expression, Aggregator, UpdateStrategy, Normalizer etc..
• Understand the business rules completely based on High level Document specifications and implements the data transformation methodologies.
• Ability to meet deadlines and handle multiple tasks,decisive with strong leadership qualities,flexible in work schedules and posses good communication skills.
• Expertise in Administration tasks including Export/Import and Deployment of products across multiple environments (Dev/QA/Production),Managing Users&Groups and associated privileges.
• Well experienced in doing error handling and Trouble shooting using various log files and Informatica Debugger.
• Good Exposure to Development, Testing, Debugging, Implementation, Documentation, End User Training, Production Support.
• Involved in Various Production activities like Disaster Recovery and other Project related Documentaion like KEDB,Query Tracker,HLD,ELD etc..
• Executing Application System Integration Testing and User acceptance testing and resolving the issues.
• Facilitation of Technical Requirement Walkthrough and joint application Design session.
• Creation and execution of application Design and implementation plans.
• Interact with the client and all the concerned stakeholders right from the project initiation till successful implementation.
• Coordinating with business and help them to build the data mapping and data conversion plans.
• Participating all Weekly and Monthly basis business board meetings to release management activities.
• Having knowledge and able to generate the reports from the OLAP Business Intelligence tool like Cognos.
• Having Experience with End to end Business process activities.
• Analyzing the application code and suggesting improvement ideas.
• Expertise in performing UAT as well as SAT.
• Independently perform Complex Root- Cause analysis and Resolution methods.
• Playing critical role as a Technical lead and guiding entire team during the issues and providing thought processing to understand the business in effective manner.
• Comprehensive Techincal, oral and written communicational skills.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Ability to work independently or lead a team.
• Flexibility to work in any kind of environment.

SKILLS SUMMARY:

ETL Tool: Informatica

ODI: MDM

OLAP Tools: Cognos,SSRS

Authentication: LDAP

Scheduling Tools-: Control-M,Autosys

OS: Windows, Unix, Linux

Databases: Oracle MS-SQL, SQL Server, PL/SQL

Languages: SQL PL/SQL, Java

Other Tools: ManageNow, Infoman, Lotus Notes, Service Now, Jira, Microsoft Suites, MS Word, MS Excel, MS Powerpoint

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Informatica 10X, Oracle,ODI,SQL

Responsibilities:

• Attending project kick-off meetings, Capturing requirements, conducting impact analysis of requirement and Providing Analyze deliverable, Sizing for development and support efforts, test strategy and time lines based on Impact analysis.
• Preparing high level Design and low level design documents for the flow of changes based on the analysis as per the Quality Procedures and standards.
• Maintaining timesheets and ensuring all the deliverables from Design to Rollout Phase with reliable quality
• Technical discussion with the functional analyst, business users to identify new requirements and gather information for enhancements and Change Requests.
• Coordinate with Data Modelers, Business team, internal, external stakeholders to review and finalize Business Requirement documents and ETL Functional Specifications.
• Perform Unit testing for the code changes done in programs and Coordinate with different groups of interfacing system for testing the change with integration.
• Performing Impact Analysis of new requirements and working with Enterprise Architects for Technical Design and Review.
• Analyze existing data model and identify gaps in the proposed solution, make recommendations for resolving gaps, and monitor results
• Participating in Change Advisor Board Meetings and handling Tech review meetings for recent ongoing installations.
• Coordinating and working with offshore team to explain project requirements and getting thedeliverableon timely manner. Also Providing Knowledge transfer to team members
• Analyze business and other data processing problems and apply science and engineering to implement and improve computer system.
• Test conditions and test strategy walk through with business partners and project teams.
• Responsible to perform QC audits, defect analysis and matrix analysis.
• Deploy Code changes to Lower Life Cycle and Test the changes with actual data.
• Fix the issues identified in lower life cycle.
• Creating Various Project related documents like Technical Design Documents, Functional Specifications and Source to Target Mapping Specifications.
• Coordinating quality assurance efforts and helpingTesting team to execute test validations for project changes in various Test phases i.e. SIT, UAT, Regression and Performance testing.
• Migrating the Code into various Environments by using Jira tool.
• Participating in all the release management activities and providing description of project, back out plans and Implementation of enhancements in to real time environment.
• Involve in production support activities during warranty period after project goes live.
• Schedule and Facilitate meetings to review Project Initiatives. Participate in review meetings of various deliverables (Code review, Design review etc.) of projects and release installation activities.
• Providing required permission to application users, to protect the data from unauthorized access. (2%) 3.Migrating the ETL Code and Database Scripts to production Environment.
• Responsible for maintaining Query register to track all project related query and defect register for maintaining all defects raised in SIT/UAT phase which will be used for DP analysis.
• Managing integration of application with other on premise application interfaces
• Providing technical guidance as needed for the following: Tech Inquiries, Test issues, Production issues and Providing support from Impact analysis to warranty hand-over.
• Provide Application Support during deployments and make sure the application is working fine.
• Monitor the Application in Production environment and Fix the Production bottlenecks in ETL Processes.
• Documenting project related documents as per the standards to ensure in compliance with the Internal and External Audits.
• Interaction with different teams like application teams, interfacing teams, network teams and devise an agreeable and feasible solution.

Confidential

Environment: Informatica 9X/8X, SQL Server 2008/2005,Cognos 10.

Responsibilities:

• Supporting Business application in production environment.
• Understanding the Requirement specifications and analyzed it and prepared mapping docs.
• Worked on Informatica PowerCenter tools like Source Analyzer, Warehouse Designer to import the source and target database schemas . Mapping Designer, Workflow Manger and Workflow Monitor.
• Responsible for Extracting, Transforming and Loading data from SQL server & Flat files And placing it into data warehouse
• Created Informatica mappings with specific business rules to load data in the target tables.
• Extensively used various Transformations to ensure the performance at various stages in the ETL Design.
• Implemented Incremental Loading for the tables exist in ware house.
• Used Session Parameters, Mapping variables/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Involved in optimizing and performance tuning logic on mappings to increase efficiency.
• Implemented Complex mappings such as Slowly changing Dimensions (TypeII) using current flag and effective date range.
• Creation of sessions and executing then to load the data from system using Informatica Workflow Manager.
• Used Update Strategy and Lookup transformations to insert, update, delete, reject the records based on business requirements.
• Communicated with Business customers to discuss the issues and requirements.
• Reviewed the Business requirements and created internal and external design for Informatica jobs.
• Used Informatica file watch events to pole the FTP, SFT sites for the external mainframe, Axiom, Oracle files.
• Involved in Enhancements and maintenance activities of the data warehouse.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Identified problems in existing production data and developed one time scripts to correct them.
• Addressing production gaps and issues.
• Involved in Analysis and fixing of critical issues reported by the client and documentation of those.
• Reviewing ETL documents related to development of new requirements.
• Worked on Informatica initiatives and earned business confidence.
• Guiding Junior folks to work on informatica and other application activities.
• Taken additional responsibilities for all the informatica related queries.
• Provided extended support during various phases design, coding, testing.
• Coordinating with Cognos infrastructure team for infrastructure issues(related to dispatcher or Content Store, etc.).
• Handling BAU issues and performing support activities..
• Resolving issues related to Cognos such as data source connectivity, ETL load failure, restoring of data source in production database, data discrepancy between business application and Cognos reports etc.
• Providing Audit report (total number of reports executed per month) to business team as per their requirement.
• Sending incident/outage notification to business stakeholders in case of any incident/outage and joining bridge calls to resolve the issue and notify/inform business regarding the status of the issue.
• Coordinating with various stakeholders like database team, server support team, Cognos infrastructure team, Documentum team, and business team.
• Responsible for Cognos archival of old data(archival jobs) on a monthly basis and coordinating with business team and Documentum team for archival.
• Raising CMR/RFC for any data modification in production servers, and also monitoring business application production servers to avoid any outage like circumstances during business hours.