SUMMARY:

• Over 10+ years of IT experience. Primarily worked in the area of Data Warehousing and Business Intelligence with notable success as BI (ETL/Reporting) Designer/Lead and Data Analyst and Hadoop Developer. Involved in all phases of data warehouse projects including Requirement Gathering, Design, Development, Implementation, Acceptance Testing and Production support for end - to-end IT solution offerings. She has been a DW & BI Programmer with special focus to ETL (Informatica, SSIS), Databases (Oracle, Teradata and DB2) and reporting (OBIEE/Business Objects). She is instrumental in Informatica and SQL writing.
• She has strong DW & BI fundamentals and has expertise on ETL tools, Databases and Unix and reporting tools like OBIEE, Business Objects. She has also worked in diverse domains like Manufacturing, Retail, Banking, Travel & Hospitality, Confidential Care, and Pharmaceuticals S&M space. She has excellent analytical, problem solving and troubleshooting skills. Experience in leading and managing teams. Handled multiple roles - ETL/Reporting Team Lead, Senior Application Developer, and Onsite Coordinator. Have also worked as Business Analyst. Good communication skill, interpersonal skill, self-motivated and quick learner. Excellent team player with good inter-personal and Client Interfacing skills and also has the ability to quickly understand technical scenarios and formulate efficient solution to meet complex technology needs.

TECHNICAL SKILLS:

Technology and Tools: Informatica Power Center 9.1 SSIS Database like Oracle, Teradata, DB2, MS SQL Server 2008, Sybase Unix Scripting Strong SQL writing skill, TSQL DAC, Siebel Analytics Scheduling tool Tivoli, ESP Scheduler R Programming OBIEE, Business Objects Hadoop Concepts, Map Reduce, Hive, Pig

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analyst/Developer

Responsibilities:

• Analyze, design, develop and maintain Informatica ETL and Oracle DAC scripts in support of an implementation of Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics) for a large Siebel 8.0 CRM Field Service application environment
• Build ETL Design including data extraction from heterogeneous sources, Auditing, Error and rejection handling and re-start ability design
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) ofan OBIEE Metadata Repository(.rpd) using Oracle BI Administration Tool.
• Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Expert in usingOBIEE Answersto create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Skilled at creating and schedulingiBotsinOracle BI Deliversto provide real-time, personalized and actionable intelligence data to subscribers.
• Analyze, debug and tune queries; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, troubleshoot and recommend improvements and alternate methodologies
• Monitor nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use;
• Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.
• Utilize experience with Informatica ETL (Extract, Transform, Load) from multiple data sources; Oracle Data Warehouse Administration Console (DAC); SQL; Oracle Database Environment; Data Warehouse Design, including Slowly Changing Dimensions; Oracle Business Intelligence Enterprise Edition (OBIEE) including Oracle Answers, Reports & Dashboard, and Repository, and Siebel CRM for Service
• Analyze and resolve problems and provide technical assistance as necessary and implement corrective actions

Confidential

Senior Associate

Responsibilities:

• As ETL Team Lead and Onsite Coordinator responsible for analysis, design, development and testing all develop components in support of implementation of Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics)
• Responsible for Shouldering overall responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance with Cognizant quality control standards and business practices and procedures
• Working on data profiling and defining the data quality rules
• Imparting domain and technical knowledge to the new entrants and also fellow team members
• As part of deployment activities, the responsibilities include gathering the requirements from the business, performing analysis on the business requirements and development of high level and detailed system/functional design, unit testing and implementation of the approaches.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer.
• Dealing with various teams from the Customer end to drive the objective of the approaches followed to have effective deliverables.
• Experienced in developingDimensional Hierarchies,Level Based Measures,and adding multiple sources to business model objects.
• Further responsibilities also comprise of ensuring top quality deliverables from Cognizant to client and collection of project metrics.
• Managing offshore resources and involved in technical coordination.
• Direct less experienced team members in investigation, data gathering and analysis. Make work assignments, check output, and provide instruction and end-user . Review results and prepare recommendations
• Perform tradeoff between implementation, schedule and cost and resource constraints, and recommend alternatives. Provide technical feedback, inputs and consultation to other organizations involved in system design or implementation activities
• Setup guidelines and prioritized work requests to handle contingencies and meet set goals.

Confidential, Oak Brook, IL

Responsibilities:

• Played the role of senior developer and Onsite Co-ordinate for all developments with offshore team for ACE Business Transformation Project
• Responsible for communicating extensively and effectively with client, to design and build a Complex design for BT program. Through Workshops and meetings gathered client requirements and proposed the design to be built in Informatica to fulfill the requirement and developed High Level Design Document.
• Data integrated different source and target databases like Oracle, MS SQL Server, Teradata, DB2 using the ETL tool.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, and dynamic Lookup and Router transformations for populating target table in efficient manner.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.
• Managed Cut-over during BT Phase 1, Phase 2 and Phase 3 Go-Live.
• Prepared the High Level Design with the technical inputs to meet the desired functionality.
• Took part in quality reviews of code bundles and TS before delivery to the client.
• Developed complex mappings
• Co-ordinate with offshore team and ensure on-time and defect free delivery
• Setup guidelines and prioritize work requests to handle contingencies and meet set goals

Confidential

Responsibilities:

• Installation and Configuration of different software’s like Informatica, Business Object etc.
• Analyzing and Gathering Requirements
• Preparing the Business System Design document.
• Design Aggregate Table based on Reporting requirements.
• Designing data-mapping and ETL Strategy documents.
• Developing ETL routines in Informatica
• Creating Perl Script used for System Integration.
• Involved in creating unit test cases.
• Monitor nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use;

Confidential

Responsibilities:

• Shouldering overall responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance with Cognizant quality control standards and business practices and procedures.
• Have developed a level of competency, which helps to anticipate issues and solve them in advance.
• Maintained/Monitored end to end data transformation and delivery workflows.
• Performed Coding, Testing and deployment activities.
• Perform Unit, Functional, Integration and Performance testing there by ensuring data quality
• Acquired Email and Telephonic etiquettes, analytical skills, problem solving and trouble shooting skills by identifying the elements and relationships of a problem in a systematic way.
• Performed various root cause analysis and elimination to improve system stability. Followed corrective /preventive maintenance methods and transition processes to ensure adherence to SLA.
• Performed peer review of the code written by team member.

Confidential

Responsibilities:

• Involved in designing and developing complex mappings in Informatica to extract, transform, cleanse and load data.
• Prepared design documents.
• Responsible for development, Unit and integration testing of the application.
• Excellent experience of Trouble shooting problems during the course of work.
• Updating the Process and Functional Specification in accordance with the changes made
• Interaction with customer/onsite coordinator on daily basis in resolving queries and ensure delivery on-time.
• Analyze, design, develop and maintain Informatica ETL and Oracle DAC scripts in support of an implementation of Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics) for a large Siebel 8.0 CRM Field Service application environment

Confidential

Responsibilities:

• Designing data-mapping documents during design phase.
• Developing mappings in Informatica during development phase.
• Involved in creating unit test cases, development and testing the routines developed.
• Writing shell scripts.
• Preparing mapping documents.