SUMMARY:

• Currently working as Application Programmer V Specialist at Confidential with total of 9 years of experience in Business Intelligence & Data Warehousing.
• Have worked on Informatica ETL tool with extensive knowledge of Data Integration and Data Warehousing techniques.
• Worked on MicroStrategy BI tools 8x/9x/10.4 with experience on components like MicroStrategy Architect, Desktop, Web, Intelligence Server, MicroStrategy OLAP Services, Visual Insights, Documents & Dashboards.
• Have worked on wide range of databases like Oracle, MS SQL Server 2008, Teradata, IBM Netezza.

HANDS ON EXPERIENCE OF:

• Oracle 9i
• Microsoft SQL SERVER 2008
• IBM Netezza
• Teradata SQL Assistant
• Informatica 8.6 and 9.1 (ETL)
• Informatica Power exchange 9.1
• MicroStrategy Intelligence Server, MicroStrategy Desktop, MicroStrategy Web, and MicroStrategy OLAP Services, Visual Insights, Dashboards & Documents 8x/9x/10x
• Unix
• Trained on Tableau Reporting.
• Experience on end - to-end phases of the project life-cycle (from requirement analysis until deployment)

MICROSTRATEGY EXPERIENCE:

• Create project specific Visualizations as per the end user requirements.
• Create documents and dashboards with varying technical requirements. Reports either as freeform sql report/regular architect-based reports or Intelligent cube-based report.
• Work on all future enhancements as part of Agile cycle.
• Troubleshooting and tuning of reports to determine and fix any data issues/Report/Document Failures, incorrect joins, incorrect results and/or performance issues.
• Continuously involve in optimizing performance of existing reports resulting with cross join/product join. Data issues caused due to Semantic Layer View definition changes, revisiting attributes definition in the logical tables which can hamper the sql.
• Understanding and translating user requirements and goals into scalable and actionable MicroStrategy solution available in production environment or assist by gathering requirements for minor enhancements and application Change request.
• Perform Impact analysis and document the requirements.
• Provide effort estimation and plan release timelines.
• Experience with MicroStrategy security and user/group models, including implementing user/object/project level security, users and user groups and security roles.
• Worked on Schema Objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Templates, level metrics, pass through functions.
• Have worked on Administration feature of Intelligence Server like Job Monitor, Events, Schedules, Subscriptions, Cache Monitor.
• Have worked on Intelligent Cubes, Documents, VLDB properties, Security Filters & Access Control List (ACLs), Data mart reports, Multi-sourcing.
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks and allow them to be initiated on time-based or event-based triggers.
• Advanced SQL - ability to build and debug/maintain advanced SQL queries.
• Good analytical, inter-personal & communication skills and proactive attitude.
• Have worked on Informatica Power Exchange mappings for Change Data Capture. I have worked on both Type-1 and Type-2 SCD mappings.
• Have worked on Oracle Analytical functions like RANK (), ROW NUMBER () & Materialized views.
• Have worked on Cursor, Functions, Stored Procedure for removing duplicate records.
• Built & Maintained SQL queries for extensive analysis on data for addressing the production issues.
• Have worked on Expression, Sorter, Joiner, Aggregator, Lookup (Static and Dynamic, connected and Unconnected), Normalizer, Update Strategy, Source Qualifier, Rank, and Router, Sequence generator, Stored Procedure, Union and Update Strategy transformation.
• Have created reusable session which accesses the Informatica metadata exchange views for tracking the list of mappings long running greater than 2hrs.
• Have worked on Impact analysis for the mappings having table dependencies within the source qualifier, lookup transformation sql-override which is having dependency on the table.
• Have created the sessions, command task, event-wait task, worklets, and workflows. I have been involved in testing and creating test case document.
• Have been part of unit- testing, integration testing and acceptance testing and production go-live activities.
• Have worked on operational manual of the project and other transition documents for the support team.
• Have worked on both development and maintenance projects.
• Strong ability in understanding the system and coming up with the best solutions.
• Excellent analytical and communication skills.
• Have handled multiple project take over, good problem solver, good team-player; work well independently, self-starter, flexible, excellent oral/written communications, and excellent ability to communicate with both technical and business stakeholders

PROFESSIONAL EXPERIENCE:

Confidential

Database: IBM Netezza

Tools: MicroStrategy 10.4

Responsibilities:

• Engage in experience in Microstrategy components like MSTR Architect, Desktop/Developer, MSTR Administration, Web, Visual Insights.
• Use Microstrategy 10.4 suite Microstrategy Intelligence Server, Microstrategy Desktop, Microstrategy Web, Microstrategy OLAP Service, Visual Insights, Documents & Dashboards, Intelligence Cube, Freeform sql reports.
• Create Microstrategy Schema and Application objects such as attributes, facts, metrics, prompts, filters, consolidations and custom groups.
• Engage in experience in Report Services, Dynamic Dashboard, Report Development and Visualization.
• Use understanding and knowledge of dimensional Data Modeling, Data Warehouse and reporting techniques.
• Work with the full life cycle development process, which includes analysis, design, development and testing.
• Utilize SQL skills and create simple to complex Schema objects as per the requirements.
• Work with complex Microstrategy reports using advanced filters, level metrics, transformation metrics and using pass through functions in schema objects.
• Troubleshoot and tune Microstrategy reports to determine and fix data issues, incorrect joins and performance issues.

