SUMMARY:

• Seeking a challenging position of Business Intelligence Architect
• 17+ years of experience in designing, developing, deploying, configuring, maintaining and Administering SAP Business Intelligence, SAP Data Services environments 4.2, 4.1, 4.0, 3.1, XI R2, R1, 6.5, 5.0 Web Intelligence, Crystal Reports, and Crystal Enterprise
• 12+ years of experience in leading teams, projects, solution design, project coordination and delegation and achieving results in a timely fashion
• 9+ years of strong experience in sizing, designing, installing, developing, deploying, configuring, clustering, integrating with other applications, maintaining and Administering Tableau Server, Tableau Desktop, Tableau Mobile, Tableau Online, Tableau Reader and building visualizations
• 4+ years of experience using SAP Lumira, Predictive analysis, Lumira Server, Design Studio, Tableau, Dashboard builder
• 3 years of experience working in a highly complicated SaaS environment serving hundreds of sites
• 6 months of experience working with SAP Lumira Discovery, SAP Lumira Designer
• Very strong experience in providing end to end enterprise wide reporting solutions for data marts, data warehouse, relational databases and other applications
• Excellent People - facing, presentation, management, leadership skills and ability to formulate a clear vision and strategy for the organization
• Self-motivated with ability to multi task, perform under pressure in a fast-paced environment, prioritize work
• Strong sense of ownership and willingness to take responsibility/accountability, c reative thinker, team motivator with good negotiation and organizational skills
• Excellent problem-solving skill and ability to adapt to shifting priorities and align activities and priorities to meet organizational goals
• 5 years of experience maintaining, configuring, patching, developing content, setting security and administering SAP HANA database
• Proficient in installation, configuration, administration, tuning, backup and maintenance of HANA, SQL Server, Oracle and Access databases
• Participated in all phases of the application development life cycle including analysis, architecture, design, prototyping, development, testing, performance tuning and deployment
• Very strong business analysis and analytical skills with ability to understand business logic and requirements to develop detailed technical design documents and POC models
• Proficient in training business users and developing project documentation, training material and product guides

PROFESSIONAL EXPERIENCE:

Principal SAP Business Intelligence Architect

Confidential, San Diego, CA

