SUMMARY:

• Nearly 6+ years of experience in Data/Solution Architect role with hands on work experience.
• Nearly 15 years of IT experience, with nearly 12 years of experience in field of Data Warehousing and Business Intelligence.
• Experienced in all phases of the project life cycle.
• Extensive experience in ETL Tools like Informatica Powercenter, Data Integrator 6.5 & 11.5 and IBM Cognos Data Manager.
• Nearly 7.5 years of experience in Business Object Suite of products namely - Business Objects (XI R2, 6.x, 5.x), Designer, XCelsius (now Dashboard 4.0), Supervisor, Broadcast Agent/Publisher, Web Intelligence, Web Administrator, DI.
• Proficient in Cognos Reporting tools namely Transformer (Cube), Framework Manager, Report Studio and Query Studio.
• Performed functionalities like Proof of Concept, Project Initiation, Implementation, Analysis and Development, Report Writing, Technical Support & User .
• Profound experience in Oracle and SQL Server back end in writing stored procedures, packages, PL/SQL, loading scripts etc.
• Worked on complete Project Life Cycle developing applications using Visual Basic, VC++, Oracle, MS-SQL Server, VBScript, JavaScript, Active Server Pages (ASP), XML, XSL, HTML, Crystal Reports, MS-Access.

TECHNICAL SKILLS:

ETL Tools: REPORTING:

Metadata: Informatica Metadata Manager

DATABASE: Oracle 11g/10g/9i/8i, SQL Server, MS Access, Sybase, MySQL

LANGUAGES: C/C++, PL/SQL, JSP, Visual Basic, VC++, VBScript, JavaScript, Active Server Pages 2.0 (ASP), XML, XSL, HTML

DESIGN TOOLS: Visio, ERWIN

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, CA

Responsibilities:

• Reverse Engineer ERWIN Models from the existing DW.
• Setup and own Informatica Metadata Manager for purpose of Lineage/Impact Analysis.
• Work with Data Governance team to integrate Business Glossary with our Metadata.
• Own the ERWIN Models and model any changes or new data going forward
• Design Data Integration from new sources to provide meaningful analysis.
• Data Modeling (both Dimensional and Relational) for the projects being undertaken using ERWIN
• Plan the infrastructure specifications for the ETL systems from growth perspective.
• Developing the development plan with detailed steps.
• Estimating/planning and tracking the development/testing effort for new incoming projects.
• Hands on involvement in development/maintenance of code in Informatica/Cognos as required.
• DDL/DML/Stored Procedures/Functions in Oracle
• Performing code reviews / Standards validation

Environment: Informatica 9.5.1, Oracle 11g, Cognos 10.2

BI Architect

Confidential, CA

Responsibilities:

• Own the Informatica Stack and defined the ETL standards and processes to be followed for any development on Informatica. This includes Informatica Administration too.
• Own the legacy ETL system and any changes to it till it has been ported over to Informatica
• Did Data Integration from multiple sources to provide meaningful analysis for Pricing/Marketing team.
• First level of contact for all urgent issues related to Informatica/ETL processes
• Data Modeling (both Dimensional and Relational) for the projects being undertaken using ERWIN
• Plan the infrastructure specifications for the ETL systems.
• Handling multiple projects concurrently. Project prioritization based on needs and constraints for resource/effort allocation etc.
• Liaising with business users to define the scope, timelines and expectations for projects requests
• Responsible for writing design documents, system requirement documents
• Developing the development plan with detailed steps.
• Estimating/planning and tracking the development/testing effort
• Hands on involvement in development/maintenance of code in Informatica also mentoring of team members.
• DDL/DML/Stored Procedures/Functions in Oracle
• Performance tuning, troubleshooting issues faced by development team in Informatica/Database.
• Performing code reviews / Standards enforcement
• Managing onsite/offshore development teams
• Setup of new environments for POC (Informatica Metadata Manager etc).
• Responsible for quality and meeting project objectives.
• Developed templates to be used for future development for capturing Audit/Incremental load information
• Expertise in performing data analysis, research and profiling. This is helpful while defining/clarifying business rules during implementation.
• Hands on development of reports/Dashboards using Cognos and Tableau and occasional cubes
• Soon after joining Confidential upgraded from Oracle EBS R11 to R12. I was given the task of doing impact analysis and code refactoring on the legacy system to prevent disruption on go live. Constrained by timelines and late availability of Source systems for testing, I none the less managed to get it all done and we went live with zero defects on the BI side on Go-Live.
• Nominated for and was one if the 4 finalist for “Employee of the Quarter” in less than a year of my joining.

