SUMMARY

• Over 9+ years of Experience in Designing, Architecture, Administration, Analysis, Management in the Business Intelligence Platforms, Data Warehousing, Client Server Technologies, Web - based Applications and Databases and Experience in industries such asRetail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering.
• Excellent team player with good interpersonal and communication skills.
• Ability to work under pressure in a fast-paced, competitive customer sensitive environment for improved performance, greater flexibility, and reduced overhead.
• Experienced in Data Warehouse Life Cycle: requirement analysis, understand trade-offs between different schema designs and their implementation, worked with DBA to implement data models in RDBMS and support enhancements.
• Define / Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications.
• Familiarity with LookML and Looker visualizations
• Fluent in SQL, experience with relational and dimensional data modeling a,. proficiency with Kimball design principles.
• Strong communication skills, confidently representing your expertise to peers and stakeholders across the organization
• Self-motivated, working independently, intrinsic learner
• Command of the English language, both written and spoken
• Coordinates with project managers and participates in project planning
• Work / Propose solutions to various challenges with data: different granularity, data gaps, complex matching logic, multi-language, structured & unstructured; harmonization & normalization of data.
• Worked in Designing Staging of ODS, ERP Applications' extract for Enterprise Data Warehouse / Data Mart / Data Lake (on Premise & Cloud) and assisted Data Warehouse Architect in Design/Dimensional Data Modeling (Conceptual, Logical and Physical) of the Data Warehouse Data Storage Strategy / Technique and implementing the best practices for efficiency and optimization.
• Worked / Assisted in planning, developing, implementing and managing data warehouse project deliverables, high level mapping for ETL specifications, working for alternatives and best practice approaches and mentoring / coaching to team members and client staff.
• Over 7+ years of experience in Data Visualization Applications - Tableau Enterprise / MS PowerBI / QlikView Enterprise (QlikView / QlikSense / N-Printing) in latest Design and Presentation.
• Worked in overseeing the overall infrastructure of Enterprise Information Management / Data Quality Management for Enterprise Solutions / Applications.
• Worked ln the development, analysis, modeling (Conceptual, Logical and Physical), design, and development of BI reports and dashboards reports for the Key Performance Indicators for the top management for analytics.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.
• Worked as a Point of Contact in data Interoperability, Analytics and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), Reports / Dashboards for all the functional areas including Supply Chain Management (SNC), Supplier Network Collaboration (SNC), Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain and Transportation, Sales/Marketing, Variable Objects with formulas.
• Worked as administrator / architect performing responsibilities not limited to Installing Configuring and Administration of BI / Data Visualization Product Suites - Tableau Server, Qlik Enterprise, SAP BI Platform, Spot fire, MS PowerBI etc.,
• Thorough knowledge of Cognos administration, tuning and report-writing, data warehousing and BI architectures, user administration, report development, data modeling, and integration, system software, and hardware configuration and updates, Cognos testing and troubleshooting
• Proficiency in using IBM Cognos BI Suite and components such as cognos connection and Query, report, event and analysis studios; Cognos TM1 and SDK, Cognos BI 10.2.2 documentation, IBM Cognos Analytics 11.0, ETL-SQL Server, Cognos 10.X Framework Manager
• Clear understanding of Cognos BI 10 and 11, Cognos Framework and Cube development, networking, relational and OLAP database designs, KPI dashboard development, BI documentation
• Experience with MS Office Suite as well as programming languages such as SQL, Java, C++, HTML and JavaScript, Windows and Linux OS
• Ability to gather business or user requirements and develop and maintain reports using Cognos 10 and 11
• Strong analytical skills with the ability to solve complex Cognos BI and performance issues
• Effective communication and presentation skills along with the ability to provide technical support to team members and clients
• Solid leadership and mentoring skills as well as the ability to work independently and in cross-functional teams
• Extensive knowledge onQlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server.
• Experienced in Nprinting installation, deployment and development of reports using nprinting.
• Expertise in deployment of dashboards in QMC, task scheduling and triggering, CAL Management and section access; involved in bouncing the QlikView servers and maintaining stability; involved in server setup, installation of QlikView and nprinting servers.
• Experienced in migrating QlikView server from virtual to physical servers and involved in scripting for restart and backing up PGO files.
• Experienced in working closely with key business partners to gather business requirements, understand them and transform into visual - interactive dashboards.
• Experienced on database such as creation of data models, Star schema, snowflake schema, users and their security access levels.
• Designed and implemented proof of concepts for clients in the financial sectors.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Sound knowledge in writing SQL Queries, PL/SQL Stored Procedures.
• Develop data models, reports and dashboards from ideation through production
• Integrate and transform data for analysis using SQL, ETL tools and API integrations
• Validate data to ensure accuracy
• Provide guidance to clients on optimizing their data environment
• Work with clients (product managers, marketers, engineering team) to define requirements, establish priorities, offer solutions, and execute development
• Perform technical and business user
• Strong organizational skills as well as the ability to perform multiple tasks simultaneously and complete projects under specified deadlines

