SUMMARY

• More than 8 years of experience as a Data Warehouse Consultant/Developer in Data warehousing,Business Intelligence (BI) Solutions design & development.Business Intelligence area dealing with data analysis, solution design metadata management and MDM.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Extensive experience in Siebel 7/8 implementations, administration & configuration.
• Expertise in Tableau, OBIEE and Pentaho Analyzer.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools,MicroStrategyData Warehouse Data Modeling and Design.
• Experience in Data Modeling and Database Architecture in OLTP and OLAP environment based on functional requirements.
• Experience in Design and Implementation in Business Objects 4.0, XIR3/ XIR2/6.5, Web Intelligence, Oracle, SQL Server and DB2.
• Installation and Configuration of Informatica MDM Hub, Cleanse and Match Server, Informatica Power Center.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
• Experience in Teradata Enterprise Data Warehouse (EDW) and Data Mart.
• Extensive experience as BI solution architect and in other BI tools like Datameer 3.0.1, Tableau etc.
• Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules. Implementing MDM solutions and real time enterprise application integration.
• Coding of sample test case programs in Java, C/C++, PERL, and for problem isolation.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Have extensive working experience with IBM tools like IBM Cognos Business Intelligence, IBM DB2, IBM InfoSphere Streams, and IBM Content Analytics for search, IBM InfoSphere Data Architect, IBM WebSphere Application Server, IBM WebSphere Portal, IBM Rational Application Developer and IBM Rational Team Concert(IBM InfoSphere Information Server 8.5/8.1/8.0/7.5/7.0 ).
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000, 2008 r2, 2005.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Experience in Other Utilities/Tools/Scripts likeKorn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1and Visio 10.0.
• Installed, Configured OBIEE 11g and Migrated OBIEE 10G to 11G.

TECHNICAL SKILLS:

• BusinessAnalysis
• Design ofDataWarehouseDevelopments
• Tableau
• Talend
• MDMS
• CICS 3.2 4.1
• COBOL
• RUP
• OBIEE
• Master Data Management
• DB2
• Design ofBusinessIntelligence Developments
• Agile
• Consultancy
• BABOK
• Microstrategy
• DataModeling
• BI Dashboards
• Siebel 7/8
• ETL Developer
• MDM
• BI Reporting
• SQL programming
• Advanced Analytics
• DataMining
• Teradata
• Project Management
• OOAD
• BI Trainings
• Pentaho.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Warehouse Developer/Consultant

Responsibilities:

• Working on the Open Source ETL tool Talend Open Studio for Data Integration is used to Extract, Transform and Load data from the MLS data bases to the client data base.
• Implemented a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.
• Advanced techniques in MS SQL Server, Vertica, OLAP Cubes, Tableau and PivotTable are utilized in daily work.
• Advanced use of Microsoft SSAS and SSIS in multi - platform BI environment (Microsoft / Oracle).
• Working on analyzing the requirements and framed the business logic for the ETL Process using Talend 5.3 and Pentaho 4.5.
• Working onEDW logical and physical data models. Once business information was logically mapped, it fell upon me to determine the best way to integrate new information into the existing logical model.
• Working on preparingData Mapping between Siebel 8 Data Element and SOA Entities for various integration touch points.
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Working on the supporting the Teradata Enterprise Data and Analytics platform including mentoring, best practice recommendations, and executing for the project.
• Tableau dashboard optimization following reporting best practices (Tableau Data Extract, Materialized Viewetc.).
• The execution was mainly based on the custom UI, configured against the core MDM Hub.
• Informatica MDM Hub 9.0 is used as the core MDM Hub.
• Development of custom reports for ERwin using Crystal Reports.
• Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
• Populate MDM configuration tables through Management Agent & console process.
• Responsible for Installing, Mastering data with InfoSphere MDM Server.
• Contributed in troubleshooting & support of IBM Infosphere 10.1/11 by applying fixes from IBM fix central.
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Develop migration plans to move Microsoft Exchange accounts to our MDM enterprise server.
• Upgraded the MicroStrategy Platform from 8.1 to 9.0
• Used Object Manager to promote objects from Microstrategy development to QA & production environment.

