SUMMARY:

• Over 16 years of BI (Business Intelligence) experience gathering requirements and developing projects and reports for Health Care, Financial and Consumer goods industries.
• Over 2 years of experience in Data modeling, Datawarehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM WebSphere DataStage 8.x
• Extensively used Cognos 10.2 product suite in recent projects.
• Over 14 years of IT experience in analyzing, designing, developing and implementation of Client/Server, Web - based and Siebel eBusiness applications.
• About 10 years of experience in CRM applications in Configuration, Integration, Reporting and Customization of Consumer Goods Applications in Siebel 8.1/7.x/6.x/5x using Siebel Tools, eScript, VB Script, EAI, EIM and Workflow. Strong understanding of Siebel Consumer Goods data model.
• Extensive experience in Siebel Analytics/OBIEE (Integrated) implementations. Customized DAC Repository, Informatica repository and worked with OBIEE/Siebel Analytics Administration Tool. Involved in creation of reports, dashboards using Siebel Analytics/OBIEE Answers and Dashboards
• Strong technical expertise on over all process of Business intelligence, Decision support system (Siebeldb (Siebel OLTP data model) - ETL - Siebel data ware house (SRMW OLAP) - Analytics server architecture-Analytics application development).
• Highly skilled in Inbound & Outbound interfaces, using EIM and Siebel Com Data Server With SAP R/3 Application and other Legacy Systems(EssBase, Manugistics) .
• Good exposure in Documentation, Analytical Problem Solving and Defects Tracking. Excellent Written and Verbal Communication Skills.

TECHNICAL SKILLS:

BI Tools: IBM Cognos Framework, Siebel Analytics 7.7 / OBIEE 10.x

ETL: IBM InfoSphere Datastage, SQL Server Integration Services (SSIS), Informatica 8.1.1

Reporting Tools: Tableau (9.2), IBM Cognos, Microsoft SQL Server Reporting Services (SSRS), Crystal Reports XI (2.0), Actuate Developer Workbench 4.0.

Databases: MS SQL Server 2014/2012/2008/2005/2000/7.0, Oracle 8.0, DB2 8.1 and MS Access

CRM: Siebel 99 / 6.0 / 7.7 / 8.1, Tools Configuration, EIM, EAI, Workflow, Assignment Manager, VBScript, eScript, VBC, Business Services

Languages: C, C++, HTML, VB Script, Java, JScript, JavaScript, PL/SQL and XML

GUI's: .Net, Visual Studio 2012/2005, Visual Basic 6.0, Developer 2000

Tools: SQL DTS, SQL Server Integration Services (SSIS), Visual InterDev6.0, Active X, Visual SourceSafe, Clear Case

Operating Systems: Windows 95/98/NT/2000/2003/XP/7, UNIX, MS-DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Edinburg, TX

Business Intelligence Engineer Manager

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Helped in preparing the mapping document for source to target.
• Designed and developed ETL processes using DataStage designer to load data from Netezza, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models.
• Designed, Developed and Automated SSIS packages to create data flat files and be FTP’d to clients site on a regular schedule
• Developed SSRS Reports using Business Intelligence Development Studio (BIDS). Used drill down functionality and built parameterized reports.
• Assisted with creation of reports and conversion of existing reports to the enterprise data warehouse using Datastage, Cognos and Tableau.
• Provided on-going analytical and technical support including maintenance and support of existing data sources, data integration, operational reports and dashboards.
• Worked in cross functional team to improve the query performance of long standing queries in the ETL jobs and reports
• Proactively worked with members of the team to complete assigned tasks as defined by scope, timelines, and budgets.
• Created and maintained technical documentation.

Confidential, McAllen, TX

Software Analyst

Responsibilities:

• Developed SSRS Reports using Business Intelligence Development Studio (BIDS). Used drill down functionality and built parameterized reports.
• Created report subscription to post the report in a folder or email it to a group on a daily/weekly/Monthly schedule.
• Analyzed data using Microsoft SQL server 2008 and Excel as needed.
• Created SSIS Packages to import/export data between the core system and SQL database.
• Created\Scheduled\Monitored the daily Sql jobs.
• Maintained SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Migrated Databases from SQL Server 2008 Enterprise to SQL Server 2008 standard.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Also was Responsible for routine DBA jobs like Backups and Restores
• Maintained legacy VB. NET intranet applications using Visual Studio 2010 and SQL Server.
• Maintain Incentive Scorecard Program using VB .NET, SSIS and SQL Server database tables, views, triggers, and store procedures to ensure correct incentive calculations.
• Collaborate in Web Application User Administration page using C#, ASP. NET, and SQL Server to control user access to web applications.
• Developed Mortgage Referral Web application using C#, ASP. NET, SQL Server to allow bank employees to submit mortgage loan referrals.
• Developed Purchasing Admin Order Reporting Web Application using VB .NET, ASP .NET, and SQL Server.

