Manager Sales

Location:

Boydton, VA

Posted:

September 17, 2020

Contact this candidate

Resume:

Nagesh

Business Intelligence Manager at ACCO Brands

Need Sponsorship to work (On H1B)

https://www.linkedin.com/in/nageshrojanala/ Mobile: +1-937-***-**** Email: ******.*******@*****.***

Dynamic, result oriented, Proactive Professional with 10 years of experience mainly focused on Microsoft BI, SAP BI & Big Data Analytics, Played various roles such as Developer, Analyst, Lead, Architect & Project Manager in multiple assignments in various (CPG, Retail, Insurance, Service) Industries.

Work Experience includes in various Global Implementations, Application Support, Up- grades/Migration Initiatives in multi country (Canada, Europe, Australia, Mexico, Chile, APAC, and Brazil) and multi time zone assignments.

Solution Architect & Lead E2E Global Implementation/Rollouts using MSBI, SAP BW

3.x/7.x, BI 4.0, Microsoft SQL Server 2008 R2 Suite (SSIS, SSRS & SSAS) tools in the areas of SD, MM, FI, CO, POS, APO (DP, SNP)

Experience in performance tuning in SSIS, error and event handling, precedence constraints, break points, transactions, check points, and logging using SSIS

Strong technical development experience in designing and building end user reports and built OLAP cubes for analysis using Cognos Web-based user interfaces (Cognos Connection, Query Studio, Report Studio, Analysis Studio) and Windows-based interfaces (Framework Manager, Transformer)

High expertise in creating reports using crystal reports and SSRS (ad-hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular and parameterized reports) tabular forms, matrix (cross tab report) form, conditional, list items, charts and sub reports

Strong knowledge in Finance Business Rules, Experience in working with FP&A, Consolidation team in Closing Issues. Fair Knowledge in Consolidation techniques using SAP, non-SAP systems (MS SQL, Hyperion, Essbase and Oracle).

Sound knowledge of OLTP Business Transaction Processes with understanding of SAP FI-GL, FI-AR, AP, CCA, CO-PA, Project Systems, Logistics (SD, MM, PP).

Expertise in ETL/ELT activities like Data Extraction, Data Modeling, loading (Initial/Full/ Delta upload), Info cube/DSO Administration/Proactive House Keeping Activities/Selective Deletions/Achieving/Backup methods. Also, Expert in Scheduling, Monitoring of Process chains, development of Data Marts, APD and Open Hub Services.

Proficient in Data Extraction from SAP R/3 (FI/CO, PS, AA, MM, SD, PP, PM ), SRM, APO, CRM), Flat Files and BW using extraction structures such as LO Cockpit, CO-PA, FI, Generic Extractors & Export Data Sources. Expert in filling of Setup tables, setting up of Initialization Queue, Delta Setup etc., with LO Extractors. Proficient in Data Source Enhancements using ABAP User Exits and BEx variable creation using user exits/CMOD.

Strong experience in Design and Development of BEx Queries using Structures, Cell definitions, Variables, Filters, Exceptions, Conditions, Structures, CKF, RKF, Selections, Formulas, Input enabled Queries, RRI, Broad Casting, Workbooks, Views, Info views, WAD templates etc.

Experience in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/2R2/2012/2014, and Data Transformation Services in SQL Server 2000

Expert in data migration from OLEDB/EXCEL/FLAT file to SQL Server 2000/2005/2008/R2/2012 and other destinations using SSIS, Hands on experience in Table loading techniques for Full table load, Incremental load LAD’s (Late arriving Dimension’s or Early Arriving Fact), Type -1 and Type -2 dimensions

Technology Experience:

OLAP Microsoft BI (SSAS, SSRS), SSAS Tabular, Power Pivot, Power View, Power Map, Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer),Pivot Table, Qlikview, SAP Business Objects Web Intelligence,BW 3.5, 7.X, SAP BPC 7.5/10.0 NW (EPM 10),SAP HANA Sp11 HCP,SAP BWoH, SAP BW/4 HANA

OLTP ( ERP) SAP R/3, ECC 6.0, SAP APO 5.1, 7.0, CRM 7.0 Salesforce.com, SAP Ariba, Movex, BANN, Oracle, Microsoft Dynamics CRM Visualization Tools Microsoft Power BI, Tableau 9.3, 10.0, SAP BEx, Query Designer, BO Advanced Analysis, WAD Designer, Report Designer, Builder SAP BO Suite (Design Studio, Lumira, WEBI & Crystal Reports), Cognos, Power Pivot SSIS, SAP BW, Informatica Power Center 7.x, Ascential Data Stage 7.5, Power ETL Query, SAP HANA SLT, BODS 4.2

Programing/Scripting SQL, Linux, ABAP/4, Python, ‘R’ (Beginner), T-SQL, PL/SQL, MDX, DMX, DAX Other DW/OLAP MS SQL, Oracle DB, Hyperion Planning, Hyperion Financial Manager& Hyperion Essbase & MS BI, SSAS, SSRS, Power BI, Power Pivot, Cognos Cloud Infrastructure Microsoft Azure, Amazon S3, AWS Scheduling, CAB tools SQL Server Agent, SAP Solution manager, Tivoli 8.4 Scheduler, Active Batch MDM Master Data Services (2012,2016)

Quick Employment Summary:

Company Role Experience

1 ACCO Brands Manager Business Intelligence 6 Years Full Time Employee

2 (TT Technologies, SVIT) Sr. Business Intelligence 2 1/2 Years 3 Texas A& M University Graduate Assistant 1 Year

Consulting Experience - B.I. Analyst / Engineer 2 Years Education Summary

Masters of Science from Texas A&M University, Commerce Major: Technology Management

Bachelor of Technology Jawaharlal Nehru Technology University, India Major: Electrical & Electronics Engineering.

Work Summary:

ACCO Brands Corporation

Greater Chicago, IL

Business Intelligence Manager

Mar 2014 – Till Date

With progressive growth in BI team at ACCO from Sr. Analyst /Lead to Manger I was able to successfully lead projects for Kensington computer product group a division of ACCO Brands, Pricing Central Team, Newly acquired business segment Pelican Artline sales project, besides supporting the ACCO Global Data Warehouse sourcing data from different regions and ERP systems of the world’s US (SAP ERP), Canada (Oracle ERP), Europe(Movex),Australia(SAP), Mexico(BANN),Chile(BANN),Brazil(BANN),Columbia(BANN), Japan(Microsoft Dynamics CRM), Singapore/ India /Malaysia (Microsoft Dynamics CRM) Global data for strategic reporting of Sales, Customer and Product Profitability, Global Spend, Point of Sales/Open orders, Pricing, Marketing also legacy ACCO SAP and Cognos systems, Building strategic and Operational reports for Customer service, Direct & Indirect business, Customer service, Finance,Supply Chain, Point of Sales/Open orders, Pricing & Marketing teams. Current internal I.T. Project: Rolling out New Azure servers set up infrastructure 2016 SQL Server and perform data migration (Data, reports, cubes, Vision control code migration) from on premise. SAP Build: ACCO Brands North America segment is currently being transitioning from Oracle ERP to SAP as part of the reporting team I am being actively involved in requirement gathering/Design and execution of reports for Order Management, POS, APO & SNP systems and Installing B.I. Contents for Transportation & Warehouse Management Systems

Act as a primary point of contact for providing business process solutions to Supply chain, Pricing, E-Commence (D2C), Service, B2B, Indirect business teams

Leading MSBI and SAP BW operational teams in day to day bug fixes & Enhancements

Solving business problems by designing and developing many B.I. Solutions

Providing data driven solutions for Supply chain, Pricing, E-Commence, Service, B2B,

&indirect business

Providing global customer and product data from different regions and create reports for C level executives (Top 10 Profitable customers and products)

Responsible to interface all levels of organization and work with across matrix on design and implement of enterprise global data warehouse

Provide reports for ACCO brands buyers which helps them to calculate/ retrieve the inventory-on water/shipment information

