Senior .net/bi Developer Resume
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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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.