Software Developer Resume Profile
Summary
- About 8 years of experience in Design, Development and Implementation on SQL Server 2012/2008,SSIS, SSRS, ETL,
- ASP.NET, C , VB.NET, ADO.NET, CSS, JavaScript.
- Experience in all stages of Software Development Life Cycle SDLC including Requirements, Analysis and Design, Implementation, Invb.tegration, Testing, Deployment and Post Development Maintenance in Waterfall Agile Methodologies.
- Good experience in RSAM GRC Tool management and issue logs.
- Good experience in Business Intelligence Development Studio BIDS .
- Expert in High Level Design of ETL/ SSIS Package for integrating data from heterogeneous sources Excel, CSV, flat file, Text Format Data using SSIS Packages.
- Excellent working experience in design and development of several reports using Crystal Reports and MS SQL Server Reporting Services 2008 SSRS from OLTP and OLAP data sources.
- Working in Erwin tool for data modeling.
- Strong Database Objects development - Tables, Views, Triggers, Stored procedures, Cursors using SQL Server 2008/2005.
- Excellent knowledge in Enterprise Manager, T-SQL, SQL Profiler, Query Analyzer and Execution plan.
- Created functions and triggers to ensure the database consistency and maintained using DBCC check, and Rank functions, CTES and derived table.
- Database/Data migration from Database to Database and SQL batches.
- Experience in Oracle to SQL Server Migration using SSIS tool.
- Designed reports with Drill Down, Drill Through and Drop down menu option and Parameterized Reports.
- Knowledge in service oriented architecture creating and consuming XML Web Services over SOAP in .NET using C or VB.NET
- Involved in object-oriented analysis, design and coding in a .NET server-side environment, specifically utilizing the Microsoft MVC framework.
- Experience in building application from TFS and deploying projects in different environments.
- Interaction with technical leaders and business analysts BA to discuss and understand the functional and requirement specification.
- Ability to participate as an active role for technical teams in a results-oriented environment, effective at translating business requirements into on-time deliverables.
- Very strong analytical and problem solving techniques, presentation skills deliverance and proven team player qualities.
- Expertise in Requirement analysis, Database design, Data modeling and complete software lifecycle.
- Having Working Experience in Banking / Retail / ERP / Healthcare Domains.
Technical Skills
Database | SQL Server 2012/2008, MS Access, Oracle, SSIS, SSRS, SQL Server Profiler,T-SQL,Erwin |
MS Technologies | .NET VB.NET, C , ASP.NET, ADO.NET,MVC ,ASP,MS-Office,PowerPivot |
Web Servers | IIS 7.0, IIS 6.0. |
Operating systems | Windows XP, Windows 7, 2008 Server, Windows 8.1 |
Development tools | Microsoft Visual Studio 2010/2008,VSS, TFS 2010, Business Intelligence Development Studio BIDS ,ETL,DTS |
Scripts | HTML, XML, JavaScript, VB Script, CSS |
Professional Experience
confidential
RSAM GRC/SSIS/SSRS Consultant
Performed Vendor Risk Management consulting and software implementation for Pharmaceuticals client engagements. Provide direction to clients on developing, refining and automating Vendor Risk Management program. Enabled the identification, assessment, reporting, management, and escalation of risks associated with vendors identified as key to client to strengthen governance and control while maintaining compliance with audit and regulators Conduct vendor security assessments using GRC platform and perform remediation tracking.
Responsibilities:
- Worked in creating Privacy and Service Reliability Use cases Attribute, Event Handlers, Trigger event in different data types.
- Worked in creating Criteria, Action for each and every handlers, buttons.
- Imported different department data into RSAM application through data mapping. Creating scheduler for daily,weekly,monthly wise data import.
- Finding issues and solved through the Log files.
- Assigned the User's Permission to access different type of department to view,modify,delete and admin rights.
- Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
- Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services SSRS .
- Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures SQL scripts as part of the enhancements.
Environment: SQL Server 2012, SSIS, SSRS,T-SQL,ETL,RSAM GRC Tool.
confidential
SQL server SSRS/SSIS consultant
- GCPS's Information Management Division provides all users the information, skills, and tools they need to perform their jobs effectively and make data-driven decisions. GCPS is one of the top 5 county schools in United States for providing education through excellent IT utilization and IT Management.
- Develop new reports for Customer Service Support CSS team using SSRS 2008. Migrating BMC SDE Service Desk Express Server crystal reports to SSRS 2008. Import Project: CSS Report Development data from various sources using SSIS in SQL 2008 and 2012.
Responsibilities:
- Involved in design, development, enhancement, implementation, testing, maintenance, version upgrade and performance tuning of the application.
- Implemented the architecture to separate a Report server from Production Batch server and created replication model to pull the data from Batch server to Report server using SSIS.
- ASP.NET development including MVC.
- Implemented handshake mechanism between CSS Batch server and Lotus notes to keep employee data up to date using SSIS.
- Extracted data from Alcatel tele management system to Report server using SSIS for KPI reporting.
- Design and development of Change management reports using SSRS 2008.
- Develop Incident Summary dashboard reports for Board meetings.
- Migrating SQL server 2008 to SQL server 2012.
- Building the Incident summary reports by school level and Tech. support associate level.
- Created Drill through reports, Drilldown reports and sub reports. Having excellent experience in utilizing filters and multi grouping inside tablix.
- Experience in single multi parameterized reports and created interactive sorting reports.
- Handled multiple data sources and data sets in a single report.
- Developed matrix reports for School Year to date performance metrics report.
- Developed the Report Dashboard,PowerPivot for School Principals to monitor their school Incidents.
- Created various Chart reports to show the Daily/weekly/monthly Incident Opened/Closed by Incident type, Urgency, School, Tech. Associate.
- Setup the E-mail report delivery system for Directors, managers. Also setup the data-driven report delivery for Individual school report for Principals. This has been done by storing user credentials in a database table.
- Administering reporting services from end to end. This includes report publishing, setting up report execution On demand, Snapshot Cached instance and managing report subscriptions.
- Experience in Ad-Hoc reporting: Setting up report models, creating reports using Report Builder 2008.
- Data migration Import Export using BCP from text to SQL Server2008
Environment: MS SQL Server 2008 and 2012 , SSIS, SSRS2008, T-SQL, CrystalReport,PowerPivot,ETL,Erwin,TFS,.Net Framework, Asp.Net, JavaScript, CSS, HTML,MVC
confidential
SQL Developer / ETL Developer
Major project concepts are mostly used by business analyst, data analyst, implementers and facility financial professional to review the source data to gather knowledge, statistics about the data and to analysis the quality and consistency of the data. Some of these projects are used to parse and load the EDI 835 and 837 data into the databases and other projects provide interface to analysis the data. These data's are used by different teams to identify the variance amount, data quality, missing claims etc.
Responsibilities:
- Involved in design, development, enhancement, implementation, testing, maintenance, version upgrade and performance tuning of the application
- Participated in meetings with Business Partners Business Analyst to gather business and software requirements for application backend design and development.
- Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures SQL scripts as part of the enhancements.
- Migration of the data from text files to SQL Server database using BCP and SSIS packages for the processing of different policies.
- Designed and implemented Parameterized and cascading parameterized reports using SSRS.
- Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
- Developed reports using SSRS and published as PDF, Excel, and CSV formats.
- Created Business Intelligence reports on a periodic basic for different facilities based on the business requirement
- Perform database consistency checks at regular intervals.
- Used Microsoft Visual Source Safe for version control.
Environment: Microsoft SQL Server 2008, SSIS 2008 , SSRS, T-SQL, VB Script, VSS,ETL.
confidential
SQL Developer
Anti-money laundering AML is used by financial institutions like Northern Trust to analyze customer data and detect suspicious transactions. It filters customer data, classify it according to level of suspicion and inspect it for anomalies. If the customer data/transaction is suspicious then the system will alert the relationship managers RM to fill the Customer Risk Form CRF for that particular customer/client. The risk evaluation for the client/customer is based on the key risk factors like Client type/Entity type, Geography, Products and Services, Transaction History/Expected Transactions, Client Screening Politically Exposed Persons PEPs and other government sanctions .
Responsibilities:
- Worked in a team of Ten, Involved in development, enhancement, testing and performance tuning of the application
- Extensively used ADO.Net to interact with the SQL Server database.
- Participated in meetings with Business Partners Business Analyst for development of the application.
- Developed stored procedures, functions and database triggers. Executed SSIS packages to populate data from the various data sources.
- Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008.
- Experience working with Crystal Reports Mainly conversion to SSRS reports.
- Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services SSRS .
- Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures SQL scripts as part of the enhancements.
- Perform database consistency checks at regular intervals.
Environment: Microsoft SQL Server 2008, TSQL,SSIS,ETL SSRS,Crystal Report,ADO.Net, .Net framework 2.0.
confidential
Role: SQL Server Developer
Project Description: There was no existing system to maintain the consultant timesheet. The consultants send their timesheets either by Fax or by email. This project goal is to maintain and manage the consultant timesheet and the invoices using a proposed system called TIMS. This system enables the consultant to upload their timesheet and maintain their weekly, bi-weekly and monthly hours online. And also TIMS helps preparing invoice to the clients.
Responsibilities:
- Involved in meeting with management for requirement gathering and analysis.
- Created the SSIS packages for extracting data from OLTP to OLAP.
- Created reports using SSRS i.e. Parameterization, Drill Down, Drill Through, Sub Reports, Charts, Table.
- Scheduled the Reports to run on daily and weekly basis in Report Manager and also sent email to analysts to review in Excel Sheet.
- Design database schema using SQL Server 2008.
- Creating and developing database object such as tables, indexing columns and setting constraints.
- Writing complex SQL queries using merge statement, multiple joins, sub queries and recursive queries.
- Creating multiple views for SSRS report.
- Writing SQL stored procedures, user define functions, triggers and cursors.
- Maintaining TIMS database system.
Environment: SQL Server 2008, T-SQL, CSV, Excel, TFS, SQL server report manager, SQL Server Management Studio. Asp.Net,JavaScript,CSS,HTML
confidential
Role: SQL Server Developer
Project Description: The major modules that should be covered in the system are Admin module, customer information management, order management cart management and payment system , back office group, fulfillment group and shipping. This main objective of this web site is to partially fulfill the eBusiness. This project consists of admin module. The product quantity and material price details are maintained by admin. The admin will maintain all the employees and the registered members' details. They can also post their doubts to all other employees or to a particular employee and reply to other employees' doubts. The admin can take back up of all data stored in the database. The Back office Group users should be able to manage the customer's order. They should be able to solve the customer issues with the available data. They can also change/cancel the order based on the customer's request.
Responsibilities:
- Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2005
- Design database schema using SQL Server 2005.
- Creating and developing database object such as tables, indexing columns and setting constraints.
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
- Creating multiple views for SSRS report.
- Writing SQL stored procedures, user define functions, triggers and cursors.
- Extensive knowledge in performance tuning.
- Developing various reports based on the business requirement using SSRS tool and BIDS environment.
- Design, Deployment and Maintenance various types of reports using SQL Server 2008, SSRS and BIDS
- Understand and identify queries behavior by SQL Profiler and resolving it.
- Technical Analysis, Code Review, Implementation
Environment: SQL Server 2005 and 2008, Business Intelligence Development Studio BIDS , SSRS, T-SQL, CSV, Excel,VSS.
confidential
Role: Software Developer
Project Description: The main aim of this project is to computerize the operations across the factory. This module deals with computerizing activities involved is sales order processing. The different activities are: Receipt of enquiries from customer, Receipt of sales orders from customers, Allot stocks for sales orders, maintaining customer's database. Maintaining products database and product inventory.
Responsibilities:
- Analyzed the architectural design for online contract and payment information.
- Design database schema using SQL Server 2005.
- Design the Data Access Layer and Business Layer and coded for those layers using C , Entity Object.
- Develop application using ASP.NET, C , JavaScript and Ajax.
- Design the dashboard information using CSS, XHTML to make the screen look and feel better.
- Prepared functional and system design using Microsoft Visio.
- Involved in writing Ajax to perform the screen well with no post back.
- Invoked multi threading to compare multiple images at a time
- Responsible for creating prototype application
Environment: Net frame work 2.0, COM, ADO.NET, C ,VB.net,Ajax, Entity Object Visual Studio 2005, MS SQL Server 2005.