Environment: Mainframes, DBA, Hyperion Essbase 9.3.1/11x, Tableau (8.0,7.0,5.2),Erwin 7.3,7.2, MicroStrategy 9.3/9.0.1/8.12 COBOL,MDMS 10.1, IBM Info Sphere, CICS 3.2, 4.1, JAVA,OBIEE, SharePoint, Crystal Reports (10.0,9.0,8.5), JCL, DB2, Visual Basic, Oracle, Teradata, UNIX, Rose, MS office, Cognos, Business Object, MS Word, MS Excel, Pentaho, Agile, Siebel 8, OOAD, Talend, MS Visio, SAS, LoadRunner, WinRunner.

Confidential ., Bridgeport, CT

Data Warehouse Developer

Responsibilities:

• Initial Solution Design using IBM MDM v11 software.
• Define downstream targets for MDM with design for attributes and sync methodologies.
• Provide exceptional Teradata database administration services for the customer's production environments.
• Effectively used data blending featurein tableau to get data from SQLServer & MS Excel.
• Worked on BI solution based on Pentaho platform and components used, Pentaho Reports, Pentaho Data integrator, Pentaho Analyzer, Mondrian cubes,
• Working with the enterprise data warehouse team (EDW) forPeople’sunited.
• Worked on the design, development and testing of Talend mappings.
• Logical and Physical data model design.
• Golden master definition for Single View of Customer.
• Provide integration support toDataStageteams for downstream integration.
• IBM Initiate broker configuration for data sync with sources and message processing based on source priority.
• Designed Analysis Phase document using BABOK methodology.
• Worked on the high-level design using design patterns and Object Oriented programming and OOAD concepts.
• Worked on building BRD for Siebel 8 for the project.
• POC for integration to IBM BPM server for workflow integration into MDM using v10.1 software.
• Created ETL job infrastructure using Talend Open Studio
• Writing a basic java client forWeb servicesintegration with BPM.
• Configuring MDM for Product domain attributes.
• Identification and configuration of MDM services for consumption in BPM.
• Collaboration with IBM teams in UK and Austin TX for bringing together the solution.
• Worked on creating the jobs and transformations in Pentaho Kettle to move Oracle data pump files.
• Devised and developed enterprise level agile software methodology that resulted in delivering high quality software.
• Worked on Teradata Physical Data Modelling and indexing strategies.
• Identification of Data Domains for MDM such as Patient, Organization and Physician etc.
• Initiate install and Configuration, Source Definitions, Match Algorithm Design, Weight generation, Threshold Analysis, Task Planning and Bulk Match Job Designs.
• Working on the upgrading & deploying Siebel 8 using LDAP authentications
• Custom Code Design for integration to downstream ODS and Data Warehouse for BI needs.
• Worked on to plug the Talend jobs into the ETL framework.
• Recommendation of MDM Best Practices in overall strategy.
• Worked on designed and developed Pentaho jobs and transformations to load data into dimensions and facts.
• New Composite Services Designfor lookup andupdate services in MDM Server and troubleshooting MDM response.
• Worked on designed Testing Planning and Preparation document using BABOK methodology.

Environment: Windows, JAVA,DBA, MicroStrategy 9.3/9.0.1/8.12 , Tableau (8.0,7.0,5.2), IBM Info Sphere, Erwin 7.3,COBOL,MDMS 10.1, Hyperion Essbase 9.3.1/11x, Crystal Reports (10.0,9.0,8.5),MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, SharePoint, OBIEE, Teradata, Oracle, Crystal reports, RUP, UML, Business Object, Visual Basic, SQL, SWOT analysis, Pentaho, OOAD, Siebel 8, Netezza, Win Runner, Agile, Talend.

Confidential, Wilmington, DE

Data Warehouse Developer

Responsibilities:

• Conducted design review of data models, cube designs & ETL architecture. Led DW/BI best practices sessions and suggested design changes to processing/querying bottlenecks.
• Worked on ETLexceptions handling, compliance tracking and data reconciliation.
• Collected and studied the Metadata about the master data for MDM and the transactional data.
• Created ETL test data and tested all ETL mapping rules to the functionality of the Informatica mapping and Ab Initio graphs.
• Install, configure, upgrade, maintain and monitor Oracle Applications (10.7/11/11.5.7/11.5.10.2 ), Oracle databases (9i/10g) and Oracle Application Servers (9iAS/10g) in a UNIX environment.
• Create Conceptual and Physical Data Models for the source system using Erwin 7.3.
• Tailored product for each client providing customizations in data warehouse, ETL mappings, OBIEE Answers, Dashboards & BI Publisher.
• Create Logical and Physical Data Models for Vertica using Erwin tool.
• Handled Teradata performance SQL Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• SQL Server migration from SQL 2005 to 2008 for all environments.
• Migrated several SQL Server 7.0, SQL Server 2000 databases to SQL Server 2005 and 2008.
• Troubleshot SSIS packages, SSAS cubes and SSRS reports issues.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Collaborated with hardware vendors to identify and procure server hardware for Siebel 8 upgrade project.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Used MicroStrategy Data Mining Services to create different predictive models like Linear & exponential regressions to forecast End of the Month numbers.
• Generated advanced reports in Grid, Graph and SQL mode, consisting of data analysis by combining a template with filters using MicroStrategy Desktop and Web
• Proposed data mart architectural design to Data Modeler using ErWin as data modeling tool.
• Update MDM elements to report and maintains metrics appropriate for tracking performance.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere andCognos.
• Involved in converting existing Crystal Reports to Business Objects as part of effort to convert to Business Objects.
• In utilizing Business Intelligence tools for the design and deployment of Data Marts supporting Enterprise Data Warehouses.
• Re-designed and updated ERwin logical and physical models of data warehouse structures that identified and documented changes for multiple ERP data sources.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Performed bulk data load from multiple data sources and Flat files to Teradata RDBMS using BTEQ, Multiload, FastLoad and UNIX shell scripting.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, AbInitio Graphs and Teradata scripts
• Modify existing Informatica mappings to utilize Power Exchange sources and Oracle and Netezza targets.
• Participated in Proof-of-Concept using IBM Info Sphere as a tool to move data between DB2 subsystems and between non-homogeneous RDBMS (DB2, Oracle and SQL Server).
• Providing Data Quality support in the process of migration of the fact and dimension tables from Oracle to Netezza platform.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.

Environment: Windows, JAVA,DBA, MicroStrategy 9.3/9.0.1/8.12 , Tableau (8.0,7.0,5.2), IBM Info Sphere, Erwin 7.3,COBOL,MDMS 10.1, Hyperion Essbase 9.3.1/11x, Crystal Reports (10.0,9.0,8.5),MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, SharePoint, OBIEE, Oracle, Crystal reports, RUP, UML, Business Object, Visual Basic, SQL, SWOT analysis, Siebel 8, Netezza, Talend, Win Runner, Agile.

Confidential, Atlanta, GA

Data Warehouse Developer

Responsibilities:

• Performed logical/physical data modeling, data distribution, Forward/Reverse Engineering of Data Models using AllFusion ERwin 3.x/4.x Data Modeler.
• Review and analyze data mapping document to determine ETL program design.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline toETLCoding.
• Managed product releases of MDM PIM by planning and coordinating the activities across multiple groups in the engineering organization.
• Designed Physical Data Model using Erwin 4.1 for Projection and Actual database Worked with object modelers, worked with Business Analysts.
• Represented the development organization in the Offering Team of multiple MDM product releases.
• Using OOAD Technology, classes were designed in UML with the help of Rational Rose tool.
• Worked on Installed and configured multiple environments for Siebel 7.7.2 implementation.
• Involved in defining the source to target ETL data mappings, business rules and data definitions.
• Proposed and implemented several enhancements and design improvements within Siebel 7
• Followed solely RUP methodologies during the course of the project.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Coded the Korn ShellScriptsfor pushing and pulling data to and from the Server, Merging the files and placing it in the server etc.
• Using UNIX console commands to check database has been connected the other functionalities.
• Data mapping, logical datamodelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Helped with Data Mapping between the data mart and the Source Systems.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Worked on Siebel 7 - OBIEE ETL process/ Report enhancements and data mapping.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, MS Office, Teradata, SQL Server Reports, WinRunner, Siebel 7, LoadRunner, Quick TestPro, OOAD, Agile.

Confidential, Dallas, TX

Data Warehouse Analyst

Responsibilities:

• Interacted with Business Users to conduct thorough Requirements Analysis.
• Created and scheduledSessionsbased on demand, run on time and run only once usingInformatica Server Manager.
• Responsible for Unit Testing of Mappings and Workflows.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Datamodellingwas performed using ERWIN tool to build logical and physical models.
• Designed and implemented the HR Business Intelligence data warehouse and ETL (extract transform load) utilizing Oracle Business Intelligence Enterprise Edition (OBIEE) and PL/SQL.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Developed the ETLInformatica Mappings for importingdata from ODS into subsequent data marts.
• Involved in Managing Data modelling project from Logical design and implementation of SybaseDatabase
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner