Manager Sql Server

KAMAL MALLIPUDI

Phone: 248-***-**** Email:******.*************@*****.***

SUMMARY:

Certified in MicroStrategy Advanced Analytics Reporting – 10.412

Almost 9 years of professional experience in implementing Business Intelligence, expertise in Data warehousing, using MicroStrategy and SQL Server and Database Maintenance.

Over 7+ years of development experience in MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web, Narrowcast Server & Mobile).

Comprehensively worked in creating complex reports in MicroStrategy Desktop (using features like Advanced Filters, Prompts, Consolidations and Custom groups) and integrating MicroStrategy reports and Schema objects (Simple And Compound Metrics, Fact Extensions and Hierarchies etc.) with the Data warehouse.

Experience in Microstrategy Architect, Office, Narrowcast, User security & management, Object Manager & designing reports (grid, freeform, drilldown, ad hoc, OLAP cube) and dashboards in Microstrategy7.2.4/8.0.1/8.0.3/8.1.0/8.1.2/9.0,9.2.1,9.3,9.4.1, 10.2

Worked extensively on MicroStrategy mobile for IPad & IPhone on design, architecture and mobile administration.

Strong knowledge in Retail, Health Care Insurance & Technology domains.

Experience in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation and testing.

Extensively worked on delivering reports and business intelligence solutions on the web using Microstrategy Narrowcast Server.

Strong experience in developing dynamic dashboards and scorecards.

Has an extensive knowledge in databases like MS Access, Oracle, DB2, Teradata and MS SQL in Windows environments.

Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 10g /9i/8i/7.x, DB2, NCR TERADATA, SQL Server 2000/7.0/6.5.

Very good knowledge of SQL and created Free-Form SQL reports on Demand.

Coordinated the Onsite-Offshore model of project execution.

Proficient in setting up and upgrading the Metadata Repository, Configuring the Intelligence Server, creating user groups, security filters, roles and privileges.

Participated in designing of Multidimensional Modeling in Microstrategy, regulating Star and Snowflake Schemas.

Excellent communication skills and the ability to work individually as well as in a team environment.

Experience in Dynamic Visualization Dashboards, Advanced Reports/ Data Marts, managing Report Caches and Migrating Projects to Micro Strategy Production server and Archive server after the enhancements are done.

Experience in working with HTML Documents, Report Services and Documents, Clustering, Security Filters, Cache management, Enterprise Manager, Server Connectivity, Freeform SQL Functionality, using different multidimensional modeling techniques as well as different data models.

Extensively involved in the development of scripts, Views, and procedures for extracting the data from different data sources.

TECHNICAL SKILLS:

OLAP Tools MicroStrategy 9 and 10 (Administrator, Architect, Intelligence Server, Desktop, Narrowcast, Dash Boards, Web and Report Services)

Databases Oracle10g/9i/8i/8.0/7.0,MS SQL Server 6.5/7.0/2000/2003. NCR TeradataV2R4/R5, Netezza V4.0, Sybase, MS Access, DB2.

ETL Tools Informatica 5.0/6.0/7.1.2 (Power center, Power Mart), Data Stage 6.0/7.0, SQL Server DTS, Fast Loads, Multi Loads.

Data Modeling Toad, Erwin 4.0/3.5.2, Designer 2000

Web MS FrontPage, HTML, DHTML, JavaScript, VBScript, ASP, JSP, XSL and XML.

Languages C/C++, JAVA, SQL/PLSQL, ASP. Net, Visual Basic

Operating Systems UNIX, Linux, Microsoft Windows 95/98/00/NT/XP, MS-DOS.

PROFESSIONAL EXPERIENCE:

Ashley Furniture, Advance, NC

MicroStrategy Architect

June 2016 – Till date

Responsibilities:

Working on building and maintaining analytical layer and MicroStrategy schema as an Architect.

Creating Logical views in MicroStrategy to support the new requirements.

Responsible for Architectural design changes and enhancements.

Worked on creating Aggregate tables to enhance the response times.

Created lookup tables for the Manufacturing ans Supply chain data.

Involved in gathering business requirements and documenting specifications.

Responsible for understanding Existing SSIS reports and converting them to MicroStrategy reports and Visual Insights.

Fixing existing MicroStrategy Dashboards and schema objects.

