Software/database Developer Resume
Raleigh, NC
PROFI LE:
Software/Database developer experienced in enterprise environments. Involved in all stages of software development life cycle (SDLC); analysis, design, coding, unit testing, deployment and maintenance. Ability to work with multinational teams. Extensive experience in developing and implementing solutions including: SQL Server database objects, object oriented applications, data integration projects, business intelligence and reporting solutions.
TECHNICAL SKILLS:
Programming : C#.NET (8 years), VB.NET (3 years), ASP.NET (2 years), HTML5/CSS3/Javascript (2 years), ADO.NET, T - SQL (Stored Procedure, Function, Trigger) (8 years), SQL CLR (2 years), WCF (3 years), LINQ (3 years), Entity Framework (2 years)
Tools: Visual Studio, Business Intelligence Development Studio, SQL Server Report Builder, DevExpress, MS-Office
Database : MS-SQL Server (10+ years), Data Warehousing (5 years), Data Modeling (2 years), Replication (5 years), MS Access (3 years)
Reporting : SQL Server Reporting Services(SSRS) (5 years), SAP Business Objects (2 years), MS Power BI (1 year), Crystal Reports (2 years)
ETL: SQL Server Integration Services (SSIS) (5 years), SAP Business Objects Data Integrator (2 years)
ERP : SAP R/3 (2 years)
Source Control : Team Foundation Server (TFS) (5 years), SVN (1 year)
Methodologies: Agile (2 years), LEAN Software Development (2 years)
EXPERIENCE:
Confidential, Raleigh, NC
Software/Database Developer
Responsibilities:
- Designing, developing and testing software applications (C#, MS SQL Server, Object-Oriented design)
- Working with multiple clients from healthcare and pharmaceutical industry on implementation and customizations, including: business process reviews and analysis, data migration and integration
- Delivering data integration by exporting, transforming and loading data (ETL Packages, SSIS, T-SQL)
- Participating in requirement definition, solution development and implementation phases of the software and database projects
- Providing second-level support to the implementation and support team (Assembla, Zoho Desk)
Confidential
Senior Software/Database Engineer
Responsibilities:
- Developed business intelligence projects including Reporting, Data Visualization, Data Analysis (T-SQL, SSIS, SSRS, SAP Business Objects 4.1, JSON, XML).
- Designed, databases and data warehouses to fulfill reporting requirements.
- Evaluated the data model and employed best practices in creating a complete schema including tables, relationships, views.
- Created Power BI Reports and Dashboards.
- Monitored the performance of SQL Server - particularly to analyze the performance of the stored procedures.
- Updated and maintained the current in-house applications (C#, WCF, XML, JSON, LINQ, Entity Framework).
- Defined project scope, identify the business requirements and rules.
- Implemented Agile development approach and planned sprints as part of project implementation.
- Adapted Lean Software Development by eliminating the waste (unnecessary code, functionality).
- Tracked solution providers to ensure the on time delivery with the required functionality using the Agile methodology.
Software Engineer
Confidential
Responsibilities:
- Developed Territory Management System (mobile and back-office) for the sales force (medical representatives and regional managers) (C#, ADO.NET, T-SQL, Merge Replication).
- Developed web application for Finance department to store and report the monthly employee expenses and integrated it to Accounting system(SAP R/3) using ASP.NET, HTML5, CSS3, XML.
- Team member (Back-end developer) of an international CRM Pharma project used by the subsidiaries in which all communication was in English.
- Developed Congress & Event Follow-up System for Sales and Marketing departments to manage the activities organized and integrated reports to enable direct reporting.
- Developed and optimized Stored Procedures, Functions and Triggers using T-SQL and SQL CLR.
- Created new projects, new code branches, and merged code streams in TFS.
- Monitored, tuned database resources and activities for SQL Server databases.
- Created ETL packages using SSIS to import data on daily basis from various platforms.
- Deployed SQL Reports(SSRS) and Crystal Reports with applications.
- Participated in requirements analysis and detail design of new systems and functionality.
- Created test scenarios and coordinated user acceptance tests.
Confidential
Software Developer
Responsibilities:
- Developed ERP/MRP application integrated with Automatic ID and data capture systems in retail industry. (VB.NET, MS SQL Server, MS Access).
- Developed custom solutions on mobile terminals using .Net Compact Framework, SQL Mobile and Embedded Visual Basic 3.0
- Documented project scope and customizations required.
- Provided Incident solutions within strict SLA deadlines.