LiveCareer-Resume

Msbi Developer resume example with 7+ years of experience

JC
Jessica Claire
, , 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
Skills
  • TECHNICAL SKILLS:
  • Operating Systems: Windows2010, 2008, 2007, 2003R2, 2003,
  • 2000Advanced Server, Windows NT, UNIX.
  • Databases: MSSQL SERVER 2016/2014/2012/2008R2/
  • 2008, Teradata, SharePoint 2013/2010/2007,
  • Oracle SQL
  • Server 9i/10g/11g, Azure SQL databases.
  • 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 Current MSBI Developer Cognizant 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/2021 SQL Developer Computer 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/2020 SQL Developer Computer 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/2017 MSBI Developer Cognizant 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 Systems Unity University College, Addis, Ababa GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

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.

Resume Overview

School Attended

  • Unity University College

Job Titles Held:

  • MSBI Developer
  • SQL Developer
  • SQL Developer
  • MSBI Developer

Degrees

  • B.S

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: