ARVINTH NARAYANAN

E-Mail: adjvy7@r.postjobfree.com Mobile: 972-***-****

PROFESSIONAL SNAPSHOT

Completed Master of Business Administration from University of Arizona in May, 2010.

A result oriented professional with more than 10 years of experience in:

- Data Warehousing

- Business Intelligence

SAP Certified Application Associate – SAP Business Objects Web Intelligence 4.1

Certified Tableau Desktop Specialist

Certified Scrum Master

ITIL-Foundation

Experienced in implementation of Business Intelligence projects using various visualization tools and platforms in Energy Utility, Retail, Finance and Market Research domains.

Experienced in discussing requirements with business, preparing technical design documents, leading team members; allocating resources among team members and guiding team members during the project, until project delivery.

Experienced in interacting with end users, data architects and ETL developers to analyze the business process and requirements and transforming requirements into dashboard and reports, designing/analyzing database and documentation.

Experienced in all the steps of Software Development Life Cycle (SDLC) and agile (SCRUM) methodology such as gathering project requirements, analysing system, developing, testing, migration and administration, security management and production support.

Proficient in Tableau for dashboard development. Also proficient in Business Objects Universe Designing, Web Intelligence reporting, Crystal for reporting, SAP Lumira, SAP Dashboard, Qlikview, MS Power BI for additional dashboard development.

Worked on generating various dashboards to Tableau Server using different data sources such as Teradata, SQL Server, AWS, Sales force, Oracle, PL/SQL, DB2, Teradata, SAS datasets, MS Excel etc.

Good understanding of relational database structures, theories, principles, and practices and proficient in SQL for data analysis and fixes as well as data validation with respect to many relational databases like Teradata, Oracle, SQL Server and PostGreSQL.

Familiar with Project Management, Change Control, Incident Management, Claims (Riskmaster application) and System Development Lifecycles in an Agile environment.

An effective communicator with excellent team building & interpersonal skills. Strong analytical, problem solving with organizational abilities.

TECHNICAL SKILLS

Reporting Tools

Tableau 2020/2019/2018/10.5 (Desktop /Server /Reader/ Public/ Online), Google Analytics, Adobe Analytics, Power BI, Business Objects. SAP Lumira, Power BI.

RDBMS

Teradata 13.0, ORACLE 12, 10g/9i/8i, MS SQL Server 2005/2000, SAP Hana and MS- ACCESS.

Data Modelling

ER Studio, Oracle Data Modeller, ERWIN,MS Visio.

GUI Tools

Visual Basic 6.0, JSP, ASP, SQL Navigator, Toad.

Client: Fannie Mae, Reston, VA Oct ‘20 – Till Date

Role: Senior Business Intelligence Developer

Description:

The Federal National Mortgage Association (FNMA), commonly known as Fannie Mae, is a United States government-sponsored enterprise (GSE) and its purpose is to expand the secondary mortgage market by securitizing mortgage loans in the form of mortgage-backed securities (MBS). The SEAR or Simplified Enterprise Architecture Repository provide the single platform to create infrastructure related content.

Responsibilities:

Led many discussions with all the projects stakeholders (Users, Project Managers and SMEs) to gather and document business requirements for the various Business Intelligence dashboards and reports related to the SEAR 2.0 application.

Worked to present the end users with Lumira dashboards and Business Intelligence report visualizations in Launchpad and Fiorified Launchpad.

Created the Portfolio and Assets related dashboards and reports for the external users where they could view the various visualizations of Tech Debt, Mandatory Upgrade List (MUL), Pattern Coverage and Health Metrics information.

Created many asset related dashboards and reports such as asset host profile and application architecture profile along with upstream and downstream assets information along with the software and servers utilized for each of the assets.

Created many complex Web Intelligence reports specifying Bar Graphs, Line Graphs, crosstabs information along with linked reports and others making use of complex formulae in many variables.

Created customized Lumira dashboards, integrating Custom SQL from Oracle based universes along with information from spreadsheets.

Created a catalogue of the existing and new reports while documenting the various datasources along with various tables used in the reports. Also, documented the Autosys jobs used to populate the various Oracle tables.

Compared the list of dashboard/report tables with the production tables to archive and/or delete obsolete tables. Archived all the unused tables in Oracle.

