SUMMARY:

• Over 8 Years of working experience as SQL Server Database developer in Financial, Healthcare, Insurance and Telecommunication domains.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle SDLC .
• Master in T-SQL Programming, SQL stack including SSIS, SSRS and SSAS.
• Experienced in RDBMS concepts, DDL, DML, constructing normalized and de-normalized tables, user defined functions, complex and dynamic stored procedures, views, triggers, synonyms, cursors and Indexes.
• Expertise working on Online Transaction Processing OLTP , Data Warehousing and Online Analytical Processing OLAP environments.
• Designed SQL Server database objects tables, stored procedures, functions and views to support outsourcing data integration SSIS , analysis, and various business processes.
• Experience in Importing/Exporting Data from various data sources like MS Access, Excel Files, Oracle, DB2, XML Files and Flat Files using DTS utility. Involved in ETL transformation of OLTP data to the Data Warehouse implementing all transformations using SSIS and SQL commands.
• Mastery in migrating DTS packages, deploying and scheduling SSIS packages as jobs using SSIS 2005/2008 as batch process.
• Experience in installing, configuring, developing and deploying reports using SQL Server Reporting Services SSRS . Created various reports like table, matrix and chart formats.
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users of financial and banking in SQL Server Reporting Services SSRS .
• Experience in designing Star Schema and Snowflake Schema with Facts, Dimensions, Measures and Cubes using SSAS for enterprise and insurance domains.
• Modified existing OLAP cube to extract historical data to support healthcare cost utilization analysis and actuarial reporting SSRS .
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Tuning poorly performing queries, long running queries by capturing the events through Profiler.
• Knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Experience in the Installation, Registration, Configuration, Database Backup/Recovery and Disaster Recovery procedures for MS Server 2000/2005/2008
• Designed and documented reporting and information management strategies for various industrial, financial, healthcare and insurance domains.
• Effective working as individual or as a cooperative team member with good communication and interpersonal skills.
• Domains: Software Enterprise, Insurance, Financial, Banking, Telecommunications, Healthcare,
• Consulting and Outsourcing.

TECHNICAL SKILLS:

• Databases MS SQL Server 2012, 2008, 2005, 2000, 7.0, MS-Access, Oracle, MySQL,
• DB2, Teradata
• Languages T-SQL, PL/SQL, XML, HTML, C, C , ASP.Net, C .Net, Java Scripting
• Server Tools Enterprise Manager, SQL Profiler, Query Analyzer, Export Import, DTS, Replication, SSIS, SSRS, SSAS, Management Studio
• Operating systems Windows XP/NT/2000, UNIX, DOS, Windows Server 2003
• Portal Server MOSS 2007, SPS 2010, SPS 2003, WSS 3.0
• Tools Microsoft Visual Studio 2003/2005/2008, MOSS2007, Informatica, Erwin

PROFESSIONAL EXPERIENCE:

Confidential

Report Analyst

Responsibilities:

• Interacted with Directors, VP and other Business Analysts to discuss the current business and future implementations
• Performed duties including the monitoring and maintenance of database software upgrades, backups, migrations, standardization and implementation of databases to improve the management of production and test environments.
• SSIS ETL tool is used for data migration, import and export and for generation of various forms of flat files that required for the business.
• Various SSIS package where developed and processed and schedule jobs through Server Agent
• Created jobs, alerts to run SSIS packages, SSRS reports periodically.
• Developed various SSIS templates for heterogeneous data migrations.
• Created the automated processes for the activities such as database backup processes in SSIS, Packages run sequentially using SQL Server Agent job.
• Retrieved and analyzed data using T-SQL, Excel, SSRS
• Developed multiple processes for Daily Reports using SSRS.
• Created various ad hoc report to meet the daily business requirement and for analysis purpose.
• Generated various types of drilldown, drill though, sub reports, tablix, matrix, charts and gauges reports based on the requirement that meets the various business logic and analysis.
• Improvised the business logic and implemented that logic by developing codes.
• Developed various report on the basis of daily, weekly monthly and quarterly etc.
• Created Dashboards in SharePoint 2007/2010.
• Integrated SSRS report with SharePoint 2007/2010.
• Migrated SSRS report from SharePoint 2007 to 2010
• Coordinated with Program Manager and Assistant Program Manager to ensure problem resolutions.
• Documented all the methodologies for end user reference.

Environment: SQL Server 2000/2005/2008/R2/2012, Windows Server 2003, Erwin, DTS, T-SQL, SSIS, SSRS, SSAS, SQL Profiler, Visio, MSO SharePoint 2007/2010, PowerPivot.

Confidential

SQL BI Tech Support / SQL DBA

Responsibilities:

• Interacted closely with Director of IT Revenue, Manager of Business Production Team, Vice president of Business Reporting Team, Business Analyst, Project manager and gathered and Peer Reviewed the Business Requirements, Software Requirement, Developing, Testing and Maintenance of data warehouse database, processes and services.
• Developed multiple processes for Monthly Reports using SSIS and MS Excel.
• Created SSIS packages to load data from different sources like Excel, Access and SQL Server.
• Written T-SQL scripts to meet the business logic and requirements.
• Supported the reporting team, troubleshoot and cleared the issues.
• Re-designed the Reporting process by creating new Databases and Schemas.
• Developed new objects i.e. Tables, Views, and Stored Procedures in SQL server 2008 database and performed tuning on it.
• Collected all the specs from different reporting team and develop the new process.
• Developed performance efficient stored procedures and transact SQL queries to pull the data into reports.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Tuning the database servers, when the user reports that a particular region is running slow.
• As per the client requirements, rendered the Reports in the form PDF, Excel and .CSformats
• Documented all the process with detailed Business Logic.

Environment: SQL Server 2008, Windows 7 Enterprise, T-SQL, SSIS, SSRS, SQL Profiler, MS Excel, MS Access.

Confidential

SQL BI Developer

Responsibilities:

• ETL tools used are SSIS, Informatics Tools and ODBC.
• Involved in SQL Server Reporting Services SSRS .
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Developed ad-hoc reports using Report Builder.
• Developed Report Model so that the end users can create their own reports using Report Builder.
• Developed various kinds of interactive reports like Drill Down reports, Aggregate reports, reports containing parameters and groups.
• Developed reports with Cascading Parameters, Sub reports.
• Developed Charts and Graphs reports.
• Developed reports using SSRS and published as PDF formats. Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Tuning the database servers, when the user reports that a particular region is running slow.
• Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading.
• Designed logical/physical data models and defined primary key, foreign key
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information As per business logic by using SQL Server Agent and windows Scheduler.
• Facilitate Silverlight knowledge-sharing and collaboration on user-generated BI solutions.
• Increase BI management efficiency.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler of RDL, DTS and RDLC.
• Migrated and recreated existing Dimensions and Cubes using Star schema to achieve the efficiency of SQL Server Analysis SSAS .
• Developed Multi-dimensional Objects Cubes, Dimensions base on regional wise using SQL Server Analysis Services SSAS

Environment: SQL Server 2000/2005/2008, Windows Server 2003, Erwin, T-SQL, DTS, SSIS, SSRS, SSAS, SQL Profiler

Confidential

SQL BI Developer

Responsibilities:

• Installed and Configured Oracle 9i, DB2 V8, Teradata and SQL Server 2005 along with SQL Server Business Intelligence Development Studio in new server.
• Gathered business requirements for creating the new mission-critical databases from business analyst, project manager, other internal employees as well as customer feedbacks.
• Collaborate on the global data architecture design and planning for the physical structure and implementation of data warehouses.
• Normalization standards to maintain data consistency and by performing data validation.
• Migration of all the databases from old servers to new server. Loaded stored procedures and user defined functions into the databases.
• Migrated SSRS 2005 reports to SSRS 2008
• Created subscriptions in Report Manager as an automated process to deliver the reports directly to the client end user as an email attachment.
• Developed reports from both relational databases SQL Server 2005/2008, Oracle and multi-dimensional databases SQL Server Analysis Services
• Worked with different report items like Tablix, Matrix, Charts etc.,
• Sub reports were created and called into Master report to show various parts of information on a single display.
• Migrated all DTS packages to SQL Server Integration Services SSIS and modified the package according to the advanced feature of SQL Server Integration Services.
• Converted Informatica mappings to SSIS packages using MS SQL BIDS.
• Migrated data from Heterogeneous Data Sources and legacy system DB2, Access, Excel to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools
• Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
• Created sub reports, bar charts and matrix reports.
• Developed and Deployed reports/report model using SQL Server Reporting Services.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: Informatica Power Center 8.1 Source Analyzer, Warehouse Designer, Transformations Developer, Mapplet Designer, Mapping Designer, Workflow Manager Worklets, SQL, Oracle 9i, DB2 V8, Tera Data, MS SQL 2005/2008, T-SQL, SSIS, SSRS, Windows NT.

Confidential

Business Intelligence/ SQL Developer

Responsibilities:

• Participating in weekly Systems and DB Meetings and updating the Project status to the Project Manager.
• Responsible for pushing data objects across databases to different working levels: Development -Test - Production.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data
• Co-ordinate with front end application developers to generate reports.
• Created scheduled SSIS packages from OLTP to various data warehouses. Also Migrated SQL 2000 DTS packages to SSIS packages
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Knowledge in documentation of backup and recovery strategies for production environment
• Developed Stored Procedures, Functions and Database Triggers.
• Developed various national wide revenue reports using reporting service SSRS as required.
• Involved in SQL Server Integration Services SSIS .Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Involved in troubleshooting of existing SSIS Packages.
• Worked on SSIS Packages, changes Structure of tables and created new Columns during transformation using SSIS packages.
• Experience in SQL Server Reporting Services SSRS .
• Creating new schemas and modifying the existing schemas based on the changes for the new development activity.
• Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading.

Environment: MS SQL Server 7.0/2000/2005, Windows 2000 Server, Windows NT Server, TSQL, SQL Server Query Analyzer, SSIS, SSRS

Confidential

SQL Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Extensively used reporting tool Web focus to create reports as per user requirements.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to MS Access, flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing and developing database.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.
• Extensively worked on star schema and snowflake schema.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Enterprise Manager, T-SQL, DTS, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.