SUMMARY

• Having 8 years of IT experience in Business Intelligence(BI) Project Development and Implementation Using Micro Strategy 9.x/8.x Product Suites including Micro Strategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server.
• Involved in Projects like Full Life Cycle Development of Data Warehousing, Project planning, business Requirement Analysis, Data Analysis, Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security.
• Expertise in Working on Direct Project Source (Two - Tier) and Server Project Source (Three-Tier).
• Good Experience in Creating Schema Objects (Facts, Attributes, Hierarchies, and Transformations) to develop public Objects.
• 5+ years of experience in Data warehouse and OLAP applications.
• Good Knowledge in Developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, Drill Maps, Templates, Searches) to develop Documents and Reports.
• Hands on Experience in Creating Documents from multiple Datasets like Grid and Graph.
• Expertise in Creating Hyper Links in Documents and Drill Reports.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications.
• Extensively worked, in Creating Interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Fine Tuning of the Micro Strategy Reports using VLDB properties, Aggregable Tables and Intelligent Cubes.
• Experience in working with Micro Strategy Multisource.
• Proficient in using RDBMS Such as Oracle and Teradata.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Strong SQL Skills Related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Good knowledge in Performance tuning, Security and Scalability, Enterprise System Architecture.
• Good knowledge of performing Data Analysis using Python Scripting.
• Specialized in Developing Stored Procedures, Functions, Packages and Database triggers using Oracle, SQL and PL/SQL.
• Actively involved with business users and stake holders gathering business requirements.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Excellent Communication, Interpersonal, Analytical skills and Strong ability to perform as Part of the team.

TECHNICAL SKILLS

Business Intelligence: Micro Strategy 9/8.1.2 (Micro Strategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server, Command Manager, Administration, Object manager, Command Manager)

ETL: Informatica

Languages: C, C++, SQL,Java, PL/SQL.

Operating Systems: MS-DOS, Windows 98/NT/2000/XP/VISTA/7, UNIX and LINUX.

Web Technologies: MS Front Page, HTML,JSON,CSS, OO JavaScript, JQuery

Databases: Teradata, MySQL,Oracle 10g/9i, SQL Server 2005

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Sr. Microstrategy Administrator/Developer

Responsibilities:

• Designed and Administration of architecture for MicroStrategy reporting environment.
• Performed administration tasks such as user creation,ACL, security groups and objects.
• Improved the performance of the reports by changing VLDB properties.
• Assisted the deployment of Assignments from deployment of objects from QA to production server.
• Setting up SSO/ Server authentication and Administartion.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Developed different transformations which help business users to compare present data with previous year’s data in reports.
• Experience in developing Public Objects like reports, filters, prompts, metrics, templates, consolidations, custom groups, cubes, etc.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Hands on experience in Admin tools Object Manager, Command Manager, Enterprise Manager, System Manager, Operation manger.
• Highly involved in working with Multi-Dimensional Model, Star & Snow Flake Schemas and other Data Modeling and Data Warehousing applications.
• Hands-on experience on MicroStrategy BI e.g. dashboards, documents, MSTR Schema creation, advanced reporting.
• Experience in using Pass through functions and In Memory cubes.
• Experience in customer-facing roles for requirements gathering and architecting solutions for BI projects.
• Trains and mentors less senior team members and business users.
• Good analytical, inter-personal & communication skills, and proactive attitude.
• Leverages experience and can create/update customization plug-ins in MicroStrategy SDK for Mobile, Authentication and UI Customizations.
• Experienced in integration with Hadoop, Hive, Scoop
• Actively participated in developing Report Delivery Schedules.
• Modified VLDB Settings to tune the reports for faster execution.
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.

Environment: MicroStrategy 10, BASE SAS, Oracle, Teradata V2R6.1.1, SQL Server 2012.

Confidential, Indianapolis, IN

Sr. Microstrategy Developer/ Administartor

Responsibilities:

• Gathered and analyzed relevant data and created Schemas that fit reporting requirements. Defined fact and dimension tables, created aggregate table for performance.
• Performed Requirement Analysis to collect various business measures and attributes to develop a reliableStar Schemaand requiredFactsandAttributes.
• CreatedAdministration Taskslike creatingUser Accounts, Assigning Privilegesand appliedSecurity Filters.
• Utilize in-depth knowledge of functional and Technical experience in data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions
• Provided various management levels with reports, Time series analysis and wide range of graphs using MicroStrategy Web.
• Worked in handling the MicroStrategy BI tools and Narrowcast Administration.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiplepanel stacks, selectorsand customized widgets
• Create export scripts using Teradata Fast export utility.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Teradata Stored Procedures
• Created Relationship Filters based on Existing Model.
• Worked with Logistics Analyst who developed business requirement. Build mock up reports and presented to the users before starting the report development.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.

Environment: Microstrategy 9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, OLAP, Windows 2003, Microstrategy Dashboard, Oracle.

Confidential, MORRIS PLAINS, NJ

Microstrategy Developer

Responsibilities:

• 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.
• Createddrill mapsfor 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 troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.
• Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
• Designed and DevelopedMicrostrategy 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.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• 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 Desktop, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MS SQL Server 2005, Windows Server2003.

Confidential

Oracle developer

Responsibilities:

• Involved in End - to-End implementation Life Cycle of Oracle Financial modules.
• Analyzed client's current business events and process based on client discussions.
• Implemented Security rules, Cross validation rules and values for Value sets.
• Configured Financial Options and Payable Options.
• Defined Payment terms, Distribution set Internal Bank account and Supplier Bank Account.
• Defined Corporate books, fixed assets categories, assets keys etc.
• Documented the main setup steps, definitions and implementation issues.
• Configured the Test Instance as per the setup document.
• Prepared the Functional Document required for the business - Future Process module and Mapping design.
• Implemented the Access control for the users based on the responsibility.
• Involved in CRP and UAT. Given training to End Users.
• Implemented Financial Modules in TEST, DEV Instances.
• Testing of setups was done in the above instances.
• Authored BR100, TE040 and MD050 documents as per the requirement.
• Providing the user with relevant Test Scripts to test the instances and helping them on functional issues.
• Implemented Financial Modules in PRE PROD and PROD instances and handing over of PROD instance to users.
• Uploaded supplier & customer details from the legacy to the application.
• Done system integration testing with the sub-ledgers to the general ledger.

Environment: OracleApplication 11.5.8/11.5.10.2 (GL, AP, AR, CM & FA), AME, AIM Documentation, Windows XP, TOAD, Rational Clear Case, Mercury Quality Center.

Confidential

Oracle Developer

Responsibilities:

• Created new Tables, Indexes, views, synonyms and Sequences where needed.
• Create complex SQL, PL/SQL Packages, Procedures and Functions as per the requirement.
• Tuning slow running SQL queries with the help of explain plan.
• Used hints like Append, parallel to aid bulk inserts.
• Indexing tables where needed for faster retrieval of data and increase the performance.
• Tuning of PL/SQL code.
• Used PUTTY & secure shell to connect to UNIX machines.
• Write complex shell scripts for processing of the files and schedule the jobs in Control - M.
• Using external tables to load data into new database
• FTP csv files generated from SAS and load data into Oracle tables.
• Worked on data modeling.

Environment: Oracle, Jira, Confluence, OracleSQL déveloper, Toad.