Sashank Viduluri
North Bergen,NJ
Summary
Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. Adept at performance optimization and tuning for servers, queries and business intelligence reports. Proficient in technology tools such as Power BI, Tableau,SSRS and Cognos. Well-organized and resourceful with a thorough understanding of business operations.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Business Intelligence Developer
Prudential Financial
Newark, NJ
10.2022 - Current
- Enhanced data visualization capabilities by migrating from Cognos to Tableau/Power BI.
- Resolved issues related to data integrity, accuracy and completeness while ensuring that all deliverables adhere to quality standards.
- Participated in team meetings discussing project progress and providing feedback about possible improvements in design and functionality.
- Generated reports through the utilization of Cognos, Power BI Paginated, Tableau and Power BI with the implementation of complex SQL queries.
- Assisted in designing database objects such as tables, views, indexes and stored procedures based on functional specifications.
- Developed KPI dashboards using Power BI that provided visibility into operational performance metrics.
- Developed reports from multiple sources utilizing reporting tools such as Tableau or Power BI with drill-down capabilities to analyze trends over time.
- Implemented Power Automate workflow for seamless automated report delivery upon data availability.
- Provided training sessions on the use of tools such as Power BI or Tableau for end users so they could generate their own reports more efficiently.
- Provided technical expertise in the development of BI solutions with a focus on performance optimization.
- Conducted training sessions for end-users on how best to utilize the BI platform or specific toolsets.
- Tested new releases of software prior to deployment in order to verify functionality works as expected.
- Engaged with business users to gather, define and document reporting requirements.
- Implemented best practices related to database design, coding standards, query optimization and error handling strategies.
- Maintained version control over all code changes within the BI environment including stored procedures, views and functions.
- Worked closely with other teams such as software developers and database administrators to ensure timely delivery of projects.
- Updated tracking documents, generated different reports, and gave presentations on findings.
- Obtained and evaluated information on hardware configuration costs, reporting requirements and security needs.
- Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
- Coordinated testing and validation procedures through software development lifecycle.
- Recommended improvements to facilitate team and project workflow.
- Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
- Developed user-friendly page for accessing multiple platforms reports.
- Mentored junior developers, enhancing overall team skills.
- Applied best practices in coding standards and style guides consistently.
- Exception handling implementation to increase program stability.
Tableau Developer and Cognos Developer
IBM, Global Business Services (Prudential)
Hyderabad, Telangana
05.2019 - 10.2022
- Researched new ways to visualize data in Tableau for enhanced presentation of results.
- Developed complex calculations using Tableau functions such as LOD expressions and table calculations.
- Collaborated with stakeholders to understand business requirements and develop appropriate visualizations.
- Tuned queries for optimal performance when connecting to databases through Tableau Server or Desktop environment.
- Worked closely with BI teams to ensure that the right data is being extracted from source systems into the Data Warehouse layer for reporting purposes.
- Provided technical support on existing dashboards and reports by troubleshooting issues related to data accuracy or report functionality.
- Developed interactive drill down features across multiple levels of detail within dashboards.
- Developed and maintained Tableau dashboards with interactive visualizations.
- Optimized SQL query execution times by making use of indexes and partitioning techniques in order to improve report performance.
- Implemented best practices for optimizing the performance of Tableau reports and dashboards.
- Managed the entire life cycle of projects from design and development through implementation and maintenance.
- Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements.
- Integrated various external APIs with Tableau to enable real-time streaming of live data sets.
- Created visual representations of product categories and relationships, using Tableau dashboards to highlight desired aspects of key financial and performance indicators.
- Manipulated Tableau parameter controls, hierarchies and filters to achieve LOD expressions and geospatial design configurations leveraging multiple data joins for comprehensive analysis.
- Reviewed project requirements to identify customer expectations and resources needed to meet goals.
- Recommended improvements to facilitate team and project workflow.
- Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
- Established clear system performance standards and wrote specifications.
- Deployed a variety of reports to meet business needs.
- Developed Cognos BI Reports using Report Studio and Query Studio.
- Created complex report models with multiple data sources, calculations and filters in Framework Manager.
- Tested and validated the integrity of new and modified reporting objects before deployment into production environment.
- Maintained documentation such as metadata models, report specifications, data marts and warehouse design documents.
- Implemented best practices around development methodologies such as Agile and Waterfall model.
- Worked closely with Business Analysts and Project Managers to gather requirements and deliver timely results.
- Configured Cognos Transformer cubes for use in Analysis Studio and Report Studio applications.
- Provided technical support for end users on various aspects of Cognos Reporting tools including installation issues, configuration issues.
- Assisted in developing training materials and conducted trainings for end users on usage of Cognos tools.
- Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
Senior Cognos Developer
IBM
Hyderabad, Telangana
01.2019 - 05.2019
- Developed complex report models in Framework Manager to support reporting needs.
- Tested various versions of software components for compatibility issues before deployment into production environment.
- Collaborated with IT teams in resolving any technical issues related to implementation of new features or upgrades of Cognos environment such as patches or service packs installation .
- Created SQL queries to extract data from Oracle and MS-SQL databases for use in Reports and Cubes.
- Configured content store database and maintained it as per requirement changes.
- Implemented security measures to ensure privacy of sensitive information within Cognos applications.
- Analyzed business requirements, created technical specifications and managed the development of Cognos solutions.
- Deployed Cognos packages onto multiple environments including DEV, UAT and Production server environments.
- Performed regular maintenance activities such as creating backups, archiving old datasets, purging logs .
- Provided guidance on best practices for developing efficient reporting solutions.
- Worked closely with Business Analysts and End Users to ensure that their reporting requirements are met accurately according to their specific needs.
- Developed data cubes with OLAP Cubes for complex analysis and reporting.
- Resolved user complaints regarding slow running reports or errors encountered during execution of the same by optimizing query performance through indexing techniques or by modifying the underlying query design if required .
- Designed, tested and developed Cognos reports using Report Studio ,Query Studio and Event Studio.
- Debugged existing reports, identified problems and provided performance tuning improvements.
- Implemented best practices around development methodologies such as Agile and Waterfall model.
- Optimized existing Cognos packages for improved performance and scalability.
- Configured Cognos Transformer cubes for use in Analysis Studio and Report Studio applications.
- Assisted users with troubleshooting problems related to their reports or dashboards.
- Assisted in developing training materials and conducted trainings for end users on usage of Cognos tools.
- Created complex report models with multiple data sources, calculations and filters in Framework Manager.
- Deployed a variety of reports to meet business needs.
- Tested and validated the integrity of new and modified reporting objects before deployment into production environment.
- Worked closely with Business Analysts and Project Managers to gather requirements and deliver timely results.
- Provided technical support for end users on various aspects of Cognos Reporting tools including installation issues, configuration issues.
- Coordinated testing and validation procedures through software development lifecycle.
- Assessed code during testing stage to determine potential glitches and bugs.
- Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
- Updated software upon release of vendor patches to mitigate vulnerabilities.
- Regularly communicated progress updates with stakeholders and clients.
- Applied best practices in coding standards and style guides consistently.
Sr. Cognos Developer (C10.2 to C11.11 Migration)
IBM
Hyderabad, Telangana
07.2018 - 12.2018
- Successfully transitioned company's analytics platform from Cognos 10.2 to Cognos 11.11
- Successfully migrated Framework manager packages from CQM to DQM.
- Designed, tested and developed Cognos reports using Report Studio,Event Studio and Query Studio.
- Installed the Framework manager and used it to develop complex report models that supported reporting needs.
- Deployed Cognos packages,reports onto multiple environments including DEV, QA,UAT and Production server environments.
- Provided technical support for end users on various aspects of Cognos Reporting tools including installation issues, configuration issues.
- Tested and validated the integrity of new and modified reporting objects before deployment into production environment.
- Enhanced report formatting according to user preferences utilizing all functionalities in Report Studio like Drill Down, Crosstabs, Master/Detail and Blocks.
- Provided guidance on best practices for developing efficient reporting solutions.
- Performed regular maintenance activities such as creating backups, archiving old datasets, purging logs .
- Collaborated with IT teams in resolving any technical issues related to implementation of new features or upgrades of Cognos environment such as patches or service packs installation .
- Applied best practices in coding standards and style guides consistently.
Senior Cognos Developer
IBM DirectTV
Bangalore, Karnataka
01.2016 - 06.2018
- Developed custom scripts to automate generation of monthly financial reports.
- Maintained documentation such as metadata models, report specifications, data marts and warehouse design documents.
- Optimized existing Cognos packages for improved performance and scalability.
- Implemented best practices around development methodologies such as Agile and Waterfall model.
- Created complex report models with multiple data sources, calculations and filters in Framework Manager.
- Tested and validated the integrity of new and modified reporting objects before deployment into production environment.
- Provided technical support for end users on various aspects of Cognos Reporting tools including installation issues, configuration issues.
- Developed Cognos BI Reports using Report Studio and Query Studio.
- Configured Cognos TM1 cubes for use in Analysis Studio and Report Studio applications.
- Developed and implemented TM1 cubes.
- Ensured smooth functioning of report generation process through diligent monitoring and timely resolution of debugging tasks.
- Managed and allocated user access to the cognos TM1 area upon request.
- Contributed to cube management by carrying out various ad-hoc functions and integrating data proficiently.
- Strengthened cube security through necessary updates.
- Developed user-specific reports utilizing various features in Report Studio including Drill Down, Crosstabs, Master/Detail, and Blocks.
- Developed and implemented new report formats
- Coordinated system installations, testing, and code corrections.
- Performed ad-hoc analysis on large datasets by writing complex SQL queries against SQL Server databases.
Cognos Developer
IBM, State Farm Insurance
Hyderabad, Telangana
08.2014 - 12.2015
- Incorporated Cognos technology into business operations by converting BO reports, optimizing efficiency.
- Developed Cognos BI Reports using Report Studio and Query Studio.
- Implemented strategies to optimize report efficiency through the application of sorting, ranking criteria and cascading prompts for improved data presentation.
- Utilized all the capabilities of Report Studio to tailor reports based on user needs including Drill Down, Crosstabs, Master/Detail and Blocks functionalities.
- Oversaw estimation preparation, provided weekly reporting to clients, and coordinated task delegation among team members.
- Utilized BO Environment tools (Infoview, Webi, Crystal) to analyze reports.
- Created complex report models with multiple data sources, calculations and filters in Framework Manager.
- Generated reports with various features like conditional formatting and Burst functionality, utilizing prompt options such as Value, Select & Search, and Date & Time. Additionally, incorporated Bookmarks, Hyperlinks, and HTML items in the reports.
- Prepared documentation as and when required while doing a particular task for further future use.
- Tested and validated the integrity of new and modified reporting objects before deployment into production environment.
Cognos Developer
Lufthansa Airlines IBM
India, Kolkata
02.2012 - 08.2014
- Monitored system performance metrics like CPU utilization, disk I and O activity to ensure optimal functioning of the BI platform.
- Developed Cognos BI Reports using Report Studio and Query Studio.
- Performed regular and meticulous monitoring of System Status Check and Automated Reports.
- Deploying Reports and Packages across different environments.
- Tested and validated the integrity of new and modified reporting objects before deployment into production environment.
- Performed thorough analysis of error messages in Reports and implemented necessary fixes
- Managed job creation and updates to meet specific needs, while tracking progress of manual tasks.
- Refreshed the Caches.
- Utilized versatile techniques such as Conditional Variables, drill-through capabilities, and Cascading Prompts to create diverse reports aligned with specific user needs.
- Utilized Report Net features such as Drill Down, Crosstabs, Master/Detail, and Blocks etc. to create new reports.
Education
Master of Science - Computer And Networking
Sheffield Halam University
Sheffield UK03-2010
Bachelor of Science - Computational Science
JNTU Hyderabad
Hyderabad India04-2007
Skills
- SQL server
- SnowFlake
- Fabric
- Data Warehousing
- Report writing skills
- Critical thinking abilities
- Agile Methodology
- Business Intelligence
- Data Modeling
- Client management
- Data extraction
- Report Generation
- User Training
- Data Validation
Certification
- Tableau Desktop Certified Associate
- IBM Certified Designer Cognos 10 BI Reports
- IBM Certified Designer Cognos 10 BI Multidimensional Reports
- IBM Certified Designer Cognos 10 BI Metadata Models
- IBM Certified Specialist Cognos TM1 10.1 Data Analysis
- IBM Certified Developer Cognos TM1 10.1
Timeline
Business Intelligence Developer
Prudential Financial
10.2022 - Current
Tableau Developer and Cognos Developer
IBM, Global Business Services (Prudential)
05.2019 - 10.2022
Senior Cognos Developer
IBM
01.2019 - 05.2019
Sr. Cognos Developer (C10.2 to C11.11 Migration)
IBM
07.2018 - 12.2018
Senior Cognos Developer
IBM DirectTV
01.2016 - 06.2018
Cognos Developer
IBM, State Farm Insurance
08.2014 - 12.2015
Cognos Developer
Lufthansa Airlines IBM
02.2012 - 08.2014
Master of Science - Computer And Networking
Sheffield Halam University
Bachelor of Science - Computational Science
JNTU Hyderabad
Similar Profiles
Task MorelandTask Moreland
NA at The Prudential Insurance Company of America, Prudential FinancialNA at The Prudential Insurance Company of America, Prudential Financial
Ethan NadeauEthan Nadeau
Quality Coach, Subject Matter Expert at Prudential FinancialQuality Coach, Subject Matter Expert at Prudential Financial
Ram KakarlaRam Kakarla
Salesforce Functional Lead at Prudential FinancialSalesforce Functional Lead at Prudential Financial
Molly K. McCaugheyMolly K. McCaughey
Disability Claims Specialist at Prudential FinancialDisability Claims Specialist at Prudential Financial
Melany CaroMelany Caro
ABA Therapist at Circle Care ServiceABA Therapist at Circle Care Service