Environment: Informatica 9.5.1, Oracle EBS R11/R12, Oracle 11g, Cognos 10.1.1, Tableau

Confidential, CA

Solution Architect

Responsibilities:

• Understanding Business Requirements and overall project objectives
• Plan the infrastructure specifications for the new ETL and reporting systems.
• Liaising with business users to better define the scope, timelines and expectations.
• Developing the project plan with detailed steps.
• Estimating/planning and tracking the development/testing effort
• Setup of new environment.
• Migration of the content store.
• Validation and performance benchmark using Lifecycle Manager.
• Updated ETL catalogs in IBM Cognos Data Manager, based on changes in Source Systems.
• Responsible for quality and meeting project objectives.
• Developed Historical Data Merge plan, along with tolerance limit for variance.

Environment: Oracle EBS R12, Oracle 11g, Cognos 10.1.1, Cognos Data Manager

Confidential, CA

Sr Systems Analyst/Solution Architect

Responsibilities:

• Understanding the source system (JDE) and business process.
• Understanding Business Requirements and overall project objectives
• Involved in Project SOW and solution approach.
• Liaising with business users to better define the scope and the business asks.
• Designing the solution framework using a scenario/use case based approach
• Defining the data flow aspect.
• Design and development of changes to Informatica Mappings and Oracle Stored Procedures.
• Estimating/planning and tracking the development/testing effort
• Responsible for quality and meeting project objectives.

Environment: SQL Server, Oracle 11g, Informatica 8.6.1, JD Edwards, Cognos 8.4.

Confidential, CA

Sr Systems Analyst/Data Architect

Responsibilities:

• Understanding the source system (over 200 + tables/views) and business process.
• Understanding Business Requirements and overall business objectives
• Involved in Project Initiation and development of project charter.
• Providing the knowledge input for design of Business Model.
• Liaising with business users to better define the scope and the business asks.
• Convert business requirements into technical requirements.
• Designing the logical/physical data model
• Defining the data flow aspect.
• Design and development of Legal Datawarehouse.
• Design and development of downstream datamarts.
• Estimating/planning and tracking the development effort
• Responsible for quality and meeting project objectives.

Environment: SQL Server 2008, Oracle 10g, Informatica 8.0.

Confidential, CA

Reporting Data Architect

Responsibilities:

• Understanding Business Requirement and process.
• Liaising with business users to better define the reporting needs and requirements.
• Designing the reporting data model
• Designing the universes and reports layout/functionality
• Defining the data flow aspect.
• Estimating and implementing the development effort
• Development of new universes/reports
• User for the reports and various functionalities in the reports.

Environment: Business Objects XI R2, Oracle 10g.

Confidential, CA

Lead System Analyst/Data Architect

Responsibilities:

• Understanding Business Requirement and process.
• Providing the knowledge input for design of Business Model.
• Liaising with business users to better define and scope the business asks.
• Convert business requirements into technical requirements.
• Was the lead System Analyst for Data Management group, overseeing 3 other analysts.
• Creation of System requirement documents to be used for ETL development.
• Designing the data model
• Defining the data flow aspect.
• Estimating/planning and tracking the development effort
• SME (Subject Matter Expert) for PayGo project on Data Acquisition/Reporting team queries.
• Active support, maintenance and enhancement for existing BI reports.
• Development of new universes/reports to support accounting processes.
• Created reports used by Finance group to do revenue booking/deferred revenue and adjustments.
• Worked on setting up auto-invoicing application based on data model created for reporting.
• Created reconciliation process/reports based on new data model for invoicing external distributors.
• Created Xcelcius reports for presentation to Senior Business users.
• Created ad-hoc reports/queries to support successful launch of new PayGo product.
• Project lead for San Diego based report development team.

