Nagendra Mukkamalla

585-***-****

acuyei@r.postjobfree.com

BI Technical Lead

Professional Summary:

Having 9+ Years of experience in the areas of analysis, design and development of Business Intelligence solution using Microsoft BI suite (SSAS, SSIS and SSRS) and Tableau (Desktop & Server) tools in Data warehousing, Client Server Technologies and Web-based Applications.

Experience in Data Extraction, Transform & Load (ETL) development using SQL Server Integration Services (SSIS 2008/2012).

Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).

Involved designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

Experienced in designing and developing SSRS 2012 reports using data from SSAS Cubes and Relational database data sources.

Experience in Performance Point Server 2010. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts with PPS.

Developed Stored Procedures, User Defined Functions and SQL scripts for automation tasks.

Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.

Hands on experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages

Having excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Worked with business partners to define analysis requirements. Guide them through the BI delivery process and layout the business and application architecture road map.

Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization according to the end user requirement.

Experience in various reporting tools like Report Builder, Report Designer and Performance point service designer.

Technical Skills:

Database : SQL SERVER 2008 R2/2012, Oracle 10g

BI Tools : Microsoft SQL Server data tools, SQL server BID Studio, SQL Server

Management Studio 2012/2008, SharePoint Server 2010, Performance

Point Server 2010, Tableau 8.x (Desktop/Sever/Reader), Business Objects,

MS SQL Server Business Intelligence Suite (SSAS, SSIS and SSRS)

ETL Tools : SQL Server Integration Services (SSIS), Tableau Extracts

Visualization / Reporting Tools : Tableau Desktop 8.0, SQL Server Reporting Services (SSRS), Business

Objects Crystal Reports, Report Builder, Report Designer

Operating Systems : Windows server 2003/2008/2012

Programming Languages : Visual Basic, C#, T-SQL, Windows Power Shell, MDX, C,

HTML, SQL, PL/SQL and XML

Qualifications:

Bachelor of Engg from Jawaharlal Nehru Technological University.

Professional Memberships / Certifications:

Professional Society / Certification

Member Since / Date Certified

Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Sep 2014

Exam 70-462: Administering Microsoft SQL Server 2012 Databases

July 2014

Exam 70-461: Querying Microsoft SQL Server 2012

Apr 2014

FTC Certification in Business Domain Academy: Wholesale Banking Products and Services

Aug 2013

FTC Certification in Business Domain Academy: Foundation Certificate in Banking

Mar 2013

Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

Mar 2009

Achievements:

Received highest Customer Satisfaction Index (CSI) of 97.1% from the customers.

Attained Microsoft Certified Solutions Associate (MCSA).

Professional Experience:

Xerox, Webster, NY Feb’ 2015 to Present

BI Technical Lead

Managed Print Services (MPS) Business Intelligence

The Xerox Managed Print Services (MPS) Suite is made up of over 30 software applications, with components both-in cloud and installed onsite in customer environments. The Suite enables the global Xerox MPS business handling millions of transactions per day for thousands of customers worldwide.

The TCS team is responsible to build a new Business Intelligence platform to get faster answers to business questions, get key business metrics reports on-demand basis for users and get insight into customer behaviour. In addition, TCS team is responsible to create Managed Print Services (MPS) Dashboards to give the better visibility for decision makers at all levels the ability to aggregate and drill in to key contract metrics that drive business performance.

Responsibilities

Design SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Design Dimensional model by analyzing all the requirements from the clients for the different source systems.

Extract data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Assist in production OLAP cubes and writing queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)

Involved in creation/review of functional requirement specifications and supporting documents for business systems.

Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.

Finding the gaps between different modules of the system and discussing the gaps with the functional personal.

Schedule the packages to keep extracting the data from OLTP at specific time intervals.

Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization according to the end user requirement.

Created various Tableau Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

Mentored business power users to create reports/dashboards using tableau desktop.

Environment: Microsoft SQL Server 2012 Integration Services, Analysis services and Reporting Services, Performance point server, Team Foundation server, Tableau Desktop 8.0, Microsoft Windows Server 2012, Microsoft SQL Server 2012.

Xerox Corporation, Webster, New York May’ 2014 to Jan’ 2015

Senior BI Developer

Global Supply Chain Business Intelligence

The Global Supply Chain (GSC) organization of Xerox manages the multiple sources of equipment and piece part inventory data. The individual teams under this group GSCB, XE-OMAF, OTC, OCF, NCTH and ACS need reports for analysis and decision making. GSC BI application is to mitigate the complexity by providing a single source instead of multiple sources, cleansed one stop integrated data warehouse that is flexible enough to accommodate new changes and scalable enough to efficiently cater to the growing user community. GSC BI application provides the flexibility for the Xerox business users to take key management decisions for the improvement of their business.

Responsibilities:

Gather the requirements from the business users for the different source systems.

Responsible for ETL Design and come up with Dimensional model after analyzing all the systems together.

