SUMMARY

• Skilled Technology Professional with 13+ Years of experience with seven plus years of experience in managing and leading DW/BI efforts from requirements gathering to its implementation.
• Extensively worked in various domains like Banking, Finance, Life Sciences, Retail and education.
• Experience withRelational and Dimensional data modeling using ERWIN, understanding ofRalph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach
• Extensively worked on large databases and implemented data optimization practices like indexing and partitioning.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets. strong understanding of Tableau Architecture and Administration experience with Tableau installations, configuration and administration
• Designed and Developed BI reports, Dashboards, Active Reports and visualizations using Cognos, Tableau and MS BI Stack
• Manages full system life cycle for BI projects including analysis and design, construction, testing and implementation
• Drives toward documentation, standardization and automation of BI processes
• System administration skills such as installation and configuration, IIS installation & management, performance tuning, troubleshooting, and configuring client software on Windows, UNIX, and Linux.
• Experience in dealing with Apache Hadoop components likeHDFS, MapReduce, HiveQL, HBase, Big Data and Big Data Analytics.
• Identifies opportunities to improve efficiency, reduce cost, and reduce cycle time
• Relies on experience, organization and judgment to plan and accomplish goals
• Manages workload and achieve results with minimal supervision
• Evaluate new tools and technologies and work on POCs as needed

TECHNICAL SKILLS

BI Tools: Tableau, IBM Cognos Suite, Power BI, SSRS, SSAS

Languages: JavaScript, SQL, PL/SQL, UNIX Shell Scripting, Java2.0, Python

RDBMS: Oracle, MS SQL Server, DB2, Netezza, Teradata

ETL: Informatica, MS DTS

Environment: Windows, UNIX

Modelling Tools: Erwin, ER/Studio

Big Data: Hadoop, MapReduce, HDFS, Hive

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville FL

Sr Consultant

Responsibilities:

• Involved in extensive analysis of source systems, existing database architecture, mapping reporting requirements.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Designed a STAR schema for the detailed data marts and Plan data marts involving conformed dimensions.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Created Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Provide Technical recommendations for optimized data access and retention for the data warehouse and review of Solution architecture, High Level design documents.
• Build repository of reusable knowledge assets and implement best practices, concept documents for client education.
• Identify opportunities for value addition to for effective use of BI applications, Lead aspects of proposal development process, scope out effort and cost of solution, develop statement of work

Environment: Informatica, Oracle10g, SQL Server, JavaScript, Erwin, Tableau

Confidential, Washington DC

Sr Consultant

Responsibilities:

• Conducted/attended requirements definition meetings with end users and document system/business requirements
• Develop an in - depth understanding of the business processes and data in the corporation and apply the knowledge towards developing and maintaining the Corporate Data Model and a Metadata Portal
• Designed and developed mappings using informatica powercenter using various sources such as csv file, SQL Server Database.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Designed and Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Worked on tableau servers to take backups, sending alerts and configuring SAML for authentication.
• Developed data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Worked on defining essential QA metrics and KPI’s to produce trending analysis visualizations.
• Given demos for end users and interacted with them to understand the requirements

Environment: Tableau Desktop 9.3, Tableau Server, Informatica, Oracle10g, SQL Server, JavaScript, Erwin

Confidential, Cambridge MA

BI Architect/Developer

Responsibilities:

• Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts.
• Worked with heterogeneous source to Extract data from Salesforce, XML and flat files and loaded to Oracle warehouse
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Given demos for end users and interacted with them to understand the requirements.
• Implemented best practices in role playing dimensions and row level security at the model level.
• Analyzed underlying data, defined data sources, and designed approach for dynamic cubes.
• Designed and Developed reports, dynamic dashboards for quick reviews to be presented to Business and IT users.
• Developed Python based API (RESTful Web Service) to track sales and perform sales analysis using Flask, SQLAlchemy and PostgreSQL.
• Created advanced analysis like forecasting and trending analysis.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Create and manage Tableau sites, projects and workbooks, groups, data views, data sources and data connections
• Used JavaScript API for advanced filtering and utility functions.

Environment: Tableau Desktop 8, Tableau Server, IBM Cognos Suite, Oracle10g, Informatica, JavaScript, Erwin, Python,Hadoop

Confidential, Chelmsford MA

BI Architect/Developer

Responsibilities:

• Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts.
• Performed installation, configuration and upgrade.
• Delivered multiple projects with challenging design and timelines.
• Given demos for end users and interacted with them to understand the requirements.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Involved in publishing of various kinds of live interactive data visualizations dashboards reports and workbooks from Tableau Desktop to Tableau servers
• Extensively used Tableau features like Data Blending Extracts Parameters Filters Calculations Context Filters Hierarchies Actions Maps etc
• Develop reports, dynamic dashboards using Tableau 9 for quick reviews to be presented to Business and IT users.
• Created advanced analysis like forecasting and trending analysis.
• Conducted Training sessions for Tableau Power users and created the documents for end user support
• Provided technical guidance to junior developers and users.

Environment: Tableau Desktop, Tableau Server, Oracle10g, Cognos Powerplay and Transformer,SQL Server,JavaScript, Erwin

Confidential, New York NY

Senior Technical Specialist/Architect

Responsibilities:

• Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
• Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
• Designed and implemented DMR for multidimensional analysis of relational data which enables the user to slice and dice the data and also drill up and drill down behavior.
• Implemented model based entitlements based out of stored procedure and defined joins across different dimensions to enable the data level security.
• Worked on integrating Cognos with java application using sdk for running and archiving reports for different submissions.
• Implemented customized URL's to launch adhoc templates using business Insight advanced to enable the users to build their own adhoc reports.
• Implemented Dynamic filtering, Dynamic sorting, Javascript to concatenate multiple prompt values to input stored procedure.
• Implemented enhanced functionality collapsible hierarchy using Javascript that expands reports on different columns with better layouts.
• Produced standard reports for various business needs using best approach and fine tuned the performance based on the users need.

Environment: Cognos 10.1.1(Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos SDK, Oracle10g, Cognos 10 Powerplay and Transformer, Business Objects, Javascript

Confidential, Washington DC

Cognos Consultant

Responsibilities:

• Cognos 10 installation and configured IIS, content store (Sql server database), security (namespaces), webserver setup. Followed best practices in configuring the server and setting up the environment.
• Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
• Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
• Created custom views in framework manager to give multi dimensional analysis on their relational database.
• Created multidimensional model using transformer based on calculated measures and budget system taxonomy and published a cube package based on that.
• Applied row level security to restrict users from accessing data based on their entitlement.
• Tuned the performance of the model using governor settings and removed loop joins by creating shortcuts.

Environment: Cognos 8.4(Report Studio, Analysis Studio), Cognos Connection, Framework Manager, Cognos SDK, SQL Server, SSRS

Confidential, Newark NJ

Cognos Consultant

Responsibilities:

• Tuned the performance of the model using governor settings and removed loop joins by creating shortcuts.
• Created model based calculations, filters and various relationships to make it feasible for the report authors.
• Created complex reports using Report Studio, Analysis studio.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts (Pie Charts, Column Charts, Bar Charts, Line Charts), Drill through Reports and Master Detail Reports using Report Studio.
• Built Customized Charts like age analysis and trending, Enhanced Report Layouts
• Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, SQL Server2k databases.
• Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Environment: Cognos 10.1.1(Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos SDK, SQL Server, SSRS

Confidential

Report Developer/ Metadata modeler

Responsibilities:

• Worked closely with the users, Business Analyst in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
• Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
• Created Models using star schemas and snowflake schemas, Packages using Framework Manager. Published and managed packages.
• Built models containing query subjects, query items, and namespaces and analyzed model with Model Advisor.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Fine tuned SQL queries and reports for performance.
• Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, Netezza.
• Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Worked with Cognos tech support team to resolve various issues.

Environment: Cognos 10, Cognos Suite 8.4(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, Cognos VVM), Cognos SDK, Toad 8, Oracle10g, Netezza, IBM DB2, Cognos 8.4 Powerplay and Transformer, Javascript, Microstrategy

Confidential

Business Intelligence/ Report Developer

Responsibilities:

• Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Creating the Cubes based on the requirements and creating the drill through reports for the cubes
• Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through Developed Combine Filter, User-Defined Filters, Custom ranking using Analysis Studio
• Created Drill down / Drill Up reports using Analysis Studio
• Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
• Tuning the performance of the Cognos Cubes and publishing Cubes on to the Powerplay Enterprise Server.
• Closely worked with data warehouse designers to refine data and metadata.

Environment: Cognos Suite 8.1(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager), Cognos SDK, Cognos PowerPlay7.3, Cognos Transformer7.3, Teradata, Windows 2000, Business Objects

Confidential

Cognos Developer

Responsibilities:

• Planned and Created professional reports in Report Studio.
• Schedule, Monitor and Control access by creating groups, roles etc. using Cognos Connection.
• Created Folders to store conditions, calculations, and catalog prompts.
• Publishing Cubes and Impromptu Web Reports on to the server.
• Created reports using Cognos Impromptu, Transformer, Power Play, Power Prompts and Visualizer.
• Designed, developed, and tested Power cubes and deployed them in to production.
• Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
• Worked on Cognos Security Administration to Create, Maintain and Restrict the Users.
• Created Reports, list prompts and drills through reports.
• Creation of Model definition, calculated measures, multiple cubes and cube groups in Power Play Transformer.
• Uploading the Data Changes and application to the Production and Staging environments.
• Involved in Data mapping between multiple data transaction systems. Database triggers, Sequences, Indexes and fact tables were widely used in providing data integration and security.

Environment: Report Net 1.1(Framework Manager, Report Studio, Query Studio, Cognos Connection), CognosImpromptu 7.3/7.1/7.0/6.0 , CognosPowerplay 7.3/7.1/7.0/6.0 , Cognos Transformer 7.3/7.1, SQL Server 2000 and 2005, Cognos Visualizer 7.3/7.1, SQL Query Analyzer, SQL Enterprise Manager, IWR, Unix, Windows 2003.

Confidential

Developer

Responsibilities:

• Creation of Model Definition Using Transformer.
• Created the catalogs for the users and managing & testing of catalogs with Cognos Impromptu.
• Created the reports for sales of the different products for different regions and demands for future forecasting.
• Used MS Analysis to build multidimensional cubes and used it in Metrics analysis to build graphs and charts of sales data.
• Performance tuning- tuned power cubes to reduce calc time and partitioned cubes.
• Creation of standard filters, calculations, prompts and conditions in catalog.
• Exception highlighting. Created Reports, list prompts and drill through reports.
• Customizing cube content with views (Suppress, Cloak, Filter, Summarize)
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using MS DTS ETL tool.
• Developed ETL mappings, transformations, Packages using MS DTS.
• Maintained stored definitions, transformation rules and targets definitions using repository Manager.

Environment: MS-SQL Server 7.0/2000, Cognos Impromptu7.0, MS DTS, MS Analysis Services, IWR, MS-OLAP Services and Windows NT, Cognos ReportNet