Confidential, Durham, NC

Snr. Systems Engineer

Responsibilities:

• Supported multiple Siebel implementations and related applications. Worked as a part of the Channel Support team to provide second and third level support for these environments. Additionally, I also worked on strategic projects with business partners and systems groups providing technical services on a wide range of technologies, running primarily on Windows platforms.
• Provided 2nd and 3rd level support for multiple Siebel CRM environments, on versions ranging from 7.5x to 8.1x.
• Participated in and/or lead infrastructure build activities as appropriate
• Applied patches/fixes to the Siebel application.
• Maintained the current response and availability service levels with different business units.
• Monitored and resolved incidents associated to this product suite.
• Worked with the team in resolving production issues and co-ordinated support activities with other technology partners.
• Interacted with the onshore team as required, for issue resolution, status updates, product metrics, etc.
• Participated in Siebel On-call rotation and occasional after hours support
• As requested/necessary, supported weekend change windows
• Ensured all activities adhere to ISO20K frameworks.

Confidential, Greenwich, CT

Snr. Solutions Programmer Analyst

Responsibilities:

• Upgraded the Siebel Analytics reports to OBIEE 10.1.3.4.1. This was done to support the OS upgrade to Vista.
• Upgraded the repository and web catalog.
• Created new reports.
• Worked on Pre-built RPD to customize Consumer Sector and Core Subject Areas.
• Involved in the upgrade of the Trade Promotion Management application from Siebel 99 to Siebel 8.1(Hydro Application)
• Developed the Account Assignment process in Hydro which can be used to assign accounts periodically and also can be used for huge organization change. Used .Net, SSIS Package and Siebel Com Objects
• Also developed the load zero volume process for direct accounts, which was later used by the consultants to develop the same for MSA accounts. .Net, SSIS Package and Siebel EIM
• Maintained the interfaces to and from Hydro.
• Worked with EBC to provide a real time lookup of external systems data
• Developed OBIEE reports for the Hydro application.
• Involved in creation and testing of complex measures in RPD.
• Designed and customized Informatica repository to create/customize SDE and SIL mappings, workflows and Sessions for ADL (Dimension table) & Price list (Fact Table) to suit the customer requirements.
• Lead the upgrade of the Radar application from Siebel 6.0.4 to Siebel 7.7.2.2 (SAM: Sales Account Management)
• Created the gap analysis
• Worked on moving data to S Party table structure
• Developed custom objects: Business components, Business objects, Links, Joins, Picklists, Applets, Views, Screens.
• Converted Vb Scripts to eScripts.
• Developed Workflows and Business service.
• Developed Siebel analytics (7.7) reports to support the SAM application. These reports were used by the Business users to understand the Account/Product penetration and measure their KPI’s.
• Integrated the Siebel analytics (7.7) reports to be viewed from within Siebel (7.7) eBusiness application.
• Supported and maintained the Informatica ETL and DAC mappings. Developed the ETL SIL mappings to import data from TdLinx which was sent as Dbase file.
• Trained business users in using Siebel Analytics Answers application to develop adhoc reports.
• Involved in Administration and migration activities of RPD, INFA rep and DAC rep from Dev-Test to Production.
• Involved in the development of Customer Management -RADAR(Retail Account Development And Reporting) application using Siebel Consumer Goods for multiple organizations.
• Developed Customer Management application using RAD development tools and technologies.
• Configured ( created new custom & modified existing vanilla objects) functionality in the RADAR application using Siebel 6.0.4 to:
• Schedule and Manage Retail Execution Activities.
• Track Execution of Retail Account Activities.
• Collect and Report on Retail Account Audit Data(NWNA & Competitors)
• Collect Contract Data
• Create Payment Schedule for Contracts
• Create Payments against Contracts
• Communicate between Account Sales teams.
• Participated with the selection, design, development, implementation and support of CRM solutions to address Opportunity Management, Account Development/Management, Retail Execution & Asset Management tools acquired by Nestle’s Sales Direct Initiatives.
• Supported and maintained the Siebel TPM application - Trade Funds & Promotion management, Customer Commitments & Settlements, and Sales Annual Planning Process. (Siebel 99)
• Configured the application to enable planning of funds at different level of accounts /products depending on the fund type. Used Siebel Tools(99) to configure Application and Business Objects layer.
• Developed the functionality to transfer amounts between funds and captured the audit trail.
• Made enhancements to the GUI and functionality in order to enable the business users to Plan Volume, Fixed Funds and Variable Deals.
• Developed a Process using Siebel Com interfaces to accommodate the rollup of volume, variable spend amount and fixed funds amount across the Organization hierarchy.
• Developed EIM process to load volume & variable deal data from excel to support the yearly planning process.
• Assisted the Business team during the year end process by developing a automated process to load Organization hierarchy modifications.
• Developed and maintained interfaces to SAP and other systems for the following: Master Data, Commitments, Payments, Settlements, Volume Actuals, Fixed Funds Accruals and Essbase. The interface was developed using Vb Com objects, DTS packages and Siebel EIM.
• Used Siebel Anywhere to distribute srf, cfg, and Siebel patch to remote users.
• Provided on-going 2nd level support, maintenance, and enhancement of the Retail Siebel applications used for Nestlé’s Trade Promotion Management activities (i.e. Customer Volume & Spending Planning, Trade Promotion Planning & Trade Funds Management) and Nestlé’s Customer Relation Management activities ( i.e. Account Management, Retail Execution, Retail/ HQ Activities Management & Asset Management)
• Collaborated with business units to assess the impact of new business requirements on development schedule and milestones.
• Gathered requirements, identified potential usability issues.
• Helped the team to reach a consensus by offering an alternative solution that allowed to maintain a robust and flexible architecture.
• Created process flow and database design diagrams.
• Produced and maintained project plans.
• Trained and educated a group of 300 business users at Las Vegas, Dallas and Tampa conventions on application usage front.
• Wrote various technical documentations and user reference manuals.
• Worked with Siebel systems Tech support for unknown issues/Bugs or any other product defects.
• Developed Unit Application Testing scripts.

