View Bench List Portal

Similar candidates

• Naveen Mandala
• James Edward Doughty Jr
• Jenyl
• Durga Prasad
• Rajesh Babu
• Dan Stevens
• Prafull Joshi

ü  7+ years of IT experience as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2000/2005/2008/2012/2014.

ü  Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014forboth OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS)

ü   Experience inSDLCmethodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing andImplementation of client-server based applications.

ü  Experience in database programming in writing Stored procedures, User Defined DataTypes ,Triggers, Constraints , Indexes, CTEsandBatch Scripts using T-SQL/PL-SQL

ü  Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.

ü  Excellent knowledge of performance tuning in tuning stored procedures, Queries using tools like  SQL Profiler, Database Tuning Advisor, Execution Plans, DMV’s and Efficient  coding standards.

ü  Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, ConditionalSplit, Bulk Insert, merge and union all etc...

ü  Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.

ü  Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for   Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.

ü  Highly experienced in full   cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.

ü  Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, NormalizationandDe-Normalization techniques for both OLTP and OLAP systems.

ü  Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS2005/2008/2012/2014 across various environments.

ü  Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014) and Excel Pivot

ü  Created SSRS projects and reports in BIDS, sortand toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.

ü  Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized(Cascading parameters), TopN, Summary, OLAP, cross tab, linked  and sub reports and filters, charts in SSRS 2005/2008/2012/2014.

Extensive experience in SQLServer Analysis Services OLAP Cubes, and Data Mining