SUMMARY:

• Result oriented Data Business Process, Business Intelligence Architect with more than 17 years of IT experience in Technical Consulting in Data Warehousing/Business Intelligence space.
• Proven ability to architect and engineer complex systems that are flexible, easy to maintain, reuse code and business rules, and that align to business objectives.
• Outstanding record of implementing advanced technology to build innovative business solutions and systems that work, change easily, and last.
• Process Improvement Analyst & Business Process, Project Manager and Business Analyst for large, complex IT projects/systems.
• Excellent analytical, communication, and facilitation skills with the ability to gain consensus across multiple teams, ability to interact with end - users, customers, and team members.
• Experience using Business Process Management technology to reduce time to market, improve quality, ensure risk/consumer/retail compliance.
• Solid experience leading and carrying out enterprise life cycle system development, from planning, analyzing, designing, building, and testing new Web and Client/Server applications.
• Excellent knowledge in data warehouse development life cycle, gathering requirements and analysis, dimensional modeling, meta-data management and implementation of STAR, Snowflake schema, Incremental loads/Change Data Capture and slowly changing dimensions.
• Extensive experience on Enterprise reporting, Cube Analysis (MOLAP) Ad hoc query (ROLAP) & Statistical Analysis & Mining and Report Delivery & Alerting.
• Expertise in Data Modeling using Entity Relationship (ER), Multi-Dimensional/Star Schema.
• Extensive knowledge in building e-Business Intelligence applications using BI 4.0 & 4.1 latest SPs, BI Dashboard, Business Objects XIR3.1, XIR2, XCelsius 2008, Crystal 2008/2011, Crystal Reports 8.5, 8.0/7.0/6.0. ROMBI,
• Expertise in BOE report conversion, 6.1B, XIR2, XI 3.1 to BI 4.0 and 4.1 latest service packs
• Proficient in Business Objects BI 4.0/4.1, Xcelsius, dashboard design using various data sources.
• Expertise in Multi-platform & Mutli BI content conversion.
• Knowledge in Big data ecosystem related technologies, configuration, supporting and monitoring Hadoop clusters using Apache, Cloudera distributions and AWS.
• Knowledge in using Pig, Hive, Scoop, HBase and Cloudera Manager.
• Understanding of MapReduce programs using Apache Hadoop for working with Big Data.
• Good understanding of XML methodologies (XML,XSL,XSD) including Web Services and SOAP
• Extensive experience in ETL design principles and performing ETL design processes using various ETL tool sets.
• Experience in ETL Development/Administration using IBM DataStage, Informatica, Talend, Data services.
• Experience in IBM Info Sphere (DataStage, Quality Stage) & Information Analyzer 8.1, DataStage 7.5.2EE client components (Designer, Director, Manager, and Administrator), Profile Stage, DataStage 7.5.2.
• Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc.
• Experience in usage of Quality Stage for maintaining and cleansing of data.
• Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Expertise in building projects and creating reports using Micro Strategy 7.x/8.x/9 product suites including Micro Strategy Narrowcast Server, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Administrator, Micro Strategy Intelligence Server and Micro Strategy Architect.
• Expertise in Business Objects Enterprise framework, client/application/intelligence/processing/data tiers, configuration and administration of Business Objects suit of products.
• Expertise in Business Objects installation, upgrade, administration, universe generation/optimization, maintaining universes, objects oriented universe design techniques.
• Extensive experience in performance tuning, CPU, memory, IO and health check monitoring.
• Expertise in client server, web, and midrange environments which include Oracle, SQL Server, Sybase, Informatica, SQL, SQL*PLUS, PL/SQL, T-SQL, BCP, SQL*Loader, Oracle Enterprise Manager, Oracle RAC, Server Manager, SQL*DBA, Erwin 3.5.2/4.0, Designer 2000, UNIX (Sun Solaris) & Windows, OOD/OOP, C/C++, Pro*C, Shell Scripting, Developer 2000, JSP.
• Experienced in Replication Setup for Standby, Fail over, & Disaster Recovery Databases, and used Oracle Recover Manager (RMAN) extensively.
• Extensive knowledge of working with Business users, session, demos.
• Techno-functional responsibilities include interfacing with users, identifying functional and technical gaps, estimates, designing custom solutions, development, leading developers, producing documentation, and production support.
• Excellent interpersonal and communication skills, creative, research-minded, technically competent and result-oriented with problem solving and leadership skills.
• Proven strategic thinking skills.
• Excellent analytical, problem-solving, and decision-making skills.
• Excellent verbal, oral, and written communication skills. Excellent presentation skills.
• Exceptional interpersonal skills with ability to gain the confidence and respect of senior executives.
• Proven ability to work with all levels of management, and the most senior of Subject Matter Experts.
• Proven ability to communicate with and work with staff at every level of the organization.
• Experience with Six Sigma, Project Management, and System Development Methodologies.
• Experience using Zachman Enterprise Architecture Framework to align systems with business.
• Ability to work independently and organize workload with minimal direct supervision.
• Strong technical, management and leadership skills.

