SUMMARY:

• Over 18 years of experience in the IT industry.
• 10 years of experience in data warehousing technologies using Informatica Power Center Client, Developer Client
• 8 years of experience using Siebel Analytics/OBIEE/DAC
• 5 years of Database Administration experience in SQL Server
• 5 years of experience in generating reports using Crystal Reports, SQL Server Report services, BI Publisher
• Knowledge of .net framework, Siebel data model and Siebel tools
• Team Leadership experience

PROFESSIONAL EXPERIENCE:

Confidential, MD

Senior Consultant

• Design, develop and Support BI Publisher Reports
• Design, develop and Support Informatica mappings
• Implemented Informatica IDQ for validating external vendor files, that includes Profiling, data validation rules, Scorecards etc
• Lead Reporting and PL/SQL Teams
• Identify and resolve any issues related to reports and database structures that effect report performance
• Integrate BI Publisher with ODRS for users to launch reports as needed.
• Develop scripts to load reference data that are used in reports and ESRD Applications
• Co - ordinate the team in identifying the issues associated to defects and work towards resolving them in timely manner
• Developer database scripts which include functions, procedures, views and Materialized views
• Co-ordinate with Change management team and preparing the deployment plan for deployment of the application in various platforms
• Translate functional requirements into technical requirements for reports development

Environment: Active Directory, OBIEE 11G, Java ADF, Oracle 11G, Bi Publisher, PL/SQL developer, Windows 2003/2008, Informatica 9.6.1, IDQ, Serena Business Suite

Confidential, TX

SIEBEL/OBIEE Consultant

• Support Siebel Marketing 8.1 and OBIEE 10.1.3.4
• Customize out of the box Siebel OBIEE repository which includes creating new subject areas and redefining joins to improve performance for campaigns
• Maintain and Support DAC repository to include new Subject Areas, Task Groups, Tasks, Indexes and Tables as needed.
• Support and trouble shoot Execution plans that are run through DAC
• Design, develop and maintain mappings in informatica for loading data into OBIEE data warehouse database that include slowing changing dimensions and Facts.
• Design and build dashboards and answers in Siebel Analytics Web (SAW)
• Create Segments/Segment trees in OBIEE for use in Siebel Marketing Campaigns
• Support scheduled campaigns that are run through Siebel application
• Administer and support Informatica repository and trouble shoot any issues that arise in informatica processes
• Gather requirements from business users and convert the functional requirements into technical requirements for developing reports

Environment: Active Directory, OBIEE 10.1.3.4, Informatica 7.8/8.6.1, Siebel Marketing 8.1, Oracle 10G/11G, Windows 2003/2008

Confidential, FL

Senior Engineer/Architect

• Support Siebel Marketing and Siebel Analytics/OBIEE
• Implemented Siebel Analytics Clustering and made configuration changes for high availability of Siebel analytics application
• Manage job dependencies through Tivoli and responsible for data integration of Siebel data
• Design, develop and maintain mappings in informatica for loading data from in and out of to Siebel systems
• Maintain and troubleshoot any performance issues that arise in the Data warehouse mappings and optimize as required.
• Design and build dashboards and answers in Siebel Analytics Web
• Make changes to the Analytics repository to support any new business requirements
• Gather report requirements from business users and translate them into OBIEE reports
• Implemented Active Directory authentication in Siebel Analytics
• Lead the team in upgrading from Siebel Analytics to OBIEE 1.3.4

Environment: Active Directory, Siebel Analytics 7.8/OBIEE 10.1.3.4, Informatica 7.8/8.6.1, Siebel Marketing/Loyalty/UCM, Oracle 10G/11G, Windows 2003/2008, IBM Tivoli

Confidential, FL

Database Admin II/Business Intelligence Architect

• Install configure and maintain Siebel Analytics, Informatica, DAC
• Gather requirements and design the data model in the Siebel analytics repository so that users can generate reports
• Design, develop and maintain mappings in informatica for loading Siebel data from OLTP to Warehouse
• Customize informatica mappings to load custom data from Siebel financial services database
• Customize Siebel DAC to include any customized workflow mappings and maintain dependencies
• Design dashboards and answers in Siebel Analytics Web
• Implemented security in Siebel Analytics for data visibility (Data Level) and report visibly (Catalog Level) based on user responsibilities.
• Performance tuning databases both Siebel OLTP and data warehouse and developed a strategy by studying the execution plans and designing efficient indexes which helped in faster response times
• Design and develop DTS/SSIS packages for data transfer and other routine tasks.
• Write procedures to convert data from different systems to SQL server format to feed the website to generate reports, run plans and generate source files for direct mailing

