PROFESSIONAL SUMMARY:

• 10 years of experience in development, design, support in Microsoft SQL Server BI Tools (SSIS, SSRS, and SSAS), SQL Server and MicroStrategy.
• Experience gathering user requirements and translating them into technical and system specifications.
• Extensive experience as a solution architect for business information systems, focusing on database architecture, data modeling, data analysis, software design, programming and application integration.
• Experience in development, design, support in MS SQL Server BI Tools (SSIS, SSRS, SSAS) and SQL Server 2005/2008/2008 R2/2012/2014
• Versatile in working with SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS)
• Extensive experience MicroStrategy Business Intelligence Suite 9.x/8.x (Intelligence Server, Administrator, Architect, Desktop, Web, Visual Insight, OLAP Services, Report Services, Dashboard, Distribution Services, Mobile, Narrowcast Server, MicroStrategy Office, Object Manager, Enterprise Manager, Command Manager and Integrity Manager).
• Extensively worked in creating and integrating MicroStrategy Reports, Dashboards and objects (Attributes, Facts, Hierarchies, Intelligent Cubes, Filters, Metrics and Prompts with the Data warehouse.
• Created complex reports in MicroStrategy desktop and MicroStrategy Web using features like Templates, Filters, Custom groups and Consolidations etc.
• Created Data Mart Reports using Complex Filters and Compound Metrics.
• Worked with Object manager to move the objects between different environments.
• Worked on MicroStrategy Administration which includes Intelligence Server Administration, Memory settings configuration, performance tuning and VLDB settings.
• Experience in designing Logical and Physical Modeling using ERWIN.
• Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers and User Defined Functions.
• Experience using SQL Server Profiler and SQL Server Database Engine Tuning Advisor for performance tuning of the slow running queries.
• Familiar with OLAP cubes and fact table, star and snowflake schemas
• Experience in Building Multidimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.
• Experience in writing Multidimensional eXpressions (MDX) and Data Analysis eXpressions (DAX)
• Strong experience in design and construction of data marts, data views and data mining
• Experience in Migration of DTS 2000 to SSIS 2008 Packages.
• Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back - up/recovery, running Database Consistency Checks using DBCC.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle 9i/10g, DB2, Sybase, MySQL, MS-Access

BI and ETL Tools: MSBI (SSIS, SSRS, SSAS), Import & Export Wizard, DTS 2000, Power BIMicroStrategy 8.0/9.0/9.2.1/9.3.1/9.4.1 (Administrator, Architect, Intelligence Server, Desktop, Narrowcast, Web and Report Services)

Languages: C#.NET, VB.NET, ASP.NET, HTML, JavaScript

Other Tools: SQL Server Profiler, SQL Server Database Engine Tuning Advisor, ERWIN, Microsoft Visio, Microsoft TFS, Tortoise SVN, Autosys, Tidal

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Sr. BI Developer

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development
• Involved in Design of Snowflake schema data model for the Data Warehouse.
• Mentoring junior developers for implementing design approaches in SSIS for implementing solutions.
• Developed SSRS Reports with backend SQL Server objects.
• Deploying MSBI projects into SSISDB database in PROD environments.
• Developed Power BI reports and used DAX queries.

Environment: SSIS, SSRS, SQL Server 2014, DAX, Power BI, JIRA, Tortoise SVN

Confidential, Fort Mill, SC

Sr. BI Developer

Responsibilities:

• Involved in requirement gathering, Analyze and understand the business requirements for report and dashboard development.
• Experience as a Microstrategy Architect.
• Developed Schema objects like Attributes, Facts, Transformation, tables and logical views.
• Developed Public Objects like Metrics, Filters, prompts, Custom groups, I-Cubes, logical views, tables, Templates, Reports and dashboards.
• Developed OLAP Services like Intelligent Cubes, View filters, derived metrics and published I-cubes using Incremental fetch functionality for specific periods for report datasets and Dashboards.
• Created various quarterly dashboard documents for Citi optima Risk management business users with the multiple panel stacks, selectors, thresholds, grids and graphs, view filters and advanced formatting (Millions and Billions formatting in same view).
• Extensively developed reports and datasets for dashboards and documents using the intelligent cube.
• Created Documents with various graphs and grids for exporting purpose.
• Preparing unit test cases and performing regression testing for schema and application objects and provided feature/functionality/usage scenarios for Business Users.
• Created prompt answer XML (RSL) and Object ID’s for JSP UI using MicroStrategy SDK for web configuration.
• Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
• Involved in migrating the objects from DEV to UAT/Prod using the Object Manager.

Environment: MicroStrategy 9.4.1 (Desktop, Web, Architect, Administration), MSTR Tools, SDK, Sybase, Oracle 10g, JIRA, Linux 2.6

Confidential, Charlotte, NC

Sr. MicroStrategy and SSIS Developer

Responsibilities:

• Responsible for the implementation, support of MicroStrategy project by managing all aspects of SDLC.
• Experience as a MicroStrategy Architect.
• Successfully implemented MicroStrategy upgrades from v8.1 to v9.2
• Created various complex reports, exception reports, Dashboards, Scorecards and Documents on financial data such as Working Capital Dashboard as well non - financial data
• Extensively used consolidations, custom groups to meet the reporting needs which cannot be supported by data model.
• Used advanced filter like pass through functions to achieve desired report data.
• Created Adaptive Metrics for exceptional Reports.
• Developed Intelligent Cubes and view reports based on the Cubes.
• Extensively Used VLDB Properties in order resolve data issues.
• Cleaned up data model by converting M-M relationships to joint child relationships.
• Implemented Slowly Changing Dimensions Type I & II
• Involved in performance tuning of reports by implementing changes in MicroStrategy environments and as well data warehouse.
• Managed and fine-tuned dynamic subscriptions used for financial statements in Narrowcast.
• Successfully implemented Single Sign On using Windows authentication by transition from Standard Authentication.
• Developed Datamart Reports and Freeform SQL Reports
• Used Command Manger to trigger subscription schedules, Updated ETL refresh dates on project home page.
• Developed SSIS Packages and involved bug fixes and deployments.
• Worked actively with Various IT teams in solving issues impacting MicroStrategy Project.
• Customized MicroStrategy Web by adding help file links to each report.
• Worked Extensively with MicroStrategy Support while resolving or identifying Software Defects and make sure we had the right fix for the issue.

Environment: MicroStrategy v8.1.2, MicroStrategy v9.2.0, MicroStrategy v9.2.1m, MicroStrategy v9.3.1, SSIS, XML, XSL, HTML, MS Office 2003/2007, SQL Server 2008

Confidential, Boston, MA

MicroStrategy & SSIS Developer

Responsibilities:

• Involved in the analysis of the existing MicroStrategy 9.0 Application Objects to support the Fallon Business.
• As per the requirement new metrics, filters etc. were created and modified the existing reports.
• Improved the performance of the existing reports impacted by the new model.
• Created Narrowcast Objects like Information Objects, ISM, Services, etc., to support the new business users.
• Created Report service documents both simple and advanced like drill down and Dashboards for end users to meet their requirements.
• Used Object Manager to move objects across the environments i.e., Development to Production Systems of MicroStrategy Modified Excel Templates for the existing Services.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Implemented SCD Type 1, 2, 3 & 6 by using best practices in SSIS.

Environment: MicroStrategy Desktop 9.0x, MicroStrategy Intelligence Server 9.0x, MicroStrategy Administration 9.0x, MicroStrategy Web 9.0x, XML, XSL, HTML, MS Office 2003, Oracle 10g, SSIS

Confidential, Sacramento, CA

MSBI Developer

Responsibilites:

• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Worked on Type-1 and Type-2 Stored Procedures in DW environment (Kimball Methodology) and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data. This entire process has been done in BIDS.
• Created Stored Procedures, User Defined Functions for databases.
• Developed complex T-SQL code for the application conversions.
• Worked with SSIS to import, export and transform data between the servers.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Writing Stored Procedures, Performance tuning the reports using SQL Profiler and SQL Server Tuning Advisor for SSRS Reports.
• Responsible for subscription of reports with the subscription report wizard.
• Developed Various reports involved in Tabular, Matrix, Ad-hoc, Drill down reports using SSRS.
• Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services.
• Designed OLAP cubes, MDX coding, Data Modeling, Star Schema, and KPI efficiently for Analysis Services for Decision Makers.

Environment: MS SQL Server Management Studio, Oracle 9i, Integration Services, Reporting Services, T-SQL, SQL Profiler