Confidential, San Francisco, CA

Database: Teradata

Tools: Microstrategy 9.2.1, Microstrategy 9.4.1

Responsibilities:

• Co-ordination of activities between the on-site and off-shore teams.
• Perform root cause analysis on the user adhoc request and perform data fixes as necessary.
• Monitor batch progress and fix batch failures.
• Building reports using metrics, prompts, relationship filters, DataMart, Multi-sourcing, templates, custom groups, and consolidations.
• Working with Documents and resolve the issue with their functionality, data issues.
• Troubleshooting, System Optimization, performance monitoring and sql tuning for Microstrategy Issues/reports.
• Trains and mentors less senior team members and business users.
• Admin functionalities of MSTR such as User Provisioning, ACL, Event, Schedules, Subscriptions
• Customer Interaction for resolving the user’s issues, helping them with the understanding on the usage of the application interface.
• Work with Product Development Manager for issues which require reverse engineering on the existing schema objects, metrics, and reports & suggest solution for handling new business requirements.
• Work with Teradata DBA for improving the sql performance of the report query.

Confidential

Database: Oracle11g

Tools: Informatica PowerCenter9.1, LINUX, Informatica Power Exchange v.9.1

Responsibilities:

• Creating the Confidential (CDC) mappings and Recovery mappings for loading data from Source to staging layer.
• Creating the Stored procedure for deleting the duplicates from the stage tables using the Oracle Analytical functions like Row Number.
• Worked on complex queries for addressing the production issues.
• Unit testing of the ETL mappings for loading data to Stage layer with test case documents.
• Developing the Atomic layerType-1 and Type-2 mappings.
• Unit testing the Type-1 and Type-2 mappings with test case documents.
• Co-ordination of activities between the on-site and off-shore teams.

Confidential

Database: Oracle 9i

Tools: Informatica PowerCenter9.1, UNIX.

Responsibilities:

• Analysis of the requirement and involved actively in bringing out various options for handling load strategy of target tables as there were deletes to be handled first for the child tables whereas Inserts & Updates first for the Parent table .
• Creating the low level design document for all 42 tables and 2 MVs for the project.
• Review on existence of the Referential Integrity Constraint on the tables required, suggested for ON DELETE CASCADE for handling deleting records from the related tables.
• Validating on the Object type in Database to be Materialized View to avoid error like Data Manipulation operation not legal.
• Validating for type of the tables SCD 1 or SCD 2 for the base layer & validating for the existence of the columns required for SCD.
• Validating on the Index existence for the tables.
• Coding and Testing.
• Documentation related to project.
• Co-ordination of activities between the on-site and off-shore teams.
• Involved in UAT support, Code Fix and Go Live as well. Successfully implemented the project.

Confidential

Database: Oracle, SQL Server 2008

Tools: Informatica PowerCenter8.6.1, Windows

Responsibilities:

• Analysis of the existing flow of the loads in production and creating dependencies between the loads to overcome the loop wholes which otherwise were resulting in records getting deleted from stage layer before getting loaded to the EDW.
• Performing the RCA for the Data missing in business reports i.e., data mismatch between the SADB and the final reports, followed by the implementing the solution in development with regression testing. Acceptance testing of the same solution and also in production.
• Actively been part of the team in understanding the existing system and have successfully done the
• Automation for tracking the long running sessions in production
• Automation for getting an alert when the morning load is not started as per the schedule which would otherwise affect all the other loads of the day and the final reports.
• Documentation related to project.
• Co-ordination of activities between the on-site and off-shore teams and have taken lead on offshore team in successfully completing the ASRs without any delays.

Confidential, San Francisco, CA

Database: Teradata

Tools: Microstrategy 9.2.1

Responsibilities:

• Data extract from the Style Assessment report which is the monthly report. This report includes the details of the new styles planned to be released for the month.
• Data export from the Model stock report which is used for analysis in comparison of the Style Assessment report.
• Data Extract from the Sales and Inventory report at Store, Week and Class Level.
• Co-ordination of activities with the downstream team for any of the data extracts request and adhoc request.

Confidential

Database: Oracle

Tools: Informatica Power Center 8.1

Responsibilities:

• Captured understanding of Source systems thoroughly for Design
• Involved in Detailed design, Traceability for all streams. Implied Type2 SCD Approach, Created, Altered Tables and Views.
• Involved in development and unit testing for all modules.
• Coordinated with the Onsite Team timely for Analysis, Design and Code Reviews.

Confidential, Minneapolis

Database: Teradata

Tools: Informatica PowerCenter8.1, UNIX, Teradata, DB2.

Responsibilities:

• Analysis of the requirement.
• Creating the detailed design for the modules.
• Coding and Testing.
• Documentation related to project.
• Co-ordination of activities between the on-site and off-shore teams