Naresh

Mobile: (***) *** - ****

ac22ys@r.postjobfree.com

Professional Profile

An experienced and highly motivated IT professional, with 10+ years of experience in analysis, architecture, design, development, testing and support of Business Intelligence products and services in MicroStrategy and Tableau. Hands on experience in development, administration, managing, designing, modeling, and testing of enterprise wide reporting systems. Strong data architecture, business requirement analysis using agile methodologies. Enjoys leading, motivating and being part of a specialized team, bringing strong leadership qualities, equally comfortable working on own initiative. Possesses exemplary technical problem solving and negotiation skills and accustomed to delivering results under considerable pressure, remaining calm and effective and prioritizing wisely.

Professional Skills

Proven experience in IT industry with business analysis, development and implementation of Data warehousing and Database focusing on Requirement Analysis, Development, Testing, Administration and Implementation of BI Solutions in various verticals such as Insurance, Retail, Manufacturing, Pharma, Banking and Healthcare.

8+ years of working experience in MicroStrategy Suite and 3+ years of experience working with Tableau Desktop and Server.

Have been in various roles from developer to Module Lead covering all phases of SDLC including business requirements analysis, design, development and implementation, Testing, On-going support, Maintenance using Waterfall methodologies and Experience in onsite-offshore model and experience in Agile methodology.

Experienced with Sprint Planning, Daily Scrums, Sprint Reviews and Retrospective Meetings, Create the Task Board and Sprint Burndown Chart at the start of every Sprint, Attend all Scrum meetings and continually work with the Team and business to find and implement improvements.

Extensive experience in BI Reporting tool suites such as MicroStrategy 8.x, 9.x, 10.x, Tableau 9.x, 10.x and expertise in playing multiple roles.

Strong experience in documenting BRD, TDD and implementing Proof of Concepts to valuable clients like AMAZON, AACC.

Good experience in ETL using Informatica Power Center. Expertise in developing Mappings and Mapplets, Sessions, Workflows and Tasks using Informatica Designer, Workflow Manager and Workflow Monitor

Worked with Informatica transformations such as source qualifier, joiner, connected/unconnected lookups, expressions, routers, aggregators, update strategy, filters, normalizers, sequence generators etc

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and have been working with various data sources such as Oracle, SQL Server, Hive, Cassandra, Amazon Red shift, Green plum, ODBC and flat file sources.

Expertise in Creating Schema Objects (attributes, facts, Hierarchies, Transformations), Public Objects(Filters, Prompts, Metrics, Custom Groups, Consolidations, Drill Maps, Templates), designing & creating Report Service Documents, Intelligent Cubes and I Cube reports.

Worked on modifying the context of data calculations using Level Metrics (MicroStrategy), LOD’s (Tableau) and Microstrategy Pass through functions (Apply Simple, Apply Comp).

Extensive Experience on Designing and development of Dynamic Dashboards and Mobile Dashboards in MicroStrategy &Tableau which helps in better understanding of the Business trends.

Well Experienced in Debugging, Optimizing the Dashboards/Mobile Dashboards/ Reports and Performance Tuning of Dashboards / Reports in Microstrategy and Tableau and effectively worked with VLDB settings and report tuning techniques in MicroStrategy to meet client requirements and applying best test approaches before delivering the product.

Worked on Various Microstrategy components like Object Manager, Command Manager, Integrity Manager and System Manager and Tableau components like Tableau Server and Tableau Mobile.

Good experience in Users/User Groups, Security Filters, Security Roles and Project management in Microstrategy/Tableau.

Worked with Advance analysis Actions, Calculated Fields, Parameters, Sets, groups, Hierarchies, Bins, Filters to create detail level summary worksheets/dashboards and Defined best practices for Tableau report development and Expertise in Joins, Data Blending, Aggregations, Forecasting, Trend lines, formatting and Dual Axis in Tableau.

Created Table calculations with LOOKUP, WINDOWSUM, RUNNINGSUM, DATE, STRING functions in Tableau.

Good in report developing, testing, deploying reporting solutions, scheduling the reports in Microstrategy/Tableau Server and manage the application’s users, groups, and integrations with active directory.

Data Visualizations Design & Implementation, Reports and Dashboards Design & Development, Universe Design & Development, Performance Management, Installation, Configuration &Maintenance of Reporting Environments, Data Warehouse/Data Mart Design & Implementation, Data Modeling and Business Analysis.

Self-motivated team player with good communication, Analytical, Problem Solving and Interpersonal skills to communicate effectively at all levels of the development process and Flexibility to adapt changing priorities and meet deadlines as per the schedules and solve client/customer related technical issues.

