|
Free Resume Posting for SOHAIL
|
SOHAIL MOHAMMED
Email: sohail@aptechukltd.co.uk
Summary:
7 years of experience in IT as MS SQL Server Developer/DBA.
Extensive and diversified hands-on experience designing, implementation and administration SQL Server Relational Database / Warehouse in small, medium, and large organizations.
Extensive experience in OLTP/OLAP environment.
Experience in Microsoft SQL 2005 Server migration from SQL Server 2000, Integration Service (SSIS), Reporting Service (SSRS), and Analysis Service (SSAS).
Backup and Recovery of MS SQL 2000 / 2005 Server Databases.
Extensive experience creating database objects such as tables, views, constraints, indexed / materialized views, stored procedures, triggers, cursors, Common Table Expressions (CTEs) on MS SQL Server 2000/2005.
Outstanding knowledge in writing complex database queries, stored procedures, triggers in MS SQL Server using SSIS, Data Transformation Services (DTS) and BCP utility.
Excellent skills in utilizing System stored Procedures, views from the system (master db) and database (local db) catalog.
Excellent experience in utilizing extended stored Procedures.
Extensive knowledge in Tuning T-SQL queries to improve the database performance and availability.
Data modeling using ER-Win & MS Visio 2003/2007.
Excellent skills in implementing ETL Packages using DTS 2000and SSIS 2005/2008.
Proficient in implementing all transformations available on the SSIS toolbox.
Good experience in Designing Aggregations and pre-calculating in SSAS 2005 and 2008.
Excellent experience in Designing, Processing and Partitioning cubes, and knowledge of Data mining.
Excellent hands on experience in creating measures, KPIs as well as defining Actions, translations and perspectives.
Excellent hands on experience deploying SSAS Objects using deployment wizard or using Synchronize database wizard.
Excellent hand on experience in creating report model on SSAS cubes, as well as changing default configuration on existing cubes.
Expert in working with MDX Queries.
Expertise in report generation using SQL Server Reporting Services (SSRS).
Outstanding knowledge in creating drill down reports, ad-hoc reports and drill through reports using the ROLAP as a source.
Experience in converting Actuate reports into SSRS.
Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
Experience in deploying reports on Microsoft Office SharePoint Server (MOSS).
Excellent skills in Microsoft SQL Server 2008/2005/2000 backend programming.
Excellent skills in using Client/Server architecture in implementing MS SQL Server based application.
Excellent organization skills, goal-oriented, with great communication skills.
Outstanding analytical, troubleshooting Skill.
Education:
Bachelors in Electronics and Instrumentation.
Technical Skills:
Languages : T-SQL, C++, VB.Net 2005, HTML, VBscript.
Operating Systems : Windows 98/2000/2003/XP/Vista, Win 2000/2003 Server.
Database : SQL Server 2008, 2005, 2000.
Database Tools : SQL Server Enterprise Manager, SQL Profiler, SQL Query Analyzer, index Tuning Wizard, BCP, DTS Import/Export, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Server Management Studio, SQL Server Integration Services [SSIS].
BI Tools : SSBI Development Studio, SSAS / SSIS / SSRS 2008 and 2005.
Others : ER-Win, MS Office, MS Visio, Crystal Report.
Professional Experience:
MOTOROLA Inc Schaumburg, IL Mar2008-May2009
MSSQL Server Developer/SSAS/SSRS/ DBA
Motorola Inc is a global communications leader, powered by, and driving, seamless mobility. Motorola is revolutionizing broadband, embedded systems and wireless networks. Motorola Inc. NM engages in the design, development, assembly, marketing, sale, licensing, installation, servicing, and support of networking solutions that consist of hardware, software, and services worldwide.
Network Usage Monitoring
This project was to monitor the usage of its carrier packet network by various clients. Their usage was monitored for billing purposes and the data stored in a SQL Server 2000. Migrating the Data from SQL Server 2000 to SQL Server 2005 using SSIS.
Responsibilities:
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Extensively involved in designing (Logical and Physical) of customer database.
Installation, configuration and maintenance of MS SQL Server 2005.
Migrated the Data from SQLServer 2000 to SQL Server 2005 using SSIS.
Identified the data source and defining them to build the data source views.
Implemented constraints like Check, Primary Key, Foreign Key on tables.
Designed and implemented stored procedures and triggers for automating tasks.
Responsible for transferring the data using SSIS packages.
Migrated the DTS packages to SSIS packages.
Documentation for all kinds of reports and DTS and SSIS packages.
Created SSIS package to export and import data from SQL Server to Access, text and EXCEL files, RAW files, Oracle.
Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
Used aggregate, Derived Column, data conversion, union all, lookup transformation in SSIS Packages.
Created SSIS Packages for testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split) for huge CSV files.
Populated Data Warehousing using SSIS Package.
Created Ad-hoc Reports Using SQL Server Reporting Services.
Debugging reports and deploying reports on Report Server and Microsoft Office SharePoint Server (MOSS).
Extracted the data from XML format.
Creating Stored Procedures for reports generation.
Created XML, PDF, EXCEL files using SSRS.
Designed and deployed reports with Drill Down, Drill Through, Drop down menu option, Parameterized, Sub-reports and Linked reports.
Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
Created reports from cubes using SSRS.
Experience in converting legacy reports and Actuate in SSRS.
Deployed the generated reports directly on the clients workstation.
Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
Developed queries in Data Warehouse in OLTP/OLAP environment.
Created & managed the database users, login IDs and security.
Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics by using query optimization, query execution plans, SQL Server Profiler and Database tuning Advisor
Tested applications for performance, data integrity and validation issues.
Extensively involved in replication and implemented Transactional Replications.
Developed administrative tasks for SQL Server for performing Backups and Recovery procedures like Log Shipping.
Created Linked Servers for data retrieval using OLE DB data sources and providers.
Environment:
MS SQL Server 2005, MS SQL Server Integration Services, MS SQL Server Reporting service, MS SQL Server Analysis services, T-SQL, Windows 2003, Team Foundation Server(TFS), Microsoft Office SharePoint Server(MOSS).
Greenway Medical, Carrollton, GA April2007toFeb2008 SQL Server Developer
Description: Electronic Health Record is a web portal for patients to view their medical profile online. This web based project provided patients to view, change or delete their appointment times. Patients are able to renew their prescriptions and change their insurance types/carriers online. Patients also have the flexibility to view and save their medical history for the past 5 years. A variety of types of healthcare-related information can be stored and accessed in a user-friendly easy-to-use manner. This application not only believed to increase physician efficiency and reduce costs but also promote standardization of care.
Responsibilities:
Involved in User Requirement Gathering and Technical Specification Documentation.
Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, indexes, UDFs.
Worked on Database Migration from SQL Server 2000 to 2005 using SSIS.
Created SSIS Packages to import data from Excel spreadsheets.
Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS.
Wrote SSIS packages and configured SQL server mail agent for sending automatic mails when DTS process is success or fails. Bulk Copy Program was used to migrating flat files or text files into SQL server.
Created and Executed the Stored Procedures and Complex Queries for Reports.
Running the packages after the upgrading process using SQL Server Agent to test these packages in new environment.
Created SSIS packages for data Importing, Cleansing and Parsing.
Extracted, cleaned and validated data from XML file into database using XML source.
Managed the Metadata associated with the ETL processes used to populate the Data Warehouse using SSIS packages.
Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
Designed, Managed and published various reports using SQL Server Reporting Services 2005.
Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
Designed Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality).
Created and designed reports based on query parameters and Report parameters.
Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
Experience in converting Actuate reports to SSRS.
Converted Crystal reports to SQL Server 2005 reports.
Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
Created report parameter properties determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time.
Created user defined functions to split the string for the multi valued parameters and pass to the main query.
Created Cascading Parameters to a Report and adding a Report Parameter to pass to a User-Defined Function.
Developed and tested all the backend programs, Error Handling Strategies and update processes.
Unit Testing and Deployment.
Environment: MS SQL Server 2000,MS SQL Server 2005, T-SQL, Excel, SSIS 2005, SSRS 2005,DTS, Data Analyzer, Win Forms, ASP.NET, VB.Net,C#.NET, ADO.NET, Microsoft SharePoint, Visual Studio 2005, VSS 6.0, Windows 2003, Microsoft Windows Active Directory 2000.
JP Morgan Chase, Atlanta Jan2006 - Mar2007 SQL Server Developer/SSIS/SSRS
JP Morgan Chase a leader in global financial services. Their operations include investment banking, commercial banking, financial transaction processing, asset management, private equity and credit receivables. Credit Gateway Analysis is an online web application which is useful for users to view the applications and they can get the statistical review. The project objective was to create and implement new Enterprise Web Based system using Front Office, Web Sphere.
Responsibilities:
Gathered requirements from business analysts and documented them based on functional specifications.
Involved in Installation, Configuration of Share Point Form in Cluster Environment.
Developed Complex Stored Procedures and Functions for the custom objects.
Customized and optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
Developed SSIS packages, architecting the flow of data from various sources such as MS SQL Server 2000, MS Access, MS Excel, CSV files to the target.
Modified the existing SSIS packages to meet the changes specified by the users.
Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
Performed Troubleshooting on the existing complex DTS package while doing a data refresh on Development and Test environments.
Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.
Designed reports in both SSRS (SQL 2005) and SQL 2000 and also deployed reports to the share point environment.
Created stored procedures to incorporate the flow of business and called various stored procedures from SSIS packages to make the flow of the package effective.
Rewrote the existing SQL queries according to the requests and executed them to check the performance.
Scheduled jobs for executing the stored SSIS packages which were developed to update the database.
Involved in developing and modifying VB and XML reports for exporting the reports to web application.
Designed and implemented stored procedures and triggers for automating tasks.
Performed unit testing on reports, and monitored the performance of the reports.
Performed Optimization and Performance tuning of the Stored Procedures.
Used Clear Case for version control and Clear Quest to access the assigned Technical Specifications.
Provided ongoing technical support in the production environment.
Environment:
MS SQL Server 2005, SQL Server Reporting Services 2005, SSIS, SQL Profiler, Crystal Reports, SharePoint, Windows XP / NT / 2000/2003, MS Office 2003.
General Motors AC& HP, Detroit, Michigan Feb2005 Dec2005
MS SQL Server Developer
General Motors Corporation (GM) is a multinational corporation headquartered in the United States. GM is the world's largest automaker as measured by global industry sales and has been the sales leader General Motors manufactures its cars and trucks in 35 different countries and sells them under the brands of Buick, Cadillac, Chevrolet etc. Project aim was to maintain the database which consists of the amount of sale of the automobile product in the desired duration in the region depending on the consumers and thereafter analyzing the way to increase sale.
Responsibilities:
Performed Project planning and scheduling database module in conjunction with project managers.
Tested queries to optimize the procedures and triggers to be used in production.
Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
Worked on Log Shipping, Mirroring & Replication to restore Database backup as disaster recovery strategies.
Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
Managed Windows NT Server logins, folder permissions, and Share permissions.
Performed layout and installation of new computer systems and modifications of existing workstations and Windows 2000 Server.
Configured Snapshot replication for reporting, user acceptance test and development servers.
Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, views and user security management.
Analyzed and designed disaster recovery/replication strategies with business managers to meet the business requirements.
Developed processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
Environment:
SQL Server 2000, T-SQL, ER-Win 4.0, Windows 2000, SQL Server Reporting Services.
Accenture, Hyderabad, India Jan2004-Nov2004
SQL Server Developer
Telstra Corporation Ltd., one of the biggest telecommunication companies in the Australia, provides not only wireless and wire communication but also broadband internet access service as well. The project that I worked is a National Sale Tracking (NST) system, which uses Microsoft SQL Server 2000 and Microsoft 2000 advanced data center Servers, including 4 sets of cluster servers. My responsibilities involved in writing stored procedures, designing DTS packages, automating SFTP and migrating databases from UAT to Pilot and to Production environment.
Responsibilities:
Analysis of the specifications provided by the client.
Designing the ware house system to maintain periodic data.
Designing, Managing and Publishing various Dashboards, score cards using SQL Server Reporting Services.
Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
Back end Experience in MS SQL Server development, writing T-SQL stored procedures, triggers, cursors, UDFs.
Created SQL joins, sub queries, tracing and performance tuning for better running of queries.
Created and Configured Dimensions, Attributes and Hierarchies.
Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
Created collapsed and printable reports based on Tabular, Matrix, List items.
Created parameters, Expressions and calculate the expressions according to the business requirements.
Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS).
Unit Testing and Deployment Cubes and Reports.
Environment:
MS SQL Server 2000, .Net Framework1.0, ASP.NET,C#.NET,VB.NET , VSS, IIS 6.0, Windows XP, Visual Studio.
Oriental Bank of Commerce, Hyderabad, India Jun2002-Dec2003 SQL Developer
Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions and for managing banks property and equipment.
Responsibilities:
Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
Created tables, indexes and constraints.
Designed and developed views, stored procedures and triggers in MS SQL Server database on Windows NT platform.
Configured and monitored database application.
Designed and developed forms using Visual Basic with ODBC.
Designed and developed reports using Crystal Reports.
Preparation of project documentation.
Environment:
MS SQL Server 2000, Windows NT platform, Visual Basic 6.0, Crystal Reports 7.0.
|
|
