SUMMARY

• 7+ years of strong experience in the IT industry with expertise in OLTP, OLAP Databases and SQL Server 2000/2005/2008 development.
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Involved in optimizing code and improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup&recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQLMail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Created SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc and created various user roles (SSAS).
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• 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).
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, C, C#

Databases: SQL Server 2008R 2/2008/2005/2000/7.0 , MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2007/2003/2000 , Rally, JIRA, TFS

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. SQL Server/BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Team development, mentoring and planning for multiple projects in an agile environment.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created SSIS packages using transformations like conditional split, data conversion, derived column, lookup, join, merge join, sort, union all, multicast, slowly changing dimension, in SSIS as per the clients Requirement.
• Created SSIS packages for File Transfer from one location to the other using FTP task with MasterSSIS Package to run all other packages.
• Used Event Handling in SSIS to handle the event at package level and task level using on error, on warning and configured it using send email task and script task.
• UsedSSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future .
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitored Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Developed various types of reports like Drill down, Drill through, Sub reports, Chart reports and Multi parameterized reports using SQL Server Reporting Services 2008 R2.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and multidimensional expression (MDX) queries.
• Built MOLAP cubes for fast data retrieval and complex calculations.
• Designed SSAS Cube and developed MDX queries for Analysis.

Environment: SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, Carmel, IN

Sr. SQL Server/BI Developer

Responsibilities:

• Performed data conversions from flat files into a normalized database structure.
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Actively involved inPerformancetuning usingSQL ProfilerandTuning Advisor.
• Responsible forQuery OptimizationusingExplain Plan.
• Created SQL Server Agent job for daily load of data.
• Created Various Triggers and Alerts for successful or unsuccessful completion of scheduled Jobs
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Created packages to convert flat file to XML file.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Configured mail tasks to know the job status of SSIS packages.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications
• Defined MDX scripts for querying the data from MOLAP cubes (SSAS) and build reports on top of cubes.
• Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports

Environment: SQL server 2000/2005/2008 , SQL Query Analyzer, SQL profiler, IIS 6.0, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2008, MS Access.

Confidential, Dallas TX

SQL Server/BI Developer

Responsibilities:

• Installed and configuredSQL Server 2008.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• DeployedSSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• DevelopedDatabase Schemas / Stored Procedures / Data Dictionary.
• Designed and developeddata visualization strategies.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Experience and advanced knowledge of Kimball Methodology for Data Warehousing.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
• Deployed the SSISpackages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• UsedXMLA protocol for SQL Server Analysis Services2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.
• Created adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.

Environment: MS SQL Server 2000/2005/2008 , MS Access, Windows 2000/2003, VB.NET, ERWIN, XML, SQL Profiler.

Confidential, Christiansburg, VA

SQL Server/BI Developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Wrote SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Deployed SSIS packages and Reports to Production Servers.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Participated in Databases Architecture and data modeling design.
• Performed DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development teams
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential, Pleasanton, CA

SQL Server/BI Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Development and Production Environments using SQL 2005.
• Experienced in Tuning and Optimization of T- SQL stored procedures.
• Built and maintained complex SQL queries using T-SQL for data analysis, data mining and data manipulation. Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Extensively used Execution Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Involved in Implementation of the application at the client site. During this tenure involved actively in BUG fixing of the modules that are being implemented.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Used the SSIS package to write the data from the flat files, MS Excel, Oracle and DB2 into SQL Server tables.
• Optimized the current ETL process, identifying and eliminating bottle necks and decreasing data latency. Created synchronized mechanism for data management in SQL Server. Set the job dependencies of SQL jobs using MSDB objects.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages.
• Met department heads and end users to discuss legacy reporting, to gather requirements, design specifications, data mapping and develop new reports using SQL Server Reporting Services (2005).
• Created reports using SQL Server Reporting Services according to user requirements.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Generated the Reports with all the subcategory Information to Business users.
• Deployed and Scheduled the Reports in Report Manager.
• Created Snapshots and Subscriptions to deliver large reports on schedule basis.
• Created Ad Hoc Reporting frame work created to reduce time and large pool of reports design.
• Wrote MDX queries and involved in OLAP Designing.
• Documented database architecture, system processes and procedures. Create, review and produce migration scripts of database objects from development to production environments.

Environment: Windows 2003 Server, MS SQL Server 2005/2000, SSRS, SSIS, SSAS, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in Normalization of database.
• Created new tables, views, indexes and user defined functions.
• Designed the database to fasten certain daily jobs and some stored procedure.
• AdministeredSQL Server by creating users & login IDS with appropriate roles & grant privileges to users and roles.
• Involved in performance tuning of TSQL queries and Stored Procedure.
• Optimized query performance by creating indexes.
• Migrated DTS packages to SSIS.
• Performed daily database backup & restoration and monitored the performance of Database Server.
• Created 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.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Used the SQL Analyzer and Profiler for studying the SQL statements and procedures.

Environment: MS SQL Server 2000/2005, Enterprise Manager, T-SQL, DTS, Windows2003, Query Analyzer, SQL Profiler.