We provide IT Staff Augmentation Services!

Senior .net/bi Developer Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Microsoft Certified Technology Specialist with 7+ years of professional experience involving in all the stages of software development life cycle, studying the user requirements, analyzing, designing, preparing necessary documentations, coding, implementation, testing and deployment.
  • Extensive experience in web technologies like ASP.NET, WCF & Web Services, IIS 6.0, HTML, XML, SOAP, XSLT, VBScript, JavaScript.
  • Hands on experience in designing and developing .Net applications with C#.Net and SQL Server.
  • Rich experience in ETL and reports development using SQL Server Integration Services (SSIS) packages and SQL Server Reporting Services(SSRS).
  • Extensive experience in US Healthcare domains and products like QNXT, CCA.
  • Proficient in database programming like developing complex stored procedures, triggers, tables, views, user defined functions, relational database models.
  • Sound knowledge of N - tier layered architecture.
  • Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, multi tabbed reports, charts, dashboard using SQL Server Reporting Services, Tableau.
  • Rich development experience in Automation tools using ASP.Net, C#.Net, SQL Server and Excel macro for minimizing manual efforts.
  • Extensive experience in performance tuning, disaster recovery, troubleshooting, backup and restore procedures.
  • Good documentation skills in preparing Technical Specification Document, Detail Design Document, Unit Test Planning, Requirement Traceability Matrix.
  • Experience in creating SSIS packages, jobs, alerts, SQL mail agent and scheduling SSIS packages.
  • Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team. Perform code review with the developers and fine-tune the code for performance improvement.
  • Specialized as a Configuration Manager for managing the necessary artifacts and share the audit report to teams, publishing documents in SharePoint and managing the users.
  • Good technical analysis/design skills, Strong understanding of business needs objectives and interests in projects, able to quickly learn and adapt to new technologies.
  • Excellent experience in onsite-offshore model interacting with clients and Onsite managers.

TECHNICAL SKILLS:

Programming Languages: C#.Net, ASP.NET, ADO.NET, .Net Framework 3.0/3.5, SSIS, RESTFUL Web Services, WCF Services

Scripting Languages: HTML, CSS, XML, AJAX, JavaScript, JQuery, JSON, PHP, Shell

Databases: MS SQL Server 2008R2/2012/2014,PL/SQL

ETL Tool: SSIS

Reporting Tools: SSRS, Excel Reporting

Operating Systems: Windows Server 2008/2012, LINUX, UNIX

Products: QNXT, CCA

Version Controls: TFS, SVN, Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential

Senior .Net/BI Developer

  • Involving in requirement gathering, analysis, design, documentation, coding, unit testing and coordinating with offshore.
  • Developing .Net applications, supporting the existing application, working on enhancements.
  • Developing SSIS packages to validate the data by extracting and applying appropriate transformations over the data and loading data from OLTP system to data warehouse.
  • Creating parameterized, cascaded, drill-down, cross-tab and drill-through reports using SSRS 2008 R2/2012, distributed the reports in multiple formats into specified locations.
  • Managing report delivery based on Time driven and Data driven subscriptions.
  • Creating ad hoc queries, complex stored procedures and views to store the data of clients, and use them in SSRS reports to generate reports on the fly.
  • Migrating Oracle OBIEE reports into SSRS reports and migrated the existing SSRS reports into higher versions.

Environment: C#.NET, ASP.Net MVC, MS SQL Server 2012/2014, SSIS, SSRS, SQL Profiler, Excel reporting, JQuery, JavaScript, Excel Macros, Oracle 11g, TFS.

Confidential

.Net with BI Developer

Responsibilities:

  • Involving in requirement gathering, analysis, design, coding and unit testing.
  • Creating documentations such as Technical Specification Document, Detailed Design Document, Unit Test Plan and Requirement Traceability Matrix and status reports.
  • Developing custom solutions using C#.Net for implementing pre and post add-ins to satisfy the business needs.
  • Developing stored procedures, functions, triggers, Indexes and views for the application.
  • Creating business critical stored procedures/functions and used them in reports directly to generate reports on the fly.
  • Solving production issues in timely manner and enhancing the applications based on the business request.
  • Developing automation tools for minimizing manual script execution, Complex rate code generation, EDI file splitting using SQL and .Net programming.

Environment: ASP.Net, C#.NET, MS SQL Server 2008R2, SQL Profiler, TFS, JQuery, JavaScript, SSIS, Excel Macros.

Confidential

.Net with BI Developer

Responsibilities:

  • Involving in understanding user requirements, analysis, design, documentation, build, code review and deployment activities.
  • Creating services to fetch the process information from multiple sources like TIDAL, hosted servers.
  • Creating windows service to get logging details from log files and log tables.
  • Providing timely support for critical deliverables and end-to-end testing.
  • Involving in performance tuning and optimization of queries, functions and stored procedures.

Environment: ASP.Net, C#.NET, MS SQL Server 2008R2, Web Service, Win Forms, TFS, JSON, JQuery, JavaScript, Oracle 11g, Excel Macros.

Confidential

.Net with BI Developer

Responsibilities:

  • Developing a generic solution with C#.Net, SSIS and SQL Server to sync the legacy data with 13-month retro processing to QNXT.
  • Developing SSIS packages using various transformations like business intelligence transformations like conditional split, data conversion, lookup, merge, sort, union all, join.
  • Designing packages with parallel processing
  • Creating automation scripts for unit testing, QA validation to reduce the time by creating SQL and VBA scripts.

Environment: MS SQL Server 2012, SSIS, SSRS, SQL Profiler, C#.NET, TFS, Excel Macros.

Confidential

.Net with BI Developer

Responsibilities:

  • Involving in complete software development life cycle process by analyzing business requirements and understanding the functional work flow of information.
  • Developing interfaces using AutoQ framework - a solution to handle the PEND claims and Rhino framework - a solution to extract, transform and load data from source to destination in the form of heterogeneous types.
  • Developing SSIS Packages to load and extract data from heterogeneous data to/from SQL Server.
  • Solving production issues in timely manner and enhancing the applications based on the request.
  • Working on migration projects from QNXT 5.2 to 5.3 versions.
  • Developing pre and post add-ins for applying client based requirements into/from the system.
  • Developing automation tools using .Net and Excel macros.
  • Developing various reports like Drill Down, Drill through, Cross tab, sub reports and Parameterized Reports.
  • Scheduling SQL jobs and managing subscriptions for SSRS reports using SSRS 2008 R2/2012.
  • Responsible for writing complex SQL queries, stored procedures, triggers, views, cursors, constraints, indexes and user defined functions to implement the business logic.

Environment: SQL Server 2008 R2, SSIS, SSRS, MS Visual Studio 2010, SQL profiler, C#.NET, ASP.Net, TFS, JavaScript, JQuery.

Confidential

.Net/SQL Developer

Responsibilities:

  • Involving in requirement gathering, analysis, design, coding, unit testing and deployment of deliverables.
  • Creating Technical Specification Document, Requirement Traceability Matrix and Unit Test Plans based on the functional requirements.
  • Creating web services.
  • Involving in designing database, applied coding standards in all the objects like tables, indexes, constraints, functions, stored procedures, views and triggers.
  • Developing generic outbound solutions for different vendors using ASP.Net and SQL Server.
  • Writing complex and efficient DML queries, view, tables, indexes, stored procedures, functions, triggers, linked servers and maintaining referential integrity.
  • Writing shell scripts to extract, transform and loading data to/from flat file to database.
  • Creating indexed views and appropriate indexes to reduce the running time for complex queries.
  • Developing PHP reports for the projects running in Unix environment with MySQL as data store.

Environment: ASP.Net, WinForms, SQL Server 2008 R2, SSIS, SSRS, C#.NET, Perl & Shell Scripting, MySQL, PHP, VS Source Safe, Perforce.

We'd love your feedback!