SUMMARY:

• Offers 9 years of experience in the field of Database development & Business Intelligence (Governance Risk Compliance /Finance/Advisory /ITSM/Retail) Tools such as SSRS and SSIS. 10 months of Onsite Experience as Technical Lead ( Minneapolis and Baton Rouge, USA)
• Solution oriented, working with teams and demonstrated excellence in building complex scripts and queries. Applied technical skills using MicroStrategy, Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
• Strong background in database design and development. Disciplined in the iterative solution development methodology and agile methodology to convert user requirements into report design and functionality. Extensive experience in creating dashboards in Tableau and MicroStrategy. Designed & deployed ETL solutions, imported data from OLTP, flat files, or other data sources & created data flow solutions to cleanse & validate data. Inserted and/or updated newly cleansed & validated data into OLTP or OLAP databases. Involved in Migration Projects.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart. Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) & Calculated fields, Joins, data Blends and Level of Detail (LOD) expressions using Tableau Desktop. Expertise in performance tuning of Tableau reports and dashboard.
• Expertise as MicroStrategy Architect in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) and also Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports. Strong knowledge of Intelligent Cubes and view reports
• Expertise in Microsoft Business Intelligence (MS BI) technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL server database management studio 2005/2008/R2 and SQL Server Data Tools (2012) with strong knowledge on SQL and TSQL concepts.
• Strong understanding of MicrosStrategy advanced architecture including data marts, multi - sourcing, fact level extensions attribute roles (table aliases/table views/logical views), partitioning, hierarchies, slowly changing dimensions , data warehouse optimization techniques and VLDB properties .
• Extensively used MicroStrategy Reporting Services to generate Report Documents. Involved in defining and designing the Report Templates. Created various Monthly dynamic dashboard documents for clients with multiple panel stacks, selectors and customized widgets. Developed complex database objects like Stored Procedures, Functions, Packages, Views and Triggers using SQL and PL/SQL. Created data models using ERwin. Was responsible for the development of HTML launch pages and reporting templates containing about many individual reports. Involved heavy use of advanced Graphing capabilities within WebFocus.
• Resilient & Adaptable to any new environment with a strong desire to keep pace with latest technologies. Demonstrates Accountability & Collaborates well with stake holders. Imparted technical trainings to Enterprise BI team members.
• Knowledge of Big data technologies like Hadoop, MapReduce, Hbase, Pig, Hive, ZooKeeper, Sqoop

TECHNICAL SKILLS:

Tools: Oracle 9i/10g /11g, SQL Server Management Studio, Netezza

Business Intelligence Tool: Micro Strategy, Tableau, Web focus

Test & Defect Management Tool: HP Quality Center

Operating System: Microsoft Windows 98/NT/2000/XP/7, Unix

ERP: ECP5.1/5.5

Scripting Language: JavaScript, Velocity, R, Perl

Web technology: HTML

Programming Language: C, SQL, PL/SQL, C++

Tools: SQL*Loader, SQL*Plus, Toad, MS BI - SSRS, SSIS, SQL, T-SQL.

Data Modeling Tool: ERwin

Big Data Technology: Hadoop , MapReduce, Pig, Hive, Sqoop, Zookeper,, Hbase

PROFESSIONAL EXPERIENCE:

Confidential

Lead Architect

Responsibilities:

• Lead the BI Team. Performed extensive GAP analysis in the project.
• Deep business intelligence experience --Architect, design, & prototype solutions in Microstrategy products to support business strategies, deliver business value utilizing agile methodologies. Owned all technical aspects of software development for assigned applications; Performed hands-on architecture, design, and development of systems Good understanding of ROLAP Star Schema modelling, Snowflake modelling, Fact, Lookup Tables, Physical and Logical Data Modelling.
• Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) and Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports
• Strong knowledge of Intelligent Cubes and view reports
• Strong understanding of Microstrategy advanced architecture including data marts, multi-sourcing, fact level extensions, attribute roles (table aliases/table views/logical views), partitioning, hierarchies slowly changing dimensions, data warehouse optimization techniques and VLDB properties.
• Developed critical SSRS reports using T-SQL stored procedures and complex SQL queries with custom coding for dynamic parameter change and formatting
• Provided technical assistance to team. Analysed the business requirements and Change Requests and estimate the development efforts required. Suggested process enhancements for better software practices, wherever required.
• Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications. Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.

Environment: & Tools: Tableau 8.x/9.x, MicroStrategy Architect, MicroStrategy Desktop 8.x/9.x, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Power BI, Oracle 11g/10g/9i, Netezza, MS BI (SQL Server SSRS/SSIS) 2012, Teradata V2, Erwin Data Modeler 4.1, Windows 2000/NT and UNIX.

Confidential

Lead Developer

Responsibilities:

• Lead the BI Team. Performed extensive GAP analysis in the project.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently. Built, published and customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters. Developed Tableau visualizations and dashboards using Tableau Desktop. Developed Tableau workbooks from multiple data sources using Data Blending.
• Created metrics, attributes, filters, reports, and dashboards; created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• Deep business intelligence experience --Architect, design, & prototype solutions in Microstrategy products to support business strategies, deliver business value utilizing agile methodologies. Owned all technical aspects of software development for assigned applications; Performed hands-on architecture, design, and development of systems Good understanding of ROLAP Star Schema modelling, Snowflake modelling, Fact, Lookup Tables, Physical and Logical Data Modelling.
• Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) and Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports
• Strong knowledge of Intelligent Cubes and view reports
• Strong understanding of Microstrategy advanced architecture including data marts, multi-sourcing, fact level extensions, attribute roles (table aliases/table views/logical views), partitioning, hierarchies, slowly changing dimensions, data warehouse optimization techniques and VLDB properties.
• Transformed Tableau into a managed service offering for consumption across corporate reports. Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. Technical Lead for Business Intelligence and Reporting Projects.
• Provided technical assistance to team. Analysed the business requirements and Change Requests and estimate the development efforts required. Suggested process enhancements for better software practices, wherever required.
• Identified all the risks and issues in the project and updated the project Risk Management Plan on time, and also escalated to all stake holders whenever required.
• Update the project management group with weekly status reports and through weekly Insight status update meetings.
• Responsible for Scheduling the project schedules, monitoring the status of work progress and guidance to the team

Confidential

Lead Developer

Responsibilities:

• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications. Created lot of custom reports for the Confidential using complex stored procedures.
• Deep business intelligence experience --Architect, design, & prototype solutions in Microstrategy products to support business strategies, deliver business value utilizing agile methodologies. Owned all technical aspects of software development for assigned applications; Performed hands-on architecture, design, and development of systems Good understanding of ROLAP Star Schema modelling, Snowflake modelling, Fact, Lookup Tables, Physical and Logical Data Modelling.
• Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) and Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports
• Strong knowledge of Intelligent Cubes and view reports
• Strong understanding of Microstrategy advanced architecture including data marts, multi-sourcing, fact level extensions, attribute roles (table aliases/table views/logical views), partitioning, hierarchies, slowly changing dimensions, data warehouse optimization techniques and VLDB properties.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (8.x/9.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security. Created and developed parameterized, drill down and adhoc Reports.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.

Environment: & Tools: Tableau, MicroStrategy Architect, MicroStrategy Desktop 9.X / 8.x, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, MS BI (SQL Server SSRS/SSIS) 2008/2012, Teradata V2, Oracle 11g/10g/9i, Erwin Data Modeler 4.1, Windows 2000/NT and UNIX.

Confidential

Lead Developer

Responsibilities:

• Technical Lead for Business Intelligence and Reporting Projects.
• Provided technical assistance to team. Involved in collecting and documenting business requirements from end clients and translating them into report specifications. Designed and developed Data Marts using SSIS packages. Created Dashboards using Tableau and MicroStrategy. Suggested process enhancements for better software practices, wherever required.
• Updated the project management group with weekly status reports and through weekly Insight status update meetings.
• Lead the change control and review management meetings. Responsible for scheduling the project schedules, task allocation, monitoring the status of work progress and guidance to the team. Extensively worked on creating weekly, monthly and yearly sales reports.
• Involved in Dimensional Modelling by selecting the business process, declaring the grain, and choosing the dimensions and facts. Contributed towards Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Created Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) and calculated fields, Joins, Blends and Level of Detail (LOD) expressions using Tableau Desktop.
• Developed Schema Objects (Facts, Attributes, Hierarchies and Transformations) using MicroStrategy Architect. Created Public Objects like Metrics, Filters, Prompts, Consolidations, Custom Groups, Drill maps and Templates.
• Deep business intelligence experience --Architect, design, & prototype solutions in Microstrategy products to support business strategies, deliver business value utilizing agile methodologies. Owned all technical aspects of software development for assigned applications; Performed hands-on architecture, design, and development of systems Good understanding of ROLAP Star Schema modelling, Snowflake modelling, Fact, Lookup Tables, Physical and Logical Data Modelling.
• Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) and Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports
• Strong knowledge of Intelligent Cubes and view reports
• Strong understanding of Microstrategy advanced architecture including data marts, multi-sourcing, fact level extensions, attribute roles (table aliases/table views/logical views), partitioning, hierarchies, slowly changing dimensions, data warehouse optimization techniques and VLDB properties.
• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces. Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps. Involved in migration of Excel reports to Micro Strategy documents. Developed Intelligent Cubes in version 9.x to slice and dice the data. Tuning MicroStrategy Intelligence Server for better performance
• Extensively used MicroStrategy Report Services to generate Report Documents. Involved in defining and designing the Report Templates. Created various Monthly dynamic dashboard documents for marketing people with multiple panel stacks, selectors and customized widgets.
• Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
• Understanding the type of schemas that best support MicroStrategy in different scenarios
• Developed dashboards/ scorecards for quick and easy visualization.

Environment: Tableau, MicroStrategy Architect, MicroStrategy Desktop 9.X / 8.x, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Teradata V2,Oracle 11g/10g/9i, Erwin Data Modeler 4.1, SQL Server, SSIS, SSRS, Windows 2000/NT and UNIX

Confidential

Developer

Responsibilities:

• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Involved in Data modeling on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases. Involved in creating the functional Specification document, technical design documents and designed mock-up screens as per specification.
• Developed complex database objects like Stored Procedures, Functions, Packages, Views and Triggers using SQL and PL/SQL and worked on performance tuning of the DB objects. Worked on performance tuning of the stored procedures, functions and packages and SQL queries used in reports. Designed forms, Reports, Dashboards, Email API and Business logic for forms which takes HTML templates and replaces the placeholders and sends it to appropriate owner.
• Installed and upgraded MetricStream hosted application for the customer. Created Installers for clients. Created PDF, Open Office (Word, Excel) reports. Designed schedule alerts and on demand alerts by using MetricStream Application. Played active role to interact with other teams like Platform team and documentation team to complete the project on time.
• Trained Business Users on the application.

Environment: &Tools: ECP 5.1/5.5, SQL, PL/SQL, Oracle 11g/ 10g/9i/8i, Toad, SQL Developer, ERwin, HTML, JavaScript.