Uploaded File
no photo
13 years experience W2 Florida City, FL
Available immediately
Actively seeking
no photo
Average rating
Profile views
Data Replication Data Warehousing SQL SQL Server ETL SSIS SSRS Database Design Stored Procedure Triggers
Remove Note
View Note
Recent Experience
SQL/SSRS/SSIS/Developer 04/16 - present
SQL Visual Studio Data Marts Stored Procedure SQL Server ETL SSIS SSRS T-SQL Business Intelligence Data Conversion Data Validation Data Warehousing OLTP Performance Tuning
SQL/SSRS/SSIS/Developer 11/15 - 04/16
SQL SQL Server SSIS SSRS Data Conversion Data Replication Asset Management Project Management Data Warehousing Disaster Recovery Database Design MS SharePoint
SQL Server Developer/Report Writer 01/15 - 10/15
SQL Server SQL

  • 10 years of experience as MS SQL Developer in administration and development of database design and development in SQL Server 2012/2008R2/2008/2005/2000 system in OLTP and OLAP environment.
  • Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
  • Highly expert in translating Business System Design document into technical design document
  • Experience in installation, upgrade and configuration of Microsoft SQL Server and databases
  • In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
  • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R2/ 2008/2005/2000.
  • Experience in scheduling SSIS packages using SQL Server Agent.
  • Strong knowledge of using variables and expressions in packages.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R2/2008/ 2005.
  • Proficient in implementing all transformations available on the SSIS toolbox.
  • Expert in resolving the performance issue of SSIS packages.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
  • Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
  • Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
  • Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
  • Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
  • Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high pressure environment.

Top 5 Skills
SkillsProficiencyLast Used
Data Replication
Data Warehousing
SQL Server
Education and Certifications
Willing to relocate?:No
Prepared to Travel:100%
Employment Type:Any
Security Clearance:No clearance
Citizenship:Green Card