Sr Consultant Specialist: Data Warehousing / Business Intelligence

• Business Intelligence / Data Warehousing Lead with 10 years of experience in the industry and more than 5 year of experience leading projects from planning to execution, developing solutions for Fortune 500 clients. Managerial and technical expertise in the area of data integration and data warehousing especially in the financial and Retail domain. Recognized as a critical resource in the current business set up with well rounded mentoring, team skills and leadership abilities. Demonstrated strong communication and articulation skills in the professional assignments.
• Data Analysis Expert with sharp analytical and synthesis capabilities. Adept at accurately solving complex problems and providing robust, scalable solutions as well as troubleshooting. First hand experience of working with latest modeling, ETL and business intelligence tools for last 5 years from simple corporate database to highly complex projects distributed databases . Received numerous customer recommendations for demonstrating clear understanding of the domain issues beyond the project requirements and exceeding expectations.
• Highly motivated individual who enjoys working on new technologies and recognizes rapid learnability as a key asset for success in the ICT space and strives to share the experience in order to enable peers and accrue knowledge to the organization.

Skills Summary

• Expert End to end management, Involved Key Role in the management, User/Member Knowledge as a user or member TECHNICAL NICHES IN INFORMATICA/DATA WAREHOUSING
• Active member of Deloitte COP for Informatica. Involved in Training and Alliance relationship with Informatica.
• Enhanced productivity by designing and utilizing Pushdown Optimization with Informatica 8.4.
• Proposed solution approach for performance tuning: Integrated CONNX with Informatica to optimize the client Warehouse With Netezza . A Booster of 300 which brought down Data Warehouse Availability to Business customers from 3 PM to 8 AM.
• Taking initiative in estimation modeling for Informatica.
• Performance tuning standards in Informatica Data Loads.
• Setting up Warehouse Design Standards.
• Identified Key Performance areas for multiple Warehouses, and Proposed/Delivered strategic solutions to the Client.
• Established Reusable Datawarehouse Validation Mechanism for the Client applicable for sessions running on any target Databases.
• Established Netezza Database standards for Design and Coding with Informatica.
• Formulation of Effective Telecom EDR reporting storage and usability with Netezza.
• Chaired and Educated multiple training sessions on Data Warehousing concepts in Infosys
• Key Member of Informatica and Data Warehouse Expert Group in Infosys

Professional Experience

• Deloitte Consulting LLC Leading global consultant
• INFOSYS Top-ranked offshore IT service provider / Leading global consultant.

CAREER PROGRESSION

• ETL Solutions Lead / Architect
• Technology Lead
• Programmer/Technical Analyst
• Software Engineer

PROJECTS

Finance Budgetary Data Warehouse

Confidential

DWH/Informatica Specialist.

• Design, Estimation, Model Development, Model Enhancements, Development, Client Management, Mentoring, Knowledge Management
• Objective: Technical lead on the IDAP-FINANCE project Atif is responsible for technical architecture for achieving the project objectives which involved conversion of NIH Datawarehouse from DB2 to Oracle. He leads the team of 4 responsible for Design and Development of ETL. He is also responsible for laying out standards and best practices for Design and Development of IDAP Project.
• Team Size: 10. Software: Informatica 9.4, Oracle 10g, Erwin, Solaris Unix, Business Objects, Toad, Hummingbird, DB2.
• Finance Reconciliation for Cards/Loans

Confidential

DWH/Abinitio Product Specialist/Onsite Lead.

• Design, Estimation, Model Development, Model Enhancements, Client Management, Mentoring, Knowledge Management
• Objective: Build and enhance systems for Recon Application used for the Reconciliation for all the transactions taking place for every Ledger of the Bank. DDE objectivity was to provide files to Recon system after all the validations in formats acceptable and DQ checks.
• Team Size: 5 1 Onsite, 4 Offshore . Software: Abinitio V2.15 , Oracle 10g , Teradata , AIX Unix
• Mortgage DataWarehouse Development
• Global Markets Leading Credit Cards Company for Confidential

DWH/Abinitio Product Specialist/Offshore Lead.

• Design, Estimation, Model Development, Model Enhancements, Delivery of all the models, Mentoring, Knowledge Management
• Objective: To build up a Single Data Warehouse for the Mortgage Bank Users for their analysis. It involved the integration of 3 subsystems 3 different Banks into 1 consolidated Warehouse for Business Analysis , research and Forecasting.
• Achievement: Agile Development methodology used for the integration of various subsystems into the Teradata Warehouse. Key niches involved quick understanding on requirements and building reusable patterns which could be used for multiple subsystems.
• Team Size: 12 2 Onsite, 10 Offshore . Software: Abinitio V2.15 , Oracle 10g , Teradata , AIX Unix

Confidential

Informatica Product Specialist/Onsite Lead.

