Sangeetha Ramasamy

H*B

Greenville, South Carolina,29607

ad1j2h@r.postjobfree.com Mobile: +1-864-***-****

https://www.linkedin.com/in/sangeetha-ramasamy-2a72b110b/

Career Objective

An innovative, forward-thinking, proactive, respected professional who has accomplished significant achievements in business intelligence, reporting, data warehousing, analysis, problem-solving, training, research and development. Technically skilled in preparing, analyzing, interpreting business data for providing insightful business decisions and building visualized reports for presentation. I am passionate and interested in breaking down complicated business questions into steps and solved them in data-informed ways.

Summary

Over 15+ years of experience in Business Intelligence using SAP Business Objects4.0, XI-R3.1/R2/6.x with Info view, Web Intelligence, Webi Rich Client, Desktop Intelligence, Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Business Explorer/Polestar XI 3.1, Publishing Wizard, Import Wizard and Report Conversion Tool & SAP Business Objects Data Services, Alteryx Developer and Administrator, Tableau Developer and Administrator.

In depth understanding of SAP Business Objects Universe Design, Development, Enhancement and Maintenance using Information Design Tool (IDT) & Universe Design Tool(UDT).

Good Experience in SAP Business Objects Data Services (SAP BODS) as an ETL tools to load data from Relational and MS access databases.

Utilize all Data Warehousing/Reporting standards, architectures, and processes to ensure that all Data processing and development practices conform accordingly.

Competent in handling all levels of data warehouse life cycle including requirements, gathering, analysis, preparing business specifications, designing technical specifications and system requirement specifications.

Participate in all aspects of the project life cycle(SDLC), following rules and procedures for testing and monitoring the Data fetching for the reports.

Experienced with trouble shooting production issues. Team player with excellent communication and problem-solving skills. Proven ability to work in cross-functional teams with high sense of ownership and strong customer focus.

Highly efficient and committed in demanding and rapidly changing environments.

Educational Qualifications:

Qualification

University/Board

Year of passing

Master of Software(MS)

BITS PILANI, Rajasthan, India

2011

B.Sc Information Technology

Kongu Engineering College, Tamil Nadu, India

2007

Certifications

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2

Alteryx Foundation Micro-Credential

Alteryx Server Administration

Technical Skills

Reporting Tools: SAP Business Objects 4.2,4,1, XI 3.1, XI R3,XI R2, Crystal Xcelsius XI/2008, Infoview/BI Launchpad, CCM, CMS,CCM, Desktop Intelligence XI, Full Client, Web Intelligence Rich client, Web Intelligence, Query Builder, SAP Lumira, SAP Design Studio

ETL Tools: SAP Business Objects Data Services (BODS) 4.2

Data Science and Analytics Platform: Alteryx 2022.1 & Alteryx 2022.3

Platforms: Windows, Unix.

Databases: Oracle 10g& 11c, SQL Server 2000, MS access, IBM DB2, Sybase IQ, EDH

Languages: Java, SQL,PL/SQL, VB.

Products: Toad, Microsoft SQL Server Management Studio, Microsoft Office, Remedy, Service Now, HP Quality Management Tool.

Professional Experience:

Senior Technical Lead

Wipro\Trane Technologies LLC, South Carolina, USA March 2020 - till date

Environment: - SAP BODS 4.2, Oracle11g, SAP BO 4.2, Windows, Alteryx Designer and Administrator, Tableau Designer and Administrator, Service Now

Project Details: Client, one of the industry leaders in creating and sustaining safe, comfortable and energy-efficient environments and provides innovative solutions to optimize indoor environments through a broad portfolio of energy-efficient heating, ventilating and air conditioning systems, building and contracting services, parts support and advanced controls for homes and commercial buildings.

Responsibility:

Involved in the development and implementation of the Enterprise Data Warehousing EDW process and Data Warehouse.

Developed and supported in Extraction, Transformation and Load Process(ETL) using SAP Business Objects Data Services to populate the tables in Data Warehouse.

Strong hands-on experience in creation and setting up data stores, projects, workflows, data flows. Expert knowledge and hands-on experience on using platform, integrator and data quality transforms.

Experienced in Scheduling Jobs, Validation, Tracing and debugging Batch job.

Worked on Performance Tuning Techniques for long running jobs used techniques like source level, transform level and target level and pushing down operations to database level.

Building of the SAP BODS Jobs, Workflows, Data Flows as per the Mapping Specification.

Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations, Map-operation, History Preserving and Table Comparison transformations

Extensively used ETL to load data from flat file and also from the relational database.

Extracted data from different sources such as Flat files, Oracle to load into Oracle database.

Ensuring proper Dependencies and Proper running of loads Incremental and Complete loads

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.

Designed, developed and managed Universes in Business Objects Designer for generating the financial reports for finance controller users.

Created universes for Financial billing system and order processing.

Resolved loops by creating Aliases and Contexts and checked integrity of universes.

Created hierarchies in Universe to provide the users with drill down in reports.

Involved in optimizing the universe and SQL tuning to increase the query performance.