• Aligned staff per skill set and experience to support the project work, monitored staff performance by rewarding positive behaviors and addressed negative behaviors accordingly
• Supervised work of others, including planning, assigning, scheduling and reviewing work, ensured quality, and Maximized efficiency of assigned project team members through strong leadership, organizational and motivational skills. Mediated and resolved project team conflicts.
• Utilized creativity and resourcefulness in identifying and implementing team-building techniques.
• Installed and configured SAP Lumira server, Lumira Desktop, Predictive analytics
• Upgraded/ applied Lumira 2.x patches to BIP, migrated SAP Lumira Lums to Lumx files.
• Utilized SAP Lumira Discovery, SAP Lumira Design Studio, built SAP Lumira Storyboard and Data Visualizations, utilized data from Universes, Hana, Excel data sources, uploaded to BIP, shared with business users, set security.
• Created hierarchies, measures, enhanced with illustrations, worked with multiple data sets, massaged data, blended data, added charts, filtered data in visualizations, stories.
• Utilized geomaps, conditionally formatted. Published documents to Lumira server, HANA.
• Worked with Business Users, upgraded, enhanced and modified data Visualizations and distributed via Enterprise.
• Performed Environment analysis of SAP BI, DS Servers for enterprise wide Reporting, ETL, and fixed issues, suggested, implemented best practices, augmented team, helped reporting, data mining teams meet their deadlines
• Analyzed existing SAP landscape, BI content, performed BI system sizing, hardware sizing, worked with Network operations, hardware vendors, application owners, content owners, Business users and prepared Business Intelligence upgrade plan as a SAP Business Objects Administrator
• Hands on experience as a Primary Business Objects Administrator in upgrading SAP BI from Version 4.0 to 4.1, 4.1 to 4.2 version, Installed, Configured and setup Business Intelligence Servers, setup security groups, migrated content between environments, suggested and introduced Process improvement best practices
• Utilized Promotion management tool, life cycle manager, migrated Crystal reports, Webi Intelligence documents, Universes, Connections and other BI content, ATL files and VM tools and migrated content
• Performed weekly code deployment, utilized multitenancy and deployed BI content to multiple customers located geographically in different cities with very complicated security requirements
• Configured BI, DI cluster, load balanced systems, setup probes and monitored system performance
• Setup and configured SAP Business Intelligence SSO for users to auto logon, designed and developed application level and profile level security for BI content, setup and configured open doc, integrated BI into company portal in a highly complicated SaaS environment.
• Designed, defined and implemented SAP BI mobile, SAP Business Objects Explorer Mobile, Setup document retention policy and restrictions
• Version controlled BI, DI content, database code, also utilized central repository, star team for managing code, Performed system backups, maintained system health, performed regular system health checks
• Planned, implemented, installed and upgraded SAP Data Services version 4.1 to 4.2
• Deployed application and web tier components, configured application server, troubleshoot system issues, worked with SAP support, users, DBA’s and other teams
• Customized BI Launch Pad web page, set default user landing pages branded BI content
• Monitored BI scheduled report jobs, data extracts, fine-tuned processes, troubleshoot BI and DS Servers issues
• Supported Business Intelligence and Data Services Servers, provided support to users located geographically in different countries and continents
• Managed and monitored Data Services environment, setup server groups, configured Job Servers, setup batch jobs, configured repositories, setup security
• Monitored system for errors, collected trace files and performed root cause analysis
• Designed, build and setup SAP HANA databases, security, users, built analytic, attribute, calculation views
• Fine-tuned SAP HANA landscape, performed system maintenance, backed up systems, planned and applied Service pack stack 08 upgraded HANA databases
• Performed regular system auditing, looked for anomalies, usage, load, maintained licensing and compliance
• Performed project management activities, managed key aspects of project, implemented the projects and delivered BI/ DS solutions in a timely manner
• Worked with various team members across different departments both internal and external customers, partnered effectively with the business departmental leads
• Provided expert guidance on Business Intelligence (BI) technologies and helped junior team members
• Lead data governance strategy and ensured policy adherence, developed scalable and maintainable BI applications to meet business objectives.
• Addressed customer queries and issues in a timely manner, worked effectively with virtual teams both off-shore and onshore, listened to and communicated effectively with business leaders, end users and technical teams.
• Developed reporting and analytics business team capabilities, strategy and roadmap. Motivated team members, resolved issues.
• Facilitated meeting with various teams for defining reporting and analytics business requirements, Worked towards a companywide acceptable Business Intelligence release strategy.
• Performed root cause analysis work, troubleshoot issues, applied fixes and work around, helped stabilize BO environments
• Developed complicated universes, fixed existing universes, utilized Information design tool and Universe Design tool, rich client, built Web Intelligence reports, Lumira stories, Explorer Info spaces.
• Worked with members from multiple teams, DBA’s, UI developers, data modelers, participated in design review meetings and worked on troubleshooting data mart issues
• Provided production support, created Adhoc reports, Conducted WebEx sessions with the business teams, discussed and trained users.

Environment: SAP Business Intelligence 4.2/ 4.1, Universe Designer, Information Designer, Webi, Sap Explorer, Web Intelligence Rich Client, BI Launchpad, SAP Data Services 4.2/ 4.1, Crystal Reports 2013, SAP Information Steward, SAP HANA 1.0 SPS09/08, SAP Lumira Server, SAP Lumira Desktop 1.25, SAP Lumira 2.0, SAP Lumira Discovery 2.0, SAP Lumira Designer, SAP Lumira Design Studio, SAP Predictive Analytics, Python 3.6, Tableau Server, Tableau Desktop 10.5/10.3/ 8.2, SQL Server 2012, T-SQL, Oracle 12c/ 11g, PL/ SQL, Splunk, Sales Force, Star Team

Principal SAP Business Intelligence Lead Architect/ Consultant

Confidential, Irvine, CA

