Sql Server Developer

S ALI BILGRAMI Frisco, TX - ***** 732-***-**** *********@*****.*** liveasali_1

EDUCATION

Masters, Information Technology, June 2007 ~ Southern New Hampshire University - Hooksett, New Hampshire.

EXECUTIVE SUMMARY

Around 11 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

Database Tools : SQL Server Management Studio (SSMS), SQL Profiler, Database Tuning Advisor, Toad,Beyond Compare

Programming Languages: T-SQL(DDL&DML), MDX,,XML, JSON, PowerShell and knowledge of C#, VB.Net,ASP.Net

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

Business Intelligence and data modelling Tools: MS Visual Studio, MS Visio, MS Office and Erwin Studio.

Business Intelligence Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), knowledge of OLAP and SQL Server Analysis Service (SSAS - Cubes, Dimensions, attributes, Measures, Hierarchies and Members).

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

Data Modelling :Conceptual, logical and physical modelling(OLTP), in depth knowledge of Data warehousing, Data Marts, Dimensional modelling(facts, dimensions and measures)

PROFESSIONAL EXPERIENCE

AltiSource ~ Plano, TX ~ Senior ETL/SQL Server Developer ~ fulltime Oct 2015 – Mar 2018.

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

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

Managed the offshore team, reviewed the code and provided the necessary feedback.

Worked closely with the Database architect in designing relational model for the rental module using ERWin/Studio 17.

Abstracted non-relevant information from users using row level security (RLS) and Dynamic Data Masking.

Utilized the JSON Support feature of SQL Server 2016 to convert the sql data to JSON format(FOR JSON AUTO, PATH)

Created stored procedures and TSQL scripts (Views, Triggers and Functions) to query databases, develop processes that simplified and made more efficient data entry and transaction processes to extract/load/update data.

Implemented logic to handle SQL Injection attack and Parameter sniffing in stored procs.

Analyzed indices for performance using DMVs/ DMFs for fragmentation levels to rebuild/reorganized indices accordingly.

Created, Configured, deployed and fine-tuned SSIS packages with Lookup transformations, Merge joins, script tasks, Fuzzy Look Ups, oledb command, FTP, Data Transformation and Derived column Tasks.

Created PowerShell scripts/bat file for deployment automation of ISPAC and sql files to the relevant servers and databases.

Researched on downloading files from SFTP Servers using WinSCP, SSIS (sensitive parameters) and Script component task.

Designed/ developed/deployed Tabular type Drill Down/Drill through Reports with Cascading parameters, Groupings, Expressions and Dashboards in SSRS with Data Driven Subscriptions.

Environment: Visual Studio 2015, PCI Integrity, Outlook 2010, SQL Server 2008/2016, Windows 7, Beyond Compare, Toad, ERwin

KPMG ~ Roseland, NJ ~ Senior BI/SQL Server Developer ~ Contract Jan 2015 – Sep 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).

Fine-tuned and refactored code for the existing stored procedures to proper coding standards.

Created Dynamic scripts to drop/create constraints and truncate tables in multiple databases.

Created SSIS packages for migrating/integrating (Look Up, Merge Join, SCD) data from heterogeneous sources.

Monitored daily Processes for different Data Loads and resolved Issues.

Prepared technical documentation for future references.

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

Aperia Solutions, Inc. ~ Addison, TX ~Senior BI/SQL Developer ~ Contract Mar 2014 – Dec 2014.

Loaded data from heterogeneous sources (MS Excel, MS Access, and Flat Files to SQL Server using SSIS).

Programmed user Defined Functions, Views using TSQL Scripting for complex business logic.

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Analyzed and fine-tuned database objects to migrate to production level using sql profiler.

Authored technical design documents for the newly created objects’ specifications.

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

S&P Capital IQ ~ NYC, New York ~ SQL Database Engineer ~ Contract Mar 2013 – Feb 2014.

Worked with business analysts to develop project specifications.

Developed new database schema and objects (Stored procedures, Functions, Triggers and complex SQL Queries) for importing the legacy data for upgrading/downgrading the companies’ rating.

Created and maintained fairly complex SSIS packages using Fuzzy lookups for importing the most accurate legacy data.

Integrated companies’ info with the ratings in one central database with historical data.

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

Bank of America ~ NYC, New York ~ SQL Server/SSRS Developer ~ Contract Jan 2011 – Feb 2013.

Designed and created tables, views, triggers and other objects required for web statistics & analysis.

Coordinated with front-end developers for implementing the logic in stored procedures and functions.

Created dynamic packages for Incremental Loads and Data Cleansing using SSIS.

Developed and deployed ad hoc and customized reports using SQL Server Reporting Services (SSRS).

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

Humana Insurance Company ~ De Pere, WI ~ Jr SQL Developer ~ Contract Jan 2009 – Dec 2010.

Developed stored procedures, views, triggers using T-SQL to calculate premiums, deductibles and copays.

Debugged the triggers, views, monitored the system and SQL server jobs for any failures.

Utilized Merge statement introduced in sql server 2008 to insert/update/delete from target tables

Imported the data from flat files to sql server using bulk insert.

Analyze data trends and resolved client functional questions in a timely manner.

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

Plexis Healthcare Systems ~ Ashland, OR ~ Jr SQL Developer ~ Contract Aug 2007 – Dec 2008.

Created stored procedure, Functions, Triggers and Views using TSQL.

Got an opportunity to work on SQL Profiler and Database tuning advisor to fine tune queries.

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

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

Contact this candidate