MS is a certified BI Developer and a System Architect. He is a specialist in data warehousing and business intelligence systems. He has significant experience in building and implementing BI solutions, business analytics and comprehensive business reporting. He is an expert in the design of data warehouse. His technical strengths include advanced skills in system design, integration and data modeling and process optimization. MS has worked extensively with the following technologies: MS SQL Server 2000/2005/2008/2008 R2/2012, PL/SQL, MDX, T-SQL, SSIS, SSAS, SSRS.
Get Your Microsoft SQL Server Development Project Started Today!
Post your Microsoft SQL Server development project on oDesk, the world’s largest online workplace, and hire skilled SQL server consultants to develop, configure, and encrypt your databases in MS SQL Server, or to manage your Microsoft SQL Server training. These experienced freelancers can transfer your MS Access database to Microsoft SQL Server, configure your server and set up your mobile or web application databases, or manage your Microsoft SQL Server data dictionary and develop, review or configure your stored procedures, triggers, and other DB objects for your applications.
Microsoft SQL Server development is the process of configuring a server and building databases for a specific software project using Microsoft’s relational database management system. On oDesk, companies hire talented SQL server developers who have experience in Microsoft SQL Server development, as well as other technologies (i.e. Visual Studio, the ASP.NET MVC framework, C# and Microsoft SQL Server Data Tools), to help them build end-to-end business management applications; and manage their back-end development using Microsoft SQL Server.
Microsoft SQL Server Programming Job Cost Overview
Typical total cost of oDesk Microsoft SQL Server Programming projects based on completed and fixed-price jobs.
oDesk Microsoft SQL Server Programming Jobs Completed Quarterly
On average, 111 Microsoft SQL Server Programming projects are completed every quarter on oDesk.
Time to Complete oDesk Microsoft SQL Server Programming Jobs
Time needed to complete a Microsoft SQL Server Programming project on oDesk.
Average Microsoft SQL Server Programming Freelancer Feedback Score
Microsoft SQL Server Programming oDesk freelancers typically receive a client rating of 4.66.
• About 13 years of Information Technology experience in development, testing, documentation, and maintenance of applications. • Over 10 years of experience in developing Cognos Applications including Relational and Dimensional modeling, that includes over 4 yrs of experience with Cognos 8.x • Migrated to Cognos 10.2 from Cognos 8.4. • Identified determinants, relational dimensions, and measure dimensions. Identified hierarchies and scope relationships to create Dimensionally Modeled Relational (DMR) packages • Expertise in different aspects of Information Technology including System/Software Development Life Cycle (SDLC), Project Management, Change and Business Process Management etc. • Excellent team player be it cross-functional team or functional team. • Expertise with Cognos tools such as Cognos8.x, ReportNet, Impromptu, PowerPlay; Impromptu Web Reports (IWR), PowerPlay Enterprise Server (PPES), Upfront, Transformer, Access Manager, Architect, and Scheduler, Framework Manager. • Involved in the process analysis, catalog design, Package design and performance optimization of Business Intelligence Reports • Created Business Intelligence Reports using Cognos Impromptu and Cognos PowerPlay. • Developed OLAP solutions using Transformer and Framework Manager. • Administered Access Manager to implement Security among Cognos applications. • Installed and Configured PowerPlay Transformer and/or Cognos8.x Framework Manager for building multidimensional Cubes. • Automated Reports and generated documents using Scheduler. • Created and managed reports in Zero-footprint environment using ReportNet, Cognos8 (Report Studio, Query Studio, and Analysis Studio). • Created Packages (Multiple data sources including PowerPlay cubes) using Framework Manager and published to ReportNet, Cognos8.x. • Used Drill through, prompts, filters, and complex calculations in Cognos8, ReportNet, Impromptu and PowerPlay. • Created report and reports with sub reports using Crystal Reports, converted reports in Crystal reports to Cognos8 reports. • Did statistical Analysis using SAS Enterprise Guide. • Macros for automation of MS Excel reports, Showcase 7.1 Queries. • Created Dashboards using Tableau 8.0 • Created Dashboards using PowerPivot for Excel 2010
Hi, i'm Dmitry. I have 11 years experience in the banks IT. My main goals are deadlines compliance, data quality of performed work, find the best solutions for tasks through communication with the clients. Since 2003, I have been supporting and developing banking software and reporting. I have experience in accounting, reporting, loans and provisions. Main skills: - SQL, Oracle, PL/SQL, Forms, MS-SQL, T-SQL - SAP BusinessObjects, Oracle BI - Java - VBA (Access, Excel) - Accounting, Reporting Сertificates: - Architect Enterprise Applications with Java EE - IT100 - Introduction to Testing Applications
I have 25+ years of experience working with Access, Excel, and the integrating them into a harmonious fluid applications, whether it be for the Desktop, on a WAN or over the Internet. I specialize in Finance and Manufacturing, including CRM, Inventory and Work Order Management, Job Costing, AR, AP, Purchasing and Sales Forecast Automation, etc. I feel those environments are structurally synonymous with most any other scenario. Working in Finance and Manufacturing, I could not afford to make mistakes. My work ethic developed beginning with my father and being in the Military, in the field of Aviation, where a tiny mistake could cost lives. I am detail oriented with an eye for efficient user friendly complete, from the ground up, to the most custom app imaginable. I have proven complex methods that are far more efficient than the conventional developer, regardless of how well they score on a test; I am the person that goes the extra mile(s) to adhere to the rules of development while maintaining a fluid user friendly interface. I develop from the ground up or customize pre-existing systems. Whether I am developing in Access or Excel, I always structure the data for easy possible future migration, regardless of the interface. An interface can be easily replicated, but carelessly stored data can be very costly. My interfaces are fluid and user friendly. They utilize as much as the available functionality permits, by using Drop-down and List Boxes, and applying Event Code to link to related data without having to return to a menu or dashboard. I am extremely fluent in VBA, using various Object Models, i.e. Access, Excel, DAO, ADO, SQL, Class Modules, etc. I write code that a lay-person can understand. Where this is not possible, I comment the purpose and flow of the Code. I do not implement limitations, as a lot of developers do, that force the Client to always call on the developer every time a little change is needed. I develop in such a way that considers future expansion. The only time I would ever need to be called upon is to implement new functionality. I prefer to teach Clients the basics so that they can make the subtle physical design changes to the interface that they want, without destroying the integrity of the system. Because I follow the rules of development, the system is straight forward and easily understood.
* Over fifteen years of solution delivery lifecycle experience combining technical and business acumen with a proven track record of delivering successful project rollouts * An effective leader with demonstrated success in planning and managing project teams and schedules, while maintaining a fulfilling environment for team members * Strong background in project methodology, systems analysis, and solution delivery * An enthusiastic and motivated self-starter with proven technical experience in architecture design and software delivery * Ability to deliver solutions which apply best practices and industry experience to meet project goals and ensure long-term viability * Strong technical background and communication skills providing a natural ability to communicate at all levels within an organization Specialties: * Technical Architecture * High-Availability Applications * Business Intelligence * Portal and Enterprise Content Management * Java/J2EE, Microsoft .NET, PHP * Mobile: IOS, jQuery Mobile Certifications: * Salesforce.com Certified Administrator (WI13)
I am willing to get involved in projects in which I can apply my experience as Business Analyst, Financial Analyst or Software Developer. I can drive the process of developing an idea and then realize the software development process. I have been working in the banking industry for more than 2 years and could be useful in the development of financial projects. During that time I was improving internal processes by implementing new functionality and fixing bugs in bank's software, managing databases etc.
I love helping people and building efficient files to help the user. I am a credentialed actuary with a bachelor's degree in mathematics. My experience includes creating numerous tools using Excel and Visual Basic in order to solve complex problems in the healthcare industry. My goals include advancing in my actuarial career and continuing to help others with their professional needs. My hobbies include running competitively and coaching. Let me know where I can help!