- Fairfax, VA, US
- $50 /hr
- Available now
Around 8 Years of IT Experience in Database Design Development, ETL Implementation and support of OLTP/Datawarehouse systems using Microsoft SQL Server 2008/2005/2000 acrossmore... Around 8 Years of IT Experience in Database Design Development, ETL Implementation and support of OLTP/Datawarehouse systems using Microsoft SQL Server 2008/2005/2000 across various SDLC environments
Extensive hands-on experience in developing ETL interfaces using SSIS, Datamarts/cubes using SSAS and enterprise reports using SSRS/Crystal utilizing latest versions (2005/2008) & features
Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement
Gathering, Design, Development, Implementation and Testing and Development experience.
Extensively worked logical & physical Data modeling, data architecture design, Normalization and
De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema)
Involved in Designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, Unique),
Indexes, defaults, rules
Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions, Views
Experience in Writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Complex joins
Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, Efficient
Data migrating (using ETL tools like DTS, BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services (SSAS)
Expertise in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modelling, Physical Modelling, Dimensional Data Modelling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
Developed cubes using Partitions, KPI’s, and Perspectives, slowly changing dimensions etc and created various user roles.
Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
Creating and Managing users, roles and assigning necessary permissions
Created Dashboard/Scorecard pages in SharePoint Server/MOSS 2007/Performance point server that use different types of web parts and excel services for reports
Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards
Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.
Business Application/SQL BI Developer