Shashank Gaddam

647-***-****(C)

adiu9l@r.postjobfree.com

SUMMARY

Twelve Plus years of experience in Analysis, Design, Development, Administration, Testing, Warranty and Production Support of Client Server, Data Warehouse, Business Intelligence, ETL and Database Applications.

Strong experience in the architecture, installation, development, administration and Implementation of Business Intelligence tools like Cognos, Tableau, Power BI, SSRS and Crystal reports.

Experienced in using Extraction Transformation and Loading (ETL) tools like SSIS, Informatica and DataStage.

Extensively worked with MDX, SQL Queries, PL/SQL in both Oracle and SQL Server databases and also have good experience in debugging, trouble shooting and tuning techniques.

Extensive experience with Requirements Definition, Functional Analysis, Technical Analysis, Business Planning, Data Modeling and Functional Decomposition.

Experience in Upgrading Cognos to higher versions and migrating Cognos ReportNet /Cognos 7.x to higher versions.

Worked on both Agile and Waterfall project methodologies

Experience on Guidewire Policy Centre, Billing Centre, Claims Centre and Contact Manager

Proven ability to build strong relationships with clients and staff using negotiating talent, persuasion and demonstrated commitment.

Strong Technical, Communication, Time Management and Interpersonal skills.

Technical Skills:

BI Tools: COGNOS, Crystal Reports, Business Objects. Tableau, Power BI, SSRS,

Operating Systems: Windows, Linux, UNIX, AIX

Languages: SQL, PL/SQL, MDX, T-Sql, Java Script.

Databases: Oracle, SQL Server, Terradata, DB2, MS Access,AS400 and SAP.

Other Tools: Toad,pl/sql developer Deployment Tool & Migration Utility (Impcat2xml), Apache, Tomcat, IIS,Jira,Servicenow,

Data Modeling Tools: Informatica, DataStage, SSIS, Erwin. Visio 2000

JDA Tools: JDA CRO, JDA BI, JDA WEBWORKS, JDA SCPO

EDUCATION:

Masters in Management Information System

Agricorp Aug 19 – Jun 20

Sr. Bi Consultant

Involved in environment setup of Cognos11 server

Install and configure Cognos application suite for various projects and modifying the portal.

Implemented Cognos Security with LDAP and Active Directory Server as authentication.

Migration and Upgraded of reports and packages from Cognos10.2.2 to Cognos 11

Integration of Cognos with guidewire suite.

Build FM models using infoCenter DataMart and other Relational Database.

Developed complex Claim Center and Policy Center Reports using Report Studio.

Performance tuning of the Cognos BI reports for quick runtime of reports.

Trained Business Users to develop new reports and functionality.

Environment: Cognos 11.x, Cognos 10.x, FrameWork Manager, Sql Server, Oracle, Windows server, Claim Center, Billing Center and Policy Center.

WSIB APR 18 – Jul 19

Sr. Bi Consultant

Involved in environment setup of Cognos 10.2.2 server

Provided production support services to existing environments.

Install and configure Cognos application suite for various projects.

Implemented Cognos Security with LDAP and Active Directory Server as authentication.

Migration and Upgraded of reports, cubes and packages from Cognos 8.4 to Cognos 10.2.2.

Integration of Cognos with guidewire suite.

Build Cubes using Powerplay Transformers.

Work with Erwin to create Data Models.

Worked with business users, functional lead to understand and document the Business requirements.

Build FM models using infoCenter DataMart and other Relational Database.

Developed complex Claim Center and Policy Center Reports using Report Studio.

Performance tuning of the Cognos BI reports for quick runtime of reports.

Trained Business Users to develop new reports and functionality.

Environment: Cognos 8.x, Cognos 10.x, Power BI, FrameWork Manager, Transformers, Erwin, Sql Server, Oracle, Db2, UNIX, Linux, Aix, Windows server, Claim Center, Billing Center and Policy Center.

Great West Life MAR 17 – MAR 18

Sr. Bi Analyst

Worked with business users, functional lead to understand and document the Business requirements.

Analyze the requirements and do the impact analysis

Participate in the overall technical design and create process flow/action diagrams.

Install and configure Cognos application suite.

Designing current database by adding tables, stored procedures, views and also developed custom tables as per requirement.

Performed data quality analysis, comparative analysis and statistical analysis using advanced sql and R Tool.

