SUMMARY

• 6 plus years of excellent experience in the IT industry as a SQL Server/BI Developer.
• Proficient in MS SQL Server 2005/2008/2012 suite of products.
• Expert in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008.
• Expert in defining data source and building data source views.
• Highly experienced in design of logical and physical data modeling using Erwin data modeling tool.
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.
• Proficient in data loads, database integration/conversions, performance tuning and optimization.
• Proficient in creating calculated measures and dimensions members using MDX, mathematical formulas and user defined functions.
• Well-versed in creating OLAP with the use of Erwin.
• Strong experience in writing complex Stored Procedures, Triggers, Cursor, Linked Server Query, UDF, and other SQL Server objects using T-SQL.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Experienced in Using Performance Monitor/Profiler to solve dead locks/long running queries.
• Hands on experience in troubleshooting database issues.
• Expert in dealing with Alerts, Operators and Jobs through SQL Server Agent.
• Performed data migration between different versions of SQL Servers 2000/2005/2008.
• Worked on administration tasks such as data loading, batch jobs, data unloading, back up & Recovery, user and application table management, upgrades, creating databases/file groups/files/transaction logs.
• Capable of forming and maintaining positive and productive working relationships in internal/external team environments.
• Capable to deal with the team members smoothly by positive attitude and strong communication skills.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005/2000
• SQL Server integration Services(SSIS)
• SQL Server Analysis Services(SSAS)
• SQL server reporting Services(SSRS)
• BCP
• MS Office (Excel 2007/2003
• Windows Vista/XP/NT/
• Windows 7
• HTTP
• HTTPS
• XSLT
• IIS 6.0
• SQL
• C++
• T-SQL
• HTML
• ODBC
• DBCC
• ADO
• DTS
• MS Access 2000/97
• XML
• ER-Designer

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

SQL server BI Developer

Responsibilities:

• Created a drill down multi parameterized report using SSRS, created shared dataset and data source.
• Created a Cascaded parameterized and multi expression reports using Visual studio TFS for a version control, deployed reports to SharePoint site.
• Designed a report in SSRS with a functionality to interface report on a web-call and report viewer and render report in a new tab.
• Developed Complex parameterized Stored Procedure for a data pull, optimized the query based on the Estimated Graphical Execution plan; evaluated the performance for multi value variables to optimize the query by preventing Variable sniffing.
• Designed an SSIS package to carry out an image loading from Different Pharmaceuticals
• Generated a script in SSIS to parse out data about a file such as file modified date, file name rout path
• Generated a SQL script to pull a data from SQL Server and migrate the data over to a flat file, drop this file to a network location and automate the job for a daily drop using SQL Server Agent.
• Created data model for a Business requirement, designed a data cleansing and data loading, automate the job Using SQL Server Agent.
• Assisted in DTS package conversion to SSIS 2012 packages project.
• Designed an SSIS package to generate an Index file for Images loaded in a database to finally ingest index files into a Nautilus system.
• Implemented In memory table and used Column Store Clustered Index as a solution for performance gain.
• Developed a Report in Power View using Power Pivot and Tabular data models.
• Detail research on Performance tuning that includes diagnosing an offending process mechanisms, system tuning, query tuning and Index tuning also investigated the various Index access methods to best utilize indexes.

Confidential, Los Angeles, CA

SQL/BI Developer

Responsibilities:

• Involved in gathering and analysis of Business Requirements by interacting with end users.
• Front End was designed using VB 6.0.
• Managing all stages of the application from design, development and testing on both development & production environments.
• Involved in creating of T-SQL Stored Procedures, Triggers, View.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes and triggers.
• Various Reports were generated including the Purchase Order Form.
• UsedSQL ServerAnalysis Services 2005 for interaction between client application and instance of Analysis Services.
• Involved in Planning and Monitoring and creating reports in Performance Point Server.
• Involved in writing MDX queries for cubes and Performance optimization of MDX queries.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Environment: SQL Server2005 Enterprise Edition,SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Performance Point Server 2007

Confidential, St. Louis, MO

SQL/BI Developer

Responsibilities:

• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Conversion of the legacy systems data into MS SQL server using DTS packages.
• Designed databases for different projects and resolve database issues.
• Created SSIS Packages using SSIS for importing from Flat file, Excel and Oracle to SQL Server 2005.
• Designed and migrated all Data Transformation Services DTS Packages to SQL Server Integration Services and modified the packages accordingly.
• Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Was Involved in property and casualty Insurance (P&C) application in the development of new products based on a responsible underwriting policy, aimed at preventing the corresponding risks and reducing their impacts.
• For instance, this involves developing environmental and security audits for our industrial clients, or even offering specific healthcare or road safety services for individual clients.
• Worked on DTS Package, DTS Import/Export for transferring data from Database Addressed the Replication Issues.
• Created new replications, DTS packages to maintain high availability of the data between the servers.
• Generated different reports using MS SQL Reporting Services like Drill down, Cross Tab and sub reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to Manager and analysts to review.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Environment: MS SQL Server 2005, Windows 2003/2000 Server Edition, SSRS, SSIS, MS Visio 2003.

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Responsible for installation of SQL Server 2000 on Production Servers and also created new ODBC connections in Windows environment.
• Developed various database objects like Tables, Triggers, Views and Stored Procedures by using T-SQL.
• Responsible for transferring of the databases and database objects from Development to Production Server using DTS.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.
• Mentored team members to optimizing SQL queries.
• Responsible for development of complex reports by using Crystal Reports 8.0. Developed various Cross Tab Reports, Drill down, Sub Reports, and Parameter Reports by using Crystal Reports versions 8.0.
• Used SQL Server Reporting Services for developing various reports.
• Created the subscriptions for various reports. And also created Report cache and Report Snapshots for the fast and efficient reporting processes.
• Deployed and Scheduled the Reports in Report Manager.
• Ad Hoc Reporting frame work created to reduce time and large pool of reports design.

Environment: Crystal Reports 8.0, SQL Server 7.0/2000, SSRS, Excel, Query Analyzer Windows NT/2000 server & Professional

Confidential

SQL Server Developer

Responsibilities:

• Wrote user requirement documents based on functional specification.
• Involved in the design of logical and physical data models using Erwin.
• Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.
• Designed, developed and maintained the report updates.
• Tasks involved decision-making, manual approval, exceptional report handling and created a decline letter file for the outside vendor.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Perform database consistency checks at regular intervals.
• Planned, created and normalized the tables for the project.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Developed stored procedures, functions, views and triggers.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Environment: MS SQL Server 2000, Programming SQL, MS Visio, Windows 2000, T-SQL, HTML, DHTML, XML, UNIX/LINUX, RUP.