PROFESSIONAL SUMMARY:

• 6 Years of experience in Testing of Database systems & Client/Server Application using SQL Server and BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in working with Visual Web Services, Visual Basic, VBScript, Jscript, XML, HTML, Database programming.
• Highly proficient in SQL Server 2005/2008/2008 R2 RDBMSdatabase development includingT - SQLprogramming.
• Well versed with developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T-SQL.
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
• Experience in client design and validations using HTML, Java Script, AJAX, and JSP.
• Good working skills in Performance Tuning, Query Optimization and Running Database.
• Experience in Up gradation of SQL Server 2005 databases to SQL Server 2008 by applying Service Packs and Hot fixes.
• Good experience with data loading and data loading methods like SQL*Loader and DB - links, Import Export and Data Pump.
• SQL Server 2008 OLAPdatabase development including KPIs, Data mining, working with changing dimensions.
• Strong experience in Microsoft Business Intelligence Tools including Integration Services, Reporting Services and Analysis Services. Configured report subscriptions both data driven and time driven.
• Good Knowledge in Full Life Cycle development of Data Warehousing
• Developed, monitored and deployed SSIS packages.
• Expert in Data Extraction, Transforming and Loading (ETL) implementation using SQL Server Integration Services (SSIS) inOLTP and Data warehouse Environment.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages
• Created complexDTS PackagesinSSISforData MigrationfromOracle/Access/Excel Sheets to SQL Server 2005/2008 andTransformation.
• Decent Working experience with Confidential 8.6.1.
• Worked on Data modeling, creating star and snowflake schemas in SSAS.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.
• Experience in Designing and Building the SSAS Cubes, Dimensions and data source views SSAS Data mining Models and Deploying and Processing SSAS objects.
• Sound knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
• Extensive experience in creating and managing reports using MSSQL Server 2005Reporting Services.
• Hands on experience in developing Custom reports and different types of Tabular reports, Matrix reports, Adhoc reports and Distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Good Working experience in developing different types of Reports in SSRS such as Cross-Tab, Drill-Down, Drill-Through, Cascading, Parameterized and Sub-Reports using global variables, expressions, functions and custom code.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Flexible, spontaneous, enthusiastic and project oriented team player with good communication and leadership skills to develop creative solutions.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2008 R2/2012, MS Access, Oracle

Languages: SQL, T-SQL, PL/SQL, C, C++

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL Tools: SSIS, BIDS, DTS and Confidential 7.1.3/8.x/9.1

Reporting Tools: SSRS, ProClarity, Report Builder 2.0/3.0, Crystal Reports and Excel.

Database Tools: Management Studio, SSAS, Visual Studio, Query Analyzer, SQL Profiler.

Other Tools: Erwin 7.3/7.2,Toad 10.5, SQL Developer, SQL *PLUS, SQL LoaderSQL Server 6.0:

Operating Systems: UNIX, LINUX, Windows XP/Vista/7/8

Scripting Lang: JavaScript, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SQL/SSIS and SSAS Developer

Responsibilities:

• Develop technical design documents and mapping specifications to build ETL Mapping to load data into target tables.
• Developed ETL packages with different data sources, SQL Server, Flat files, Excel source files, XML files and loading the data into the target tables by performing different kind of transforming using SSIS.Read data from Excel, CSV and text files which stored genes expression information into SSIS (SQL Server Integration Services)
• Involved in a complete SSIS life cycle in building, deploying and executing SSIS package using multiple transformations such as Conditional Split, Data Conversion, Merge Join, Lookup and derived column
• Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.
• Worked with C# to write different script tasks.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Deploying, Testing and Scheduling SSIS packages using SQL Agent.
• Provided technical expertise in data analysis, collection and documentation of metadata components and information delivery.
• Utilized T-SQL extensively in order to replace SSIS transformations in order to improve the performance of the packages
• Designed reports using MDX and the reporting wizard to produce Drill Down and Drill Through reports to provide custom views of the information for users.
• Involved in the creation of Tables, Table Partitions, and Indexes.
• Developed and maintained various cubes using MDX complex queries using SSAS.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
• Analyzed the requirements and selected the appropriate fact tables/created fact tables.

  Designed SSAS cube to hold summary data.

• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.

Environment: MS SQL Server2008, SSIS, SSAS, MS Office, Oracle 10g,MS Office 2007/2010, Microsoft Visio 2010, SQL Server Management Studio 2008 and 2012.

Confidential, CA

SQL/SSIS and SSRS Developer

Responsibilities:

• Involved in design of application framework using MVC(Model-View-Controller) guidelines and MS Visual Studio.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, and sub-queries to generate various reports.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User-Defined Functions.
• Experience in using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks and handling the Isolation Levels.
• Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.
• Worked on various work orders tofix and find solutionsto existing ETL code.
• Worked with the Business users and the data/system analysts to understand theBusiness rules and Business requirementsand updated the ETL code accordingly.
• Conducted SSIScode reviewmeetings and updated the ETL code after taking input from team members. Made sure that the code is in-line, with the set standards.
• I got a chance to work with the Finance team created files like General Ledger and files to people soft team for Account Payables Check's and EFT's.
• Got a very good opportunity to work on various correspondence parts by pulling out the data and generate letters for respective transactions on a policy.
• Worked on conversion loading the data from the client on to our dev regions cycling them and checking for the issues and fixing them, Running metrics for client on bi-Weekly basis.
• Automated the ETL jobs usingUC4 scheduler and purged the unused objects.
• Written and executedETL test casesas part of testing the code before migrating to Production.
• Analyzed the source data and decided on appropriateextraction, transformationandloading strategy.
• Integrated with the end users to gather requirements, plan, build, test, deploy, document and applychange control process.
• As part of theteam, implementedTest Driven Developmentby working with the SA/DA/Tester before the actual ETL development has started.
• ImplementedPair Programming,Code Reviews andUnit testingas part of Agile Methodology.
• Handled successful production code fixes with minimum/no impact to business.
• Hands on experience working with the UI technologies like HTML, JavaScript, JSF, JSP tag libraries.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2008.
• Created, Maintained & Scheduled various reports in SSRS like Drill down and Drill through & Parameterized Reports using SQL Server Reporting Services SSRS
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Created different reports using complex queries to create the datasets in SSRS
• Used expressions in SSRS for various reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any errors occurred during execution.

Environment: MS SQL Server2008, SSIS, SSRS, MS Office, Oracle 10g,MS Office 2007/2010, Microsoft Visio 2010, SQL Server Management Studio 2008 and 2012.

Confidential

SQL Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program and Interacted with Development Teams, Managers to analyze business needs and developed technical Servers.
• Migrated access objects to SQL Server 2005.
• Created tables, indexes and constraints.
• Created Stored Procedures, Indexes, Views, Triggers, Stored Procedures in T-SQL and DTS Packages.
• Provided the production support for the applications developed/maintained by views team.
• Establish guidelines for tuning of application code and assist the application development teams, Work directly with the Manager of Unix and Database Systems, performance tuning of heavy transaction oriented SQL statement.
• Developed batch programs for data load using SQL*Loader and shell scripts.
• Designed functional model of schema gathering customer interactions.
• Wrote database triggers in T-SQL to check the referential integrity of the databases.
• Defined stored procedures for module integrity and application.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan and scheduled Jobs weekly, monthly.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal reports.
• Preparation of project documentation.

Environment: SQL server 2000/2005, SQL Profiler, DTS, T-SQL, Win 2003, Crystal Reports 8.0

Confidential

SQL DEVELOPER

Responsibilities:

• Involved in this project to create reports using development methodologies like strategies, positions, patterns, development standards, integration, documentation, and testing to manage the product development lifecycle.
• Design Web pages using ASP, HTML, JavaScript, and CSS.
• Developed Web applications using ASP.NET and application logic using C#.NET.
• Extensively used and customized complex ASP.Net server controls like Data grids, Calendar and more.
• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS.
• Migrated access objects to SQL Server 2005.
• Created tables, indexes and constraints.
• Created Indexes, Views, Triggers, Stored Procedures in T-SQL and DTS Packages.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Defined stored procedures for module integrity and application.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Preparation of project documentation.

Environment: ASP.NET, C#, VB.NET, SQL server 2005, SSRS, SSIS, Visual Basic 5.0, Win NT, Crystal Reports 8.0.