SUMMARY:

• Highly accomplished DW/BI Consultant with more than 19 years of experience in all phases of SDLC leading large high - performing teams for Fortune 500 clients.
• Exposure to all stages of Software Development Life Cycle.
• 10+ years of experience in analysis, design, development, testing and implementation involving Informatica and various other Data Warehousing tools and technologies.
• Expert level experience in Developing system data requirements, data architecture solution, HLD, ETL specs and other data design artifacts.
• Worked extensively in Informatica Power Center Repository Manager, Designer, Workflow Manager and Monitor.
• Extensive experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases.
• Experienced in 24X7 production support for Data warehousing and BI using Informatica & Business Objects.
• Implemented complex business rules in Informatica by creating re-usable transformations, robust mappings and mapplets, utilizing varied transformation logic like lookups, router, filter, expression, aggregator, joiner, update strategy, normalizer and more.
• Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes.
• Extensive experience with Shell and Perl Scripting in the UNIX and Linux environments.
• Exposure to Dimensional Data modeling techniques like star and snowflake schemas using Erwin.
• Expertise in designing and implementing SCD - slowly changing dimension types (1, 2 and 3) and Change Data Capture.
• Expertise in handling and loading high volumes of data into data warehouse in each load window.
• Expertise in Cognos 8 BI Suite (framework Manager, Cognos connection, Report, Analysis and Query Studio).
• Proficient in implementing ETL QA procedures.
• Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
• Experience in performing Functionality testing, System Integration Testing (SIT), Integration, Negative testing, User Acceptance (UAT), Stress Testing and Regression testing on several applications as needed to minimize defects.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.

CORE COMPETENCIES:

• ETL - Informatica Developer/Lead
• BI - Lead Developer
• Data Management & modeling
• L2/L3 - 24X7 prod support
• Data Quality & Data Profiling
• Performance Tuning
• Data Integration
• Global Delivery model
• Incident/problem Management

TECHNICAL SKILLS:

Database: Oracle 11G, DB2 and MS SQL Server 2000, Teradata

ETL Tools: Informatica, SQL Server Integration Services

Data Modeling Tool: CA Erwin 7.3 and MS Visio

Languages: Linux Shell scripts, SQL, PL/SQL, C

BI Tools: QlikView, Tableau, Cognos, Crystal Reports, MSBI (SSAS, SSRS)

Other Utilities: RALLY, MS Office, SQL*Plus, TOAD, SQL Developer, Rational and Mercury Quality Center 9.0.

EXPERIENCE:

Confidential, Minneapolis, MN

Senior Data Migration Architect

Responsibilities:

• Gather and analyze the requirement and convert into technical specifications.
• Data profiling using informatica IDQ. Analyze and validate the data and prepare data mapping to convert from legacy to SAP data needs.
• Develop solutions that improves data cleansing / integrity issues.
• Work with business to gather requirement / changes and convert them into design, analyze for feasibility.
• Design data extraction, transform and load frameworks and design standards.
• Guide the developers in design challenges, development methodologies
• Develop informatica code for critical supply chain objects (Vendor Master, Material Master, Purchase Order, Source List of Procurement) and asset management objects (Maintenance Plan, Notification, Class and characteristic assignments).
• Develop transformation reconciliation(audit) reports and SAP load reconciliation reports.
• Work with various implementation partners and co-ordinate defect resolution meeting and guide the team in resolving the defects based on priority.
• Work on performance tuning.
• Prepare run documents.
• Prepare unit test plan, system and integration plans.
• Support during UAT and address issues / clarifications.
• Work with various stakeholders and project leadership to identify problems and risk highlight to get right attention to potential problem and get them to closure.
• Always look for opportunity to implement new ideas, improve end user satisfaction.
• Stay ahead of schedule, work additional hours when demanded.
• Team player - working for the success of the project and team instead of just individual excellence.

Confidential, Hartford, CT

