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. • Used T-SQL in SQL Server 2012 to develop Stored Procedures, UDFs, Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau. • Performed Provider analysis and gave useful Insights about reliable Insurance group, claims, deposit details from the Power BI dashboards. Created report schedules on Tableau server. • Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports using SSRS for customized and ad-hoc Queries. • Developed dashboard reports using Reporting Services, Report Model using Report Builder.

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. • Responsible for creating the reports based on the requirements using SSRS. • Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions. • Identified and defined the Datasets for the report generation. • Deployed the generated reports directly on the client's workstation. • Explored and used many enhancements of Power BI in current reports like Content pack and direct connection to databases like SSAS. Involved in writing scripts for the client’s requirements for reporting purposes. • Assisted in production OLAP cubes, wrote queries to produce reports using SSAS and Power BI for reporting.• Worked on building queries to retrieve data into Tableau from SQL. • Analyzed the existing reports, cubes and dashboards and prepared the use cases for Tableau visualizations.

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. • Developed mappings utilizing SSIS to transform data from multiple sources: Excel, Flat File, and SQL Server to OLTP database. Implemented Incremental loading using checksum and CDC. • Implemented SSIS packages with loggings and event handlers for error handling. • Worked on implementing transactions for billing details and checkpoints in the packages for optimizing the performance. Designed the OLAP cube using SSAS for hospital drug analysis. • Restructured ETL packages with optimized queries and proper transformations for faster data loading. • Deployed SSIS packages from development server to production server utilizing project deployment model. • Generated parameterized, cascading parameterized, drill down, and drill through reports. • Created reports using Power BI if data getting from Azure cloud and web services. • Optimized embedded queries or stored procedures that generate reports. • Created analytical reports and dashboards utilizing Tableau.

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. • Worked with POWER SHELL to automate SSIS Package and create report in Excel. • Involving in creating the packages by using Control Flows, Data Flows and script tasks. • Scheduling the ETL jobs to run some of them daily and some of them are monthly once • Fixing the defects in QC as per the tester comments. Launching the report builder for ADHOC reports. • Extensively working in loading fact and dimension tables in Data warehouse. • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing. Extensively used Excel PowerPivot and Slicing and Dicing concept • Created reports to retrieve data using Stored Procedures, MDX Queries that accept parameters. • Used various report items like tables, sub report and charts to develop the reports in SSRS. • Developed T-SQL queries and stored procedures with multiple parameters to created data Sets for reports • Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snowflake Schema. Created mapping tables to find out the missing attributes for the ETL process.

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 SQLstatements. Administered user, user groups, and scheduled instances for reports in Tableau.• 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.• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSASand SSIS. Monitored performance and optimized SQL queries for maximum efficiency.• Used multiple transformations in SSIS to meet the business requirements by extracting data fromheterogeneous source systems, transform and finally load into the Staging Data base.• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked onData transfer from a Text file to SQL Server by using bulk insert task in SSIS.

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 for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse. Created packages to migrate data from different data sources to data warehouse. • 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 T-SQL. • Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS). • Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement. Executed the test cases in Quality Center to ensure the quality of the data migration.• Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.

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. Reviewed and Analyzed the Business and Functional Requirement Documents. • 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. • Generated reports using SQL server Reporting Services, and created user friendly templates, indexes, using xml • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Developed SQL queries to validate data in tables based on business requirements. • Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS. Extensive use of T-SQL DDL and DML commands for various applications.