Confidential, Greenwich, CT

Responsibilities:

• Worked at Confidential as a Siebel Integration Consultant in designing & developing interfaces for business data flows between Siebel and SAP R/3
• Involved in the deployment of Siebel .Com Application using Siebel eBusiness. Created HTML Template. Modified the vanilla database to use the new templates. Used LDAP for login purposes.
• Designed, Developed and Automated the Inbound and Outbound Interfaces using Siebel EIM, Siebel Com Data Server, DTS(Data Transformation Service)
• Performed the Business Analysis by identifying Business Objects/Business Components/Process Selection.
• Performed GAP analysis between Siebel Objects and SAP Objects. Identify the possible process rules
• Designed and developed Master Data Synchronization (Accounts, Products, Price List, etc.) between Siebel and SAP Systems.
• Designed & Developed common error handling mechanism for all Interfaces.
• Developed Controls for Error Notification and Auditing purposes.
• Responsible for designing, developing, implementing, and supporting the following Siebel Com Data Server based Inbound/Outbound interfaces:
• An inbound interface to load master data Accounts and Products into Siebel from SAP having daily business data flow.
• An inbound interface to import Price List, Actuals (Sales) from SAP
• An outbound interface to export Sales deals, Commitments, Lumpsum accrual into SAP System
• A daily inbound interface to import Settlements from SAP system
• A daily outbound interface to post Siebel payments into SAP
• Customized the "Vanilla Siebel 99" using Siebel tools to meet the business requirements. Involved in the configuration of Siebel Enterprise Applications at the User interface layer, Business Object layer and Data Object layer.
• Created / Modified Business components & Business Objects according to the business needs.
• Created /Modified Applets, Views and Screens in the Siebel User Interface layer to meet the business functionality. Implemented View Drill Downs, Dynamic Toggles, Picklists and Multi Value Groups.

Confidential, Texas

Programmer/Analyst

Responsibilities:

• Worked as a Visual Basic Programmer.
• Involved in developing & maintaining the system. Developed front end and database changes according to the requirements
• Generated various reports for the users using Crystal reports.
• Generated a web-based report using Cold Fusion and HTML.