SUMMARY

• Total 14+ years of IT experience with Technical and Functional experience in Business Intelligence (BI), Data Modelling, Data Warehousing (ETL), Data Analysis, Cloud, Testing and Documentation.
• Business domain knowledge of Mortgage Banking, Retail Banking, Credit Card Collections, Financial Institution, Insurance and Retail.
• Experience in creating reports, dashboards, datasets in Power BI desktop using various visualizations, themes, wallpapers, filters etc.
• Experience in publishing the reports on to Power BI service and work in multiple workspaces.
• Experience in creating measures and writing complex DAX code to achieve business requirements in Power BI desktop tool.
• Experience in performance tuning of Power BI reports using Performance Analyzer, DAX studio and Vertipac Analyzer.
• Understanding of the M - language and reviewing/wiring/modifying M-code as needed in Power BI desktop tool.
• Experience in Data Modelling, cleaning (shaping), transforming in Power BI desktop tool.
• Experience in managing query relationships with various cardinality and cross filter direction (Single and Both) in Power BI desktop.
• Experience in working with different kind of data sources like Excel, Database (SQL Server, Oracle, DB2) and Web in Power BI Desktop.
• Implemented row level security in Power BI desktop and published to Power BI service.
• Experience in working with different storage modes in PowerBI like DirectQuery, Import and Live Connection.
• Experience in working with large Power BI dataset for self-service reporting in Power BI Service.
• Experience in using on-premise data gateway to refresh dataset for reports in Power BI Service.
• Expertise in writing SQL queries using TOAD, DBeaver, and SQL developer.
• Excellent knowledge on data warehousing concepts - Star schema, Snow-flake schema, Hybrid and worked on both OLAP and OLTP databases.
• Experience in writing Linux and Unix shell scripts and Windows batch scripting.
• Good Understanding of Linux and Windows Administration.
• Experienced in analysis, design, development and implementation of Business Intelligence and Maintaining Applications using Confidential Cognos BI Tool suite
• Expertise in Data Modelling and generating reports using Confidential Cognos Analytics.
• Good understanding of cloud technology (AWS) terminology and AWS console.
• Functional and Technical Expertise with proficiency in requirements gathering, design, development and implementation of a project (SDLC).
• Experienced in data modelling using Confidential Cognos Framework Manager and relational database as source including applying data level, and query subject level and package level security & Publishing packages to Cognos portal.
• Expertise in Confidential Cognos installation/configuration, portal administration, version migration and security setup.
• Experienced in troubleshooting informatica production issues at different stages like database, workflows, sessions, mapping.
• Experience in creating mapping, workflow and sessions in Informatica ETL tool.
• Excellent communication and inter-personal skills and team player.
• Business users training in developing/using various Reports

TECHNICAL SKILLS

BI Tools: MS PowerBI, Confidential Cognos 11/10/8, Tableau

ETL Tools: Informatica Power Center 9.5/6, 10.1/2, Data stage 10/11, Teradata.

Database: DB2, Oracle, Snowflake, Sql Server, Sybase, Netezza.

Languages: PL/SQL, shell scripting, windows batch scripting.

OS: Linux 5/6/7, Sun Solaris Unix 7/8/9, HP Unix 9/10/11, Confidential AIX 3, 4 and Windows server 2003/8/12/16.

Other Tools: Control-M, Autosys, HP Quality Center, HP Service Manager, HP Quality Centre, Toad, PL/SQL Developer, Cygwin, Putty, WinSCP, RapidSql

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

Sr. BI Developer

Responsibilities:

• Meeting with business users to gather clarification and/or requirements for the reports.
• Creating reports from different databases (Oracle, DB2, Sql Server) using MS Power BI desktop tool.
• Using Query Editor, DAX calculations, M-code to clean and transform data in Power BI desktop.
• Creating measures using advanced DAX calculations to achieve business goal.
• Data Modelling, Transformation and cleaning using Power BI desktop to implement the data Model same as in Cognos.
• Scheduling of Power BI dataset, report and dashboards in Power BI Service.
• Implemented row level security in Power BI desktop.
• Used gateways to refresh data in Power BI service as the database are on-premise.
• Used a composite model for self service dataset (DirectQuery and Import).
• Planning the data refresh schedule for the self-service Power BI dataset as fact and dim tables were in different storage mode.
• Training the Business users in Power BI service portal.
• Performance tuning of the reports as they have strict requirement for time of report run.
• Analysis of the data in FTM database (DB2) using DBeaver tool to meet report requirement.
• Production support for all kind of BI/DW issues for the reports.
• Analysing the Informatica logs for job failures and working with appropriate team to fix issues.
• Preparing deployment document for moving the Cognos objects from DEV to QA to PROD environment.
• Defect fixing of production issues.

Confidential, Portland, OR

DW/BI Operations Lead

Responsibilities:

• Creating reports from different databases (Teradata, Oracle, Sql Server) using MS Power BI desktop tool.
• Performance tuning of Power BI reports using Performance Analyzer, DAX studio and Vertipac Analyzer.
• Troubleshooting dataset refresh issues in Power BI service and fix the issues.
• Using Query Editor, DAX calculations, M-code to clean and transform data in Power BI desktop.
• Data Modelling, Transformation and cleaning using Power BI desktop to implement the data Model same as in Cognos.
• Scheduling of Power BI dataset, report and dashboards in Power BI Service.
• Creating measures using advanced DAX calculations to achieve business goal.
• Implemented row level security in Power BI desktop.
• Used gateways to refresh data in Power BI service as the database are on-premise.
• Worked in Power BI Pro and Premium license.
• Worked in power BI Dataflows and modified ETL tasks there.
• Used a composite model for self-service dataset (DirectQuery and Import).
• Production support for Informatica job failure issues.
• Writing and troubleshooting of Shell scripts for Informatica and Cognos related issues.
• Troubleshooting, Enhancement and development of Informatica mapping, session and workflow.
• Troubleshooting of Informatica issues at various levels like platform level, source/target connectivity level and data level.
• Communicating with several teams for fixing Informatica and Cognos issues like DBA, Unix Admin, Informatica Platform team, Active Directory team etc.
• Checking the session logs for troubleshooting informatica job issues.
• Debugging informatica job performance issues and fix them at various level like source, mapping, session, target and system (OS) level.
• Framework Manager modelling for relational and DMR model using Teradata and Snowflake db.
• POC for tableau reporting for comparison with Power BI self-service reporting.
• Login to AWS console for server health, ELB health, S3 storage, database storage etc.
• Production support for all Cognos reporting issues that involves modifying reports, writing SQLs, Framework manager modelling and all kind of troubleshooting.
• Troubleshooting of transformer cubes (version 10.2.2) and cube modelling for relational DB and DMR.
• Cognos operations regular tasks like deployment, data source, permission/security, job/schedule etc.
• Scheduling of reports based on time and triggers.
• Working with Confidential on PMR for product related issues.

Confidential, Chicago, IL

Sr. BI/DW Consultant

Responsibilities:

• Involved in Architecture and design of Data extraction, transformation, cleaning and loading using Informatica ETL tool.
• Involved in Requirement gathering and source data analysis for the EDW project for WMA.
• Involved in the Logical and Physical design and creation of the ODS and data marts.
• Developed Informatica mapping, workflow, session and tuned them for Optimum performance, Dependencies and job scheduling.
• POC in Power BI self-service capabilities for their EDW reporting.
• Created DSNs, parameters, variables, expressions in Informatica ETL tool.
• Used SQL utility tool PL/SQL Developer to run SQL queries and validate the data (source and target).
• Prepare migration document for moving Informatica objects from DEV to QA to UAT.
• Used Informatica Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Troubleshooting of all kind of production issues in Informatica job runs.
• Designed and developed Dashboards to show reports from different packages on to a single portal page and applying filters.
• Migration of Cognos reports from version 10.2.1 to Cognos Analytics 11.0.5.
• Framework manager modelling for various data sources (oracle, SQL server) with DMR
• Created DMR reports for drill up and drill down functionality in the report.
• Drill-through definitions from Cube to a relational Package.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables.
• Set up user capabilities and security on cognos portal
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 11.0.2/3/4/5, IIS 8.5, Windows server 2012, Windows Batch script, Control-M, Oracle 12c, TM1 10.2, Informatica 10.x.