Core Competencies - Functional:

Solution Architecture

Interfacing with teams for business requirements gathering, conducting system analysis and finalizing techno-functional specifications. Creating high level design (HLD) documents for the project.

Translating the client's business requirements into specific system, application or process designs.

Working with client personnel & executives to identify functional requirements.

Software Development

Handling the design, development, testing, troubleshooting and debugging of the software.

Providing post-implementation, application maintenance and enhancement support to the client with regard to the product/ software application. Interfacing with vendor/s for technical support.

Setting up and driving process, documentation and quality standards for all phases of the SDLC.

Technical Skills

BI Tools: MicroStrategy 8.x/9.x/10.x, Tableau Desktop 8.x, 9.x, 10.x, Tableau Server.

BI Mobile: MicroStrategy Mobile (I Phone, I Pad and Android devices), Tableau Mobile.

Databases: Oracle 9i/10g/11g, Big data, AWS, SQL Server 2000/2005/2008.

Query Tools: TOAD, Teradata SQL Assistant, Rapid SQL, PL/SQL Developer, Oracle SQL Developer.

Modeling Tools: MS VISIO, Erwin.

ETL Tools: Informatica Power Center, Talend

Programming

Languages: C, C++, Core Java.

Operating Systems: Windows, UNIX/LINUX.

PROFESSIONAL EXPERIENCE

Architect / BI Lead

CUMMINS Inc, Columbus, Indiana (Apr 2017 – Till Date).

Led multiple teams for new initiatives, enhancements and support of BI in Corporate Office of Technology.

Interacted with business stakeholders to understand their requirements, analyzing the available data to build Microstrategy/Tableau Dashboards.

Reverse engineered and optimized reports and dashboards.

Created Microstrategy Mobile dashboards (iPad) and worked on optimizing performance of mobiles dashboards and security and extensively worked on I Cubes.

Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.

Extensively worked in creating and integrating MicroStrategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.).

Expertise in creating Security Roles, Security Filters, Microstrategy User Groups and Users, assigning security roles to Users and Groups.

Also worked as ETL support contact supporting Informatica mappings to load data into data warehouse.

Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment and worked with command manager scripts for cube publishing, security filters creation etc.

Developed Tableau workbooks from multiple data sources using Data Blending.

Performed ETL Transformations using Informatica

Created Auditing reports for various purposes like User activity, Query performance.

Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, Agents performance, strength & weakness for the client at a glance, also interact with data as necessary

Debugged several data issues using Informatica Mappings & Sessions.

Used Tableau Data Extracts for improving Performance and giving flexibility for different users in using worksheets.

Administered user, user groups, and scheduled instances for reports in Microstrategy/Tableau.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Created report schedules, data connections, projects, groups in Tableau server.

Defined best practices for Tableau report development and dashboards development.

Training the users on Tableau / Microstrategy.

Installation and Configuration of Microstrategy 9.x & 10.x and Tableau tool suite on AWS.

Configuring I-Server, Project and Web Preferences Settings, Database connectivity, Migrating Metadata, Project Duplication Activity.

Environment: Microstrategy 10.x& 9.x, Informatica 9.6, Tableau 9.1, AWS, Oracle 11g, IBM DB2 9.7, SQL Server 2008, Windows.

Architect / Sr. Consultant - Business Intelligence

CITI, NewYork, NY (Jan 2015 – Mar 2017).

Worked with business analysts to baseline the reporting requirements.

Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer.

Worked with data architects on data needed for testing the reports and dashboards.

Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.

Extensively used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.

Created drill maps for end users to drill down and recover data.

Extensively worked with Microstrategy Intelligence Server, MicroStrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.

Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

Involved in Informatica development besides MicroStrategy role

Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.

Designed and Developed Microstrategy Dashboards using customized Widgets.

Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.

Extensively used report services to create dashboards to create summary level reports using multiple datasets.

Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.

Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.

Environment: Microstrategy 9.3.1 & 9.4.1, Informatica, Oracle 11g, SQL Server 2008, Main Frames, Windows.

Sr. Software Engineer

Pacific Life, Newport Beach, CA. (Feb 2014 – Jan 2015).

Designed and Developed Reporting platform for Product Sales analysis system and Market Risk space.

Led a global team from India for Development and ensured timely deliverables.

Reconciled the reporting to a more strategic and transparent platform and met Regulators requirements.

Synthesized the data and developed Business Objects reports for Executives and visualizations/reports using Tableau.

Hands-on development assisting users in creating Tableau worksheets and visualizations.

Interacted with Users and suggested best solutions for having a robust reporting platform.

Provided support for Users creating report schedules, data connections, projects and groups in Tableau server.

