Resume

Sign in

Sql Server Developer

Location:
Frisco, Texas, United States
Posted:
January 10, 2018

Contact this candidate

S ALI BILGRAMI

**** ********** *****, ****** ** 732-***-**** ac3zg5@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 10 years of experience in Analysis, Design, Development and Tuning of Relational Database Management Systems (RDBMS) for domain specific Business Intelligence (BI) applications in Online Transaction Processing (OLTP) environment and all phases of Software Development Life Cycle (SDLC) with a thorough understanding of Object Oriented Principles(OOPs) Conceptual, Logical and Physical database modeling, Normalization, Data mapping, ER Diagrams, Extract, Transform and Load process(ETL) and creating precise SQL Server Reports(SSRS) in terms of observing business rules.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2012/2008 R2/ 2005, MS Access 2007.

Programming Languages: T-SQL(DDL&DML), Basic understanding of C#, VB.Net, ASP.Net,XML and HTML(Not development)

Operating Systems: Windows Vista/7/8 and Windows 2012 Server.

IDE & Business Intelligence Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2008/2010/2012/2015, SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS), SQL Profiler and Database Tuning Advisor.

Version Control: Visual Source Safe, Team Foundation Server, SVN, RedGate,PCI Integrity.

Data modeling Tools: MS Visio 2003/2007, MS Office

PROFESSIONAL EXPERIENCE:

AltiSource – Plano, TX

SQL Server Developer – fulltime October 2015 – Current.

Actively involved in Client meetings, requirement gathering and technical documentation.

Designed and developed SQL Server Objects (Tables, Stored Procedures, Functions, Triggers, and Views, temp tables, table variables and User defined types) using Transact SQL (TSQL).

Performed index analysis using DMVs and DMFs for internal and external fragmentation to rebuild/reorganized the indexes accordingly for better performance.

Created, Configured and deployed SSIS packages with Lookup transformations, Merge joins, script tasks, Fuzzy Look Ups, oledb command and Derived columns for multiple Data Flow tasks.

Created SSRS drilldown and drillthrough reports to display the daily tasks processed

Designed, developed and deployed Tabular, Matrix type Drill Down, Linked and Sub-Reports with Cascading parameters, Groupings, Expressions and Dashboards in SSRS with Data Driven Subscriptions for sending Emails to the users in different formats.

Worked closely with BA(s), Application Developers(s) and DBA(s) to achieve the technical goals.

Environment: Visual Studio 2015, PCI Integrity, MS Outlook 2010, SQL Server 2008/2016, Windows 7, Beyond compare, toad for sql tool.

KPMG - Roseland, NJ

SQL Server Developer – Contract January 2015 – September 2015

Designed and developed SQL Server Objects (Tables, Stored Procedures, Functions, Triggers, and Views, temp tables, table variables and User defined types) using Transact SQL (TSQL).

Performed index analysis using DMVs and DMFs for internal and external fragmentation to rebuild/reorganized the indexes accordingly for better performance.

Designed and developed end to end data flow using SSIS and SSRS

Environment: Visual Studio 2012, TFS, MS Outlook 2010, SQL Server 2012, Windows 7, RedGate sql tool

Aperia Solutions, Inc. - Dallas, TX

SQL Server Developer – fulltime February 2014 – Dec 2014.

Created SSIS Packages to Extract, Transform and Load raw data from flat files to SQL Server tables.

Created Error Handling, Logging and fine-tuned existing SSIS packages.

Created SSRS reports (Tabular) using Cascading Parameters and conditional expressions.

Environment: Visual Studio 2012, SVN 3.0.4, MS Outlook 2010, SQL Server 2008R2/2012, Windows 7.

S&P Capital IQ - New York, New York

SQL Server Developer – Contract April 2013 – January 2014.

Designed, and created Database Schema, Tables, Stored procedures, Temp tables, and Table variables, Functions, Triggers, Joins, Sub-Queries, Constraints, Indexes, Views, Rules, Defaults and complex SQL Queries with proper Error handling using Try Catch methodology.

Created File Groups, Files, Partition Functions, and Partition Schemes to split the table data horizontally to boost the Performance.

Environment: Visual Studio 2012, SVN 3.0.4, MS Outlook 2010, SQL Server 2008R2/ 2012, Windows 7.

Bank of America - New York, New York

SQL Server Developer – Contract January 2011 – Feb 2013.

Created Tables, Temp Tables, and Views, Functions, Triggers, indexes and Stored Procedures to populate data into the SSRS reports

Designed, developed and deployed Tabular and Matrix type List, linked and Sub-Reports with Charts and Document maps using SSRS.

Environment: Visual Studio 2010, Windows 7.0, SVN, MS Outlook 2010, SQL Server 2008R2, SSRS.

Humana Insurance Company, De Pere, Wisconsin

Junior SQL Server Developer – Contract January 2009 – December 2010.

Created Tables, Functions, Views, Joins, Indexes and Stored Procedures using TSQL.

Enhanced and modified the existing Database Objects (Tables, Views, and Stored Procedures).

Environment: Windows 2003 Server, Visual Studio.Net 2.0, SQL Server 2005, Team Foundation Server.

Plexis Healthcare Systems - Ashland, Oregon

Junior SQL Server Developer – Contract August 2007 – November 2008.

Created Tables, Stored procedure, Functions, Triggers and Views using TSQL.

Fixed the Bugs in the existing Stored Procedures, TSQL Scripts.

Environment: WindowsServer2003, Visual Studio 2005, SQLServer2005, Tortoise CVS.

EDUCATION:

Masters, Information Technology, June 2007

Southern New Hampshire University - Hooksett, New Hampshire



Contact this candidate