Post Job Free

Resume

Sign in

Data Project

Location:
Dublin, OH
Posted:
August 03, 2017

Contact this candidate

Resume:

Narasimhaiah Mannem

Mobile: 614-***-****

E-mail: ac1nk8@r.postjobfree.com

Experience Summary:

Total 14+ years of IT experience (8 years in US) in all phases of Software development life cycle including requirements gathering, analysis, estimation, design, develop, implementation and support of Information Management and Business Intelligence Applications for various clients like Cardinal Health, Shell, British Petroleum, British Telecom and npower in Health care, Energy & Utilities, Telecommunications, and processing industries.

Extensive experience in Business Intelligence applications (Assessment, Architecture, Installation, Configuration, Administration, Design, Develop, Deploy, Implementation, Migration and Support) using SAP Business Objects product suite 4.2 / 4.1 / XI 3.1 / XI R2 and Business Objects 6.5/6.1/5.1.4.

Experience in SAP HANA SP12/SP10/SP9 (Data provision (SLT), Smart data access (SDA), HANA modeling, Security and HANA SQL Script).

Experience in design and develop HANA views to consume from Web Intelligence, Analysis for Office, SAP Lumira and Tableau.

Experience in Data Extraction / Transformation and Loading, Data Migration, Data modelling, Data Analysis and Data Profiling.

Experience in driving End-to-End (E2E) BI & Analytics solutions to business that meet or exceed business requirements around data availability, data quality, flexibility, SLAs.

Experience in design, develop story boards and visualizations using SAP Lumira, and Tableau.

Experience in emerging technologies like HADOOP and integration with HANA.

Knowledge in S4HANA, BW4HANA, SAP BODS XI 3.1/4.1, AWS, Qlik View /Qlik Sense and SAP BW.

Knowledge in Agile and waterfall methodology.

Functional knowledge on various SAP Modules like SAP SD, FI, CO, and MM.

Experience on working in large or medium BI program and driving E2E design standards & guidelines leveraging technologies like Teradata/Oracle/SQL Server technologies, SAP BI and ETL tools.

Experience in coordinating cross-functional teams, management and presenting technical ideas to diverse groups & proven ability to implement technology based solutions for business problems.

Proven track record of managing IT operations performance and the delivery of IT services leveraging ITIL processes (including Problem Management, Incident Management, Configuration Management, and Change Management).

Team player, strong attention to detail, ability to work with staff at all levels within an organization.

Confident, independent, leadership skills, good decision-making abilities.

Education:

Master of Engineering (Mechanical) from Osmania University graduated in the year 2004.

Bachelor of Engineering (Mechanical) from Andhra University graduated in the year 1997.

Certification:

SAP Certified Application Associate – SAP HANA (Edition 2015)

SAP Business Objects Enterprise Certified Professional – BOE XI 3.0

Technical Skills:

Business Intelligence

SAP Business Objects 4.2 / 4.1 / XI3.0 / XIR2 (CCM, CMC, universe designer, information design tool, Desktop Intelligence, Web Intelligence, Web Intelligence Rich client, Crystal Reports, Live Office, Xcelsius, Import wizard,, Report Conversion Tool, Report Comparison Tool, Dashboard Manager, explorer, Analysis Office, Dashboard, SAP Lumira) and Business Objects XI R1/6.x/5.x ( 2- tier / 3-tier Business Objects, Supervisor, designer, Broad Cast Agent), SAP HANA SP9/SP10/SPS12, SAP BW, Tableau, Hadoop, Qlik View/Qlik Sense.

ETL Tools

Informatica 7.1.5, DTS, Data Stage (Info sphere), Data Loader and OWB

Databases

Oracle 11g/9i/8.x, SQL Server 2000/2008, MS Access, DB2 and Teradata.

Operating Systems

Unix, Linux, Windows NT/2000/2003/2008, MS-DOS.

Languages

SQL, PL/SQL, UNIX Shell Scripts

Other Tools

TOAD, winsql, Erwin

Packages

MS-Word, MS-Excel and MS-PowerPoint.

Professional Experience:

Project #6

Client: Cardinal Health Inc, Dublin, OH Sept’2007 to till date

Role: Business Intelligence & Analytics Consultant

Responsibilities:

Providing overall technical guidance, leadership, and execution of E2E technical design as relates to data extraction from SAP and Non-SAP Source systems into Data Warehouse and Business Intelligence capability requirements.

Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.

Design and developed HANA models using SDA (Smart Data Access) to extract data from different source systems.

Developed complex SQL scripts in Calculation views.

Transport HANA content in system landscape Dev, QA, Stage and Prod using delivery units and CTS through LCM.

Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development.

Involved in SAP HANA Security including User Management, Work load Management, Roles, and Privileges.

Implemented data security access with dynamic privileges in HANA, Universe / report/folder level / user group security access with integrating LDAP directory for SSO in BO.

Design, develop, implement and maintain Universes using Information Designer Tool and Universe Designer Tool.

Created Universes on top of HANA calculation views and developed reports using Web Intelligence, Crystal reports, Live Office, Analysis Office for Excel, SAP Lumira, and Tableau for end users.

Administration of BO 6.0 and SAP BO XI 3.1/BO XI 4.1 / BO XI 4.2 servers (Server configuration and monitoring, security & migration, users, groups, folders, applications, authentications) using supervisor module and CMC.

Create documentation to establish requirements traceability and help the technical user community.

Business Objects Report migrations between different versions i.e. BO 6.5 to SAP BO XI 3.1, BO XI R1 to SAP BO XI 3.1, SAP BO XI R2 to SAP BO XI 3.1, SAP BO XI 3.1 to SAP BI 4.0, SAP BI 4.0 to SAP BI 4.1 and SAP BI 4.1 to SAP BI 4.2.

Develop prototyping solutions, preparing test scripts, and conducting tests for reporting solutions.

Provide functional and technical guidance to business teams when needed.

Assist Project Managers in developing project plan including resourcing, budgets, timelines and forecast.

Used Business Objects reports level functions like Alerts, Breaks and Customized Filters to display relevant data and created complex reports by linking data from Multiple Data Providers from different databases, created various predefined security settings depending upon users and group needs.

Design and develop ETL mappings for Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Data stage.

Involved in performance tuning of reports that were running slowly (Performance tuning at the report level, Designer level and database level)

Preparing User Acceptance Test documents.

Handling change requests and other enhancements to the applications.

Provide data analysis and identify data related issues within the NPS DWH environment as well as upstream systems, as needed.

Proactively maintain system, support, and process documentation; work closely with Development teams, Operations, and Business Owners to ensure accuracy and completeness.

Working as onsite coordinator - to provide steady state support for NPS DWH (End-to-End) and other reporting applications i.e. Medical, EBS and PD reporting applications.

Environment: Business Objects 4.2/ 4.1/XI 3.1/XIR2/XIR1/6.5/6.1 (CMC, Desktop Intelligence, Web Intelligence, Crystal Reports, Import Wizard, Designer, Information design tool, Report conversion, Live Office, Xcelsius, Dashboard Manager, explorer, Analysis Office), SAP HANA, SAP Lumira, Tableau, Informatica, Info Sphere, SQL Server 2000, Oracle 9i, DB2, Teradata, PL/SQL, UNIX Shell Scripts, Windows 2000/2003/2008/UNIX/LINUX servers.

Achievements:

Got Wipro BTS Starship Award (Category- Individual Excellence) for Project Performance.

Got CSAT 7/7 for seven consecutive years.

Project #5

Business Objects Technical Lead Jul’2006 to Aug’2007

Client : Shell, Netherlands

Team Size: 6

Was responsible for leading projects to design and develop reporting applications i.e. File Plan Data Analysis, E-PIMS design, Energy Component, Live Link, SPEED and ASSAI that including

Responsibilities:

Assess the current reporting environment and applications for the migration.

Design the BO XI architecture and develop specifications for the migration.

Preparation of Architecture and Design documents related to the projects.

Design and build the Data Warehouse for File Plan Analysis and Live link applications.

Deployment of Business Objects 6.5.1 for Other Applications like Energy Component.

ETL mappings design for Extraction, Transformation and Loading of data from FPB and TRIM application databases into Data Warehouse using MS DTS.

Design and build the universes.

Design and developed the Reports as per the Users requirements using all facilities in Business Objects.

Data reconciliation between the source and Target for the different applications.

