Sql Server Data
Resume:
KHAWJA AHMED
***** ******** *** ***, *******, TX 77429
**********@*****.***
OBJECTIVE: BI Developer/SSIS Developer/ETL Developer/Database Developer/ SQL Server Reporting analyst/Programmer Analyst
SUMMARY:
More than 8 years of experience in SSIS Developer/SSRS Developer/SSAS Developer/Database developer/ BI developer/Data warehousing
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) / Data Transformation Services (DTS)
Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005/2008/2010/2012/2014 for integrating data using OLE DB /ODBC /FTP connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all etc.
Skilled in SQL Server 2005/SQL Server 2008/ SQL Server 2010/SQL Server 2012 /SQL Server 2013 Business Intelligence tools/SQL Server Data Tool/Team Foundation Server (TFS)/Data Warehousing and ETL processes.
Good Hands on experience in Data Warehouse Design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
Proficient in work with Business intelligence development service(BIDS)
Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)
Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2010/2012/2014/) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS 2005/2008/2010/2012.
Working experience using in SQL Server Analysis Services (SSAS)
Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
Proficient in analytical query using MDX
IT domain focused on delivering Business Intelligence analysis tools.
Database Analysis, Reporting, Development and common Administration tasks
Ability to deliver comprehensive BI through MS solutions including MS Excel, Microsoft Office
Understanding Power BI, Share Point, Excel Services, PowerPivot
Experience in all phases of MS Access database development and design
Experience working with SQL Server 2005, SQL Server 2008,SQL Server 2012 programming dynamic queries, and stored procedures
Proficient in DML and DDL operations in SQL
Ability to analyze and interpret data to create marketable information
Skill in Visual Basic Coding
Proficient in Power BI (Creating Dashboard)
Skill in Microsoft office project and Microsoft Visio
Experience in work with ColdFusion development
Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012/2014/2016 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL
Certification: Microsoft Certified Technology Specialist (MCTS) in SQL Server 2008, Business Intelligence Development and Maintenance
EXPERIENCE:
Lone Star College-University Park, Houston, Texas Oct-2016-Present
BI Consultant
Creating and modifying existing SSIS package from Oracle database to SQL database
Deploying SSIS package into multiple environment.
Taking existing Oracle BI Publisher/OBIEE Dashboard and other reports converting to SSRS using SQL Server 2016
Comprehensive SOW that covers the back-end architecture, governance, security administration, etc.
Bray International Inc
SQL and BI Developer April-2014 – July-2016
Development, optimization, and maintenance ETL process using SSIS tool
Created complex SSRS reports by pulling data using SSIS Package
Design, document, optimize, and maintain scalable ETL packages utilizing SSIS
Providing scheduled and ad-hoc reporting solutions, data analysis and general business intelligence. This includes developing and deploying SSRS reports, automating current reporting packages, working with business analysis to interpret report requirements and developing SQL queries for complex data structures across multiple databases.
Performed data conversion from flat file into a normalized database structure
Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent and scheduled Jobs using SQL Server Agent
Creating user friendly Report using SSRS Platform
Design, develop, document, and maintain reports with SSIS / SSRS, along with migrating reports to SSRS
Developed various operational Drill-through and Drill-down reports using SSRS
Developed different kinds of reports such a Sub Reports and Charts, Map etc.
Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012/2014/2016 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL
Compass Professional Health Service, Dallas, TX Dec 2013 – Feb-2014
SQL and BI Developer
Job description:
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Create project and solutions using BIDS.
Delivering Business Intelligence solutions to end clients
Worked on writing ETL processes using SSIS in a data mart/warehouse environment
Create SSIS Package for data transformation and execute data flow
Worked on creating number of ETL processes using SSIS to populate data into Staging, Transformation, and Data warehouse databases tables
ETL design and development, BI solution design and development, dashboard and visualization development, testing, and solution implementation and maintenance
Responsible for loading & modeling data using SSIS in a data mart / data warehouse built using the dimensional data model (DM) in a MS SQL Server environment
Responsible for design, develop and implementation of BI reporting solutions using SQL Server 2008 SSRS
Develop in SQL reporting, or data package transitions
Maintain and building and maintaining SQL Server Analysis Service (SSAS) cubes and associated data stores
Develop reporting framework and reporting deliverables in SQL Server Analysis Service(SSAS)
Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012/2014 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL
Express-scripts, Irving, TX NOV/ 2012 – Nov/ 2013
Sr Programmer Analyst
Job description:
Create SSIS Package for data transformation and execute data flow
Create project and solutions using BIDS.
Developed and delivered number of complex SSRS reports, SSIS packages
Worked on creating number of ETL processes using SSIS to populate data into Staging, Transformation, and Data warehouse databases tables
Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer
Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2 as SSIS Packages
Followed Microsoft recommended best practices in designing, developing and implementation of the ETL using SQL Server Integration Services (SSIS), including upgrading DTS to SSIS
Involved in creating SSIS jobs to automate the reports generation and cube refresh packages
Responsible for design, develop and implementation of BI reporting solutions using SQL Server 2008 SSRS
Developing BI solutions using SSIS, SSRS (BIDS)
Developed reports using Microsoft BI Stack
Parameterize report to make user friendly report for users.
Worked on Microsoft BI Platform
Creating Tabular and Multidimensional Cubes
Strong understanding of OLAP database/cube architecture, Normalization & Data mining
Plan, design, and implement application database code objects, such as stored procedures and views.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Design, implement, and support data warehousing requirements
Implement business rules for data loading and integration
working with relational database management systems
Application development in Cold Fusion
Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL
Medco Health Solutions, Irving, TX Feb 2011 – Oct 2012
Developer Analyst
Job description:
Development, optimization, and maintenance ETL process using SSIS tool
Created complex SSRS reports pulling data using SSIS Package
Design, document, optimize, and maintain scalable ETL packages utilizing SSIS
Migrating SSIS packages from SQL Server 2005 to 2008 and SQL Server 2008 to 2012
Performed data conversion from flat file into a normalized database structure
Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent and scheduled Jobs using SQL Server Agent
Creating user friendly Report using SSRS Platform
Design, develop, document, and maintain reports with SSIS / SSRS, along with migrating reports to SSRS
Developed various operational Drill-through and Drill-down reports using SSRS
Developed different kinds of reports such a Sub Reports and Charts, Matrix reports
Creating analytical report using Report wizard and other tools.
Published report and creating report using report builder
Configured Server for sending automatic mails to respective people when a SSIS process failure or success
Developed number of stored procedures, executing through SSIS packages. Used Merge’ statement for inserts and updates in the stored procedures.
Configuring Data source and data source view using Cube wizard in BIDS
Design, code, test, and document all new or modified BI systems, applications,
Plan, design, and implement application database code objects, such as stored procedures and views.
Enhancement of existing SSAS OLAP cube report and modifying existing Data warehouse and data Mart
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Perform quality assurance and testing of SQL server environment.
Application development in Cold Fusion
Environment: Data Warehouse, ETL, SQL Server 2005/2008, data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL
Verizon, Irving, TX (Sep 07 –Jan 2011)
BI/SSIS Developer (Cofee/Billing Project)
Job Description:
Responsible to maintain SSIS, SSRS reports through version control TFS, also responsible for create and modify existing database changes including tables, stored procedures and maintain the code in TFS.
Involved in migration of Data from Excel, Flat file, Oracle, XML files to SQL Server by using Deployment utility
Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer
Migrated data using ETL Tool in SSIS
Responsible for code change movement process, responsible for moving code from DEV to UAT and PROD. Responsible to address Service tickets, and troubleshoot production issues
Environment: SSRS, SSIS, SSAS, MDX, Performance point, Power pivot, T-SQL
Create project and solutions using BIDS.
Worked with SSRS creating analytical report using Report wizard and other tools.
Designed and developed reports in MS SQL Server Reporting Services(SSRS)under SQL Server 2005/2008/2012
Parameterize report to make user friendly report for users.
Published report and creating report using report builder
Building Tabular and Matrix reports and report on cube.
Reported all events and requirements through established reporting mechanisms in SSRS
Worked with SSAS architecture, creating cubes, Dimension and measure groups, configuring Data source and data source view using Cube wizard in BIDS
Designed and implemented Dimensional models, Star Schema, created Fact and Dimension tables, designed and developed OLAP Analysis Cubes using SQL Server 2008 SSAS.
Perform quality assurance and testing of SQL server environment.
Develop new processes to facilitate import and normalization, including data file for counterparties.
Performing data integrations between a warehouse, CRM and other source systems using varied data access methods
Created Data warehouse Cubes in SQL Server Analysis Service (SSAS)
Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
Environment: Data Warehouse, ETL, SQL Server 2005/2008, data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL
Department of Youth, Dhaka, Bangladesh (Jan 2004 –July 07)
Job Description:
Responsible to maintain SSIS, SSRS reports through version control TFS, also responsible for create and modify existing database changes including tables, stored procedures and maintain the code
Designed and implemented Dimensional models, Star Schema, created Fact and Dimension tables, designed and developed OLAP Analysis Cubes using SQL Server 2008 SSAS.
Parameterize report to make user friendly report for users.
Responsible to maintain Microsoft SQL Server Integration Services, Reporting Services and Analysis Services
Working on Understand the source and Client tables, design the data transformations needed to move the data from source to Client
Responsible for Design, development, testing, deployment, support and troubleshooting for SSIS ETL programs and SQL scripts
Support requirements in SSRS and in this area would understand the business requirements for reporting
Worked with cubes, fact and dimension extensively for SSIS and SSRS
Manage various sources of information and large data sets
Compiling data, creating reports and presenting information, including expertise with SQL Server Reporting Service, MS Access
Design, development and tuning of relational databases using SQL Server 2005
Develop effective and efficient software components that comply with software design specifications as well as customer and industry best practices
Provide time estimates for assigned work products that accurately reflect the level of effort required for requested development
Conduct thorough unit testing of all assigned work products
Support the deployment of software solutions into the customer's production environment
Provide immediate solution support and troubleshooting following deployment
Write quality technical documentation to describe resolution actions and best practices. Document operational procedures
EDUCATION:
Masters in Information Systems (MIS), University Of Phoenix, Phoenix, AZ
Contact this candidate