Sql Server Bi/ Power Bi Developer Resume
Marietta, GA
SUMMARY
- Over 9 years of extensive work experience in Data Warehouse, Data mart, ETL, MS SQL Server
- Development (DTS/SSIS, SSRS, SSAS), Development & Support of MS SQL Servers 2012/2010/2008/2005. Expert in ETL, Data warehousing and OLAP
- Expertise in Power BI, Power BI Pro, and Power BI Mobile .
- Expertise in Writing complex DAX functions in Power BI and Power Pivot .
- Experience installing, configuring enterprise gateway & personal gateway in Power BI Service
- Well versed in calculated columns, measure queries in Power BI desktop .
- Good knowledge on all types of transformations available in Power BI query editor.
- Expertise in MS SQL Server environments using complex SQL, T - SQL, PL/SQL, Stored Procedures, Functions, Views, Triggers, Indexes and Performance Tuning.
- Extensive experience in MS SQL Server 2008/2010/2012 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS).
- Expert in creating SSIS packages including using script transformations using VBScript.
- Transformed data from various data sources like access, excel, flat file using OLE DB connection by creating various SSIS Packages.
- Expert in preparing ETL mapping process and maintaining mapping documents.
- Extensive development experience using SSRS, SSIS, Microsoft DTS.
- Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
- Strong Object Oriented Analysis, designing and programming technical skills, ability to learn new emerging technologies and adapt quickly.
- Expertise in developing advanced SSRS reports with functions, formulae, parameterized, Sub Reports, Cross Tab reports, OLAP reports, Drill Down reports, summary reports, ranking, statistical functions and scheduling using custom tool/Enterprise server.
- Analyzed customer needs in order to generate reports using SSRS output formats as required (eg: XML, PDF, Excel, Web etc.)
- Very Good Knowledge on Data Warehouse concepts, Experienced on Different ETL Tools like SSIS and DTS..
- Expert in using SQL Server Agent to Schedule the SSIS Packages and SSRS Reports.
- Experience with T-SQL for developing stored procedures in SQL Server 2000/2005/2008/2012.
- Created numerous SQL reports for users and familiar with various types of stored procedures, views, joins, union, intersect, sub queries, alias, formatting etc.
- Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
- Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
- Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and flat-files etc.
TECHNICAL SKILLS
Operating System: Windows 95/98/2000/NT/XPLanguages: SQL, T-SQL, PL/SQL, C, C#, VB.Net, Unix and Shell Script
RDBMS: MS SQL Server 2000/2005/2008/2010/2012 , MS Access, MySQL Sybase, Teradata, DB2, Oracle 7X/8i/9i/11g
Database Tools: Oracle SQL Developer, TOAD
Reporting Tools: Power BI, SSRS, Data Reports, Development Studio .
ETL Tool: Power Query, SSIS, DTS.
Analytical Tool: Power Pivot, SSAS
Version Tools: VSS, Clear case
Server Technology: IIS Server 4.0/5.0, PWS, MTS, Windows NT, Tomcat 5.0.19, Win XP.
PROFESSIONAL EXPERIENCE
Confidential, Marietta, GA
SQL Server BI/ Power BI Developer
Responsibilities:
- Created and supported the existing SSIS and DTS Packages.
- Created and Modified the Stored Procedures and views for the existing ETL process, application and reporting system according to new business rules.
- Created and modified the web application enhancements.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards .
- Provided analytical, complex and specialized client service analysis using Power BI dashboards.
- Used SSRS and MS Power BI to create customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Utilized Power B I to design multiple scorecards and dashboards to display information required by different departments and management.
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
- Involved in Application, ETL and Reports maintenance.
- Worked on existing SSIS to improve the performance.
- Scheduled SSIS packages through SQL Agent Jobs with configuration file.
- Involved in Testing SSIS load process.
- Worked on Extracting, Transforming and Loading (ETL tools) using SSIS, Bulk Insert, BCP, DTS Packages and SSIS packages.
- Deployed SSIS, DTS and Reports into Production environment.
- Designed, Developed and Deployed SSIS Packages and SSRS Reports.
- Monitoring the daily, weekly and monthly scheduled Packages.
- Moved the packages and configuration files from development to QA and Production.
- Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
Environment: Power BI, T-SQL, SSMS, SSIS, SSRS, SQL Server 2010/2012, Oracle SQL Developer
Confidential, St.Louis, MO
MS SQL Server SSRS/ETL Developer
Responsibilities:
- Involved in validating the incoming data to see for errors in the files.
- Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from Legacy Systems and transform and store in the Staging tables
- Involved in mapping the Legacy Accounting events to Standard Banking Accounting
- Involved in importing the data from Staging tables to the Banking System.
- Developed packages to process the data files in sequential order.
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
- Different dashboard reports developed by using Bar Chart, Pie Chart, Line Chart and Gauge charts and also used coding for color generation.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS .
- Experience in moving data from heterogeneous data sources like oracle, xml etc to Sql using SSIS.
- Created SSIS packages to improve the performance of Dashboard reports.
- Developed Drill Down and Drill through reports.
- Worked with Report Subscriptions to schedule reports and to generate the report PDF formats.
- Involved in final testing to check the expected values with the clients.
- Moved the agency from development to Production after verifying the data in Banking System.
Environment: T-SQL, SSMS, SSIS, SSRS, SQL Server 2010, Windows .
Confidential, Atlanta, GA
MS SQL Server/SSIS/SSRS/ETL Developer
Responsibilities:
- Supporting the existing system and also involved in converting the DTS packages & Informatica Jobs into SSIS Packages .
- Used different transformations and expressions in SSIS to load CNI (News Paper) data from flat file source system to SQL Server.
- Moved the packages and configuration files from development to QA, UAT and Production. Scheduled SSIS packages through SQL Agent Jobs with configuration file. Involved in Testing SSIS load process .
- Designed, Developed and Deployed SSIS Packages and SSRS Reports .
- Responsible for ongoing maintenance and change management to existing SSIS packages and SSRS reports.
- Performed Report Testing and Verification as per Internal Reporting system requirement
- Different reports developed by using existing Table, Matrix controls, Chart and also used formulas, functional coding.
- Developed Report Models for Ad-hoc Reporting.
- Worked with Report Manager and Report Server to run, schedule, deploy and organized the reports.
- Involved in final testing to check the expected values with the clients.
- Provided Documentation support on SSIS, SSRS 2008 as assigned.
Environment: Windows, T-SQL, SSMS, SSIS, SSRS, SSAS, DTS and SQL Server 2000/2008.
Confidential, Dallas, TX
SQL Server Developer
Responsibilities:
- Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
- Involved in portions of the analysis phase of the application development cycle.
- Implemented and managed database backup and recovery strategies
- Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
- Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
- Generated test data and tested database to meet the functionalities deliverables in the project
- Generated database SQL scripts and deployed databases including installation and configuration
- Creating tables, relationships, triggers and indexes for enforcing business rules
- Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
- Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
- Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS .
- Enhancing and deploying the SSIS Packages from development server to production server.
- Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
- Played a major role in the production support SSIS jobs.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, ProClarity Server, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle.