Data Sql Server
Resume:
Ahmed Saleem
ac9hfh@r.postjobfree.com
Sr. MSBI/SQL Developer
PROFESSIONAL SUMMARY:
A result driven software professional with 8years of progressively responsible experience in DataAnalysis, Design, Implementation, Administration and Support of BusinessIntelligenceOLTP(BatchProcessing,OnlineProcessing), OLAP,ETL,Datawarehousing,Datamining,DBMS&DataModeling usingconfidential SQLServer2016/2014/2012/2008R2/2008/2005, SSIS, SSRS and SSAS.
Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.
Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
Experience in OLTP/OLAP environment and Data Warehouse.
Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
Extensively used Report Wizard, Report Builder and Report Manager for developing and deploying reports in SSRS.
Experience in developing Dashboard, Ad-hoc and Parameterized Reports using SSRS.
Strong experience in MS SQL Server with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’S, OLAP charts and SSRS Reports with PPS.
Excellent analytical, high level and low level design and problem solving skills.
Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.
Good Knowledge on Micro strategy reports, Development of Metrics, Attributes, Filters and various other Micro strategy components.
Experience in handling Master Data Management (MDM) services and setting up the Master Data Services (MDS) to integrate and maintain various entities.
Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Vision and Erwin Tool.
Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.
Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
Developed reports using global variables, expressions and functions.
Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
TECHNICAL SKILLS:
Databases
Confidential SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2, Postgre MS Access, NoSQL Databases (HBase).
Database Tools
MS SQL Server (2005/2008/2008 R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS)
Development skills
T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI
Languages
VB.net, Linux, UNIX
ETL Tools
DTS, SSIS (SQL Server Integration Services), Informatica
Reporting Packages
SQL Server Reporting Services, MS Excel.
Tools/Methodologies
MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.
Operating Systems
Windows XP, Windows 7, Windows 8, Win 2003/2008/2008 R2
Professional Experience
CoreLogic Credco LLC, San Diego, CA
Jun'18 to Present
MSBI/SSIS/SSRS/SSAS Developer
Responsibilities:
Actively involved in business rule analysis and gathered user requirements.
Created several SSIS packages for performing ETL (Extract, Transform and Load) operations from OLTP to OLTP and OLAP systems.
Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from Flat files, excel files and SQL server database.
Developed multiple test plans and test case documents working with Product Owners and Developers.
Worked on Dimensional modeling of the data from Scratch (Extracted the scratch data from heterogeneous sources and doing the ETL for incremental data loads using SSIS and building them into Dimension and Fact tables using Star Schema).
Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
Interacted with Business Analysts for UAT (User Acceptance Testing), and tested the possibilities of system failure with UAT.
Worked on data migration from Oracle sources to SQL server 2014.
Expertise in optimizing long running T-SQL lookup queries by managing Clustered and Non Clustered Indexes, Stored Procedures for Incremental Loads and long data load by dividing the large data loads into Batch Tables with optimum batch size using execution plan.
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for complex Databases and Worked with error handling and logging on SSIS packages.
Worked with Quest SQL Compare table and the data compare between Dev to Test and Test to Prod environment.
Created and modified stored-procedures, triggers, cursors, and views in support of DBA day to day duties or reports like Drilldown, Cross tab reports, Tabular reports.
Worked with handling the Data warehouse audits and error handling with rejects records, total counts of records based on the update, delete and insert and Power pivot.
Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.
Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.
Migrating Oracle database source based SSRS reports to SQL source-based by changing the Oracle source code to SQL code compatible.
Used Phabricator tool to verify the changes between existing script which is in source control to the script which I developed.
Developed Oracle scripts, Functions and Packages using Oracle SQL developer.
Created and managed database objects such as tables, views, indexes, stored procedures, and user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
Created Metadata reports in SSRS that gives the information about the metadata of the jobs like Effective from, Effective to, Current or not current report, Execution times and errors if there are any.
Involved in creating measure groups using different fact tables and created calculated members, Advanced KPI’s and named set in SSAS.
Used JIRA project management system to track the enhancements and developments on a daily basis.
Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014/2016.
Expertise in building and migration of various DTS packages.
Strong experience in creating and publishing packages in Framework Manager.
Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
Environment: Microsoft SQL Server 2005/2008/2012/2014/2016, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Power BI Desktop, SharePoint, TFS, Visual Studio 2015, SQL Server Analysis Services (SSAS), T-SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.
Cincinnati Children's Hospital Medical Center, Cincinnati, Ohio
Jan'17 to May'18
Senior SQL BI Developer
Responsibilities:
Involved in the performance of data consistency and tuning effectively with SQL Profiler, Index Tuning Wizard.
Involved in creating and maintaining database objects, Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications.
Installed SQL Server 2012/2014 and all necessary tools in Development, Staging and Production environments.
Upgraded SQL Server 2000 and 2005 to the SQL Server 2014 and troubleshoot the compatibility issues.
Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
Converted complicated Crystal Reports to Standard SSRS reports by creating stored procedures and mapping parameters thus by enabling Business Users easy access to one stop Reporting Solution via SSRS.
Created all types of database objects like Tables, Views, Triggers, Stored Procedures, Indexes, and User Defined Functions according to Business logic.
Responsible for Creating and Monitoring SQL Agent jobs and Scheduled Tasks on all environments.
Created SSIS packages by using various Transformations, Containers to import and export data.
Developed many Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports, Bar Graph Reports, and Cascading Parameters Reports using SQL SSRS 2010/2012.
Worked with different business users in setting up data marts based on their Analysis/Reporting needs.
Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
Involved in lot of installations/upgrades/deployments of new/updated tools and applications.
Documented all the procedures for Crystal Reports Conversions, SSRS Onboarding and other Application updates.
Experience with on-site / off-shore coordination by attending daily sync-ups and ensuring the deadlines are met.
Created relationships between tables in Power BI using Star and Snowflake schemas.
Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.
Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
Proficient in creating ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL server and transformed it using different transformation as Lookup, Fuzzy lookup and Slowly Changing Dimension SCD.
Worked on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.
Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.
Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.
Environment: SQL Server 2014/2012/2008/2005, SSIS-2012, SSRS-2012, Power BI, Crystal Reports, Periscope Data, Tableau Server.
Merck, Kenilworth, NJ
Apr'14 to Dec'16
MSBI/SQL Developer
Responsibilities:
Developed various T-SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.
Created Database Objects like Tables, Stored Procedures, and Views.
Creating Indexes and used Scan and Seeks for performance tuning.
Developed and deployed SSIS packages in Production Server.
Installed, Configured, Managed and Monitored SQL Server 2012/2008/2005.
Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
Created logging, custom logging and error handling packages.
Involved in supporting more than 80+ Users for various Reporting and Analytics requirements across multiple Business Units and departments.
Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts.
Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
Worked in production support to optimize the stored procedures and scheduled many jobs.
Created complex queries involving Sub-queries and Joins.
Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.
Creating tables, indexes and designing constraints.
Created Backend validations using Insert/ Update and Delete triggers.
Created usage based aggregations in cube to minimize time for query retrieval from client tool.
Generated Reports using Global Variables, Expressions and Functions for the reports.
Created many Complex Queries using MDX Expressions.
Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
Reviewed the SQL Server Error Logs and Application Logs to resolve the issues.
Develop the reports for business users using Crystal Reports.
Tested the reports and fixed bugs in the stored procedures.
Maintained the physical database by monitoring performance, integrity and optimized SQL queries for Maximum efficiency using SQL Profiler.
Provided 24x7 on call support for various projects and ensure that all critical database problems are resolved in timely manner.
Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting
Environment: SQL Server 2012/2008/2005, SSRS 2012/2008, SSIS 2012, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2012, XML, XSLT, MS Office and Visual source safe, Business Objects XI 3.1/3.0, XI R1/R2, Power BI, Power Map, Power Pivot, Power View.
Community Health Plan, Seattle, WA
Dec'12 to Mar'14
SQL Developer
Responsibilities:
Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.
Worked on internal project to develop a performance Data warehouse.
Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.
Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
Participated in creating reports that deliver data based on stored procedures.
Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
Developed Multi-dimensional Objects using MS Analysis Services.
Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
Designed and deployed various complex reports using MS Reporting Services.
Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.
Analyzed reports and fixed bugs in stored procedures.
Designed and implemented stored procedures and triggers for automating tasks.
Involved in Trouble Shooting Complex Reports.
Created Large Number of Report Models for users to create their own reports.
Fine-tuned SQL queries for maximum efficiency and performance.
Configured the report viewing security for various users at various levels using Report Manager.
Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.
Environment: Microsoft SQL Server 2012, Microsoft Excel 2010, Power Pivot, Team Foundation Server (TFS), Windows 2008.
NCCPL, Islamabad, Pakistan.
Sep'11 to Nov'12
SQL Developer
Responsibilities:
Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
Validated change requests and made appropriate recommendations. Standardized the implementation of data.
Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
Performed job scheduling in the SQL Server Environment.
Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
Managed user access. Created and managed new security accounts.
Backup and restore databases.
Developed and implemented database and coding standards, involved in improving performance and maintainability of corporate databases.
Environment: SQL Server 2000/2005/2008, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS
References: References will be produced upon request
Contact this candidate