Sql Server Windows

NEELOUPFHAR SHAIKH

Email: *****************@*****.***

Mobile: 267-***-****

QUALIFICATIONS SUMMARY

• 10 years of technical expertise in complete software development life cycle including requirement Analysis, Design, Development and Testing.

• Ability to adapt to new technology with ease.

• A dynamic & thoughtful leader who is diligent and has a proven track record in delivering technology projects.

• Very comfortable workings in stressful, rapid develop and deploy environments. Excellent leadership, interpersonal and communicational skills.

• Worked on Complete software Development using agile methodology

• Strong technical expertise in .net technologies.

• Excellent analytical, problem solving and technical skills. CORE COMPETENCIES

Programming C Sharp, VB.Net and ASP.Net

Database MS SQL SERVER 2008/2012, MS Access

Reporting SSRS, Crystal Reports

Source control Team Foundation Server, visual Source Safe Windows Servers Windows Server 2003/2008

Methodology Agile

ETL Tools SSIS

Education

Master of Science in Computer Engineering & Technology, University of Memphis, Memphis, Tennessee

CERTIFICATIONS

Brain Bench Certified in UNIX Administration

Brain Bench certified in web server administration.

Enterasys certified in switching

Enterasys certified in Routing

Professional Experience

Client: Radius Global Solutions 02/2018 – till date Radius is a collection and contact center which uses next generation technologies to create and customize accounts receivable management and call center solutions that meet unique customer relationship solutions. I worked as a developer and handled several inhouse applications using C-Sharp, SQL server and ODBC. Worked closely with department manager, developers and clients to define business requirements for current issues and future applications improvements. I was involved in all phases of Project Management Lifecycle, including but not limited to requirements, solution design, development, testing and production release.

Responsibilities:

• Analyze customer requests for changes/new requirements to production system.

• Research, document and communicate business requirements.

• Design and develop web applications using C sharp, SQL server and ODBC.

• Design, develop reports using SSRS technologies.

• Enhance existing SSIS packages and develop new ones.

• Created and developed various ETL Packages to retrieve data from various sources to SQL server.

• Configured and scheduled several jobs for various clients and wrote T-SQL tasks to send emails upon job failure and success and schedule complex dates.

• Analyzed code to fix logical and code errors.

• Created all required tables, queries and stored procedures.

• Deployed application to Test and Production servers.

• Demo progress for end users throughout development process. ENVIRONMENT: Visual Studio 2010/2015, SQL Server 2012, SSIS, Team Foundation Server, C sharp, SSRS American College of Radiology May 2010 – April 2014 Systems Analyst II

Lead analyst on the initiative to configure, create and enhance in house reports portal to support daily reports as 3D charts, pdf and excel formats for the associates, department managers and senior management. Also developed several in house applications using .net and c sharp and managed existing Data warehouse application and its associated SSRS and SSIS reports and tasks. I worked closely with the Department directors, Statisticians and Research associates to define the business requirements, and formulate solutions for current issues and future application improvements. I was involved in all phases of Project Management Lifecycle, including but not limited to, requirements, solution design, development, testing, and production release and upgrade to latest software versions. Role & Responsibilities:

• Research, document and communicate business requirements

• Design and develop web applications using C sharp, .Net.

• Design, develop reports using crystal reports and SSRS technologies.

• Enhance existing SSIS packages and develop new ones.

• Analyzed code to fix logical and code errors and provided upgrade plans to enhance different applications to new software versions and techniques and to improve efficiency.

• Created all required tables, queries and stored procedures.

• Deploy application to Test and Production servers.

• Demo progress for end users throughout development process

• Creation of functional manuals and detailed system workflows

• Provide support related to production issues and operations processing

• Analyze customer requests for changes/new requirements to production system EENNVVIIRROONNMMEENNTT:: Window 7, Visual Studio 2010/2012, JScript, SQL Server 2010/2012, SSIS, Visual Source safe, C sharp, Windows server 2003

FADAVIS, Philadelphia, PA Mar 2007 – Jan 2009

Systems Analyst/.NET Developer

F.A. Davis is an independent publishing company whose mission is to listen to educators and students, analyze the competition, and then publish the texts, references and electronic resources that the health sciences market demands. It offers both educators and clinicians the most effective tools to teach students and providing the means to keep abreast of the latest research and trends. Role & Responsibilities:

• Involved in client interaction and requirements gathering.

• Analyzed code to determine cause of errors and revise programs as needed.

• Enhanced existing software to meet client specifications into screen layouts, graphical user interfaces and printer outputs.

• Developed front-end screens for registration, update the policy installment pages, coding of application logic in Asp.net, Vb.net 2005.

• Used Ado.Net for database access and developed pages using Ajax for partial page updates.

• Designed and Administered Security policies in .Net Code based as well role-based security.

• Used Microsoft application building blocks like data access, exception handling and logging configuration management application blocks.

• Created and developed various ETL Packages to retrieve data from excel and other text files and transfer data from oracle to SQL server tables on a nightly basis.

• Used Visual source safe for version control.

• Wrote stored procedures and triggers querying batch updates, insertion and deletion. Involved in data modeling and design using SQL server 2005.

• Responsible for migrating objects between 2 servers, this includes diagnosing problem, setup Migration plan, install required software’s on new server, backup and restore databases, recreate user logins, SQL server agent jobs.

• Responsible for creating and scheduling database, transaction log, shrink jobs.

• Created application to handle EDI 850 Transactions.

• Created ETL Packages to transfer Edi Acknowledgement, EDI 810 and EDI 850 files to and from remote ftp server to local system.

EENNVVIIRROONNMMEENNTT:: Window XP, Visual Studio 2005, JScript, VbScript, SQL Server 2005, SSIS, Visual Source safe, Ajax, PL/SQL, EDI, C sharp, Windows server 2003, Remote Desktop (Microsoft's Terminal Services)

AQSSYS, Milwaukee, WI July 2006 - Feb 2007

Programmer Analyst

AQS provides commercial property and casualty insurers with policy administration solutions and services that offer carriers a way to increase speed to market, reduce operations costs, improve business processes and facilitate compliance. These solutions process billions of dollars of direct written premium annually and include a suite of products designed to meet the business needs of the industry. The company’s product suite is built using leading-edge technology and is augmented by a full menu of services, including implementation, technical, bureau and client services. Role & Responsibilities:

• Modified internal applications and utilities including databases and insurance utilities.

• Document adjustments made to client and internal software applications.

• Researched potential customization of client systems and quotes requiring programming time.

• Worked with Business analysts, QA’s to fix issues and enhance existing applications.

• Agile methods using Behavior driven development practice were used for complete software development.

• Enhanced existing software to meet client specifications into screen layouts, graphical user Interfaces and printer outputs.

• Compiled code and correct errors detected in compile process.

• Performed unit tests to identify errors and confirm that programming meets Specifications.

• Analyzed VB 6.0, .NET application code to determine cause of errors and revise programs as needed.

• Used Star Team for version control.

EENNVVIIRROONNMMEENNTT:: Window 2000, Visual Studio (Vb.Net and Asp.Net), JScript, VB script, VB 6.0, MS SQL Server 2000, Star Team, Remote Desktop (Microsoft's Terminal Services), Agile Methodology. Department of Workforce Services, Littlerock, AR Aug 2005 – July 2006

.Net Developer

The website is an enhancement of the mainframe application. The usual process of mainframe application is to generate employer form with the employee and their claim information, and later mail to the respective employer after 2 business days for validation. The employer goes through the employee inputs and validates it and faxes it back to the office, which is later scanned and stored as offline Pdf by the local office. This process was quiet time consuming and required lot of labor, so a website was built which authenticates the employer and lists his employees and when an employee is selected it will display his information along with the claim details, the employer validates the employee information and submits the page, without having to fax it back. When the page is submitted the information is stored as offline and a confirmation page is generated for reference. Role & Responsibilities:

• Involved in detailed analysis and design of online search page and Form Filing.

• Used Visual Source safe to take advantage of Visual studio .Net source code control features to leverage no intrusive team development capabilities and manage web content effortlessly.

• Designed, developed and enhanced reports derived from SQL Server stored procedures using Crystal reports.

• Wrote and edited SQL Server stored procedures, packages and functions as per the business logic to let the Crystal reports to access the data.

• Created and edited Asp.net pages to customize report environment for adding new features or Enhancements.

• Created various DTS packages transfer data from text files to SQL server tables.

• Created Windows services for automatic email generation.

• Debugged and enhanced existing Web services.

• Assisted junior programmers in debugging and understanding code process in various applications.

EENNVVIIRROONNMMEENNTT:: Window 2000, Visual Studio 2005 (Vb.Net and Asp.Net), JScript, SQL Server 2000, DTS, Web Services, Windows services, Fytek, Crystal Reports 10.0, Visual Source safe Project 2: Offline PDF Generation:

Offline pdf generation is an effective way of storing pdf files in SQL Server. The department handles claimant and employer claims, which allows users to fill the related forms and Save them as pdf files in SQL server database. The no. of forms that are filed per day is more than 500.And each pdf file has size around 150-200kb, this was affecting the website performance. In order to resolve this issue, the data was first stored as xml stream in the main database and later converted to pdf files by a .net component running on offline pdf server, thereby reducing load on the main database. Role & Responsibilities:

• Agile methodology using Behavior driven development practice was used for complete software development.

• Involved in writing stored procedures and triggers querying, batch updates, insertion and Deletion.

• Involved in creating VB 6.0 components to generate offline pdf's.

• Performed unit tests to identify errors and confirm that programming meets Specifications.

• Supported User Acceptance testing.

• Used Clear Case for version control.

• Mentored new developers on business functionality and involved in User Training.

• Worked with Network and system administrators to deploy relevant components and applications to windows server.

Environment: Asp, SQL Server 2000, VB 6.0, Fytek, Clear Case, xml, Agile Methodology, Windows Server 2003.

Service Assurance, Memphis, TN Aug 2003 – July 2005 Business Systems Analyst/Developer

Project: Trucking Hand-Held Application

Key member in design, development, Integration and testing of Hand Held application for performing onsite inspection of containers and chassis equipment for Delta Depot, a client company in West Memphis, Arkansas. Evaluated user’s requests to develop and modify new and old modules to determine feasibility, time required, compatibility with current system, and computer capabilities. Role & Responsibilities:

• Involved with system migration study, analysis and design.

• Worked through full software development cycle including planning, requirements analysis, design, coding, unit testing, and acceptance testing

• Involved in design and development of Access database and migrated data from DB2 to Access.

• Prepared detailed workflow charts and diagrams that describe input, output and logical operation.

• Provided staff and users with assistance solving computer related problems, such as malfunctions and program problems.

• Fixed data declarations by adding option explicit statements and proper type declarations to every dim statement to make the data more portable during upgrading. Compiled and performed fix cycle to fix all the compiler errors. Fixed all the commented issues and reviewed the expected behavior changes and like events.

• Used word doc objects in VB 6.0 to print reports from hand held device.

• Designed, developed and enhanced reports derived from Access using Crystal Reports.

• Used Image capturing methods to capture signatures from hand held device.

• Ran and tested the entire project to check for expected results.

• Used citrix remote network connection to deliver applications remotely. 8

Environment: DB2, VB 6.0, Access, Citrix Server, Windows NT, Crystal Reports.

Contact this candidate