SUMMARY

• To acquire a position to utilize my skills and abilities in a resourceful manner that would help in the growth of the organization. I work for while being innovative and flexible thereby reaching the top rung of the ladder.
• 8 years of IT experience in Analysis, Design, Development, Testing and Maintenance of Business Intelligence and Data Warehousing projects using MicroStrategy platform, Informatica, Oracle, Teradata, Sybase and ERWin.
• Expertise in using MicroStrategy 10.x/9.x/8.x/7i/7.x product suite which includes MicroStrategy Desktop, MicroStrategy Intelligence Server, Narrowcast Server, MicroStrategy Architect, Administrator, MicroStrategy Office, MicroStrategy Object Manager and MicroStrategy Command Manager.
• Experienced in data modeling, building Datawarehouse solutions and database architecture.
• Worked on database development in SQL Server environment using SQL/T - SQL, stored procedures, joins, pre-defined and user defined functions, pre-defined and user defined data types.
• Strong skills in Performance Tuning, Query Optimization, Client/Server Connectivity and perform Database Consistency Checks to amplify efficiency of SQL Server.
• Experience in upgrading and administering SQL Server databases.
• Experience with MS SQL Server Integration Services (SSIS), Reporting Services (SSRS), Power BI and Analysis Services (SSAS).
• Experience in developing, monitoring, extracting and transforming data using SSIS Packages.
• Experience in logging, troubleshooting and deploy SSIS packages across environments using configuration files and environment variables in SSIS.
• Developed SSIS ETL packages for incremental and full load of data warehouses and schedules the same for daily and periodical loads.
• Experience with designing, creating, deploying cubes, dimensions, facts, aggregations, KPI’s and using SQL Server Analysis Services (SSAS).
• Well versed in using MDX (Multi Dimensional Expressions) queries to retrieve data from multi-dimensional SSAS Cubes.
• Experience in building Tabular models and writing DAX expressions.
• Practical understanding of Star Schema and Snowflake Schema Methodology.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Metrics, Filters, Prompts etc.) with the data warehouse.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Experience in creating Report Service Documents and Dashboards.
• Very good experience in working with very large databases like Oracle, Sybase, Teradata, SQL Server with MicroStrategy.
• Flexible and Versatile who can adapt to any new environment. Ability to perform well in a group or individually and can cope well in a high intensity work environment.
• Excellent Analytical and Problem Solving Skills.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10.4/9.x (Administrator, Desktop, Intelligence Server, Architect, Web, Narrowcast Server, Distribution Services), Tableau

ETL Tools: Informatica Power Center 8.x/7.x/6.x, Data Stage, SQL Server DTS/SSIS, SSRS, SSAS services.

Databases: Oracle 10g/9i/8i, TeradataV2R6/V2R5, MS SQL Server, Sybase 12

Languages: SQL, PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML

Operating Systems: Windows 98/2000/NT/2003/XP/Vista, UNIX

Office Tools: MS Office, Microsoft Visio

Other Tools: Toad, SQL Assistant, PL/SQL Developer, Aqua Data studio, Interactive SQL.

PROFESSIONAL EXPERIENCE

Confidential, CA

MicroStrategy Developer/Administrator

Responsibilities:

• Gathered the Reporting requirements from business user and created BRD (Business Requirement documents).
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Created the Report Specification document and had it signed off, after suggesting some useful alterations.
• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in MicroStrategy.
• Involved in MicroStrategy upgrade to version 10.
• Used database specific Microstrategy Apply functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
• Designed Hierarchy of Dimensions and Fact Tables in Microstrategy Architect.
• Created Logical Views to accommodate user requirements.
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using I-cubes improved performance of the RS documents significantly.
• Loaded the Intelligent Cubes using Incremental refresh reports.
• Created Scripts to create user, apply security filter and run the cubes in Command Manager.
• Created Dashboards for CCAR Project on projections of future data.
• Used the Object Manager to move the objects from Development to UAT and then to Production Environment in Microstrategy and did project duplications.
• Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Created documents with both Grids and graphs as per user requirements.
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing.
• Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Highly used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.

Environment: MicroStrategy Desktop 10.4/9.4 (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast), Sybase, Informatica Power Center, SQL Server, MS Office and Windows 2000.

Confidential - Jersey City, NJ

MicroStrategy Developer

Responsibilities:

• Worked with business users, development team and management to define needs and crafts user requirements (identifying application and schema objects necessary to meet requirements).
• Created and presented solutions and architecture design to client teams for approval (logical models, star schema or snowflake design, and schema objects configurations; hierarchies, drilling paths).
• Developed Microstrategy schema and application objects, reports, RS documents, dashboards.
• Assisting the team in integrating relational designs and business objects within their metadata and data warehouses.
• Extensively used MicroStrategy Report Services to create Report Documents, Dashboards.
• Tested and validated data by running SQL scripts to ensure continuous accuracy, ease-of-use, and integration with existing resources.
• Performed Microstrategy installations and configurations and troubleshooting ODBC DSN connectivity issues
• Worked with advisory architecture and development teams on guiding the design and development of new Microstrategy design standards, with a focus on enhanced insight capabilities.
• Built Intelligent Cubes and set them up for optimal complex document performance in need of 20,000,000+ records.
• Last but not least, migrated projects across the SDLC.