• Performed Environment analysis of SAP BI, DS Servers for enterprise wide Reporting, ETL, and fixed issues, suggested, implemented best practices, augmented team, helped reporting, data mining teams meet their deadlines
• Created Project plan, resource plan, managed key aspects of project, implemented the project and successfully delivered Business Intelligence solutions in a timely manner
• Worked with various team members across different departments both internal and external customers, partnered effectively with the business departmental leads
• Provided expert guidance on Business Intelligence (BI) technologies and helped junior team members
• Lead data governance strategy and ensured policy adherence, developed scalable and maintainable BI applications to meet business objectives.
• Addressed customer queries and issues in a timely manner, worked effectively with virtual teams both off-shore and on, listened to and communicated effectively with business leaders, end users and technical teams.
• Developed reporting and analytics business team capabilities, strategy and roadmap. Motivated team members, resolved issues.
• Facilitated meeting with various teams for defining reporting and analytics business requirements, Worked towards a companywide acceptable Business Intelligence release strategy.
• Drove the adoption of new business intelligence technologies and best practices within the team, conducted info and tool introduction sessions for new business users
• Performed root cause analysis work, troubleshoot show stopper issues, suggested fixes and work around, helped stabilize BO environments
• Installed, Configured and setup Business Intelligence Servers, setup security groups, migrated content between environments, suggested and introduced Process improvement best practices as a SAP Business Objects Administrator
• Supported Business Intelligence and Data Services Servers, provided support to users located geographically in different countries
• Monitored BI scheduled report jobs, data extracts, fine-tuned processes, troubleshoot BI and DS Servers issues
• Developed complicated universes, fixed existing universes, built reports, storyboards with charts using SAP Lumira.
• Coordinated with DBA, application developers, data modelers, participated in design review meetings and worked on troubleshooting data mart issues
• Provided production support, created Adhoc reports, Conducted WebEx sessions with the business teams, discussed and trained users.
• Built visualizations using SAP Lumira, Installed and configured SAP BI mobile. Setup and distributed BI content over mobile phones, iPad/ tablet devices.

Environment: SAP Business Intelligence 4.1, Universe Designer, Information Designer, Webi, Sap Explorer, Web Intelligence Rich Client, BI Launchpad, SAP Data Services 4.2/ 4.1, Crystal Reports 2013, SAP Information Steward, SAP Lumira Desktop 1.21, Business Objects Design Studio, SAP Predictive Analytics Tableau 8.2, SQL Server 2012/ 2008/ 2005, T-SQL, Oracle 11g, PL/ SQL

Principal SAP BI Administrator/ Lead

Confidential, Fountain Valley, CA

• Designed, Analyzed and provided SAP BI landscape for enterprise wide Reporting, ETL, IMDB’s, statistical, data mining and decision science teams
• Created Project plan, resource plan, managed key aspects of project, implemented the project and successfully delivered Business Intelligence solutions in a timely manner
• Worked with various team members across different departments both internal and external customers, partnered effectively with the business departmental leads
• Provided expert guidance on Business Intelligence (BI) skills and technologies
• Lead data governance strategy and ensured policy adherence, developed scalable and maintainable BI applications to meet business objectives.
• Addressed customer queries and issues in a timely manner, worked effectively with virtual teams both off-shore and on, listened to and communicated effectively with business leaders, end users and technical teams.
• Developed reporting and analytics business team capabilities, strategy and roadmap. Motivated team members, resolved issues.
• Facilitated meeting with various teams for defining reporting and analytics business requirements, Worked towards a companywide acceptable Business Intelligence technical architecture.
• Drove the adoption of new business intelligence technologies and best practices within the team, conducted info and tool introduction sessions for new business users
• Brought entire Memorial Health System, its associated clinics and other Pharmaceutical teams under one shared services BI Umbrella
• Implemented process, planning and improvement methodologies, Report/content coding, migration and documentation standards
• Implemented BI best practices, interacted with operational and technology management teams regarding security, reporting elements and integrity of source and data systems and repositories
• Lead team of direct reports and pushed for excellence, insight, and improvements
• Drove reporting and dashboard deliverables, new change requests and projects, followed agile methodology, communicated issues and project progress to management and customers.
• Documented project status, provided accurate and timely reports of current and projected progress of all project tasks
• Communicated effectively, built rapport with all project stakeholders and team members and instilled confidence in business users by consistently delivering high quality solutions and effective management
• Show cased SAP suite of tools, conducted demo and training sessions, researched specific department needs, suggested and implemented applicable SAP tools
• Performed Hardware sizing, worked with network team, hardware vendors and other team members
• Analyzed, Planned, Performed, managed Business Objects Upgrade projects 3.1 to 4.0, 4.0 to 4.1 as a SAP Business Objects Administrator
• Installed, Configured, setup SAP BI platform, tools such as Crystal Reports, Web Intelligence, Explorer, SAP Mobile, Live Office, Dashboards
• Implemented SAP HANA IMDB. Configured SAP HANA database, applied patches, setup security
• Performed HANA administration activities setup catalogs, packages, backups. Developed Analytic, Attribute and calculation views, utilized LCM
• Installed, configured, setup Data visualization and predictive tools such as SAP Lumira Server, SAP Lumira Desktop, SAP Predictive Analytics
• Developed and show cased Lumira stories to higher level management, built visualizations using Tableau.
• Installed and configured and maintained SAP Information Steward, Metadata Management, Data Insight and other EIM suite of tools
• Installed, configured and maintained SAP Data Services/ ETL tools. Setup security, repositories, managed and scheduled batch jobs, maintained Data Insight rules and Data quality jobs
• Lead the team in defining enterprise wide KPI reports and provided inputs to upper level management
• Served as a sub matter expert for BI core technologies by providing consulting services to other teams on request, audited work done by vendors and contractors, raised issues, got them fixed, organized peer review sessions. Established and enforced best practices and guidelines
• Analyzed existing reporting artifacts and removed redundancy and promoted sharing of information across customer groups, decommissioned old legacy reporting systems and built efficient SAP BI content, Web intelligence, Crystal reports, Lumira Stories
• Built Storyboards, built measures, charts, added data from multiple sources, geomaps using SAP Lumira, Business Objects Design Studio.
• Collaborated with other developers, Architects, Data Modelers and DBA’s to optimize the data model for BO reporting tools
• Participated in UAT conference status calls, answered user questions. Conducted user training sessions, developed training manuals. Fixed reporting defects raised by users
• Conducted Universe review sessions, gathered user feedback, modified Universe to make it more user friendly, added commonly used filters as Universe predefined conditions.
• Proactively monitored all BI environments for capacity and performance related issues and took necessary steps for their resolution and ensured application SLA’s are successfully met
• Administered SAP BI environments, HANA servers, maintained security settings, added users, folders, applied latest service packs and hot fixes.
• Migrated reports, universes, repository objects, folders, inboxes, users and settings from one environment utilized Import wizard, LCM, Promotion Management. Created repeatable backup jobs
• Used Publishing wizard to upload Crystal reports in Bulk. Scheduled reports on BOE, maintained cascading prompts using Business Views Manager
• Closely worked with Network Operations team regarding VM space issues, network, priority and hardware issues
• Identified server, tool issues, worked with SAP technical support, participated in long Net viewer sessions, set server and tool trace files and worked towards resolution

