PROFESSIONAL SUMMARY:

3 Years of experience in IT, as MS SQL Server Database Developer in Windows environment, current experience with SQL Server 2012/2008R2/2008/2005/2000.

Experience in Financial and Healthcare environments with primary skills on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.

Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS 2008.

Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services SSIS , Business Intelligence delivery using Microsoft SQL Server Analysis Services SSAS and Reporting solutions using Microsoft SQL Server Reporting Services SSRS .

Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.

Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008.

Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services SSRS , Report Model and Ad Hoc Reporting using Report Builder functionality.

Experience in Performance Tuning and Query Optimization.

Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.

Experience in creating and managing fragmentation of Indexes to achieve better query performance.

Experience in creating the MDX cubes and dimensions in SSAS.

Experience in using tools like Bulk Copy BCP , Data Transformation Services DTS and SSIS.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .

Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .

Worked on SharePoint development and scheduling reports using it.

Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

Technical Skills:

Professional Experience:

Description:

Sammons Financial Group, Inc. SFG is the parent of a group of member companies under the insurance Holding Company Act made up of several successful financial services companies offering a variety of financial and retirement products through multiple distribution channels including retirement products, annuities, variable annuities1, variable life insurance2, life insurance, including bank, corporate, and credit union owned life insurance. The member companies of SFG include North American Company for Life and Health Insurance , Midland National Life Insurance Company, including its divisions, Sammons Annuity Group and Sammons Corporate Markets Group, Sammons Securities Company , LLC.

Responsibilities:

• Worked with business system Analyst, Operational risk manager to understand the requirement clearly and to create reports.
• Involved in report development, testing and deployment.
• Created several Excel and report builder reports for mobile services Enrollment and Claims projects.
• Created ad hoc reports, chart reports, tabular and matrix and parameterized reports using Report Builder 3.0.
• Used BIDS to create parameterized reports.
• Used Microsoft SharePoint Designer to upload, download, manage data source, create web parts, web pages, folders, schedule reports daily, monthly, created report web parts to display them in .aspx format.
• Used SharePoint to schedule reports and send by email daily, monthly in different formats such as PDF, Excel, and CSV.
• Browsed the cube for analysis and validation of the data.
• Created several Excel reports using cube data.
• Used MDX to create enrollment and claims timestamp report.
• Worked on T-SQL programming, stored procedures and views in the process of developing reports.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.
• Developed reports in SSRS 2008 R2 and deployed reports into SharePoint Server 2010.
• Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
• Involved in regression testing, and optimization of the query.

Environment: SQL Server 2008 R2, SQL server 2012, Report Builder 3.0, Business Intelligence Studio SSAS, SSRS , SharePoint 2010, T SQL, MDX, MS Excel.

Description:

Leading organizations need to use technology to respond to business requirements and market opportunities quickly by overcoming aging, inflexible infrastructure. Moxtra Converge Infrastructure consulting services can help these organizations consolidate server, storage and network resources so that they can support any workload, anywhere, anytime. With a converged infrastructure they can provision resources dynamically and manage them as a service.

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Deployed SSIS packages and Reports to Production Servers.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources CSV files, oracle, and MS SQL 2000 and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Responsible for developing graphically rich dashboard reports on the Microsoft SQL Server 2008 R2 platform in a way that users can access, based on role or business function within the organization and user skill sets.
• Created Ad-Hoc reports in Query Studio in Cognos.
• Created Dashboards using Cognos connection like displaying Cognos navigator, Cognos search Cognos viewer in a single page.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS 2008 R2
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Created Report Models for Ad Hoc reports on different perspective.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2008 R2, SQL Server 2012, ECC, Prosphere, Cognos, Business Intelligence Studio SSAS, SSIS, SSRS , SharePoint 2007, T SQL, Erwin, MDX, MS Excel.

SQL Server Developer

The online project was mainly into design of multivalued stored procedures and performance optimization of database engine.

Responsibilities:

Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.

Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.

Generated T-SQL scripts for application development.

Created Stored Procedures and User Defined functions.

Created Indexes to speed up the queries.

Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedure.

Scheduled Jobs and Alerts using SQL Server Agent.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Developed Cubes using SSAS.

Environment: SQL Server 2000, SQL Server Query Analyzer, DTS, SSAS, SSRS, Crystal Reports, T-SQL, Windows 2000/XP