BI Consultant

Responsibilities:

• Transform legacy BI assets from WebFocus / Cognos to Strategic BI Assets in Qlikview.
• Responsible for BI Architecture, data extraction architecture (Setup 4 tier architecture to extract, load, transform and provide analytical solutions) .
• Provided architecture and design guidance in integrating Qlikview with D3. Js using extension objects.
• Involved in Requirement Gathering, Documentation of Business Requirements.
• Created QVDs for Optimized loads and better maintenance.
• Created a simple data model to handle complex relationship between multiple fact tables.
• Designed a Link Table which is used for connecting all the Fact tables and Master data tables.
• Scripted all the business logic into the backend Data Model for avoiding conditional statements in Dashboard.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboard style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Created Actions for defining default selections, Input fields on-open of QVW files.
• Created Line charts, Pivot tables, PIE charts to compare sales between different line of business (Products, Categories, Calendar).
• Designed integration solution to build predictive modelling using ‘R’.
• Work with IT partners, vendor teams and provide state of art support to the end user community.
• Developed efficient Data Models in qlikview and built visually appealing dashboards.
• Designed and Implement data security.

Confidential, Fortworth, TX

DW/BI Consultant

Responsibilities:

• Involved in blueprinting, gathering requirements, designing and rolling-out the various data integration modules.
• Designed and developed data models, ETL architecture in SSIS.
• Advocated and enforced in following standards and best practices.
• Proactively generated status reports and appraised the project status at regular intervals.
• Managed system and human resources required for the project.
• Developed KPIs, Monthly status reports and monitored resource ramp up / ongoing cost of the project.
• Oversee system landscape / co-ordinate sandbox / test environments.
• Involved in BI change management processes.

Confidential, Irving, TX

Team Lead/Consultant

Responsibilities:

• Extensively involved in requirements gathering, writing ETL Specs and preparing design documents.
• Created source to target mappings, edit rules and validation, transformations, and business rules.
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies.
• Fixed various performance bottle-necks involving huge data sets by utilizing Informatica’s partitioning, pushdown optimizations and SQL overrides.
• Responsible for the data migration from AS-IS system bundle qualification tool.
• Lead the data migration team to understand the source system, participated in the design of target system.
• Orchestrated the conversion approach and design, held reviews with subject matter experts and business stockholders.
• Defined data grooming rules after profiling the source system data spanned across various systems (bundle qualification / CRMM, Billing & customer profiling systems).
• Planned the dry run, cut over plans and actual migrations.
• Provided support during integration, user acceptance testing and post production support.
• Designed and generated metrics dashboards to the customer executives.

Confidential, Mountain view, CA

BI Consultant

Responsibilities:

• Responsible for the QlikView platform at the organization.
• Analyzed qlikview server / publisher environment and reconfigured to improve platform availability.
• Ensures the platform is available with low downtime / outages.
• Responsible to apply QlikView patches.
• Responsible for MTP and ensured applications adhered to standards, best practices and will not hamper the performance of the platform.
• Work with vendor (QlikTech) to report issues and co-ordinate issue resolution. Implement suggestion given by the vendor to improve the system performance / technical issues.
• Participate in design reviews and provide feedback / solutions to the design of applications.
• Govern the day to day administration activities (monitor data load, access setup, backup / recovery, monitor server performance).
• Estimated service capacity requirements and increased the server capacity on the need basis.
• Provide guidance to the offshore team in resolving any technical issues.
• Drive initiatives in completing proof of concepts on new features provided by QlikTech and present to the customer.
• Responsible for prototyping QlikView environment in enterprise cloud.
• Designed Dashboards and Prototype Demos in QlikView.
• Loaded data reduction based on Section Access.
• Devise data extraction methods for various data sources.
• Architected data extraction / data compression methods using QVD files.
• Architected near time data load using QVD files.
• Identify performance bottlenecks and suggest design / code changes.

