IRFAN SYED
Email: ***********@*****.***
Cell: 609-***-****
Summary:
Over 7+ years of experience working on SQL server integration services, SQL server reporting services, SQL server Analysis Services and TSQL Development.
Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.
Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.
Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS, SSAS and SSRS 2005/2008.
Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
Experience in writing complex SQL queries involving multiple tables inner and outer joins.
Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
Worked Extensively on ETL process using SSIS package.
Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
Extensive experience working with SAP Cubes and DSO`s and ETL Process.
Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
TECHNICAL SKILLS
Languages
C, C++, JAVA, C#.NET, T-SQL
Database
MS-SQL Server 2000/2005/2008 R2
Operating Systems
Windows XP/NT/2000/2003/2008
Web Technologies
JSP, Servlets, ASP.NET, HTML, XML
Developer Tools
SSIS, SSRS, SSAS, SAP BW, Business Objects.
Other Tools
Ajax, Apache, Tabular Model, MAP Reduce, HIVE, PIG and TABLEAU
Caterpillar - Nashville, TN Feb 14 – Present
MS SQL/SSIS/SSRS Developer
Responsibilities:
Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
Created views to restrict access to data in a table for security.
Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.
Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.
Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.
Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and TSQL procedures in SQL SERVER 2008 R2.
Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments
Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow
Defines and captures metadata and rules associated with ETL processes
Review and analyze database performance, cubes and reports generated using SQL SERVER 2008 R2 Reporting Services.
Environment: SSIS, SSRS, MS SQL Server 2008/2005, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.
Service Master - Memphis, TN Jul 12 – Nov 13
MSBI Developer
Responsibilities:
Analyzing different user requirements and coming up with specifications for the various database applications
Developing database applications which are automated
Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable
Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
Implemented the Snap Shot View as extra layers for high availability of data while the ETL process loading the data in to the SQL Database.
Maintained two different databases: Read-only reporting database and Disaster recovery database
Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
Implemented new T-SQL features in SQL Server 2005 like Partitioning, Advanced Error handling, Common Table Expression (CTE) and LINQ.
Involved in training Update features for Business solution of SQL Server.
Provided KT to the support team for the smooth transition after the 90 days warranty period.
Environment: SSIS, SSRS, MS SQL Server 2008/2005, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.
Burger King Corp. - Miami, FL Apr 11 – July 12
MSBI Developer
Responsibilities:
Developed Logical and physical data model using ERWIN and mapped the data into database objects.
Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
Optimized the database by creating various clustered, non-clustered indexes and indexed views.
Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
Problem identification, troubleshooting, resolution, and index tuning databases.
Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
Created Alerts for successful or unsuccessful completion of scheduled Jobs.
Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
Environment: SQL Server 2000/2005, MS Analysis Service SSAS Developer 2000, MS Project, MS Access 2000 & Windows 2K platform.
Marathon Oil Corporation - Houston, TX Feb 09 – Jan 11
MSBI Developer
Responsibilities:
Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
Installed, configured and maintained SQL Server Integration Services (SSIS).
Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
Implemented SQL Server OLAP services (SSAS) for building the data cubes.
Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
Developed reports using SSRS and published as PDF, Excel, and CSV formats.
Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
Designing and building data load procedures using MS SQL Server.
Designed and implemented Stored Procedures and Triggers for automating tasks.
Configured product meta-data tables to support client data reporting needs.
Incremental and full database recovery with experience of complex recovery scenarios.
Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries
Environment: SQL Server 2000/2005, MS Analysis Service SSAS Developer 2000, MS Project, MS Access 2000 & Windows 2K platform.