Sql Server Data
Resume:
Khaja Ali Email: ***************@*****.***
Professional Summary:
Over 3 years of IT Professional experience in Development, Database Design, Client Analysis, Presentation, Implementation and Testing of Windows and Web Applications using SQL Server 2008/2005/2000 and Microsoft Visual Web Developer 2005/2008.
Knowledge of TSQL (DDL,DML), coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2000/2005/2008.
Experience in designing Database Models using Microsoft Visio and Erwin.
Strong Working experience with .Net Framework(2.0,3.0, 3.5,4.0)
Expertise working with .NET Server Controls, Web User Controls, Custom Controls and Validation Controls.
Experience in both Client/Server and Multi-Tier application development.
Proficient in creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
Expert in using tools like SQL Profiler, Execution Plan, Windows Performance for monitoring and tuning MS SQL Server performance.
Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS and Bulk Insert
Experience in loading a flat file, Excel file using Import-Export Wizard.
Experience in Importing/Exporting Data from various data source like Excel, Oracle, DB2 and Flat file using SSIS.
Experience as a Programmer in Design, Coding, and Implementation.
Expert in migrating of databases from older versions of SQL Server to SQL Server 2008.
Developed Drill through/down, Cross-Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS) and deploying them using web applications onto the web servers.
Experience working on version control tools such as Visual Source Safe.
Expertise in Developing and Extending SSAS Cubes, Deploying and Processing SSAS objects.
Experienced in creating scheduling Jobs, Alerts, and scheduled DTS Packages
Experienced with all the phases of Software Development Life Cycle (SDLC) and Quality procedures and standards while executing projects.
Ability to efficiently perform in a team and individually without supervision.
A multi tasking analytical thinker with the ability to work on fast paced work Environment.
Education:
MS in computer science
Skill set:
MS SQL Server 2008 R2/2005/2000/7.0, Visual Studio.NET 2008/2005/2003, Oracle 9i, MS Access 97/2003, DTS (Data Transformation Services), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Crystal Reports 9,Talent, MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, OLAP Services, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, ER-Studio, C, C++, MS Visio, XML, T-SQL, PL/SQL, XHTML, CSS, Visual Basics MS Office, ASP, ASP.Net, Visual Studio, Windows 9x//NT/2000/XP.
Work Experience:
Projects Summary:
Ropes & Gray LLP, Boston, MA 01/2012 – Present
Business Intelligence Developer
Ropes & Gray is a leading global law firm with more than 10 offices located in U.S, U.K and Asia. The firm founded in 1965 and has over 1,000 lawyers and professionals all over the world. Ropes & Gray clients include corporations and financial institutions, government agencies, universities, and health care organizations. It is one of the top five practice groups of the year for private equity, health law, securities litigation and white collar crime. This project is to build a Data Warehouse for the firm and create Reports for decision making and Analysis. I was involved in creating SSIS Packages, perform ETL operations, Creating Reports using SQL Server Reporting Services 2008 R2 and upgrade Reports from SSRS 2005 to SSRS 2008 R2.
Responsibilities:
Participated in Software Development Life Cycle, involved in requirement gathering from the Business Analyst and for preparing the Requirement Specification Document
Created Tables, Indexes, Views, Stored procedures, Triggers and Functions using SQL Server 2008R2.
Created SSIS packages for ETL purpose and Data Ware house build using proper Control Flow and Data Flow elements to achieve performance.
Developed and implemented Error handling logics and Restart ability of the Package in order to handle bad data and avoid redundancy and package failures.
Designed SSIS Packages to transfer data from various data sources like File system, Excel Access and other relational database management systems to SQL Server using Business Intelligence Development Studio.
Involved in writing complex Stored Procedures and Fine tune complex SQL queries and Stored Procedures to increase performance.
Worked on all types SSIS configuration, Check Points, Implemented Auditing within the ETL processes and deploying the Packages to file system and SQL Server.
Designed, Developed and Deployed reports such as Tabular Reports, Matrix Reports, Parameterized, Drill down, Ad hoc and Sub-reports using Report Designer and Report Builder 3.0 and Generated Reports using Global Variables, Expressions and Functions using SQL Server Reporting Services of BIDS.
Responsible for scheduling Reports using subscription services of SQL Server Reporting Services.
Created T SQL Queries to fetch complex data from different tables in remote databases using Joins, Views, Store Procedures for Data Source query in SSIS and SSRS.
Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
Applied various data transformations like Merge Join, Look Up , Merge, Union All, Multicast, Data Conversion, Slowly Changing Dimensions, BDD, Aggregate, Sort, Derived column, Multicasting, Conditional Split.
Merged data from multiple data sources into SQL Server 2008 by creating SSIS package in BIDS.
Generated Reports with Grouping, Sorting and Formating using Report items to display data in different formats and deploying them using Reporting Services Configuration Manager of Microsoft SQL Server 2008 R2.
Managed the historical data (Type1 and Type2) in the data warehouse from various data sources.
Improved Performance of SSIS package by choosing suitable control flow and Data flow Tasks for better performance.
Environment: MS SQL Server 2008 R2, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2008, MS Visio, Microsoft Visual Source Safe, Microsoft Office 2007, Visual Web Developer 2010.
JP Morgan Chase & Co., Chicago, IL 09/2011– 12/2011
MS SQL SSIS/SSRS Developer
JPMorgan Chase is a leading global financial services firm with assets of $2.1 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for customers, small business and commercial banking, financial transaction processing, asset management and private equity. This project was in Commercial Banking about analyzing market potential, generating various reports and analyzing the performances of branches in loans sector. The Project also involved Transformation of data from different sources like Oracle, SQL Server 2005 to SQL Server 2008.
Responsibilities:
Participated in Software Development Life Cycle, involved in discussion on business requirements and implement them using MS Visio 2007.
Creating Database objects – Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
Developed Database Triggers to enforce Data Integrity and additional Referential Integrity.
Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
Designed SSIS Packages to transfer data from various data sources like File system, Excel and Access to SQL Server using Business Intelligence Development Studio.
Designed, Developed and Deployed reports such as Tabular Reports, Matrix Reports, Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder 3.0 and Generated Reports using Global Variables, Expressions and Functions.
Responsible for scheduling Reports using subscription services of SQL Server Reporting Services.
Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
Applied various data transformations like Slowly Changing Dimensions, Aggregate, Sort, Derived column, Multicasting, Conditional Split.
Merged data from heterogeneous data sources into SQL Server 2008 by creating SSIS package in BIDS.
Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
Used SQL Server 2008 to design, implement and manage data warehouses OLAP cubes.
Managed the historical data in the data warehouse from various data sources.
Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
Environment: SQL Server 2005/2008, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2005, MS Visio.
Rofous Software Pvt Ltd, Hyderabad , India 05/2008– 05/2009
MS SQL Server Developer
Rofous Software Pvt Ltd is a leader in IT solutions and services committed to delivery excellence. Rofous Software is specialized in IT strategy and design, application development, integration and management. . The project was to monitor and tune performance of SQL Server 2005, perform ETL operations and generated Reports using SQL Server Reporting Services.
Hardware/Software:
MS SQL Server 2005, BIDS 2005, SSRS 2005, SSAS 2005, Cubes, OLAP, OLTP, T-SQL, Crystal Reports, Query Analyzer, .Net
Responsibilities:
Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.
Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
Developed Drill through/down, Cross-Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS)
Responsible for defining Queries for generating Drill Down Reports and handling Parameterized Reports in SSRS and sorting the data, defining subtotals for reports and designing report layout.
Created Report Models using Report Model Designer.
Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
Extracted data using Query Analyzer and DTS packages.
Tuned and optimized SQL statements, stored procedures and views.
Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
Created DTS packages for transforming data from various data sources.
Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
Experienced in moving the data from heterogeneous data sources like oracle, xml etc to SQL using SSIS.
Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
Fine tune complex SQL queries and Stored Procedures to increase performance.
Suggested creating Clustered and Non Clustered indexes on tables
Generated queries to Drill Down Reports and handling Parameterized Reports in SSRS. Sorted the data, defining subtotals for reports and designing report layout.
.
Environment: MS SQL Server 2005/2008, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2005, MS Visio, Share Point Server (MOSS) 2007.
Environment: Microsoft SQL Server 2000/2005, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel
CMC Limited, Hyderabad, India 06/2007 – 05/2008
.Net Programmer/SQL Developer
Worked as Application Developer where my job entailed building web applications using ASP.Net, ADO.NET and maintaining SQL Server 2000. Wrote Stored Procedures for better performance to retrieve data from the backend database. Involved in User Account Management module, user Registration process and logon support.
Responsibilities:
Involved in all layers or tiers of the application.
Design and developed the user interface and the database.
Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
Developed Web Forms using ASP.NET and C#.
Extensively involved in developing Win Forms using Visual Studio 2005.
Extensively involved in developing Windows User Controls.
Involved in all phases of SDLC.
Implemented the project using n-tier architecture with presentation tier (ASP.NET),
Used ASP.NET Server Controls and HTML controls to design the web pages.
Configured the Web.Config file for Authentication, Session, and Trace.
Used ADO.NET Connection, Command, Datasets, Data Adapter, Data Reader and Data Set to retrieve and store the data in SQL Server 2000.
Extensively used CSS for giving styles to the screens.
Created master pages and Cascade Style Sheets to maintain consistent look and feel among all pages.
Used Web Form controls Data Grids, Dropdown list controls and Validates
Worked with HTML Controls, ASP.Net Web Controls and Web User Controls.
Created Stored Procedures and triggers for automated operations.
Created Tables, Views, Indexes and Relations using SQL Enterprise Manager.
Used Visual Studio.NET debugger and ASP.NET trace functionality to debug the application.
Used Visual Source Safe for version control and history during development.
Environment: MS SQL Server 2000, T-SQL, Microsoft Visual Studio 2003, Visual Studio 2005, Oracle 9i, MS Excel, MS Access 2000, Microsoft Visual Web Developer 2005, Windows NT.
Contact this candidate