Post Job Free

Resume

Sign in

MSBI Developer

Location:
Seattle, WA
Posted:
September 07, 2015

Contact this candidate

Resume:

acrk22@r.postjobfree.com

Contact: 404-***-****

Professional Summary

Over years 7 of IT experience in sectors as a SQL server Developer that includes Database Design and Development of SQL Server 2012/2008R2/2008/2005.

Highly motivated Business Intelligence Professional using SQL Server and Microsoft Technologies.

Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2008R2/2008.

Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSAS, SSIS) using SQL Server 2012/2008R2/2008/2005.

Extensive experience in Analysis service development (both star and snow flake schemas) of multi-dimensional models and tabular models using SQL Server 2012/2008R2/2008/2005.

Extensive experience in providing Enterprise Reporting solutions using SSRS 2012/2008R2/2008, Power BI tools ( like power query, power pivot, power views )and SharePoint Services.

Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.

Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance.

Hands on experience in Waterfall model.

OLTP Experience

Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.

Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL and relational database models.

Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.

Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.

Expertise in scripting T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views.

Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Indexed views and Database triggers.

Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.

Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring.

Experience in query optimization, running DB Consistency Checks using DBCC commands.

Efficient in creating joins and sub-queries for complex queries involving multiple tables.

ETL, OLAP Experience

Analysis Services (SSAS Multidimensional Model / Tabular Model):

Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.

Expert in designing and developing Tabular models.

Implemented Role based and user based subject selection in Tabular models.

Expert in DAX functions.

Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.

Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.

Expertise in creating Cell Level Security in cubes using SSAS.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Worked on OLAP Storage modes likes ROLAP/ MOLAP/ HOLAP.

Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.

Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.

Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).

Reporting Services (SSRS/ Power Pivots / Power Views / Power Queries):

Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.

Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.

Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.

Developed reports using global variables, expressions and functions using SSRS.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.

Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.

Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.

Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

Data Transformation Services/ Integration Services (DTS/SSIS):

Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Worked on migrating some of the DTS packages in to SSIS.

Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.

Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.

Extensive knowledge of using Package Configuration wizard to configure SSIS packages.

Expertise in creating Property Expressions, Script Tasks for SSIS packages.

Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.

Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.

Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages, Monitoring Integration services Performance and activity, and implementing Security considerations for SSIS Packages.

Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.

Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

Created SSIS Packages for Incremental Loading and slowly changing dimensions.

Created logging, custom logging and error handling packages.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.

Executed the DTSX Packages by using DTExec Command.

Converted data using Derived Column, Data conversion transformation and Script task.

Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files.

Created SSIS Packages using Variables, Expressions and Environment Variables

Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team.

Technical Skills

RDBMS: MS SQL Server 2012/2008R2/2008, MS Access.

Programming Languages: T-SQL,C#, VB scripts.

Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual, Visual Studio .NET.

Operating Systems: Windows 8/7/XP, Windows Server 2008/2003/2000.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Excel 2013 for Power Pivots and Power views.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Data Modeling: Visio 2010.

Application Packages: MS Office Suite, MS Outlook.

PROFESSIONAL EXPERIENCE

Axis Capital, GA December ’14 to Till Date

Systems/ Data Analyst

AXIS is a global insurer and reinsurer, providing clients and distribution partners with a broad range of specialized risk transfer products and services in different types of business entities like Axis Insurance, Axis Reinsurance and Accident and Health. As a global insurance provider of insurance it tracks back all the business entities functionalities and the business market strategies based on the available data in the system

Responsibilities/ Roles:

Worked as systems analyst or data analyst.

Worked with business in generating the views (Visualization).

Coordinate with different teams for finding business expected fields (from various sources).

Participated in Creating FDM Framework

Working in agile model, Helping scrum master in getting the stories into rally and defining the stories.

Also performs data analysis on the developed reports and provides acceptance for those stories.

Provided requirements for the development team regarding mappings and views that are to be built.

Provided best business solutions to the clients which helped in getting deep insights the business data.

Created HealthCare data base and here participated in physical and Logical data modelling.

Created the Visio to get a clear picture on business requirement.

Good troubleshooting and analytical skills

Developed Cubes for fast fetching results.

Developed SSIS Packages for pulling the data from source systems along with transformations and making them into facts and dimensions (Data Warehouse) which are required for building cubes (SSAS).

Has worked on designing of SQL-DB (especially star and snowflake) and optimizing the databases.

Created test plans and performed BI testing.

Coordinated with offshore for implementing the business decision into technical solutions.

Part of development team in providing technical solutions.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Provided tabular model/ power BI insights to the business.

Provided linkage solutions for different teams which helped in tracking the system as a whole (in a integrated level).

Developed power views, pivots and reports for business solutions.

Provided mapping specs for ETL packages to move data in between the systems.

Effectively communicated with different system owners in understanding their data flow which in turn helped in analyzing the flow of data between system and ways to integrate the same.

Also provided business solutions for adding some of the key fields in different systems which are helpful in joining the data from different sources.

During analysis came up with new views that will really help the business to look into summary level of the data and also check the issues with the available data.

