Sowmya K

Business Analyst - 4 Years of Experience - Near 92008


Business Analyst


Carlsbad, CA

Education Level:


Will Relocate:



PROFESSIONAL SUMMARY Thermo Fisher Scientifc, CA Mar 2017 - Present Marketing Automation developer Thermo Fisher Scientific is an American multinational, biotechnology product development company, created in 2006 by the merger of Thermo Electron and Fisher Scientific. Thermo Fisher Scientific is dedicated to improving the human condition through systems, consumables, and services for researchers. Responsibilities: * Involved in reviewing business requirements and analyzing data sources form Excel/Oracle Server for design, development, testing of reporting and analysis projects within Tableau Desktop. * Development of ad-hoc data visualizations for analytical efforts for the marketing and predictive anlytics team. * Worked with Business users, Analysts, Team Lead and Functional Analysts to identify process improving opportunities in data analytics and data modeling. * Implementing new advancements and enhancements to translate data into visualizations. * Developed multiple SQL statements for exceptions management to exclude accounts based on complex business logic. The SQL statements were run in a batch using UNIX scripts. * Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. * Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau. * Developed complex SQL queries with multiple tables for database solutions. * Prepared sample code and applications for displaying various outcomes of API applications using PHP. Resolved technical problems relating to API application by identification and fixing bugs with adobe API explorer. * Have working knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports. Worked on Report studio, Cognos Connection. * Created/maintained an internal self-service portal used by the marketing team to disseminate insights and knowledge. Developed PHP and JavaScript language to flow information into the web portal. * Imported and exported data from saved queries used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Created pivot tables and charts using excel, modified pivot tables, and refreshed and formatted pivot tables for Marketing and Predictive teams. Experienced with trouble shooting and optimizing Report performance. * Customized data by adding filters at both the Framework level and Report level. * Created organized and formatted reports, folders and other contents on Cognos Connection Portal. * Involved in part of ETL Process for loading the data and by designing catalogs and supporting ETL Process * Customized data by adding Filters Calculations, Prompts, Summaries and Functions. * Applied three levels of security to the model (Data, Object and Package). * Applying Row and Object level security to Reports. * Performed Admin task for user permissions, scheduling the reports. * Performed Report Administrator to give set of permissions to the end user. Environment: Tableau 8.1, Oracle, Teradata, MS SQL Server, SAS, Javascript API, Tableau Server, Agile/ Scrum, UNIX / Linux.