Business Intelligence Power Bi

Shashank Gaddam

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

**************@*****.***

SUMMARY

Sixteen 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.Talend and Visio 2000

JDA Tools

JDA CRO, JDA BI, JDA WEBWORKS, JDA SCPO

EDUCATION:

Masters in Management Information Systems

Certifications:

Certified Power Bi Developer

Certified in Azure fundamentals

Certified Cognos Developer

CMIG Jun 21 – Till Date

Sr. BI Consultant

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

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

Wrote calculated columns, measures using Data Analysis expression language (DAX) in power bi desktop.

Worked with Power M query for data massaging in power bi desktop.

Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as using Azure Synapse.

Developed power bi reports and dashboards using Azure Synapse, AAS models and excel,

Work with various Team Members, internal departments and third-party agencies on report business requirements, documentation, timelines, testing, and technical delivery

Conducted a cross – training power bi session to help other users to work with power bi.

JDA/BY Jul 20 – Feb 21

Sr. Bi Consultant

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

Work with the Data Management team to provide input on logical and physical database design, data modeling and/or mapping

Wrote calculated columns, measures using Data Analysis expression language (DAX) in power bi desktop.

Worked with Power M query for data massaging in power bi desktop.

Developed power bi reports and dashboards using Azure Synapse, AAS models and excel,

Conducted a cross – training power bi session to help other users to work with power bi.

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 upgradation 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 upgradation 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 cognos11 to present the conclusions.

Design and create professional reports/dashboards and visualization and stories in Cognos 11.

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 workflows.

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, Framework 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.

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

Setup and maintain user ids, passwords and user classes and access to the data sources.

Scheduled and Distributed reports using Cognos Connection through Bursting.

Deployed packages, content store from a development environment to production environments.

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

Trained business users to develop/use reports using Report Studio/Query Studio

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

Execute/Schedulling Corn Jobs on linux and Aix environments.

Environment: JDA SCPO, CRO, TPO, RRO, JDA Demand, JDA Webworks,Cognos 10.2.2, Cognos 10.1.1,Cognos 8.4, 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.

Work with Crystal Reports and Business Objects in creating reports and subreprots.

Also create packages in business objects universe.

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 on Informatica to create workflows.

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

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, Crystal Reports, Business objects, Oracle 10g, Sql Server 2005,Toad, SSIS, Windows Server, Informatica, DataStage, MS access, AS 400, Excel, PL/SQL,SAP BW, MDX, XML, BEX Analyzer, BEX Query Designer, Java Script and Windows 2003.

Contact this candidate