Bi Dveloper Resume
4.00/5 (Submit Your Rating)
IL
SUMMARY
- I is a competent and detail oriented BI Data Analyst wif 6 plus years of work experience in Microsoft technologies such as SSIS, SSAS, SSRS, Power BI, EXCEL and Microsoft SQL Server
- Working experience in Data Analysis, Data Conversion, Data Quality, Data Integration, Data Visualization, developing and updating data ware house, Managing SQL Server objects.
- Experience in creating SSIS packages for data migration and building Enterprise level dashboards in Power BI for Data Analytics.
- Having 3+ Years of experience on Microsoft BI Technologies (SSIS, SSRS, and SSAS).
- Around 3 Years of experience on SQL database development.
- Implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Financial, Insurance, Sales and Health domain. Experience in Data Warehousing & Business
- Intelligence life cycle in design, developing, testing and implementation. And SQL developer and SQLDBA.
- ETL Development using SSIS.
- Authoring of Reports, KPIs and Dashboards using SSRS.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2005 (SSAS).
- Build and deployment of BI solution.
- Experience in creating jobs, and schedule SSIS Packages using SQL Server Agent. Good in troubleshooting SQL job failures.
- Sound Experience in writing Stored Procedures.
- Strong experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Aggregator, Joiner, Update Strategy etc.
- Proficient in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLEDB connection from heterogeneous sources like (Excel, CSV, ARCOS, Oracle, flat file, Text Format
- Data) by using multiple transformations.
- Provided by SSIS such as Data Conversion, Derived Column, SCD, Conditional Split, and Look Up, Bulk Insert, Merge, And Union All etc.
- Experienced in creating Tables, Stored Procedures, and Views, Indexes, Cursors, Triggers and complex queries using T - SQL in SQL Server 2014/2010.
- Involved in the Development of different mappings and tuned for better performance.
- Experience in DWH MSBI end to end Testing.
- Knowledge in OLTP, OLAP, Dimensional Data Modeling Concepts, Star and Snowflake schema design and data warehousing methodologies.
- Extensive experience in Installation, Configuration, Updates, Backups and Restore of SQL Server
- Analysis of Business Specification document /Source map document for creating packages and Reports.
- Performed Unit testing and validated the data.
- Involved in the Requirement gathering from the business users.
- Interacted wif Architect to understand the High level Design.
- Expertise in data analysis for different domains.
- Experience in Unit Testing and UAT.
- Experience in various domains like Insurance, Healthcare, Banking and Retail industries.
- Experience wif Waterfall and SCRUM process (Agile Methodology).
- Design, develop and maintain web-based business process and database applications.
- Tuned and optimized queries by analyzing different query options and indexing strategies.
- Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Involved in ETL process from development to testing and production environments.
TECHNICAL SKILLS
BI tools: SRRS 2014, SSAS 2014
ETL: SSIS 2014/2010
Modeling Tools: Microsoft Visio
Database: SQL Server 2014/2012
Concepts: Data Warehousing, Relational & Dimensional Modeling
Operating Systems: Windows 10, UNIX
Reporting Tools: Excel Reporting, Microsoft Power BI, Tableau 10.4
Office Applications: MS Outlook, MS Project 2013, MS Excel, MS Office, MS Access
Programming Languages: SQL (SQL Server 2014 Management Studio), Python 3.6.2
Methodologies: Waterfall model, Agile, SDLC
PROFESSIONAL EXPERIENCE
BI Dveloper
Confidential, IL
Responsibilities:
- Design, build, deploy and debug of ETL's.
- Managing team for resolving production tickets and responsible for operational
- KPI’s for data integrity, security and availability.
- Extracted and Loaded data into SQL Server Database using SSIS for exporting data from flat file source to SQL Server database.
- Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Restricted data for particular users using Row level security and User filters.
- Developed Tableau visualizations and dashboards using Tableau Desktop.
- Developed Tableau workbooks from multiple data sources using Data Blending.
- Provided 24/7-production support for Tableau users
BI Developer
Confidential
Responsibilities:
- Designing Reports using SQL Server Reporting Services.
- Daily ETL overnight jobs monitoring and support.
- Developing SSIS package and creating job to run on quarterly basis.
- Create interactive visualization reports and dashboards wif visual analytics on Power BI Desktop/Service dat help clients to find answers for most important questions in the data.
- Actively collaborate wif the team for Development, Optimize, Maintenance of data quality in the SQL databases.
- Data extraction & transformation, Data Analysis and Data Modeling using SQL queries to develop interactive Power BI dashboards and parameterized SSRS reports.
SQL Developer
Confidential
Responsibilities:
- Developing Procedures, views and functions.
- Analyze code for problem resolution and performance optimizations.
- Provide technical support to application development teams.
- Designing Reports using SQL Server 2005 Reporting Services.
- Responsible for preparing SQL Scripts.
- Auto updates data by weekly.
- Developing stored procedures.
- Responsible for preparing SQL Scripts and updating in both develop and production environment.
- Frequently interact wif Client to meet his requirement.