Environment: SAP Business Intelligence 4.1, 4.0, 3.1, Universe Designer, Information Designer, Webi, Sap Explorer, Web Intelligence Rich Client, BI Launchpad, SAP Data Services 4.0, 3.1 Crystal Reports 2013, 2011, 2008, SAP Information Steward, SAP HANA 1.0 SPS07, SAP Lumira Server, SAP Lumira Desktop 1.19, SAP Predictive Analytics, Business Objects Design Studio, Tableau 8.2/7.0/6.0, SQL Server 2012/ 2008/ 2005, T-SQL, Oracle 11g, PL/ SQL

Sr. Business Objects Architect/ Lead

Confidential, San Diego, CA

• Collected requirements from both business users as well as non-business users communicated from developer to CEO, developed report template documents. Discussed details with SME’s, data modelers and developed requirements, technical design, table mapping and project scope documents
• Lead team meetings, produced periodic status reports and updated plans, identified need for meetings of key project participants, facilitated team communication, participated in conflict resolution by building consensus
• Worked with cross-functional teams to gather requirements, prioritized projects and made sure they aligned with overall business needs and IT goals
• Worked closely with business units and provided direction, addressed business system challenges and suggested alternative solutions.
• Took ownership of understanding the customer’s information needs from the Business and worked in all areas to develop innovative ways to deliver solutions
• Ensured accuracy of delivered reports and conformity to SLA, analyzed data questions and issues as they arise, Worked with Business and Technology teams and proposed solutions and provided strategic direction
• Worked with Business Teams and Technology teams and prioritized on-going BI demands
• Lead the team in defining enterprise wide KPI reports and provided inputs to Chief of Actuary and other Directors in preparing their project roadmaps. Provided weekly project status reports, conducted JAD sessions
• Provided guidance, leadership and support in design, development and deployment of complex reporting and data architectures for Enterprise data marts, data integration and aggregate table designs for reporting applications. Handled one off Adhoc reporting requests
• Implemented data quality programs, raised upstream source systems changes, user entry issues and legacy application data issues in data governance group meetings and minimized impact to downstream data marts and reporting systems. Made corresponding ETL code changes, Updated Universe metadata and participated in data obfuscation project
• Developed Business Objects Universes, supported, updated and modified existing Universes. Set database limits and thresholds in the Universe, added hierarchies, utilized aggregate aware, created contexts
• Developed Complex Business Objects web intelligence reports with BO Infoview, created Webi reports with multiple queries and multiple tab’s, utilized custom SQL where required
• Optimized report execution time, developed complex queries, stored procedures for report generation using SQL server 2005, 2008 databases.
• Developed metrics, analytics, dashboards, alerts, used dashboard manager, scheduler.
• Performed Root Cause Analysis, found defects, logged defects, assigned them to developers and regularly monitored their status until they are retested and fixed
• Developed Complex Crystal Reports XI using stored procedures, commands, sub reports, prompts, cascading prompts and uploaded to BOE. Used Crystal Xcelsius for charting
• Demonstrated success in multi-team, multi-stakeholder, complex project environments. Used Crystal reports SDK and BOE and invoked reports from other web applications such as Java, ColdFusion with Crystal report viewers embedded into those applications presented detailed design documents to Architecture review board for approval
• Added metadata to Universe objects, consulted with subject matter experts, data stewards for input and clarification
• Designed aggregate tables, reporting tables based on data marts for building complex actuarial trending reports and triangles used for rate modeling, loaded data using SAP Data Services
• Maintained Data Integrator code, made updates to Job’s and data flows as needed, monitored daily and monthly data loads, utilized management console and UC4 scheduler
• Monitored all BI environments for performance and took necessary steps for their resolution and ensured application SLA’s are successfully met
• Maintained Business objects servers, maintained security settings, added users, folders, applied hot fixes and service packs. Regression tested reports after application of service packs on servers as primary SAP Business Objects Administrator
• Migrated reports, universes, repository objects, folders, inboxes, users and settings from one environment to other using Import wizard, Business Objects Life Cycle Manager (LCM). Created repeatable backup jobs
• Maintained scheduled reports on BOE, maintained cascading prompts using Business Views Manager, worked with BO support on issues
• Peer reviewed fellow developers code, mentored and helped them as required, helped SAP team’s BW and Bex developers in building business objects Universes, troubleshoot Universe corruption issues

