SUMMARY:

• Over eighteen years of experience in Information Technology industry specializing in Data management, Business Intelligence, Data governance, Data modeling, Advanced Analytics, and System Integration.
• Experience working cross functionally with IT team, business leaders, marketing, finance and executives.
• Well acquainted with quality processes like CMM - Level 5 and Six Sigma, Scrum methodology for agile project management.
• Expert knowledge of Finance, marketing, operations, strategy and statistics.

TECHNICAL SKILLS:

Data Management: Informatica Powercenter 6.0/7.1/8.1/9.1/10. x, DTS 8.0, IDQ 9.0,, Informatica MDM, Metadata manager, OWB

Business Intelligence: Cognos 10/8 (Cognos EP series 7.1/7.4, CRN 1.1, Tableau, Qlikview 11

Database: Oracle 7.x/8i/9i/10g/11g, Sybase, MS SQL Server 2000,Hbase

Analytics/Statistics/Operations: SPSS, Stata, Excel Risk solver

Data Mining: Machine learning, Octave, MS Azure, R,Python

Cloud services: AWS EC2, S3

Data modeling: MS Visio, ERWIN

Project management: MS Project, Jira

Programming languages: C, Pro *C, C++, Java, PL/SQL,Shell scripting (awk,sed and shell), Perl,XML,Unix Internals

Configuration Management: VSS, Rational Clearcase

Other Tools: Rational PurifyPlus, Rational Rose, ASN.1 compiler, Maestro Scheduler, Control M scheduler, Six-Sigma tools Minitab, Autosys Scheduler, UC4 scheduler

Methodologies: SSAD, OOAD, DMAIC, Scrum/Agile

Business Domain: Telecom, Direct Marketing, Investment Banking, Retail, Infomercial business, Transportation

PROFESSIONAL EXPERIENCE:

Confidential, Orange,CA

BI/DW Solution Architect

Responsibilities:

• Data source analysis, requirement gathering, data stewardship, and impact analysis
• Architect DW solutions, data models, enhance EDW and data marts
• Design ETL processes and develop ETL routines.
• Design and develop dashboards, define KPIs and manage metadata.
• Process automation, performance tuning and process improvements.
• Production support and fixes

Environment: Oracle 12c, Informatica Power Center 9.6, OWB, Erwin 9.0.0, Qlikview 11/12, PL/SQL, Unix Shell scripting, Windows scripting,Amazon S3, SQL server 2016

Confidential, Newport Beach, CA

BI/DW Solution Architect and Delivery Manager

Responsibilities:

• Manage and supervise a team of 5 onsite and offshore resources.
• Architect DW solutions and direct the team in implementing the solutions.
• Project planning, work estimation, resource allocation, and delivery.
• Recommend solutions to client to come with up the best strategy.
• Design ETL process, guide the ETL team in building the ETL objects and review those.
• Data source analysis and requirement gathering
• Data modeling, enhance EDW and data marts
• Process automation, streamlining business process, performance tuning and process improvements.

Environment: Oracle 12c, Informatica Power Center 9.5, Informatica Metadata Manager, MSVisio 2010, PL/SQL, Unix Shell scripting, Control-M 8.x

Confidential, Santa Monica,CA

Lead BI/DW Solution Architect and Delivery manager

Responsibilities:

• Architect EDW and BI solutions, lead data acquisition projects.
• Liaison between the business and technical team to gather requirement, define KPIs.
• Lead a team of ten onsite and offshore resources.
• Recommend solutions to business users to come with up the best strategy.
• Design logical and physical data models.
• Perform multiple linear regression model.
• Create and integrate data marts in the EDW.
• Project planning, work estimation, resource allocation, and delivery.
• Data source analysis, requirement gathering, data stewardship, and impact analysis
• Design ETL processes, guide the ETL team in building the ETL objects and review those.
• Data validation, regression testing and UAT.
• Design reporting solutions such as cubes, reports and dashboards, and guide the reporting team in building and reviewing those.
• Documentation of BRD and Technical design documents.
• Process automation, streamlining business process, performance tuning and process improvements.

Environment: Oracle 11g/10g, SQL Server 2012,Informatica Power Center 9.5, IDQ 9.0, TDM, Cognos 10,Redhat Linux 4.1, Windows 2008 server, Microsoft Project 2007, MSVisio 2007, Erwin 9.0.0, Tableau 8.3, AWS, PL/SQL, Unix Shell scripting, Stata, Python

Confidential, Buffalo, NY

Technical Architect

Responsibilities:

• Designed the OSPOS data mart, data models, ETL processes and related sales reports and cubes, and was involved in the development of enterprise DW.

Environment: DTS 8.0, Informatica Power Center 8.1.1, MS SQL 2000, Oracle 9i, Cognos Series 7.2/7.4 ( Impromptu, Power Play), CRN 1.1 MR1/MR2/MR3, Cognos 8 Report Studio, Analysis Studio, Framework manager, Access manager, Cognos SDK, Unix shell scripting, Windows 2000 server, Microsoft Project 2000, MSVisio 2000, UC4 scheduler.

Confidential, Diamond bar,CA

Technical Architect

Responsibilities:

• Built a datamart and developed ETL solutions and programs for Demantra Spectrum Suite and Demand planning module

Environment: Informatica Power Center 7.1, SQL*Loader, Oracle 9i, Windows scripting, Vbscript, Windows 2000 server, Windows NT.

Confidential, Los Angeles, CA

BI Consultant

Responsibilities:

• Worked on a consulting assignment for fixing and performance tuning of employee complaint reports.

Environment: Cognos Report Net 1.1 Report Studio, Framework Manager, ERWIN 4.1.4, Oracle 9i, Windows XP/Windows 2000 Server.

Confidential

Team lead

Responsibilities:

• Developed ETL programs and reports related to Global General Ledger (GGL) and led the testing team for end-to-end testing.

Environment: Informatica Power Center 6.0, Autosys Scheduler, Perl, Sun Solaris 5.7, Linux, Cognos Report Net 1.1, Oracle 9i, Windows 2000 Server

Confidential

System Analyst

Responsibilities:

• Enhanced and maintained Direct Marketing Application, a $66 million business, one of the key systems for supporting business of GE Appliances, which consists of several modules.
• Redesigned the Web Solicits and cross sale application using six sigma DMAIC methodology.

Environment: Maestro Scheduler, Six-Sigma tools, Pro *C, Oracle, PL/SQL, Shell and AWK scripting, CGI-BIN, Java, UML, HP-UX 9000/800.

Confidential

Team lead

Responsibilities:

• Developed a solution to integrate GPRS Roaming TAP3 with the existing billing system.

Environment: Pro *C++, ASN.1, UML, Sun OS 5.7, Rational Rose, Rational PurifyPlus,VSS

Confidential

Software developer

Responsibilities:

• Involved in development and testing of The Integrated Network Management (INM) System that is a multi-vendor and cross-technology management platform for managing the element managers and network elements in a telecom system.

Environment: Java, CORBA, UML/Rational Rose, Rational Clearcase, WinNT4.0, HP-UX 9000/800.

Confidential

Team lead

Responsibilities:

• Developed GPRS Tap3 module and its integration with the infranet billing system.

Environment: MS-Visio 98, Pro *C, SQL/PL SQL, Oracle 8i, ASN.1 Compiler, Sun OS 5.7.

Confidential

Software developer

Responsibilities:

• Developed an application for processing of incoming and outgoing TAP3 files of a mobile operator.

Environment: ERWIN 4.0, Proc *C, SQL, Oracle 8, ASN.1 Compiler, DEC- UNIX.

Confidential

Software developer

Responsibilities:

• Developed an application called CDR-Collection system, which collects the CDR (Call Detail Record) files online from a Confidential M7B MSC (Mobile Switching Center) and transfer them to the billing system.
• Developed an application called Switch Audit Handler (SAH) that generates a discrepancy report based on the mismatch of the status of services of customers in the Home Location Register (HLR) vis-à-vis the network operator’s billing database.

Environment: Pro * C, Oracle 7.3.2, UNIX Internals, Digital Alpha UNIX, Confidential DX-200 Switch, Ericsson Switch, HP/9000FTAM APIs