SUMMARY

• Over 9 years of IT experience in Enterprise Business Intelligence lifecycle implementation with Tableau, Cognos BI Suite, Qlikview and SQL server Suite.
• Expert in Agile and Waterfall SDLC methodologies.
• Extensive experience in creating Tableau visualizations, Tableau dashboards and Stories.
• Experience in Software Design, Development, Analysis, Testing with Data mart, Data Warehouse, Data modeling, Stored Procedure/TSQL coding.
• Experience in handling complete range of admin capabilities: Monitoring Server status, system metrics, monitor activities, create groups and user roles, set user interface profiles, setting up data source connections.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail, and Cascading) and Dashboards.
• Strong knowledge with complete Tableau Suite including Tableau desktop, Tableau Server and Tableau online.
• Well-versed in developing reporting applications using Cognos Business Intelligence components like Cognos 10 BI Suite (Framework Manager, Report Studio, Cognos Connection, Metric Studio, Query Studio, and Event Studio), Cognos Report Net 1.1, Cognos Impromptu, Power Play Transformer, Impromptu Web Reports(IWR), Access Manager, and Cognos series 8 suite of tools.
• Expertise on all types of aggregations and statistical terms in tableau. Completed a course on Probability and Statistics as a part of University Curriculum.
• Experience in Production Support and Troubleshoot/Test issues with existing reports and dash boards.
• Experience in creating data warehouse from scratch, by creating required tables, implementing keys are relationships.
• Good understanding of Kimball Methodology.
• Extensive experience in databases including but not limited to Db2, Oracle, MySQL, Teradata, Netezza and SQL Server.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Excellent knowledge in designing and developing dashboards using Qlikview by extracting the data from multiple sources (Flat files, Excel, Access).
• Experience with QlikView objects including Pivot, Straight Table, Multi box, Bar chart and more.
• Extensive work on Data Extraction with Oracle 11g, SQL Server & MS-Access.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2012.
• Very Good Understanding and Experience in Transact SQL Server (TSQL), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Highly Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions, views and Indexes.
• Expert in developing SSIS Packages to extract, transform and load (ETL) data into the data warehouse database from heterogeneous databases.
• Experienced in using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created calculated measures and dimensions members using MDX, mathematical formulas and user defined functions.
• Excellent knowledge in designing and developing dashboards using Qlikview by extracting the data from multiple sources (Flat files, Excel, Access).
• Extensive experience in building Business Intelligence (BI) Applications using Business Objects Suite.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Reporting Tools: Tableau 10, Tableau 9x, Cognos (11/10/8) BI Suite, BO, Qlikview

SDLC Methodologies: Waterfall, Iterative, Agile/Scrum

Databases: MS SQL Server 2008/2012, Netezza, Oracle 8i/9i/10g/11g, DB2, MS Access, Sybase ASE/IQ

Database Tools: TOAD, Rapid SQL, Query Analyzer, SQL Developer

Data Modeling: ER/Studio 3.5/4.0, Erwin 7.3/4.1, Power Designer

ETL Tools: DataStage, Informatica Power Center, Ab Initio, SSIS

QA Tools: HP ALM, Quality Center 11/10, Rational Clear Quest

Languages: SQL, PL/SQL, HTML, DHTML, JSP, T-SQL

Web Servers: IIS, Apache Web Server, Tomcat

Operating Systems: Windows 2000/NT/XP/Vista/7/8, Server 2003/2008/2012 UNIX, Ubuntu, Linux

PROFESSIONAL EXPERIENCE

Confidential - Williams, OH

Sr. Tableau/Cognos Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to Tableau reports and Dashboards.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Converted existing Excel Reports into Tableau Dashboards.
• Involved in managing the application's users, groups, and integration with Active Directory
• Very good knowledge on Tableau Server Site Administration
• Evaluated database performance issues and executed database optimization.
• Prepared backups using Tabadmin and Tabcmd commands.
• Worked with T-SQL to create Tables, Views, Stored Procedures and functions. Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
• As a Tableau Analyst, used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also, to slice and dice the data, for analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, indicators, and gauges.
• Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop. Also, involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
• Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.

Environment: Tableau Desktop 9.0, 10.0 Tableau server, Tableau public, T-SQL, SQL Server2012/2008, Data view, Alteryx, Oracle 11g/12c, Microsoft Excel 2007, MS Access, Windows 2007, Linux/Unix, HTML/CSS, JavaScript, SAS, JIRA and GIT.

Confidential, Fortmill, SC

