Msbi Developer resume example with 7+ years of experience
JessicaClaire
, , 100 Montgomery St. 10th Floor(555) 432-1000, resumesample@example.com
Professional Summary
Over 7 years of Information Technology experience in all phases of Software development life cycle including Database administration, ETL, Data Analysis and Business Intelligence.
Meet with customer business and technical leaders to identify and scope the business opportunities.
Interacted with Business Users for gathering the Reports/Dashboards requirements.
Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services and MS SQL Server Reporting Services (SSRS).
Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T-SQL.
Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions.
Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and agile methodology.
Strong experience in design and developing ETL using SQL Server Integration Services (SSIS).
Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
Design and implement end-to-end data solution (storage, integration, processing, and visualization) in Microsoft Azure.
Azure Data Factory (ADF), Integration Run Time (IR), File System Ingestion, Relational Data Ingestion.
Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server.
Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services.
Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients and Power BI for executives and managers.
Experienced in supporting 24/7 production computing environments, on-call, and weekend support
ETL TOOLS: SQL Server Integration Services (SSIS), Data
Transformation Azure data factory.
Reporting Tools: SQL Server Reporting Services (SSRS),
Crystal reports, Tableau, Power BI.
Database Query Tools: SQL Server Management Studio (SSMS),
Business Intelligence Development Studio
(BIDS), Visual Studio 2013/2015/2017,
SQL Profiler, DQS.
Configuration Management Tools: JIRA, Team Foundation Server, Service Now
(TFS) 2012/2010/2008, GitHub
Third party tools: Tidal, Avaya, and windows Application server
Work History
10/2021 to CurrentMSBI DeveloperCognizant Technology Solutions | Mooresville, NC,
Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the reporting needs
Transformed data from various data sources using OLE DB connection by creating various DTS packages & SSIS Packages
Responsible for implement Unit testing and performance improvement purposes
Scheduled reports to run daily, weekly and monthly based on the requirement Report Manager
Working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc
Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS
Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients
Responsible for scheduling SSIS jobs to automate the processes using SQL Server Agent
Responsible for extracting and loading client historical data from source to SQL environment for performing various business operations using SSIS
Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, and SQL server using SSIS
Generated test data and tested new database consistency with existing databases
Refreshed and republish reports and datasets manually and created ad-hoc reports as per need
Worked on knowledge transfer and documentation of various jobs developed and deployed into Lower environment
Scheduled frequency and time to refresh data for the data sources
Extract data from different sources RDBMS and CSV through Power BI
Scheduled data refresh on for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
08/2020 to 10/2021SQL DeveloperComputer Aid | Lakeland, FL,
Worked with senior management team and operation-level managers to gather requirements
Involved in data migration SAS to SQL/extraction from Flat files, Oracle, Teradata and SAS datasets
Performed edit checks, helped cleaning and validation the data sets using SAS
Import and exported SAS data
Produced safety and efficacy reports by using different statistical procedures
Created SAS data sets by extracting data oracle databases and flat files using PROC SQL, PROC import, and SAS Data Step
Strong experience in Analysis, Design, development, and implementation of end-to-end Business intelligence
Analyzed existing SQL queries to identify opportunities for improvements
Developed ETL framework for processing and monitoring import of flat files in SSIS for key client
Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using Microsoft SSIS and/or Azure cloud technology
Developed, implemented and optimized stored procedures and functions using T-SQL
Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS
Responsible for Scheduling reports to run daily, weekly and monthly basis using SSRS Report Manager
Developed custom database objects, stored procedures and delivered application support
Designed and implemented TSQL queries for reporting and complex solution development
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment
Designed and developed customized extract, transform and load (ETL) applications per client specifications
Reviewed and interpreted business report requirements to address user needs
Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements
Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback
Generated, debugged and enhanced existing reports with introduction of new system features
Proved successful working within tight deadlines and fast-paced atmosphere
Developed and maintained courteous and effective working relationships
Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
09/2017 to 07/2020SQL DeveloperComputer Aid | Long Beach, CA,
Worked with senior management team and operation-level managers to gather requirements
Wrote and optimized SQL statements to assist business intelligence practices
Responsible for creating and managing various database objects such as tables, stored procedures, views, Triggers, and Database Constraints to meet business requirements
Involved in Interacting with the user for gathering business requirements and resolving the claims for the client accounts
Responsible for making an analysis of transactions of the client and determining solution for settlement of the client account
Proficient in coding of optimized Teradata batch processing scripts for data transformation and aggregation
Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines
Responsible for extracting and loading client historical data from source to SQL environment for performing various business operations using SSIS
Responsible for scheduling SSIS jobs to automate the processes using SQL Server Agent
Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server
Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Checkpoints, Transactions and package configurations
Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle
Experience in creating Multidimensional cubes using SSAS and designing DW schemas
Experience in creating SSRS reports using pie charts, bars etc
For business analysis purpose
Experience in writing Excel macros using vb script to format the excel report
Responsible for designing, development and deployment of SSRS reports using SSRS report designer
Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2, Azure-SSIS IR
Responsible in Designing and developing Tabular Report, Parameterized and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of SSRS
Responsible for Scheduling reports to run daily, weekly and monthly basis using SSRS Report Manager
Defined security models with row level data security, role-based security etc
In Business Objects Universes and Central Management Console (CMC)
Responsible for creating complex Cross tab, OLAP Cube report using Crystal Reports integrated with SSMS
Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis
Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements
Involved in monitoring, trouble shooting performance tuning of databases to support production environment in 24/7 on-call rotation
Responsible for creating and maintaining high-level design documentation considering future changes
Demonstrated respect, friendliness and willingness to help wherever needed.
08/2014 to 08/2017MSBI DeveloperCognizant Technology Solutions | Neenah, WI,
Gathered requirements to determine necessary hardware configurations for planned software
Involved as a team member for requirement analysis in design phase of the Project
Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs
Experience in handling Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS
Experience in working with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task
Experience in working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc
Deployed different SSIS packages on development and test environments
Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads
Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010
Involved in development and deployment of the Cube
Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS
Scheduled reports to run daily, weekly and monthly based on the requirement Report Manager
Defined Report Layouts for formatting the report design as per the need
Generated test data and tested new database consistency with existing databases
Maintained existing applications and designed and delivered new applications
Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent
Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
Education
Expected in B.S | Management Information SystemsUnity University College, Addis, AbabaGPA:
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.