PROFFESIONAL SUMMARY:

• 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008R2 /2005/2000 with various business domains like Healthcare, Insurance, Finance and etc.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2008.
• Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions, synonyms, collections, Exception handling, Query Tuning using query optimizer.
• Experience in writing T-SQL objects, stored procedure in SQL Server 2005 to SQL Server 2008.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in data administration activities for database security creating logins, users, roles and assigning permissions to them
• Experience in performing administration tasks like database files management, backup/restore security management, database mirroring and synchronization.
• Experience on high availability SQL server solutions, including replication modules snap shots/transactional and SQL Server clustering active-active, active-passive
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Expert Knowledge of Integration Services SSIS , Reporting Services SSRS and Analysis Services SSAS . Worked Extensively on ETL process using SSIS packages.
• Experience in using tools like SCM, VSS and CVS.
• Experience in using tools like NEXSURE, A tool used for front end access in insurance firms.
• Proficient in using Team Foundation Server TFS .
• Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT Dimensions tables and Logical Physical data modeling using SSAS and Teradata.
• Excellent 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, Conditional Split, Bulk Insert, merge and union all.
• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP Bulk Copy Program and DTS Packages.
• Migration of SSRS reports from SQL 2005 to SQL 2008. Migration experience with DTS to SSIS 2008. Extensive experience with data modeling techniques, logical and physical database design.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart, and Sub Reports and formatting them using both SSRS 2005/2008.Very good knowledge in scheduling and deploying reports on report manger.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Skilled in Analysis Services OLAP cube and view development in SSAS 2005/2008.
• Experience in using cognos / Microstrategy business objects for reporting. Worked in OLTP OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements. Involved on administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, File groups, Transaction logs, Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re-Indexing. Designed business object reporting solutions on top of SAP integrationkit : web space intelligence X Celsius and crystal reports. Designed universes from multiple data providers by creating prompts , queries ,applied context and aliases to remove loops. Published crystal reports in web based environment using crystal enterprise

TECHNICAL SKILLS:

Databases MS SQL Server 2012, 2008 R2, 2008/2005/2000, Oracle 8i/9i/10g, MS-Access 97-

2007

ETL Tools SQL Server Integration Services 2005/2008 , Data Stage, DTS

Operating Systems Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

Reporting Tools SQL Server Reporting Services SSRS , Crystal Reports 8/10

Programming Languages C , C, C , VB.NET, Visual Basic for Applications VBA and ASP.NET.

Database Tools MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor DTA

Other Tools Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize.

Version Control Tools Visual Source Safe 6.0, Source gear Vault, SVN, and TFS.

PROFFESIONAL EXPERIENCE:

Confidential

Role: Sr. SQL Server /BI Developer

Confidential offer a wide variety of property and casualty insurance and surety products and services to businesses, organizations and individuals. Products include automobile, homeowners, umbrella, condominium, tenant, flood, identity theft and boat.. The project involved to maintain central SQL Server database to promote teamwork in the sales and service of the Wells Fargo's customers for better servicing the customer relationship.

Responsibilities:

• Extensively worked on designing reports using SQL Server Reporting Services SSRS .
• Created ETL packages with different data sources SQL Server, Flat Files,Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Established and documented a complete Disaster Recovery Plan for the Database servers as a proactive team member.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Developed standards and guidelines to maintain develop and administrate the SQL Server database.
• onverted various SQL statements into stored procedures thereby reducing the number of database accesses.
• Proficient in creating queries in TFS to validate results of TFS reports.
• Customized Microsoft's Team Foundation Server according to the company's requirements.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Installed and configured report server in Dev and UA environments.
• Migrated DTS packages to SSIS Packages in 2005.

Environment: SQL Server 2008, NEXSURE, MS SQL Server Reporting Services SSRS , MS SQL Server Integration Services SSIS ,Team Foundation Server TFS , Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling.

Confidential

Role: Sr. SQL Server SSIS/Crystal Report Developer

Confidential is a private company headquartered in Confidential . The company owns many stores in and around Philadelphia, Confidential. The company works hard to offer customers with the highest level of satisfactionby offering quality products and services. The company has huge database including employee, product and customer information. The project was Database Management System. In that they want to manage their seasonal promotion, sales information and product details.

Responsibilities:

• Worked in AGILE environment using SQL Server 2012.
• Worked as team lead for an offshore team from India.
• Created database objects like tables, complexStored Procedures, Functions, Views, Triggers,Indexes and T-SQL queries DDL and DML to meet the business requirements using T-SQL.
• Worked on support, resolve any production data quality issues and also supporting any research requests.
• Createdfunctions and developedprocedures for implementing application functionality at the database side for performance improvement.
• Created and Modified T-SQL stored procedures for validating the integrity of the data.
• Hands on MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC using SQL Server Profiler, Execution Plan and Performance Monitors.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
• Experience in providing Logging andError handling by using Event Handler and Custom Logging for SSIS Packages.
• Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow of SSIS package.
• Hands on using tools like SCM, VSS and CVS.
• Gathered report requirements and document technical specifications.
• Pulling the data from T-SQL stored procedure to make the parameterized reports.
• Formatting the existing reports as well as creating new reports with different sources.
• Responsible for Full Report cycle including Authoring, Managing, Security and Generation ofreports.
• Worked on database security, Replication and Log shipping activities.
• Managing the security of the servers, creating the new logins and users, changing the roles of theusers.
• Backing up, Restoring system other databases as per requirements, and also scheduled thosebackups.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.

Environment: SQL Server 2012, T-SQL, Crystal Reports 2011, MS SQL Server Integration Services SSIS , Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling.

Confidential