Environment: SAP Business Objects XI R2, BO 3.0, 3.1, Business Objects Universe Designer, Business Objects XI,3.1, WEBI, Voyager, Web Intelligence Rich Client 3.1, Desktop Intelligence XI, 3.1, BO Infoview, Tableau 6.0, Data Integrator XI, SAP Data Services XI 3.0/ 3.1/ 3.2, Crystal Reports XI/ 2008, Xcelsius 4.5/2008, SQL Server 2000/ 2005/ 2008, T-SQL, UC4 8.0

Principal Business Objects Administrator/ Consultant

Confidential, Anaheim, CA

• Developed report developers guide, user training materials and Universe organization document.
• Prepared a list of elements required for BO reports and coordinated with DBA and application developers to get those populated, participated in design review meetings
• Developed and made modifications to the complex Business objects universe, developed universe objects with case statements where required, created user prompts, forced join prompts, lov’s
• Developed Business Objects XI web intelligence reports with BO Infoview, created Webi reports with multiple queries
• Created reports by using complex formulae, cross tabs, alerts, totals, graphs, reviewed, developed and converted SQL Server stored procedures
• Provided production support, created Adhoc reports, Utilized report component repository. Unit tested the developed reports
• Conducted WebEx sessions with the business teams, discussed and trained users.

Environment: Business Objects XI R2, Business Objects Universe Designer, Business Objects XI WEBI, BO Infoview, SQL Server 2005, T-SQL, Test Director, Siebel CRM 8.0

Senior Business Intelligence Lead

Confidential, Los Angeles, CA

• Analyzed the Key business questions (KBQ’s) that users are trying to get answered and translated them into Business requirements
• Created report templates documents, developed BI tool training and documentation
• Mapped the key functional elements in the data warehouse that needs to be presented to end users via Universe, web intelligence reports and for Adhoc reporting
• Defined metadata and rules associated with BI processes, implemented and supported Complex BI processes
• Analyzed, designed and developed Business Objects Universe for the complex dimensional model with star, snow flake schemas utilized database UDF’s in Universe, exported it to BOE CMS
• Created classes, objects with user friendly names and in easy to understand format, based on the complex data model and user requirements, created objects using Aggregate Aware function, set object-table compatibility
• Created hierarchies, developed universe objects with case statements where required, created user prompts, forced join prompts, set table join cardinality, set lov’s
• Developed Business Objects XI web intelligence reports with BO Infoview, created Webi reports, KPI’s, reports with groups, buckets, calculations and charts, customized BI tools to meet user needs, developed dashboards using dashboard manager, Xcelsius.
• Adapted BI processes to accommodate changes in source systems and new business user requirements and performed data analysis to validate ETL logic
• Designed customized interface application for Business objects SDK for HTML query panel, defined the security, intercepted BO queries with custom Java code
• Developed reports for electronic customer management system, Marketing Campaigns using Crystal Reports XI
• Developed reports, dash boards for performance analysis, Cross selling and commissions.
• Uploaded report to Business Objects XI, developed reports for Crystal SDK for report distribution via custom front end JAVA application.
• Developed complex reports with multiple drill downs and sub reports and configured BO for report distribution via Business Objects XI Info view
• Created reports by using complex formulae, running totals, graphs and charts for BOE XI
• Designed the batch processes, developed and converted SQL Server stored procedures.
• Participated and directed the use case team in design of the enterprise wide reporting applications for Life Insurance and other business units. Worked in coordination with database DBA team
• Delegated tasks to front end team, database team and reporting team, coordinated various project activities, tested the application, created defects in the Test Director.
• Conducted demo’s, WebEx sessions, net meeting sessions with the business teams, discussed and clarified requirements and trained users.
• Managed, utilized, assigned tasks to other developer’s, reviewed their code, participated in application shakeout after code deployment, tested the application and reports

Environment: Business Objects XI R1 and R2, Business Objects Universe Designer, Business Objects XI Webby, BO Infoview, Crystal Reports XI, IBM DB2 7/8, SQL, Windows, SQL Server 2000, T-SQL, Test Director, TOAD 2.0

Sr. Reports Developer / Database Developer

Confidential, Seattle, WA

• Developed and modified Business Objects Universe, created objects, classes, user prompts.
• Collected reporting requirements from users and translating end-user requirements into finished and working Business Object queries, reports
• Defined and maintained Business Objects Universes supported and maintained the Business Objects servers and application, administered security settings.
• Monitored system usage and performance and recommended appropriate changes, Created management reports for system metrics WEBI
• Developed complex financial reports for Risk team, upgraded old reports from previous versions to new versions for an asset management - brokerage firm.
• Mapped old reports to the new complex data model. Analyzed the report specifications and the database, Created KPI reports, Dashboards using Crystal Reports 10 and XI and Business Objects Dashboard manager
• Optimized the report execution time, Created objects, tables, stored procedures, views, cursors and indexes in T-SQL.
• Fine-tuned the database stored procedures to increase efficiency. Utilized database monitor, execution plan, profiler and index tuning wizard.
• Moved the reports from development, testing and finally to production environments and followed Change management processes. Created Ad Hoc Reports, Reports with multiple sub reports
• Utilized report component repository, developed report templates and reports with charts and maps using Crystal Reports 10.
• Developed VBScripts for report distribution to various servers.
• Uploaded the reports to the Crystal Enterprise and to VB.Net custom application for report distribution, uploaded Print reports directly to the applications as Crystal Enterprise Administrator
• Reviewed code developed by other developers, suggested ways to increase performance. Participated in design of reporting database

Environment: Business Objects XI, 6.5, Crystal Reports XI /10, T-SQL, SQL Server 2000, VB Script, Visual Source Safe 6

Sr. Reports Programmer/ Crystal Enterprise Administrator

Confidential, Seattle, WA

• Analyzed the report specifications and the database, Created KPI reports, Dashboards using Crystal Reports 10 against the Oracle Data marts with financial data and utilized fact and dimension tables, uploaded the reports to Crystal Enterprise 10
• Optimized the report execution time, created stored procedures, views, cursors, indexes and Triggers in T-SQL and PL/SQL, SQL * PLUS, SQL using TOAD 7.5. Fine-tuned the database and improved the performance of Oracle database, utilized ref cursor to generate reports from PL/SQL stored procedures
• Designed the reporting database architecture and mapped the various tables and sources required for reporting.
• Updated and maintained the BO Universes, Utilized the Business Objects Universe for generating Adhoc reports, utilized the query generated for testing and validating data
• Analyzed data, assisted team in delivering complex reports and performed data analysis, tested the web intelligence reports, provided day to day administration of the Web Intelligence environment.
• Fine-tuned the database stored procedures to increase efficiency. Utilized database monitor, execution plan, profiler and index tuning wizard.
• Utilized report component repository, developed report templates and reports with charts and maps using Crystal Reports 10.
• Performed Crystal Enterprise Administrator tasks, created accounts for security, set preferences and roles to individual logins, scheduled the reports and set default parameters on the Crystal Enterprise portal.

Environment: Business Objects 6.5, Crystal Reports 10, Crystal Enterprise 10, T-SQL, PL/SQL, SQL*PLUS, SQL, TOAD 7.5, SQL Server 2000, Oracle 9i/8i

