SUMMARY:

• 5+ years of experience in IT industry as a Microsoft Certified Business Intelligence Developer
• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R 2/2012/2014/2016 , SSIS, SSAS and SSRS.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform
• Strong proficiency in the use of T - SQL for developing complex stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Proficient with data warehouse structures staging, facts, dimensions, aggregate tables, dimensional modeling, Star/Snowflake schemas and maintaining data integrity.
• Involved in Transformation and Loading (SSIS), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.
• Understand and experience working with cloud infrastructure services like Microsoft Azure Storage, Cloud/On-Premises Database, Azure Data Lake, Azure Data Factory.
• Experience and working knowledge of DAX, Power BI report and Dashboards.

TECHNICAL SKILLS:

DBMS/RDBMS: MS-SQL, 2012, 2008R2,

ETL: SQL Server Integration Services(SSIS), SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS), Power BI, Azure

Data Modeling: SQL Server Analysis Services (SSAS), database and data warehousing concepts (OLTP & OLAP

Languages: T-SQL, C#, VB

BI Tools: SQL Server Management Studio (SSMS), Data Tools (previously BIDS), Microsoft Azure Storage, Cloud/On-Premises Database, Azure Data Lake, Azure Data Factory.

Office Tools: MS Word, PowerPoint, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

• Participate in business analysis activities to gather required reporting and dashboard requirements
• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources
• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users
• Ensure proper configuration management and change controls are implemented for your sphere of influence
• Provide training and assistance to users for generation of adhoc reports
• Design and implement technology best practices, guidelines and repeatable processes
• Perform duties with moderate to low supervision
• Participate in Agile/Scrum ceremonies

Confidential, Elkhorn, NE

SQL Server SSIS/SSRS/SSAS ETL DEVELOPER

RESPONSIBILITIES:

• Migrated data from SQL Server 2008 to the SQL Server 2012 using SSIS as ETL tool.
• Involved with direct discussion with business units and other source systems teams, creation, migration, and decommission and redesigning the project.
• Collected business requirements from cash operations and translated them as technical specifications and design documents for development.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Involved in creating C# scripts using script task in SSIS
• Build the customized SSIS packages using C# script Tasks and components.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules.
• Interacted with Program Managers and Test Engineers to contribute and Review Functional Specifications and Test Cases.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2008) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Database and data warehousing concepts (OLTP & OLAP
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow Tasks.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008/2012.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and deployed on report server.
• Deployed the SQL Server 2008/2012/2014/2016 R2 SSIS packages.

Environment: MS SQL Server 2008/2012, Business Intelligence Development studio (SSRS/ SSAS/SSIS), MS Office Access 2003 and Visual Studio 2012/2015.

Confidential, Omaha, NE

SQL server SSIS/SSRS/SSAS Developer

RESPONSIBILITIES:

• Analyze channel performance, design and execute experiments, research, financial models and other mechanisms to identify, evaluate and prioritize opportunities.
• Identify key metrics and build exec-facing dashboards to track progress of the business and its highest priority initiatives using SSIS/SSRS/SSAS
• Work closely across the matrix with teams like Finance, Marketing, Product, Engineering and senior executives for trend analysis
• Build weekly metrics and reporting to track portfolio progress and help ensure quarterly goals will be met
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Used Notification Services Available in SQL Server 2008 to create alerts and email notification.
• Helped Development Team in deploying and testing the application, which uses SQL Server 20012 backend.
• Created automated stored procedures for day end operations using SQL Server agent.
• Developed reports using complex TSQL queries, User Defined Functions’, store procedures and views.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services(SSIS).
• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs.
• Extracted data from various sources like SQL server 2005/2008/2012 , CSV, Excel and text file from Client servers and through FTP.

Environment: MS SQL Server 2005/2008/2008 R2/2012, Business Intelligence Development studio (SSIS/SSRS/SSAS), MS Office Access 2003 and Visual Studio 2008/2015