.

Environment: MS SQL Server 2012/2008R2,Visio, MS SQL Analysis Services 2012, XML, MS Excel, Visual Studio 2008, Windows Server 2003, Oracle, Hive.

Microsoft, WA Dec’13 to Dec’14

Sr.SQL SSIS/SSRS/SSAS Developer

OEM Security & Provisioning also known as OSP is the new OEM platform for Provisioning, authentication and authorization .It replaces the current MSOPS system which is used by existing OEM platforms like MOO & DOC. New OEM platforms/programs like OA3.0 and HAWK will be on boarded to OSP. OSP is also providing new capabilities like authentication and authorization of WCF services as required by the OA3.0 program.

OSP uses CORP STS built on ADFS 2.0 managed by MSIT Infrastructure team for authentication and IT Authorize platform for authorization. OSP is also building the new Provisioning UI in Silverlight for user, company, roles & resource management

.

Responsibilities/ Roles:

Analysis of the requirements provided by the clients and had direct interaction with the Business managers.

Translate business requirements into ETL design specifications.

Having hands on experience in SQL Performance tuning.

IC (Individual Contributor) Role for SQL Database for both onshore and offshore.

Responsible to develop code in an efficient manner

Understanding existing applications functionality.

Created SSIS Packages using SSIS Control flow Tasks, Transformations (Lookup, Derived Columns, Condition Split etc.) in efficient manner within deadlines.

Created SQL Jobs to run SSIS packages on scheduled basis.

Experience in using transformation of Data flow task.

Participated in triage meetings to discuss the status and bugs reported.

Participated in DATA migration testing.

As a part of test team, involve in functional spec walkthroughs, understand functionality

Responsible to create functional, technical specifications.

Understanding applications functionality.

Good troubleshooting and analytical skills

Good interpersonal and Communication skills

Experience in installation, upgrade and configuration of Microsoft SQL Server and Database.

Experience in creating master and child packages, package configurations and logging.

Gathered the business requirements and dealing with the clients on the same.

Experienced in writing functional specifications and Technical specifications documents.

Has worked on designing of SQL-DB (especially star and snowflake) and optimizing the databases.

In SQL DB design worked on Stored Procedures, Functions and T-SQL.

Developed SSIS Packages for pulling the data from source systems along with transformations and making them into facts and dimensions (Data Warehouse) which are required for building cubes (SSAS).

Developed SSRS reports independently and also Reports using Power pivot and power views.

Developed Tabular models with row level security and integrated that to Power pivots and Power Views.

Developed SSAS cubes and tabular models based on the requirements.

Assisted my Team Members in their respective work.

Have come up with some innovative ideas to implement complex things (by reducing re-work).

Participated actively in Defect Fixing (UT/SIT/UAT/Production).

Played an SDET role also has experience in testing like unit testing.

Also worked in different modules and different internal projects involving agile model, Monthly release and Quarterly release.

Good knowledge on SDLC.

Created test plans and performed BI testing.

Mentored the resources to bring up to track on new technologies.

Designed and implemented complex report layouts.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Designed reports based on cube data (MDX).

Design reports that renders based on user, this restriction is implemented using report level, database level and row level securities.

Designed power pivots, power views, power queries and also hosted the same in share point.

Also experienced in scheduling refreshment of power pivots in share point.

Responsible for scheduling the subscription reports with the subscription report wizard. Played a Content Manager role on report server

Designed tabular models to hold data which can be easily used for generating power views.

Implemented row level security in tabular model this deals with restricting data based on user.

Implemented complex calculations in tabular model using DAX.

Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema.

Created roles using SSAS to restrict cube properties.

Created bottom count, top count, cross join, non-ascendants and Parallel Period MDX queries for creating Calculations and KPI’s on a cube.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Created Name to set, filter, ancestors, cross join, dynamic measures and members in MDX queries.

Developed Aggregations, partitions and calculated members for cube as per business requirements.

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: MS SQL Server 2012/2008R2/2005, SQL Server Data Tools, Business Intelligence Development Studio, Visio, MS SQL Integration Services 2012/2008R2, MS SQL Analysis Services 2012/2008R2, SQL server reporting services, MS Excel 2013/2010, Visual Studio 2013,Share point 2010, Power BI tools(Power Pivot, Power Query, Power Views),

Microsoft, WA Feb’13 to Dec’13

Sr.SQL SSIS/SSRS/SSAS Developer

Darwin System is a Microsoft enterprise wide data warehouse used to collect, process, and store the different types of business events from various data sources which are then used by the business for investigation purposes.

Microsoft network is a very vital and critical digital asset and it has to be protected and kept secure. Investigating the business events is a very important activity in protecting its business from malicious users and to protect the users from malicious programs spread through the network. OA data warehouse plays a very crucial role in keeping the Microsoft business tracking and also to conduct effective investigations against malicious users by corroborating with evidence.

It targets on development of reports for clients business analysis. It mainly deals with Major Supply Chain, looking at in and out flow of its products. It targets different level of users who belong to different countries and different levels. This tool supports following business processes:

Future estimations on their products

Analysis of failures and avoiding them.

Analyzing issues with the items sold to the customers.

The scope of market areas for further development.

.

Responsibilities/ Roles:

Gathered the business requirements and dealing with the clients on the same.

Experienced in writing functional specifications and Technical specifications documents.

Has worked on designing of SQL-DB (especially star and snowflake) and optimizing the databases.

In SQL DB design worked on Stored Procedures, Functions and T-SQL.

Developed SSIS Packages for pulling the data from source systems along with transformations and making them into facts and dimensions (Data Warehouse) which are required for building cubes (SSAS).

Developed SSRS reports independently and also Reports using Power pivot and power views.

Developed Tabular models with row level security and integrated that to Power pivots and Power Views.

Developed SSAS cubes and tabular models based on the requirements.

Assisted my Team Members in their respective work.

Have come up with some innovative ideas to implement complex things (by reducing re-work).

Participated actively in Defect Fixing (UT/SIT/UAT/Production).

Played an SDET role also has experience in testing like unit testing.

Also worked in different modules and different internal projects involving agile model, Monthly release and Quarterly release.

Good knowledge on SDLC.

Created test plans and performed BI testing.

Mentored the resources to bring up to track on new technologies.

Designed and implemented complex report layouts.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Designed reports based on cube data (MDX).

Design reports that renders based on user, this restriction is implemented using report level, database level and row level securities.

Designed power pivots, power views, power queries and also hosted the same in share point.

Also experienced in scheduling refreshment of power pivots in share point.

Responsible for scheduling the subscription reports with the subscription report wizard. Played a Content Manager role on report server

Designed tabular models to hold data which can be easily used for generating power views.

Implemented row level security in tabular model this deals with restricting data based on user.

Implemented complex calculations in tabular model using DAX.

Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema.

Created roles using SSAS to restrict cube properties.

Created bottom count, top count, cross join, non-ascendants and Parallel Period MDX queries for creating Calculations and KPI’s on a cube.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Created Name to set, filter, ancestors, cross join, dynamic measures and members in MDX queries.

Developed Aggregations, partitions and calculated members for cube as per business requirements.

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Designed Multi-Dimensional models, DATA MART/ WAREHOUSES and SSAS cubes

Developed custom reports using SSRS/SQL Server BI studio.

Created custom and Ad hoc reports using SSRS.

Created reports that call Sub reports in SSRS.

Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server 2012/2008.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012/2008 and in adding calculations using MDX.

Identified and defined Fact relationships in SSAS.

Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.

Responsible for maintaining cubes using SSAS and populate the cubes with the data.

Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.

Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.

Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.

Created different measure groups and calculations using SSAS.

Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Responsible for maintaining and tuning existing cubes using SSAS.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.

Environment: MS SQL Server 2012/2008R2/2005, SQL Server Data Tools, Business Intelligence Development Studio, Visio, MS SQL Analysis Services 2012/2008R2, SQL server reporting services, MS Excel 2013/2010, Visual Studio 2013,Share point 2010, Power BI tools(Power Pivot, Power Query, Power Views)

Microsoft, WA Aug’08 to Jan’13

SQL SSAS/SSRS Developer

MSCert is a suite of applications supporting the MSLearning Certification Business. It is also known as Credential Management and comprises of 4 sub-systems like Secure Sites (Candidate portal), Candidate Manager Tool (CSR tool), EDPs (Exam delivery Partners - VUE, Prometric, ATA, CertiPort), Fulfillment Vendors (Welcome Kits). MSCert is having External Dependencies on Vellum Service, MS-Individual API, OM (Order management). In

MSCert there are primarily 8 databases like MSCert, MSCertImportExport, CDS, ECMail, ProfileSynch, MSCertMart, ILRStaging, and ILRReporting

Responsibilities/ Roles:

Developed Web pages (ASP.NET), data warehousing (SSIS) and SSRS reports independently.

Assisted Team Members in their respective work.

Have come up with new ideas to implement complex things (by reducing re-work).

Participated in actively in Defect Fixing (UT/ST/UAT/Production).

Developed query for generating drill down and drill through reports in SSRS 2008R2/2008.

Identified and worked with Parameters for parameterized reports in SSRS 2008R2/2008.

Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.

Developed reports using SSRS 2008R2/2008. Used table control, matrix control for cross tab reports.

Worked Extensively on ETL process using SSIS packages.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.

Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008R2/2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.

Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Created DTSX packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

Involved in extracting the data using SSIS from OLTP to OLAP.

Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.

Experience in migrating some of the DTS packages in to SSIS.

Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.

Assisted with various ad hoc query requests.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages

Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012/2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Configured SSIS packages using Package configuration wizard to allow package run on different environments.

Efficiently implemented Error handling in SSIS.

Created SSIS packages to load data from various data sources Oracle,DB2 and Flat files

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Environment: Analysis Services (SSAS), Reporting Services (SSRS



Contact this candidate