Sr. Tableau/ Cognos/Qlikview Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created dashboards by extracting data from sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging sources.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server. experience and expertise in creating Tableau Workbook's, Publishing workbooks and Dashboard.
• Developing the QlikView reports, dashboards, building semantic/data models for ado reports, (QVD) generation etc using QlikView.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Created report schedules, data connections, projects, groups in Tableau server.
• Built power play reports based on the cubes and published to Report Net Server.
• Coordinate with Cognos Support team in resolving the technical issues of the Cognos suite of products.
• Using Cognos 10.2.1 Report studio, created various complex Reports like List Reports, Grouped Reports, Cross tab Reports, Chart Reports Drill-Through Reports and Active Reports for Mobile and iPad Applications.
• Created and updated Framework Manager models and published to Cognos Connection.
• Implemented stored procedure query subject in Cognos Framework Manager.
• Implemented data level security, object level security and package level security using the Framework manager and Access manager.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Used Cognos Transformer to build OLAP multidimensional cubes and used it in Dashboards.

Environment: Tableau Desktop 8x, Cognos 8x/10x Suite, Transformer, Frame work Manager, Windows Server Standard R2, Excel, T-SQL, SQL Server management studio, Oracle11g, DB2, TOAD, MS SQL Server 2008R2, UNIX, Teradata, Qlikview, Linux, Micro strategy, Map Reduce, MS Access.

Confidential, Columbus, OH

Tableau/SSIS/Qlikview Developer

Responsibilities:

• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created Tableau workbooks with calculations, parameters, Quick Filters.
• Worked and generating various workbooks and dashboards extracting date from various sources such as Oracle, SQL Server, DB2and data files using data blending and joins.
• Developed workbooks and dashboards using Tableau Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
• Developed Qlikvew Dashboards using various Qlikview objects like Charts, List Box, multi box, Table Box, Button, text box and containers as per business needs.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• 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.
• Assisted Project Manager in developing in project timeline and resource estimations. Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Took the responsibility of preparing the Functionality Test Plan which was used to test system inputs and outputs in the pre-production stage.
• Wrote complex SQL queries to pull and process data from multiple data sources (SQL Server, flat files, etc.).
• Designed and programmed re-usable SQL code to prepare data for analysis.
• Downloaded data from various sources.
• Loaded data into SQL database and convert it to applicable dataset to make it ready for report generation.

Environment: Tableau Desktop 8.0/8.3 Tableau server / Administrator, SQL Developer, SQL 2008, Tableau Server 7.0, Tableau Desktop 7.0, MS SQL Server 2005, MS SQL Server Reporting Services 2005, Qlikview, Oracle 10g, Microsoft office Suite, SQL Server Integration Services (SSIS), Crystal Reports, Erwin, XML, JIRA and GIT.

Confidential, Cleveland, OH

Tableau/ETL Developer

Responsibilities:

• Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc
• Created Sets, Groups and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Generate new QVD files created by ETL logic to feed Qlikview applications.
• Writing SQL queries for data validation by using join conditions.
• Worked on groups, sets, parameters, different calculation functions including Table calculations.
• Worked on various reports using best practices and different visualizations like Bars, Trends, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extracted data from various heterogeneous sources like Oracle, DB2, SQL Server, MS Access and Flat files.
• Incoming data was loaded to the landing area and from there to staging area.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer Mapplet Designer and Mapping Designer.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
• Performed data validation by Unit testing, integration testing and System Testing.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Developed various Mappings, Mapplets and Transformations for data marts and Data warehouse.
• Created conditional and context filters to filter the data on dashboard. Responsible for Creating Parameters for desired functionality.

Environment: Tableau Desktop 8 & 9, Tableau server, SQL Server, Oracle, Windows 8, Informatica PowerCenter8.6, Oracle 10g, TOAD, PL/SQL, MS Access, Windows 2008 Server, DB2, UNIX Shell Scripting.

Confidential

MS SQL/BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Installed and Configured SQL Server 2008 successfully.
• Created Stored Procedures, User defined functions, Views, Triggers, Indexes and Wrote T- SQL codes maintaining query standards for the project.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source, Excel spread sheets and Flat files to SQL Server 2008.
• Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.
• Utilized SSRS reporting services to generate different types of reports from the database.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and Sub Reports.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in Visual Source Safe (VSS).
• Evaluated database performance and performed maintenance duties such as Tuning, Replication, Backup and Recovery.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services, SQL Server Reporting Services, DTS, MS Access, MS Excel, Windows 2003 servers, T-SQL, PL/SQL, Visual Studio 2008.

Confidential

SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2005 successfully on Windows Server 2003.
• Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
• Error handling using Try-Catch Block.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
• Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
• Created Master Child package using variables and Execute package task in SSIS.
• Assisted the front-end application developers with their queries.
• Taking Databasefull Backup, Transaction log backup & differential backups.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2005, T-SQL, VB, MS Word 2005, DTS, SQL Profiler, Visual Source Safe, DTS/SSIS 2005, Import and Export Wizard, BCP, Windows Server 2003, UNIX.