Maintained Tableau repository by creating backups using Tabadmin and Tabcmd commands.

Automated scheduling of reports using control-m and improvised ad-hoc capability for Users.

Environment: Tableau, SAP BO BI, Business Objects XI 3.1, Oracle 11g, PL/SQL Developer, Windows.

Sr. Software Engineer

DICK’S Sporting Goods, Kansas, US (June 2013 – Feb 2014)

Worked on Migration from SAP BO to MicroStrategy.

Involved in Analysis of requirements and preparing the Technical Design Documents.

Understanding Business Logic and Designing the Report/Document as per Technical Design Documents and performing data validation for Reports.

Involved in creation of Schema Objects like (Attributes, Facts, Transformations and Hierarchies).

Developing the objects like Reports, Documents in MicroStrategy.

Developed Interactive Dashboards for Business Analysis.

Created Various Public objects like (Filters, Prompts, Metrics, Consolidations, Dashboards and I cubes).

Optimized Query Performance by using VLDB settings at report level.

Worked on All OLAP Services (Dynamic aggregation, Derived metric, View filter, Derived elements & I Cubes).

Performance tuning for various Reports.

Involved on experience working with Object manager to move Objects from Development to QA environment.

Environment: MicroStrategy 9.x, SAP BO BI, Business Objects XI 3.1, Oracle 11g, PL/SQL Developer, Windows.

Sr. Software Engineer – Microstrategy Developer

Target, India (Sep 2011 – Jun 2013)

Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the MicroStrategy Desktop and MicroStrategy Web interfaces.

Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).

Expertise in creating logical data models by recognizing the source tables and columns, to build Attributes Facts, Hierarchies and Relationships that are necessary to create a MicroStrategy project.

Developed multiple complex reports using Derived metrics, Compound metrics and Filter in a metric to meet the requirements.

Created new Facts, Attributes and attribute form expressions and Hierarchies as needed in the project.

Developed Transformations (table based, formula based) to be used for comparative analysis like claims this year to last year (year to date and month to date).

Extensively created Custom groups and Consolidations to meet the requirements.

Optimized the Intelligence Server for better performance.

Created Dynamic dashboards with visual insight to improve marketing by product, customer, geographic and promotion analysis.

Hands on experience in Performance Tuning of the tool and also modifying VLDB properties to achieve maximum performance.

Used Narrowcast Server to create various Services, Information Objects, Imported Objects and Static Subscriptions and used ETL sync mechanism to send reports based on data load completion.

Created narrowcast services to email /send to a directory either report service documents in PDF or excel files.

Environment: MicroStrategy 9.x, SQL Server 2005, Oracle, Windows.

Software Engineer – Tableau Developer

CIGNA, India (Apr 2010 – Aug 2011)

Worked as Tableau developer in standardizing Tableau for shared service deployment.

Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.

Extensively used data blending, embed functionalities in Tableau.

Installed Tableau Server in Dev, QA, UAT and Prod environments.

Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Created report schedules, data connections, projects, groups in Tableau server.

Created scripts on windows task scheduler for auto sync of users from Active Directory groups.

Defined and created procedures to install Tableau desktop in silent mode.

Defined best practices for Tableau report development.

Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues

Environment: Microstrategy 9.x, Tableau, Oracle 11g, MS SQL Server, Windows.

Software Engineer

MAXIMUS INC, India (Jan 2009 – March 2010)

Understanding the client requirements by coordinating with the onsite technical team.

Identified and created schema and application objects like attributes, facts, Hierarchies in Microstrategy Desktop.

Creating different types of Metrics, filters, Prompts, Documents based on client requirements.

Designed Filters to generate Reports in grid and graph mode.

Created Drill maps for the existing reports to define custom drilling options.

Created Consolidations, Custom Groups and Transformations required for reports.

Created Reports using complex Filters and Compound Metrics and Prompts.

Environment: Microstrategy 8x / 9x, Oracle, SQL Server, Windows.

Software Engineer

Baltic, Denmark (Feb 2007– Dec 2008)

Worked on analyzing the systems and gathering the requirements.

Coded the Stored Procedures and functions and well-tuned the SQL in the application.

Involved in writing PL/SQL packages and database triggers

Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.

Database design, E-R diagrams, Logical, Physical layout design using Erwin.

Extensively Involved in Knowledge Transfer for the documentation team for the development activities carried out by our team.

Defining and reviewing the coding standards, besides reviewing the code.

Analyzing the enhancement / support request, estimating effort and providing architectural and technical support to the team, besides developing key components.

Environment: Oracle 9i, SQL Loader, TOAD, Erwin, UNIX and Windows.

Contact this candidate