We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Baltimore, MD

SUMMARY:

  • Holding over 11+ Year of professional IT experience in all the aspects of Business intelligence Leveraging Tableau applications and Power BI with a strong background in Database developoment and expertise in full life cycle development including planing, analysis, design, Implementation and maintenance using BI tools.
  • Extensive knowledge in software development life cycle (SDLC) and project management methodologies.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Indexes using T - SQL.
  • Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
  • Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, and BCP & Bulk Insert utilities.
  • Hands on experience in creating solution driven dashboards by developing different chart types including crosstab, heat/geo/tree maps, pie/bar charts, circle views, line/area charts, scatter plots, bullet grephs and histograms in tableau desktop
  • Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
  • Proficient in designing and handling sql databases, DB tables, views, store procedures, functions, triggers, CTE’s to assist efficient data manipulation and data consistency and used DDL and DML commands for various business application.
  • Experienced in reporting services, power BI, crystal reports using MS SQL server and in supporting services MDX technology of the analysis services.
  • Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement.
  • Experienced in data warehousing concepts like star schema’s, snow flake schema’s, normalization, de-normalization, relational data structure, non-relational data structure.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
  • Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
  • Published reports to Azure-based power BI services(pro) and schedule subscription and expert in creating, configuring and fine-tuning SSIS packages, SSRS reports and T-SQL queries using SQL profilier monitoring tool.
  • Proficient in Data warehousing and SSAS skills: MDDB/MDX, KPIs, Calculated Members, OLTP, OLAP (MOLAP, HOLAP, and ROLAP), Relational and Dimensional Modeling skills (star schema and snowflake schema).
  • Experienced in working with Iterative Agile Programming Methodologies, Waterfall methodologies, Scrum and Test-driven development (TDD).
  • Expertise in generating reports using linked reports, sub reports and filters, chart in SQL server reporting services.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore MD

SQL BI Developer

Responsibilities:

  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
  • Createdcomplex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.
  • Worked on ECPS(Engineering Change Proposal) given by the government to Maintain Their Website MCRISS(MARINE CORPS RECRUITING INFORMATION SUPPORT SYSTEM).
  • Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
  • Conceptualized and Designed Logical and Physical Data Models using Erwin.
  • Worked as T-SQL developer in creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications.
  • Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling &Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
  • Designed, developed, tested and implemented ETL jobs in InfoSphere DataStage in all environments.
  • Creating Clustered and Non-Clustered indexes on tables for faster query retrieval. Also, fine tuning existing indexes.
  • Strong Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
  • Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
  • Created logging, custom logging and error handling SSIS packages. sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
  • Created and Executed Stored Procedures and Complex Queries for Reports.
  • Modifiedthe existing SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files according to the requirement specifications.
  • Created roles using SSAS to restrict cube properties.
  • Used Microsoft Power BI Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Workedon both live and import data to Power BI for creating reports.
  • Expertisein publishing Power bI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power bi server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
  • Administered Power BI Create, customize & share interactive web dashboards in minutes with simple drag & drop.
  • Involved in gathering client requirement and developed Power BI reports based on user defined ad hoc user Interface for end users.
  • Documented All MSSQL database structures and functionalities. Worked with Auditors and Provided Database related documents.
  • Involved in creating SSRS and power view reports.
  • Created user defined functions for generic use.

Technologies & Tools: Microsoft Visual Studio, Microsoft SQL Server 22016, Server Integration Services 2012, SQL server Reporting Service 2012, Server Analysis Services 2012, XML, GitHub, Excel, SSDT, Windows Server, RDBMS, Windows XP, PL/SQL, Microsoft VSTS 2012, Windows7,10.

Confidential, NYC, NY

BI Developer

