Team Lead Resume Arizona - Hire IT People (2024)

SUMMARY

• Around 15 years ofexperiencewithanalysis, design, testing, development, and implementation of client/server applications
• Thorough knowledge of Power BI, Cognos, Qlik Sense development, administration and architecture, report - writing, BI system configuration, and upgrading, BI solutions designing, system modification, and performance improvement
• Experience in creating visualizations (Table, Bar, Pie, colored Bar, dual-axis bar, scattered plot, stacked bar, line graph, map views, Funnel, Doughnut chart, Q&A, Cards, Slicer, etc.) using Power BI
• Experience In creating Power BI reports and dashboards using database and Excel Data and publishing reports into Power BI Service Workspace
• Experience in creating dashboards in Power BI using various sources like AWS, Service Now, and Snowflake
• Experience in creating calculation measures and multiple filters using Slicers in Power BI
• Experience in creating calculated columns and measures using DAX
• Experienced in creating new Snowflake Warehouse and using it for reporting source
• Experienced in providing required privileges to users using the Snowflake
• Experienced in importing data from AWS S3 and using bulk loads in Snowflake
• Installed, configured, and deployed various Cognos and Qlik products and managed security at all levels
• Expertise in the deployment of dashboards in Qlik QMC, task scheduling and triggering, and section access
• Administering BI application or system implementations and providing a stable production environment that meets performance needs as well as preparing recommendations for system improvements by analyzing technical configurations, and user change requests
• Proficiency in using Cognos BI 10 and 11 Analytics and Framework Manager
• Good at Informatica power center and cloud admin activities like deployment, creating connections and providing access to users, and performing maintenance activities
• Trained on Snowflake and AWS
• Effective communication and interpersonal skills along with the ability to provide support to technical teams and business user
• Excellent analytical skills and the ability to solve complex analytics systems and reporting issues
• Strong organizational and multi-tasking skills as well as the ability to cope with the fast-paced and challenging work environment

TECHNICAL SKILLS

Operating Systems: Windows 10/7, XP, Unix/Linux

ETL Tool: Informatica Power center

Scheduling Tool: Robot

OLAP Tools: Cognos 10.x Transformer, SSAS

Reporting Tools: Power BI, Cognos Analytics 11. x and Qlik view\sense, Tableau

Cloud: AWS, Snowflake, IICS (Informatica Intelligent Cloud Services)

Databases: SQL Server, Oracle

Ticketing Tool/Agile PM Tool: ServiceNow/Rally

PROFESSIONAL EXPERIENCE

Confidential, Arizona

Team Lead

Responsibilities:

• Migrated Cognos reports to Power BI
• Expertise in gathering and translating end-user requirements into effective & efficient Dashboards
• Mastered the ability to design and deploy rich Graphic visualizations
• Expertise in importing data from multiple data sources into Power BI
• Published reports into Power BI server and scheduled the datasets, provided row-level Security
• Configured Power BI gateways and enabled schedule refresh & scheduled cache refresh for Import and direct query data sources
• Maintained proper documentation of reports and updated whenever the new Iteration of data comes in
• Developed application in Power apps using Common Data Service CDS, SQL, Flow, Excel, and SharePoint
• Developed Power apps model and canvas driven apps
• Developed data capture and navigation desktop and mobile apps in Power apps that connect to distribution center solution design analytics
• Deployment of ETL code to DEV/QA/ STG/ PROD environments
• Created and managed data connections in the power center and IICS
• Shut down and start Informatica servers on Linux box during Linux servers/repository database servers patching activity
• Manage users and their access to the power center and IICS
• Worked with Informatica vendors to resolve the issues
• Developed dashboards in Qlik sense
• Created and managed data connections, tasks, triggers, and apps deployment in QMC
• Controlled content security based on security rules
• Installation and configuration of Qlik view\sense servers
• Upgradation of Qlik sense servers
• Configure and administer Qlik view\Sense using Qlik Management Console (QMC)
• Shut down Qlik servers on windows box in case of any major database server upgrade or Qlik box upgrade and verified the functionality and integrity of the server on the restoration of Servers
• Worked with the DBA, Network, and support team to diagnose and resolve database\Infrastructure issues
• Deployment of reports and packages from DEV to QA and QA to PROD
• User management
• Responsible for Interacting with clients directly to understand and freeze the business requirements
• Design and developed Meta Data Models in Cognos Framework Manager
• Developed Reports in Cognos Analytics 11.0.8
• Responsible for effective issue resolution of incidents reported via Service now
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manager
• Performance tuning of existing Cognos reports
• Effort estimations for the requirements and reevaluate the effort estimates based on scope deviations
• Involved in up-gradation of Cognos Analytics from 10.1 to 11.0.8 and provided support
• Created Projects, Namespaces, Models, and Packages using Cognos FM and deployed packages on Cognos connection