Estimate the effort required to develop the components.

Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Designed current database by adding tables, relationships, creating stored procedures, views.

Created and deployed cubes using star and snowflake schema. Performed and worked with dimensions, measures, generating KPI, MDX queries.

Created SSIS Packages for performing ETL operations from the external source.

Generated canned Reports/Dashboards for Business users by using SQL Server Reporting Services.

Performance tuning of SQL queries and stored procedures

Proficiency and expertise in SQL Server database Backup/Recovery and OLAP cube replication.

Worked closely with business to enhance functionality of Business Intelligence platform to implement various client requirements.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2012 Reporting Services, Integration Services and Analysis services, Performance Point Server 2010, Team Foundation server, Microsoft Windows Server 2008 R2.

Wells Fargo Capital Finance, Edison, New Jersey Nov’ 2011 - April’ 2014

Senior Business Intelligence developer

WFCF CHOICE Business Intelligence Reporting

Well Fargo Capital Finance provides receivables managements and invoice discounting services to a wide variety of clients, from small to medium enterprises to billion dollar organizations.

The Nova Commercial Services / Factoring system product of William Stucky & Associates, which is named as CHOICE, is the receivable management system of Wells Fargo. Wells Fargo Capital Finance provides business-factoring services for clients in US and Europe.

Responsibilities

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server 2008 using SSAS, SSIS, SSRS.

Used transformations like Look Up, Derive Column, Conditional Split, Aggregate, Row Count, and sort and execute SQL Task to load data into Data Warehouse.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experienced in SDLC life cycle for Design, Development and Staging phases of the project’s with support of Data-Flow, Process Models, and E-R Diagrams.

Maintained log information in Text file to tracking Errors and recording package execution status. Created Configurations, Checkpoints and Breakpoints.

Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.

Understood the existing ETL and relational database framework and Scheduled Packages using SQL Server Agent Jobs.

Perform Preventive maintenance activities like causal analysis, restructuring program codes, data problems resolution and performance tuning.

Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.

Environment: Microsoft SQL Server 2008, SQL Server 2008 Integration Services, Analysis Services and Reporting services, SQL Server 2008 Management Studio, Performance point services dashboard designer and Team Foundation Server, Microsoft Windows Server 2003/2008 R2.

Wells Fargo Capital Finance, Edison, NJ Jan’ 2010 – Oct’ 2011

Business Intelligence Reports Developer

WFCF LUCAS Business Intelligence Reporting

LUCAS (Loan Underwriting and Collateral Analysis System) is used by Capital Finance to store, track, maintain and administer asset-based loans. Asset-based loans are a commercial loan which collateral is usually the Client's inventory and/or accounts receivable. LUCAS can calculate a client’s daily borrowing availability based on a number of criteria (usually how much collateral has been submitted). Borrowing decisions are made based on the most current collateral information.

Responsibilities

Created numerous ad-hoc reports for daily needs regarding Client and Customer financial standings.

Expert in creating various types of reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) on Relational databases.

Designed different project solutions to handle wide array of reporting needs from different aspects.

Perform Preventive maintenance activities like causal analysis, restructuring program codes, data problems resolution and performance tuning.

Provide clear instructions to promote reports to UAT and PROD.

Coordinating with a Project Manager and/or a Business Analysts to resolve issues and collect specifications for developing new reports.

Publish weekly Status reports, Minutes of Meeting and Update Project documents.

Environment: Microsoft SQL Server 2008, SQL Server 2008 Reporting Services, SQL Server BID Studio 2008, SQL Server 2008 Management Studio and SAP BO crystal reports, Microsoft Windows Server 2003.

KPMG, India Apr’ 2007 – Dec’ 2009

Application Developer

KPMG Steady State Application Support

The Account Research Online application provides the necessary information related to accounting/audit/tax/advisory etc. as collections pertaining to Geographic regions. Every day the Business team will upload new content from their end (Content Management System) and from our end we have to make sure that content gets updated in all the sites – AMR, EMA and ASPAC. Hence, the associates of KPMG would have access to the updated information. In order to access this content any non KPMG user has to pay a certain amount.

Responsibilities

Provide technical support for production cycles jobs and troubleshoots issues.

Discuss all production support aspects with application development management.

Interact with infrastructure, release management, change management, QA, DBA and application teams.

Provide regular status reports to management on application status and other metrics.

Coordinate escalation and resolution of major service issues.

Report promptly to management and business partners regarding critical outages until resolution.

Understanding the issues, analysing and finding the root cause.

Ensured adherence to all the quality norms followed throughout the project like tracking the life-cycle of a ticket/issue/query through Work Allocation Sheet (WAS), preparing analysis documents for all the issues, logging of review comments in the REVIEW LOG, preparing Minutes of Meeting (MOM) after every weekly call.

Environment: ASP.Net, C#.Net and T-SQL, Microsoft SQL Server 2005, Microsoft Windows Server 2003

Contact this candidate