• Ability to multi-task and meet deadlines in a fast-paced, dynamic environment.
• Excellent communication and documentation skills.
• Strong experience in database and ETL/ELT Admin tasks.
• Well versed with all Phases of SDLC Software Development Life Cycle Process with respect to development, deployment, maintenance and enhancements especially agile and scrum prototypes.
• Thorough understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL
• Experience on Teradata SQL and Utilities - BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TPump.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like XML, SQL server, Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments
• Experience of supporting existing data-warehousing systems and resolving production issues.
• Implementation of ETL Strategy, which optimizes Mapping Performance.
• Extensive experience in Extraction, Transformation, Loading data from various sources into Data Warehouses using Informatica Power Center 7.1.3, 8.6, 9.5.1.
• Data Warehouse development working with Extraction/Transformation/Loading, using Informatica Power Center.
• Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.
• Extensively worked on Informatica PowerCener Client versions 7.x, 8.x, 9.x including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Around 9 years of Software experience in Client/Server Technologies and Internet applications of which 9.1 years in the Design, Development and Implementation of Data warehouse using Informatica and Oracle.
• Ability to train the end users to get adapted to the newly developed system and possess excellent skills to build client interface and rapport with Client Base.

Confidential

Role: ETL Informatica Lead Developer/Designer/Data Analyst/Release manager for CCAR schedules/Support.

Description:

The Comprehensive Capital Analysis and Review CCAR evaluates a BHC's capital adequacy, capital adequacy process, and its planned capital distributions, such as dividend payments and common stock repurchases. As part of CCAR, the Federal Reserve evaluates whether BHCs have sufficient capital to continue operations throughout times of economic and financial market stress and whether they have robust, forward-looking capital planning processes that account for their unique risks. The Federal Reserve may object to a BHC's capital plan based on either quantitative or qualitative grounds. If the Federal Reserve objects to a BHC's capital plan, the BHC may not make any capital distribution unless the Federal Reserve indicates in writing that it does not object to the distribution.

Responsibilities:

• Involved in migration of data from Oracle to Green Plum.
• Work with customers in gathering business requirements for data migration needs.
• Work across multiple functional projects to understand data usage and implications for data migration.
• Assist in designing, planning and managing the data migration process.
• Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
• Test ETL and reports of others for quality assurance, and migrating releases into testing and production environments.
• Provides conceptual guidance to other senior and high-level technical experts.
• Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
• Manage assigned risks and monitor potential impacts as part of the data migration plan.
• Develop best practice, processes, and standards for effectively carrying out data migration activities.
• Perform source system data analysis in order to manage source to target data mapping.
• Support the UB Data Warehouse batch cycle and any required changes to the schedule.
• Contribute to peer code reviews for all ETL changes.
• Perform data migration audit, reconciliation and exception reporting.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Prepare RCA for the Non-Compliance raised by the Quality facilitator.
• As a Lead, provide assistance or training to lower level staff.
• Managing 12 members in the team and coordinating their work and resolving technical issues raised.
• Technology: Informatica 9.5.1, LINUX, Autosys, Oracle, Green Plum, OBIEE.

Confidential

Role: Lead Developer/Designer/Data Analyst/Release manager for CCAR schedules/Support.

Description:

• Confidential is moving from a CapPR bank holding company BHC to a CCAR BHC requiring higher standards and increased capital planning and data submission requirements. Beginning in 2012. UB has engaged in an effort to identify business requirements for Enhancements to the Bank's ICAAP processes and ongoing compliance with capital planning
• And information collection regulations. The scope and objectives of this project, CCAR BHCs are required to submit financial Statement, capital and portfolio data to the Federal Reserve on an annual basis. This Information is captured in FRY14 regulatory forms, and detailed data requirements and Completion instructions have been provided by the Federal Reserve.
• As part of this project, Union Bank has to submit the following reports/schedules to the Federal
• Reserve.
• Wholesale CRE Loans
• Wholesale - Corporate Loan
• Retail - Address Matching Loan Level Data
• Retail - Domestic Small business
• Retail - First Lien Closed-end
• Retail - Home Equity Loan HELOC

Responsibilities:

• Worked as a Lead in Understanding the business requirement specifications provided by the client and translate them into ETL design specification, and create mappings, sessions and workflows.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy
• Gathered the requirement/s through MDR tool Metadata Repository .
• Involved in Estimation of the project.
• Follow up with the business users for UAT , architects for design and any other stakeholders necessary
• Risk Management Analyze the risk and have Mitigation plan .
• Planning daily activities to meet the Project timelines and Quality Management.
• Involved in debugging the UNIX scripts according to the requirement.
• Weekly Status Reporting to the Client.
• Daily status tracking of the project.
• Developed mappings between source and target tables.
• Conducting code review sessions.
• Involved in Unit testing and integration testing.
• Preparing the LLD and carrying out impact analysis.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Prepare RCA for the Non-Compliance raised by the Quality facilitator.
• Monitoring the resource performance and come up with the training plan for the team members.
• Task Assignment to the team and responsible for updating daily status to the offshore team.
• Technology: Informatica 9.5.1, LINUX, Autosys, Oracle, Green Plum, OBIEE.