TECHNICAL SKILLS:

Languages: SQL/SQL*Plus, PL/SQL, T-SQL. UNIX Shell Scripting / PERL, VB script, Java script, BO SDK

Database: Oracle 11g, 10g, 9i, 8i, Sybase 12, DB2 8.1, SQL server 2005, 2008

ETL Tools: IBM Info Sphere (DataStage, Quality Stage) & Information Analyzer 8.1, DataStage 7.5.2EE client components (Designer, Director, Manager, Administrator), Profile Stage, DataStage 7.5.2. Informatica Power Center 8.6/7.1.3/ 6.2, Data integrator

Reporting: Business Objects XIR3.1, BI 4.0 (DeskI, Qwaas, Xcelsius, Live office, LCM, and Federator),Cognos, Crystal 2008.

Platforms: UNIX, AIX, Lynx, Windows Standard & Professional (XP, NT, 2000, 2008)

Web App: Tomcat 5.5/6.0, Web logic 9.2/10.3

Web Server: Apache 3.0, IIS 5/6.0

Utilities/Tools: Putty, SmarTerm, TOAD, Project 2003 Standard, Visio 2003 Professional

Knowledge: Hadoop/Big Data: HDFS, Mapreduce, Hbase, Pig,Hive, Sqoop, Flume, MongoDB, Cassandra, Power pivot, Puppet, oozie, Zookeeper

Java & J2EE Technologies: Core Java, Servlets, JSP, JDBC, JNDI, Java Beans

IDE s: Eclipse, Net beans

Big data Analytics: Datameer 2.0.5

Frameworks: MVC, Struts, Hibernate, Spring

PROFESSIONAL EXPERIENCE:

Confidential

Lead Senior Data Architect/Business Analyst

Responsibilities:

• Defined Personal Excess Liability product end to end dataflow process for downstream systems.
• Responsible for functional, business PEL master data definition analysis and content mapping.
• Defined MIS CIP migration strategic Analysis, definition, implementation, performance measurement.
• As a lead, primarily responsible for designing, implementing and supporting multiple Data Warehouse initiatives.
• Responsible for designing and implementing multiple Data marts.
• Responsible for the design of the ETL architecture for the Data Warehouse.
• Responsible for implementing best practices in Data Warehouse.
• Responsible for data model changes and source to target mappings to fulfill the growing requirements of business intelligence reports.
• As a subject matter expert, support the development teams as well as the business through all phases of the project
• Responsible for analyzing source databases and creating mapping documents.
• Responsible for implementing and supporting Metadata and Business Glossary.
• Primarily responsible for design flow for ETL that load data in to DHW. This involves data cleansing, complex transformation rules, validation and referential integrity.
• Documented test plans, test scripts, and validations based on design specifications for unit testing, system testing and functional testing.
• Responsible for preparing production deployment document and supporting the applications for any production issues.
• Responsible for conducting code review sessions with offshore and onshore teams and suggesting changes when necessary.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.
• Conducted JAD sessions for effective communication of vision and goals between stakeholders and gathered business requirements.
• Designed Data Flow Diagrams (DFDs), Entity Relationship Diagrams (ERDs) and web-page mock ups using modeling tools.
• Prepared Business Process Models that presented modeling of all the activities carried on by the business from the conceptual to procedural level.
• Effectively utilized prototypes to demonstrate and verify the behavior of the system
• Responsible for business and IT users regarding Data Ware house and its concepts.
• Responsible for Netezza & Exadata proof of concert to combine OLAP/OLTP systems.

Confidential

Project Lead/Data Architect/Business Objects Lead Architect/Admin

Responsibilities:

