BACKGROUND SUMMARY:

Over Twelve years of Software Industry experience in Design, Development and Support of Software Applications over entire Software Development Life Cycle

Over five years of experience in managing ,leading of development teams and coordinating client users and business partners in various projects. And over three years of experience in managing/coordinating with offshore teams

Over Four years of experience in Siebel Analytics 7.8/OBIEE (10.1.3)/DAC and in configuring repository using Siebel Administration tool, design Siebel Intelligent Dashboard, reports, Siebel Answers, and iBots

Four years of extensive experience in development of OLAP tools using COGNOS 7 – Impromptu, Cognos Server Administration and Cognos Power Play. Primary technical expertise in the area of COGNOS development, administration, installation and configuring servers and maintaining Cognos environment using Cognos Tools

Over Eight years of experience in Database development/Administration/Data Modeling/Data Warehousing / Business Intelligence in various roles including ETL of data using DTS, SSIS, Informatica & Ascential Datastage. Logical, physical and dimensional modeling of data using Visio & ERStudio with SQL Server and Oracle databases.

Over Five years of experience in implementing Siebel 7.7 ePharma - SFA (Sales Force Automation) and design/development of client-server/N-Tier applications using Visual Interdev 6.0 and Visual Studio.NET . Design & development of reports using crystal reports and crystal enterprise server configuration and deployment of client-server applications using Install Shield.

TECHNICAL SKILLS:

• Cognos: Cognos ReportNet, Cognos Frame Work manager, Cognos Report Studio, Cognos Query Studio, Cognos Impromptu 7.x , Impromptu Web Reports -IWR, Cognos PowerPlay ,Access Manager, Cognos Query, Decision Stream, PowerPlay Transformer, Scheduler, Visualizer, Cognos Metric Manager ,SQL Plus and Cognos Metadata Migration Utilities
• Siebel: Siebel Analytics 7.x/OBIEE 10.1.3, Siebel 7.7 Tools, DAC,Siebel EIM, Siebel Assignment Manager
• Business Objects: Crystal Reports 7.0/8.0/8.5/9.0
• Environments: Windows NT, Windows 95/98/2000/XP, MS DOS
• Databases:SQL Server 6.5/7.0/2000/2005, MS Access 97/2000/2002/2003, Oracle 7.x/9i/10g
• Database Design Tools: Embarcadero ERStudio 7.5, Micro Soft Visio
• ETL Tools: Informatica PowerCenter 7.x/8.1.1, Ascential DataStage 7.5, Ascential QualityStage 7.5, SQL Server 2000 DTS/SQL Server 2005 SSIS
• Microsoft Software:Visual Basic 5.0/6.0, Visual Interdev 6.0(VB & ASP), Visual Studio.NET 2002/2003 (VB.NET & ASP.NET), Visual Source Safe, Front page, MS Access, Share Point Team Services
• Package Software: Install Shield
• Languages:VB, VBA, C#, SQL, PL/SQL, Java Script, VB Script, HTML, XML, Siebel VB

PROFESSIONAL EXPERIENCE:

Confidential, Nutley, NJ

Projects: Max-IS Siebel 7.8 Sales Force Effectiveness (SFE) Tool – Analytics
US Contact Center –Call Center OBIEE Reports
Environment: Siebel Analytics 7.8, Disconnected Analytics 7.8, Siebel DAC, Oracle BI 10.1.3,
Informatica PowerCenter 7.1.2/8.1.1, Oracle 9i

• Onshore Team Lead for Offshore IDC Team: Work with offshore analytics/OBIEE/ Informatica team, gather requirements from client, define technical design specifications, define project plan, assign/review development work with offshore team and support
• Coordinate with client and set up daily status meeting with offshore team, review and analyze the project progress and discuss next tasks.
• Manage and coordinate with client users for their problem solving and resolution
• Disconnected analytics ePharma applications: Review offshore team work and worked in creating, defining and developing of disconnected application configuration xml file, sourcing reports, Sourcing queries(DDL for disconnected tables),Defining Data Sets,application directories, Silent Installation, disconnected repository (RPD) and webcat files
• Review offshore team work and also worked in creating custom mappings using and Source Qualifier, Lookups, Aggregator, Update Strategy using mapping designer. Worked in creating workflows, worklets and tasks using Workflow Designer.
• Onshore production support in Scheduling the Execution plans and monitoring the ETL jobs using DAC
• Coordinate with offshore/onshore QA team during the system test, bug fixing and issue resolutions.
• Worked in design, development and configuration of RPD, Dashboards and Reports
• Created dimension hierarchies and other complex metrics like time comparisons and share measures.
• Implemented Siebel Analytics security at user and data levels utilizing variables and initialization blocks in the repository. Administration of user securities and webcat folder and Implemented caching to increase performance.
• Created, modified and formatted client adhoc requests including charts and filters, in Siebel Answers.
• Developed Siebel Delivers/iBots for delivering reports, personalized alerts and schedule iBot for subscribed users.

