Mohammad Abbas Email & Phone Number

Foster City, CA

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralized SQL databases using SSIS to overcome transformation constraints. Converted DTS application to SSIS as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using SSIS. Created Pivot tables using Power Pivot and power Query.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studio using SSIS.
• Debugged SSIS Packages using Data Viewers, Breakpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.

Austin, Texas Area

• Worked on SDLC involving in all stages of development.
• Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications. Implemented different types of constraints on tables.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Optimized queries tuned and monitored server performance using SQL Profiler.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS. Developed SSIS solution for developing a fully-fledged data warehouse solution.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc. Identified and defined Fact relationships in SSAS.

SFO, CA

• Involved in project planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
• Created logical and physical data models using the Erwin data modeler tool.
• Responsible for identifying sources, creating a Pre-staging and staging database, and data mart utilizing dimension modeling. Worked closely with the database developer as a team mentoring.
• Implemented normalization and de-normalization of existing tables wherever needed for faster query processing. Identified types of slowly changing dimensions required for the data mart.
• Maintained data integrity by creating various integrity constraints.
• Managed ETL for extraction, transformation, and loading of data to the destination data mart.

San Jose, CA

• Analyzed the functional specs provided by the business users and created technical specification documents.
• Active part in maintenance of data cubes for OLAP. Involved in migration of crystal reports to SSRS 2008.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives. Wrote PowerShell scripts to automate Excel Macros and generate various reports.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2008. Involved in Migration of SSRS 2005 to SSRS 2008.
• Created Triggers, Views for Audit and security purposes. Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.

SFO, CA

• Performed server installation and configuration using SQL server.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Storedprocedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters,Hierarchies, Actions and Maps etc. Built complex formulas in Tableau for various business calculations.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboardsand Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Involved in designing calculated measures using Multi-Dimensional Expression (MDX).
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval andserver efficiency SSAS and SSIS. Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.

Hyderābād Area, India

• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010. Developed stored procedures to use in SSRS report using dynamic SQL and T-SQL.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects. Created SSIS packages to clean and load data to data warehouse.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc. Developed stored procedures to use in SSRS report using dynamic SQL and.

Hyderabad Area, India

• Efficiently used Microsoft SQL server 2005/2008/2008 R2 SQL server management studio.
• Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis. Elicited business requirements through interviews, surveys, prototyping and observations.
• Prepared BRDs (Business Requirement Documents) supporting documents containing essential business elements, detailed definitions, & description of the relationships, to analyze and document business data requirements..
• Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Prepared functional specification documents and managed any changes in user requirements with change requests and by keeping track of the requirements through traceability.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2005/2008 environment.