SUMMARY:

• 8 years of Strong Experience in developing applications using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services(SSRS) in Production, Development and Testing Environments.
• In - depth understanding of SQL Server and various database and business intelligence tools with Database Developer with strong background in Data warehousing and ETL experience.
• Experienced in Data Loading ETL by SSIS, Data Analysis by SSAS and Reporting by SSRS
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Excellent experience in migration of data from Excel, Flat file, XML, Oracle to Microsoft SQL Server
• Highly proficient in the use of T-SQL for developing complex stored procedures, tables, user functions, relational database models and data integrity, SQL joins and query writing.
• Using PowerShell scripts to create environment variables and configure and mapping with Project Parameters for deployment of SSIS packages in Dev, Test as well as Proc servers
• Delivered BI reporting solutions in SSRS, and Tableau.
• Developed complex SQL queries using stored procedures with parameters and variables, table variables, common table expressions (CTEs), and temporary table to support SSIS, SSRS.
• Provided continued maintenance and development of bug fixes for existing and new SSIS packages and reports.
• High level of energy, integrity and work ethics with an exceptional ability to deliver outstanding bottom line results, which improves productivity to automate and maintain applications and database operations
• Team player and self-starter with excellent communication and documentation skills, ability to work independently or as part of a team and capable of picking up new skills quickly.

TECHNICAL SKILLS:

SQL Server 2008/2012/2014 , SQL Server DQS, SSIS, SSAS and SSRS, SSMA, C#, VBA, Oracle 12c, Oracle 10g/11g, Power BI, Tableau, MS Visio, Access 2007/2010 database, Tableau on Operating Systems Windows Server 2008R2, 2012R2,Windows 7/8/10 and VMware, SAP Crystal report.

WORK EXPERIENCE:

Confidential, Chanti lly, VA

SQL SSIS ETL Developer

Responsibilities:

• Worked with installing, designing and managing MS SQL Server 2012/2014/2016. Migrated SSIS Packages from SQL Server 2008/2010, Oracle, DB2 to SQL Server 2014.
• Worked on Business intelligent tools SSIS, SSAS and SSRS as well. Create and modify data warehousing, dimensional, relational, and OLAP data modeling. Developing database tables and views in Extract, Stage in - out as well as Data Warehouse or Data marts databases.
• Design and develop database and tables for SSIS package design requirements
• Using SQL server Management studio to create store procedures, configuration files, tables, views, and user defined functions; implement best practices to maintain optimal performance.
• SQL server Business intelligent ETL tool SSIS to design and develop SSIS packages Created packages using SSIS for huge data extraction from Flat Files, Excel Files, and OLEDB to SQL Server using Execute SQL Task, Dataflow Task, Execute Package Task, Foreach Loop Container, Script Task, Fuzzy Lookup, Lookup, Derived Columns, Condition Split, Aggregate, 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.
• Designing and developing ETL programs and stored procedures for Data Warehousing using SSIS. Cleaning the data using multiple methods based on different situations of ETL processing development.
• Using C# and VBA to handle complex logical scripts within Scrip tasks.
• Written T- SQL Scripts and Stored procedure to extract data from Database and for Testing Purposes.
• Trouble shooting ETL execution issues on DEV, TEST, PROC working environments and configured SSIS packages to allow packages run on different environments successfully.
• Configured permissions of new instances of SQL Server for deploying SSIS packages into SSISDB.
• Configuration deployment environment variables to ensure deployed packaged running successfully in different servers.
• Experience in creating complex ETL SSIS packages using proper control and data flow elements with error handling.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Created Maintenance Plans and setup log files to monitor jobs.
• Develop test cases and perform Unit testing and system testing of assigned components.
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2008/2 .
• Except using the project deployment model and the legacy deployment model, Using PowerShell scripts to create environment variables and configure and mapping with Project Parameters for deployment of ETL SSIS packages in Dev, Test as well as Proc servers.
• Modifying connection string expression and variables to ensure SSIS packages dynamic configuration.
• Creating and developing SSRS reports in to rich look.
• Experienced in designing, building and deploying multidimensional cubes using SSAS
• Create and analyzed cube data to generate reports using SSAS for business users.
• Implementing the comparing QA test when data is loaded to different server destinations using Red Gate Software.
• Refreshing the data periodically on QA test server to ensure data accurate and consistent before raise tickets for DBA update data on Production.
• Developing SSRS reports and modified the existing SSRS depended on client requirements.
• Data Management and Visualization with Tableau for reports generation.
• Design and created Visio Data Flow Diagram using MS Visio for diagramming in the design phases proposal. Explained the whole design of ETL Process using Visio tool.
• Documentation ETL processing with SSIS packages and applied Naming Standards in TEST and PROC servers

Confidential, Elkridge, MD

SQL SSIS ETL Developer/Report Developer

Responsibilities:

• Creating ETL processing by using SSIS package to load data from Flat files, Excel files, and OLEDB data sources to SQL Server 2008/2012/2014 by using Control flow tasks of Foreach loop container, Execute SQL tasks, File system task, Script task and Data flow tasks of Lookup, Fuzzy Lookup, Derived Columns, Condition Split Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Creating SSIS packages and perform Incremental Load in SSIS 20008/2012/2014
• Using SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Update data warehouse data by Slowly Changing Dimension (Type 1, Type2 and Type3) simple pass through mapping.
• Updating the data load ETLs, Data Initial Validation process by Store Procedures, Data Cleansing and Standardization process.
• Ability to analyze business rules, perform data mapping and update ETL packages to improve ETL processes performance.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Data analysis and data migration by transferring them using SSIS packages.
• Designing, developing, and deploying reports in MS SQL environment using SSRS 2008/2012/2014 .
• Developed Parameterized reports with Drill Down and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Using Database and Data warehouse knowledge and analytical programming skills to develop and upgrade reports and/or reporting/analysis tools by SSRS and SSAS for product offerings to support our business and clients goals.
• Understanding of development, data modeling and ETL knowledge that includes Data Warehouse, Data Modeling, Star and Snowflake schema
• Knowledge of logical and physical data modeling concepts (relational and dimensional)
• Developing Logical and physical data model mapped the data into database objects
• Using SQL Server Management Studio to create complex Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Modify existing SQL server queries, T-SQL (DDL and DML), store procedure, view, packages, and ETL jobs.
• Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Used SQL queries to pull the data in tableau desktop.
• Experience with Tableau, dashboard design and delivery.
• Identifying issues with the claims / eligibility data and identify solutions to fix data issues
• Monitoring and troubleshooting performance issues on the application servers.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Confidential, Washington, DC

SQL SSIS ETL Developer/ Database Developer

Responsibilities:

• Managed database elements, including creation, alter, delete and copy of schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL.
• Interacted with Team, Designed and developed database using ER diagram, Normalization and relational database concept.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse
• Identified slow running query and optimization of stored procedures and tested applications for performance.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Transformed data from One Production server to another server using OLE DB connection by creating various SSIS packages.
• Created SSIS package configuration using environment variable to change the value of variables.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis
• Generated ETL packages with different data sources and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Updated the technical requirement as per a given requirement and created data mapping document for data transformation.
• Developed complex Stored Procedures, functions, triggers, Indexes and views
• Created and monitored automated scheduling jobs and alerting using SQL Server Agent.
• Created new SQL Server Instance, Installation configuration, Managing server and security, move or copy database to multiple location.
• Created complex Stored Procedures that accept parameters/Functions and used them in Reports directly to generate reports on the fly.
• Experience in Maintaining server level and database level security best practices by creating users, configuring permissions and assigning different roles to users.
• Created, maintained, updated and troubleshooting of SSIS packages.
• Administrated, updated, troubleshooting and development of SSRS
• Created Database Backup scheduling jobs for production and development environment.
• Optimize SQL queries, Stored Procedures and functions.
• Managed database elements, including creation, alter, delete and copy of schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints.

Confidential, Tampa, FL

SQL Server Database Developer/ Report Developer

Responsibilities:

• Develop database architectural strategies at the modeling, design and implementation stages to address business requirements for both transactional and data warehousing systems. Contributed to build three start schema Data Marts with my team members including three fact tables and 14 dimension tables.
• Successful database design and data validation performance before loading data for migration of Chip-DNA Sequences and Clinic trails experiments data in many relational databases of SQL server 2008/2012/2014
• Created ETL packages using SQL Server 2008/2012/2014 SSIS to extracted data from different data sources such as SQL, MySQL, Oracle, MS access even remote server with different file types such as flat file, Excel, XML files, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).
• Developed projects using SQL Server 2008/2012/2014 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified OLAP cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using MDX.
• Generated variety of business reports using SQL Server 2008/2012/2014 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint.

Confidential, Tampa, FL

Data Analyst

Responsibilities:

• Identify relationships and trends in data, as well as any factors that could affect the results of research by using SAP Crystal report.
• Report results of statistical analyses, including information in the form of graphs, charts, and tables. See more occupations related to this task.
• Analyze and interpret statistical data to identify significant differences in relationships among sources of information.
• Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports.
• Compile and validate data; reinforce and maintain compliance with corporate standards.
• Develop and initiate more efficient data collection procedures.
• Used advanced Microsoft Excel functions to generate spreadsheets and pivot tables.
• Extracted, compiled and tracked data, and analyzed data to generate reports.
• Collecting different kinds of research data which we generated from Real-Time PCR, Elisa, and Flow Cytometry in mouse model as well as clinic data from clinic trails with formatted and integration. Loading all the data to our databases. Analyzing data to find anti-tumor signaling pathway based on gene expression profile and changes in protein level comparing with control groups.
• Analyzed results. Coordinated and executed experiments and assessed results.
• Designed and carried out clinical evaluation, analyzing results upon completion.
• Discovering trends and relationship between malignance and gene expression prior, during, or post anti-tumor drug treatment. Data from Real-Time PCR were formatted and analyzed in Excel, ELISA analysis software, CFX Manger Software, Prism, Photoshop, FlowJo, MS office for Clinical trials experiments.

Confidential, Tampa, FL

Research Scientist

Responsibilities:

• Discovering genes and cytokines which are associated with malignance and developing small molecular for immunotherapy against cancer in mouse model and human cancer cell lines. Generating data from PCR, RT-PCR, Flow Cytometry as well as Elisa to compare drug efficiency on cytokines level as well as gene profile. Creating spreadsheets of Excel files based on gene profile and cytokines production for mechanisms study. Creating Access databases to store and analyze all the data for final reports and publications using MS office including Excel spreadsheet.

Environment: Microsoft SQL Server 2008/2012/2014 , Oracle 12c and Oracle 10g/11g, Data warehouse modeling, T - SQL, 2012/2014 SQL Server Data Quality Services, Performance Monitor, SSIS, SSRS, Tableau, Microsoft Office.