SUMMARY

• 10+ years of strong Data Warehousing experience using Informatica PowerCenter 9.0/8.1.1/7.1/7.0/5.1.1/1.6/1.5 , Informatica Power Analyzer, Ascential DataStage 7.0/ 6.0/5.2/5.1/4.2/3.6 (Manager, Designer, Administrator, Director), Orchestrate, Integrity, MetaRecon, Informatica Power mart 5.1.1/5.x/4.7/3.8, Transformations, ETI, ETL, MS Excel, OLTP
• 10+ years of strong Business Intelligence experience in OLAP using various reporting tools like OBIEE,Business Objects, Cognos7.0/6.6, Data Reports, Seagate Crystal Enterprise, Seagate Crystal Reports 8.0/7.x/6.x and SQR 3.0.
• 11 years of professional experience in IT Industry including around 8 and half years of expertise in Design, Development and Implementation of state of the art Data Warehouse Applications.
• Strong background working with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines. In - depth understanding of project life cycle, including all phases of system and software development. Experienced in Business Analysis, Source system analysis, Architectural Reviews, Data Modeling, Data validation, Data testing, Resolution of data discrepancies.
• 7+ years of Data Modeling experience using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWin3.x, Oracle Designer. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• 10+ years of high-end programming experience using SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus, SQL*Loader, Very Strong Unix Shell Programming/Scripting, Visual Basic 4.0/5.0/6.0, Developer 2000, C, HTML 4.0, DHTML, XML, Windows 3.x/95/98/2000, Win NT 4.0, Sun Solaris8, HP-UX and AIX 4.3

TECHNICAL SKILLS

• Data Warehousing: Informatica PowerCenter 9.0/8.1.1/7.1/7.0/5.1.1/5.0/1.7 (Designer, Server Manager, Repository Manager), Informatica PowerMart 5.1.1/5.0/4.7 , Power Connect, ETL,AscentialDataStage 6.0/5.2/5.1/4.2/3.6 (Designer, Director, manager, Administrator), Orchestrate, Integrity, MetaRecon, Data Mining, Datamart, Metadata, OLAP, OLTP, SQL*Plus
• Business Intelligence: OBIEE 11g, Business Objects XI, Cognos 7.0/6.6/5.0, Actuate 9.0
• Databases: Oracle 10g/9i/8i/8.0/7.0, Sybase Server 11.x/12.0, MS SQL Server 6.5/7.0/2000 , DB2 UDB, MS Access 7.0/’97/2000, Teradata 6.2.
• Tools: Erwin 4.1/3.5, Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, Toad, SQL*Loader, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports
• Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, ASP, Java, JSP, C, C++, Unix Shell Scripting, Dbase III
• Others: HTML 4.0, ASP 3.0/2.0, JSP, CGI, PERL, JavaScript, DHTML, MS Excel, MS Office, MS-Project.
• Environment: Sun Solaris 2.6/2.7/2.8, HP-UX, Confidential AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98/2000, Win NT 4.0, SCO Unix.

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Cross-functional role that combined software, data and business architect responsibilities focused on integration projects and business intelligence/data warehousing projects. Provided technical leadership to enterprise wide projects affecting external customers and end users, internal customers and partners (300,000+ end users in 10,000 companies, 10+ large partners - major wireless carriers and VAR’s in US and Europe).
• Evangelized, designed and implemented architecture that directed streams of data from main data sources (NOC, customer facing portal, multiple ordering systems, and partner integration services) into central data repository that represents complete business model of the enterprise. This approach has drastically reduced LOE and complexity of cross-systems projects and most of the operational reporting and created launch-pad for data warehousing projects.
• Designed new data architecture for partner integration services, which consisted of unified core and customizable integration modules. This approach significantly streamlined and improved quality of partner billing and reduced LOE and complexity of partner on-boarding implementations.
• Defined roadmaps, project plans and steps to implement data and DSS architectures.
• Worked with business users and SME's to best determine approaches to satisfy user requirements, gaps and risks.
• Developed prototype solutions to verify capabilities for new systems development, enhancement, and maintenance of decision support.

PEBDW - Product Enhancement Billing Data Warehouse

• Provided technical solution to support product enhancement, operational, billing and management reporting needs for a mobile user community across 40 carriers (operators) who uses several mobile application solutions like email, social networking, IM etc…
• Designed and implemented a data warehouse and business intelligence reporting solution which is integrated with Carrier partners.
• System is designed to handle high volume data processing, 40 - 100 million records daily.
• Maintained and Administered Business Objects Reporting Environment.
• Extensively created reports and deployed as per Carrier requirements using Infoview and BO designer.
• Data captured from heterogeneous systems including log files.
• Implemented database partitioning, dbms job routines, analytical queries and parallel queries to improve the performance of the existing backend processes.
• Improved the performance of the database queries using Explain Plan, TKPROF.

Environment: Oracle 11g/10g/9i, Oracle Applications ERP, Erwin, Informatica 9.01, OBIEE 11g, PL/SQL, SQL*Loader, Business Objects XI R2, Perforce, Python, Perl, Actuate 9.2, UNIX, Toad, XML Spy, Windows XP Professional, Windows 2003 Server, Web Services.

Confidential,

