Sql Server Data
Resume:
Ahmed Shuja
**********.****@*****.***
MSBI/SQL Developer
PROFESSIONAL SUMMARY
Around 8 Years of IT Experience in Software Analysis, Design and Development in Client/Server systems, Data warehousing and Business Intelligence applications.
Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services(SSAS)
Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), ETL and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
Experience in complete Software Development Life Cycle (SDLC) - requirements gathering, conceptual design, analysis, high and low level detailed design, development, system testing.
Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Ad-hoc reports using SSRS. Installed, configured and maintained SSRS server.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS/ETL Packages.
Experience in Performance Tuning in SSIS/ETL packages by using Row Transformations, Block and Unblock Transformations.
Using Dimensional Data Models and Ralph Kimball approach for faster database performance and simpler data navigation.
Working with SQL Server Job scheduling to execute Integration Services (SSIS) packages and to send reports to the client.
Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
Implementation of logging, configurations and Error handling, Checkpoint, Transactions in SSIS/ETL packages.
Excellent in High Level Design of ETL DTS Packages & 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.
Created SSIS packages to transfer data between OLTP and OLAP Databases.
Experience in creating and optimizing cubes on data warehouse using SQL Server Analysis Services (SSAS) of SQL Server 2008 using star and snowflake schema Dimensional Data Models for fact and dimension tables.
Expertise in ETL (Extraction, Transformation and Loading) development using SQL Server Integration Services (SSIS).
Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.
Expertise in generating reports using SQL Server Reporting Services (SSRS) and scheduling and deploying reports on report manager.
Good knowledge in developing and designing reports through SSRS and Excel.
Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
Designed and developed matrix and tabular reports with drilldown, drill through, parameterized reports, sub-reports using SQL Server Reporting Services (SSRS).
Enhancing the Reports visually by adding the visual elements like charts, graphs in SSRS reports.
Experienced in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export and SSIS packages.
Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
Excellent analytical, interpersonal, project management, organizational, communication and team building skills.
Execute tests, report and manage defects, troubleshoot and defect root cause analysis.
Experience in Logical & Physical Data modeling, data architecture designs.
Coordinating and tracking all projects for seamless releases using Project Management System JIRA and Source Code Management System SVN.
Experience in Functional Testing, and tracking defects using Team Foundation Server/Tortoise SVN.
Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
TECHNICAL SKILL
Databases
MS SQL Server (2008, 2008R2, 2014), ORACLE
DWH/BI Tools
SSIS (2005, 2008, 2014), SSRS (2005, 2008, 2012), Crystal Reports, Business Intelligence Development Studio (BIDS), Visual Studio, Erwin Data Modeler.
Development skills
T-SQL, PL/SQL, SSIS/SSRS/SSAS
Languages
CICS, PL/SQL, T-SQL, OLAP, C#.NET,C++, ASP.Net. VB Scripting, HTML
Reporting Tools
SQL Server Reporting Services, MS Excel,
Tools/Methodologies
MS Visio, MS Project, SQL Profiler, MS Office
PROFESSIONAL EXPERIENCE:
Indivior, Richmond, VA Apr’17-Present
Role: MS SQL Server Developer/ (SSIS/SSRS)
Responsibilities:
Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
Designed new reports and wrote technical documentation, gathered requirements, analyzed data, designed complex reports from different data sources such as SQL Database and Cubes.
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files
Created different kind of reports like List reports, cross tab reports, charts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports as well as managed the subscription of the reports (Standard and Data-Driven Subscriptions).
Monitored and modified Performance using execution plans and Index tuning.
Responsible for Migrate Data from multiple sources like flat file and Excel to Single SQL Server table.
Used Stored Procedures, DTS packages, BCP for updating Servers.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Automated messaging services on server failures, for task completion and success.
Leveraged dynamic SQL for improving the performance, and efficiency.
Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014.
Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
Advised optimization of queries by looking at Execution Plan for better tuning of the database.
Created SQL Server Reports using SSRS 2012/2014.Identified the data source and defined them to build the data source views.
Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
Transformed and combined the data using Query Editor in the Power BI.
Created Power BI Visualizations and Dashboards as per the requirements.
Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
Worked on creating and maintaining SSAS Databases which includes creating new Cubes, Dimensions, and Calculated Measures, Partitioning and building MDX queriesUsed FTP and SFTP servers to transfer files to vendors.
Implemented snowflake schemas in dimensional data modelling to extend existing models in the relational database.
Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
Query Optimization and Performance tuning.
Performed backup/ restore, database objects such as tables, procedures, triggers, constraints, Indexes and views
Environment: SQL Server 2016, SSRS 2016, SSIS, SSAS, MS SQL Server 2016 Management Studio, T-SQL, MDX, Power BI, Visual Studio 2013, Stored Procedures, GitHub and Microsoft Excel.
Kaiser Permanente, Pleasanton, CA Feb’ 15- Mar’17
Role: MS SQL Server Developer/(SSIS/SSRS)
Responsibilities:
Worked on Full life cycle development (SDLC) involving in all stages of development.
Involved in system study, analyze the requirements by meeting the client and designing the complete system.
Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse.
Responsible for identifying client and organizational needs and providing suitable system based solutions.
Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.
Involved in developing ETL for loading data into Database.
Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer the data quickly, efficiently and maintaining Integrity.
Create tables with primary and secondary keys that adheres to the dimensional database model
Developed ETL Processes using SQL Server 2012 Integration Services (SSIS) to migrate data from Oracle data source into a SQL Server 2012 database.
Created SSIS/ETL Packages by using different kind of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).
Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
Deployed SSIS/ETL packages across development, test and production environments using project deployment model.
Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.
Generate KPI for customer satisfaction survey results and disease management.
Created various reports like financial, audit and monitoring reports using Parameterized, Drill down and Drill through reports, Sub Reports, and charts using SSRS.
Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2012/2008.
Attended status meetings and took active role in initiating bug triage meetings when necessary.
Facilitated Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
Created and executed SQL queries and scripts to validate data movement and generate expected results for UAT.
Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional data modeling. Backup & recovery.
Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
Experience in Logical modeling using the Dimensional data Modeling techniques such as Star Schema and Snow Flake Schema.
Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.
Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012,Tableau SQL Server Integration Services(SSIS),Visual Studio 2010, TFS, Erwin, Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS),T-SQL,PL/SQL.
PECO Pallet, Irvington, NY Mar’13 – Jan’15
Role: SQL Server/SSIS/SSAS/SSRS Developer
Responsibilities:
Worked with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.
Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer the data quickly, efficiently and maintaining Integrity.
Created ETL Projects using SSIS in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
Designed ETL specification documents for all the projects.
Created SSIS Packages by using different kind of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).
Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
Deployed SSIS packages across development, test and production environments using project deployment model.
Created tables in the dimensional data warehouse and worked on the Ralph Kimball approach of the data warehouse.
Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
Connected Tableau server with share-point portal and setup auto refresh feature.
Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.
Implementing Facts and dimensions for providing views of large sets of data.
Created drill down, drill through, cascading parametric and sub reports from SSAS cubes that can be browsed on web.
Developed report specifications, created and modified reports using SSRS 2012.
Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.
Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012, SQL Server Integration Services(SSIS), Visual Studio 2010, TFS, Erwin, Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS),T-SQL,PL/SQL, Tableau, tableau server.
Vertafore, East Lansing, MI Oct’2011 - Feb’2013
SQL/BI Developer
Responsibilities:
Involved in Database maintenance plan and Implemented replication. Designed and implemented data access stored procedures and triggers for automating tasks.
Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
Developed Stored procedures, Views, User defined functions in line with business requirements.
Developed SSIS packages to automate data retrieval data from Oracle, SQL Server, Excel and Flat Files using MS Business Intelligence (BI/power BI) tool.
Developed and Scheduled SSIS/ETL Packages for loading Facts and Dimensions.
Scheduled SSIS packages to automate incremental load of Data Mart.
Worked on Informatica Power Centre tools Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Using Informatica PowerCenter created mappings to transform the data according to the business rules.
Tuned the Informatica mappings for optimal load performance.
Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
Developed, scheduled and generated variety of reports like List, Matrix, Chart and Sub Report and standard template by implementing SQL Server Reporting Services (SSRS).
Deployed and scheduled reports using SSRS to generate weekly and monthly reports.
Managed and coordinate with remote users for change request and optimization of application.
Scheduled SQL Server Agent jobs, alerts and designed and implemented user log in and security.
Prepare technical specifications and involve in end user training during hands off phase.
Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services, SQL Server Reporting Services (SSRS), Business Intelligence development Studio (BIDS), Power BI, Informatica Power Centre 8.6.1, Informatica Power Connect, HTML, PL-SQL, Visual studio 2008, SVN.
UBL - Pakistan Jun’ 2010 - Sep ‘2011
Jr. SQL Server Developer
Responsibilities:
Involved in installation and configuration of SQL server 2000 on Servers.
Applied patches and service packs to keep the database at current patch level.
Learned to Implement database standards, naming convention for the database objects and maintain database security.
Used Ralph Kimball approach and dimensional data modeling to extend the data base.
Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.
Implemented trigger and stored procedures and enforced business rules via checks and constraints.
Involved in data conversions and data loads from various databases and file structures.
Monitor failed and long running MS SQL Server jobs.
Environment: SQL Server 2005, DTS, T-SQL, Crystal reports7, ASP.Net.
Education
Bachelor’s in Electrical Engineering
Bahria University, Islamabad, Pakistan
Contact this candidate