SUMMARY

• 12 Years of IT Experience in Business Intelligence, Application Architecture & Design, Development, Customization, Marketing and Implementation
• Industry experience in Biotechnology, Health Care, Electronic Security, Financials, Insurance, Networking, Manufacturing, Automotive, Telecom and Brokerage
• Implemented Ralph Kimball and Bill Inmon Dimensional Modeling Techniques
• Implemented Methodologies like Agile and Waterfall Model
• Technical Leadership, Small and Large Team Management
• Excellent Communication Skills, Technical and Non - Technical at all levels
• Logical Database Design and Physical Database Implementation
• Business Intelligence Reporting, Enterprise Data Warehouse and Dimensional Data Modeling
• Business Analysis, Requirements Gathering, Functional Specs and Solution Architecting
• Enterprise Application Development, Client/Server and Multi-Tier Architectures, Transaction Processing, Real-Time Systems
• Database Administration and System Management

TECHNICAL SKILLS

Data Warehouse: Informatica 6.2.2/7.1.2/7.1.3/8.1.1/8.6/9.0.1 , 9.1.0,9.5. DAC 7.8.2/7.8.4/7.9.5 / 10.1.3.4.1 , Siebel Analytics 7.8.2/7.8.4/7.9.5 , OBIEE 10.1.3.3/ 10.1.3.4.1 /11.1.1.5. x/11.1.1.6.x/11.1.1.7.x, BI Apps 7.9.5/7.9.6.3/7.9.6.4 , Visio Professional 2013, Erwin 7.1

CRM/EBS: Siebel 7.x/7.5.x/7.8.x/8.x eSales, eFinance, eBusiness, Call Center, Marketing, eAutomotive, eCommunications, Oracle CRM Public Sector 8.x, Oracle E-Business Suite 11.5.10, R12.1.3 AGIS Module, PeopleSoft HCM 9.1

OS: Windows 2000/2002/2003/2008/ NT/XP, HP-UNIX 11.x, AIX 5.3/6.1/6.2, Oracle Enterprise Linux 5.x, Oracle Solaris 10, Red Hat Enterprise LinuxServer64-bitx86

Databases: Oracle-11g/10g/9i/8i, MS-SQL Server, UDB DB2 8.2, Toad 8.5/8.6.1/9.6.1.1/9.7.2/9.1.0.62 , Quest Central 4.8.0.7, Teradata 6.2.2, Teradata SQL Assistant 7.2, HummingBird FTP 10

Languages: SQL, C/C++, Visual Basic 6.0

Web: HTML, ASP, Java Script, XML

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Lead Developer/Datawarehouse Architect

Responsibilities:

• Involved in JAR/JAD sessions with Customers to Gather Requirements
• Build or Modified 15 Star Schemas and 6 Snowflake Schemas
• Prepared Technical Design Document (MD 070) by coordinating with Functional Consultant
• Prepared Prototypes and given Estimates to complete entire SDLC
• Designed ETL and DAC for Data Loads to bring data from 5 Different Data Sources (e.g. Agile PLM, EBS, Demantra etc...)
• Worked Extensively with the Teams both Offshore and Onsite OBIEE (4 Developers), Functional (1 Consultant), Informatica and DAC (6 Developers) in Development, Testing and Production
• Implemented Solutions with modeling of conceptual, Logical and Physical data elements.
• Conducted Interviews for End Users to understand their data needs for Reports, Training, Service Levels and Quality.
• Designed the Reports Layout to Build 48 Reports in total where 13 Complex, 30 Medium and 5 Simple
• Worked on both Object Level Security and Data Level Security
• Prepared Cut Over Master Plan for entire Implementation

Environment: Oracle R12 (12.1.3), OBIEE 11.1.1.7.1 5 , BI Apps 7.9.6.4, Informatica 9.5.1, DAC 10.1.3.4.1 , Oracle Database Enterprise Edition 11.2.0.3.0 , Oracle Linux x bit

Confidential, Princeton, NJ

Informatica & OBIEE Architect/Lead Developer

Responsibilities:

• Involved in JAR/JAD sessions with Customers to Gather Requirements
• Involved in preparing the Project Plan with my Delivery Manager by giving the actual time lines be taken to Implement the project successfully
• Actively coordinated with Functional Consultant to prepare Technical Design Document (MD 070)
• Upgraded the System from OBIEE 11.1.1.6.4 to 11.1.1.7.1 on a Single Node Environment
• Setup LDAP Security and worked on both Object Level Security and Data Level Security
• Build or Modified 19 Star Schemas and 11 Snowflake Schemas for 17 Modules (Learning and Compliance, Global Payroll, Staffing, Standard HR and Talent, Utilization etc...)
• Worked Extensively with both Onsite and Offshore Teams for OBIEE (8 Developers), Functional (2 Consultants), Informatica and DAC (9 Developers), Testing (8 Testers) for Design, Development, Testing and Production
• Fully Integrated Oracle HR Analytics into Existing Environment where Existing Integrations are Designed for Cognos
• Worked Extensively on 15 Data Sources to pull data into Datawarehouse to build 135 Reports and 36 KPIs
• Designed ETL in such a way to Populate Current and 10 Years of Historical Data to Oracle DHW
• Educated Users on where to use Export Options for Summary Reports by considering only Excel 2007, PPT 2007 and PDF where as for Drill Through or Detail Reports only Excel 2007 and CSV based on their Usage not considering the Default Options
• Actively coordinated with Testing Lead and Team Members solving Defects and updated HP QC Tool accordingly
• Coordinatedandworkedwith theTesting Teamto prepareUAT Scripts for User Sign Offs

Environment: PeopleSoft HCM 9.1, OBIEE 11.1.1.7.1 , BI Apps 7.9.6.3, Informatica 9.1.0, DAC 10.1.3.4.1 , Oracle Database Enterprise Edition 11.2.0.3.0 , Red Hat Enterprise LinuxServer64-bitx86, HP QC 12.01

Confidential, Princeton, NJ

Informatica & OBIEE Architect/Lead Developer

Responsibilities:

• Involved in JAR/JAD sessions with Customers to Gather Requirements
• Designed 9 Star Schemas and 5 Snowflake Schemas
• Prepared Technical Design Document (MD 070) by coordinating with Functional Consultant
• Prepared Prototypes and given Estimates to complete entire SDLC
• Designed ETL and DAC for Data Loads to bring data from 7 Different Data Sources
• Worked Extensively with the Team OBIEE (4 Developers), Functional (1 Consultant), Informatica and DAC (4 Developers) in Development, Testing and Production
• Implemented Solutions with modeling of conceptual, Logical and Physical data elements.
• Conducted Interviews for End Users to understand their data needs for Reports, Training, Service Levels and Quality.
• Designed the Reports Layout to Build 39 Reports in total where 9 Complex, 25 Medium and 5 Simple
• Worked on both Object Level Security and Data Level Security

Environment: Oracle E-Business Suite R12.1.3 AGIS Module, Informatica 9.1, DAC 10.1.3.4.1 , OBIEE 11.1.1.5, BI Apps 7.9.6.4, Oracle 11g, AIX 6.1

Confidential, Cherry Hill, NJ

Team Lead/Lead Developer

Responsibilities:

• Involved in preparing the Proposal Document along with my IT Director and CEO/President
• Involved in creating Sample Reports by my Team, proposed by the client as a POC from the 4 Modules listed Customer Management, Marketing Analytics, Contact Center Telephony Analytics and Service Analytics
• Handled a Team of 8 both Offshore and Onsite i.e. 2 ETL Developers, 4 OBIEE Developers, 1 Business Analyst and 1 DWH Admin
• Used to Upload entire Project Documents in a SDLC form by creating Individual Folders accordingly
• Used to Motivate and Mentor the Team to Deliver their Assigned Tasks to meet Deadlines by having Daily Status Meetings

Environment: Siebel eAutomotive 7.8, Informatica 9.0.1, DAC 10.1.3.4.1 , OBIEE 11.1.1.6.0 , BI Apps 7.9.6.3, Oracle 11g, Windows 2008 Server

Confidential, Novi, MI

Datawarehouse Architect/Lead Developer

Responsibilities:

• Involved in Signing Up of SOW and MPP plan by the Stakeholders
• Involved in JAR/JAD sessions with Customers of 6 Sectors to Gather Requirements
• Handled a Team of 16 both Offshore and Onsite i.e. 6 ETL Developers, 7 OBIEE Developers, 1 Business Analyst, 1 Offshore Team Lead and 1 DWH Admin
• Used to Upload entire Project Documents in a SDLC form by creating Individual Folders accordingly
• Build 360 Reports, 9 Score Cards and 875 Mappings to meet the Requirements

Environment: Oracle CRM Public Sector 8, Informatica 9.0.1, DAC 10.1.3.4.1 , OBIEE 11.1.1.5, BI Apps 7.9.6.3, Oracle 11g, Oracle Solaris 10

Confidential, West Chester, PA

