EXPERIENCE SUMMARY:

• Over 8 years in IT industry with major focus on Business Intelligence tools, Data Warehousing and Database Applications.
• Certified in analyzing and visualizing data with Microsoft Power BI.
• Experience in design development and implementation of Business Intelligence.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Lead the day - to-day activities for one or more delivery teams, ensure alignment to software delivery processes/best practices.
• Work with management to develop, establish and maintain project management standards and procedures.
• Provide subject matter expert (SME) consultation on complex projects.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Expert in creating Dashboards using Tableau features like Quick Filters, Action Filters, Drill down, Hyper linking, Ranking
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Prepare for and facilitate project related meetings including: project kickoff presentations, discovery session(s), client status meetings.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Developed key performance metrics and dashboards to help drive key business decisions through data compiling, modeling, reporting and automation.
• Experience in test automation tools like Selenium IDE, RC, Webdriver and Grid.
• Exposure with Source Code debugging, writing unit / White box test code with help of JUnit and TestNG framework.
• Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites.
• Analyzed the in depth client requirements by understanding the business flow and business model
• Good understanding different database management systems including Oracle11i TOAD 8.6.1 SQLServer DB2 Teradata V12.0 with respect to Enterprise Data Warehouses.
• Expert in creating Report Service Documents and DASHBOARDS.
• Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA.
• Strong SQL Skills related to information retrieval and analysis.
• Experience in executing all phases of Software Development Life Cycle from Requirement Analysis to Go Live and support, meeting client SLAs and development of objects required post go-live.
• Strong development, team-leading, project management and support skills.
• Experience working with new technologies and a quick learner.
• Preparing the Technical Specification documents, Developing, Testing and Preparing UTP.
• Excellent Communication, Analytical, Problem solving and mentoring skills.
• Self motivated individual, who works well in fast paced, high-pressure environment.

TECHNICAL SKILLS:

Business intelligence: MicroStrategy (MicroStrategy Desktop/Web, Mobile/IPad, Intelligence Server, PowerBI Desktop, PowerBI web, PowerBI Admin portal Narrowcast Server, VBA,Report services, Business Objects. Informatica Power Center 9.1.0

Databases: Oracle 10g/9i/8i/7.x,Teradata V2R4/5,DB2,SQLServer, MS Access 2000

Utilities: Oracle SQL-loader, PLSQL Developer, TOAD, Oracle Developer, Teradata Query analyzer.

Languages: C, PL/SQL.

OS: Window NT/2000/98, Sun OS 5.6

Tools: /Internal applications: SQL Developer, SSN, SharePoint, Jira,Version1, Bugman, Pivotal, Testlink

PROFESSIONAL EXPERIENCE:

Confidential, FosterCity, CA

MicroStrategy/Power BI Developer

Responsibilities:

• Worked with the business operational teams to understand data sources and implement new requirements.
• Research existing database methods and create study for suggested changes.
• Identify, analyze, and interpret trends or patterns in complex data sets
• Worked with Data Engineers to transform raw and staged data into actionable and meaningful analytic solutions.
• Worked with data visualization and analysis tools to build, publish and maintain data models leveraged in reporting and by business analysis
• Worked with the broader analyst community to gather, scope and prioritize analytic opportunities
• Worked in a cross-functional team to define and clarify analytic requirements, develop implementation plans, and ensure data quality standards.
• Documenting data requirements and evaluating complex business problems to present actionable analytic recommendations
• Identify, collect, and assemble relevant data requirements from disparate sources to enhance internal data warehouse systems and reporting capabilities for the organization.
• Serve as a subject-matter expert and proactively identify and implement the best methods/models to address complex business questions, such as data visualization
• Advanced working knowledge of large data manipulation and data mining within an Microsoft SQL environment
• Used Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management.
• Develop documentation and materials, participate with customer groups in the planning for long term systems enhancements
• Exceptional problem solving, technical and data analysis skills.
• Effectively presented information and communicated findings, conclusions and recommendations to business management
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.

Confidential, Phoenix, AZ

MicroStrategy Developer

Environment: Microsoft PowerBI Desktop, PowerBI web, PowerBI, Enterprise Manager, MS-Excel 2010, MicroStrategy 10.4, TOAD, MS-Word 2010, VBA,MS-Office Visio 2010, Windows 10.

Responsibilities:

• Lead the day-to-day activities for one or more delivery teams, ensure alignment to software delivery processes/best practices.
• Work with management to develop, establish and maintain project management standards and procedures.
• Prepare for and facilitate project related meetings including: project kickoff presentations, discovery session(s), client status meetings.
• Create mockups and POC’s on user stories for business acceptance and sign-off. Using Microstrategy architect, create metadata and warehouse schema for reporting, attributes, determine hierarchy, metrics and application objects.
• Developed key performance metrics and dashboards to help drive key business decisions through data modeling, reporting and automation.
• Demonstrate and implement customized solutions in MicroStrategy Web for enhanced user experience for store leaders and managers.
• Coordinate with business analysts to understand the business and reporting requirements, feature requests and enhancements.
• Enhanced existing VBA application by performing VBA coding, modifying understanding existing VBA scripts.
• Participate in data warehouse and schema architecture design discussions with onsite teams and provide inputs for logical and physical data model, schema and table creation, source to target data mapping and build logic for data transformation and manipulation.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Created Level metrics, advanced filters, prompts.
• Created and Deployed Multi Panel Dashboards, Multiple Images, Hyperlinks and edit links to navigate the documents between the hierarchy elements of the project.
• Worked with ETL Developers to resolve the data issues.
• Work with offshore team on report design and visualization, dashboard creation and implementation of requested functionality.
• Lead technical delivery teams across multiple projects of various complexities.
• Identified potential project risks, provide continuing direction to the delivery teams and communicate project status regularly.

Confidential, Foster City, CA

MicroStrategy Developer/Tableau

Environment: MicroStrategy 9.4, Enterprise Manager, MS-Excel 2010, MS-Word 2010, MS-Office Visio 2010, Windows 10.

Responsibilities:

• Worked with the ETL team and business operational teams to understand data sources and implement new requirements for DPS-Portfolio Optimization Project.
• Ensuring all requirements for reporting project status, action items, risks, and issues sufficiently meets the needs of project stakeholders.
• Working with stakeholders to ensure common understanding of priorities, strategies, and timelines for the project.
• Created Prelim and Detail design documents based on the business requirements.
• Developed and implemented complex reports, Dashboards and Visualizations for VDM Fraud Dashboard Reports &KPIs Project.
• Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.
• Involved in the lifecycle of VDM Fraud Dashboard Reports &KPIs Project, DPS-Portfolio Optimization Project and VDM Prepaid Cardholder Data Integration.
• Provided Support for QA, UAT Environments and DR fixes.
• Administered the object change management process: Object migration across the various environments using Object Manager or Project Merge.
• Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management
• Worked the Production issues queue, provided full support to our business intelligence community
• Created Schema Objects and Public Objects with Command Manager.
• Created Time Triggered and Event Triggered Schedules, Events and Subscriptions for the Intelligent Cubes reports. Created batch files using command manager script to Trigger events.
• Expertise in Integrity Manger. Trained QA Team on Integrity manager Usage. Compared report and I-Server performances in DB2 and Oracle Databases.
• Prioritize and multi-task concurrent projects; Effective in resolving all clients and development issues
• Coordinated the Onsite and Offshore team to resolve issues.
• Created manual test cases and Performed Integrity Testing for all the reports.
• Performed backend testing by executing SQL Queries
• Interacted with business stakeholders, gathered requirements and managing the delivery, covering the entire Tableau development lifecycle. Testing each report based on the requirements before and after migration, performance monitoring of each object before and after migration.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Created histograms, pie charts, box plots, scatter plots for inventory management and background maps illustrating the potential revenue change.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Involved in Sprint planning, review meetings and various business meetings for requirement gathering.
• Extensively work on various production migrations, interacting with the business and handle UAT process successfully.
• Queried database using SQL to test and validate the tableau reports.
• Scheduling the reports for daily run against the Hadoop environment, monitoring the performance daily.
• Coordinated with various teams in Enterprise Data warehouse and other IT teams and responsible for the whole life cycle of multiple BI migration projects.

Confidential, Woonsocket, RI

MicroStrategy Developer

Environment: Oracle SQL*Plus, Oracle SQL Developer, Agile Scrum, MS-Excel 2010, MS-Word 2010, MS-Office Visio 2010, Windows 7.

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates for the project.
• Designed Components, Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Created recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships.
• Created Consolidations Custom Groups and Prompts for the reports.
• Created Dashboards and Scorecards to provide users the convenience of doing data analysis in a better way.
• Created Data mart reports for dashboards depending upon the requirement.
• Drilling options (Drill up down across) were used to generate adhoc reports.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Documented and reviewed design documents with the team, prototyped and obtained Director feedback at early stages of design, coordinated test plans, and provided feature/functionality/usage scenarios to documentation.
• Assisted the DBA's and the ETL architects to design and create Tables in the Oracle database to achieve the business requirements.
• Developed and implemented Security Roles User Groups and Privileges and Object Security for the developers and End users.
• Implemented Event and Time Based Schedules. Worked with Unix Administrator to monitor jobs that would trigger based on certain conditions and fire Event Schedule to kick off reports.
• Performing QA and production migrations of MicroStrategy objects using Object Manager.

Confidential

Sr. Software Engineer

Responsibilities:

• Gathered requirements directly from the users for future enhancements.
• Prepare for and facilitate project related meetings including: project kickoff presentations, discovery session(s), client status meetings.
• Create mockups and POC’s on user stories for business acceptance and sign-off. Using Microstrategy architect, create metadata and warehouse schema for reporting, attributes, determine hierarchy, metrics and application objects.
• Developed key performance metrics and dashboards to help drive key business decisions through data modeling, reporting and automation.
• Responsible for maintaining and enhancement of automation framework.
• Responsible for coding automation scripts in Java using Selenium Webdriver, junit/testng.
• Working on a complex Hybrid Automation Framework which generally is based on Page Object Model and having an excellent understanding of the same.
• Following ATDD (Acceptance Test Driven Development) process.
• Involved in Knowledge Transfer activities during key product releases.
• Analyse automation results on Jenkins server.
• Engaged effectively in calling with US client and onshore leads.
• Responsible for functional and regression testing.
• Responsible for writing feature files to cover all possible test scenarios.
• Monitoring and tracking of bugs.
• Reviewing, Modifying and sending the Status Report consisting of the Bug reports, defect logs, effort estimates and the other deliverables along with the summary of the entire work done on a weekly basis to the PM.
• Analyzing, reproducing and reporting the bugs online and keeping a track of them using JIRA.
• Stabilizing the Testing Process and updating the repository on a daily basis.
• Involved in Interacting with Onsite team for discussing the business requirements, and clarifications.
• Giving Knowledge Transfer to new team members regarding the specification as well as the testing process and tool used in the project