Name: VINAY
Location: CA
Available Immediate
Open to relocate
Professional Summary
· Highly experienced Business Intelligence Professional using SQL server 2005 and 2008 offering over 7 years of commercial experience working for various organizations within several industries such as health, manufacturing, supply chain management, banking, retail and private
· Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS)
· Diagnosed query optimization, client/server connectivity, and running database consistency checks using DBCC Utilities
· Developed database objects such as tables, views, stored procedures, triggers, row-level audit tables, cursors, indexes, user-defined data-types, functions, constraints
· Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
· Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
· Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP
· Experience in Database Backup and Recovery
· Debugging Stored Procedures, Views, User Defined Functions and Triggers
· Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon
· Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects
· Experience in writing Multidimensional Expressions (MDX) and used the MDX queries in the report generation
· 4+ years’ experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services, (SSRS)
· Experienced in Development and Deployment of Reports (Tabular forms, Matrix (Cross Tab report) form, Conditional, List Items, Charts and Sub Reports) using SSRS
· Experienced in SharePoint providing central management, governance, and security controls for implementation of project requirements
· Experience with software development life cycle (SDLC) and project management methodologies.
· Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements
· Possess excellent management skills of outstanding decision making with excellent verbal and written communication skills
· Supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients
Technical Skillset
RDBMS/Data Access | MS SQL Server, SSIS, SSRS, SSAS 2005/2008 R2 |
Development Tool | BIDS, SSMS, VSTS 2008/2010, Report Builder 2.0/3.0 |
Language | C#, VB, C++ |
Reporting Tools | SQL Server 2005/2008 /R2 Reporting Services, Report Builder 2.0/3.0, Excel |
Web Technologies | ASP.NET, JavaScript, HTML , XML, XSLT, SOAP, WSDL, CSS, Web Services, Ajax |
Source Control | Source Depot, CVS |
Operating Systems | XP, Vista, Server 2003/2008, window 7 |
Regards,
Rao
Key Business Solutions, Inc.
|| Phone: 916 668 9539|| Fax: 916 646 2081 || || Email: rao@key-soft.com || Website: www.key-soft.com ||
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
P 7 Ways You Can Easily Save Paper and Avoid Killing the Environment