Single point of contact for strategic analysis team and ACCO - sales/purchasing/sales/finance teams

Pull data from different ACCO vendors which contains the forecasting, container, fright information which helps the supply chain higher management to track inventory levels Upgrade home grown Enterprise Data Warehouse from on premise to Azure cloud with IaaS Platform

Create SQL Server databases from the ground up determine business requirements, create logical models, build physical models, and plan system architecture.

Design, develop and support SSIS packages, SSRS reports, review database design, code written by other database, business intelligence and software engineers

Kensington Cognos discontinuation as a team lead successfully lead in discontinuation of Kensington Cognos legacy systems and moved about 89 reports redesign into SSRS from Cognos also training users on new tools and supporting thereafter on a day to basis

Providing new reports for the Pricing Central Team for annual price adjustments of Indirect and Direct customers and training the team on building own reports also migrating the old access database to SQL Server and support.

Created Sales and Inventory solutions for APAC (Malaysia /japan) Finance, Sales and Supply chain team can get information of the current day to day sales and inventory levels

prioritize and execute tasks in fast paced environment be proactive, responsible and flexible

Created business centric KPIs such as NetSales, Gross Sales, PBT, Volume, Net Income

Work with Marketing product managers to provide reports by product by region gross/net trade sales for product to determine the product profitability TT-Technology Inc.

New York, NY

Sep 1 2012 – Mar 17 2014

Client 1) MetLife Investments, Morristown, NJ

Business Intelligence Analyst

Louisville Gas and Electric Company (LG&E-KU) is a regulated electric and natural gas utility, based in Louisville, Kentucky, serving Louisville and 16 surrounding counties. As part of IT Projects and Support/Development team developed reports for the new Asset & Resource Management (ARM) system which is previously part of Work Management System (WMS).

As part of the IT Support and Development team developed several SSIS packages and Reports

Migrated reports from the old Work Management System to the new Asset and Resource management system environment using SSRS and integrated these reports to the new ARM system

Migrated data from the old oracle system to the new system mostly for the first load or initial load loads and some packages are of Incremental load

Created Interfaces for the ARM system in order the data to be flown fluently in the oracle system from the front end application

Mapping the old system tables, columns with respective to the new system tables and columns and check where the data is having data integrity and maintained with consistency

Develop some custom reports in the ARM application

Set up the SSRS environment (Report Server, Report manager) by installing Test and Prod environment for testing and deploying reports

Change the existing Oracle packages to be compatible to the new system tables and schemas

Developed 6 new reports by gathering requirement from business

Changed dataset for the old reports in order to work on the new system

Worked as SQL Developer developing complex oracle packages for the new ARM system for the new ssrs reports

Configured Share Point 2013 for SSRS 2012 reports by installing add on in order to run the reports which provides secured data sets and shared security

Moved the old code reports, packages from Visual source safe to Team Foundation Server

Set Subscriptions on report server to deliver reports on daily weekly and monthly basis to email and shared folders.

Got trained in QlikView and Converted few SSRS Reports into a QlikView Dashboard. Environment: SSDT 2012(SSIS, SSRS, SSAS), Windows 7, Work Management System (WMS), Assert and Resource Management(ARM), Microsoft Outlook, Cisco Jabber, SSIS, SSRS, T- SQL, PL/SQL, Toad for Oracle, Team Foundation Server, Visual Source safe (VSS),Microsoft Office, Cisco Web Meeting, Microsoft Visual Studio 2010, Oracle 11g, Power Pivot For Excel, QlikView, SQL Server 2012

Client 3) Micron Technology Inc., Boise, Idaho

Business Intelligence Developer

For more than 30 years, Micron’s teams of dreamers, visionaries, and scientists have redefined innovation designing and building some of the world’s most advanced memory and semiconductor technologies.

As a BI Developer I was responsible for ETL daily loads with major transformations, migration of DataStage Jobs to SSIS Packages, conversion of Cognos reports and power cubes to SSRS reports and SSAS cubes, besides performing L3 Operational support for BCM Team (Business Change Management).

