SUMMARY

• 9+ years of IT experience in all phases of Full Software Development Life Cycle (SDLC) Initiation, Planning, Analysis, Design, Construction, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• 8+ years of extensive experience working with all aspects of Confidential 9.4.1/9.3.1/ 9.3.0/9.2.1 m/ 9.2.1//9.1/9.0.1/9.0 /8.1.2/8.1/8.0.3 tool suite ( Confidential Developer, Confidential Desktop, Confidential Web, Confidential Narrowcast Server, Confidential Distribution Services, Confidential Integrity Manager, Confidential Command Manager, Confidential System Manager, Confidential Object Manager, Confidential Mobile, Confidential Office and Confidential Enterprise Manager).
• 4+ year experience in Confidential Mobile to configure, develop dashboards & documents for iPad.
• Trained in Confidential SDK to customize Confidential according to the customer requirements.
• Trained in Informatica and Big Data components.
• Installed and Configured Intelligent Server and Narrowcast Server to schedule; execute and deliver reports directly to business users using various delivery methods.
• Significant experience in the Banking, Wireless, Healthcare, Insurance, Retail and Manufacturing domains.
• Good experience in upgrading Confidential project from one version to another version and making use of improved performance and new features. Involved in upgrading Confidential version 9.3.1 to version 9.4.1, version 9.3.0 to version 9.3.1, version 9.2.1m to version 9.3.0, version 9.0 to version 9.2.1m, version 8.1.2 to version 9.0, version 8.0.3 to version 8.1.
• Experienced using Confidential Integrity manager to compare reports/documents between different environments, Confidential Object manager to move objects and Command Manager to create schema objects in bulk.
• Extensive experience in developing Schema Objects (Facts, Attributes, Hierarchies, and Transformations) and Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches and Templates) to develop reports.
• Proficient with Data modeling using ERwin and Toad for dimensional data modeling techniques such as Star schema and Snowflake schema, which includes Logical and Physical data modeling.
• Good Experience in RDBMS like Netezza, Teradata, DB2, Oracle, SQL Server and DBMS like MS Access.
• Extensive experience creating Reports, Documents, Dashboards and Scorecards according to client/business user requirements.
• Extensive experience performing Administration tasks like Intelligence Server Administration, Configuring Memory Settings, Performance Monitoring, Scheduling, Creating New Users, Security Groups, Object Manger, Project Manager, Integrity Manager, Security Filters, Command Manager and Narrowcast Server Administration.
• Communicated, Managed and Mentored a team of offshore resources on a day to day basis to ensure productivity.
• Experienced with the concepts of Data Warehousing, Data Marts, Logical and Physical data modeling, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Optimized report generation with respect to Very Large Databases (VLDB) to make absolute use of Database Flexibility, Caching, Security and Scalability Issues suited for Oracle, Teradata, DB2 and SQL Server and involved in troubleshooting Confidential reports.
• Self - initiative, excellent analytical and Communication skills and ability to work independently and as good team player.

TECHNICAL SKILLS

BI Tools: Confidential 9.4.1/9.3.1/ 9.3.0/9.2.1 m// 9.2.1/9.1/9.0.1/9.0/8.1.2/8.1/8.0.3 ( Confidential Developer, Confidential Desktop, Confidential Web, Confidential Mobile, Confidential Narrowcast Server, Confidential Distribution Services, Confidential Office, Confidential Command Manager, Confidential System Maanger).

Database Tools: Aginity Netezza Workbench, DbVisualizer, SQL Loader, SQL *Plus, Query man, SQL Server Management Studio.

Databases: Netezza, Oracle 11g/10g/9i/8i, Teradata, DB2, SQL Server 2010/20, MS Access, MySQL.

Languages: C, C++, SQL, PL/SQL, T-SQL, UNIX Shell Scripting

Web Technologies: HTML, XML, PHP, JavaScript, Ajax, Adobe Flash Builder 4.

Operating Systems: Windows Server 2010/2008/2005 , MS-DOS, UNIX.

Data Modeling: ER Studio 8.5, Toad Data Modeler, ERwin.