TECHNICAL SKILLS

Languages: T-SQL/SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script, Python

Data Visualization / BI Applications: Tableau 2020 APR., v11/v10/v9/v8/v7, MS PowerBI, PowerQuery, Cognos 8.4/8.3/8.2, SAP Business Objects Enterprise - Web Intelligence, BO Design Studio SAP Lumira, Crystal Enterprise, MS SSRS / SSAS, OBIEE, SpotFire, Qlik Enterprise, IBM Cognos 8.4, 11, 11.2

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access, SAP Hana 1.x / 2.x, Snowflake, Amazon Redshift, PostGre SQL

Data Modeling Tools: Microsoft Visio, UML, Erwin, ER Studio

EIM / ETL: Alteryx 2020.x / 2019.x / 2018.x, SAP EIM, Alteryx, Microsoft SSIS / DTS

PROFESSIONAL EXPERIENCE

Sr. Looker Architect /Visualization Lead

Confidential, PA

Responsibilities:

• Looker development with snowflake as backend, best practices.
• Strong experience with LookML models, looks, and dashboards.
• Proving architecture plan for new looker migration project.
• Strong expertise in creating development plan.
• Configure new connection in support with the Looker admin.
• Dataset or view validation to pull a new table.
• Familiarity with Looker's shared consumption portal and features
• Evangelize the democratization of data via sessions and Looker hours
• Develop, Design and Support Interactive dashboards, reports, and exception Reports
• Provide production support for looker dashboards and reporting solutions along with performance tuning.
• Translate business requirements into efficient visualizations and reporting.
• Capability to enable users to interact with the data and develop their own data insights using Looker
• Exposure to Basic looker admin activities and associated testing.
• Ability to facilitate and coordinate discussion and to manage expectations of multiple stakeholders
• Contribute to new offering innovations and the general advancement of reporting capabilities
• Attend stakeholder business requirement meetings to understand the process flow
• Assist in establishing and refining standards for enterprise reporting
• Develop and deploy dashboards, visualizations and autonomous and dynamic reports using various technologies
• Maintain existing and future report distributions
• Generate data extraction, summarization and ad-hoc query requests as required by the business reporting environment
• Enhance existing processes utilizing best practices and the latest technologies
• Manage technical issues, tasks, and timelines
• Perform troubleshooting and provide resolutions to reporting issue
• Solve technical and data related problems to meet the needs of the business
• Prepare and maintain documentation for reports, metrics, and processes
• Provide feedback on the effort, risks, and resources necessary on potential project initiatives
• Examine the needs and concerns of Analytical Leads to determine opportunities or problem areas and provide feedback in the development of policies, procedures, methods and/or standards
• Develop and maintain constructive and cooperative working relationships with corporate Team Members and various departments within Confidential .
• Attend internal and external meetings and address topics of analysis and reporting
• Research and respond to information requests from internal departments, external departments, Supply chain and management
• Developed interactiveTableauvisualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• StretchedTableaulimits to create unconventionalTableaucharts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Worked on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
• Implemented data blending and joins to work with data from multiple databases in a single report.
• Implemented Data Representation using Visualization Techniques inTableau(Graphs, Charts etc.)
• Involved in Data modeling, designing, and building relational databases.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Understood underlying Data and reworked Data Analysis with PowerBI.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Developed & Implemented Reports usingTableauServer.
• Extensive experience in handling Internet Information Server (IIS), Creating and configuring the virtual directories, map them to physical folders and configuration of the applications for domain authentication.
• Responsible for QlikView Server and Publisher maintenance - Creating tasks, scheduled jobs for QVD extracts and report reloads.
• Involved in Installation QlikView 12.0 SR5, Nprinting 16/17 in both publisher and server.
• Involved in testing dashboards of Qlikview 11.2 version to migrate it to Qlikview 12.1.