Created a Data model using ER Studio cataloguing all the various free hand SQL information from each of the Lumira dashboard to create an architecture repository of the database.

Worked on shakeout/regression testing performed in Sandbox, Acceptance and production environments for new Business Objects patch migration.

Performed data analysis and validation using free hand SQL on various sources systems including Oracle and Postgre to validate the existing Lumira dashboard information.

Helping the team prime up for Oracle to AWS migration.

Provided Business Objects and Lumira training to some of the new business users.

Environment: SAP Business Objects 4.2 SP6, Lumira, AWS, Oracle 12g, JIRA, Python, SharePoint, MS Office Suite (Word, Excel, PowerPoint).

Client: Canon USA, Melville, NY Sep ‘17 – Sep ‘20

Role: Senior Business Objects Developer/Lumira Developer

Description:

Canon USA is a subsidiary of Canon Inc. which specializes in the manufacture of imaging and optical products, including cameras, camcorders, photocopiers, steppers, computer printers and medical equipment earning revenue of over $11 billion. The daily transactional data is stored in the ODS/warehouse through their homegrown S21 application and the data analysed using many Business Object reports/Power BI/Lumira dashboards.

Responsibilities:

Led many discussions with the various stakeholders to gather business requirements to create BI design documents.

Scheduled and coordinated the day-to-day activities of the team.

Reviewed design documents, user acceptance test cases, results documents prepared by team members. Allocated tasks to the members and ensured on-time delivery.

Worked with various stakeholders to document business rules and requirements from existing reports.

Updated requirements traceability matrix throughout the lifecycle of a capital project until project closure. Worked on providing universe user guide information as well other report documentation for the various end users.

Worked on many BI implementations like Customer Dedupe, BISG, LAG, Magento Commerce and creation of master-child (linked) universes along with many support initiatives.

Worked on complex Web Intelligence reports that require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages along with specifying version control of all the updated reports and dashboards.

Utilized the Development, QA and Production environments effectively. Developed the various reports and dashboards in the development environment, tested it extensively in QA while working with end users, and deployed the reports in production environment with version control.

Created many dashboards (for business executives), graphs using Tableau, SAP Dashboard, Lumira, Tableau and MS Power BI. Personalized the dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI).

Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations.

Technical knowledge of both Tableau Desktop and Tableau Server from an administrative and a consultative standpoint.

Supported business and field users for any issues in their WebI and Tableau reports. Worked extensively on Severity 1 & 2 tickets (Remedy) and data/bug fixes.

Extensively worked on implementation of Lumira 1.31 to 2.1 upgrade.

Assisted users in scheduling WebI reports through BO Scheduler distribution system.

Developed new universe for Ecommerce team, which encompasses all their order and membership information.

Experienced in writing complex SQL queries to create many derived tables as well as the ability to write free hand SQL queries to analyse the information for customer problem research.

Designed and modified the Universes in IDT 4.2/4.1 as per the requirements adding new folders/classes and objects with row-level security.

Developed and maintained complex universes supporting multiple levels of hierarchies for drill down, drill through and drill across functionalities.

Created Year to Date, Month to Date and Summary reports for the different domains like Project Management, Financial and Tax department.

Worked with the ETL developers in tools like BODS and INFORMATICA to use design, build, and populate data objects such as cubes, relational dimensional databases, and data mining models.

Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console as well administration experience with cluster node installation.

Experienced in BO server management like restarting the instance, application server and applying patches as per user requirements as well as production deployments. Exclusively worked on upgrading from 4.1 version to 4.2 SP6 and then to 4.2 SP6 patch 3 version.

Environment: SAP Business Objects 4.2/4.1 (Rich Client, CMC, Web Intelligence, Designer), Tableau, SAP Lumira, Teradata, Oracle, MS Office Suite.

Client: Xcel Energy, Denver, CO Nov ‘10 – Aug ‘17

Role: Business Objects Developer/Crystal Reports and Xcelsius Developer

Description:

Xcel Energy is an electric utility company providing Electricity and Natural Gas to customers in eight different states earning revenue of over $11 billion. The operational and financial data is stored in the Warehouse through various third-party applications and the data analysed using different Business Object reports/dashboards.

Responsibilities:

Involved in all steps of Software Development Life Cycle (SDLC). Gathered report requirements from the users, preparing draft specifications, generating new universes and reports.