• Design, Estimation, Model Development, Model Enhancements, Delivery of all the models, Mentoring, Knowledge Management
• Objective: Worked on Multiple sub streams for the client as an Technical Analyst for the Data Warehousing Team for large Scale Integration and Standalone Data Warehousing Projects.
• Integrated SVT Development: To build up a Single View Telecom Provisioning System for the Client. It involves integration of multiple Systems into a single umbrella for provisioning of new and existing Telecom customers.
• MVNO SPA Data Warehouse : To build up a Data Warehouse for Vodafone MVNO within Carphone. This included integration of Sales data with the Daily Vodafone Data Feed and also revenue Facts on the daily MVNO EDR's.
• Quick Wins Development : Rework and redesign components of existing Retail and Telecom Datawarehouse from two perspectives
• Improve Performance
• Add additional functional components for the Business Warehouse Reporting
• Strategic Analysis and Implementation of ODS development intended to bring down the Availability of Carphone Warehouse Telecom Universe from 3 PM to 8 AM.
• Achievement: Successful implementation of enhancements in production and zero UAT defects.Ontime delivery of all the new model developments and enhancements on existing models. Despite the short time to understand the Systems, implement, train the team and deliver quality, the project was a success due to intelligent use of in-process quality assurance steps involving regular KT, detailed planning and conducting joint reviews to avoid mistakes being repeated. Recently received Spot Award for outstanding contribution to the project and also received client appreciation for delivering the Project with accurate planning onto Production environment from Infosys team.
• Team Size: 10 1 Onsite, 9 Offshore . Software: Informatica 8.4 , Oracle 10g , Netezza , AIX Unix, Business Object 6.5

FRW DWH development for

Confidential

• Developer/Module Lead. Preparing Proof of Concepts, Detail Design, Code Review, Issue resolution and performing Independent Unit and Integrated Testing, Delivery of the module, Training/Mentoring new members of the team, estimate effort, report status, Knowledge Management
• Objective: FRW was a major functional reporting system development for the ABN bank which also targeted to be BASEL II compliant. The Goal was to facilitate credit risk and economic capital reporting within the abnk's portfolio management division to provide data for BASEL II Credit and equity risk capital calculations. It incorporated data from 35 different systems into a PeopleSoft Enterprise Performance Management platform. Key requirements were to manage the credit data storage and cradle to grave history of Obligors. Bank also had to utilize a consistent reconciled risk data across the originations and servicing, risk management into the reporting Systems.
• Achievement: Identified key design changes and improvements in the code which led to a tangible improvement in the Informatica performance. On time delivery of module was well appreciated by senior management. Development Tools and mechanisms for automated code validation. Setting up Code and Performance standards for the Team and a key member for the Knowledge Management Drive.
• Team Size: 35 5 Onsite, 30 Offshore . Software: Informatica Power center 7.1, Oracle 9i, HP UNIX

Confidential

• Lead. Preparing Proof of Concepts, Detail Design, Code Review, Issue resolution and performing Independent Unit and Integrated Testing, Delivery of the module, Training/Mentoring new members of the team, estimate effort, report status, Knowledge Management
• Objective: CDW is the primary Data warehouse that is extensively used by the Confidential business group for key business decision support decisions. The overall CDW architecture centers on the enterprise data warehouse. It is the place where the most granular data resides. The data found in the enterprise data warehouse is detailed, historical and integrated. Due to the nature of this data, data marts are created to represent data in a more user friendly view particular to a business user's overall needs. CDW stores the historical loan and customer based information, and helps the Business to analyze, understand, review and research the key business trends, profitability, forecasting and make a foundation for the future business decisions
• Achievement: Identified key design changes and improvements in the code which led to a tangible improvement in the Informatica performance. On time delivery of module was well appreciated by senior management. Received Most Valuable Player award for taking the initiative of starting the Informatica development for the first time at offshore and its successful impmentation.Also appreciated for various Knowledge Management initiatives.
• Team Size: 27 7 Onsite, 20 Offshore . Software: Informatica Power center 7.1, Pure Integrate v 5.3, Oracle 9i, HP UNIX, Essbase 6.5/7.1, MSSQL

Professional Awards and Recognition

• Constantly rated 1 in Deloitte Consulting LLC
• Received OPA Outstanding Performamce Award in Deloitte for contribution to the nVsion program at NIH.
• Pico Award From Carphone Warehouse Client as the best Technical Analyst for Maintaining Excellent Performance for the entire Financial Year 2008
• Pico Award From Carphone Warehouse Client as the best Technical Analyst for Maintaining Excellent Performance for the entire Financial Year 2008
• Most Valuable Player for Carphone Warehouse, CBS ODS project 2007
• Best Project Delivery for Carphone Warehouse Engagement
• Best Project award for ABN Amro, Commercial Datawarehouse project 2006
• Part of the team and anchored the Project Review by Narayan Murthy for Best project ABN Amro, Commercial Datawarehouse project 2006
• Most Spirited Team for ABN Amro, Commercial Datawarehouse project 2006