SUMMARY

• 15+ Years of IT Experience in Business Intelligence, Application Architecture & Design, Development, Customization, Marketing, Master Data Management (MDM), Big Data and Implementation
• Industry experience in Biotechnology, Health Care, Electronic Security, Financials, Insurance, Networking, Manufacturing, Automotive, Telecom, Supply Chain, Transportation, Pharmacy 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.1, 10.0.0 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/ 12.2.1.0.0 BI Apps 7.9.5/7.9.6.3/7.9.6.4 , BI Publisher, 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 R12.1.3 AGIS Module, PeopleSoft HCM 9.1, AS 400

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

Databases: Oracle-11g/10g/9i/8i, MS-SQL Server 2016, 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, 15.00, Teradata SQL Assistant 7.2, 15.00 Hummingbird FTP 10

Big Data: Cloud era 5.10, Hue 3.11, Hive 1.1.0, HDFS 2.0, Centos 7.3

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

Web: HTML, ASP, Java Script, XML

PROFESSIONAL EXPERIENCE

Confidential, PA

Informatica Architect/Lead Developer/Administrator

Responsibilities:

• Gathering Business Requirements or Enhancements to tweak the existing Mappings during the conversion from Pentaho to Informatica
• Documenting Functional and Technical Design Specs based on the Business Requirements
• Training the Development Team on Informatica Power Center Version 10.0.0 (Mappings and Workflows)
• Developing and Executing 198 Tables in total by building both Staging and Target Mappings for Job Control Master, Customer Master, AGGSPEND Vendor File Import, LASH Files and ICS Files
• Also, build 7 Workflows by breaking them into 18 Worklets by Scheduling them in the required nightly timing by using Informatica Scheduler
• Doing Performance Tuning for the Mappings where there were Bottle Necks by following the Best Practices
• Loading data from PeopleSoft Finance, Salesforce, MDM and other Legacy Systems data into MS SQL Server 2014 Tables using Informatica Power Center 10.0.0
• Converting all ETL mappings of Pentaho 5.0.1 to Informatica Power Centre 10.0.0
• Following the entire SDLC Process i.e. Development, Unit Testing, Regression Testing, UAT, Production and Post Production Support
• Was doing On Call Support to Fix Production Issues or Failures
• Was taking care of Informatica Administration by trouble shooting the system if the services come down or any other system error occurs
• Resolved the Foreign Characters data issue by replacing the MS Windows ANSI Connection with UTF-8 Encoding of Unicode
• Setting up ODBC Connections in both (TEST and Production) Informatica Boxes and in all the 4 Environments of Informatica
• Done the Migration of all the Mappings and Workflows from DEV to TEST, TEST to UAT and UAT to Production Environments

Environment: Informatica 10.0.0, Pentaho 5.0.1, MS Windows Server 2008 R2 and 2012 R2, Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 Bit, Oracle SQL Developer 4.1.5.21, Linux Version 12.1.0.2.0 , MS SQL Server 2008 R 2 10.50.6000.34 64 Bit and MS SQL Server 2014, Windows NT 6.1 64 Bit

Confidential, Scottsdale, AZ

Informatica Lead / Big Data Developer

Responsibilities:

• Gathered Business Requirements, assess, develop Business Intelligence Program Strategies, Design and Implement BI Information and Analytical Solutions for Big Data
• Prepared Functional and Technical Design Documents based on the Business Requirements
• Trained all my 7 Team Members to come up to speed on Informatica (Mappings and Workflows)
• Developed and Executed 400 Tables Approx. by building both Staging and Target Mappings
• Worked on Hive 1.1.0 by creating Source Tables where the data gets loaded into HDFS 2.0 from AS 400 DB2 Database
• Done Performance Tuning for the Mappings where there were bottle necks by following the Best Practices
• Build History Tables, Partitioning by Year in Hive using Hue 3.11 with the new version of Cloud era 5.10
• Loaded data from Hive Tables into MS SQL Server 2016 Tables using Informatica Power Center 10.0.0
• Converted Teradata .BTEQ Scripts to MS SQL Server T-SQL Scripts
• Conversion of Teradata 15.00 Database to MS SQL Server 2016 Target Database
• Used Impala to query from Hive Tables as and when there were Performance Issues
• Prepared Sqoop Scripts to pull History Data from Teradata Database to MS SQL Database
• Prepared all the DDL's for Work, History, Stage, Target and Polybase (Sqoop) Tables to be executed in Hive and MS SQL Database

Environment: Informatica 10.0.0, Cloud era 5.10, Hue 3.11, Hive 1.1.0, HDFS 2.0, Teradata 15.00, MS SQL Server 2016, AS 400 DB2, Centos 7.3

Confidential, Phoenix, AZ

OBIEE Lead Developer/Architect

Responsibilities:

• Involved in JAR/JAD sessions with Product Owners and Safeway Top Management to Gather Requirements
• Prepared Prototypes and given Estimates to complete the development work for the future Sprints where the Sprint Life Cycle is typically 2 Weeks
• Worked with my Team Members along with other teams for the Upgrade of OBIEE from 11.1.1.7.1 4 .2.1.0.0
• Worked extensively on Gross Profit Dashboard (Factors and Projections, Period Facility…etc.) reports by building RPD (All 3 Layers) metadata and Web cat
• Worked extensively with End Users to understand their data needs for Reports, Training, Service Levels and Quality.
• Designed the Reports Layout to Build 5 Reports in total where 2 Complex, 2 Medium and 1 Simple
• Worked on both Object Level Security and Data Level Security
• DonePerformance Tuningfor theExisting ReportsandDashboardsand followed theBest Practices.

Environment: OBIEE 12C ( 12.2.1.0.0 ), Oracle Exadata 11.2.0.4.0 , Oracle Linux x bit

Lead Developer/Datawarehouse Architect

Confidential, Milpitas, CA

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, Herndon, VA

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 Web Cat
• Extended W DAY D dimension thru 2020
• Build a new Subject Area called “Audit Trail Others” by building a new star schema
• Done a POC (Proof of Concept) for Vice President of ADT 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 ADT 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

Responsibilities:

• Involved in implementation of Crystal Reports on Win NT & SQL Server
• Responsibilities include direct interaction with HR Department for Requirement Specification, generating reports for verification & Drafting Crystal Reports 60 in Corporate Intranet
• Involved in development of user interface for application by using VB & ASP

Environment: VB 6.0, ASP, Seagate Crystal 6.0, SQL Server, HTML, Win N