Implemented aggregate awareness to ensure the query is pulling the correct level of aggregation.

Created many financial reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals.

Developed many standard and ad-hoc reports using features like linking documents, crosstab, sections, breaks, ranking, filters, input controls and scheduled reports in BI Launchpad.

Involved in preparation of Technical design documents.

Using Service Now Tool, follow change management in promoting changes from development and staging to production environment, created Knowledge Article for standard application production process such as Service Account maintenance.

Maintaining knowledge of reporting processes and assisting end users with access and data issues.

Installed, Configured, maintained complete SAP Business Intelligence Suite(4.2) on Windows Environment.

Implementing Single Sign on(SSO) with SAP Business Objects on Windows.

Extensive experience in SIA (Server Intelligence Agent), FRS, CMS, CMC, Page Server, Cache Server, Job Server, Input/Output Servers.

Extensively used CMC(Central Management Console) for User Management, Content Management and Server Management tasks and CCM(Central Configuration Manager.

Promoting contents between multiple environments.

Perform installation, migration and upgrade of Alteryx Servers under High Availability scenario Perform performance analysis of existing Alteryx Servers and make Best Practice recommendations.

Perform day to day administration of Alteryx Servers in Windows environment.

Manage sites and projects/ collections.

Configure and manage project permissions.

Configure and maintain Active Directory integration with Alteryx Server.

Configure and troubleshoot Single Sign On (SSO) issues for Alteryx Server.

Provide 2nd tier support to user community on various Alteryx Server and Desktop issues.

Experience configuring Single Sign-on (SSO) with Outh authentication.

Experience in creating and guiding the user for DCM connection.

Experience in creating workflow by using the DCM or any other connections.

Experience/knowledge on the mongo DB.

Experience in moving the content from DEV to PROD by using alteryx designer.

Design and develop ETL workflows and datasets in Alteryx

Have Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms

Prepared technical specifications and documentation for Alteryx workflows Perform end to end Data validation.

Designed and Developed Tableau reports and dashboards

Experienced in Service Now Incident Management, Problem Management and Change Request and Application Development Change Request.

Associate Consultant

Wipro\Ahold, South Carolina, USA December 2019 - November 2020

Wipro\Ahold, Bangalore, India April 2018 - November 2019

Environment:- Oracle, Unix Shell Scripting

Project Details: Ahold Delhaize, one of the world's largest food retail groups, a leader in supermarkets and e-commerce. The project has been designed to provide the Technical support across various applications, among which one of the applications is Handheld Perishable Store Ordering.

Responsibility:

Analysis the existing system, Design the system process flow, provide the cost and resource estimation

Assist the project team to prepare the detailed project plan for project activities and deliverables

Facilitated with tech support to formulate a strategy for implementing good user support.

Handle the system/software upgrades, Bug Fixes, Minor & Major Enhancements and Application performance tuning.

Exposure to detecting, documenting and recommending approaches for handling data quality issues. Employ best practices for design, development, unit testing and test plan development

Cooperate and liaise with stakeholders and Offshore & Onshore team members for issue resolution, Bug Fixes and enhancements.

Responsible for providing knowledge on Production Environment to the migration team while Application Integration

As a Technical Lead, responsible for mentoring and guiding the Junior resources\Rookies.

Associate Consultant

Wipro\Allergan Inc, Bangalore, India December 2014 -March 2018

Wipro\Allergan Inc, California, USA March 2014 - November 2014

Environment:- Business Objects BI 4.1,SAP BODS,Oracle, SAP Lumira, SAP Design Studio

Project Details: Allergan Inc, one of the top pharmaceutical company that acquires, develops, manufactures, and markets brand name drugs and medical devices in the areas of medical aesthetics, eye care, central nervous system, and gastroenterology.

Building and Updating Universe's and Reports based on requirements. Have Developed Monthly, Quarterly Reports as required by the Management. Application Management Support for SAP Business Objects Module.

Responsibility:

Responsible for conducting training sessions with end users to teach them the fundamentals to work on Reports

Responsible for installation of Business Objects software’s for Technical team

Facilitated with tech support to formulate a strategy for implementing good user support.

Created Process document for supporting Business Objects environment. Process Document includes Template for gathering details for new schedule setup requirements, Steps to get access to Business Objects Environment (Requesting through the Access portal through Windows Active Directory), Web Intelligence and Publication setup best practices and Schedule Monitor Master List

Created Audit report (based on Audit Universe) to show the active users of the Business Object Environment and helps to clean the environment by removing the Users who are inactive.

Ensured Business Objects Enterprise Content Security by creating custom access levels for Developer,Super User and Basic User roles in Production Environment.

Assigned top level security within CMC(Central Management Console) for developer group,Super User Group and basic user group using the custom access levels.

Also created an Audit report to display the active reports( the report which has been used within specified period).

Promoted content from development to test to production environments using life cycle manager(LCM) and import wizard after testing and user signoff.

Responsible for setup and monitoring the scheduled reports and publications (Daily, Weekly, Quarterly and Monthly)

Exposure to detecting, documenting and recommending approaches for handling data quality issues.

Awarded “Onsite Best New Comer” during 2013-2014

Technical Lead

Wipro\Nissan-Kolkata, India December 2012 - February 2014

Environment:- Business Objects BI 4.1, DB2 AS/400

Project Details: Nissan Motors, one of the top Automobile Manufacturer in the world. The purpose of the project is conversion of Cognos Impromptu with Business Objects to support Windows 7 Migration which involved conversion of 120 reports across the seven different distribution center.

Responsibilities:

Performed an Initial Study of the current reporting application, to finalize the data elements required for reporting

Responsible for analyzing business requirements and developing queries and reports using Business Objects

Responsible for the design, development, coding, testing, debugging and documentation of Business Objects Reporting through extensive usage of standard concepts & principles

Expertise in implementing the universe concepts to accommodate the requirement efficiently

Good exposure on the single and multisource enabled data foundations using Information Design Tool.

As part of this project, dynamic data connection functionality(allowing the report to connect to particular database connection based on the selection of the prompt in the report) has been implemented which helps in creating duplicate reports by creating single set of reports for different distribution centers along with dynamic prompt

Customized LOVs in Universes for quicker performance of reports. Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes.

Set up row level or column level security on universe to restrict data access to certain user or user groups.

Worked extensively on various Web intelligence functions like Queries, Cross Tab, Conditional Formatting, Master Details, Breaks, Sections, Alerts, and Filters, Sorts/custom sorts, drilling, Ranking, Prompts, Formulas &Variables and merging two dimensions using the multiple data sources.

Involved in reviewing the code (Universe/Report) and documents (Design Document/Unit test case)

Involved in coordinating the Business Objects team tasks

Responsible for coaching, guiding and mentoring junior members in the team to help them scale up faster

Administer and supervise configuration of SAP Business Objects (SAP BO Admin). Designing, developing, and maintaining of management and analytical reports using SAP Business Objects Administrator tools includes Business Objects CMC, Info view, Web Intelligence, Desk Intelligence and Universe Designer.

Administration of servers, SAP Business Objects 4.1 Platform, Tomcat web servers, Crystal Reports, and Xcelsius Dashboards, Active Directory SSO.

Achieved 7/7 CSAT for this project with Wipro internal award

BOBJ Developer

Wipro, Bangalore, India April 2008 - November 2012

Environment: - Business Objects 6.5, Business Objects XI R3, Sybase IQ, Designer, Desktop Intelligence, Crystal Xcelsius Dashboard.

Project Details: - Client-Leading global provider of business decisioning data and analytics (Client Location-USA) who needed a Semantic layer and easy platform to Query and get reports to answer several questions regarding their Business. So mainly set up roles, rights, build Universes, and designed reports to provide better interaction and better Data Visualization.

Responsibilities:

Analysis of Business Objects Environment, Universe and Reports.

Developed new Desktop Intelligence reports to have the score card performance captured. Created Reports using functionality like Slice and Dice drill up and down, Cross Tab, Master Detail tables and Formulas. Automated XML data through Visual Basic macro.

Created Interactive Dashboards using Crystal XCelsius.

Automated the Daily Score card using Excel macro.

Created & Modified Universes for various functional areas of high level reports group using Designer.

Setting up new universe connections, access restrictions, checked integrity, cardinalities, optimized query processing time by using key features like aggregate awareness, indexing within designer.

Customized LOVs in Universes for quicker performance of reports. Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes.

Provide the team with in-depth SQL Query expertise for complex scenarios.

Changed the universe parameter settings to optimize the performance of universe.

According to the customer information created complex report using Universe as main data provider.

Exported the universes to the Repository making resources available to the users.

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

Various Programming tasks included developing Reports using free hand SQL.

Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.

Business Objects Reporting based on Oracle e-Business Suite implementation including (Account Payables, Account Receivables & General Ledger) Modules.

Created Universes and Webi intelligence reports and Dashboards based on Oracle Project Portfolio Management (PPM) database as per the requirement using Toad and did various analyses such as Effort analysis and rolling forecast details.

Enhancement project includes the development of Universes and Webi reports based on Oracle Territory Management(OTM)

Achieved 7/7 CSAT for 5 enhancement projects with Wipro internal award.

Provided technical oversight and subject matter expertise to Business Intelligence Team on key initiatives.

Migration of various reports and Universe from 5.1 & 6.5 to XI R2 and provided support Development, Test to Production Environment. Configured servers in XI R2 for Development, Test and Production environments and created Server groups.

Develops proto-types and presents to stakeholders as solution options for purposes of introducing new technologies, and development techniques in environment.

Set up the monitoring of BO servers. Set up the auditing policies, and managed event and alerts related to CMS, Audited and Reported Database services. Administered CMS cluster configuration, CMS sizing and load balancing. Kept availability of BO Web applications CMC, BI Launchpad, and other applications. Managed day to day scheduled report jobs from Instance Manager. Performed Business Objects Service Patch and software upgrades. As SAP BO Admin, set up row level or column level security on universe to restrict data access to certain user or user groups using Central Management Console.

Contact this candidate