• Involved in gathering, analyzing, functional requirements and data specifications with the stake-holders.
• Worked with various IT Business Managers, Architects, End users in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Involved in Data Warehouse using DataStage ETL (extract, transform and load) tools to load legacy business data.
• Involved in Performance Tuning on the source and target at DataStage Level and Data Loading.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
• Performed Analysis and Design of ETL methodologies in all the phases of Data Warehousing life cycle.
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL).
• Experienced in working with scheduling tool Autosys.
• Defined Business Objects system infrastructure process flow to support various BOE products, new instances, upgrade dependencies, Crystal and WebI publication and scheduling.
• Involved in end-to-end web server/web application /BOE integration, CMS clustering in both Windows and AIX 6.1 platforms.
• Defined security model for various CitiDirect business groups, introduced single functional id user processing capability for custom web application accessibility.
• Defined user management best practices and created user creation process document.
• Created shared Business Objects architecture, design, multiple instance sizing, component integration.
• Involved in BOE instance creation capacity planning, tuning, upgrades/ alert monitoring.
• Created user groups, assigned user level access rights at folder, user groups and connection level.
• Upgraded Business Objects universes, WebI, crystal 2008, and dashboard models from version 3.1 SP3 to version BI 4.0 SP4.

Confidential

Lead Data & Business Intelligence Architect

Responsibilities:

• Involved in Designing and developing multi-dimensional model (Star Schema and Snowflake Schema) using Erwin.
• Worked with the business users to gather the business analysis reporting requirements. Designing and developed ETL process.
• Analyzed source data coming from various databases and files and working with business users and developers to develop the data Model.
• Worked with Business Users and DW Designers to understand the processes of Development, Methodology, and then implement the ideas in Development accordingly.
• Developed, tested Stored Procedures, Functions and packages in PL/SQL for Data ETL, Performed Data conversions.
• Involved in troubleshooting the load failure cases, database problems.
• Administered the Business Objects systems infrastructure, including installs, upgrades, and troubleshooting, publishing reports using publication.
• Involved in end-to-end web server/web application /BOE integration, CMS clustering in both Windows and UNIX platforms.
• Installed Business Objects 4.0 (base 4.0 and applied SP4) software and migrated content across the environments.
• Installed BOE client tools on windows platform.
• Involved in shared Business Objects architecture, design, multiple instance sizing, component integration.
• Involved in BOE instance creation capacity planning, tuning, upgrades/ alert monitoring.
• Involved in Business Objects client-server patch deployment.
• Defined folder based user security for various SBS user groups.
• Created user groups, assigned user level access rights at folder, user groups and connection level.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Upgraded Business Objects universes and reports from version 3.1 SP3 to version BI 4.0 SP2.
• Experienced in working with Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating high and detail level design specifications.
• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.

Confidential

Senior Data Warehouse Technical Analyst/Business Objects Lead

Responsibilities:

• Comprehensive experience in all phases of application development from initial requirements gathering, systems design, specification, and project planning through construction, documentation, deployment, and .
• Performed all phases of the Software Development Life Cycle (SDLC). Planning, Analysis, Design and Implementation.
• Created Xcelsius dashboards for tracking daily IT Shared Services operational SLA, reconciliation alerts.
• Created advanced support call activity tracker using Xcelsius gauges, charts, and other components, metrics, key performance indicators to generate interactive flash files and integrated with webapps for daily tracking calls.
• Extracted data from GL module and created universe and generated report for plan view & statutory reporting.
• Heavily involved in upgrading systems and maintained after implementation. Corrected defects using methods such as modifying code and fixing incorrect joins and altering sequence of program.
• Played key role in building shared BI infrastructure for CITI’s major sectors.
• Effort Estimation and Project Cost Management working with Shared Architecture Team.
• Participation in Business blueprint and requirement gathering discussions with end user, and transforming them into technical designs in close coordination with Onsite Architects.
• Functional feasibility analysis, for the CITI Implementation project, and translating the specifications to the team.
• Technical set up of Business Objects suit, setup of development, quality and production environments.
• Responsible for the deliverables for shared infrastructure builds, enhancements, end to end BI solution, process chains, stream line shared applications.
• Involved in shared BO Architecture, design, multiple instance sizing, component integration.
• Involved in Business Objects XIR2, XIR3 SP, FP and LA client-server patch deployments, capacity planning tuning upgrades/alert monitoring.
• Involved in end-to-end web server/web application/BOE integration, CMS clustering, load balance BigIP.
• Involved in Business Objects 6.1b to XIR2 migration initiatives, E-E 6.1B 2 XIR2 transformation.
• Integrated BOE SSL, site minder. Configured web agent and enabled LDAP for various confidential applications.
• Managing Problem tickets during the support phase after Go-Live and ensure smooth Go-Live and transition.
• Delivery, Cost, Utilization. Change Management and weekly conference calls with end user and SAP Business Objects teams.
• Preparing system volume testing, regression test cases to check the parameters with production server.