Environment: Active Directory, Siebel Analytics 7.8, Informatica 7.1.2, Siebel Financial Services, SQL Server 2000/2005, Windows 2003, SQl Server Report Services

Confidential, FL

Date warehouse Developer/Database Administrator

• Design and architect logical and physical databases
• Backup, restore and performance tuning databases for optimal performance
• Design, develop mappings in informatica for loading data.
• Develop reports using sql server report services
• Developed COM components in Visual Basic.
• Design the databases in SQL Server and make changes to the table structures for better performance of the system.
• Design and develop DTS packages for data transfer and other routine tasks.
• Write procedures to convert the Oracle data to SQL server format to feed the website to generate reports, run plans and generate source files for direct mailing
• Run Email campaigns and pull the source files for Direct mails.
• Generate response reports by running match back analysis.

Environment: Active Directory, ADO, ASP, Visual Basic 6.0, C++, Oracle 8i, Developer 2000, SQL Server 2000, Windows 2000, Crystal Reports, SQl Server Report Services XML, XSLT, Jscript, VBScript, JavaScript, Oracle Financials, COM+, CDO, Site Server, XMLSPY, Load Runner, Test Director

Confidential, CA

Senior Web Developer/Database Administrator II

• Design the databases in SQL Server and make changes to the table structures for better performance of the system.
• Written stored procedures, EIM process to accommodate the current data in the Siebel data model.
• Written DTS packages, stored procedures, functions and triggers in SQL Server.
• Designed the XML interfaces and write XSL code to display the XML data.
• Written ASP pages, client side code using VBScript, JavaScript and Jscript.
• Improved the application performance by adopting various techniques.
• Developed COM components in Visual Basic.
• Generated reports both at website level and also at database level for sales forecast.
• Developed MSI packages to deploy the websites.
• Written test plans and scripts to do load testing of the websites.

Environment: Active Directory, ADO, ASP, Visual Basic 6.0, C++, Siebel 7, EIM, SQL Server 2000,Oracle 8i, Developer 2000, Designer 2000, Windows 2000, Crystal Reports, XML, XSLT, Jscript, VBScript, JavaScript, COM+, CDO, CSS, Site Server, Wise Installer, XMLSPY, Sonicwall Firewalls, LoadRunner, TestDirector, Load Runner, SonicWALL Firewalls

Confidential, FL

Senior Software Engineer/Team leader

• Design, develop, and maintain all the websites.
• Used Commerce server to design and create the websites.
• Design the databases in SQL Server and make changes to the table structures.
• Written DTS packages, stored procedures and triggers in SQL Server.
• Developed screens and generated reports using Developer 2000/Designer 2000.
• Developed new components to fit them in the Commerce server pipeline application.
• Written ASP pages, client side code using VBScript, JavaScript.
• Integrated Cybersource component for credit card processing.
• Used site server for generating the website reports.
• Written test plans and scripts to do load testing of the websites.

Environment: ADO, ASP, Visual Basic 6.0, SQL Server 7.0, Oracle 7.3, Developer 2000, Designer 2000, Windows 2000/NT, Unix, Jscript, VBScript, JavaScript, MTS, CDO, CSS, Site Server 3.0, Commerce Server 3.0, ER Studio, Erwin, Cobol.

Confidential, AL

Programmer/Analyst

• Design the databases in SQL Server and make changes to the table structures.
• Analysis, Design and implement the T-Log system.
• Written DTS packages, stored procedures and triggers in SQL Server for sending the transaction log details to the financial system.
• Written procedures to feed the Oracle financial systems with the financial data from the website transactions.
• Developed new components to fit them in the Commerce server pipeline application.
• Written ASP pages, client side code using VBScript, JavaScript.

Environment: ADO, ASP, VB 6.0, SQLServer 7.0, Windows NT, VBScript, JavaScript, MTS, CDO, CSS, Site Server 3.0, Commerce Server 3.0, ER Studio, Erwin, Cobol

Confidential

Programmer/Team Lead

• Lead Developer.
• Involved in analysis, Design and coding of the system.
• Developed components in VB for data access and business logic.
• Developed screens and reports using Oracle.
• Design Databases and table structures in Oracle.
• Developed the ASP pages and ActiveX controls.
• Written client side script to handle the client side validations.
• Coding and testing.
• Used crystal reports tool to generate the reports from database.

Environment: ADO, ASP, Visual Basic 5.0, Cobol Oracle 7.1, MTS, CDO, Crystal Reports, Windows NT, Unix