Sathya Raj Eswaran's Email Addresses & Phone Numbers

Senior Business Intelligence Reporting Analyst @ Optum Elsegundo CASenior Business Intelligence Reporting Analyst @ Optum Elsegundo CABusiness Intelligence Developer @ HealthCare Partners • Responsibilities:• Develop sophisticated dashboards in Tableau to satisfy the needs of business requirement.• Performance optimization of dashboards with huge volume of data.• Design and develop Tableau reports to ensure all the business requirements are...

Senior Business Intelligence Reporting Analyst @ Optum Elsegundo CASenior Business Intelligence Reporting Analyst @ Optum Elsegundo CABusiness Intelligence Developer @ HealthCare Partners • Responsibilities:• Develop sophisticated dashboards in Tableau to satisfy the needs of business requirement.• Performance optimization of dashboards with huge volume of data.• Design and develop Tableau reports to ensure all the business requirements are met and provide enhanced Solution that meets client needs. • Analyze Business Requirements and prepare Design document• Refresh and publish the data and dashboards to the Tableau server. Scheduling the data source refreshes using windows batch file with Tabcmd scripts.• Extracting data from different sources connecting them and used the same to create dashboard • Created data blending in case of merging two different datasets.• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.• Provide mockup dashboards to business.• Creating Reports in SSRS .• Creating ETL solutions using SSIS.• Building Framework Manager Packages for using in Report Studio reports.• Developing summary and detail reports using Cognos Report Studio using lists, crosstabs, various charts, drill through.• Integrated Cognos reports with Tableau for more detailed reporting, using URL actions, and passing filter values from Tableau to Cognos.• Responsible for requirement gathering from business and prepared the requirement specification document and mapping document.• Defined best practices for Tableau report development. • Coordination with the Business and clarify the requirements and document the same.• Environment:• BI Tools: Tableau Desktop V8.2/9.0, Tableau Server V8.2/V9.0.3, Cognos Report Studio 10.1.1, Cognos Query Studio, Cognos Framework Manager, SSIS ,SSRS,• Database: SQL Server 2008R2,2012 Elsegundo CAData Analyst @ Cigna Responsibilities:• Develop sophisticated dashboards in Tableau to satisfy the needs of business requirement.• Performance optimization of dashboards with huge volume of data.•Responsible for requirement gathering from business and prepared the requirement specification document.•Preparation of Data mapping documents for data loading in to TruCare.•Preparation of Data mapping documents for 278 Vendor Delegated Authorization in to Trucare.•Coordination with the Business and clarify the requirements and document the same.•Creation of user stories in Rally and distribute the work to Development team and QA.•Providing support for existing .Net applications like BBT and DS Viewer.• Design and develop Tableau reports to ensure all the business requirements are met and provide enhanced Solution that meets client needs. • Analyze Business Requirements and prepare Design document• Provide mockup dashboards to business.• Building Framework Manager Packages for using in Report Studio reports.• Developing summary and detail reports using Cognos Report Studio using lists, crosstabs, various charts, drill through.• Works as a SCRUM analyst and creation of user stories in the Rally.• Designed, developed and enhanced the application in .NET Framework 4.0Environment:• BI Tools: Tableau Desktop V8.2/9.0, Tableau Server V8.2/V9.0.3, Cognos Report Studio 10.1.1, Cognos Query Studio, Cognos Framework Manager,SSIS,Informatica• Modelling Tools: Cognos Framework Manager• Database: SQL Server 2008R2,2012• Agile tools: Rally• Development : Visual studio .Net 4.0,ASP.Net,C# From October 2014 to September 2015 (1 year) Bloomfield CTLead Engineer @ Wipro • Work with Business Analyst to understand the user requirements and look and feel of the dashboards to be developed and prepare Design document• Provide mockup dashboards to business• Develop sophisticated dashboards in Tableau to satisfy the needs of business requirement.• Created dashboard using parameters, sets, groups and calculations.• Created drill down and drill up in worksheets.• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.• Created and developed Databases, Tables, Indexes, Stored procedures, Views, Triggers in SQL server.• Design and develop Cognos reports to ensure all the business requirements are met and provide enhanced solution that meets client needs.• Production Support and Maintenance- Maintenance of Production, Staging and Development environment data and application.• Responsible for requirement gathering from the Business Analyst’s and for preparing the Requirement Specification Document.• Designed, developed and enhanced the application in .NET Framework 3.5.• Developed Windows Services using C#.• Used ASP.NET Validation Controls and JavaScript to perform various Client side validations.• Used ADO.NET extensively for retrieving, querying and manipulating data in the database.• Extensively used Data bound controls like Grid view, Data List and Data Repeater controls.• Created and consumed Web Services to expose the application functionality for different applications running inside the company & outside, implementing a Service Oriented Architecture (SOA).• Configuring the Telerik controls in the application.• Build and Release management.Environment: Windows 2008 server, IIS 6.0 ,IIS 7.0, MS-SQL Server 2005,2008 R2, VSS, HTML, XML ,JavaScript, CSS , ASP,RMP JavaScript, Visual Studio .Net Professional 2005, 2008, Telerick controls, C#, VB, Free marker, RMP java script, Web service, Fusion,Tableau,Cognos Report Studio,SSIS ,SSRS. From July 2010 to October 2014 (4 years 4 months) Hartford, Connecticut AreaSenior Software Engineer @ iSOFT • Coding based on the technical design and following coding standards. • Performance tuning of complex time consuming queries• Developing automation tools to reduce manual effort there by reducing the cost of resources involved.• Providing fixes to issues by doing a thorough root cause analysis and impact of the defect.• Build and Release management.• Calculate the Query plan of stored procedure and made the necessary changes to the stored procedure.• Providing solutions to the developers for the tuning of stored procedures according to the coding guidelines provided by Organization and Microsoft.• Customized the applications which should comply with Organizations own standard• Responsible for the design and development of builds, SQL stored procedures, hosting the application including source code control and issue tracking.• Developed Tables, Stored procedures, Views, Functions and Triggers to perform automated rules, updating to related tables using SQL Server 2005.• Involved in GUI design for the project using Master and Content Pages along with User Controls.• Worked on Grid Views to Edit/Display/Modify the cases information.• Application will track the code which violates the coding standards.• Coding violation results are exported in Excel and PDF through FXCop report Analyzer tool and providing necessary actions suggested by Microsoft• Perform complete testing of Web applications unit and system, engaging development team as necessaryEnvironment: Windows 2008 server, IIS 6.0 ,IIS 7.0, MS-SQL Server 2005,2008 R2, VSS,CM Synergy, HTML, XML ,JavaScript, CSS, Remedy, Visual Studio .Net Professional 2005, C#, Web service From January 2007 to July 2010 (3 years 7 months) Chennai, Tamil Nadu, India