Hi,
Kindly find detail summary of our Sr.SQL Server/BI Developer available for project in NJ ….You can call @ 732 649 1563 Or catch me Live on : venuk1983(Ymail/ Gtalk)……. Name : R B Location : NJ Relocation : NJ,NY,PA,DE & RI Available : Immediately Comm Skills: Excellent Face-2- Face : Yes SUMMARY · Over 8+ years’ experience in Information System Technology and Business, System Analysis, database design/development, Programming, development of MS SQL SERVER 2000,2005,2008, 2008R2, 2012 databases in on Production (24/7), Testing, Development/Staging. · Experience in Finance, Manufacturing, Health Insurance and Real Estate domains with expertise in MS SQL Server 2000/2005/2008R2, 2012 and Microsoft’s suite of products like SSIS, SSRS, SSAS * Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages. * Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012/2008/2005 · Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions and Triggers to facilitate efficient data manipulation and data consistency · Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files · Experience in creating SSIS packages, Errors handling, Event Handling, Precedence Constraints, Break Points, Check Points, and Logging. · Experience in creating various types of reports(table, chart and matrix report, web reporting by customizing URL Access etc.) using SQL server Reporting Services(SSRS) · Extensive experience of creating the Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab etc.) using SQL server reporting services 2005 and 2008 * Knowledge on SQL Partitions and SSIS Partitions SSIS packages. * Experience in Data Stage tool for dimensional modeling , Extraction, Transformation, Loading and multi-dimensional analysis * Designed solution designed documents and implemented the code according to that. · Extensive knowledge in Tuning SQL queries improving the performance of the Database. · Experience in creating SSIS jobs in SQL Server Agent, Alerts and schedule SSIS/DTS Packages. · Experience in writing the PL/SQL · Experience in developing complex store procedures, efficient triggers, functions. · Experience in using BI xPress enterprise tool. * Experience in Business requirement gathering, Analysis and Documentation of the requirements. * Worked extensively on modules Supervisor, Designing Dash Boards, Web Intelligence reports Desktop Intelligence Reports and Broadcast agent in Business Objects and Crystal Xcelicus * Experience on working full load, Incremental load, Change data capture, Slowly changing Dimension and data ware house concepts. · Skilled in building effective productive working relationships with co-workers. · Work well both individually and with others in team environments. · Honest, energetic, hardworking, and aggressive with excellent analytical and Organizational Skills. TECHNICAL SKILLS: · MS SQL Server 2012/2008R2,2008/2005/2000, MS Access, Transact-SQL (T-SQL), · SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Visual Studio 2005/2008/2010,DTS SQL Developer, ERWIN, Windows Server (2008, 2003, 2000), Windows PC (7, XP, 2000, 98, 95), MS DOS, Crystal Reports 10.0/11/2008,Report Builder, Adobe Photoshop 7.0/CS5/CS6, Adobe Flash, Windows Server- 2003/NT/XP/2000, Windows vista, Windows 7, Windows8 · PL/SQL, HTML, XML, C#, Visual Basic 6.0, VB.NET 3.5 EDUCATION & CERTIFICATIONS: Bachelors from Nagarjuna University Oracle Certification in 9Isql Kindly add [email protected]<mailto:[email protected]> to your mailing list.. Regards, Venu K Nixsol Inc Tel :(732)-649-1563 Fax :(732)-909-2424 [email protected]<mailto:[email protected]> (Y) : [email protected]<mailto:[email protected]> (Best way to reach me is via Email) [Description: View my profile on LinkedIn] < http://www.linkedin.com/in/venukbdm> Think Green: Please consider the environment before printing this e-mail.