Confidential, Charlotte, NC

DW/BI Technical Consultant

Responsibilities:

• Meeting with business users for requirement analysis and prepare technical specification document for the same.
• Extracted the data from the Flat files, CSV file, Oracle databases into staging area and populated onto Enterprise Data warehouse using Informatica ETL tool.
• Worked on the UNIX scripts for running Informatica workflows and threshold check for the incoming files.
• Prepared ETL Design-Document and Implementation Plan documents.
• Prepared mapping specifications documents, unit testing documents for Informatica mappings.
• Utilized many Informatica transformations like Router, Lookup, Sorter, Filter, Aggregator, Expression, joiner and Update Strategy.
• Used SQL utility tool TOAD to run SQL queries and validate the data (source and target).
• Designed and developed Dashboards in Report studio to show reports from different packages on to a single portal page and applying filters.
• Drill-through definitions from Cube to a relational Package.
• Framework Manager modelling for both relational and DMR type.
• Report creation from DMR, Cube based and DB based packages.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Implemented security in reports based on various companies and roles according to the requirement.
• Involved in creating security and deployment (exports and imports).
• Created static choice value prompts, conditional variables and conditional blocks associated with these variables to display/hide columns and queries based on user’s selection in Prompt pages.
• Worked with Java scripts for different report requirements.
• Designed the standard template for creating reports in Report Studio In-order to meet the reporting standards.
• Worked on performance tuning of reports and testing at different stages.
• End User documentation, Technical documentation and UAT document.
• Framework Manager Modelling with multiple data sources and multiple tables from each of them.

Environment: Cognos BI Series 10.2.1, Framework Manager, Query Studio, Report Studio, Analysis Studio, Windows 7, Z-Linux, Informatica 9.6, SQL Server, SQL Developer, Toad, HP Service manager.

Confidential, Jersey City, NJ

Tech Lead

Responsibilities:

• Developing a logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Analysing requirement Specification document and preparing the technical Specification document as per the Business requirement.
• Developing the SQL scripts as per the business requirement.
• Developing Dash Board reports in Report Studio.
• Developed Active reports in Report Studio for use in mobile devices using go-mobile cognos app.
• Creating the Report Studio reports using the Cube as a data source.
• Adding business rules by defining different kinds of calculations and filter.
• Developing the reports using various templates like list report, Cross-tab Report and Chart Report.
• Working experience with different date functions in Report Studio.
• Creating the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Extensively working with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning the by analysing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Post production support

Environment: Cognos BI Series 10.2, Framework Manager, Query Studio, Report Studio, Analysis Studio, Windows 7, Sybase, Teradata, SQL Server, Toad, Rapid SQL.

Confidential, Charlotte, NC

Cognos Lead

Responsibilities:

• Developed transformer cubes and used them as data source to write reports in Analysis Studio.
• Cognos administration tasks like installation, configuration and maintenance of cognos server components and desktop clients.
• Cognos permission and security of packages, folders, reports etc.
• Scheduling reports in Production environment for business users.
• Wrote Audit reports for users from the cognos Audit package.
• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of business users.
• Report testing and output comparison in cognos lifecycle manager.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models,
• Packages, Reports and Power Play Models.
• Migrating the existing Cognos 8 packages, cubes and reports to Cognos 10.
• Enhancing the Framework Models and Reports to meet the changing business Requirements.
• Created a Framework Manager Model with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Create IQDs using Framework Manager
• Created dimension views and User Class views to implement the data security in the Power Play Transformer Model.
• Created various Power Play reports for the Different user groups.
• Created various Crosstab reports and Drill through reports as per the user requirements using Conditional formatting.
• Created various cubes using multiple data sources.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Collecting and sharing best practices and tips in Framework Manager modelling, security setup, Report Authoring, Stress testing and Performance tuning.
• Addressing the Performance and other Production issues with the reports and cubes.
• Defining the Users, Group and Roles in LDAP using Cognos Access Manager.
• Worked on migration to Cognos 10.1.1 from 8.4.1