Performing Unit Testing and System integration Testing.

Supporting UAT from offshore.

Handling change requests and minor enhancements.

Helping BOCC supporting team to fix the bugs and incidents rose from other BO applications.

Environment: Business Objects 5.x/6.5.x/XI R2, MS DTS, Oracle 9i, SQL Server 2000

Project #4

Business Objects Technical Consultant May’2006 to Jun’2006

Client: npower, UK

Project Name: Portfolio Management (Phase 3) – Gas

Team Size: 4

Responsibilities:

Created, modified, enhanced, tested, deployed, optimized, and maintained Business Objects Universes using Designer to include objects like dimensions, details, measures & tables, views according to the users requirements

Created various stored procedures, functions, cursors, views to do the reporting with the OLTP transactional database.

Reviewed System Integration test scripts.

Support System integration Testing and UAT from onsite

Fixing the bugs and incident of Business Objects applications

Environment: Business Objects 5.1.6, Oracle 9i

Project #3

Business Objects Technical Lead Sept’2005 to Apr’2006

Client: BP Inc, USA

Project Name: BP- Load Tracker & Metric Reporting

Team Size: 4

Responsibilities:

Design and build the universe.

Formatted the Reports as per the Users requirements using all the facilities in Business Objects.

Involved in the Installation and configuration of all components of Business Objects and configured the Web Intelligence using configuration tool.

Responsible for setting up the Users/Groups, Database connections, assigning privileges to the Users using Supervisor.

Installed & configured BCA Scheduler & Publisher.

Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.

Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.

Worked in creation of multiple universe and document domains for development, test and production Environments.

Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.

Good experience in creating and maintaining Secured, Shared and Personal connections.

Involved in designing and developing of Universe for reports generation.

Checked the integrity function for existence of loops and resolved them by using aliases and contexts.

Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.

Manipulated the data by creating user defined objects using advanced database functions

Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down,Alerter, User response, and Formulas etc

Responsible for overseeing the Detail Design documents related to the project.

Data reconciliation between the source and Target for the different subject areas.

Support and maintenance of all the BO applications like fixing the bugs and incidents.

Involved in Unit Testing and System integration Testing of Universe and Reports.

Supporting UAT from Offshore

Handling change requests and minor enhancements.

Environment: Business Objects 6.5.1, SQL DTS and SQL Server 2000

Project #2

Sr.Software Engineer Dec’2004 to Jun’2005

Client: British Telecommunications, UK (through Tata Consultancy Services)

Project Name: SAJ R2-13 MIS

Team Size: 29

Responsibilities:

Design and build the universe.

Formatted the Reports as per the Users requirements using all the facilities in Business Objects and Web Intelligence.

Involved in installation, deployment, configuration and administration of Business Objects using Apache and tomcat as web/app servers.

Involved in customizing the registry editor to accommodate the large LOV (list of values) & for troubleshooting, bug fixing.

Responsible for setting up the Users/Groups, Database connections, assigning privileges to the Users using Supervisor.

Installed & configured BCA Scheduler & Publisher.

Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.

Created aggregate aware tables at the database level & derived tables with prompts at the universe level to create various levels of pre-aggregated measures.

Responsible for overseeing the Detail Design documents related to the project.

Involved in training on the BO for development resources.

Data reconciliation between the source and Target for the different subject areas.

Involved in Unit testing and System Integration testing.

Environment: Business Objects 6.5.1, Web Intelligence 6.5.1, OWB, Apache/Tomcat and Oracle 9i

Project #1

Software Engineer at Sanghi Textiles Ltd, Hyderabad

Dec’2002 to Nov’2004

Project Name: In-house Projects (Production & Material Information System (PMIS), STL Marketing & Sales Information System, Personnel Information System and Inventory Control System)

Team Size: 3

Responsibilities:

Involved in the Designing and Building of Universes, Classes and objects for management information system.

Interacted with the business users to understand their requirements and documented the scope and specifications of module.

Developed more than 20 reports for all modules and some reports are extremely complicated and go against multiple data providers.

Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.

Created and managed the Groups & Users.

Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Responsible for overseeing the Quality procedures related to the project.

Involved in training the end users for production support.

Environment: Business Objects 5.1.4 and Oracle 8.0



Contact this candidate