Created entity relationship diagrams and multidimensional data models, reports and diagrams for Supply Chain and Purchasing departments.

Demonstrating different features of MicroStrategy 10.2 to the business team to take full advantage of the Software.

Created Dashboards and Visualizations from scratch using MicroStrategy 10.2 Desktop and web.

Consult with stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

Was involved in Performance Optimization to existing reports and report response time was brought down remarkably.

Perform migration activities on the objects from DEV to Stage and Production.

Involved in 10.4 upgrade impact analysis.

Environment: MicroStrategy Tool Suite 10.2, 10.4 (Desktop, Intelligence Server, Web), MS Sql Server, MS Visual Studio ’15, MS Excel

Sanofi Pasteur, Mt Pocono, PA

MicroStrategy Architect

March 2014 – June2016

Responsibilities:

Worked with MicroStrategy Architect to build Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.

Provided logical data modelling to the ETL teams.

Created Attributes, Facts and MicroStrategy logical views as per reporting needs.

Created customized Hierarchies for Drill Maps.

Extensively worked creating Visual Insight Dashboards in 9.4.1 and 10.2, 10.3

Generated and implemented MicroStrategy Transactional Services reports.

Implemented security filters at project level to restrict certain products based on user group assignment.

Implemented Mobile versions of Dashboards and Visualizations for iPad.

Manipulated attribute and attribute forms properties to enforce right table joins.

Kept myself updated about the latest features and changes by attending Microstrategy Symposiums and Webcasts and prepared documentations for the team.

Trained BA's and business users in the latest features like Data Wrangling in Microstrategy 10.

Participated in upgrade analysis while moving to 10, 10.2 and 10.3.

Responsible for development and management of projects with primary focus on providing robust and scalable Business Intelligence solutions to various functions within company.

Created Intelligent Cubes to perform highly interactive analysis by using Dynamic Sourcing, View reports and Derived elements.

Worked closely with various business functions to find opportunities to build new business enhancing reports and to automate existing labor and time intensive critical reports.

Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator.

Performed Administration tasks like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, Installed patches like sever installation and solved customer issues

Designed many Freeform SQL reports by directly querying against the data warehouse.

Extensively worked in both Ad-hoc and Standard Reporting Environments and involved in building reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle.

Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, ESRI maps, documents for summary level reporting with large datasets.

Created Complex filters, prompts, and metrics with advanced qualifications involving Apply Simple & Apply Comparison functions. Created smart metrics with custom subtotals.

Worked extensively on Complex reporting needs which involved creating Consolidations and Custom Groups.

Worked with ETL to implement complex product based transformations.

Highly used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time. Also used OLAP services like Derived metrics, View filters wherever necessary.

Created Database tables and logical views required for MicroStrategy reporting needs.

Created complex metrics involving MTD/YTD Transformations and Level Dimensionality.

Responsible for Unit Testing of the reports.

Involved in migrating the objects from DEV to UAT/Prod using the Object Manager.

Environment: MicroStrategy Tool Suite 9.3.0, 9.4.1, 10.2, 10.3 (Desktop, Intelligence Server, Narrowcast Server, Web, Mobile), Toad, MS Excel, Informatica

General Motors Corporation, Detroit, MI

MicroStrategy Developer

October 2012 – March 2014

Responsibilities:

Identified Source tables and columns from Oracle database to create the necessary Schema in Desktop and Creation of Metadata & Statistic tables.

Involved with creation and usage of few Ad-hoc reports, with a set of pre-tested Application Objects for quick review and analysis of 62 KPI’s detailing based on various segments.

Good experience in creating and optimizing Microstrategy Dynamic dashboards, documents and Visual Insight Analysis.

Generated and implemented MicroStrategy reports by creating projects, attributes, facts, metrics, filters, prompts, templates and drill maps.

Worked with CDM call center reports that provide the summary counts of carryover, applications/quotes received, and applications closed/approved on daily, Week-to-date, Month-to-date and Year-to-date.

Identified the required lookup tables develop Logical and Physical reporting elements for new reports, adhering to current methods and standards

Decent knowledge of Web and Administrative tasks like Assigning Privileges, Job Monitoring, Performance monitoring, User group functionality.

Good Experience in Microstrategy 9.3 features, MS Distribution services, Visual Insight and flash widgets.