Successfully interpreted data in order to draw conclusions for managerial actions and used Tableau to present the conclusions.

Design and Create professional reports/dashboards and visualization in Tableau.

Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.

Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports.

Created Filters, Groups, Sets on Tableau Reports.

Published Tableau data source (.tdsx) to server for business to do ad-hoc data analysis which Is not available in reports.

Handling the performance tuning of reports to reduce refresh time.

Integrated ‘R’ with data lake to analyze data.

Environment: Cognos 11.0.7, Tableau, Dashboards, Report Studio,Frame Work Manager, Sql Server, Db2, Main Frames, PL/SQL, Big Insights, Unix and Windows server.

Scotia Bank JAN 17 – Mar 17

Sr. BI Consultant

Worked on Informatica to create work flows.

Extensively used informatica client tools – Source Analyzer, Mapping Designer, and Mapplet Designer.

Design and Create dashboards, professional reports in Report Studio.

Performance tuning of the Cognos BI reports for quick runtime of reports.

Environment: Cognos 10.2.2, Informatica 7.x,Dashboards, Report Studio, Query Studio, Frame Work Manager, Oracle 12, PL/SQL and Windows server.

JDA Software India Pvt Ltd. Apr 11 – Oct 16

Technical Architect

Worked with business users, functional lead to understand and document the Business requirements.

Analyze the requirements and do the impact analysis

Participate in the overall technical design and create process flow/action diagrams.

Design & Develop custom screens in JDA Webworks foundation framework and integration touch points for upstream and downstream systems.

Design of the underlying data model using sql/plsql components.

Installing and Configure Cognos and Implemented Security with LDAP server as authentication.

Import metadata from Relational Databases into the Framework Manager to build models.

Design and Create dashboards, professional reports in Report Studio and ad hoc reports in Query Studio.

Developed Physical data models and created DML scripts to create database schema and database objects

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Implemented Incremental load, used Event Handlers to clean the data from different data sources

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Developed various operational Drill-through and Drill-down reports using SSRS

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate a report from two different Data Sets.

Involved with Query Optimization to increase the performance of the Report.

Developed Reports for business end users using Report Builder with updating Statistics.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005

Documented and maintained database system specifications, diagrams, and connectivity Charts.

Execute/Schedulling Corn Jobs on linux and Aix environments.

Environment: Cognos 10.2.2, Cognos 10.1.1,Cognos 8.4, SSIS, SSRS, Report Studio, Query Studio, Frame Work Manager, Teradata,Oracle 12.x,11.X,PL/SQL, Windows server, Unix and Linux.

Nico Info Sep 07 – Nov 10

Technical Architect

Interpreted logical and physical data models for business users to determine common data definitions.

Worked closely with business analyst to analyze the reporting requirements.

Build impromptu reports using cognos 7

Install, Configure and administrated Cognos 8 BI Tools on development and production server.

Worked with business users, functional lead to understand and document the Business requirements.

Implemented Cognos 8 Security with LDAP server as authentication.

Developed ETL jobs to load data.

Extensively used informatica client tools – Source Analyzer, Mapping Designer, Mapplet Designer,

Developed UNIX shell scripts to run informatica from pre to post sessions to finish the task.

Created SSIS packages to load data.

Import metadata from various sources such as Relational Databases, Multidimensional cubes as sources into the Framework Manager and build models, packages.

Build Cubes using Powerplay Transformers.

Design and Create professional reports in Report Studio and ad hoc reports in Query Studio.

Developed dashboards in Report Studio and scorecards

Tuned the performance of the Cognos BI 8 for quick runtime of reports.

Worked on MS Access Database to generate some excel reports.

Created tables and views in sql server 2005.

Extracted data from AS400.

Worked with DBA to create SSIS packages to load data in SQL server 2005.

Worked with SAP BEX team to develop queries.

Written MDX queries for reports.

Worked with end user to fix the issues in the report.

Worked on SAP BEX Analyzer to validate the report.

Worked on java script to auto select prompts in the reports.

Environment: Cognos 7.x,Cognos Reportnet, Cognos 8.x,Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Powerplay, Oracle 10g, Sql Server 2005,Toad, SSIS, Windows Server, Informatica, MS access, AS 400, Excel, PL/SQL,SAP BW, MDX, XML, BEX Analyzer, BEX Query Designer, Java Script and Windows 2003.

Contact this candidate