Projects: Sales and Marketing Adhoc Reporting (SMART)
Global Finance - Product Sales (PROS)
Global Marketing Research – Sales and Marketing Data

Environment: ERStudio 7.5, Siebel Analytics 7.8/Oracle BI 10.1.3, Informatica PowerCenter 7.1, Oracle 9i/SQL Server 2005

Lead the project and worked on defining on Siebel analytics/OBI, data modeling and ETL for this project

• Lead and Manage the onshore/offshore development teams for Siebel analytics/OBIEE and ETL development
• Coordinate with users, review the user requirements and analyze the data for OLAP design
• Designed OLAP data warehouse, data models, star schemas and indexes for optimizing performance.
• Data modeling with ER Studio and defined data architectural standards and designed database architecture
• Define ETL mappings using Informatica PowerCenter , prepare ETL data dictionary and lead the offshore ETL team for ETL projects to load the data from Oracle OLTP database.
• Took responsibility for overall delivery of analytics development and acted as primary point of contact for issues and problems
• Extensively used Analytics Administration Tool to design, develop & configure physical, business and presentation layers in analytics repository
• Worked in design, development and configuration of RPD, Dashboards and Reports
• Designed costume time dimension for MAT, YTD and QTD to improve the performance.
• Created dimension hierarchies and other complex metrics like time comparisons and share measures.
• Implemented Siebel Analytics security at user and data levels utilizing variables and initialization blocks in the repository.
• Administration of user securities and webcat folder and Implemented caching to increase performance.
• Created, modified and formatted requests, along with charts and filters, in Siebel Answers.
• Utilized Siebel Delivers/iBots for delivering reports, personalized alerts and schedule iBot for subscribed users.
• Support global finance team for any ad hoc reports and existing project
• Setup training sessions with sales & finance users to introduce and train new OBIEE tool & reports

Global Marketing Research – Sales and Marketing Data
Environment: Cognos Series 7.3, Ascential DataStage 7.5, SQL Server 2000/2005, SharePoint Portal Services,
Visual Studio.NET 2003, Siebel Analytics 7.8

• Coordinate, conference and follow up with DOANE & DMR vendors on marketing Data Analysis.
• Coordinate/manage offsite developers for data stage jobs development
• Marketing data analysis for the creation of data mart including fact and dimensional tables/views.
• Review catalogue, joins, catalogue level filters and cubes of cognos environment and identify technical requirements for migrating to Siebel analytics
• Defined and designed various cubes/reports as per user requirements
• Support GMR team for any ad hoc reports and monthly/quarterly data processing
• Prepared operational documents, user guides and technical specification documents for the projects

Database Development, Administration and Data Warehouse

SQL Server 2000/2005

• Server Installation, administration, data base designing with referential integrity, indexes,
• Create stored procedures, clusters, triggers, views and performance tuning of slow queries,
• Worked in defining server user logins, database securities, users and roles
• Created and defined agent alerts, Email operators and Jobs and schedule jobs
• Worked in database migration including server installation from SQL Server 2000 to SQL Server 2005
• Worked with SQL Server 2005 using SQL Server Management Studio, Business Intelligence development Studio for designing & developing ETL packages
• Extensively worked on data modeling, ETL and start schemas on all the projects

Oracle 9i

• Database maintenance, data load using PL/SQL. Create database, define indexes, and create stored procedures, views and triggers

Informatica PowerCenter 7.1

• Defined and prepare requirement document into technical specifications
• Defined source-to-target ETL field mapping using Informatica PowerCenter , prepare ETL data dictionary and lead the offshore ETL team
• Developed Informatica mappings, mapplets, workflows, worklets, error handling processes and scheduling strategy
• Troubleshoot and resolve performance issues in Informatica Power Center mappings and workflows;

Ascential Datastage/Quality Stage 7.5

• Defined ETL field mapping and requirement documents
• Created datastage functions/routines to implement data validations
• Developed and scheduled ETL jobs and sequence jobs and created hash files as intermediate stage(lookup) in the datastage jobs and used sequential files to extract data from text files
• Used different types of databases like ODBC,DRS Stage to extracts data from or loads data into databases
• Used different types of processing like Aggregator, transformer, link partitioner, link collector

Cognos Development & Administration

Projects: Sample Administration and Management System; Siebel - ePharma – Sales Force Automation;
Sample Administration and Management System; Call Accounting System

Environment: Cognos Series 7.0, Visio, SQL Server 2000, Cognos ReportNet, Report Studio.

