SUMMARY:

• Experience in Data Warehousing, Data analysis and Database applications, which include MicroStrategy platform.
• Knowledge on Business Intelligence project development and implementation using MicroStrategy 10.x/9.x product suites.
• Worked on ETL process using Ascential DataStage 7.5.1.A, InfoSphere DataStage 8.x, QualityStage 8.0, Oracle, SQL and UNIX.
• Knowledge in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.
• Worked on Designing Schema Objects like creating Attributes, Facts, Hierarchies, Transformations and developing public objects like Metrics, Advanced Metrics, Filters, Advanced Filters, Prompts, Custom Groups, Consolidations as per the user requirements.
• Experienced in creating Dashboards, Scorecards by using MicroStrategy Report Services.
• Good knowledge on Intelligent cubes and Visual Insights
• Used MicroStrategy Object Manager to migrate the objects/projects between different environments.
• Experience in writing SQL Queries (Sub queries and Join conditions, correlated sub queries)
• Comfortable with all phases of Software Development Life Cycle (SDLC) including business requirements gathering, Design, Development, Testing, and Implementation of Client - Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP/Business Intelligence Applications.
• Experience on end to end development of a Data Quality and DataStage parallel Jobs.
• Extensively worked on Design and Development in DataStage 8.1, DataStage 8.7, Oracle 9i/10g/11g, Teradata 13 and MS SQL Server 2008.
• Developed expertise in testing the DataStage jobs according to the Client requirements.
• Performed documentation in accordance with the Company/Client standards and processes.
• Worked with various Stages like look up, join, funnel, filter, row generator, column generator, remove duplicates, complex flat file, xml file, Sequential File, Sort, Dataset, Aggregator, Transformer, and Change Capture etc.
• Documented jobs using annotations and following naming standards for code maintenance.
• Able to meet deadlines and handle multiple tasks.
• Involved in gathering and analyzing Business Requirements for generating reports.
• Good communication & interpersonal skills with abilities in resolving complex software issues.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10.x,9.x (Architect, Desktop, Object Manager, Command Manager, Web, Intelligence Server, Integrity Manager, Enterprise Manager, Narrowcast Server)

ETL Tools: InfoSphere DataStage 8.x, Information Analyzer 8.1.2, QualityStage 8.0, Informatica Powercenter 9.x, Informatica Data Quality

Databases: Oracle 9i/10g/11g, Teradata 13, MS SQL Server 2008

OS: Windows XP Professional/Vista, RedHat Linux

Other tools: TOAD, Team Foundation Server, PuTTY, WinSCP, MS Office

PROFESSIONAL EXPERIENCE:

MicroStrategy Developer/Consultant

Confidential, Bethpage, NY

Roles & Responsibilities:

• Created Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters.
• Created Hierarchical prompts, nested prompts, object prompts.
• Created Cubes to assist the quick analysis for the Demand and Deployment Team. In turn reduced a large amount of load on the MicroStrategy and Database.
• Experienced in performance tuning of the reports and the environment.
• Involved along with Oracle DBAs to create partitioned tables and indexes to improve the overall report performance.
• Worked on District Manager Mobile Dash Boards for Better, quick and best Analysis of store performance.
• Developed Dashboards using widgets and selectors for summary level reporting.
• Designed Visual Insight dashboards using map visualizations and have trained users on creating one. MicroStrategy data can be viewed on Google Maps and visualized in MicroStrategy web using DHTML, in Visual Insight, an iPad.
• Created Dashboards using report services documents. Applied custom fonts on dashboards using SDK.
• Applied Teradata Application Utilities and Teradata SQL. Also Fine-tuned SQL using Teradata.
• Involved in extraction of data from different Sources like SQL Server, Oracle, Flat Files into Teradata Global Repository Database, using Informatica.
• Developed Dynamic Dashboards and Scorecard reports.
• Developed departmental dashboards for different brands and Key Performance Index corporate dashboards.
• Migrated Narrocast Services to Distribution Services.
• Created customized Custom Groups with complex filters and Relationship filters.
• Created Complex reports for analysis (like Market Basket analysis) with custom groups, Transformations and complex filters.
• Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both Microstrategy Desktop and MicroStrategy Web.
• Created Ad-hoc reports with dynamic prompt answers for the end users.
• Worked with the MicroStrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues
• Used the VLDB properties for performance tuning and SQL optimization.
• Created Transformations like last month to current month and also created the required transformation tables.
• Experience in analysis the explain plans of SQL and analyzing the indexes in the process of tuning the reports.
• Involved in designing the Conceptual model and creating the Aggregate tables considering both the Technical Feasibility and Business Feasibility to improve report performance.
• Interacted with the data modeling team for the Logical and Physical model design.
• Coordinating with offshore team during migrations and any production support issues.
• Working on CA Technologies UnicenterServicePlus Service Desk for support.
• Performed the ETL, UAT and System tests on the warehouse tables and the reports.

Environment: MicroStrategy 10.x (Administrator, Architect, Desktop, Web, Object Manager, Integrity Manager), ETL, UNIX, Windows 2012, DB2, Oracle, MicroStrategy Dashboards, MS-Excel, Toad for DB2.

MicroStrategy Developer