Worked in team of Reporting Analytics & Data warehouse (RADW) – Operations Support & Data stage to SSIS migration Project

As a L3 Operational support performing operational activities as per SLA

Supported several cubes such as CTM (Capable to Match), SNP(Supply Network Planning),DP(Demand Planning), GATP(Global Available to Promise), Global Inventory, cubes as part of the L3 Operational support

By the process of Clear quest troubleshooting, enhance, debug databases and support customers

Trouble shoot SSAS cubes, SSRS Reports, DataStage Jobs, SSIS Packages as part the L3 operations and Enhanced performance of Oracle database by tuning existing code

(packages)

Under take small projects build data marts for FAB, Sales, QA, Purchasing, and Inventory

Create several new Type-1,2,3 (Hybrid Dimension Tables), and loaded several fact table which are used by the end user to create Materialized Views, Reports and SSAS Cubes

Migrated 14 Data marts from DataStage to SSIS which is up to 280 Jobs to SSIS packages.

Coordinate between project manager and off shore team on a daily biases on the project day to day activity

Developed New packages that loads Business Data Repository (BDR) and scheduled jobs daily, weekly and monthly basis

Migrated several DataStage jobs that and scheduled the SSIS packages in Active Batch

As a L3 Operational support performed operational activities using RCQ for trouble shooting and enhance business change as per Clear quest request’s by the customers

Used many custom tools Auto ETL, DAT Manager for editing SSIS packages and configure SSIS packages as per the migration process

Migrated Cognos reports into SSRS reports passing parameters

Trouble shoot SSAS cubes, SSRS Reports, DataStage Jobs, SSIS Packages as part the L3 operations within the specified time, Enhanced performance of Oracle database by tuning existing code (packages)

Environment: SQL Server 2008, Windows XP, Ascential Data Stage 7.5, Microsoft Outlook, Microsoft Communicator, SSIS, SSRS, SSAS, T-SQL, PL/SQL, SQL Developer, DAT Manager, Auto ETL, Sub Version, Microsoft Office, SAP Logon, Active Batch, Microsoft Office Live Meeting, Microsoft Visual Studio 2008, Oracle 10g, Relational Clear Quest SVIT INC

Flushing, NY

July 16 2011 –Aug 30 2012

Client 1) MetLife Bank, Somerset, New Jersey

SQL Server/ BI Developer

MetLife is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries, MetLife is the largest life insurer in the United States and serves 90 of the largest Fortune 500 companies. I was involved in Mortgage Information System (MIS) project which is a historical data warehouse which provides financial as well as property, borrower and other non-financial data for MetLife’s mortgage portfolio. It also provides monthly analytics such as commercial mortgage market valuations and income projections. Besides reporting, MIS also serves as an ODS, supporting operational processes such as Market Value determination and Income Projection, also involved in developing reports on MIS Data ware house in addition to migrating MetLife Bank Actuate reports on to SSRS 2005/2008 reports

The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS)

Developed SSIS Package using MS SQL Server Integration Services to load last 4 days of data from Oracle into SQL Server database to store consistent and durable data

Built new SSIS Packages to load incremental data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files

Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages. Extensively worked on mappings, incremental data loading, and SSIS transformations

Designed & developed several SSIS packages for the daily, Hourly, Weekly & Monthly Loads to Mortgage Information System (MIS)

Migrated and Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports

Developed complex reports in SSRS 2005 with many work around for reports according to the business requirements

Involved in creating cubes, reports for the new MLB data warehouse (MetLife Bank) using SQL Server Analysis Services (SSAS)

Designed Common Table Expressions (CTEs), table variables, temp tables, which makes a reusable expression part of a query

Performed code optimization and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks Environment: SQL Server 2005, SSIS, SSRS, Actuate Reporting,.Net, T-SQL, Windows XP, UNIX, Visual Studio, IBM Lotus, IBM Same time, Borland Star Team, Compare IT, Performance Point Server, MDX, Microsoft Office, Snag IT 10, Share point server

Contact this candidate