Confidential, Seattle

Team Lead

Responsibilities:

• Requirement analysis and rationalization of reporting solutions
• Responsible for Interacting with clients directly to understand and freeze the business requirements
• Prepare High/Low-level design documents for Framework Model and reports
• Design and develop Meta Data Models in Cognos Framework Manager
• Lead the team by distributing the work among the team members
• Developed Cognos Reports and Dashboards
• Involve in performance tuning of existing Cognos reports
• Performed Unit testing
• Ensure that the deliverables are delivered on time to the customer as agreed
• Production Support which involves solving user problems
• Effort estimations for the requirements and reevaluate the effort estimates based on scope deviations
• Providing support after upgrade from 10.1 to 10.2.1
• Involved in up-gradation of SSAS cubes from
• Created a new Cube in SSAS and added new dimensions\measures in existing cubes as per requirement

Environment: Cognos 10.2.1 (Framework Manager, Query Studio, Report Studio), IBM DB2, SSAS

Confidential, Cincinnati

Team Lead

Responsibilities:

• Interacted with BA on requirements and clarifications needed for the reports\models
• Interacted with On Shore Co-Ordinator to ensure a smooth transition of work between onshore and offshore
• Analyzed the Complex as well as simple reports and estimated the work involved
• Lead the team by distributing the work among the team members
• Developed Cognos Reports
• Unit Testing for Data & Layout Formatting
• Ensure that the deliverables are delivered on time to the customer as agreed
• Peer Review of the Reports and design documents
• Worked extensively on enhancements of production reports
• Attend client meetings to report weekly status on support
• Production Support which involves solving user problems
• Implemented Package, object, and data-level security in Cognos
• Created schedules for reports with heavy access traffic and long-run duration ahead of time and delivered PDF/Excel o/p straight to concerned user email boxes

Environment: Cognos 10.1 (Framework Manager, Query Studio, Report Studio), Cognos Transformer, IBM DB2.

Confidential

DW Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements
• Developed models and packages using Framework Manager
• Developed Cognos10 reports
• Developed High/Detail level design documents for FM Model and reports as per client standards
• Prepared Unit Test Cases
• Developed Cognos Reports
• Performed Unit Testing of reports
• Key contact point for providing technical inputs from offshore
• Interact with the Quality groups to ensure that the highest level of quality standards and best practices are maintained
• Handled process and technical audits

Environment: Cognos 10.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio), oracle11g

Confidential

DW Developer

Responsibilities:

• Analysis of the specifications provided by the clients
• Developed High/Detail level design documents for Framework Model and reports
• Build a DMR Model in Framework Manager
• Implemented all types of security (Data, object, Package level) in Framework Manager
• Created different types of reports according to the business user requirements
• Prepared Unit Test Cases
• Performed Unit Testing
• Experience in Scheduling of reports\Jobs
• Interact with the Client and users regularly for resolving issues about the reports delivered
• Played as a good mentor to the newly joined team by giving knowledge transition in both technical and functional areas

Environment: Cognos 10.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio), SQL Server 2008 R2, SSIS, and Cognos TM1

Confidential - New York

Report Developer

Responsibilities:

• Gathered Requirements from customers and documented the same
• Analysis of the specifications provided by the clients
• Created different types of reports according to the business user requirements
• Created list reports and crosstab reports using multiple queries in a single report and conditional formatting to highlight the business needs
• Guided and mentored the team which is also the part of the same client and helped them in their critical time delivery of reports
• Interact with the Client and users regularly for resolving issues about the reports delivered

Environment: Cognos 8.3, SQL Server 2005, Perl Script

Confidential

Cognos Developer

Responsibilities:

• Involved in analyzing & understanding the existing functionalities and requirements of the
• Cognos Report net 1.1 reports and FM Model
• Tested the migrated reports for their data miss matches and integrity
• Coordinating with the onsite folks to come up with the new solutions
• Produced bug-free reports and error-free documents and contributed to delivering products well within schedule

Environment: Cognos 8.3, Cognos Report Net 1.1, Oracle 9i