Technologies: Windows 2000, 2003, XP, and Vista, UNIX, AIX. Crystal Reports 8.5, 8.0/7.0/6.0. Business Objects 6.1B, XIR2 SP2, SP3 FP 3.2, XIR3 SP3, Xcelsius 2008. Oracle, Sybase, DB2 and SQL Server. Tomcat, WebLogic 9.2, 10.3, WebSphere. IIS 6.0, iplanet. Project 2003 and Standard Visio 2003 Professional.

Confidential

Senior Business Objects and Data Warehouse Technical Analyst/Architect

Responsibilities:

• Designed, developed and implemented business critical reports for various managements.
• Involved in system level troubleshooting for major deployments.
• Worked with various development teams on multi-source database systems.
• Responsible for tracking, analyzing and reporting of project performance against plans. Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders.
• Participated in technical weekly meetings, status reports, presentations, project for senior management across IB business sectors.
• Designed XIR2 web and Desktop Intelligence reports.
• Worked with data storage team on data retention process for BI components.
• Trained developers on steps involved in migration of reports from Crystal 8.5 to 9.0 and then 9.0 to 10.

Confidential

Senior Data Warehouse/Business Objects Developer

Responsibilities:

• Key role - In full life cycle BI infrastructure deployment.
• Installation of Business Objects Enterprise v6.1B.(Production Servers).
• Build Business Objects application on POC, Prepared test case.
• Developed report specifications for critical Business Objects application.
• Integrated Single Sign On with site minder.
• Manage Supervisor system level activities. Support ongoing user’s maintenance project.
• Involved in upgrade, reporting conversion initiatives for PeopleSoft modules.
• Installed Desktop products; created domain.key for POC environment.
• Create design universe, doc domain migration process. Maintenance of Repository Domains, Users and User Groups, User Privileges and Categories.
• Involved in pilot project for application foundation tool testing.
• Developed UNIX Shell scripts to pull data files from various sources through ftp and cleanse them, and also for invoke various Informatica batch/session jobs. Created Bulk load stored procedures.
• Deployment of reports to different environments depending on project phase like testing, UAT and production.
• Developed PL/SQL and triggers to implement business rules, involved in SQL query tuning & database tuning.

Technologies: Data Warehouses & Data Marts (using Star & Snow Flake Schema), in Oracle PL/SQL, 8i, under Sun Solaris OS, Unix (Solaris), PeopleSoft 8.4, Business Objects 5.1.3, Web Intelligence 2.6.3, 2.7, 6.1a, 6.1b, 6.5.1, Cognos 7, Data Integrator 6.5, Crystal Enterprise 10, OWD 2.0.4.7/2.1.1, Informatica Power Center 5.1, 6, 7.0, 7.1, Webi SDK (JSP).

Confidential

Team Lead Senior - Data Warehouse/Business Objects

Responsibilities:

• Design and developed Data Model, Star/Snowflake Schema combining the PeopleSoft sub systems transaction activities across the financial systems to have a data mart Accounting Information for end users (AIW).
• Developed relational databases, normalization and integrity rules, and enforcement. Analysis of session failure using Trace levels and worked with SQL Overwrite.
• Explored Coding of reports using BO SDK VB Script, for complex user requirements.
• Designed and developed complex VBA macros to customize user enhanced menu options on Business Objects application.
• Designed VBA macros in Excel - for manipulation of raw data in Excel - as per user’s requirements.
• Scheduling reports to Broadcast Agent Server and coding of macros using Business Objects SDK to reach user requirements.
• Involved in Business Objects Universes creation, reports creation and deployed reporting system over the web.
• Designed Sessions and Batches to do frequent data loads for Data load accuracy.

