We provide IT Staff Augmentation Services!

Sr. Etl Msbi Developer Resume

Lake Forest, IL

SUMMARY

  • Around 9 years of IT experience as MS SQL Server Developer 2012/2008 R 2/2008/2005/2000 in various Industry verticals like Insurance, Airlines, Telecommunication, Pharmaceutical, Retail and Bank.
  • Extensive experience with different phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
  • Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
  • Extensiveexperiencein writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
  • Experience in developing and monitoring SQL Server Integration Services (SSIS) Packages and Data Transformation Services (DTS).
  • Excellent knowledge in Creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, SQL Joins, Query Writing, Data Dictionaries, Data Integrity, Cursors and Indexes using T-SQL.
  • Major experience in Data Warehousing and SSIS Packages along with SQL Programming.
  • Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
  • Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
  • Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2005/2008).
  • Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
  • Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access and designed data conversions from wide variety of source system.
  • Experience in creating SSIS packages using Active X scripts and with Error Handling.
  • Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005 .Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
  • Expert in creating packages, Jobs, Sending Alerts using SQL Mail. Experience in SQL Server Analysis Services (SSAS) OLAP Cubes and Data Mining, SSAS 6.5/ 7.0/ 2000/ 2005/ 2008/2008 R2/2012.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0,Perl,CSS, HTML, XML, MHTML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), SSAS(SQL Server Analysis Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program

Other Software: MS Office- 2007/2003/2000 , Adobe Professional, SharePoint

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

Database Tools: SQL Query Analyzer, SWIFT Tool, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

Sr. ETL MSBI Developer

Responsibilities:

  • Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
  • Design and tune ETL process. Working closely with the Guideware team on business aspects.
  • Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Configured files to deploy the SSIS packages across all environments.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
  • Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
  • Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
  • Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Environment: MS SQL Server 2008/2012, Red Confidential tools, Power Pivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio

Confidential, Phoenix, AZ

Sr. MS BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
  • Migrating Databases from SQL Server 2008 to SQL Server 2012.
  • Planned, defined and designed data based on the business requirement. Creating dashboard, scorecards using performance point server according to client requirements.
  • Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
  • Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Designed logical/physical data models using Erwin tool 8.0.Uses of power pivot.
  • Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.

Environment: MS SQL Server 2012/2008, Enterprise Edition, Bamboo, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007, Erwin 8.0

Confidential, Irvine, CA

MS BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Designed and developed SQL Server Reporting Services (SSRS) SQL Server 2005/2008.
  • Involved in Report writing according to business requirement using SSRS and Crystal Reports.
  • Generated database monitering and data validation reports in SSRS.
  • Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Sub reports, Adhoc reports (SSRS).
  • Deployed SSRS Reports in SharePoint for web based access for multiple end users.
  • Configure the report server and generated the report models for user interactions.
  • Involved in Partition of cubes in order to increase the performance of cubes.
  • Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
  • Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
  • Used windows Power Shell Script to automate application deployment process.
  • Generated dynamic stored procedures, triggers, Cursors, Joins for the database development.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Used Informatica to Extract and load the Data as per the requirement.
  • Interacting with Business users and BA’s to gather requirements for creating ETL Packages and Reports.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
  • Creating SSIS Packages using different type’s task and with Error Handling.
  • Fine tuned the complex database stored procedures to increase performance.
  • Performance tuning and optimization of procedures and queries.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
  • Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
  • Successfully deployed reports in various sources like XML, Web browser and PDF.
  • Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
  • Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
  • Created SQL Server Profiler traces and used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
  • Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Created Analytical reports by ProClarity tool.
  • Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
  • Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
  • Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2005/2008, Management Studio(SSMS), ETL, DTS, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX, Share point (2003/2007), Asp.Net, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS 2005/2008, community server, Erwin

Confidential, Chicago, IL

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
  • Performed Migration of data from SQL Server 2005 to 2008.
  • Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
  • Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
  • Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
  • Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Created report in SQL Server 2005 and deployed them on local-host for remote access.
  • Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
  • Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
  • Ran DBCC and fixed data corruption in application databases.
  • Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008/2005,, SSIS 2008, SSRS 2008, SSAS 2008, Power pivot, Visual Studio 2008, T- SQL, Visual Source Safe 2008 (VSS), XML, ADO.NET, ERWIN 7.1, PL/SQL, MS-Access, MS-Excel

Confidential, Portland, OR

SQL Server Developer

Responsibilities:

  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
  • Created User Defined Functions, Stored Procedures, and Triggers.
  • Designed and created SQL Databases, tables, indexes, and views based on user requirements.
  • Create joins and sub-queries for complex queries involving multiple tables
  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
  • Created data loads and Upgrade scripts for data migrations and validations
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
  • Have deployed packages on different servers by configuring it.
  • Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
  • Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
  • Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
  • Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
  • Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Generate various ad hoc reports using MS Reporting services.
  • Created various Weekly and Monthly reports showing detailed information.

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in different stages of Project Life Cycle.
  • Created new Databases, tables, established relationship among tables in a database.
  • Created stored procedures and functions to support efficient data storage and manipulation.
  • Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
  • Defined Constraints, Indexes.
  • Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Scheduled Jobs using SQL Server Agent.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
  • Designed and implemented several complex reports.
  • Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
  • Created different user level groups, and assigned appropriate permission level to the database.
  • Preparation of project documentation.

Environment: SQL Server 2000/2005, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server

Hire Now