OBJECTIVE:

• Seeking for Sr. Architect/Management role with an opportunity to work on challenging projects providing great business and customer value.

SUMMARY

• 9+ years of experience in Business Intelligence with well acquainted in performing as Tibco SpotFire, Power BI, Microstrategy, Tableau and Iron Python Scripting with Strong Domain Knowledge of Financial, Health care, Banking, Telecom and Gaming along with Functional testing.
• Experienced in Full life cycle development gathering requirements, documentation, participating in design, development, testing and deploying BI solutions using SpotFire and MicroStrategy.
• Interacting with stake holders on day to day basis to understand their requirements and get clarifications for the team.
• Created and modified the elements and information links based on the requirements using Tibco SpotFire thru JDBC connection.
• Created Spotfire reports using data connectors thru ODBC connection.
• Created reports using multisource like Teradata and Oracle.
• Created custom reports using Iron Python scripting.
• Experience in creating Parameter and Personalized Information Links.
• Experience in creating custom filters in text area, calculated columns, custom expressions, Property Controls, Document properties, action controls.
• Experience in using transformations.
• Created reports using various charts (Line, Bar, Pie and MAP..) based on requirements in SpotFire.
• Migrated custom reports from Spotfire to Power BI using static tables, related functions, dynamic table creation using crossjoin.
• Created very complex data model using Power BI and SSAS to handle migration of reports.
• Created reports in power BI using Import, Direct Queries.
• Created calculated columns, Measures using DAX.
• Used functions like Sum, calculate, related, Divide, switch..etc.
• Experienced in managing team of 10+ members.
• Experienced in giving estimations and resource allocation for project deliverables.
• Experience in analyzing the risk and raise a flag well in advance to mitigate it.
• Provide effective performance feedback through employee recognition, rewards, and disciplinary action.
• Experience in creating Schema Objects (Facts & Fact Extensions, Attributes, Hierarchies, and Transformations) to develop application Objects.
• Experience in Developing Application Objects (Filters, Nested Prompts, Advanced Metrics, Custom Groups, Consolidations, Drill Maps, Templates and Freeform sqls) to develop Reports and Documents.
• Experienced in creating and working with intelligent cubes.
• Experience in using MSTR admin features like Object Manager and Integrity Manager.
• Experience in creating Documents, Dashboards (Widgets) and Visual insights.
• Excellent multitasking capability, efficiently plan and prioritize tasks with strong technical and business management skills. Actively involved with end users in gathering business requirements.
• Trained Business users on MicroStrategy self - service Reporting.
• Knowledge in Data Science (Machine Learning, business Statistics and R Studio).
• Expert in Smoke, Functional, Regression and user acceptance Testing.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Analyst

Responsibilities:

• Created and modified the elements and information links based on the requirements.
• Created reports using multisource.
• Designed and customized the reports in development and production to supply the business with improved flexibility and functionality.
• Extensively used filters, prompts, calculated columns, calculated expressions, Data functions using TERR, data-on-Demand, transformations and HTML to generate reports.
• Created filters using Iron Python scripting.
• Supported testing team and business users for testing the reports in SIT and UAT.
• Prepared BRD’s and LLD’s for 1-1 migration (Spotfire to MicroStrategy)
• Developed and Modified MicroStrategy reports based on enhancement requests.
• Extensively involved in data modeling to create attribute relationships.
• Created Schema and public objects specific to reports requirements.
• Created and modified the attributes and their relationships, facts and hierarchies based on the requirements.
• Coordinated with COE teams in migrating reports from one environment to other.

Confidential

MicroStrategy Consultant

Responsibilities:

• Interacted with Business Users in gathering Requirements.
• Involved in schema designing discussions
• Extensively involved in data modeling to create attribute relationships.
• Created Schema and public objects specific to reports requirements.
• Created and modified the attributes and their relationships, facts and hierarchies based on the requirements.
• Created Security Filters and assigned them to specific users.
• Guided the Testing, UAT and Business users in validating the report.

Confidential

Sr. Analyst

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Restricting user access and applying security based on the reporting requirements.
• Developed schema objects needed for report development needs.
• Tested the reports to make sure the report data is correct and performed security filter testing for different product users.
• Developed reports like APD summary, Poker rake amount, casino bets, bonus amounts given to particular categories
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in Testing and Data validation of Reports
• Performed tuning to minimize data load time. Excellent gain in performance recorded and also involved in defining requirements, functional specifications, design documentation and test strategy
• Developed various public objects needed for building the reports
• Developed static reports as per the report layout for partners
• Setting up Narrowcast report delivery to the partners to receive the reports
• Performed Unit testing of reports

Environment: MicroStrategy 9.3.1/9.4.1 (Administrator, Architect, Desktop, Intelligence server, Narrowcast Server, Object Manager, Web) Windows 7 enterprise, Informatica, Teradata 13.0/14.1, Solaris 10