We provide IT Staff Augmentation Services!

Bi Developer (sql Server Ssis/ssrs Developer) Resume

SUMMARY

  • Certified Microsoft BI developer with over 4+ years of experience in using the Microsoft Soft SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Gathered business requirements, definition and design of data source and data flows.
  • Full Software Development Life Cycle (SDLC) experience including Requirement Gathering, Analysis, Design, Development, Testing, and Implementation of various medium and large scale client/server applications in a structured development environment.
  • Participated in AGILE iterative development methodology.
  • Experience in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
  • Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, data conversion, derived columns, conditional split, data conversion with multiple data flow tasks.
  • Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL/Package, script tasks, send mail and file system.
  • Scheduled jobs for executing the stored SSIS package which were developed to update the database on Daily basis using SQL Server Agent.
  • Experienced in handling Slowly Changing Dimensions while loading data into data warehouse.
  • Trained in Power BI reporting tool.
  • Created SSRS report projects in BI Visual studio and created, modified and managed various report models with multiple objects, source fields and expressions.
  • Experienced in creating parameterized reports, drill down reports, drill through reports and sub reports
  • Created Dashboards, Tabular, Matrix reports, Charts and graphs as per customer requirements, using SSRS.
  • Processed and generated reports for the end business users on a daily, weekly, and monthly basis.
  • Wrote SQL queries and stored procedures to generate data for reports.
  • Configured and administered report manager, created item level securities, group permissions in SQL Server Reporting Services.
  • Proficient with data warehouse structures staging, facts, dimensions, aggregate tables, dimensional modeling, Star/Snowflake schemas and maintaining data integrity
  • Developed Multi - dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
  • Ability to prioritize multiple tasks. Excellent communication skills, proactive, self managing and teamwork spirit, goal-oriented, highly motivated with excellent analytical, troubleshooting, and problem-solving skills

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/XP/Vista, Windows 7/8/10

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer

BI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2010,2015

Languages: T-SQL

ETL Tools: SQL Server Integration Services(SSIS), DTS, SQL Server Import/Export Wizard

Source Control Tools: Visual Source Safe (VSS), Team Foundation Server 2010 (TFS)

OLAP Tools: SSAS, SSRS

Report Tools: SQL Server Reporting Services (SSRS)

Data Modeling: SQL Server Analysis Services (SSAS)

Job Scheduler: SQL Server Agent

Office Tools: MS Word, PowerPoint, MS Excel

PROFESSIONAL EXPERIENCE

Confidential

BI Developer (SQL Server SSIS/SSRS Developer)

Responsibilities:

  • Gathered business requirements, definition and design of data source and data flows.
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
  • Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
  • Designed SQL database with control and audit schema tables to maintain historical data and error handling.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
  • Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service(SSIS).
  • Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports
  • Designed and develop Dashboards and Reports using SSRS.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS)
  • Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.

Environment: SQL Server 2012/2016, SSIS, SSRS, BIDS, Excel, Notepad++, XML

Confide

BI Developer

Responsibilities:

  • Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.
  • Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting
  • Performed capacity planning and growth prediction for client audit data
  • Query tuning based on query execution plans, statistics, and profiling
  • Created code based solution for application error involving composite key manipulation
  • Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning
  • Worked with development teams in the design of physical databases and in modification.
  • Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
  • Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
  • Proficient in SSIS process design architecting the flow of data from various sources to target.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
  • Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
  • Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance XML schemas to update user tables and system objects for company data dictionary
  • Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements
  • Served as a team member 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.

Environment: SQL Server 20012/2016, Visual studio 2012/2015,SSIS,SSRS.

Hire Now