Environment: Microstrategy v8,v9,0.1,SQL SERVER 2012,Oracle 9g, Report, DB2,MS Access, Teradata, Sybase.

Confidential - Charlotte, NC

Microstrategy Developer/Report Developer

Responsibilities:

• Gathered the Reporting requirements from business user and created BRD (Business Requirement documents) for SDLC process.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary and created Functional and Technical specifications for relevant teams.
• Created TCP (Test case procedures) for the development team and the business user.
• Created Metadata Repository and Statistical tables in the data warehouse using the Configuration Wizard.
• Created Dashboards, reports to Track Key Account Performance trends, Top Payor Accounts, National Benchmark reports and many more.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters and compound Metrics and Prompts.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Created transformations (Table Based and Expression Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Used database specific Microstrategy Apply functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering based upon the business user change request on UAT Testing.
• Involved in Customer Support and Maintenance & Performance Tuning of reports.
• Designed and developed various database objects like tables, views.
• Wisely used various VLDB properties for tuning long running reports.
• Extensive T-SQL programming to build objects such as stored procedures, views tables and functions.
• Extensive performance tuning of T-SQL code and SSIS package.
• Created ETL- SSIS packages to process various files from source to destinations as per guidelines and business rules set by RMS.
• Develop complex SSIS packages using features such as dynamic connection managers, for each loop containers, dynamic expressions, variables, execute SQL tasks etc.
• Develop and deploy SSIS packages across UAT and production servers using configuration files and project deployment models.
• Debug and troubleshoot SSIS package failures using breakpoints and checkpoints.
• Work with testing teams to resolve any bugs and defects detected during test cycles.
• Work with operations team to migrate SQL server to Azure.

Environment: MicroStrategy Desktop 9.2/9.4 (Administrator, Desktop, Web, Intelligence Server, Narrowcast Server), Teradata, UNIX, MS Office and Windows, T-SQl, SSIS, SSRS, SSAS, UAT, Azure, SQL Server, ETL, Data Warehouse

Confidential - Phoenix, AZ

ETL Developer (SQL, SSIS, SSRS, SSAS)

Responsibilities:

• Design, implement, test & maintain major scalable Sybase T-SQL components
• Define new product features in conjunction with product management & provide specifications
• Ensure quality & completeness of the product through unit testing, documentation & maintenance
• Provide 2nd or 3rd line support capability
• Partnering with global teams to achieve successful business delivery
• Knowledge of Sybase T-SQL or Microsoft MS-SQL
• Own and optimize SSDT release process to deploy source code across stage and production environments as part of CI/CD process.
• Work with database operations to upgrade SQL Server from SQL Server 2014 to SQL Server 2016 version.
• Created ETL- SSIS packages and scheduled packages for Incremental and full load of EDW.
• Created multi-dimensional SSAS cubes used by various marketing teams and exposed data through Pivot tables and Tableau.
• Strong ability to write & maintain stored procedures
• Strong database analysis & design skills
• Data Modelling tools/Diagrams/Documentation
• Competence in Unix/Linux environments
• Experience working on mission critical high performance systems
• A firm focus on quality & high attention to detail
• Bright & enthusiastic, self starter, highly motivated, comfortable taking the initiative and bringing ideas to the table
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters and compound Metrics and Prompts.
• Ability to work independently or with others within a distributed global development team, and to deliver within strict timelines
• Be flexible and adaptable

Environment: MS SQL Server, SQL, ETL, Microstrategy, SSIS, SSRS, SSAS, Data Warehouse, CI/CD, Tableau, PL/SQL, SQL Loader, SQL Plus, TSQL

Confidential

MSBI Developer/SQL Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Extensive T-SQL Programming involving development of Stored Procedures, CTE’s (Common Table Expressions), Views, Triggers, User Defined Functions and Scalar Functions.
• Trained on Microsoft’s own internal Data Transformation Tool called METaL (Metadata Extraction, Transformation and Load).
• Created Script Templates, Tables Columns, and Constraints using ERwin and forward engineered across various SQL Database environments.
• Developed SSIS extracts and migrated legacy SSIS.dts packages from SQL Server 2000 to 2008 R2 using SSIS (SQL Server Integration Services).
• Develop SSIS packages to extract data from source systems, transform and load staging and warehouse tables.
• Deploy and schedule SSIS packages for incremental load of data warehouse along with troubleshooting production issues.
• Develop SSAS cubes to facilitate reporting for ‘Genesis’ data mart.
• Developed MDM solution as ‘Source of truth’ for agent call data using Master data services (MDS).
• Re-developed SSAS 2000 cubes in SQL Server 2008 R2 rewrite MDX expression for calculations and named sets.
• Scheduled SQL jobs and SSIS packages using SQL Server agent for incremental and full load of data warehouse.
• Trained business users in developing ad-hoc reports in ProClarity 6.3 version.

Environment: SQL Server 2008, T-SQL, METaL 2.2\3.1, Data Vault, MDM, Erwin, SSIS, SSAS, MDX, Octopus 3.2.0, TFS (Team Foundation Server).