Reports Developer / Database developer

Confidential, Seattle, WA

• Designed the BO Universe based on user requirements and data model
• Designed the architecture for interface to data warehouse using Business Objects business views and Web Intelligence
• Validated reports by comparing reports to result generated by BO queries against the database. Analyzed data for accuracy and verified ETL logic and transformation rules
• Troubleshoot existing reports to eliminate data discrepancies and responded to end-user inquiries submitted to the internal help desk request system.
• Designed, developed and administered reports by transforming data into reports, generated reports off tables, views, stored procedures
• Developed reporting architecture, production, snapshot/reporting clone databases, connected reports to databases using ODBC, Crystal ODBC, Remedy ODBC, OLE DB/ADO drivers
• Implemented Complex business logic using custom functions, formulas, filtering, sorting, selecting and grouping data. Formatted reports by positioning, sizing, layering report objects
• Generated Balance score card reports, Summary reports, drill down reports, dynamic reports, interactive reports, sub reports by implementing parameters for dynamic reports, cross tabs for summarized reports, created advanced record selection formulas, Optimized the report execution time
• Utilized report component repository, developed effective report templates and reports with charts and maps using Crystal Reports 10/9.0/8.5. Distributed the reports, deployed on web using Crystal Enterprise 10/9.0/8.5 and RAS
• Performed all Crystal Enterprise Administrator tasks, created accounts for security, set preferences and roles to individual logins, scheduled the reports and set default parameters on the Crystal Enterprise portal
• Multidimensional reporting against OLAP Data using OLAP Expert, Report creation wizard, Pivoting OLAP Grids, OLAP Analyzer, optimized SQL queries using Crystal Reports
• Knowledge of ITIL processes, developed VB Scripts, Created Crystal reports and embedded them into Remedy application.
• Participated in architecture related meetings, design reviews, report mockups and demo sessions

Environment: Business Objects 6.0, Crystal Reports 10/9.0/8.5, Crystal Enterprise 10/9.0/8.5, T-SQL, PL/SQL, SQL*PLUS, SQL, TOAD 7.5, SQL Server 2000, Oracle 9i/8i, Remedy ARS 5.1.2, MS Access XP, Windows XP, VB Script, JavaScript

Database developer / Reports Developer

Confidential, Seattle, WA

• Generated reports based on tables, views, stored procedures. Collected requirements from technical/non-technical users.
• Created Ad Hoc Reports. Developed effective report templates and reports with charts and maps using Crystal Reports 9.0/8.5. and Remedy Crystal reports
• Uploaded the reports onto Crystal Enterprise Portal. Created user accounts on the Crystal Enterprise portal, assigned roles and privileges to individual logins. Configured IIS, published reports on the web environment. Used Java Script and ASP.
• Developed complex stored procedures, tables, views, cursors, indexes and Triggers in T-SQL, PL/SQL, SQL * PLUS and SQL. PL/SQL stored procedures were developed using ref cursor.
• Created links from reports to the application via a web server. Created Reporting catalog for the reports developed and uploaded it to share point site.
• Designed and developed the reporting architecture, production, snapshot/reporting clone databases, utilized ODBC, Crystal ODBC, Remedy ODBC, OLE DB/ADO drivers
• Generated parameterized reports, summary reports, drill down reports, dynamic reports, interactive reports, sub reports, Balance score card reports, cross tabs reports, created advanced record selection formulas
• Developed reports against OLAP Data using, Pivoting OLAP Grids, OLAP Analyzer, OLAP Expert, Report creation wizard
• Developed the Business Objects Universe, set the cardinality based on the data model, utilized the BO query generated for testing, data validation. Utilized the BO query in development of complex KPI Crystal reports with multiple calculations
• Conducted report mockups, design reviews, user training and attended issue meetings. Provided on call support and helped to solve the user issues and made necessary changes,

Coordinated with DBA on design and architecture issues.

Environment: Crystal Reports 9.0/8.5, Crystal Enterprise 9.0/8.5, Business Objects 6.0, T-SQL, PL/SQL, SQL*PLUS, SQL, TOAD 7.5, SQL Server 2000, Oracle 9i/8i, Remedy ARS 5.1.2, MS Access XP, Pentium PC with Windows XP, VB Script, JavaScript, Visual Source Safe 6

Reports developer / Database developer

Confidential, Dallas, TX

