We provide IT Staff Augmentation Services!

Bi Developer Resume

0/5 (Submit Your Rating)

Philadelphia, PA

SUMMARY

  • Over 7 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) which includes Analysis, Design, Development, Testing of applications using Data Warehousing concepts and Business Intelligence tools.
  • Working experience with MS SQL Server ( / 2005/2000 /7.0 ) and Visual Studio ( 2010/20 ) used to generate reports, design models, integration, developing custom utilities and applications using .NET.
  • Extensive experience developing and implementing solutions using Microsoft SQL Server integration services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) for data warehousing and data marts.
  • Expertise in Power BI, Power BI Pro, Power BI Mobile.
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources.
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
  • Created packages using SQL Server Integration Services (SSIS) for data Extraction from/Load to Flat Files, Excel File MS Access, DB2, Oracle etc.
  • Creating and monitoring the batch jobs using SQL Server Agent.
  • Installed Configured and Maintained SQL Server Integration Services (SSIS). Created SSIS/DTS packages and deployed them to SQL Server and File system.
  • Maintained the configurations passing the variable values though XML file, database table and sometimes through Environment variables to run the packages manually upon failure.
  • Also configured and deployed the new Project based deployment introduced in 2012 SQL Server Data Tools (SSDT).
  • Deployed the Projects to Integration Services Catalog and managed the security. The Configurations are set from Project and Package parameters through the Environment.
  • Proficient in design and development of various dashboards for data visualization, reports utilizing Power BI Visualizations like Funnel Charts, Bar Graphs, Scatter Plots, Pie - Charts, Donut Charts, Bubble Charts, Line charts, Heat Maps, Tree Maps.
  • Installed Configured and maintained SQL Server Reporting Services (SSRS) reports and deployed to the Report Manager and the Sharepoint. Also maintained the security and performance of these reports.
  • Created cascade parameterized, adhoc, drillthrough, drilldown, Graph, Chart, KPIs, linked, snapshot, subreports, canned reports etc. using SSRS.
  • Integrated SSRS and Crystal Reports with .net application automatically passing the report parameters from the application and defaulting to the desired output to a certain format if required.
  • Created SQL Server Analysis Services (SSAS) cubes and migrated some of the existing cubes. Also created SSRS reports out of these cubes writing MDX queries to pull the data.
  • Created multiple cubes in a database solution with multiple facts in a single cube with shared dimensions.
  • Created hierarchies, partitions and perspectives as and when required based on the complexity of the cube.
  • Processed and maintained the cubes on a schedule directly in SQL Agent using XMLA or through SSIS process task.
  • Experience with design of datawarehouse and datamarts using Inman and Kimball methodologies based on the organization.
  • Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.
  • Experience in RDBMS database and tables design Normalization, De Normalization, Unique, primary, foreign keys and Clustered, Non clustered Indexes.
  • Extensive experience with T-SQL in writing and debugging complex stored procedures, triggers, table views and user-defined functions.
  • Working experience with ASP .NET and C# and its integration with Webfocus Reporting and SQL Server Reporting Services.
  • Connecting to database using ADO.NET and data retrieval using Dataset and Data reader. Also using LINQ and AJAX in the new frameworks.
  • Experience in web applications with .NET framework 2.0/3.0/3.5/4.0 using ASP.NET,C#, ADO.NET, SOAP, Web Services, XML and XSL.
  • Development of Interoperable WebServices, Winforms, Console Applications using C# and VB. Net.
  • Well versed with IIS, registry, assembly configuration. Used Powershell script to register .net assembly in GAC.
  • Delivered 24/7 support including scheduled and emergency night and weekend work.
  • Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000, Oracle 10g/9i/8i, DB2, Access

ETL Tools: SSIS, DTS

Reporting Tools: Power Bi, SSRS, Crystal Reports X1/X

Languages: C, C++, C#, LINQ, Visual Basic

.NET Technologies: Web Forms, ASP.NET, ADO.NET, .Net 3.5/3.0/2.0, Web Services

Web Servers: Microsoft IIS, SharePoint 2010/2007

Scripting Languages: JavaScript, JQuery, AJAX, HTML, XML, XSD, CSS, T-SQL, Powershell

Methodologies/Tools: UML, MS Visio

IDEs/CMS/Tools: MS Visual SourceSafe VSS, TFS, Visual Studio 2010/08/05/03

Operating Systems: Windows Server 2008/2003/2000, Windows 7/XP

PROFESSIONAL EXPERIENCE

Confidential, Wilmington DE

Reporting Analyst

Responsibilities:

  • Analyze Design, Development and Testing of applications using MS SQL Server and Visual Studio.
  • Migrated all SSRS Reports to Power BI Dashboards.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Translated the business needs into technical specifications.
  • Created reports using, Pie charts, Column chart, Scatter chart, Slicers, KPI, and Table Matrix.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Worked in Power BI environment to create dashboards like daily, weekly, monthly reports using Power BI desktop and publish them to server.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
  • Published Power BI Desktop reports created in Report view to the Power BI service.
  • Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Worked closely with business users in order to understand the legacy Excel reports and did conversion to SSRS.
  • Used subscription to schedule reports to be generated on predetermined time.
  • Created Drilldown, Drillthrough, Canned reports, Charts etc and Deployed to ReportManager.
  • Deployed and scheduled SSRS Reports to generate all daily, weekly, monthly and quarterly Reports including current status. Involved in optimizing report performance using Report Caching and Snapshots.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS). Deployed the generated reports on to the server.
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Fine-tuned the logic in stored procedures, Functions and Triggers for optimum performance.
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
  • Migrated some of the SSRS reports from environment.
  • Developed reports in SSRS from IBM Netezza warehouse and SQL Server.
  • Created new SSIS packages for the data migration from IBM Netezza warehouse to SQL Data Marts and created reports out of them.
  • Converted all the existing Excel reports into SSRS and created Tabular, Matrix Reports, Charts, Line Graphs, Stacked Bar Charts, Pi charts etc. and added default date parameters to refresh the data monthly in the reports.
  • Created Subscription for the reports and scheduled and maintained the delivery of the reports to the corresponding users.
  • Created detailed documentation of all the reports covering both the technical and non technical aspects.
  • Introduced SSRS and Trained all the existing senior developers in SSRS and helped them to develop reports and resolve any issues they encountered while creating the reports.

Environment: MS SQL Server 2012/2008R2/2005, SSIS, SSRS, SSAS, DB2, MS Access, SQL *Plus, ASP.NET, C#.NET, ADO.NET, Windows XP, .NET Framework 3.5/3.0,Visual Studio 2010/2008/2005 .

Confidential, Philadelphia PA

BI Developer

Responsibilities:

  • Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
  • Understand the functional requirement specifications and preparing design documentation.
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Deployed packages to SQL Server and file system in 2008 and also used the new Project based Deployment introduced in 2012 SQL Server Data Tools (SSDT) to deploy the 2012 packages.
  • Configured and deployed the SSIS 2012 projects to the new Integration Services Catalog. Set the Environment and managed configurations using the Package and Project variables.
  • Maintained the SSIS projects and users accessing the Catalog and SSISDB.
  • Scheduled and monitored the SQL Agent jobs to run these packages periodically.
  • Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.
  • Created new SSIS packages for the existing legacy Data Transformation Services (DTS) packages in the due course of data migration from SQL Server .
  • Scheduled and monitored the execution of the jobs using a third party tool Global Event Control Server (GECS) and SQL Server Agent.
  • Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.
  • Migrated, recreated and maintained the Legacy packages, cubes and reports.
  • Migrated some of the SSRS reports from and from environment.
  • Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embedded GIF images in report headings and footings.
  • Involved in building and maintaining dimensional cubes with SQL Server Analysis Services (SSAS) and used MDX script for querying the data.
  • Developed Business views, Report objects, Cubes for the users to analyze the data and help them in decision making.
  • Deployed SSRS reports to Report Manager and made a call to those reports through a URL from .Net API (.aspx).
  • Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.
  • Designed interactive web pages in ASP.NET and user controls using C#. The pages are developed using dynamic controls with java scripting.
  • Experience developing web applications using ASP.NET,C#, ADO.NET using both C# and VB#.
  • Also developer Web applications on the client side using HTML, AJAX, JQuery and LINQ to SQL which is much faster to render since it runs on the client side.
  • Performing Unit testing and internal QA for the developed application.
  • Created and maintained the SSRS reports, design documents and other scrum status trackers available on SharePoint for the business users and the steering team.
  • Used Compucom ticketing system for the change management and tracking the issues and enhancements.
  • Working closely with the users supporting the existing reports and creating new reports.

Environment: MS SQL Server 2012/2008R2/2005, SSIS, SSRS, SSAS, DB2, MS Access, SQL *Plus, ASP.NET, C#.NET, ADO.NET, Windows XP, .NET Framework 3.5/3.0,Visual Studio 2010/2008/2005, HTML, JavaScript, AJAX, LINQ.

Confidential, Atlanta, GA

BI Developer

Responsibilities:

  • Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
  • Design/Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse and claim systems.
  • Worked on Stored Procedures and Database Triggers.
  • 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.
  • Worked Extensively with SSIS to import, export and transform the data between the linked servers.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Involved with various business groups while developing their applications, assisting in database design. Worked on SQL query tuning, execution plan to enhance query performance.
  • Design and implementation of Performance Tuning and Maintenance plan for database consistency checks, backup/restore. Designed DTS package to export data from/to access data source to SQL Server.
  • Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
  • Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Created SQL Agent Jobs and scheduled the SSIS Package to run overnight. Resolved the issues associated with the job failure.
  • Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
  • Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
  • Prepare documentation related to database design, objects security and rules.
  • Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.
  • Defined production support document with recovery process.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
  • Created indexes and implemented optimizal fill factor for all tables.
  • Create and Modify User Defined Functions, Stored Procedures, Triggers, Views according to the business requirements.
  • Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.

Environment: MS SQL Server 2008R2/2005, SSIS, SSRS, SSAS, DB2, MS Access,, ASP.NET, C#.NET, ADO.NET, Windows XP, .NET Framework 3.0,Visual Studio 2008/2005, HTML, JavaScript, XML.

Confidential, Irving, TX

SQL Developer

Responsibilities:

  • Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Developed complex queries in T-SQL, wrote Stored Procedures, Triggers and Queries with best execution plan. Created cubes and dimensions for the analysis of sales in specific areas.
  • Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
  • Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
  • Created stored procedures and user-defined functions for different Reports.
  • Created complex correlated sub queries to generate reports.
  • Knowledge of working on translation to SQL cluster.
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies. Developed, monitored and deployed SSIS packages.
  • Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
  • Worked with SSIS packages involved FTP tasks, Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot Control Flow Transformations.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS). Deployed the generated reports on to the server.

Environment: Visual Studio 2008/2005, MS SQL Server 2008R2/2005, SSIS, SSRS, DB2, MS Access, ASP.NET, C#.NET, ADO.NET, Windows XP, .NET Framework 3.0/2.0, HTML, JavaScript.

We'd love your feedback!