I have 10+ years of experience in IT industry, 8 of which are specific to Data Management technologies. During my career I had the oportunity to coordinate and lead diverse groups of people for different IT projects including government entities deployments, and major data center migrations. I have experience on customer requirement analysis, service performance reporting, lean sigma (basic), database architecture assessment and design and implementation of database solutions. Also have Senior Level experience on SQL Server technologies (2000/05/08/12) that includes but not limited to: HIgh availability environments (clustering, mirroring), T-SQL, automation, SSRS, SSIS, SSAS, Disaster Recovery Solutions, performance and query tuning, upgrades, migrations, patching, audit & compliance and data modeling.
Transact-SQL Job Cost Overview
Typical total cost of oDesk Transact-SQL projects based on completed and fixed-price jobs.
oDesk Transact-SQL Jobs Completed Quarterly
On average, 12 Transact-SQL projects are completed every quarter on oDesk.
Time to Complete oDesk Transact-SQL Jobs
Time needed to complete a Transact-SQL project on oDesk.
Average Transact-SQL Freelancer Feedback Score
Transact-SQL oDesk freelancers typically receive a client rating of 4.61.
I am a SQL Server Expert with 9+ years of experience. My primary skills include database management and development, performance tuning, BI and data warehousing, statistics, data mining and reporting. I have a Masters Degree in Mathematics, I am very adaptive, I can quickly understand any problems and deliver an accurate solution. My work experience includes several high profile companies in finance & banking, telecommunications, as well as high traffic internet companies, using the mentioned systems and methods on an everyday basis. Client feedbacks: "so, after your first work, our DBs are FLYING!" S.W. - MySQL database performance tuning "You've done a really excellent job. It's a weight off my shoulders and I really appreciate it." C.L. - SQL Server management and optimization
• 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
I am an expert-level senior database administrator and developer with over 10-years of DBA experience in high-transaction environments along with my MCDBA/ MCITP: Database Administration for SQL 2005 and 2008 as well as my CCNA, ITIL v3, and Comptia A+ certifications. I have extensive experience writing complex queries and stored procedures with optimal performance in mind. Some databases which I am responsible for maintaining the availability and performance of run upwards of 9,000 batch requests per second with less than 50ms response time thresholds. I am extremely familiar with and have production implementations of several high-availability solutions such as log-shipping, clustering, mirroring as well as several replication topologies. Additionally, I have an in-depth knowledge and understanding of the database engine and query optimizer which are skills that I use daily along with extensive experience with ETL processes using SQL Server and other database management systems utilizing SSIS and other technologies/ solutions. I work with several hundred databases with an average size of 650 GB and a maximum size of 20 TB. I also have experience determining server hardware and SAN/ storage/ IO specifications and migrating dozens of servers and applications to new server hardware and SQL versions with very little downtime. In addition, I have several years of experience developing windows and web applications using the .Net suite with dozens of fully developed and deployed solutions; I have created several sites which make use of encryption methodologies, SSIS, ETL (Extraction, Transformation, Loading), XML, auto-login, brute-force detection and prevention, and several other advanced functions for stability and security.
To make a mark and excel by using my capabilities, knowledge and expertise and to grow with the organization I work with. I would like to be Innovative and Progressive. Experience in sourcing of candidates for technical position across USA. Experience in technical recruiting, LinkedIn recruiting 6 years of experience as a SQL Server developer. Extensive experience with SQL Server, BI in Microsoft Technology(SSIS, SSRS) , Error Handling and SQL Tuning, writing stored procedures, functions, trigger, views implementing business logic ,backup restore and copy databases in same or remote servers. Also having experience in ORACLE Database, MySQL, VB scripting and MS Office.
I have several years of experience developing software mainly using the .NET framework, SQL Server, PHP, MySQL, VBA (Excel + Access), Movicon and other Scada systems, among other technologies. Over the last 7 years I've developed several desktop and web applications for industrial environments, sometimes working directly with international enterprises from the area, through their IT teams. Over the time I've developed management systems, integrated systems in automation projects, data systems, among other types of development. I have also experience in teaching programming skills and project management. I have a degree in Mathematics and Computer Science and a post degree in Software engineering. I am client focused, follow instructions and hardworking. If it's not perfect, it's not finished. I'm continuously learning and improving my skills, combining what I love to do with what I am required to perform. Programming is my life!
I have deep knowledge of .NET and I can say that I'm really good at the development of ASP.NET Web applications, MVC social networks portals and cloud-hosted solutions (for example, on Azure platform). I'm constantly striving to improve my skills in web-development to become a guru in this sphere. I'm very careful to the details and always do my best to meet the requirements of my customers. Clean code, understandable comments, testing and debugging - that's what you get when you pay me!
I am a highly experienced software developer with 16 years of commercial experience. I have built applications for well known businesses and organizations including Manpower, PepsiCo, the Charity Commission and the University of Essex. I currently run my own software development company. My software has sold to more than 500 organisations worldwide. A recent example of my work is http://www.findaforum.net.