| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
E-mail: EMAIL AVAILABLECell:PHONE NUMBER AVAILABLESummary:Strong experience as IT Analyst in data analysis, data mapping, CI reports.Experienced in Power BI desktop, Cognos,Tableau, Oracle Functions, Stored Procedures, Triggers, Oracle Forms and Oracle Reports.Strong analytical and problem solving skills.Experienced in computer hardware and software audits.Strong communication skills.Education:BS, Engineering, Rigas Technical University. Riga, Latvia.Technical Skills:Tools: Power BI Desktop, Tableau, Cognos Analytics v11, OLAP Modeling, Cognos Framework Manager, Oracle Developer 2000, Oracle Forms, Oracle Reports, Actuate Reports, Gasp 6.5, Loftware, MS OfficeLanguages: SQL, PL/SQLOperating Systems: UNIX, Windows 10Databases: Oracle, SQL ServerProfessional Experience:Amsive Bolingbrook, IL Jan 2017 June 2024Senior BI Developer/AnalystConverted Cognos reports to Power BI reports, Created reports and Dashboards in Power BI desktop, created charts, graphs, calculations. Created reports and dashboards in Cognos 11 (Cognos Analytics). Created new and modify existing Framework Manager packages.Created reports for company clients and apply data security for each client.Prepared documentation for row level security and applied it for Framework Manager packages.Created documentation for company clients.Trondent Development Corporation Barrington IL November 2015 April 2016Developer AnalystPerformed detailed analysis for the company business.Created and maintained reports in SQL Server Management Studio.Analyzed data for the .php files and performed data mappings.Worked with company front end applications for data analysis and troubleshootings.Created work orders and resolved issues under customer requests.Rising Medical Solutions Incorporated Chicago IL April 2015 June 2015BI AnalystPerformed data analysis for the company new reports development.Analyzed company business and created documentation for reports development.Gathered user requirements for current and new Tableau Desktop reports.Develop visually informative dashboards, customized reports, based on business requirements.Converted old application reports into new and created new reports with Tableau Desktop.Resolve the issues with current Tableau reports and dashboards.Performed troubleshooting under user requests.Sysmind LLC/IT-Resources/Leo Burnett Chicago IL November 2014 February 2015Analyst/DeveloperPerformed data analysis and gathered user requirements for new reports.Performed data mapping for new data base.Created new Cognos reports and modified existing reports.Created new reports in SQL Server Management Studio.Created reports documentation.Focus Product Group Int Lincolnshire, IL July 2013 June 2014Cognos Developer/AdminWorked as a Cognos Developer for business users.Performed BI analysis and gave recommendations to the business.Created and maintained Linux Scripts, SQL scripts, stored procedures with Informix Database.Built Cognos reports and packages in Framework Manager for all Company departments.Created dashboards to show company sales for current year, previous year and YTD.Performed company daily operations for data load in Elite system.Gathered business requirements and performed user training.Created and maintained Cognos MDC cubes with Transformer.Created and maintained Cognos jobs.AON Corporation Chicago, IL July 2009 March 2012Cognos DeveloperBuilt complex Cognos reports using Cognos 8 and Cognos 10 suites.Identified data items through research, analysis, profiling, data mining and data discovery of the source data.Converted old application reports into Cognos reports. Performed data analysis and evaluate numbers with Excel and Adobe PDF outputs.Served as a Liaison between the business experts/users and the project technical team to ensure the users requirements are understood and interpreted correctly by the technical team.Created complex SQL queries for reports layout with drill-through items, conditional blocks and render variables.Developed Cognos reports with different chart types and drill-through sub reports.Worked with business analyst and users to analyze requirements and business rules.Created Cognos report documentation.IT Trail Blazers, LLC/Capgemini/Astellas Pharma Deerfield, IL January 2008 March 2009Cognos DeveloperBuilt complex Cognos reports using report studio to support R&D and sales and marketing functions.Worked closely with business users while gathering requirements, analyzing data and supporting existing reporting solutions.Performed Cognos user training.Managed and worked closely with offshore team on various business projects.Created and maintained Cognos packages in Framework Manager.Designed production rollout process for Cognos applications.Promoted packages to production using import/export utility.Created and maintained Cognos jobs.Created, refreshed and supported Cognos Transformer models and cubes to support timely sales operations.Performed Cognos administrative functions such as creating user accounts, user classes and roles using Access Manager.Built and maintained Cognos reporting security.Prior experience available on Request |