Responsibilities:

• Extensively involved in System Study & Business Requirements Analysis required for data warehouse planning phase and the creation of deliverables required to develop a comprehensive alternative analysis and cost benefit analysis for an enterprise data warehouse.
• Worked with business and data analysts, developers, database administrators and requirements analysts to translate business requirements into technical requirements.
• Responsible for preparation and/or review of any technical designs and/or documents
• Advised other groups in the organization on data warehouse development and conducted ETL (code/documentation) reviews before migration and ensured best practices are followed.
• Responsible for administration and maintenance of all Informatica environments.
• Performed impact analysis and Implemented Informatica Upgrade from Powercenter 7.1 to Informatica Powercenter 8.1.1.
• Responsible for designing and development of logical, physical dimensional data models using Erwin
• Developed Oracle Stored Procedures, Functions, Packages and Triggers and defined security.
• Implemented handshaking methodologies between wide variety of Systems
• Extensively used the versioning in Informatica
• Created complex mappings using Informatica to load data.
• Created Pipeline partitioning to improve Session performance
• Scheduled workflows and sessions to schedule the loads at required frequency using workflow manager. Generated completion messages and status reports using session.

Environment: Informatica Power Center 8.1.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Business objects 5.1.5 (Reporter, Designer, Supervisor, Broadcast Agent, Web Intelligence), ERWIN4.1, Redhat Linux, Shell Scripting, SQL, PL/SQL (Procedures and Functions), Oracle 9i, TOAD 7.4.0, Win XP/2000.

Confidential, Roseland, NJ

Responsibilities:

• Involved with needs assessments and proposals, design and implementations in Development, staging and production environments.
• Designed, architect the complete informatica power center suite.
• Installed and configured repository server and Global repository on oracle 9i DB in RISC (Confidential pSeries 650s and on sun Fires 440, 6800 and 210) for Different sources of ADP.
• Implemented Row level Security for users using VPD( Virtual Private Database)
• Involved in creating LDAP to Oracle Database architecture design.
• Physical and Logical designing of the Database. Implementing the OFA at OS Level and Oracle level. Creation of the data Flow diagrams and ER diagrams Creation of database. Security to database through user, role, profile management. Development and testing the Backup and Recovery strategies. Reverse engineering using ERwin. Shell scripts have been used to perform all the OS level jobs and to call the batch jobs and to monitor the database.
• Evaluated ETL Vendors (Informatica, Ascential) and performed a POC for impact on source system performance and LDAP connectivity.
• Analyzing ORACLE Architecture to get the technology used for Confidential (Change Data Capture) to implement the Datastage Confidential and Datastage OmniReplicator, Datastage (mercator) LDAP connector to source systems to Co-Ordinate with Developers for develop internally the same Confidential technology.

Environment: Informatica PowerCenter 7.0/7.1,Persistent Ldap connector, Ascential Datastage, Mercator,Confidential IDI, Web Report, XML,DB2 UDB 8.1, Oracle8.x/9.x, AIX 5.x,Sun Solaris 9 and Windows2000, Suse Linux, Java, PHP scripting.

Confidential,Roseville, CA,

Responsibilities:

• Extensively involved in the Analysis, Design and Modeling. Worked on Star Schema, Data Modeling, Data Elements, and Issue/Question Resolution Logs, Source to Target Mappings, Interface Matrix and Design Documents.
• Created Informatica mappings using Designer with PL/SQL Procedures, Functions and transformations (such as Aggregators, Filters, Router, Normalizer, store procedure & Sequence) to build business rules.
• Performed various Informatica Administrative tasks & managed Informatica Repository.
• Involved in the design of Informatica sessions, batches, refresh strategy, scheduling, dependency, event triggers & post/pre using workflows and various Tasks (session, command and event).
• Extensively used ETL to load data from various sources like Oracle, SQL Server, Sybase and DB2 into the target Oracle database.
• Created Test plans and Test Scenarios.

Confidential, Orange County, CA

Responsibilities:

• Involved in the high-level design of the ETL system, which comprises of re-engineering of existing CPMS system.
• Developed low-level design to depict the functionality of each individual system.
• Worked on all components of Ascential Datastage 7.0/6.0 for various requirements. DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse, used DataStage Manager for importing metadata from repository, new job categories and creating new data elements and used DataStage Director and the runtime yengine to schedule running the server jobs, monitoring and debugging its components.
• Worked extensively on Parallel Extender (DataStage 6.0) for splitting the data into subsets and to load data, utilizing all available processors to achieve job performance.
• Hands on experience in working with Dynamic data re-partitioning using Hash File for Lookup tables and to add desired degree of Parallelism for data transfer.
• Worked on DataStage Administrator to assign privileges to users or user groups to control purging of Repository and DataStage client applications or jobs they run, move, rename projects and manage or publish jobs from development to production status.
• Wrote custom and complex user defined Routines and Transformations.

Environment: DataStage 7.0/6.0, (Parallel Extender, Integrity, Meta Broker, Meta Stage) and Orchestrate, ERWIN 3.5 2, DB2 UDB 8.1, Universe Basic, Business Objects 5.1, WEBI, ZABO, Korn Shell Scripting, UNIX AIX 4.3x and Windows NT 4.0.