Business Analyst/ Bi Developer

Confidential, PA

Responsibilities:

• Design solutions that align with the firm’s data management principles, policies, standards and best practices
• Translate requirements and generate and develop a roadmap utilizing the best technologies for the project with comprehensive and obtainable milestones
• Develop and deploy dashboards, visualizations, and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform, web portal, mobile, tablet devices, widgets, and email
• Optimize report distribution, execution, and the scalability of all reporting solutions so they are autonomous and dynamic
• Work with the Data Management team to provide input on logical and physical database design, data modeling and/or mapping
• Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as Microsoft SQL Server, Oracle, and Netezza
• Develop deep knowledge of the hospitality industry and understanding of the business needs of the various stakeholders within Confidential (including Hotel Analysts, eCommerce team and Revenue Management)
• Work with various Team Members, internal departments and third-party agencies on report business requirements, documentation, timelines, testing, and technical delivery
• Worked in delivery of end-to-end Data Solutions - Data Analytics, Business Intelligence, Data Cleansing, Data Processing, Master Data Governance / Management for large scale Data Conversions / Migration implementations and Data Mining
• Worked in delivering end-to-end BI and Data Solutions can plug as needed and that can work full projects (from requirements gathering to back-end development through front end tableau development.
• Experience in understanding project specifications, overseeing deliverable preparation and extensive client engagement
• Worked as Architect to Model and Implement the new Enterprise Data Warehouse, Entity Relationship Diagrams (ERD) using Data Modelling Applications like ER-Studio / Erwin.
• Experience in Developing Performance Dashboards, Scorecards, Metrics, analysis, Prompts, Drills, Search (using Add-ons), Reports / Dashboards for cross-functional areas including Supply Chain Management (SNC), Supplier Network Collaboration (SNC), Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain and Transportation, Sales/Marketing, Variable Objects with formulas.
• Design and implement effective database solutions and models to store and retrieve data
• Examine and identify database structural necessities by evaluating client operations, applications, and programming
• Assess database implementation procedures to ensure they comply with internal and external regulations
• Prepare accurate database design and architecture reports for management and executive teams
• Worked with Relational Databases such as (Oracle, MS SQL Server, Teradata, Sybase ASE, DB2 UDB, etc.,), in-Memory Databases (SAP Hana), Cloud DB / DW (Snowflake DW) & Columnar databases
• Worked in critical problem solving and written / verbal communication across the Organization and Teams.
• Worked closely with constituents across the business (Sales, Marketing, Product, Customer Experience, Research and Finance)
• Design/Develop mappings/workflows, Data Analysis and reverse engineering of data model, Data preparation with SQL Scripting in Alteryx.
• Support the System Integration testing by fixing the bugs.
• Support the end-to-end integration testing by comparing the data in the reports with the source system to find out the mismatches; and find its root cause.
• Support the User Acceptance Testing by addressing any technical queries or fixing the bugs, if any.
• Co-ordinate with the source systems for any data mismatches.
• Development, Testing and Data Validation of in Alteryx/Incident/Change Request implementation in Production Environment
• Worked in Scale-Up / Scale-Out of Alteryx Server for high availability, high performance.
• Experience in delivery of Complex dashboards using Tableau for the daily and weekly reports for Business and Operations teams.
• Handled Tableau Server Administration, Role Assign and Interaction to user groups based on business requirements and manage schedules, Project/Site creation, Application / Dashboard Publishing in Tableau Server.
• Worked in generating dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL server and Microsoft Analysis Services.
• Worked in an Fast-Paced Agile environment and were able to bring structure
• Worked in interpret data from multiple sources, understand & propose data integration logic for Agile ROI, Marketing Mix etc.,
• Coordinates with project managers and participates in project planning
• Worked in Fast-Paced Agile methodology, ability to define and implement prototypes and MVPs.
• Experience implementing Tableau Server or other Business Intelligence platforms
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies, List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio, Data Blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, SQL Server, NOSQL DB - MongoDB and HDFS.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Lead the Tableau migration project from On-Prem to Google Cloud Platform (GCP) and also upgrading Tableau to version 2019.4
• Handled Tableau admin activities like security, user creation, granting access, permissions, managing extracts, patches, backup, upgrades and installations.
• Analyzed massive amounts of data using Tableau and Big Query and published to Tableau Online for users to view and interact.
• Created executive dashboards that clearly tells the story of how the different divisions of BAO financial group is performing and to assist the executives to make appropriate business decisions.
• Installation and configuration of high availability Tableau Server Cluster(Primary, Worker, Backup Primary) and its processes (VizQL Server, Application Server, Data Server, Data Engine, Background Tasks, Gateway and Repository).
• Responsible for building Data Pipelines with JAVA and SQL that consume and transform the end customer’s data received in CSV format and feed it downstream into various data sources including Google Big Query.
• Activated Tableau server management add-on in the production Tableau server and used tools like Tableau Resource monitoring tool to identify issues that cause slow load times, extract failures and other critical issues.
• Used Tableau content migration tool to copy or migrate content between Tableau Server projects, sites and deployments.
• Created Tableau extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insight into large data sets.
• Defined the purpose and audience, rough sketch the plan, build and test interactive dashboards and applied visual best practices.
• Migration of ETL mappings from Informatica to Talend Cloud. Performed performance tuning of data integration jobs in Talend
• Processing, design and development of Dashboards/Reports for order Status in Power BI Desktop.
• Experienced in Publishing the Dashboards/Reports to Power BI Service.
• Expert in providing the Security to the Power BI Dashboards/Reports, Cubes and SSIS Packages.
• Testing the developed Dashboards/Reports was as per the requirements.
• Involved in Creating Workspaces in Power BI service.
• Providing the Privileges on Dashboards/Reports to appropriate users.
• Publishing Apps Power BI services and providing access to appropriate users.
• Sharing the Dashboards/Reports among the members within the organization.
• Experienced in Creating and Publishing the Models and Publishing those models into Power BI Service.
• Looker development with AWS Athena(S3), as backend, best practices.
• Strong experience withLookMLmodels, looks, and dashboards
• Familiarity with Looker's shared consumption portal and features.
• Evangelize the democratization of data via sessions and Looker hours
• Develop, Design and Support Interactive dashboards, reports, and exception Reports
• Provide production support for looker dashboards and reporting solutions along with performance tunings.
• Communication with the Looker end user with the system explores.
• Translate business requirements into efficient visualizations and reporting
• Capability to enable users to interact with the data and develop their own data insights using Looker
• Exposure to Basic looker admin activities and associated testing
• Ability to facilitate and coordinate discussion and to manage expectations of multiplestakeholder.

Environment: Looker, Tableau Server 2020.x/v10/v9/9.2, MS PowerBI, Power Query, Alteryx, Cognos 8.4, SAP Hana 1.x, MS SQL Server / 2008 R2, Amazon RedShift, MongoDB, Kafka, Cloudera, Python, Hadoop (Cloudera), Hive, Impala, Angular JS, Java Script.

ETL Developer/ Data Analyst

Confidential, NJ

Responsibilities:

• Documented complete server architecture and solutions to troubleshoot performance, scheduling and server related issues.
• Experience in Tableau as an administrator, including providing installation, administration, configuration, maintenance, performance monitoring, tuning support, providing general systems administration support, including patching, monitoring and experience with tabcmd and tabadmin command utilities, Tableau server licensing mechanism.
• Worked with security auditors and Tableau team members to document ATO requirements and translate them into technical solutions
• Manage application users, groups, Workbooks and Projects, Database Views, Data Sources, Data Connections and integration with Active Directory
• Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications
• Coordinates with project managers and participates in project planning
• Interfacing with other security compliance individuals and ensuring the project’s security controls are properly documented.
• Created incremental refreshes for data sources on Tableau server, developing / tuning of ETL process to Extract, Transform and Load the data into stage area and data warehouse using SSIS, SAP BODS and home grown ETL Processes not limited to DTS, Analysis Manager, Alteryx.
• Involved in migrating data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL server and Microsoft Analysis Services.
• Worked and trained in handing Privacy Data Sources following compliance standards HIPAA, PCI and OWASP
• Working knowledge of HL7, FHIR and related standards.
• Exposure to Analytics and Big Data platforms
• Experience implementing Tableau Server or other Business Intelligence platforms
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, SQL Server, NOSQL DB - MongoDB and HDFS.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Processing, design and development of Dashboards/Reports for order Status in Power BI Desktop.
• Experienced in Publishing the Dashboards/Reports to Power BI Service.
• Expert in providing the Security to the Power BI Dashboards/Reports, Cubes and SSIS Packages.
• Testing the developed Dashboards/Reports was as per the requirements.
• Involved in Creating Workspaces in Power BI service.
• Involved in Design and Documentation for the EU-Payments.
• Providing the Privileges on Dashboards/Reports to appropriate users.
• Publishing Apps Power BI services and providing access to appropriate users.
• Sharing the Dashboards/Reports among the members within the organization.in Creating and Publishing the Models and Publishing those models into Power BI Service.

Environment: Tableau Server v9/9.2/v8/8.2/v7, MS PowerBI Windows Server Standard R2, Excel, SQL Server management studio, Alteryx, Cognos 8.4, SAP Hana 1.x, MS SQL Server 2008 R2, PostGre, MongoDB, Kafka, Node JS, Java Script, Cloudera, Python.

Data Analyst/Tableau Developer

Confidential, Lyndhurst, NJ

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Provide infrastructure and platform sizing for projects, including hardware and software requirements, plan, design, and execute performance tests of platforms
• Analyze, troubleshoot, and/or fine-tune product performance or deployment issues when required
• Develop and document technical architecture, system designs, performance test results, and other technical aspects of implementations
• Define and/or offer guidance on best practices during implementation and integration of the Tableau platform
• Strong technical background with complete understanding of data warehouse modeling, architectures, OLAP, OLTP data sets, etc.
• Solid knowledge and experience with Windows Server and networking technologies
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs least users.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program managers and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static data sets.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Set up Alteryx server & managed server/configurations
• Set up User Managed (MongoDB Replica)
• Create Identity Access Management, Users, Groups & Multifactor Authentication
• Create VM in MS Azure
• Create and place Alteryx server on MS Azure VM
• Create Alteryx workflows with advanced analytics
• Create analytical application in Alteryx designer and store on Alteryx server for non - technical user
• Create In-database Alteryx workflows and data preparation for visualization in Tableau & Power-BI
• Create ETL between different data warehousing such as snowflake & Redshift via Alteryx workflow
• Create working using API as a data source and utilizing connectors for better data ingestion.
• Utilize R to create Arima and exponential smoothing models
• Facilitate in creating tableau visualization dashboard and enable the data to tell a story
• Managed & create database snowflakes data warehousing on azure VM

Environment: Tableau Desktop 8, Tableau Server, Business Objects, Cognos Report Net 1.1, Cognos 8.3 BI Modeling, Oracle, Crystal Reports, Windows Server 2008. Cognos 8.3(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.3(Impromptu, PowerPlay Transformer), Oracle10g, Cognos SDK, SQL Server 2005, Windows 2003 Server.

BI Consultant - Tableau/ Alteryx Developer

Confidential, Farmington, CT

Responsibilities:

• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed. Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance. Developed different kinds of reports (pivots, charts, tabular) using global and local Filters. Design various reports, i.e. Drill down, Pivot, Narrative Reports inOBIEEAnswers.
• Implemented Prompts to provide dynamic filter condition to End users. Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.
• Designed and developed Performance Measurement Dashboards/ Reports that are Dynamic & Interactive with drilldown, drill across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
• Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders.
• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE11g.
• Providing object level security for different web groups based on responsibilities Understanding the Business requirements, Involved in Designing and Configuration of Business Intelligence Server Repository as per Business Needs.
• UsedOBIEEAdministration Tool for Customizing and modifying the physical, business model, and presentation layer of the repository. Working onOBIEEAnswers to create the reports as per the client requirements.
• Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.
• New KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI Layer on DW for Tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked in Admin Tasks using Restful APIs.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Worked extensively with Tableau Business Intelligence tool to develop various dashboards.
• Worked extensively using Excel to validate the data and use as the source data files.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Cognos Admin:
• Assisted senior admins and developers in implementing effective Cognos BI and relate analytical solutions as well as provided support in the designing and deployment of new reports and modification of existing ones as required
• Installed, upgraded, and maintained security of all Cognos BI components, software applications and systems and monitored and controlled server usage as required as well as implemented and documented best practices of Cognos infrastructures
• Supported BI application implementation and Cognos deployment and upgrades in a clustered environment as required as well as migrated project changes from development to UAT and from UAT to production
• Allowed users access to Cognos namespaces and related software or applications as required as well as configured databases for multilingual reporting using IBM Cognos Analytics
• Communicated various Cognos system performance issues with BI teams in a timely manner and recommended service improvements as required as well as provided technical support and consultation for system or application usage and maintenance to users

Environment: Tableau Desktop 6.0.2, Excel, Oracle), Windows Server 8, Windows 7, IBM Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.4 (Impromptu, Powerplay Transformer and all Server Administration), SQL Server 2005, Oracle 10g, Windows server 2003, Rational Clear Case, Clear Quest.

BI Consultant - Tableau Developer/ Alteryx Developer

Confidential, Princeton, NJ

Responsibilities:

• Worked as an End-to-End QA Tester for PLA projects, Web (eAuto and eHome) and Mainframe Applications.
• Setup 6 testing environments to facilitate the testing process.
• Identified and Documented Projects Risks, Dependencies, Issues and Assumptions.
• Analyzed Business/System Requirements and involved in developing Test Plans and Test Cases.
• Reviewed the BSM (Business Scope Management) report to understand the scope and benefit of the projects
• Attended the BRI (Business Requirement Identification) meeting to understand the business Requirements.
• Reviewed the TRD (Technical Review Document) from developer and prepare the TDR (Technical Data Review) document with detail objectives (test cases).
• Implemented WEB projects eAuto, eHome and Agent Dashboard (eCommerce) projects.
• Involved in P&C Auto and Property Billing Application (ASB and FSB), which covers Payments (Check, Cash, Credit Card), Statements (Monthly Statements), Notices (Cancellation, Reminder, Final Cancellation).
• Involved in testing Agent Dashboard Reports and Alerts.
• Derived Test Cases and Executed related to Report Parameters, Report Layouts and Drill Down Functionality.
• Involved in the review of the test plan, scripts to ensure they match and cover all the requirements in the functional specification document.

Environment: Tableau Desktop 7, Tableau Server, Business Objects, Oracle, Crystal Reports, Windows Server 2008.

BI Consultant - SQL Developer

Confidential, Allentown, PA

Responsibilities:

• Planned, designed, and implemented application database code objects such as stored procedures and views.
• Provided database coding to support business applications using T-SQL.
• Performed quality assurance and testing of SQL server environment.
• Developed new processes to facilitate import and normalization, including data files for counterparties.
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports to testing and release / deployment.
• Trained and mentored EBI team, users andassisted and coached them inmaterial, processes and delivery of, standards and best practices.
• Interacted with report owners to establish/clarify their requirements and developed report specifications.
• Performed development activities from gathering requirements and designing solutions through developing code reports to testing and release deployment.

Environment: Microsoft, Linux, Oracle 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000, MS Access 2000

BI Consultant - SQL Developer

Confidential, PA

Responsibilities:

• Programmed client’s website and applications - worked collaboratively with clients. Teammates and web analysts to complete designs and estimates.
• Involved tuning and applying the SQL statements and PL/SQL processes.
• Created different kinds of reports on Tables, Views, and Synonyms from the Oracle Database.
• Provided insightful ideas for developing effective and accurate codes - Evaluated latest technology on the market and made recommendations to clients to integrate new designs as available by new technology.
• Collaborated with end users and other related departments to ensure that the website is meeting the client’s expectations and business requirements.
• Collaborated with technical team members to integrate back-end and front-end elements.

Environment: Windows 00/XP,SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL-PLU, Oracle 7, Java.