Role: Sr. SQL Server SSIS/SSRS Developer

Confidential is headquartered in Confidential with an international office in the Confidential . Think Finance has been the leading innovator in financial services for the under banked. Think Finance brings a deep understanding of under banked consumers together with the industry's best technology and risk management platform to deliver a suite of next generation solutions.

Responsibilities:

• Worked in AGILE methodology using SQL Server 2008 R2.
• Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• Performed Data Modeling in the initial stages of the project.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables. Developed views using complex split week logics.
• Experience in writing VB scripts in script component task.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Built efficient SSIS packages for processing Fact and Dimensiontables with complex transforms and type 1 type 2 changes.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Involved in query optimization and performance tuning.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Implemented error handling in several existing Store Procedures using Try Catch blocks.
• Worked in SVN version controlling environment.
• Handled complex financial data and large databases.

Environment: SQL Server 2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling.

Role: Consultant, Operations SQL/SSIS/Crystal Report Developer

Confidential is a global leader in credit information and information management services. They also provide healthcare services to clients across the United Sates. I am a part of Confidential team. Our team helps clients with data management and reporting solutions to the monthly data we get from them.

Responsibilities:

• Performing DBA functions, installing, configuring and supporting database systems.
• Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service SSRS .
• Actively participate in gathering of user requirement and system specification.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and SSIS.
• Increased query performance necessary for statistical reporting by 25 after performance monitoring, tuning and optimizing indexes.
• Created/Maintained clustered/non clusteredIndexes for fast and efficient reporting process. Indexed views, dimensions and stored outlines for optimal performance.
• Check the performance of each and every query using SQL Profiler, Index Tuning Wizard and Estimated query plan optimize the performance tuning of SQL queries and stored procedure.
• Backups and Restoration / Database Recovery, Resource allocation / Monitoring
• Deployed SSIS packages and Reports toProduction Servers.
• Created Datawarehourse Cubes in SQL Server Analysis Service SSAS .
• Created partition table for very large database for good performance.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development teams
• Designed and developed OLAP using MS SQL Server Analysis Services

Environment : SQL Server 2008 R2/2008/2005/2000, Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2000/2003 Server, Visual Basic .Net, SQL Server Data Tools, Query Analyzer, SQL Server Profiler.

Role: SQL Server/SSIS / SSRS Developer

Confidential a comprehensive range of wireless and wire line communications services bringing the freedom of mobility to consumers, businesses and government users.

Responsibilities:

• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Installation, configuration of MS SQL Server 2005/2008.
• SQL server Upgrade from 2005 to SQL 2008.
• Merging 2 different versions of databases to one single database and upgrading to SQL 2008.
• Extensively involved in designing Logical and Physical of customer database.
• Data Warehousing using Data Transformation Services Package SSIS .
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.

Environment: MS SQL Server 2005/2008, Windows 2003 Server, SQL Query Analyzer, SSIS, TSQL, C ,ASP.NET.

Role: SQL Server Developer

Confidential is the global brand used by confidential insurance companies and underwriting divisions offering property, casualty, professional and specialty insurance products throughout the world. My duties focused on maintaining, and optimizing the existing databases designing and implementing new databases for various projects according to the requirements from clients monitoring database performance and growth, performance tuning, establishing and administering database security in development, testing, and production environments.

Responsibilities:

• Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2005 and ASP.Net.
• Implemented transactional replication among different servers to have high availability of the data.
• Created DDL, DMLscripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Done High Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources Excel, CSV, Oracle, flat files, Text Format Data .
• Developed multi-dimensional databases MDDB , OLAP cubes and data marts using SQL Server Analysis Services SSAS 2005 that stored and maintained the data.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed final verification procedure for SQL release to production environment.
• Documented all database changes, followed and enforced change and release management processes.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, MS-Excel, DTS, Visual Studio.Net 2005, Windows server 2003.

Role: SQL Server BI Developer

The Confidential is the largest media and entertainment conglomerate in the world in terms of revenue. The project involves creation of various SSIS packages and generating reports and scheduling reports for different SSAS cubes. Different report items like charts, sub reports and tables were also designed.

Responsibilities:

• Actively involved as a part of a team for gathering and analyzing the User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships
• Upgraded SQL Server 2000 databases to SQL Server 2005.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
• Created jobs using SQL Server Agent and generated SSRS SQL Server Reporting Services reports as a part of each job.
• Upgraded DTS Packages to SSIS Packages.
• Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
• Managed the legacy data in the data warehouse from various data sources.
• Created Indexed View to optimize query performance by facilitating easy user interface implementation.
• Documented different Stages of Data Transformation, procedures and scripts.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, T-SQL, DTS, BIDS, SSIS, SSRS, SSAS.

Role: SQL Server Developer

Confidential life insurance companies. Because of the strong investment lineage of Confidential is able to offer a comprehensive variety of products and services that suit the diverse needs and risk-return profiles of every investor. The Project started in 2003 with a life Insurance Plan .The requirement here was assisting building database and also modifying when required. Integrating different databases and finally giving report about the effective policies sales.

Responsibilities:

• Involved in Physical and Logical design of the databases.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Created and maintained Data Transformation Service DTS packages for migrating data.
• Scheduled Jobs for DTS packages.
• Used BCP/Bulk Insert to publish table output to text files.
• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
• Used all Declarative Constraints for maintaining Data Integrity.
• Created Views to restrict access to data in a table for security.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Auditing using triggers.
• Created schema objects, rules and granted roles to the users.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Monitored the Database Performance using execution plans and Index tuning.
• Involved in scheduling backups of databases and logs and restoring them when necessary.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 server, Windows NT 4.0.