Power Bi Developer

Chandraprakash

Senior BI Developer

E-mail: ***********@*****.***

Phone: +1-857-***-****

LinkedIn: https://www.linkedin.com/in/chandra45455/

SUMMARY

Seasoned Cognos and BI Developer with over 12 years of experience in system analysis, administration, and programming. Proven track record in leading complex technology projects, with deep expertise in Cognos Analytics, SQL, Power BI and Tableau. Skilled in report writing, cube building, and data analysis at translating technical concepts into actionable insights and leading teams through data-intensive projects. Strong communicator with excellent organizational skills and the ability to handle large datasets and distributed systems effectively.

Professional Skills

Business Intelligence (BI) Tools: IBM Cognos, Framework Manager, Query Studio, Analysis Studio,

Tableau Desktop, Power BI Desktop

Languages : SQL/Pl SQL, T-SQL

OLAP Tools : Power Cubes, IBM Planning Analytics by TM1

ETL Tools : Power Query, Snowflake, Informatica

Databases : Oracle, AS-400 DB2, SQL Server

Tools : Jira, SVN, AWS, WinSCP, performance tuning

Operating System : Windows 7 & 10,Linux

Certifications

Microsoft certified Power BI Data Analyst

Certified Designer-Cognos BI Reports

Professional Experience

Implementation Partner: Acentra Health

Client: State Of Michigan, Lansing, MI May 2023 – Current

Role: Senior Cognos BI Admin / Developer

Responsibilities

●Resolve complex production issues across the enterprise BI & Analytics ecosystem, collaborating with cross-functional teams (Infrastructure, ETL, Data, etc.) to meet deliverables and ensure continuity of operations.

●Led the successful implementation of TM1 software, resulting in a improvement in financial forecasting accuracy.

●Collaborated with IT teams to test and validate patches before deployment, ensuring minimal disruption to daily operations.

●Developed patches management strategies to address security vulnerabilities and compliance requirements in alignment with industry best practices.

●Developed and maintained TM1 models to streamline budgeting processes, reducing cycle time.

●Perform root cause analysis on BI system failures and data issues, devise, test, and implement timely and effective solutions.

●Developed, deployed, and optimized enterprise-level reports and dashboards using IBM Cognos BI V11, ensuring high performance and scalability across departments. Configured and customized Cognos features to meet complex business requirements and enhance data-driven decision-making.

●Utilized JavaScript within Cognos BI to create interactive, user-friendly report elements and to extend native Cognos functionality. This allowed for customized data visualizations and streamlined user experiences.

●Conducted risk assessments and business impact analyses to prioritize critical systems and applications for disaster recovery planning.

●Developed and implemented performance tuning best practices and guidelines for the organization, ensuring consistent optimization across all systems and applications.

●Designed and maintained Transformer and Dynamic Cubes for fast and flexible data analysis, accommodating high-volume data sets and complex hierarchies. Improved query performance and data processing speed through effective cube modeling and optimization.

●Conducted data extraction, transformation, and loading (ETL) processes using Oracle databases to feed Cognos reports and dashboards. Wrote complex SQL queries and optimized data retrieval to ensure consistent and accurate reporting.

●Utilize IBM Cognos Analytics (Framework Manager, Transformer, and Reports) to design, maintain, and enhance reports and dashboards for various business units.

● Administer and support IBM TM1 (Planning Analytics) environments, working with finance teams on forecasting and budgeting models.

●Develop and execute SQL queries for Oracle databases to retrieve, analyze, and troubleshoot data issues.

●Updated and tested disaster recovery planing regularly to incorporate changes in technology and business processes, ensuring readiness for unforeseen events.

●Conducted system audits to identify inefficiencies and implemented performance tuning strategies to enhance overall system responsiveness and throughput.

●Proactively identify recurring issues and work to develop automated solutions, streamlining processes and improving operational efficiency.

●Collaborate on automation initiatives using scripting languages such as DOS/Batch and PowerShell, reducing manual interventions in daily tasks.

●Work with job scheduling tools like BMC Control-M to automate workflows and manage job dependencies.

●Manage incident resolution using ServiceNow, adhering to defined ticket workflows and escalating when necessary.

●Participate in agile delivery cycles, utilizing tools like Azure DevOps for sprint planning, backlog management, and issue tracking.

Environment: IBM Cognos 11.1.7/ Framework Manger/Oracle 19c / performance tuning

Implementation Partner: Client Network Services India (CNSI)

Client: State of Illinois Oct 2021 – Apr 2023

Role: Senior Cognos BI Admin / Developer

Responsibilities

●Lead the development and implementation of Cognos Analytics solutions, including report writing, cube building, and data analysis.

●Enhanced TM1 reporting capabilities by creating customized reports, leading to a increase in data visualization efficiency.

●Provided training and guidance to staff members on disaster recovery procedures and protocols to enhance organizational resilience.

●Researched and recommended new technologies and tools to support performance tuning efforts, staying current with industry trends and innovations

