OBJECTIVE

• Experienced SSIS Developer in the market for a challenging role supporting a company wif advanced technical skill in ETL and various SSIS tools.

SUMMARY

• 5 years’ experience in Information Technology as SQL/BI developer.
• Expert in data warehouse maintenance, troubleshooting and automation of reports using TSQL queries and writing stored procedures.
• Knowledge in dealing wif Relational Database Managements Systems (RDBMS), writing stored procedures.
• Good command and profound noledge in T - SQL statements in constructing triggers (DDL & DML), tables, applying constraints, variables, stored procedures, functions, views, User Defined Functions (UDF), and maintaining data integrity throughout the business environments.
• Experience in data transformation and utilization of data flow items such as OLE DB sources for data source setup, Lookup components, Derived columns, Multi casting split, Data conversions, applying Aggregate functions, Merge and Merge join.
• Expert noledge of data extraction, transforming and loading (ETL) using SQL Server integration services (SSIS), Data Transformation Services (DTS).
• Expert in developing dynamic packages and implementingETLdesign for incremental loads and data cleaning in data ware housing usingSSIS.
• Experience in enhancing and deploying theSSISPackages from development server to production server.
• Worked on all activities related to high level design ofETLDTS package for integrating data from multiple heterogeneous data sources (Excel, Flat File, Text format Data) usingSSIS.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and createdSSISpackages to load excel sheets from PC to database.
• Expert in designing Tabular Reports, Matrix reports, Drill Down reports, Drill Through Reports, parameterized reports in multiple data sets and creating charts using SQL Server Reporting Services 2012 (SSRS) in Data tools.
• Deployed all the reports to testing environment.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• An ability in Designing, Building the Dimensions, cubes wif star and snow flake schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Excellent communication skills, analytical skills, can understand business requirements in various domains, self-learning ability and leadership quality.

TECHNICAL SKILLS

Database: MS SQL Server 2014, 2012, 2008R2, 2008, MS Access 2003, 2007, 2010, 2013

SQL Server Tools: SSIS, SSRS, SSAS, Server 2008/2012 Management Studio, SQL Server Business Intelligence StudioReporting Tools SQL Server Reporting Services, Oracle Business Intelligence (OBIEE 10g & 11g), Tableau

Languages: T-SQL, SQL, MS ACCES

Office Tools: Microsoft Office 2003 / 2007 / 2010 / 2013 / 2016/

PROFESSIONAL EXPERIENCE

SQL Developer (ETL/SSIS/SSRS)

Confidential, New York

Responsibilities:

• Actively participated in interaction wif users, team lead, DBA's and technical manager to fully understand the requirements of the system.
• Performed data migration from SQL Server 2008 to SQL Server 2012.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created reports for tax ids and making sure the fee schedules are implemented correctly.
• Created reports for the provider and vendor data and making sure the fee schedules were processed correctly.
• Created Triggers to enforce data and referential integrity.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created reports basing on the requirements using SSRS 2012.
• Migrated data (import & export -BCP) from Text to SQL server.
• Designed SQLSSISPackages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLServer 2012, or further Data Analysis and Reporting by using multiple transformations provided bySSIS such as Data Conversion, Conditional Split, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2012.
• Extracted the data usingSSISfrom OLTP to OLAP.
• Developed, monitored and deployedSSISpackages.

Environment: SQL Server 2012/2008,SSIS, SSRS, Visual studio 2012, MS Visio 2007.

SQL BI Developer (SSIS/SSRS)

Confidential, Atlanta, GA

Responsibilities:

• Involved in Planning, Defining and Designing the Database using Erwin on business requirement and provided documentation.
• Created DDL scripts to create database schema and database objects.
• Implemented T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for business queries involving multiple tables & calculations from different databases.
• Imported data from text files and excel spread sheets into SQL Server 2012 database usingSSIS package.
• UsedSSISVariables for storing the values which are used in various components of Data Flow Task.
• CreatedSSISReusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Created environments inSSIScatalogs and run the packages in one environment for different environments.
• Scheduled Jobs for executing the storedSSISpackages which were developed to update the database on Daily basis using SQL Server Agent.
• Implemented Event Handlers and Error Handling inSSISpackages and also performance tuning theSSISpackages.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer based on the requirements.
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.
• Created relationship in both cube structure as well as in DataSource view using SSAS.
• Used full load and incremental load to ensure data integrity.
• Troubleshooting performance issues and fine-tuning queries and stored procedures using SQL Profiler and Execution Plan.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Report Services (SSRS), SQL Server Analysis Service (SSAS).

OBIEE Developer

Confidential, Detroit, Michigan

Responsibilities:

• Developed many Time-Series objects for tracking and performing the trend analysis of new card uses.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Performance Tuning of reports is done by identifying the indexes required on the back end tables and also from the data available in the Cache.
• Worked in Answers to create Reports & designed various report views like Table, Charts, Pivot, Created Column Filters and Prompts to filter the request and worked wif column formatting functions.
• Developed dashboards displaying the client requirements like cumulative order and invoice revenue by week for the current quarter.
• Upgraded RPD, Web Catalog (Answers, Dashboards) OBIEE 11.1.1.7.0 using upgrade assistant utility (Oracle Fusion Middleware Upgrade Wizard).
• Built OBIEE Repository at 3 layers me.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Worked wif OBIEE Answers, Intelligence Dashboards. Demonstrated noledge in dealing wif various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.

OBIEE Developer

Confidential, Virginia Beach, VA

Responsibilities:

• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling.
• Use the best practices of business intelligence to meet project and company objectives.
• Using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Implemented security by creating users and adding them to groups for new hires.
• Worked wif Metadata and Interactive Dashboard Development wif drill down capabilities.
• Building Metadata Repositories (.rpd) Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool.
• Design and developed Dashboards like Revenue, Expenses, Hire to retire wif three levels of aggregation drilling across using Dashboards Links, Guided Navigation.