Sr QA Analyst
Resume:
MOHAMMED
**********@*****.***
OBJECTIVE:
Honors Graduate in Software Engineering with 3.58 GPA, Seeking a position to utilize my skills and abilities in the Information Technology Industry that offers professional growth while being resourceful, innovative and flexible.
SUMMARY:
• Experience in SSIS/DTS Package Configuration, SSRS, SSAS, Database Migration, T-SQL.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, SQL Server 2005.
• Extensive knowledge in T-SQL queries.
• Experience in designing the DTS/SSIS packages to extract and load data into the databases.
• Proficient in software design and web development experience using C++, Java and HTML.
• Sound knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
• Strong professional experience in developing commercial quality web and windows applications using the .NET Framework, C#, VB.NET, ASP.NET, MS-SQL Server, XML Web Services.
• Very strong in Object oriented design principles and design patterns and used Rational Rose for Use-case design, Architecture, Object modeling and Component modeling.
• Experience in working across the various platforms and have good exposure to client server architecture, object oriented approach and Internet technologies
• Expertise with Windows 95/98/2000/NT/XP, UNIX.
• Excellent problem solving skills, experience in working group projects, desire and ability to learn and apply new technologies. Self motivated and detail oriented.
• Expert at finding and resolving malfunctions, using exceptional technical and communication skills to ensure minimization of downtime and optimal computer performance. Very energetic and ready to take new challenges.
ACADEMIC CREDENTIALS:
• Master of Science in Software Engineering Aug 2009.
• Bachelor of Technology in Computer Science May 2006.
Technical Skills:
• SQL Server Tools : SQL Server Management Studio, SQL Server Business Intelligence development
• Languages : C, C++, SQL, T-SQL, PL/SQL, JAVA, ORACLE.
• Operating Systems: Windows server 2003, 2000 server, Windows NT/95/XP, UNIX, LINUX.
• Databases : MS-SQL Server 2008/2005/2000, MS-Access 97 & 2000
• ETL Tools : Data Transformation Services, SQL Server Integration Services (SSIS)
• Scripting : HTML, DHTML, Shell Scripting.
• Reporting Tools : SSRS, SSAS.
• Web Technologies: ASP.NET, PHP, XML, VBScript, JavaScript, HTML4.0, DHTML.
• Net Working : TCP/IP, LAN, FTP, DNS, DHCP, IIS.
PROFESSIONAL EXPERIENCE:
1. ASSOCIATED BANK, IL. NOV 09 – Present
Project scope: The scope of the project is to design a BI solution to replace legacy application report system. The idea is to fetch the data from different systems into one database and design reports. Based on the existing reports from the OLTP database and updates changed it into BI solution with Microsoft technology SSIS and SSRS.
Responsibilities:
• Collected the user and system requirements and write technical specifications.
• Developed SSIS packages to extract and transform data.
• Create tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Experience with Data Transformation Services (DTS) an Extract Transform Load (ETL) tool of SQL Server to populate data from various data sources by creating packages for different data loading operations for each application
• Create joins and sub-queries for complex queries involving multiple tables.
• Imported various Sources, Targets, and Transformations using SSIS packages.
• Developed and implement backup and recovery strategy.
• Created stored procedures and triggers for database transactions in SQL Server
• Created and customized SSIS packages and used SSIS to load data from difference sources.
• Created and Managed OLAP Cubes using SSAS.
• Experience in Processing the Cubes.
• Created Time Dimensions on OLAP Cubes using SSAS
• Created Web Based and Graphical Reports using SSRS.
• Extensively used the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Performing Backup and Recovery & Automation of Backup and Recovery.
• Creating Triggers, Stored procedures, Tables and queries. Import and export of SQL objects from and to various sources.
Environment:
SQL Server 2005/2000, Windows 2003, DTS/SSIS, T- SQL, Excel, SSAS, SSRS, BIDS.
2. Impact Informatics Solutions & Consultancies Pvt. Ltd May 2006 –July 2007
Junior SQL Developer
The purpose of the project was to enable the optimum utilization of the resources to maintain inventory. This is achieved by facilitating the up to the mark and timely, information about the status of the inventory and restricting entry of quality items only, evaluating vendor suitable for a particular requirement. It gives accurate report on the status of the inventory, order placed to vendors, vendor evaluation, deliveries received and due to be delivered.
Responsibilities:
• Created and configured the database, with 2 file groups, created the tables having required constraints.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Worked on Log Shipping, Replication to restore Database backup.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assisted in coding, design and performance tuning.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Packages through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
Environment: - MS SQL Server 2000, C#, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, MS Access & Windows NT platform.
3. Synergy Computer Solutions Inc Sep 2005- Mar 2006
Internship Project: SCS-Resumate
Description: SCS-Resumate is a web based application built for Human Resources Recruiters team for managing, searching, retrieving and matching the profiles of applicants. Candidate records are created and saved completely automatically from resumes contained in e-mail messages, or from any file, such as a Word .doc .rtf file. Resumes can be Searched, Edited, Matched, Called and Emailed from within the application. The application has Calendar, file attachments and full text search of attached documents.
Responsibilities:
• Developed the Automated data entry through Word file scanning.
• Designed and developed a Microsoft Word file parser, which reads Resumes (Word format) and automatically picks up the required fields and maps it to DB fields and saves the details with the Resume as attachment.
• Implemented the Resume (Word document) parsing engine using the Regular Expression classes in .Net to read Candidate’s Name, Address, Qualification and Experience.
• Used Test Director for Test Planning, Test Designing, Test Analysis, Defect Tracking and Test Evaluation
• Met with client groups to determine user requirements and goals. Analyzed Business requirements and System specifications using which developed Test Strategies, Test Plans, Test Cases and Test Scripts for the Functional, GUI and Integration testing.
Environment: ASP.NET 1.1, C#, SQL Server 2000, Test Director, Windows 2000.
ACADEMIC PROJECTS:
STUDENT INFORMATION SYSTEM
Implemented sample student information system on SQL Server using SQL queries, stored procedures, triggers and cursors are also extensively used. This project involves design and implementation of student information system contains the student, professor and other related activities in the university.
Environment: SQL Server 2000, Windows 2000
SMO Scripting
This project deals with SMO (sql server management objects).In this project we script out all tables, views, stored proc from the database in to files and we store all of them in a directory With this we can manage our database with simple user interface in this project we use sql server as database.
Environment: VB.NET, SqlServer2000, Windows XP
GPS NAVIGATION SYSTEM
This project is aimed at the implementation of GPS navigation system by using the Map point control 2006. This control allows us to embed maps into our Visual C# application. In this application we develop UI by using WPF forms. In this application user will pick starting and ending address then it will generate directions for it this application will generate dynamic maps while the vehicle is moving. This application will measure the Latitude and longitude and speed of the vehicle.
Environment: Visual Studio.NET, Windows XP
Reference: Will be provided upon request.
Contact this candidate