Environment: Cognos BI Series 8.4.1 and 10.1.1, Framework Manager, Query Studio, Report Studio, Analysis Studio, Transformer, Windows XP, Unix,Oracle 10g, Control-M,SQL Server, SQL Developer, Toad.

Confidential, Irving, TX

Cognos System Analyst

Responsibilities:

• Troubleshooting of various user issues in Framework Manager, Report Studio, Query studio and Transformer.
• Content deployment from Dev to UAT and UAT to PROD.
• Set up security for Packages, folders in Cognos Admin portal and also created roles and groups in Cognos namespace.
• Created Cognos ‘data sources’ (for Oracle, DB2, SQL server, MS Access, Cubes) and File shares in cognos Admin portal.
• Run cognos maintenance tasks from cognos Admin portal (like Consistency check).
• Performance Tuning of cognos environment by setting up advanced properties in the portal Administration page.
• Monitoring of the servers where cognos server components (content Manager and Report server) are installed for resource (CPU usage, memory usage etc) and space constraints (temp folder, data folder etc).
• Defined routing rules in cognos admin portal to rout reports from specific package to particular dispatcher.
• Retrieved packages from content store (SDK code) for developers who accidentally lost their packages.
• Worked with LDAP and Active Directory team to set up security in Cognos.
• Created Audit reports for users for checking various parameters like report usage on a package.

Environment: Cognos BI Series 8.3, Framework Manager, Query Studio, Report Studio, Analysis Studio, Windows XP, Oracle 9i, Unix, Transformer, Power play, SQL Server, SQL Developer, Toad

Confidential

BI Analyst

Responsibilities:

• Involved in gathering Functional requirement from the end users and analyzed the requirement.
• Analyzing the requirement document and differentiating the metrics (facts and dimension) for PowerPlay cubes and Cognos 8 reports for design purpose.
• Preparing the design document for PowerPlay cubes, Cognos 8 reports, Coding Standards document, Naming Conventions document, Defect logs, Review Logs.
• Creating IQD files using Cognos Framework Manager
• Building the model file for cube using Cognos Transformer series 7, building cubes and publishing them to Cognos portal using PPES (PowerPlay enterprise server).
• Open the cube in Powerplay and slice and dice them and create cube views.
• Writing shell script to build cube in Unix and batch script to build cube on Windows.
• Creation of packages(Relational and Dimensional) from Cognos Framework Manager
• Creating the reports using Cognos 8

Environment: Cognos 8, PPES (powerplay enterprise server) Windows server 2003, Sun Solaris Unix, Shell Script, Windows Batch script, HP Peregrine, Putty, Toad, PL/SQL Developer, Oracle, DB2.

Confidential, Irving TX

QA Testing Analyst

Responsibilities:

• Analyzing the existing manual test cases and designing new Test Cases from Functional Specification.
• Writing the Test conditions from Test cases.
• Preparation of Test Strategy Document
• Execution of the manual test cases and regression test cases.
• Back end(database) testing using SQL queries in Oracle 9i database
• Tracking the Bugs throughout the life cycle of Testing using Mercury Quality Center.
• Performed negative and positive testing
• Participated in Document Reviews and Inspection
• Preparation of the Readiness Documents, Mapping Documents
• Creation of testing framework and the Automation test scripts using WinRunner and QTP.

Environment: Mercury Quality Center, Test Director, MS Excel, Toad, Oracle 9i.