Worked on creation of many Webi reports and Lumira and Design Studio dashboards.

Worked on Business Object migration project from XIR 3.1 to 4.1 SP 5 and played a key role in migration of all business objects reports from Deski to Webi.

Created complex highly formatted reports in WebI using multiple data providers for various financial and energy projects. Fixed performance issues in WebI and DeskI reports. Also worked on many complex projects with no data model and data.

Designed new universe and modified existing ones in 4.1, XIR3 as per the requirements, adding new classes and objects as required.

Experience in using Information design tool (IDT), to create universes using multiple data sources from SQL Server, Oracle and Teradata.

Used derived tables to create the universes for best performance, and used context and alias tables to solve the loops and traps in the Universe.

Created number of formulae, conditional display of fields for complex calculations and used them in different sub reports linked to the main reports. Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc.

Created dashboards, graphs using Tableau and Xcelsius. Personalized the dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI).

Have extensively worked in developing ETL activities for supporting Data Extraction, transformations and loading using Business Objects Data Services.

Worked with ETL team to create complex Jobs, Work Flows, Data Flows, and Scripts using various Transformations (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.

Experienced in cleansing the data using Data Quality transforms.

Created an Xcelsius dashboard for the closed projects, which combined data from three different universes using three different QaaWS queries.

Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.

Created many schedules for e-mail delivery and write files to ftp servers for Business Objects reports using a third-party scheduling tool Infoburst. Extensively worked to resolve any schedule related errors too.

Provided mentoring and training to users in the Business Objects training and conducted Open Lab sessions. The training sessions usually consisted of a Basic, Intermediate and Advanced session. Assisted users in solving report issues during open lab sessions.

Environment: SAP Business Objects 4.1/XI R3/XI R2 (Desktop Intelligence, CMC, CMS, Web Intelligence, Designer, Xcelsius 2008, Import Wizard), Teradata, Oracle, MS Office Suite.

Client: DCP Midstream, Denver, CO Jul ‘10 – Oct ‘10

Role: Business Objects /Xcelsius Developer

Description:

DCP Midstream is one of the largest gatherers and processors of natural gas, and one of the largest producers and marketers of natural gas liquid. The Business Objects reports improved the capability and better analyse the credit system of its clients.

Responsibilities:

Involved in all steps of Software Development Life Cycle (SDLC). Gathered report requirements from the users, preparing draft specifications, generating new universes and reports.

Worked on creation of many Webi reports and Lumira and Design Studio dashboards.

Worked on Business Object migration project from XIR 3.1 to 4.1 SP 5 and played a key role in migration of all business objects reports from Deski to Webi.

Created complex highly formatted reports in WebI using multiple data providers for various financial and energy projects. Fixed performance issues in WebI and DeskI reports. Also worked on many complex projects with no data model and data.

Designed new universe and modified existing ones in 4.1, XIR3 as per the requirements, adding new classes and objects as required.

Experience in using Information design tool (IDT), to create universes using multiple data sources from SQL Server, Oracle and Teradata.

Created an Xcelsius dashboard for the closed projects, which combined data from three different universes using three different QWAAS queries.

Company: Tata Consultancy Services, Chennai, India Oct ‘05 – Jul ‘08

Role: Business Objects Developer

Description:

Tata Consultancy Services Limited (TCS) is a leading Indian IT services, business solutions and outsourcing company providing services to clients in all major domains. My client was ACNielsen, which is one of the world’s largest market research firms.

Responsibilities:

Involved in all steps of Software Development Life Cycle (SDLC). Gathered report requirements from the onsite teams, prepared draft specifications to generate new reports.

Created various LOVs for ease of Ad-hoc reporting in the process of building the Universes.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.

Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free hand SQL.

Developed new Business Objects Reports along with modifying existing reports to support new and additional business requirements. Used prompts, filters, alerts, drill down analysis, row level securities and aggregative awareness as per the end user requirements.

Extensively used calculation contexts, variables and drill downs in the creation of reports.

Involved in the creation of various report formats including Master/Detail Reports, Sub Reports and Cross Tab Reports and published them via the Crystal Enterprise.

Worked with ETL team to create mappings to extract data from source files, transform the data using filters, expressions and stored procedures and then load to data warehouse.

Involved in unit testing, integrated testing and system testing in the report development project.

Contact this candidate