Packages: MS Office Suite (2010/2007/2003 ), Adobe Dreamweaver (CS4/CS3).

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr MicroStrategy Administrator/Architect

Responsibilities:

• Involved in meetings with Business Users to discuss and finalize the requirements for reports.
• Created projects and performed project duplications.
• Migrated objects from Dev to QA and QA to Prod using Object Manager Packages.
• Created System Manager Workflow to run cubes in series after data load completion.
• Developed various documents/dashboards as per requirements for executives to support for iPad/Web.
• Was involved in upgrading Confidential from 9.3.1 to 9.4.1.
• Was involved in data model meetings and made suggestions which work best for Confidential .
• Used Enterprise Manager to check reports usage, project performance etc.
• Coordinated with ETL for populating tables and correcting data related issues.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships between attributes.
• Developed Public objects like Consolidations, Custom Groups, Metrics, Prompts, and Filters according to the report requirements.
• Visited office location in UK for user training and helped them in creating their own reports and converting SAP BW/excel reports to Confidential .
• Improved the report by making changes like VLDB settings, moving filters on metrics from report filter to report limit, working with DBA to implement distribution keys on fact tables, etc
• Tested reports by running queries against Netezza database using Aginity.
• Was responsible for providing migration & Test case documents for object migrations to higher environments.
• Created various Hierarchy, Nested & Object Prompts.
• Assisted users in creating Visual Insight Documents and Dashboards.

Environment: Confidential 9.4.1/9.3.1 (Administration, Desktop, Architect, Web, Mobile, Distribution Services, Object Manager, Command Manager, Integrity Manager, Enterprise Manager, System Manager), Netezza Database, Aginity workbench..

Confidential, Lyndhurst, NJ

Sr MicroStrategy Administrator/Architect

Responsibilities:

• Involved in meetings with Business Users to discuss and finalize the requirements for reports.
• Upgraded all the Confidential servers from 9.2.1m to 9.3.0 and 9.0 to 9.2.1m.
• Used Integrity Manager to check the report data, performance while performing the upgrade.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships between attributes.
• Created various drill maps to support drilling from reports based on the requirements.
• Developed Public objects like Consolidations, Custom Groups, Metrics, Prompts, and Filters according to the report requirements.
• Created visual insight reports as per user needs.
• Created various reports and documents for higher management to view on iPad.
• Developed Dashboards & documents according to the requirements.
• Created data marts to support various reporting needs.
• Used Pass-through functions like ApplySimple to create complex attributes, metrics and filters.
• Created users and assigned them to appropriate security groups.
• Created various intelligent cubes to support large number of reports.
• Automated many corporate reports to run weekly and monthly using time based schedules.
• Created various groups and assigned security filters to restrict users.
• Migrated objects from Dev to QA, QA to PROD using Object Manager.
• Modified VLDB Settings to improve the performance of the reports.
• Tested all the reports by running queries against SQL Server database using SQL Server Management Studio.

Environment: Confidential 9.3.0/9.2.1 m/9.0 (Administration, Desktop, Architect, Web, Mobile, Distribution Services, Object Manager, Command Manager, Integrity Manager, Enterprise Manager), SQL Server 2008.

Confidential, Irving, TX

Responsibilities:

• Involved in meetings with Business Users to discuss and finalize the requirements for reports.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Developed data model exclusively for this project.
• Assisted DBA’s in populating various tables by proving the SQL codes.
• Coordinated with ETL and Confidential SDK developers.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships between attributes.
• Developed Public objects like Consolidations, Custom Groups, Metrics, Prompts, and Filters according to the report requirements.
• Developed Dashboards according to the requirements.
• Used Pass-through functions like ApplySimple to create complex attributes, metrics and filters.
• Created various groups and assigned security filters to restrict users.
• Migrated objects from Dev to QA, QA to PROD using Object Manager.
• Used Integrity Manager to check the report data, performance when they are moved between environments.
• Modified VLDB Settings to improve the performance of the reports.
• Tested all the reports by running queries against SQL Server database using SQL Server Management Studio.

Environment: Confidential 9.2.1 (Administration, Desktop, Architect, Web, Object Manager, Distribution Services, Command Manager, Integrity Manager, Enterprise Manager), SQL Server 2008, SQL Server Management Studio.

Confidential, Hoffman Estates, IL

Sr MicroStrategy Architect/ Developer

Responsibilities:

• Worked with Business Users to discuss and finalize the requirements for reports and provided best practices whenever required.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Documented the Technical Design’s for the reports according to the requirements.
• Documented all the testing results following the Test Case Documents.
• Developed Schema Objects like Facts, Attributes and Transformations, and assigned relationships between the attributes.
• Created Various Hierarchies which allows drilling on the reports.
• Developed Public objects like Consolidations, Custom Groups, Metrics, Prompts, and Filters according to the report requirements.
• Created several Base Formulas using facts that can be reused to build any number of metrics.
• Tested reports by running queries against the Netezza database using Aginity Netezza Workbench.
• Developed Prompted Filters that gave user a choice of different filtering criteria each time they run the reports.
• Coordinated with DBA and ETL developers for table creation, loading data and other database related issues.
• Developed various Dashboards and Scorecards.
• Migrated objects from Dev to QA, QA to PROD using Object Manager.
• Used Integrity Manager to check the report data, performance when they are moved between environments.
• Improved the report by making changes like VLDB settings, moving filters on metrics from report filter to report limit, working with DBA to implement partition on fact tables, creating indexes, etc.
• Provided production support and fixed bugs in existing reports.
• Used Transaction Services and loaded report data into tables which can be used by other reports.

Environment: Confidential 9.1/9.0.2 (Administration, Desktop, Architect, Web, Object Manager, Command Manager, Integrity Manager, Enterprise Manager), Netezza TwinFin 5.0.8, Aginity Netezza Workbench 1.5.

Confidential, Washington, DC

Responsibilities:

• Gathered requirements from Business users, Stake holders for the project.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Extensively used Command Manager to create schema objects in bulk.
• Proposed naming standards for Attributes, Metrics and Filters to make easy for Business users.
• Prepared documentations related to the Confidential project implementation.
• Created Various Hierarchies which allows users to drill on reports.
• Developed Public objects like Metrics, Custom Groups, Consolidations, Prompts, Templates and Filters.
• Tested all reports by running queries against the Netezza database using DbVisualizer.
• Coordinated with Database Architect and ETL developers for data availability and data model related issues by providing solutions that support Confidential application.
• Documented the Confidential Data Dictionary.
• Created security groups/roles in user manager and assigned the users accordingly to restrict the access to Confidential objects.
• Created security filters to restrict the data on the reports for individual users.
• Developed various Ad-Hoc reports and canned reports for the users.
• Used auto prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Used Enterprise Manager to check the performance of the reports and usage of objects.
• Created static and dynamic dashboards using various widgets according to the requirement.

Environment: Confidential 9.0 (Desktop, Architect, Web, Object Manager, Command Manager, Integrity ManagerEnterprise Manager), Netezza TwinFin 5.0.8, ER Studio 8.5, DbVisualizer 7.0.7, HP Quality Center 10.0.

Confidential, Jersey City, New Jersey

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Developed different reports according to the requirements.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Extensively used Command Manager to create schema objects in bulk.
• Interacted with DBA and Data Modeler to build Dimensional Data Modeling (Star Schema, Snow-Flake Schema).
• Managed, Trained and guided junior Confidential Developers of team size 5.
• Created groups in user manager and assigned the users accordingly to restrict the access to objects.
• Created security filters to restrict the data on the reports for individual users.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports.
• Performed routine administrator tasks during absence of Confidential administrator.
• Created Users, Roles & Privileges using the Confidential Desktop (Administrator).
• Extensively worked with Object Manager to migrate the Confidential Objects from development to QA and then to production environment.
• Used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards.
• Tested all the reports by running queries against the warehouse using Query man. Also compared those queries with the Confidential SQL engine generated queries.
• Modified VLDB Settings to tune the reports for faster execution.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Involved in upgrading Confidential 8.1.2 to Confidential 9.0.
• Extensively used Integrity Manager to test reports when upgraded from Confidential 8.1.2 to Confidential 9.0.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing, Thresholds and Report Optimization.
• Used Confidential Narrowcast server to deliver reports directly to business users by various delivery methods.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Provided Business user training for the Confidential Desktop/Web.

Environment: Confidential 9.0/8.1.2 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, OLAP Services, Project Manager, Intelligence Server), Teradata 12.0, Oracle 11g, Query Man, UNIX

Confidential, Green Bay, Wisconsin

Responsibilities:

• Worked with business users to verify data requirements and provided best practice consulting when needed.
• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to view reports in different perspectives.
• Assisted in Project setup (Installing, Configuring, Managing and controlling) and Project Lifecycle management.
• Managed and guided junior Confidential Developers of team size 5.
• Developed reports and dynamic dashboards for daily, weekly and periodic sales analysis.
• Extensively used Command Manager to create schema objects in bulk.
• Worked on advanced features like heterogonous column mapping, relationship filters and parent-child relationship.
• Periodic maintenance of Intelligence server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Created Transformations like YTD (year to date), MTD (month to date), and WTD (week to date) analysis.
• Coordinated with ETL and DBA teams for data availability and data model related issues and problems and provided solutions that support Confidential application.
• Responsible for Installation and Configuration of Intelligence server, Web Server and Enterprise Manager.
• Involved in managing objects between different environments by using object manager.
• Created and managed Confidential application objects, schema objects and configuration objects.
• Created various Narrowcast Services to deliver reports to users by various delivery methods.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
• Implemented Narrowcast tasks like service designs, subscription, scheduling and administration.
• Used Confidential Enterprise Manager to see the usage of reports and their performance.

Environment: Confidential 8.1.2(Desktop, Intelligence Server, Web, Administrator, OLAP Services, Project Manager, Narrowcast Server), DB2 9.5, Teradata 12.0.

Confidential, Somerset, New Jersey

Responsibilities:

• Upgraded the environment from Confidential 8.0.3 to 8.1 to take advantage of the performance gains, cart-style prompts, reporting services & interactive dashboards.
• Involved in analysis, design and construction of the Metadata.
• Coordinated with the DBA for table creation, loading data and other administrative activities.
• Designed Dashboards in 8.1 using the new selectors radio buttons, check boxes, panels, slider and button bar etc summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Created a Database instance for Confidential and added all the tables, table prefixes and updated the table structure required for the Project.
• Extensively used Command Manager to create schema objects in bulk.
• Extensively used Integrity Manager to test reports when upgraded from Confidential 8.0.3 to Confidential 8.1.
• Implemented the Confidential projects by creating Public & Schema objects like facts, attributes, hierarchies, reports, filters, metrics and templates in Confidential Desktop.
• Improved the performance of the reports by changing VLDB properties.
• Developed different transformations which help business users to compare present data with previous year’s data in reports.
• Extensively used Confidential Report Services to generate Report Documents.
• Implemented Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Applied best customization practices which can improve system performance and make application easier to maintain and upgrade to later versions of Confidential Web.
• Performed Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: Confidential 8.1/8.0.3 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, OLAP Services, Project Manager, Intelligence Server), Teradata V2R6.1.1, SQL Server 2005, ERwin.

Confidential

Oracle Developer cum DBA

Responsibilities:

• Planned, Installed, Configured and Upgraded of Oracle Databases (9i-10g).
• Coordinated Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performed Daily, Weekly and Monthly Oracle monitoring and maintenance tasks
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Created Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Created of Users and granted privileges and roles.
• Performed Database Tuning, Database Security and Integrity.
• Used extensive Sub Queries, PL/SQL procedure, DDL functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL
• Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle and also monitored the data loading jobs and tuning the SQL queries.
• Created Indexes, Views, Alerts, Triggers, Procedures, Stored Procedures, Functions and packages in PL/SQL. Writing shell scripts to automate the data loading. .

Environment: Oracle 10g/9i, SQL Server 2000, UNIX, Windows (NT/2000), TOAD, SQL *PLUS, UNIX Shell Scripting, PL/SQL.