Technologies: Data Warehouses & Data Marts (using Star & Snow Flake Schema) in Oracle PL/SQL, 8i, under Sun Solaris OS, Unix (AIX, HP, SCO & Solaris), PeopleSoft 8.4, Business Objects 5.1.3, Web Intelligence 2.6.3, 2.7, OWD 2.0.4.7/2.1.1, Informatica Power Center 5.1/6, Webi SDK (JSP).

Confidential

Senior Data Warehouse/Business Objects Developer

Responsibilities:

• Created several complex Business Objects Universes and key elements of reports. Design and Hierarchy Building for Data Analysis, Aggregation Navigation, and apply to condition in Business Objects, resolve loops and other SQL problems.
• Created Business Objects reports and creating queries, and constantly worked with end users.
• Created complex PL/SQL Stored Procedures, Functions and triggers to implement business rules
• Prepared PL/SQL Packages to synchronize data in warehouse with various data marts.
• Involved in Data Manipulation & Mining for Data Marts (dependent and independent).
• Developed Materialized Views to contain summary information for easy search and Provider Search routines to dramatically improve the response times.
• Created several anonymous PL/SQL block to perform update based on max effective dates.
• Setup data extraction, transform and loading jobs through cron utility of UNIX.
• There were about 100 mappings, 20 SQL Scripts, Oracle Stored Procedure and Shell Scripts, source to target data analysis and a detailed design for every mapping.
• Wrote scripts for cleansing the data and created Unix Shell Scripts for scheduling back end jobs and running batch processes.

Technologies: Data warehouses & Data Marts (using Star & Snow Flake Schema) in Oracle 8i, PL/SQL, Sybase, under Sun Solaris OS, Informatica 5x, 6, 7.0,7.1, Business Objects 5.1.3, Web Intelligence 2.6.3, 6.1b, Cognos, Designer 2000, JSP.

Confidential

Oracle Developer/Data Modeler, Business Objects

Responsibilities:

• Developed PL/SQL stored procedures, packages & functions, database triggers to enforce various business rules and troubleshoot extraction processes and databases.
• Involved in designing the data marts based on the requirement document using Erwin but after analysis of the data coming from various data sources to setup the extraction processes and created the target databases for them.
• Setup Materialized Views & snapshots to periodically update contain summary information into the report database to facilitate easy data access and also developed the routines which make use of the Materialized Views for better response times for the regular query requirements.
• Developed Business Objects reports and creating queries, document centricity, calculations, variables, breaks, sorting, drill down, slice and dice, alerter and formatting presentation styles (graphical).
• Gathering user-requirements/feedback, implementing them in reporting applications, testing, QA and delivery.

Technologies: Oracle 8i, Designer 2000, SQL*PLUS, SQL* LOADER, PL/SQL, Oracle 8.0, Java, ASP 3.0, IIS4.0, Stored Procedures, SQL*Net and Informatica Power Mart 4.x, Business Objects 5.0, 5.1 and Web Intelligence 2.5/2.6, Oracle Express.

Confidential

Data Warehouse/Business Objects Consultant:

Responsibilities:

• Involved in data extract, load and transformation process using SQL*Loader, PL/SQL, C, UNIX Utilities.
• Wrote UNIX Shell Scripts and PL/SQL Code to transfer the data across the platforms and systems into Oracle Database.
• Mentored and provided technical assistance to developers for writing smart SQL & PL/SQL code to avoid unnecessary trips to the database to access the data that resulted in overall performance gain.
• Estimated the database requirements like table sizing, index requirements and resizing.
• Enforced business rules using declarative and non-declarative integrity constraints.
• Migrated data using Export/Import. Transferred large amounts of data in text format into the Oracle database using SQL*LOADER.

Technologies: SQL*PLUS, PL/SQL, SQL* Loader, SQL*Net, Stored Procedures, Business Objects 4.1, Windows NT v 4.0, Oracle v 7.3.2, PL/SQL v 2.3 and Erwin.

Confidential

 Designer/Developer

Responsibilities:

• Created several tables, views, synonyms, constraints, indexes, stored procedures, functions and triggers. Enforced business rules using declarative and non-declarative integrity constraints. Rebuilt indexes for better performance.
• Migrated data using Export/Import and transferred large amounts of data in text format into the Oracle database using SQL*LOADER. Wrote UNIX Shell Scripts and Pro*C Code to transfer the data across the platforms and systems into/from Oracle Database.

Technologies: Oracle 7.3, SQL AND PL/SQL, Oracle v 8.0.4, Forms 4.5, Reports 2.5 and PRO*C.