Sas Bi Developer Resume Profile
Recent Activity
- Successfully completed Boot camp training on SAS Business Analytics from SAS Institute INDIA Pvt. Ltd. The course included training on Base SAS, Advanced SAS and Business Intelligence BI tools.
- SAS Certified Base Programmer for SAS 9 Credential A00-211 scored 92
- SAS Certified BI Content Developer for SAS 9 Credential A00-270 scored 86
Professional Summary
- 9 years of technical experience working with SAS tools and Microsoft technologies.
- Can work on SAS Business Intelligence tools such as Enterprise Guide, BI Dashboard, Information Map, Web Report Studio, Microsoft Add-ins, Data Integration Studio, OLAP Cube etc.,
- Can write SAS MACROS and invoke already created MACROS.
- Can use basic SAS procedures like PRINT, CONTENTS, SQL, FREQ, SORT, FORMAT, MEANS etc.
- Worked on Microsoft technologies such as ASP.NET, C .NET, ADO.NET, Web Services, WCF, AJAX, SQL Server, Design patterns and other technologies such as VB 6.0, CSS, JavaScript and XML
- Implementation on MS SQL Server 2005/2008 with the use of stored procedures, triggers, views, cursors.
- Worked through the phases of Software Development Life Cycle SDLC requirement analysis, creating technical specifications, design, and development, Unit testing, UAT for various Internet and client-server applications.
- Implemented AJAX features using Telerik Controls to create flicker free UI.
- Self-motivated, excellent analytical, communication, interpersonal and presentation skills.
- Excellent team player and execute tasks under less supervision.
- Experience in XML related technologies: XML, DOM, SOAP and HTTP.
- Experience in Worked extensively on Web Controls and User Controls and HTML Controls using C .NET.
- Experience in developing N-tier Service Oriented Architecture SOA Enterprise Applications by creating and consuming web services as well as WCF Services.
- Extremely focused and able to quickly identify and respond to priority issues.
Technical Skill Set:
SAS | SAS Foundation, Macros, Enterprise Guide, BI Dashboard, Information Map Studio, Stored Processes, Web Report Studio, IDP, Microsoft add-ins, Data Integration Studio, OLAP Cube |
Programming Languages | Microsoft .Net Framework, ASP.NET 2.0 /3.5, C .NET 2.0 /3.5, ADO.NET, VB 6.0 |
Databases | SQL Server 2000 / 2005 / 2008 |
Web Technologies | Web Forms, Web Services, WCF Services SOAP, WSDL, AJAX, XML. |
Web Servers | IIS 6.0 |
Version Controller | CVS, Team Foundation Server, Microsoft Visual SourceSafe |
Other Tools | N Unit, FX Cop. |
Operating Systems | Windows NT/95/98/2000/XP/Windows 7 |
Confidential
SAS BI Developer
Confidential - This is an information consumer reporting application. This is a dashboard application for the sales department manager that displays the consumer information, products details, Orders placed by the consumer etc. It also displays multi-section reports for Sales Analysis, Product Analysis in Web Report Studio.
Responsibilities:
- Used SAS Foundation to create required datasets.
- Used Data Integration Studio to extract and transform data from source tables and to load them into new target table.
- Used Cube Designer Wizard from DI Studio to build a new cube with three dimensions.
- Used SAS Information Map Studio to build IMaps - one from target table and the other from OLAP cube.
- Used SAS Enterprise Guide to read data, prompt the user to select a value and create a graphical report.
- Converted the complete project into a SAS Stored process that will be used in SAS BI Dashboard with a custom graph indicator.
Environment: SAS Foundation, Macros, The Platform for SAS BI 4.3.
Confidential
Team Leader
Confidential Learning Environment is a leading provider of computer-based and e-learning instruction, assessment, and curriculum management product and services for K-12 Kindergarten to 12th grade educational institutions. PLE's extensive library of instructional material covers core learning objectives in key subjects complements or supplements classroom-based material and ensures curricula are aligned with local, state, and national standards. PLE's assessment tools also offer educators and parents a way to monitor each individual student's performance in key categories ensure that no child is left behind and prescribe personalized courses of supplemental instruction.PLE gives educators more power and performance to raise student achievement. Valuable feature and functionality enhancements include a new, intuitive user interface, streamlined workflows for teachers and administrators, and enhanced reporting capabilities.
Responsibilities:
- Understood the business requirement and the business flow from the PDC team.
- For authentication and authorization used WCF services.
- Written client side validation scripts in JavaScript language.
- Also used Bugzilla to upload the TDD Technical Design Document that provides the entire detail about the solution for the bug at hand .
- Implemented AJAX features for partial post back.
- Web Service, Controller, Entity, Data Access layer using C .net 3.5.
- Based on the prototype provided by the PDC team designed and developed the User Interface,
- Used CVS as version control for storing different versions of Source Code by branching them.
- Published the developed code in web farm.
- Provided support for staging fixes after Integration testing as well as System testing.
Environment: Visual Studio.NET 2008, ASP.NET 3.5, C .NET 3.5, SQL Server 2008, Enterprise Architect 7.1, XML, JavaScript, Microsoft Enterprise Library, CVS. N Unit, FXCop.
Confidential
Senior .Net Developer
Confidential Comcast Desktop Toolkit is a Customer Support application. It provides support and information to the Comcast customer about the Desktop Tool. The modules consist of Customer Account information, Family Plan, View current Order and Order history, Billing Order, Cable Card Pairing, Thomson Device Toolkit, Box flipping etc. A customer can view his account activities, add/delete a family member to his account, Order or configure a number to his account, track his item ordered with Comcast, fetch billing information by providing Order Id, View history of previous orders, pair a Cable Card with his device etc.
Responsibilities:
- Used Windows Communication Foundation WCF Microsoft's programming model to build service-oriented application which enables to build reliable solutions that integrate across platforms to transfer data between ESP and CDT.
- Created and consumed Web services in .NET using SOAP over HTTP to display data to the UI.
- Extensively used typed dataset to store and retrieve data in various layers.
- Involved in object orient analysis, design, coding and testing of overall system.
- Involved in developing UI Screen, Business Logic Layer and service layer.
- Implemented AJAX features using Telerik Controls such as Rad Grid, Rad Panel, Rad Window to get flicker free look and feel.
- Designed and developed the user interface web forms using C .NET 3.5 and implemented n-tier architecture.
- Developed the prototype based on the business requirement.
- Contributed to gather the requirement and understand the business flow from the business team.
- Consumed the java web services written in ESP product to fetch data from the database.
- Written client side validation scripts in JavaScript language and ASP.NET input validation controls.
- Generated detailed design document with sequence diagram and prepared use cases.
- Implemented asynchronous page refreshing using AJAX.
- Used Visual Studio Team Foundation Server as version control for storing different versions of Source Code.
- Completed code review and peer review.
Environment: Visual Studio.NET 2008, ASP.NET 3.5, C .NET 3.5, ADO.NET 3.5, Telerik Controls, Paint.NET, Enterprise Architect 6.5, XML, Team Foundation Server, Team Explorer, HTML, JavaScript, IIS 6.0
Confidential
.Net Developer
Confidential is a UPS employee savings plan where participants' tax-deferred contributions are invested and earnings are applied monthly to their accounts. Employees, both active and inactive, can withdraw money in the form of cash and/or UPS stock. application is delivered to replace the previous SunGard OMNI Plan system. The Thrift consists of six modules - Withdrawal, Batch Inquiry, Batch Process, Process Inquiry, Employee Inquiry, Adjustments.
Responsibilities:
- Involved in development of Business Logic Layer and Data Access Layer for the application and implemented business logic using C .Net 2.0
- Designed, developed, Unit Tested, Documented the UI using C .NET 2.0
- Integrated website with single sign-on system used in corporate network.
- Deployed web application to the production server and provided post Production Application Support.
- Implemented AJAX for asynchronous posting of part of page.
- Used ASP.NET 3.5 Provider model for membership, role, profile and sitemap.
- Used Microsoft Data Access Application Blocks DAAB for Data access.
- Designed and implemented global exception handler to log and notify unhandled application exceptions.
- Used Datasets, Data Grids, Details View extensively and write T- SQL for retrieval, insertion and updating Database SQL Server
- Created User controls to make web control page reusable in other ASPX pages.
- Created and consumed XML Web services using SOAP over HTTP.
- Created stored procedures, views, triggers, T-SQL queries in SQL Server 2005 for various reports by optimizing queries for better performance.
- Used SQL Server 2005 for generating reports using SQL server reporting services SSRS .
Environment: Visual Studio.NET 2005, ASP.NET 2.0, C .NET 2.0, ADO.NET 2.0, MS SQL Server 2005, XML, HTML, JavaScript, IIS 6.0.
Confidential
.Net Developer
Confidential is a web based task tracing tool that brings in transparency on the tasks status between onsite co-coordinator and offshore team. It tracks the allocation of new request / change Request to the team, duration required to complete a particular task, online approval/ rejection of completed tasks. Confidential maintains list of web-based tools used by the organization, which can be used by both administration and development team.
The features of the web based tools are:
- Create new requests
- Monitor work in progress
- Track request through its entire life cycle.
- Track the efforts spent.
- Generate reports
- Approve /reject completed tasks.
- Automate workflow.
Responsibilities:
- Designed and developed the application.
- Defined relationships in the tables in database.
- Programming and implementation.
- Tested, debugged and maintained software programs.
- Provided technical support
- User training.
Environment: Visual Studio.NET 2005, ASP.NET 2.0, C .NET 2.0, ADO.NET 2.0, MS SQL Server 2000, VB 6.0, COM.
Confidential
VB SQL Developer
Confidential
Workflow keeps track of the status of Insurance related documents like Cover Note, Endorsement, and Renewal of Insurance etc. Cover Note is a temporary substitute to the Insurance policy, provided to the customer who claims for Motor Insurance. Status taken care by Workflow are,
- Uploading customers from an Excel file to the software.
- Entering a document in the system.
- Allocating document to IOC processor to process it.
- Re-allocating document to some other IOC Processor in case of emergency
- Holding a document in case required documents are not received
- Marking a document discrepant automatically in case required documents are not match
- Posting a document
- Utilities like Tasks completed / Tasks pending are provided to check TAT of the user.
Various kinds of reports like, Cover Note Issuance, complete or partial status of a document, Pending Tasks, Pending Documents, User wise Documents etc, can be generated.
Responsibilities
- Assisting in Requirement study and analysis to assess system capabilities and areas of improvement.
- Assisting in preparing functional requirement specification and business requirement documents.
- Preparing test cases in excel sheets.
- Coding and unit testing prior to system implementation.
- Post implementation support involving user training and technical support
- Extensive usage of Stored procedures, views, cursors etc.
Environment: VB 6.0, MS ACCESS 2000, Crystal Report 8.0, MS SQL Server 2000, VB 6.0, COM
Confidential
VB Programmer
Description: This software is a complete solution for Export Documentation. Software facilitates generation of Proforma Invoice, Custom Invoice and Commercial Invoice. Documents like Bank Certificate BRC , FORM C, AREs, POE, Bill of Lading, Packing Lists, Bank Drafts, Advanced License, DEPB and DFRC can be easily generated from the package.
Responsibilities
- Programming and implementation.
- Tested, debugged and maintained software programs.
- Provided technical support
- User training
Environment: VB 6.0, MS SQL Server 2000, Crystal Report 8.0, COM.
VB Programmer
Description: This software takes care of complete payroll process for the organization. It creates and maintains all the information about the employee, provides a unique ID to a new employee, generates the salary slip, logs overtime of the employees.
Responsibilities
- Programming and implementation.
- Tested, debugged and maintained software programs.
- Documented the process flow
- User training
Environment: VB 6.0, MS Access 2000, Crystal Report 8.0, COM.
VB Programmer
This highly versatile, time saving self-sufficient software is capable of handling entire laboratoryprocedures in chemical plants and labs. This software facilitates total sample management, different kind of tests required in labs by using various formulae, different methods used for analytical tests performed in labs, standard operating / test procedures, various specifications, certificate of analysis various other detailed as well as summary reports optimum user-friendly queries.
Responsibilities
- Front-end developments using VB controls.
- Developed program specification.
- Defined relationships in the tables in database.
- Post implementation Support
- Tested, debugged and maintained software programs.
- User training.
Environment: VB 6.0, MS ACCESS 2000, Crystal Report 8.0, COM