Sql Server Project
Resume:
PERRY ZAFAR
*****.*****@*****.***
SUMMARY:
. 6+ years of working experience in software industry.
. Developed SSRS reports like parameterized, drilldown, drill through, ad
hoc etc using BIDS and Report Builder 3.0.Conversion of access report
into SSRS reports.
. Develop SSIS packages using SQL Import and Export wizard for import and
export data to and from database tables.
. Developed SSIS packages using control flow: data flow task, FTP task,
Execute sql task, File System task, Script task, for each loop container
task and other tasks.
. In depth knowledge of database concepts and database programming using T-
SQL Queries and database object like store
procedure,Views,Variable,Functions,Trigger,temp table.
. Expert in SSRS reports using Business Intelligent Development Studio and
Report Builder.
. Participate in requirement gathering, analysis, and support the
development of SSRS reports and SSIS packages based on the business
requirement gathered.
. Participate in translating reporting requirements into business
requirement documentation and generating T SQL queries and reports.
. Developed associated forms using Argo software 5.2 and ECS middle tier
development.
. Retested change requests in the Loan Origination System using test plan
and test cases.
. Pretty good working experience on Walters Kluwer financial services
EXPERE testing tool.
. Strong knowledge and expertise in working with Microsoft technologies
like ASP.NET, C#, Web Forms, .Net Framework, and XML technologies (XML,
XSL and XSLT).
. Proficient in working with databases like SQL Server 2000,SQL Server
2005,2008 using data access technologies like ADO, ADO.NET, OLEDB and
ODBC.
. Developed front end user interface using HTML/DHTML, ASP.NET, CSS and
JavaScript.
. Developed enterprise wide applications by analyzing requirements and
recommending innovative and creative solutions to the problem at hand.
. Experience in handling the complete software development life cycle.
Involved in design development, testing and implementation of projects at
different stages.
. Good programming skills using C#, .NET framework 2.0/3.5 and SQL Server.
. Adaptability to quickly learn new technologies and tools.
. Strong educational background with excellent communication, presentation
and interpersonal skills.
. Ability to handle multiple projects concurrently and achieve milestones
successfully.
. Pretty good working experience on Microsoft Visio 2010, MS Excel and
Access.
. Implemented projects using Agile Scrum Methodology.
TECHNICAL SKILLS:
Operating Systems Windows 2000, MS DOS, UNIX, Sun Solaris,
Linux.
Web Technologies ASP.NET, HTML, CSS, Argo Software 5.2
C#, SQL, T-SQL, PL/SQL, HTML, XML, XSL,
Languages XSLT.
RDBMS MS SQL Server 2000,2005,2008 Microsoft
Access,SSRS,SSIS, BIDS, Report Builder
Data Access Technologies ADO.NET, ADO, ODBC, OLEDB
Scripting Languages JavaScript
IIS 4.0/5.0/6.0, Personal Web Server, MS
Application Servers Commerce Server 2000
MS Visual Studio .NET 2005/2008/2010
IDE/Tools
Bug testing Tool Test Director 7.6, 8.2/ Quality Center 8.2,
9.0.Load Runner 8.2, 9.0, QTP 8.2
PROFESSIONAL EXPERIENCE:
May 2013 - Recent
SQL Server BI Developer
MATRIX
Client: Mortgage Company, Dallas, TX
Role: SQL Server BI Developer
Project: Create New and update SSRS Reports, SQL code and SSIS packages.
The project is to create new and update reports as per Report Requirement
Documentation (RRD) using Report Builder and Business Intelligence
Development Studios of SQL Server
2008 R2.
Create new packages and update existing packages from business requirement.
Create and update T SQL code for all requirements.
Responsibilities:
. Using RRD developed sql queries and developed SSRS reports in BIDS.
. Update existing report s from Report Builder as per RRD
. Extensively worked with SQL Server queries and store procedure.
. Developed and designed SSRS reports as per requirements.
. Worked with Complex T-SQL queries to get the desired result from database
tables
. Troubleshoot existing reports and packages.
. Develop SSIS packages as per business requirements.
. Update existing SSIS packages as per request or incident.
. Worked on new and existing Stored Procedures, Functions, Views and Other
objects
. Worked extensively on Team Foundation Server (TFS) for SQL,SSRS,SSIS
along with share point site for documentation.
Environment: SQL Server 2008, 2008 R2, SSRS, SSIS, BIDS, Report Builder
3.0, ASP.NET,
T-SQL, Visual Studio 2010, 2008, JavaScript, M S Access database, TFS
March 2012 - March 2013
Application System Engineer
TEK Systems
Client: Wells Fargo, San Antonio, TX
Role: SQL Server Developer in Servicing Data and Analytics
Project: Conversion of batch report to SSRS (BIDS AND Report Builder) and
New and update SSRS Report
The project was a conversion of batch reports (sql server management
studios and access database) reports into SQL Server Reporting Services
using Report Builder and Business Intelligence Development Studios of SQL
Server 2008 R2.
Gathered business requirement and generated documentation, new reports and
update report from BRD (business requirement documents).
Responsibilities:
. Participate in requirement gathering, analysis, and support the
development of SSRS reports and SSIS packages based on the business
requirement gathered.
. Participate in translating reporting requirements into business
requirement documentation and generating T SQL queries and reports.
. Used BIDS and Report Builder to create SSRS reports.
. Worked on BRDs. Developed sql queries and developed SSRS reports in BIDS.
. Extensively worked with SQL Server queries and store procedure.
. Developed and designed SSRS reports as per requirements.
. Worked with clients to update existing reports.
. Worked with .Net SDA Report Portal for backend database development.
. Worked on Servicing Data and Analytics reports.
. Worked with Complex T-SQL queries to get the desired result from database
tables
. Written Stored Procedures at backend
. Conversion of access reports to sql reports.
Environment: SSRS, SSIS, BIDS, Report Builder 3.0, ASP.NET, T-SQL, Visual
Studio 2010, JavaScript, M S Access database
Jan 2010 - FEB 2012
SQL/SSRS Developer
NIIT Technologies
Client: Associated Bank, Green bay, WI
Role: SSRS Report Developer
Project: Lending and Sales (Commercial Loans)
Description: Project was to generate different types of reports using BIDS.
Gather information, generate SSRS/SSIS as needed and after validation move
them to production.
Responsibilities:
. Responsible for creating Databases, Tables, Cluster Index, Unique/Check
Constraints, Default, Views, Stored Procedures, Joins, and Functions.
. Experience in SSIS package using import/export wizard.
. Generated perametrized,drilldown,drillthrough,linked reports based on the
statistical analysis of the data from various time frame and division
using SQL Server Reporting Services (SSRS)
. Developed Reports for business end users using Report Builder with
updating Statistics.
. Developed charts, map reports.
. Creates SSIS packages using data flow: Excel, Flat File, OLE DB as data
flow sources, Aggregate, Data Conversion, Derived column, Cache
transform, Conditional split, Lookup, Merge join, Multicast, Row count,
Sort, Union all, OLE DB Command as data flow transformation, Excel, Flat
file, and OLE DB as data flow destinations.
Environment: SQL Server 2008/2008r2, Integration Services (SSIS), Reporting
Services (SSRS), DTS, C#, .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS
Excel, MS Access, MS visual Studio, BIDS.
AUG 2009 - DEC2009
Consultant Programmer
Tek Systems
Client: US Bank, Minneapolis, MN
Role: Software Programmer
Project: Argo Lending and Sales on Browser.
Argo lending project is a web based financial application developed to
develop bank forms by adding new fields on the existing bank web forms.
Using this application banker can assist in opening new accounts, customer
verification, safe deposit box etc. This application consists of several
SRS (software requirement specifications) with UI and functional
requirements.
Responsibilities:
. Involved in Requirements gathering sessions.
. ARGO ECS (Enterprise Commerce Server) Middle-tier development. Created
mapping documents that map SRS (Software requirement specification) label
fields with XML Schema tags, field length and Argo field length, external
data list and FQDF.
. Data integration/ mapping (identifying data from the company banking
system and mapping to forms) and data manipulation. Functional change
request for user interface fields.
. Use traces and logs to troubleshoot errors.
. Work with teammates and clients to achieve the highest quality, industry
leading products.
. Worked on Lending Project using ARGO Software 5.2.
. Developed queries to retrieve data from the SQL Server database. Database
development, preferably in SQL Writer in Argo Software 5.2
Environment: Argo Customization tool, SQL Server 2008, Microsoft Visio
2010, Loan Origination System
APRIL 2009 - AUG 2009
Consultant Developer
Macintosh Incorporated, Dallas, Tx
Client: Argo data, Richadson,Tx
Role: Software Developer
Project: Associated forms lending project
Description: Developed Associated Forms using XML, HTML/DHTML, CSS, and
JavaScript, Basic SQL and Structured Programming for Lending project.
Responsibilities:
. Developed data list, external data list and transaction to generate
XML/XSL as per tags for bank forms.
. Data integration/ mapping (identifying data from the company banking
system and mapping to forms) and data manipulation. Functional change
request for user interface fields.
. Use traces and logs to troubleshoot errors.
. Work with teammates and clients to achieve the highest quality, industry
leading products.
. Worked on Lending Project using ARGO Software 5.2
. Developed queries to retrieve data from the database. Database
development, preferably in SQL Writer (Server) in Argo Software 5.2
. Designed and created database objects.
Environment: Argo Customization tool, SQL Server 2008, Loan Origination
System
APRIL 2007 - MARCH 2009
Junior Developer
Motus IT, Dallas, TX
Project: Patient Database
Client: All Scripts Healthcare Solutions, Libertyville, IL
Role: SQL Developer
Description: All Scripts is a health care organization which provides
clinical software for the physicians and information solutions for patients
and healthcare professionals' .The project about is an e-commerce site that
allows doctors can access patient information. The doctors can use the
database to access patient insurance, visits, history of treatment.
. Involved in design and development of patient database in SQL Server
2005.
. Developed table, queries, views, store procedures and trigger.
. Developed reporting services with T SQL queries and store procedure and
trigger to update patient information.
. .Net developer used store procedure logic to insert, update and delete
using ASP .Net web page
Environment: ASP.NET(C#), SQL Server 2005, IIS, Microsoft Visual Studio
.Net.
Project: Student Database management Systems
Client: Motus IT training center, Dallas, TX
Role: Web Developer
Description: Motus IT is a training center which provides students software
application development and other training classes for the students .The
project about is a student information site that allows student to use
online enrolment forms and employees to maintain, update student
information using ASP .Net web forms.
. Involved in design and development of 3 tier architecture for the
application.
. Developed several web pages using ASP.NET.
. Used C# for code behind logic.
. Developed several stored procedures on the SQL Server database to
retrieve, update, validate and integrate business rules.
. Performed client side validations using JavaScript and server side
validations using ASP.NET validation controls.
Environment: ASP.NET(C#), SQL Server 2000, IIS, Microsoft Visual Studio
.Net.
Project: File Patcher
Client: Motus IT, Dallas, TX
Role: Software Developer
Description: The operation was to read all the log files from the server
and place the logs in a database for archive purpose
Responsibilities
. Implemented Business Logic using C#.
. Developed C# .Net library class and methods for file operations like
opening files, copying and deletion.
. Developed database with tables, views, queries and store procedures.
Environment: Visual Studio.NET, ASP.NET, C#, SQL Server 2005, IIS 5.0
Client: Zale's
Role: Software Engineer
Project: PORTAL
Description: Developed web based applications for the Zale corp.'s vendor
portal and store portal. Worked on many applications like 'Purchase
Orders'. Integrated all the applications to Microsoft SharePoint portal.
Worked on migrating applications from SAP portal to Microsoft SharePoint
portal.
Responsibilities:
. Designed the user interface to Login and Create User web page using
ASP.NET Web Controls, User Controls, HTML, CSS and JavaScript.
. Developed the logic of drop down list, check box, and radio buttons.
. Developed client side validations using JavaScript.
. Responsible for Tracking and updating of bug statuses and fixing them.
Environment: ASP.NET(C#), SQL Server 2005, IIS, Microsoft Visual Studio
.Net
EDUCATION:
B Sc (Bachelor of Science in Engineering): Nagpur University, India
Tech Skills, Addison, Texas:
SQL Server 2000 and 2005 foundation. Comp TIA Network+ (2009)
MCTS- .NET Framework 2.0-Web-Based client development 70-528.
MCTS- .NET 2.0 Application Development foundation 70-536.
MCTS- SQL Server 2005 Implementation and Maintenance 70-431.
MCTS- Business Intelligence Development and Maintenance 70-448
Contact this candidate