SUMMARY

• SQL/BI Developer with over 7 years of professional IT experience in Database /Data Warehouse Design, Development and Analysis using MS Access 2008/2010/2013 , MS SQL Server Management Studio 2005/2008/2008 R2/2012/2014, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and Tableau
• Extensive knowledge of Object Oriented Analysis and Design(OOAD) including Unified Modeling Language (UML) Diagrams(User Cases/Class/Domain Model/Black-box/ System Sequence/White-box Sequence)
• Profound knowledge of Software Development Life Cycle (SDLC) and Project Management Methodologies including Waterfall and Agile Scrum/XP
• Adept in analyzing Business Requirements using MS Access to load Data from different Data Sources, create Tables, Queries, Forms, Reports, draw Entity-Relationship(ER), and Extended Entity-Relationship (EER) Diagrams
• Superior in involvement for creating Fact Tables and Dimension Tables, Star Schema and Snowflake Schema for implementing Data Warehouse Structures
• Built Complex Tables, Temp-Table, Table-Variable, Stored Procedures, User-Defined Functions, Indexes, Triggers and Joins using T-SQL Queries, Dynamic SQL Queries and Sub-Queries
• Exceedingly experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery Procedure and Replication
• High proficiency in Extraction, Transforming and Loading (ETL) processes to Perform Data Transfers from OLTP to OLAP, different server locations and heterogeneous sources like Oracle, Excel, XML, Flat Files
• Strong skillset in using Incremental Loading including CDC to Extract Data from Raw Data and SCD/ Lookup to Load Data from Staging Area to Data Warehouse
• Excellent skills to deploy SSIS Packages by using different Package Configuration especially XML / SQL / Environment Variables Configurations, and deploy SSIS Project with project parameters
• Highly knowledgeable to set Package Schedule by using Job in SQL Server Agent
• Sufficiently generated different types of routines and Ad-Hoc Reports, Dashboard Reports, Cascading parameterized Reports, Drill-Down/Drill-Through Reports, and Sub-Reports by using SSRS
• Proficient in SSRS deployment, and very knowledgeable to create cache/snapshot/subscription(Standard and Data-Driven) for SSRS reports
• Skilled in managing OLAP Cubes, creating Key Performance Indicators (KPI) and set up Security and Perspectives in SSAS
• Outstanding Communication and Problem Solving skills with strong ability to translate all critical business requirements and needs to technical specifications achieving all project deliverables

TECHNICAL SKILLS

Programming: JAVA, J2EE, JavaScript, C, C++, C#, Android Studio

System: Windows 2000/XP/Vista/7/8/Linux, SharePoint 2010/2013, Team Foundation Server

Database Tools: Server Integration Service (SSIS), Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS), Tableau 7.0/8.0/8.1/8.3 , Amazon cloud, MySQL, MS Visio 2010, MS Access, MS SQL Server 2005/2008/2008 R2 /2012/2014

Web: HTML/HTML5, CSS, Adobe Dreamweaver

Office Tools: MS Office/Excel/PowerPoint/Outlook

Others: Computer Graphic, Agile Scrum/XP, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

MS SQL Server Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Write T-SQL statements and use local and global Temp Tables, Views, and CTEs to support data extraction
• Create Stored Procedures and Views to support reporting and interface data requirements
• Create SSIS Packages for interfaces from different end users and different departments, loading data into various output files
• Design daily/weekly/monthly SSRS reports utilizing multiple types of reports including sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports
• Work with deployment environment at final stage and establish database connections to tables and datasets
• Provide migration and integration between SQL Server 2008 and 2012 under SQL Server Management Studio
• Involve in multiple Software Development Life Cycle (SDLC) phases, including requirement gathering from end users, providing requirement analysis, and designing data mapping documents
• Provide data cleansing including removal of duplicate data, conform data and time data type formatting, string editing, and data conversions
• Update queries and Stored Procedures for existing reports according to updated requirements, and provide maintenance for database environments

Environment: SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office 2007/2013, Windows 8/7, Team Foundation Server.

Confidential, Trenton, NJ

MS SQL Server Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Imported & Exported of data from Raw Data to Database/Data Warehouse by designing/implementing with SSIS Data Flow Task
• Wrote T-SQL statements for retrieval data and involved in performance tuning of TSQL queries mainly using Execution Plan/ SQL Profiler
• Wrote T-SQL statements to create local and global Temp Tables, Views and Derive Tables for team leader to check information
• Designed/Built Extract Transform which extract data from data source by using Incremental Load CDC in SQL Server Integration Services
• Created SSIS packages, deployed SSIS Package using different Configurations and executed the packages and scheduled in SQL Server Management Studio
• Created debugging methods to debug errors in SSIS Packages, as set Error handling in Data Flow/ Break Points in Control Flow, and also created Send Email Task and set Logging to get error information through Email
• Deployed SSIS Project with project parameters and set different environments in SQL Server Management Studio which allow packages executed in different environments
• Involved in some phases of Software Development Life Cycle (SDLC), including requirements gathered from business users, analysis, design, create of mapping documents
• Weekly updated the Dimension and Fact tables through SSIS Packages and created new Dimension Tables when new requirements added
• Using Incremental Data Loading: Lookup to fulfill Slowly Changing Dimension when load data from Staging Area to Data Warehouse.
• Designed SSRS reports with sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports
• Involved in creating calculated members, named set, advanced KPI’S for the SSRS reports

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office, Windows 8/7, Team Foundation Server.

Confidential, Dallas, TX

BI Developer (SSMS/SSIS/Tableau/SSAS)

Responsibilities:

• Gathered the requirements and analysis whether these requirements can be fulfill, then design UML Diagrams, including class/ use case/ black-box/white-box diagrams
• Compiled data from different data sources, then built ETL package, migrated data, like account and customer data, from XML, Flat Files, old version Databases and Oracle, cleaned and backed up data, and synchronized daily transactions by using SSIS
• Implemented the automated processes for the activities such as Database backup processes and SSIS Packages run sequentially using SQL Server Agent job
• Set Error Handler/Data Viewer/Break Points/Logging to debug in SSIS Control Flow
• Involved in TSQL Performance Tuning by using Execution Plan/ SQL profiler
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
• Created and Configured OLAP Cubes (Star Schema) using SQL Server 2010 Analysis Services (SSAS)
• Used various SSIS tasks such as Conditional Split, Derived Column, etc. for Data Scrubbing, including data validation checks during Staging Area(before loading the data into the Data Warehouse), and design ER Diagrams by using MS Visio2010 in Data Warehouse
• Developed, designed and supported complex Tableau reports that measure key business metrics such as Customer flow and Cross-transfer to be delivered to Management on a scheduled basis by using tableau
• Converted Stored Procedures, User-Defined Functions to new datasets for creating reports in Tableau
• Used SQL Server Analysis Services (SSAS) to design cubes for summary reports

Environment: SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visio2010, Tableau 8.0/8.1/8.3, MS Office, Windows 7/XP, SharePoint 2013

Confidential, Houston, TX

BI Developer (SSMS/SSIS/SSRS/Tableau)

Responsibilities:

• Used SSIS Data Conversion when extract Data from Source like Flat File, XML, and other databases (Oracle)/Condition Split to separate output followed by the requirements…
• Wrote TSQL like Indexes, Views, Stored Procedures and Triggers in SSMS to fulfill Requirements
• Deployed SSIS Packages using Package Configurations, and used SQL Server Agent to schedule package deployment
• Involved in creating subscription both Standard and Data-Driven to delivery reports in a special time
• Created caches and snapshot to store the reports at a specification time then the company can use them later
• Used SSRS to create Drill Thought/Drill Down reports with KPI for inner group weekly
• Debugged SSIS package by using Break Points/Error Handling/Data Viewer
• Loaded data from Staging Area to Data Warehouse by using Slowly Change Dimension: Lookup
• Created new dimension tables and modified old ones in the data warehouse which be built by others
• Designed and created Report templates, bar graphs, donut and pie charts used tableau

Environment: SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tableau 6.0, MS Office, MS Excel, Windows 7, SharePoint 2010.

Confidential, Frisco, TX

MS SQL Server Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Wrote SQL and higher level T-SQL including Create Tables, Indexes and applied Constraints, connected various applications to the database and written User Defined Functions, Nested Stored Procedures, and Nested Triggers…
• Successfully migrated data between different heterogeneous sources such as Flat File, Excel and SQL Server 2008 using SSIS and Bulk Insert
• Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and XML html files
• Used Lookups Transformation to get the data from reference data sets by using SQL Server Integration Services (SSIS)
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
• Designed and modified configuration to set work schedule in MS SQL Server after deployed packages and projects
• Used Expressions, Functions and wrote code using C# for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2008
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008, Analysis Services (SSAS) and Reporting service (SSRS)

Environment: SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, MS Office, Windows XP.

Confidential

MS SQL Server Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Extracted Data from different data sources as XML/Flat Files/Oracle and use Data Conversion to clean the data type and then load to SQL Server
• Imported Data from MS-Access 2005/MS-Access 2007/ Oracle Database and XML files to SQL Server Database
• Converted complex business logic into SQL Stored Procedures and User-Defined Functions to achieve functionality required by business analysts
• Created and updated Views and temp tables to analysis requirements from customers also created new indexes and triggers and update old ones
• Worked for TSQL and SSIS Performance Tuning include Execution Plan/SQL Profile…, and set MaxConcurrentExecutables/ EngineTreads…
• Created SSIS packages including Control Flow and Data Flow, use Execute SQL Task, For Loop /For Each Loop/ Sequence Containers…, and Data Conversion, Conditional Split, Lookup transformations
• Involved in SSIS life cycle in creating SSIS packages, building, deploying and executing the packages
• Using SSIS Packages and created data mappings to load the data from source to destination
• Created interactive reports with SQL Server Reporting Services (SSRS) as Drill Through/Drill Down reports, using the report parameters, query parameters, Filters and Expressions
• Deployed SSIS Packages with different Configurations

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS-Access 2005, MS Office, Windows XP.