Responsibilities:

  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
  • Build dashboard using parameters sets groups and calculations.
  • Involved in creating a dual axis bar chart with multiple measures.
  • CreatedDax Queries to generated computed columns in Power BI.Blended data from multiple databases into one report by selecting primary keys from each Database for data validation.
  • UsedPower BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Documented All MSSQL database structures and functionalities. Worked with Auditors and Provided Database related documents.
  • Created user defined functions for generic use.
  • Identified the factors involving the performance of the reports and coordinated in creation of indexes statistics to improve the query turnaround time efficiently.
  • PublishedPower BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
  • Exploredata in a Variety of ways and across multiple visualizations using Power BI
  • UsedPower BI Gateways to keep the dashboards and reports up to date.
  • Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
  • Created interactive dashboards, various Power BI visualizations by connecting to different sources and datasets.
  • Using Power BI Connect live to Analysis Services models for both Tabular and Multidimensional cubes and involved data migration from oracle to HDFS.
  • Wrote and modified various Stored Procedures used in the application using T-SQL.
  • Schedule and maintain packages by daily weekly and monthly in SQL Server Agent.
  • Maintained version control and was assigned tasks using Team Foundation Server (TFS) and documented the entire application.
  • Perform quality assurance checks and update databases to ensure data integrity.
  • Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database applications.
  • Involved in creating SSRS and power view reports.

Technologies & Tools: MS SQL Server 2014, SSIS/SSAS/SSRS, Power BI, ETL, T-SQL, Visual Studio 2015, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT).

Confidential, Pittsburgh, PA

SQL BI Developer.

Responsibilities:

  • Responsible for aggregating data from multiple sources in an efficient data warehouse and designed enterprise-level solutions for very large multidimensional databases.
  • Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic.
  • Excellent experience in Extracting, Transformation and Loading (ETL) using various tools including T-SQL, Import/Export data wizard, and SQL Server.
  • Experienced working with SQL Agent Jobs/ Work Unit to trigger, schedule, and monitor loading/rollback processes.
  • Expertise in SQL Stored Procedure Performance tuning, by using Extended Events, Index, Data Profiler trace, and Execution Plan.
  • Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
  • Expertise in Integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
  • Hands on experience on multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Created and executed several SSIS packages to perform ETL operations of the data from source server destinations server and OLTP to OLAP.
  • Used various SSIS tasks such as ConditionalSplit, DerivedColumn, which were used for DataScrubbing, datavalidation checks during Staging, before loading the data into the Data warehouse.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
  • Maintained requirements and created traceability tests between requirements and test cases, validated data using SQL queries.
  • Managed Production Databases like performance issues, Microsoft SQL Server 20012 R2.
  • Troubleshoot both client side, server-side and database issues (Microsoft SQL server).
  • Responsible for creating and modifying database objects to meet changing business needs.
  • Daily Task Distribution within the team and keeping track of the progress using Scrum Board.

Technologies & Tools: SQL Server 2012/2008R2, Server Integration Services 2012, SQL server Reporting Service 2012, SQL Server Management studio, Microsoft Visual Studio, MS Excel, T-SQL, UNIX scripts, Linux, CSV, XML, Excel, Windows XP, XML files, PL/SQL.

Amdocs

SQL Developer

Responsibilities:

  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
  • Conceptualized and Designed Logical and Physical Data Models using Erwin.
  • Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
  • Created logging, custom logging and error handling SSIS packages. sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
  • Created and Executed Stored Procedures and Complex Queries for Reports.
  • Designed SSAS cube to hold summary data for Tableau dashboards.
  • Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
  • Created roles using SSAS to restrict cube properties.
  • Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
  • Created usage-based aggregations in cube to minimize time for query retrieval from client tool Tableau.
  • Was involved in developing Tableau Dashboards using both relational and Multidimensional data.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Converted metric insight reports to Tableau reports.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop.
  • Involved in gathering client requirement and developed Tableau reports based on user defined ad hoc user Interface for end users.

Technologies & Tools: Tableau Desktop 8.x, Tableau Servers 8.X, BI Publisher, Tableau reports, Tableau Suite (8.x), SQL Developer, Windows, Agile.

TECHNICAL SKILLS:

BI Tools: RDBMS Servers:

Operating Systems: Programming Languages:

Databases: Office Applications:

Configuration Tools: Data Base Monitoring Tools:

SSIS, SSRS, SSAS, TABLEAU, POWER BI: MS SQL Server 2016/2014/2012/2008 R2/2005

Windows, Linux: PL/SQL, T-SQL, .Net, C#, Java, Ruby, Python

NoSQL, DB2, MySQL, Oracle, SQL Server, Sybase: MS Outlook, MS Project, MS-Excel, Power Pivot 2010, MS-Access

Team Foundation Server (TFS), GitHub: SQL Monitor from Redgate, SQL Profiler (SQL Server)

Hire Now