Developer Sql Server .Net Business Management
Resume:
Soloman Philip
**************@*****.***
[pic] [pic] [pic] [pic]
SUMMARY OF QUALIFICATIONS
. 10 years of experience in Object Oriented analysis, design, and
development using .NET, ASP.NET, AJAX, WINFORMS, WCF, WPF, Web
Services., C#, VB.NET, Win32 API, VB, COM, and UML on Healthcare,
Insurance, and e-commerce domains
. Experienced in full SDLC (Software Development Life Cycle) which
includes System/Information Engineering, Software Requirements
Gathering, Systems Analysis and Design, Implementation, Testing,
Support and Maintenance.
. Experienced in Customer Support and Maintenance of Software
Applications. Experience in RUP, Agile, and Extreme Programming (XP)
methodologies
. Expert in .NET Framework, C# and VB.NET
. Experienced in Database Development & Administration using Microsoft
SQL Server 2008/2005/2000/7.0
. Versatile experience in Enterprise Manager, Query Analyzer, Profiler,
SQL Server Management Studio etc.
. Expertise in generating reports using MS Reporting Services 2008/2005
. Experience in configuration of report server and report manager
scheduling, give permissions to different level of users in SQL Server
Reporting Services (SSRS).
. Excellent skills in implementing ETL Packages using DTS and SSIS 2008/
2005.
. Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule
DTS/SSIS Packages
. Experienced in software configuration management using Visual Source
Safe, Clear case
. Successful in meeting technological challenges and finding solutions
to meet the needs of the customer
. Strong project management skills through practice and learning through
peers and exposure to various project management tools for Scheduling,
Task allocation and Tracking.
. Experienced in documenting Requirements, Technical/Design
Specifications by following
. Experience in managing an off-shore model projects
. Experience in working with IIS, creating and configuring web
applications
. Good communication, interpersonal and presentation skills
. Excellent work ethics, self-motivated and quick learner, willing to
learn, adapt new technologies and third party products
TECHNICAL
SKILLS
GUI / IDE : Visual Studio .Net 2003/2005/2008, Visual
Studio 6.0
Methodologies : UML, OOAD, Design Patterns
Languages : C, C++, SQL, C#,
VB.Net, Java 2.0
Frameworks/middle ware : WCF, Web Services, COM/DCOM
Technologies : ASP.NET, AJAX, ADO.NET, XML,
XSLT, XPATH, Java Script, VB Script and ASP3.0
Databases : SQL Server 2008/2005/2000/
7.0, MS-Access & Oracle 10g
Tools/Utilities : SSRS, SSIS, VSS 6.0, Crystal
Reports 10/8.5/7.5,VSTO
Version Management : Visual Source Safe, Clear case
Installation Packages : Install Shield, Project &
Deployment
Software Testing: : Test Plan/Test Cases, N-
Unit Test and Mercury Test Director
Operating Systems : Windows NT, 2000, 2003, XP
CERTIFICATIONS
> Microsoft Certified Professional (MCP) in Visual Basic 5.0 and SQL
Server 6.5
> Microsoft Certified Application Developer(MCAD) in C# ASP.Net and Web
Services
> Brain Bench certified in VB.Net, C# and ASP.Net
EDUCATIONAL QUALIFICATION
Bachelor of Engineering, India
PROFESSIONAL EXPERIENCE
Sr. NET Developer
Apr 2010
- till date
Client: Bank of America (Merrill Lynch), Pennington,NJ
SMARTS
The SMART System integrates customer integration with their
financial system. It captures all activities such as cheque deposit, credit
limit increase and etc and integrates the details.
Responsibilities:
. Designing and programming of application using C#. NET.
. Implemented SOA by using WCF
. Designing and developing the Middle tier using ADO.Net to perform and
implement business logic, Updating/Retrieving the data to/from SQL
Server Database
. Creating and modifying tables, constraints and Indexes.
. Writing Transact SQL Queries, stored procedures, user-defined
functions, triggers etc.
. Built different types of chart reports using SSRS for the business
requirement like column chart, Pie Charts.
. Created package to transfer data from OLTP to OLAP databases
. Writing Transact SQL Queries, stored procedures, user-defined
functions, triggers etc.
. Worked with Data Adapter, Data Commands, Datasets and Data Connection
for interacting with the Database.
. Dynamically loaded reports parameters based on the selection of
reports.
. Version controlling application code using Visual Source Safe.
. Debugging, testing and Deployment.
Environment: C#, ASP.Net,MVC, .Net 3.5,WCF, SQL Server 2008, XML, XSLT,
HTML, CSS, Java Script, SSRS, VSS, NUnit, Windows XP/2003
Client: MACY'S, Atlanta, GA
Nov 2009 - Mar 2010
SPA - Size Profile Analysis
The Size Profile Analysis system enables associates to create
and save size profiles at the product, category, and location levels. A
size profile is a unique combination of sales distributions (by size)
across a single size range for merchandise with similar attributes. By
creating size profiles at the location level, you can identify size
variances between locations.It is very useful for making recommendations
on the best distribution of sizes across differing pack quantities,
categorizing multiple methods of grouping styles with similar attributes in
the analysis and providing sales data from the new Enterprise Data
Warehouse.
Responsibilities:
. Responsible for Developing the user interface in ASP.Net using C#
. Successfully Implemented custom controls, server side components and
utilized visual inheritance to create consistent views.
. Successfully developed Develop reusable Data Access functions that
access data using dataset or data reader, stored procedures and SQL
queries and compiled into a single DLL to be available for the entire
application.
. Worked with Data Adapter, Data Commands, Datasets and Data Connection
for interacting with the Database.
. Created reports using SSRS from OLTP and OLAP data sources and
deployed on report server
. Created and Deployed SQL Server Integration Service (SSIS) packages
between enterprise databases and Third party data source to transfer
data.
. Worked on performance tuning of the application especially on SQL
Server Stored Procedures using SQL Profiler
. Performed unit testing and module testing on developed web forms and
custom classes using NUnit.
. Participating in the knowledge transfer process and share the
knowledge with the clients and the team
Environment: C#, ASP.Net,MVC, .Net 3.5,WCF, SQL Server 2008, XML, XSLT,
HTML, CSS, Java Script, SSRS, VSS, NUnit, Windows XP/2003
Sr. NET Developer
May 2009 -
Aug 2009
Client: Aflac, Columbus, GA
PSW- Letter Integration
PSW is a Policy Service Workflow integration engine for Aflac.
Modification of existing policy can be done by using this engine and other
pre defined templates. The customer change request has been made thro
LGS (Letter Generation System).The base template is customized by the
representative based upon the customer request.
Responsibilities:
. Involved in Analysis, Designing, Database Design, Normalization,
Component Development and Integration.
. Identifying new requirements and collecting the information from the
users
. Designed User interface in C#. Net
. Implemented SOA by using WCF
. Implemented AJAX to improve user experience
. Designed and implemented the Admin Module using ADO.net with MS
Visual Studio'08
. Created reports using SSRS from OLTP and OLAP data sources and
deployed on report server
. Created tabular, matrix, chart, drilldown reports, parametric,
cascaded reports and dashboards and scorecards reports according to
business requirement.
. Created complex Stored Procedures for better performance to generate
reports
. Rendered reports in different formats like PDF, excel etc to be
executed automatically on weekly or monthly basis and managed
subscriptions.
. Created report snapshots and cache for better performance
. Created SQL Server Integration Service (SSIS) packages between
enterprise databases and Third party data source to transfer data.
. Created SSIS Packages by using advanced tools (i.e. pivot
Transformation, Derived Columns, Condition Split, Term extraction,
Aggregations, Multicasting).
. Documented all database objects, procedures, views, functions &
packages for future references.
. Used Execution Plan, SQL Profiler to optimize queries and enhance the
performance of databases
. Involved in developing unit test cases in NUnit
. Testing the application and fixing the bugs if any
. Running ad-hoc tests as and when new cases are identified
. Assisting the team members in fixing the bugs
. Participating in the knowledge transfer process and share the knowledge
with the clients and the team
Environment: C#. Net, Winforms, ASP.Net, Net 3.5, WCF, SQL Server 2008,
XML, SOAP, XSLT, HTML, CSS, Java Script,AJAX, SSRS, SSIS,OOAD, UML, NUnit,
VSS, Agile Methodology, and Windows XP/2003
. NET Developer
Feb 2009 -
Apr 2009
Client: Summit Energy, Lousville, KY
Dashboard View
Dashboard View is one of the web site for viewing variety of
customer reports such as budget report, Invoice report etc.,. By using this
tool the user can create and customize the template report, which is
already defined.
The user can subscribe the report by using predefined schedule.
Responsibilities:
. Designed and implemented reusable software elements like Server Side
controls and Custom control using C#.NET
. Preparing the scope of the application and then designing the Model
using Rational XDE.
. Designed User interface in C#. Net
. Created generalized User controls.
. Designed and implemented the Admin Module using ADO.net with MS Visual
Studio'08
. Involved in version management of source code using Rational Clear
Case
. Written stored procedures for accessing the data from SQL 2005.
. Testing the application and fixing the bugs if any.
. Testing the General and MIS reports with dummy data and later with
actual data
Environment: C#. Net, WCF, ASP.Net, .Net 3.5,SQL Server 2005, XML, XSLT,
HTML, CSS, Java Script, SSRS, SSIS, VSS, NUnit, Windows XP/2003
AT&T (Atlanta, GA)
.NET Developer
NIT - Network Incident Tracker
June 2008 - Aug 2008
Network Incident Tracker is a Customer Operations web application that is
designed to provide an efficient method for kiosks (stores) Consumer and
Business Sales, Employees and eventually will be available on our customer
interfacing AT&T web site.Today there are many different ways and means to
report AT&T Mobility network quality issuses (e.g. Dropped, Blocked, No
Coverage, Poor Voice Quality & Echo) our consumer, Business and internal
(employee) customers experience within our network.
Responsibilities:
. Designing and programming of Web application using ASP.NET.
. Creating and maintaining SQL Server 2005 Database.
. Creating and modifying tables, constraints and Indexes.
. Dynamically loaded reports parameters based on the selection of
reports.
. Version controlling application code using Visual Source Safe.
. Debugging, testing and Deployment.
Environment :C#,ASP.Net,Web Service,VSS,SQL Server
2005,XML,XSLT,HTML,CSS,Java Script, SSRS, Photoshop,Windows XP
. NET Developer
May 2007 -
May 2008
Client: Georgia Pacific, Atlanta, GA
KAM - key Account Management
KAM is an Account planning processing tool used to analyze the
business process. It is used to determine key
Buying factors, identify which factors will likely drive customers to
switch suppliers, analyze how we are positioned
Against these factors relative to competition, and review our win-loss
history of prior bids. Account summary is used to review history with
account, product mix, contract status, and customer financial stability.
Using key decision makers contacts in the organization with decision
rights, the level of contact they require, their general feeling towards
GP, and how they make decisions are identified
Responsibilities:
. Responsible for Client interaction, analysis, design and development.
. Developed Proof of Concept and best practices for the application
architecture.
. Developed data access components and business logic components using
VB.NET
. Implemented AJAX to improve user experience
. Creating and modifying tables, constraints and Indexes. Writing
Transact SQL Queries, Stored procedures, user-defined functions,
triggers etc.
. Implemented data access ADO.Net to perform and implement business
logic, Updating/Retrieving the data to/from SQL Server Database
. Version controlling application code using Visual Source Safe (VSS)
. Code review for Standards, Performance, and Memory Management.
. Involved in preparation of Test Plan and Test Cases and Unit test and
Integration test.
. Motivated the team, helping them to learn new concepts and adding new
skills to the entire team.
Environment: VB.Net, ASP.Net, .Net 3.0, SQL Server 2005, XML, XSLT, HTML,
CSS, Java Script, SSRS, SSIS, VSS, Windows XP/2003
. NET Developer
Aug 2006 -
Apr 2007
Client: Centers for Disease Control and Prevention (CDC), Atlanta, GA
PEMS - Program Evaluation and Monitoring System
The main objective of PEMS is data collection. This software is
designed for health departments and community-based organizations (CBO's)
funded by the Centers for Disease Control and Prevention to deliver HIV
prevention services. CDC is recognized as the lead federal agency for
protecting the health and safety of people. PEMS is an electronic/browser-
based prevention tool to facilitate the collection, reporting, analysis,
and interpretation of standardized data on HIV prevention service
activities as required in the health department and CBO program
announcements. It monitors different types of disease control programs
throughout different states and funds different agencies, which are
connected either directly or indirectly with the state health department or
CDC. This system helps CDC evaluating and monitoring HIV related diseases
and the performance of the agencies, which are assigned the task of
preventing it.
Responsibilities:
. Understanding the manual system
. Understanding the clients needs in trying to implement a computerized
system to improve the operational efficiency
. Documenting the requirements and relating the same to the clients and the
development team
. Designing the database tables and creating the necessary scripts to
achieve the same
. Programming using C# to create the User interface
. Testing the various components of the system and integrating the entire
team work
. Building the system and deploying the same at the client's location
. Training the end-users with this new system
. Comparing the new system with the existing system and highlighting the
needs of the new system to the users
. Documenting the changes suggested by the end-users and incorporating them
in the system
Environment: C#, ASP.Net, .Net 3.0, SQL Server 2005, XML, XSLT, HTML, CSS,
Java Script, VSS, Windows XP/2003
. NET Developer
Apr 2006
- July 2006
Client: Temel Inc, Boonton, NJ
MySampleCloset.com
MySampleCloset.com is the Online Drug ordering system, connecting
Healthcare Professionals with Pharmaceutical companies to obtain Product
samples. The Registered physicians can order the Drugs and controlled
substance. It provides safe, secure, private and convenient way to order
the Drugs.
Responsibilities:
. Studying the present system and analyzing.
. Designed and developed the project by following MVC pattern.
Implemented Service Oriented Architecture.
. Designed and implemented reusable software elements like Server Side
controls and Custom control using VB.NET
. Preparing the scope of the application and then designing the Model
using Rational XDE.
. Created generalized User controls.
. Involved in Encryption of Data by using MD5 Encryption and SHA1
Encryption.
. Designed and implemented the Admin Module using ADO.net with MS Visual
Studio'05
. Involved in version management of source code using Rational Clear
Case
. Written stored procedures for accessing the data from SQL 2005
. Testing the application and fixing the bugs if any.
. Testing the General and MIS reports with dummy data and later with
actual data
Environment: VB.Net, ASP.Net, Net 3.0, SQL Server 2005, XML, XSLT, HTML,
CSS, Java Script,CSLA, VSS, Windows XP/2003
. NET Developer
Mar
2003 - Apr 2006
Client: Siemens Medical Solutions - Health Services, Malvern, PA
Soarian
It is a Healthcare solution providing complete medical
solutions, which will be used in various Hospitals for performing their
daily activities like patient registration (Inpatient, Outpatient, and
Emergency Outpatient), Activity Handling, diagnostic information, Staffs
daily schedules.
1 Responsibilities:
. Interacted with the users to understand the business requirements
. Created design documents based on the business requirements and rules
. Designed User interface in C#. Net
. Accessing Office products by using VSTO
. Developed data access components and business logic components using
C#. NET
. Designed and implemented the Modules using ASP.NET and ADO.NET with
MS Visual Studio'03
. Implemented MVC architectural pattern
. Created and Implemented Web Services
. Written stored procedures for accessing the data from SQL 2000.
. Testing the application and fixing the bugs if any.
. Testing the General and MIS reports with dummy data and later with
actual data.
. Involved in Problem Management and Change Management process using
CharmNT.
Environment: C#, ASP.Net, .Net 2.0,SQL Server 2000,XML, XSLT, HTML, CSS,
Java Script, Crystal Reports, VSS, Windows XP/2003
Siemens Information Systems Ltd, Bangalore, India
Dec 2000 - Feb 2003
Visual Basic & SQL Server Application Developer
Med Suite - CSSD
The Central Sterile Supplies Department (CSSD) comprises that service
within the hospital in which medical/surgical supplies and equipment, both
sterile and non-sterile, are cleaned, prepared, processed, stored, and
issued to various clinical departments of the hospital for patient care.
Sterilization is defined as the process of destroying all microorganisms on
a substance by exposure to physical or chemical agents. In practice,
sterility is described as the probability of a surviving microorganism
being one in a million. The sterilization process is fundamental to safe
patient care. Without sterilization, modern invasive surgical, diagnostic,
and therapeutic procedures would be impossible.
Responsibilities:
. Designing of Desktop application GUI in VB 6.0
. Utilized connection pooling, which helps to plan, design and deploy
ADO applications for enhanced application performance, scalability and
security.
. Wrote complex Queries, Stored Procedures and Triggers.
. Involved in creating User Controls.
. Developed business logic and Smart Card interface in C++
. Designed and Created Complex Reports like Drill downs using Crystal
Reports 8.5.
. Designed and Created sub Reports using Crystal Reports 8.5
. General unit testing and bug fixing and testing of MIS reports
Environment: Visual Basic 6.0,MS Access 2003,C,C++, Oracle 10g,Crystal
report 8.5, VBA Coding, Clear case, Windows XP
Dharma Systems, Bangalore, India
Dec 1999 - Dec 2000
Visual Basic/ASP & SQL Server Application Developer
Admin Net
An Intranet application, which enables employee's interaction to
management through net. Assignment, Employee track, Leave approval,
compensation are done by this system. Here there are 2 broad category
users. All the activities are taking place by mail service
Responsibilities:
. Gathering various techno-functional requirements by interacting with
the clients and studying their existing business process
. Designing the front-end User Interface using ASP Pages & the back-end
SQL Server Database
. Testing the application prior to upgrading the production
. Upgrading the production system
. Training the users on the new system
. Setting up maintenance jobs to take regular database backups
. Monitoring the SQL Server jobs
Environment: ASP2.0, IIS 4.0, HTML, DHTML, VB Script, Windows NT
Contact this candidate