data analyst

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: Expert in SQL Server, Oracle and MS Access Databases Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script Expert in excel Macro Expert in C & C ++ Programming I have experience in all the above areas which I have gained during execution of project work As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble

Dear Sir/Madam: I am a software developer certified and with formal universitary studies in language, translation, management as weel as MOOC course on software engineering, with experience as a data analyst, including web crawling by using Python raw modules as well as Scrapy or a mix of tools including browser emulation, captcha outsourced services and javascript data rendered web pages. I do ETL, data mining and BI. I work with SQL (Remote Access or Downloaded base), Spreadsheets any vendor (its API) as well as Python, R, QlikView and I have worked with RapidMiner fro data visualization, KPIs the like. I have knowledge support form statistics for business and Economics and Finance maths. Proposal variables: Time: See proposal Quality: All the data you need according to industry standards. Scope: DA specified information according to your post. Delivering results as required (almost all known formats). Cost: See proposal. I look forward to work for you. Please, do not hesitate to message me for further details or before any doubt.I am free and ready to start.. Sincerely yours. Dario A.

1) 5.4 years of Experience in Data Analytics, Report Generation, Maintenance of Business Report Processes and Data Verification's and Validations 2) Extensive SQL experience in querying and data extraction 3) Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point. 4) Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs. 5) Wrote several Teradata SQL Queries using Teradata SQL Assistant for Adhoc Data Pull request. 6) Used Joins like Inner Joins, Outer joins while creating tables from multiple tables 7) Created pivot tables in Excel by getting data from Teradata 8) Create profiles for loyalty member who hold the Sears membership card and write insights after analyzing profile 9) Manage and update report orientation and structures with the use of advanced Excel functions including Sumifs and V-Lookups 10) Analyze information like Summary Statistics, BU shopping, Segmentation, Trips, Demographics that easily fulfill the requirements related to a particular member or group of members

Hi, I am Asif from Pakistan. I have 7 years of experience in the field of DWH and BI. I have worked in Oracle, MySQL, MSSQL and Netezza and on reporting tools like Cognos and MicroStrategy. I want to make clear things about this project like: 1- What do you want, a developer which will develop a data warehouse on an oltp or an analyst who will do some reporting or data extraction from an OLTP structure? 2- What kind of data that will be. (Want to know about the business domain).? 3- What kind of analysis do you require?

Hi I am a big data engineer with 3 years of experience. I have been working on big data and analytics solutions, for inform decisions. I have know how of using the right tools at right moment to make data analytic platform for both structured and nonstructured data. I can do this project for you. looking forward for your response for further deep dive into the project Thanks

I would like to apply for the job of Business Intelligence in your country and in your company. I am an IT professional with more than nine years of experience in difference projects of business intelligence. Senior architect specialist in data mining and reporting with different BI tools. I was part of technical teams in these years as technical reference where we developed and created some solutions applications with different BI tools for example: QlikView, SAP BI/BO, Business Object, MicroStrategy, Oracle, Teradata, Powercenter, DataServices, Reporting, ETL…I have so many knowledge about Data Warehouse systems in different Architectures and I have enough knowledge and ability to understand some business models thanks to my experience working for banking, insurances, telecom, finance & risk, retail and services companies. My work can summarised in work with Business user to understand the user requirements, layout, and look and feel of the application to be developed and analyse and transform business requirements of the Client into Logical and Physical BI solutions. This has given me experience of dealing with internal and external clients, as well as managing experience of dealing with final users, high direction and external consultants. I am now studying English at the Private Languages School, taking the B.2 level course. I am an enthusiastic worker, and I enjoy work in a team and I enjoy creating good solutions for business users. Also I could start work immediate

Hello I am master in GIS, Cartography and Analysis. I finished study in AGH (Poland) and IFNTUOG (Ukraine). I can do your tasks fast. Best regards Michael

Hi Let me introduce myself. I am certified Microsoft Data Analyst working with SQL Server an it's analysis and reporting services. Thanks Archil