Confidential

Role: Lead Developer and Data Analyst.

Description:

• Confidential Consumer Lending Systems CLS is integrating its operations with Mortgage Servicing Platform MSP . MSP is a comprehensive, fully integrated solution by Lender Processing services LPS that gives mortgage bankers the ability to automate all areas of loan servicing, including loan setup and maintenance, customer service, cashiering, escrow administration, investor accounting, default management, corporate accounting and federal regulatory reporting.
• The advantages of using MSP are as follows:
• Increased productivity and flexibility
• Reduced overall servicing costs
• Increased management and control
• Improved compliance
• The scope of this project is to enable the seamless phasing out of the existing Consumer Lending Servicing Systems CLCS of UB and efficient utilization of MSP instead.

Responsibilities:

• Understand the business requirement specifications provided by the client and translate them into ETL design specification, and create mappings, sessions and workflows.
• Involved in Data Extraction from Oracle, Flat files, Mainframe files using Informatica.
• Developed various mappings to load data from various sources Mainframe files, flat files, oracle using different transformations like source qualifier, Normalizer, joiner, Aggregator, Lookup, Router, Update Strategy ,filter and Expression to store the data in different target tables.
• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, testing and mentoring.
• Involved in debugging the UNIX scripts according to the requirement.
• Developed mappings between source and target tables.
• Conducting code review sessions.
• Involved in Unit testing and integration testing.
• Preparing the LLD and carrying out impact analysis.
• Regular Communicating with the onsite team to get the requirements.
• Technology: Informatica 8.6, LINUX, Autosys, Oracle.

Confidential

Role: Lead Developer

Description:

The aim of this project was to upgrade migrate the ETL code of the Union Bank from Informatica 7 environment to Informatica 8. As a part of this activity 40 folders containing around 3000 mappings for all the LOANS, Branch and BASEL source systems are migrated. The logics and paths of the Unix Scripts for triggering the ETL's are also modified as a part of this activity. The migration was followed by rigorous system integration testing cycles, ensuring that the parameter files updating, source files archival and reconciliation and post loads balancing is happening in the expected manner. Until the complete ETLs were upgraded loads were running in both INFA7 and INFA8 repositories. Real-time source files were Ftp'd onto the test server on which INFA 8 was running as in production server. After the completion of daily loads in both environments the data comparison and validation is carried out. All the data differences and data quality issues identified and reported to the management. After fixing the data anomalies the code again goes for SIT cycles.

Responsibilities:

• Properties and names of ETL objects and UNIX scripts modified as per new standardization documents.
• Modified the server names and path names in the UNIX script as per Linux standards.
• Removed the short cut definitions in ETL objects and modified the ETL objects without short cut definition.
• Involved in system integration testing and data validation.
• Technology: Informatica 7.1.4 and 8.6, LINUX, TWS, Oracle.

Confidential

Role: Senior. Developer.

Description:

• In this Project dashboards are built for the NBC.com and NBC Sports and the Backend ETL's are built to bring the data from Ominiture source system.Omniture is third party application, used to fetch details on the impression, page views, unique view, page visits and clicks for all the sites of NBCU, so that NBCU could assure their advertisers for requested amount of impressions and views from the NBCU sites.
• We get this information to our database with two metrics.
• Site Metrics: It contains the information regarding the whole site with its impressions, unique page views, page views etc.
• Content Metrics: It contains the information particular to the content placed in the site with its impressions, unique page vies, page views etc.
• In both SITE and CONTENT level data we are getting three types of file: DAILY, WEEKLY, and MONTHLY.

Responsibilities:

• Worked on the source extracts as required for business on the source system Omniture
• Worked on the shell scripts to extract the data from the source system and load them accordingly.
• Worked extensively on the analysis of the data and transforming according to the business logic.
• Involved in developing mappings according to the business requirements received from the Strategic Business analysis team.
• Worked extensively on Teradata to analyses the data.
• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, testing and mentoring.
• Participates in technical walkthroughs/ code reviews of other team member's components, test plans and results and help them with gaps.

Technology: Informatica8.1.6/Business Object's 6.5, Teradata, UNIX.

Confidential

Role: Senior. Developer.

Description:

• In this project a platform is built for end clients HSBC, PBGB customers for trading their money in stocks. This platform is combinations of different components, some of which are buy components. Different databases main database being EDB are used for moving an activity or trade placed. For this purpose PWX Power Exchange RT ETL's are used for moving the data at real time. They run continuously all the time. Moving the data, also there are batch ETL's power center which are ran through scheduling done during EOD and BOD Jobs. For each client different platform is maintained.
• Data movement is done in real time through various components.
• Different components are integrated for building the platform.
• Provide a single point of administration.
• Common platform to full fill all Trading needs.
• Scalable enough to accommodate future changes and implementations.

Responsibilities:

• Requirement gathering from business owners or users.
• Understand and analyze the data sources, type of data and prepare a list of data elements.
• Generation of Functional Specifications and Technical documents.
• Design for implementation of the database.
• Worked on the Redesign of the TLM project for converting business specifications to technical specification individually.
• Worked on the compatibility of software's for project set up.
• Technology: Informatica8.X/informatica7.X, Business Object's XI, SQL server and Oracle 10g, UNIX.

Confidential

Role: Jr. Developer

Description:

• The Pricing project will implement an effective pricing system for BAWC that provides a well-controlled and centralized pricing database. This will facilitate the identification and removal of discrepancies in cargo pricing across stations. An effective and auditable pricing system will improve the robustness of internal controls in the Cargo Sales process.
• The solution proposed is a centralized system with local maintenance of rates, together with an improved management information system for reporting on pricing.
• This solution also provides enhanced integration between NGRM New Generation Revenue Management and Pricing activities. Automatic pricing automating at stations that use the BAWC Booking Front End BFE will be provided. It will build upon the NGRM framework to deliver an automatically derived rate specific to the customer, which can be used to calculate whether or not the consignment should be accepted. Ancillary charges that are to be included for evaluation currently fuel and EHC will also be calculated.

Responsibilities:

• Extensively worked as a production support to resolve any issues in production
• Monitored the workflows, which are running in production on daily basis.
• Resolved performance issues that were raised in production.
• Assisted in Migrating Repository objects using Repository Manager between various environments.
• Exported universes to the repository to making resources available to the users.
• Daily monitoring the Broadcast Scheduler and performing action against reported issues.
• Scheduling reports on BCA, making changes to Universes through Designer tool of BO and promoting them to LIVE.
• Involved in making changes to Reports through BO reporting tool and Promoting them LIVE.
• Technology: Informatica PowerCener 7.1.3, Business Objects 6.5, Oracle 9i, UNIX.

My Role:

• Involved in requirement analysis, Design and development Testing.
• Involved in unit testing.

Confidential

Role: Jr. Developer

Description:

Worked as ETL Developer for San Miguel Corporation that sells various food products. It has various stores. This company is a leading seller for a variety of food products with several Branches in USA. Data from various online transaction processing OLTP applications and other sources is selectively extracted, related, transformed and loaded into the Oracle data warehouse using Informatica Power Center ETL tool. The database has lots of historical data. So data warehousing plays a Major role in enabling various stores to View data at a lowest level and help them to make Decisions to bring more revenue to company with new policies.

Responsibilities:

• Involved in developing of the ETL Extract, Transformation and Load strategy to populate the Data Warehouse from various source systems Oracle , flat files feeds using Informatica.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformations.
• Used various Transformations like Source Qualifier, Joiner, Aggregator, Update Strategy, Expression, Sequence Generator and Filter for better data messaging and to migrate clean and consistent data.
• Created Informatica mappings to build business rules to load the data into data warehouse.
• Created Mapplets and Reusable Transformations.
• Used the Workflow Manager to create Sessions.
• Involved in the unit testing to check the data consistency.
• Used Informatica Workflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings

My Role: As a Team member, Developer. Involved in unit testing.

Confidential

Role: Jr. Developer

Description:

Confidential Electronic Goods with its stores spread around the Confidential. The sales data was stored in different databases such as oracle, flat files across different locations. The project is involved in the maintenance of the decision support system for Bayer by means of integrating data from disparate feed system, situated across different locations into a repository of meaningful business information. This was very much required for the management to get a view of their businesses at a common site.

Responsibilities:

• Responsible for Extracting, Transforming and Loading data from Flat files and ORACLE files and placing it into Data warehouse.
• Used various transformations like Source Qualifier, Filter, Aggregator, Expression, Lookup, Sequence Generator, Joiner and update Strategy to create mappings.
• Created Mapplets and Reusable Transformations.
• Created and developed a series of mappings for handling different cases of input data in the same source table.
• Tuned and tested the mappings to perform better using different logics to provide maximum efficiency.
• Used the Workflow Manager to create Sessions.
• Involved in the unit testing to check the data consistency.
• Used Informatica Workflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings

Technology: Informatica Power Center 7.1.3, Business Objects 6.5, Oracle 9i, UNIX.

My Role:Involved in ETL Design development and testing.