Have Decent experience in Microstrategy Narrowcast services, created schedules, publications and Information objects.

Was involved in knowledge transfer and Performance Optimization was done to existing reports and report response time was brought down remarkably.

Performance Optimization was done to existing reports and used Data-mart reporting, VLDB settings for better reporting.

Environment: MicroStrategy Tool Suite 9.2.1,9.3.0 (Desktop, Intelligence Server, Narrowcast Server, Web, Office), Oracle 10g R2, Toad, Data stage 7.5.1, Cognos, MS Access, MS Excel

Ahold USA, Boston, MA

MicroStrategy Consultant

September 2010– August 2012

Responsibilities:

Planning, requirements analysis, design and development of new MicroStrategy projects or enhancements of existing projects.

Interacted with business users extensively in gathering the requirements and translated them into report specifications for the MicroStrategy platform.

Developed multiple reports (Grid, Graph & freeform) for multiple projects.

Worked on Database design of highly complex data transformations including Slowly Changing Dimensions.

Experienced in designing dynamic dashboards using Microstrategy Report Services.

Architected and performed the report development for the MicroStrategy projects by creating facts, attributes, hierarchies, reports, filters, metrics and templates.

Created complex reports using Advanced Prompts, Non- Aggregatable Metrics, Conditional Metrics, Transformation Metrics and Level Metrics.

Written and created SQL views in Teradata database.

Used Object Manager to promote objects from Microstrategy development to QA & production environment.

Created Microstrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.

Architected a number of BI reporting and dashboard solutions

Used functions in MicroStrategy like Apply Simple & Apply Comparison whenever necessary.

Extensively worked on MicroStrategy Administration that includes Intelligence Server administration, configuration of Memory settings, and Performance monitoring.

Implemented Narrowcast services for scheduling reports to business users & analysts.

Experienced in Business Objects report testing & integrity check of universes and migrating reports to MSTR.

Customized reports, Documents and deployed them to MicroStrategy web.

Executed testing of all reports for the final deployment.

Assisted in upgrading the MicroStrategy Platform from 9.0 to 9.2.1.

Environment: MicroStrategy 9.0/9.2.1 (Architect, Agent, Object Manager, WEB, Administrator, Enterprise Manager), Narrowcast Server, Dash Boards, SQL Server, Teradata V2R3, Informatica, Windows NT, Windows 2000 Professional.

Meredith, Des Moines, IA

MicroStrategy Developer

December 2009 – August 2010

Responsibilities:

Involved in collecting the Business Requirements and documenting the specifications.

Played an important role in coordination with the entire team and managing the time estimates for the entire project.

Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository.

Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.

Created complex filters with advanced qualification involving ‘Apply Simple’ and ‘ApplyComparison’ functions.

Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.

Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics.

Gathered requirements from the users and defined KPI’s to build scorecards and dashboards.

Experience in Report Net while creating Microstrategy report.

Extensively used MicroStrategy Report Services to generate Report Documents.

Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.

Worked as a support resource for other related projects and was responsible for re-architecting required changes and checking the report results in QA.

Tested all the reports by running queries against the warehouse using Sql Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.

Responsible documentation and configuration of Enterprise Manager for logging statistics and reporting purposes.

Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.

Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues.

Environment: MicroStrategy 8.2.1/9.0.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Dash Boards, SQL Server, Oracle 9i, SQL Navigator, HTML & DHTML.

Sonata Software Ltd., Bangalore, India / Client: Punjab National Bank, India

Oracle Developer

June 2008 – November 2009

Responsibilities:

Created database objects like Tables, Views and Indexes, Clusters and Sequences.

Identified the Integrity Constraints and developed database triggers.

Creating and maintaining triggers, packages, functions and procedures.

Responsible for developing the online screens.

Performed data imports and exports using the SQL Loader.

Developing Reports using Oracle Reports 2.5.

Analysis of the database for performance issues and conducting detailed tuning activities for improvement.

Involved in performance monitoring and tuning of Oracle database servers.

Wrote procedures to meet ad-hoc requirements to replicate data from one table to another.

Involved in system maintenance.

Performed backup and restoration of system and user databases and involved in scheduling the backups.

Managing the use of disk space, memory and connections.

Environment: Oracle 7.1, Developer 2000, T-SQL, ASP, VB, PL/SQL.

Contact this candidate