Environment: Business Objects XI R2, Data Integrator, Oracle 10g, SQL Developer.

Confidential, CA

Senior Data Analyst & Offshore Team Coordinator

Responsibilities:

• Understanding Business Requirement and process.
• Liaising with business users to convert business requirements into technical requirements.
• Leading offshore team
• Overseeing development work done by offshore.
• Testing, reviewing and finally signing off on the code send by the offshore team.
• Providing the knowledge input for design of Business Model.
• Active support, maintenance and enhancement for existing system (PL/SQL data extraction & DI).
• Writing stored procedures using embedded cursors, Session Contexts and DB-Links.
• Designed ETL jobs in DI to extract data from SAP sources and Flat Files.
• Creation of materialized views, database and query tuning.
• Re-wrote number of packages for more efficient PL/SQL.
• Implemented Mail/pager notification for critical jobs in DI.
• Implemented Date override/recovery strategy implementation in DI.
• Involved in knowledge transfer/ to new team members.
• Acting as Subject Matter Expert (SME) for the team on PL/SQL and DI Designer.
• Creation of Documents for complex processes which I proposed/implemented/Reviewed.
• Defined and implemented processes for transition of artifacts between offshore and onsite.

Environment: Data Integrator, Business Objects XI R2, Microsoft VSS, Oracle 10g, SAP R/3, Toad 7.0.

Confidential, WI

Senior Data Analyst & Developer

Responsibilities:

• Understanding Business Requirement and process.
• Providing the knowledge input for design of Business Model.
• Active support, maintenance and enhancement for existing system (PL/SQL data extraction & DI).
• Writing stored procedures using embedded cursors, Session Contexts and DB-Links.
• Designed ETL jobs in DI to extract data from SAP sources and Flat Files.
• Creation of materialized views, database and query tuning.
• Re-wrote number of packages for more efficient PL/SQL.
• Implemented Mail/pager notification for critical jobs in DI.
• Implemented Date override/recovery strategy implementation in DI.
• Involved in knowledge transfer/ to new team members.
• Acting as Subject Matter Expert (SME) for the team on PL/SQL and DI Designer.
• Designed and created complex universes using concepts like linked universes etc.
• Designed and created universe objects using internal functions like @Select, @Where etc for the POC.
• Designed sample reports with Drill Down feature.
• Worked on SAP R3 system as part of debugging and Integration Testing.
• Found and resolved over 40 high/medium risk issues in less than 4 month which was appreciated.
• Creation of Documents for complex processes which I proposed/implemented/Reviewed.
• Designed sample complex reports with nested and dependent prompts, using Desktop Intelligence.
• Scheduled/added/monitored reports using WebI and BCA.

Environment: Data Integrator, Business Objects XI R2, Microsoft VSS, Oracle 10g, SAP R/3, Toad 7.0.

Confidential, San Diego

Senior Analyst (BI)

Responsibilities:

• Understanding Business Requirement and process.
• Providing the knowledge input for design of Business Model.
• Active support, maintenance and enhancement for existing legacy system (PL/SQL data extraction).
• Writing stored procedures using embedded cursors, Session Contexts and XML Queries.
• Designed and created universes in BO XI R2 to encompass all possible user requirements and queries.
• Designed and created universe objects using internal functions like @Select, @Where @Prompt etc.
• Created reports with drill down features using Desktop Intelligence.
• Created reports with nested dependent prompts in the report using Desktop Intelligence.
• Involved in knowledge transfer/ to client personnel for generation and usage of ad-hoc reports.
• Acting as prime knowledge contact between offshore and onsite team.

Environment: Business Objects XI R2, Microsoft VSS, Oracle 10g, Toad 7.0.

Confidential, Utah

Senior Developer

Responsibilities:

• Low-level design and development of the ETL process.
• Data Modeling
• Production Rollout of the data warehouse
• Historical Data loading
• Ongoing production support.
• Created Universes to handle detailed and aggregated data by using Embedded Functions like @Prompt, @Aggregate Aware, @Select, @Where in the Designer.
• Supporting and managing the Business Objective Related Issues in the organization, which includes answers for all the Business Object queries and supporting business community and technical users.
• Involved in all the review phases to make sure that all Business Object Reports and Universe follow development standards.
• Analysis of the existing business processes and Data Warehouse.
• Development of complex reports using Desktop and Web Intelligence.
• Scheduling of reports using BCA.
• Development, Support, Modification and Enhancement of existing Universes by working with development team and user community.
• Performance Tuning of the generated reports, which included overwriting standard query with a custom one.
• Handing Source Control and versioning of the code.
• Handling the quality aspect, overseeing the testing of the code and defect ratio report generation.
• Phased code rollout/Build generation for testing/client inspection.

Environment: Data Integrator 6.5, Business Objects, Microsoft VSS, Oracle 10g, MySQL, Sybase.

Confidential

Senior Developer (BI)/Offshore Team Lead

Responsibilities:

• Development of new reports based on business requirements.
• Automation of report generation through Broadcast agent.
• Making sure of report circulation by configuring BCA to save report to shared file system in pdf form and writing scripts to update Intranet web page with regards to new file.
• Defining custom hierarchy in the Universe so that automatic drill down features may be incorporated in the reports.
• Created drill down reports for business users.
• Supported all ad-hoc queries and report requests.
• Provided troubleshooting and problem resolution to technical people for BO problem.
• Acted as SME (Subject Matter Expert) for the development team.
• Conversion of legacy reports from Excel to Business Object reports.
• Conversion of legacy data loading system from PERL to Informatica.
• Support for existing system, both ETL and Reports.
• Liaison with the clients for day-to-day requirement gathering
• Clarification of queries posed by the team members.
• Work assignment and allocation to the team members.

Environment: Business Objects 6.1, Web Intelligence, Informatica 6.0, Broadcast Agent Server, IIS 5.0, Oracle 8i, Informix, POSTGRES.

Confidential

Senior Software Developer

Responsibilities:

• Daily support for data loading on informatica.
• Involved in analyzing the source data and automating load processes,
• Involved in creating reports for bad data and rollover of data load in case of failures.
• Daily/Weekly support for BO reports.
• Involved in creating ad-hoc reports and queries as and when needed by business users.
• Designed fleet of Informatica mappings using filters, lookups, and stored procedure, Joiner, update strategy, expressions and aggregations transformations
• Involved in performance tuning of existing mappings for better performance. Worked closely with the DBA’s and end users.
• Used TOAD for writing PL/SQL Oracle Database triggers and Procedures/Functions/Packages.
• Extensively used ETL to load from operational system (Oracle database) and flat files into the Oracle target database.
• Applied the complex business rules through PL/SQL.
• Handled the new features of Informatica 6.1 including Workflow Manager to handle work lets.
• Universe creation based on the Data mart developed for the Enterprise to embed the entire user requirement.
• Handled Embedded Functions like @Prompt, @Aggregate Aware, @Select, @Where in the Designer to handle User requests and aggregation tables for report generators
• Supporting and managing all the Business Objective Related Issues in the organization, which includes answerable for all the Business Object queries and supporting business community and technical users scattered across various locations worldwide.
• Involved in all the review phases to make sure that all Business Object Reports and Universe follow development standards.
• Resolved many production problems for various applications.
• Analysis of the existing business processes and Data Warehouse.
• Development, Support, Modification and Enhancement of existing Universes by working with development team and user community.
• Performance Tuning of the generated reports.

Confidential

Software Developer

Responsibilities:

• Involved in development and enhancement of Complex Risk module.
• Involved in designing and implementation of capturing of insurer quotations and the policy creation.
• Involved in functionality of code implementation for Mid Term Adjustments, Cancellation, Renewal and Reinstatements of the complex risk policies.
• Involved in reports and document management, for which Active Reports was used.
• Translating of business requirements into implemental design.
• Designing and coding of the ASP pages as well as COM+ components, as per the requirements of the business flow.
• Database table designing and writing stored procedures to access the data from the ASP Pages (server side - using VBScript, ADO/COM+ objects).

Environment: ASP, VB/VC++, COM+, XML, XMLHTTP, DHTML, VBScript, JavaScript, SQL Server 7.0 and Active Reports.