• Created report storyboards, implemented business logic using custom functions, formulas, filtering, sorting, selecting and grouping data. Formatted reports by positioning, sizing, layering report objects
• Generated reports for billing, performance analysis, auditing and monitoring using Crystal Reports 8.5/9.0, Access Reports. Distributed the reports and deployed them on web using Crystal Enterprise 8.5/9.0 and RAS
• Used both Native and ODBC connections to talk to the database, customized front end to call the reports. Modified Existing reports for the performance issues, Upgraded all the existing reports from Version 7.0 to 8.5/9.0.
• Developed DTS packages/ nightly batch jobs to get data from production servers to reporting databases
• Created reporting tables, views, stored procedures in T-SQL for SQL Server databases and PL/SQL for Oracle databases using ref cursor, developed queries, cursors, triggers, added data validation controls to forms using Visual Basic, created spreadsheets and workbooks using MS Excel and exported reports to Excel.
• Administered the Crystal enterprise server, optimized number of reports that can run on the Crystal Enterprise server, created individual logins on the Crystal Enterprise portal, scheduled the reports on Crystal Enterprise server

Environment: Crystal Reports 8.5/9.0, Crystal Enterprise 8.5/9.0, Oracle8i, Business Objects 5.0, TOAD 7.0, SQL Server 2000, MS Access 2002, MS Excel 2002, PL/SQL, T-SQL, Windows XP, Visual Basic 6.0, VBScript, JavaScript

Reports developer /Programmer

Confidential, Richardson, TX

• Developed dynamic, interactive, drill down, summarized reports using functions, filtering data.
• Developed the reporting architecture, generated multidimensional reports against OLAP data using Crystal Reports 8.0/8.5 by implementing parameters for dynamic reports, cross tabs for summarized reports
• Created advanced record selection formulas, optimized the report execution time. Distributed and deployed presentation quality reports on the web. Imported/Exported reports to different file formats, Created Ad Hoc Reports
• Fine-tuned and improved the performance of database, Developed PL/SQL stored procedures for Oracle 8i and utilized ref cursor
• Scheduled, distributed the reports across the enterprise using Crystal Enterprise 8.5
• Participated in design reviews and architectural issues for the development of database

Environment: Crystal Reports 8.0/8.5, Crystal Enterprise 8.5, Oracle 8.1.6 & 8.1.7, SQL, PL/SQL, Shell scripting, Designer 2.1.2, Pentium PC with Windows NT, SunOS (Release 5.5.1), Solaris - UNIX

TECHNICAL SKILLS:

Reporting tools: Business Objects 4.2 / 4.1/ 4.0/ 3.1/ 3.0, XI R1/ R2/ 6.5/ 5.0Crystal Reports 2013, 2011, 2008, XI, 10, 9.0, 8.5, 8.0, 7Crystal Enterprise 10, 9.0, 8.5, 8.0, Crystal Xcelsius 2008, 4.5

Oracle reports 6i, 6.0, 3.0, 2.5, Discoverer (4i/3i/3.0): Web Intelligence, Desktop Intelligence, Explorer, Live Office, Voyager

Visualization Tools: Tableau Server, Tableau Desktop 10.5/10.3/9.0/8.2/7.0/6.0, Sap Lumira Discovery 2.0, Lumira Designer, SAP Lumira Server 1.17, SAP Lumira Desktop, SAP Predictive Analytics

ETL Tools: SAP Data Services 4.2/ 4.1/ 4.0, XI 3.0/ 3.1/ 3.2Business Objects Data Integrator XISAP Information Steward 4.2/ 4.1/ 4.0

Databases: MS SQL server 2012/2008/2005/7.0, Oracle 12c / 11g / 10g / 9i/ 8i/ 7.XIBM DB27/8, SAP HANA 1.0, MS Access 2016, 2013, 2010, 2003

Programming: T-SQL, SQL, PL/SQL, SQL*PLUS, Python 3.6, SQL*LOADER, KornBourne Shell Scripting, C, C++, Java, UML, Assembly Language

Front End: Developer 6i/2000(Forms 6i/6.0/5.0/4.5), Visual Basic 6.0Remedy ARS 5.1.2, Service now

Design Tools: Erwin 4.0, Rational Rose, Designer 6i/6.0/2000, MS Visio 2010, 2003

Operating Systems: Windows Server 2016/ 2012/ 2008/ 2003, Windows 98/NT/2000/XP/7AIX 5.2, UNIX (Sun OS5.6), Linux, MS-DOS, Mac OS 9.1, Linux 11

Tools: TOAD for Oracle 12.0/11.0/10.0/8.0/7.5, TOAD 2.0 for DB2, SQL Navigator Version Controls Microsoft VSS, SVN