Confidential, Pleasanton, CA

Roles & Responsibilities:

• Gathering the Functional and Business requirements and documenting specifications.
• Involved in Analysis, Design, Development, Testing, Documentation and Implementation of the project.
• Worked on Agile Methodology.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Creating Table Aliases and Developing Logical Views.
• Creating attributes, facts, and working on Attribute relationships using MicroStrategy Architect.
• Developing Metrics, Prompts, Filters, Reports, Report Builders, Report wizards, Drill maps.
• Worked on Drill to Template on Standard Reports to Drill to Child Report from Parent Report / Summary Report.
• Develop Hierarchies, Custom groups, Consolidations and Transformations etc.
• Defining Drill Hierarchies, creating relationship between Attributes.
• Created Reports using Complex filters and compound metrics and Prompts.
• Troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Creating Interactive Dashboard Reports and Documents to view personalized reports based on user requirements.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Upgrade of Web and I - servers along with documenting upgrade for MicroStrategy client products
• Utilized Integrity Manager to Perform Testing on Dev, QA and Production Environment Using Baseline Vs Baseline and Baseline Vs Projects Techniques.
• Validated Results Rowset, SQL Execution time, formatting and PDF Exports, on Grids, Dashboards and Documents Using Integrity Manager.
• Worked on Creating Security Filters and Organization Groups.
• Assigning Security filters by adding Users to related Organization Groups.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Web, Object Manager, Integrity Manager), ETL, UNIX, Windows 7, DB2, MicroStrategy Dashboards, MS-Excel, Toad for DB2. Citrix Application

MicroStrategy Developer

Confidential, San Ramon, CA

Roles & Responsibilities:

• Involved in creating schema objects like Attributes, Facts, Hierarchies, Transformations and Public Objects.
• Developed MicroStrategy application objects such as Metrics, Filters, and Prompts to compare monthly, quarterly, and annual statistics.
• Implemented advanced data drilling features, drill maps that allow users to view the reported information in greater details, from high-level enterprise wide overview to information relating to specific stores and products.
• Created Hierarchical prompts, nested prompts, object prompts.
• Created customized Custom Groups with complex filters and Relationship filters.
• Created Ad-hoc reports with dynamic prompt answers for the end users.
• Worked with the MicroStrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues
• Created Transformations like last month to current month and also created the required transformation tables.
• Good knowledge on MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administration.
• Worked on performance tuning to reduce the runtime of MicroStrategy reports and improved the performance of reports by changing the VLDB Settings, reducing the number of SQL passes, addition index creation etc.
• Catered to the user needs in terms of technical assistance, maintenance and provided access and privileges.
• Involved in generating adhoc report generation for the client’s immediate needs.
• Used MicroStrategy web to enable users to run-predefined revenue and region reports for building their own customized reports.
• Managing projects through entire systems development life cycle, including creating timely status reports and leading status meetings.
• Involved in preparing test cases and test plans for the reports.

Environment: MicroStrategy 9.3 (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Integrity Manager, MicroStrategy Enterprise Manager), Redhat Linux, Oracle 11g, Toad.

BI/DW Analyst

Confidential

Roles & Responsibilities:

• Interacted with the business users to better understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements.
• Extracted data from sources such as Teradata, ORACLE and Flat Files (Delimited Text and CSV files), Transformed as per mapping specification documents and loaded into Teradata DWH.
• Worked with various Stages like look up, join, funnel, filter, row generator, column generator, remove duplicates, complex flat file, xml file, Sequential File, Sort, Dataset, Filter, Funnel, Aggregator, Transformer, and Change Capture etc.
• Taking the backup of jobs developed using DataStage import/export utility.
• Delivered daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Used stage variables in performing derivations and set up conditions to filter records based on the constraints in the Transformer and Lookup.
• Used DataStage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
• Performed all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Generated metric reports reflecting the weekly & monthly reduction in errors and suspects and setup review meeting with clients for User acceptance.
• Implemented ETL jobs from the offshore team & enforced QA standards to promote readability and maintainability and insure a higher quality of ETL development.
• Designed Mappings between sources to operational staging targets, using Star Schema, implemented logic to Slowly Changing Dimensions.
• Documented jobs using annotations and following naming standards for code maintenance.
• Involved in meetings with team members to resolve the issues and optimize the performance.
• Used DataStage Director for Job scheduling, Monitoring and Create the Batches.
• Participated in Unit testing, Functional testing, integration testing & provided process run time.

Environment: Ascential DataStage 7.5.1.A, InfoSphere DataStage 8.1, InfoSphere DataStage 8.7, Information Analyzer 8.1.2, QualityStage 8.0, RHEL, Teradata 13, Toad, PuTTY, WinSCP.

Software Developer Intern

Confidential

Responsibilities:

• Developed data models to meet the needs of the organization's information systems.
• Managed the flow of information across various applications and departments using relational databases.
• Maintained data integrity by working to eliminate redundancy.
• Stayed informed of the ways the organization uses its data.
• Provided status reports and create/contribute to project estimates.
• Created and maintain documentation for all projects.
• Participated in weekly database user discussion forums and meetings.

Environment: MS-SQL, PuTTY, WinSCP, Windows XP.