Team Lead/Datawarehouse Architect

Responsibilities:

• Involved in JAR/JAD sessions with Customers to Gather requirements
• Involved in preparing the Project Plan with my Manager and made necessary changes for the project implementation
• Actively coordinated with BA’s both On-site and Off-shore for Functional Design Doc
• Designed Product Complaint, Order, Service Request and Confidential Install Base Star Schemas
• Prepared Technical Design Document, ETL Spread Sheet, Image Suffix, DAC Migration from DEV to Test and Test to Production environments, and Scripts for backend changes, Informatica and DAC for this Release
• Worked extensively with OBIEE (6 Developers), 2 BA’s (1 On-Site and 1 Off-Shore) and Informatica (4 Developers) Teams for Design, Development, Testing and Production
• Actively coordinated with Testing Lead and Team Members solving defects and maintained a tracker for reporting status
• Trained all Informatica Team members as to how the new workflows to be registered in DAC and prepared a document with a sample task by taking screen shots
• Provided Suggestions or Solutions for the Team Members on the need bases by doing Feasible Analysis

Environment: Siebel eBusiness 7.7, Informatica 7.1.2, DAC 7.8.5, OBIEE 10.1.3.4.1 , Oracle 10.2, Windows 2003, Toad 9.1.0.62, MS Visio 2007

Confidential, Jacksonville, FL

Datawarehouse Architect/Tech Lead

Responsibilities:

• Involved in JAR/JAD sessions with Customers to Gather requirements
• Worked extensively on Audit Trail, Activity, Revenue, Quote, Quote Item Star Schemas
• Worked extensively in Informatica, DAC, RPD and WebCat
• Extended W DAY D dimension thru 2020
• Build a new Subject Area called “Audit Trail Others” by building a new star schema
• Created Confidential CC Corp, Confidential NA Corp and Confidential TCML Security Groups in RPD and WebCat for specific Dashboards like Core Commercial, National Accounts and Total Commercial Sales
• Done a POC (Proof of Concept) for Vice President of Confidential by creating a Brand new Dashboard called Total Commercial Sales with Sub Dashboards called Total Commercial Sales, Total Business Line, Region, Group, District and Town and explained the differences or advantages of using Drill Downs and Navigation within the Reports
• Modified and Developed the existing reports and met all Enhancements as and when required for both the releases 2.0 and 2.1
• Actively participated with the Testing Team by preparing Test Cases for 2.0 and 2.1 Releases
• Detecting Defects, Opening Tickets by using HP Quality Center and solving them
• Done Design Documents, ETL Spread Sheet and Scripts for backend changes, Informatica and RPD for Release 2.0, 2.1 (Phase 1, 2 and 3)
• Done knowledge Transfer to 2 Employees of Confidential for Application Maintenance

Environment: Siebel eCommunications 7.8.2.3, Informatica 7.1.2, DAC 7.8.2, Siebel Analytics 7.8.2, Oracle 10.2.0.4.0 , AIX 5.3, Windows 2003, Toad 9.6.1.1, HP Quality Center 9.2

Confidential, Schaumburg, IL

OBIEE Architect/Lead Developer

Responsibilities:

• Involved in JAR/JAD sessions with customers to gather requirements
• Involved in implementing a prototype model for “OBIEE Integrated Application”
• Installed and configured Informatica and DAC on Unix Environment and OBIEE on Linux servers by coordinating with Confidential Unix Administrators
• Involved in Gap analysis between the OOTB Informatica Mappings with the current requirements
• Worked extensively on Revenue, Pipeline, Person, Service Request and Activity Star Schemas
• Done Data Modeling and created 8 Dimension and Fact extension mappings, 4 Custom Dimension and Dimension Extension Mappings and 3 Auxiliary change capture mappings
• Design and configured DAC by creating a New Container called “ Confidential Sales Container” which involves all the Vertical version of OOTB SDE and SIL workflows and Custom Folder for all the custom workflows
• Created a separate Execution Plan called “ Confidential Automotive Sales” and Scheduled Full & Incremental loads for the Data warehouse
• Ran 332 OOTB jobs and registered 15 Custom Jobs in DAC
• Worked extensively on 3 Layers of RPD and build 9 Reports like Forecast Analysis, FSP Trend Analysis etc…

Environment: Siebel eAutomotive 8.0, Informatica 8.1.1, DAC 7.9.5, Oracle 10.2.02, HP-UNIX 11.11, Oracle Enterprise Linux 5.0, OBIEE 10.1.3.3, BI Application 7.9.5, Toad 9.7.