• Worked in establishing the Cognos Reportnet development environment. Installed Cognos Framework Manager, Report studio and set up Cognos server configuration
• Designed User Requirement document and system requirement specification for report development.
• Designed models using Framework Manager and deployed packages to the ReportNet Servers
• Designed and developed standard reports using Report Studio and created Ad hoc reports using Cognos Query Studio.
• Worked in migrating Architect and Impromptu metadata to Cognos ReportNet using Cognos Metadata Migration Utility
• Manage, lead and coordinate with cognos team and also worked in Creating catalogue, defined joins, catalogue level filters, definitions, cascade prompts and maintained shared, distributed catalog using Impromptu .
• Created User Classes, Users and define filters for user level in the catalogue for developing various reports List, Cross Tab and cubes.
• Defined the schema, create data sources by using Impromptu Query Definition (IQD), create power play model with multiple dimensions and levels as per requirements using PowerPlay Transformer and Created cubes.
• Create drill down reports and define in model to drill through and to analyze the detailed level report through any level and dimension.
• Published Impromptu reports, Power Play reports & Cubes to Upfront through Power Play Enterprise Server administration and defined the Cube Securities.
• Created executable file using VB.NET, schedule the file to execute reports bursting and email to respective sales representative.
• Created Cognos scripts to automate the process for rebuilding the cubes. Maintenance and Production support
• Coordinate with QA team during in bug fixing and issue resolutions.

Database Administration and Data Warehouse Activities

SQL Server 6.5/7.0/2000

• Server Installation, administration, data base designing with referential integrity, indexes,
• Extensively worked in designing DTS packages (ETL) using strong Transact-SQL development skills and perform legacy data loads.
• Create stored procedures, clusters, triggers, views and performance tuning of slow queries,
• Worked with Microsoft OLAP Services and Analysis Services
• Worked in maintenance including back up and restore, SQL Profiler, SQL Current Activity and Performance Monitor, Replication Monitor, Migrations and Upgrades
• Worked in defining server user logins, database securities, users and roles
• Define linked servers to communicate between multiple servers
• Created and defined agent alerts, Email operators and Jobs and schedule jobs
• Worked in database migration including server installation from SQL Server 7 to SQL Server 2000
• Worked in Setting up SQL Server Replication, define and manage merge replication, publication, subscriptions, snapshot and define and set up articles, filter columns, filter rows.
• Extensive knowledge of SQL Server 2005 using SQL Server Management Studio, Business Intelligence development Studio for designing & developing ETL packages, Configuration tools like SQL Server Configuration, Reporting services configuration, Developing & Deploying Reports and analysis services

Oracle 7.x/9i

• Database maintenance, data load using PL/SQL. Create database, define indexes, and create stored procedures, views and triggers
• Extensive Knowledge in using Oracle 10g

Application Development

Siebel- ePharma – Sales Force Automation
Environment: Siebel 7.7 Tools, Siebel EIM, Siebel, SQL Server 2000

• Worked in preparing User requirement Documents, System Requirements specifications, roll out and installation procedures.
• Configuration, Customization and Maintenance of ePharma SFA Application as per requirements.

Sample Administration and Management System – (Validated System)
Environment: Visual Studio.NET 2002 (VB.NET), VB, MS Outlook, SQL Server 2000, Crystal reports 9.0
This system is designed to enter and track the Sample distributes to practitioners and weekly inventory. This system is part 11 compliance validated system.

• Meet with key users, gather business requirements and analyze and prepare user requirements documents(URD), system requirements specifications, roll out and installation procedures.
• Lead the developers team to assist in various modules under this system and deliver the system on specified time
• Coordinate with QA team during the system QC period.
• Designed the prototypes for all modules under this system. Designed and developed Main Menu for the system
• Designed and developed common class libraries for sharing among the developers
• Designed and developed crystal reports like Sample Receipt and Weekly inventory for this application

Projects: Call Accounting System; Regulatory Affairs System
Environment: VB 6.0, MS Access, VB, VBA, SQL, SQL Server 7, Crystal Reports 8/8.5
This system is to maintain the practitioners (Physicians) information, Sales Reps Activity, calls, planned calls (itineraries), Xponenet and Xplantrack syndicated data.

• Meet with users, collect and analyzed system requirements.
• Lead and coordinate with the development team to manage and to integrate different modules to main system and coordinate with QA team
• Designed, developed and coded call activity, itinerary, itinerary wizard modules and synchronization module
• Designed and developed various sales reports using crystal reports
• Prepared user System requirements specifications, roll out and installation procedures.
• Used Install Shield 6.2 to design, develop and deploy the system

Women’s Health System and My Records Medical Database
Environment: Visual Basic 6.0 , MS-Access, Visual Interdev 6.0, SQL Server 7.0,HTML,Front page, ASP, VBScript, JavaScript,
COM, MTS and Crystal Reports 7

• Designed , developed and programmed VB applications and developed ASP web pages.

Programmer February 1999 to April 1999
Confidential, Lodi, NJ.
Sales Management System
Environment: Visual Basic 6.0 with MS-Access

• Designed and developed VB application and Crystal Reports

Inventory Control System and Computer Control System
Environment: VB 4.0/5.0, VB, PL/SQL, Oracle 7.x, PLC Step 5

• Education and Training:
• Post Graduate Diploma in Computer Application (PGDCA)
• Bachelors of Engineering (Electrical)