Confidential

Tech Lead / DWBI Consultant

Responsibilities:

• Gathered the Functional Requirement Specifications from customer and understand the same.
• Were responsible managing tasks and deadlines for the ETL/BI teams both Onsite and Offshore.
• Lead a team of Informatica, Cognos developers, QA team and provided updates to customer PM on project Status and issues.
• Designed and Developed the Framework Manager models and Published the packages.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Map Reports Using Report Studio and Query Studio.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Responsible for High level & low-level ETL flow design.
• Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues.
• Was involved in conducting the review of Informatica, Cognos Code, and Unit Test Cases & Results with the Developers.

Confidential

Production Support Lead

Responsibilities:

• Lead a team of 15 People and ensured client expectations were met.
• Working closely with change control board to ensure the changes to the production systems are well planned, thereby minimizing the impact to the users.
• Implemented methodologies and best practices to deliver the greatest value possible from enterprise system in services being rendered.
• Served as single point of contact for delivery teams and supported handover of work product to support teams during release process.
• Worked closely with business units to ensure timely and accurate resolution of issues in the support process; increased user satisfaction.
• Optimized systems up-time and minimized unplanned outages to increase system availability.
• Supported Sarbanes Oxley Requirements and ensured that ITIL standards were met.
• Enhanced and modified, per business requirements, the management process of the ETL aspect of the EDW for daily, month-end and quarter-end close.
• Worked closely with the level 2 support team to drive closure on any issues that arose during normal ETL (informatica) processing activity whenever published service levels were not met.
• Lead the ongoing monitoring of production environments for the EDW, including alert management as well as trend reporting to feed into the ongoing capacity planning exercises.
• Evaluated and selected suitable tools to provide the automated monitoring for the ETL area to increase employee efficiency and drive lower costs.
• Monitored and managed support tickets in the helpdesk call tracking system to ensure the timely closure of open tickets and provided weekly reporting metrics for the support area.
• Managed the enhancement of metrics reporting for the ETL area to provide automated dashboard provision on performance supported by available online metrics.

Confidential

Technical Lead/Business Analyst

Responsibilities:

• Analyzing the source system for the new analytics requirements.
• Conduct and drive requirements session. Manage Client needs and expectations. Gather and document functional requirements.
• Design, Development, Testing and reviewing Informatica mappings, Cognos Impromptu Catalogs, Power play cubes and Impromptu reports.
• Design, Development, Testing and reviewing Cognos Transformer models.
• Responsible for creating conceptual, Logical and physical dimensional data models.
• Participate in business meetings and test case reviews with business team and internal project teams.
• Created test strategies/test plans.
• Conduct and drive User Acceptance Testing for a wide group of audience.
• Supervising and managing client project team, onsite and offshore project teams during assessment, analysis, design, coding, testing, deployment and warranty phases of software development life cycle.
• Serving as a liaison between business and technology teams.
• Coordination with client business team, client IT team, onsite and offshore project teams to ensure accurate project communication.
• Status reporting to client business and IT Senior management team
• Provide 24x7 support on Informatica data load, problem / incident tickets
• Monitor and Ensure the production jobs are running without delays / failures.
• Work with DBAs and other support groups to get problems related to their areas.
• Attend meetings, initiate escalations in case of any delays issues which impacts SLAs.
• Work on incident & problem tickets and resolve them in timely manner.
• Troubleshoot network, hardware, and software issues while coordinating resolution with users, vendors and internal service groups.
• Write and design test scripts.
• Create change or issue logs as well as analyze performance trends and recommend process improvements.
• Assess changes for risk to production systems and assures quality, security, and compliance requirements are met for supported areas.
• Update, create and test the business continuation plan.
• Coordinate project resources and provide guidance to less experienced analysts.
• Provide tactical technical solutions in case of any failures and create problem tickets to find out permanent solutions.
• Provide shift handover documents to other support members.