●Designed and executed complex SQL queries for data extraction, analysis, and reporting, supporting business decision-making processes.

●Utilized Tableau for visualizing complex data and delivering actionable insights to stakeholders.

●Coordinated with cross-functional teams to manage and prioritize multiple technology-based projects, ensuring alignment with business objectives.

●Implemented data lineage and traceability processes to support user inquiries and maintain data integrity.

●Documented performance tuning processes, procedures, and outcomes to ensure knowledge sharing and continuity within the organization.

●Conducted training sessions for team members on TM1 functionality, improving overall team proficiency.

●Collaborated with cross-functional teams to gather business requirements and design TM1 solutions to meet company needs.

●Provided technical leadership and mentorship to junior developers, fostering a collaborative and productive team environment.

Environment: performance tuning / IBM Cognos 11.1.7 / Oracle 12c/Cognos Admin/ Cognos Framework Manger

Implementation Partner: Client Service Network India (CNSI)

Client: Mizuho Bank, NY. Jan 2020 – Sep 2021

Role: Power BI Developer

Responsibilities

●Extract data from various sources, including SQL databases, ERP systems, and external APIs.

●Cleanse, transform, and model data to ensure accuracy and consistency using Power Query and DAX (Data Analysis Expressions)

●Integrate data from multiple sources to create a unified data model that supports comprehensive reporting

●Customize reports to meet specific business needs, ensuring they align with the bank’s requirements and regulatory standards

● Optimize the performance of Power BI reports and dashboards to handle large volumes of data efficiently

●Oversaw the timely deployment of software patches and updates, resulting in a reduction in system vulnerabilities.

●Mentored junior team members on performance tuning techniques and best practices, fostering a culture of continuous learning and improvement.

●Utilized various Power BI visualizations (charts, graphs, maps) to represent data effectively and facilitate insights

●Design intuitive user interfaces to enhance the user experience and make data exploration easy for stakeholders

●Regularly gather feedback on reports and dashboards to make iterative improvements and ensure they meet user expectations.

●Provided training and support to end-users on how to use Power BI reports and dashboards effectively

Environment: Power BI, Snowflake, SQL Server

implantation Partner : Client Service Network India (CNSI)

Client: Pacific Life Insurance, Newport Beach, CA Feb 2016 – Dec 2019

Role: Tableau Developer

Responsibilities

●Understand and analyze business requirements to identify data visualization and reporting needs.

●Work closely with stakeholders to gather and comprehend data requirements.

●Design and develop interactive and visually appealing dashboards and reports using Tableau.

●Create various charts, graphs, and other visualizations to represent data insights effectively.

●Connect Tableau to different data sources, including databases, spreadsheets, and cloud-based data warehouses.

●Develop data models and data extracts to support reporting requirements.

●Improve data refresh and update performance for Tableau dashboards.

●Collaborate with other members of the business intelligence team, data engineers, and data scientists to ensure alignment with overall data and analytics strategies.

●Provide training to end-users on how to use Tableau dashboards and reports.

●Implement security measures to ensure that Tableau dashboards and data are accessed only by authorized users.

Environment: Tableau, Business Intelligence, Data Warehousing, Oracle, SQL Server

Implementation Partner: Wipro Technologies

Client: Dillard’s Strategic Network, Houston, Tx March 2015 – Feb 2016

Role: Cognos Developer

●Creates, modifies, enhances and maintains Framework Manager Models within Cognos BI

●Good Experience in Cognos environment setup, Upgradation

●Developed and maintained Cognos Reports, Dashboards and Cubes to provide actionable insights for business stakeholders. Implemented performance optimizations results in 30% reduction in report generation time.

●Responsible for data analysis, designing, developing, and testing reports in Cognos 10.x for the various

●disciplines within organizations in accordance with standard team processes.

●Involved in analysis of requirements, preparing design documents, coding, and Unit Testing by following the Software Development Life Cycle (SDLC) Process.

●Involved in the comprehensive transition of project technology from USA team.

●Commendable contribution towards the improvement of the process through ideas.

●Dedicated work attitude to submit the deliverables on time.

●Maintaining project related documents according to quality standards.

Implementation Partner: Wipro Technologies

Client: Mercedes-Benz, Troy, MI Oct 2012– Feb 2015

Role: Cognos Developer

●Generated detailed data on your loan portfolio so that you can increase profits and scale. Reduce manual labor and increase profit.

●Involved in code review process and followed best practice standard in project.

●Creation of Unit test plan and Unit test result to support the code changes.

●Coordinating with onsite and offshore teams.

●Effectively handled Production support primary and secondary responsibilities without any issues.

●Implemented Dynamic Header & Footers for 200 Cognos Reports which saved 20 % overall efforts.

●Proficient in Active Reports & Mobile Reporting. Experience with RAVE visualizations is desirable

Education: Bachelor of Technology (ECE) from JNT University

Contact this candidate