Uploaded File
no photo
SQL Developer
W2 Arlington, VA
Available immediately
no photo
SQL Developer
Average rating
Profile views
SQL Visual Basic Oracle Data Marts .NET SSRS SSAS SQL Developer Project Management T-SQL
Remove Note
View Note
Recent Experience
SQL Developer 03/14 - 05/16
.NET Data Marts ETL Oracle SQL SQL Developer SQL Server SSAS SSIS SSRS Stored Procedure T-SQL Visual Basic Project Management

  • Over 4+ years of experience in the IT domain focused on Microsoft SQL Server 2008R2, SSIS/SSRS/SSAS, OLTP and OLAP.
  • Experience as BI Developer and utilizing Microsoft SQL Server BI stack (T-SQL, SSAS, SSIS, SSRS) transformed data to intelligence and intelligence to value.
  • Experience working with Very Large Databases(VLDB) such as 2 TB and over 5billion Records.
  • Experience in designing and developing high level ETL Packages to extract, transform and load data from flat files to OLTP and OLTP to Data warehouse tables.
  • Experience with SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
  • Experience in designing Dynamic SSIS Packages using variables,expressions, containers.
  • Expert in Package Management like Saving, Encryption, Logging, and Auditing.
  • Experience with SSAS,MDX ,Reports,ETL Architeure.
  • Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables
  • Expert in creating Data Source Views(DSV),Dimesions,Hierarchies,Cubes, Partitions.
  • Expert in creating calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Experience in designing KPI’s,Perspectives,Actions using Microsoft sql Server 2005/2008 Analysis Services.
  • Worked with MOLAP,OLAP,ROLAP storage modes.
  • Good experience in Designing Aggregations and pre-calculated measures, groups and measures.
  • Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
  • Experience in generating, adhoc , Parameterized, Drill through, Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/R2.
  • Experience in creating excutive level Dashboards,Charts using SSRS,Powerpivot and Excel.
  • Expertize knowledge in SSRS using SharePoint Integration Mode.
  • Solid Experience in writing complex T-SQL queries like Aggregate Queries, GROUP BY, HAVING Clauses, Subqueries, CTEs, Derived Tables , JOINs , UNIONs.
  • Experience in writing Stored procedures, Indexes, Views, Synonyms and user defined functions.
  • Experience with Fragmentation and Query analyzer for SQL Server 2005/2008 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
  • Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production
  • Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
  • Provided 24 X 7 Production support for the database and application issues.
  • Worked directly with Director of Data warehouse and Vice Presidents of the Company.
  • Experience in translating user & business requirements into functional and technical requirements.
  • Team Player,worked Independently and also as team lead.

Top 5 Skills
SkillsProficiencyLast Used
Visual Basic
Data Marts
Education and Certifications
not provided
Willing to relocate?:No
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen