SUMMARY

• 7+ years of extensive IT experience as SQL Server and Microsoft Business Intelligence developer.
• Specialized as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services (SSIS, SSRS & SSAS).
• Proven ability to work independently and as an integral part of a team. Self - motivated with high attention to detail and strong communication skills.
• Expertise in analyzing, designing, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012/2008/2005 , SQL Server Integration, Reporting & Analysis Services.
• Extensive expertise in Insurance, Healthcare, Finance, Automobile sectors.
• Expertise in using T-SQL (DML, DDL).
• Involved in creating numerous database objects like tables, stored procedures, views, functions, indexes and constraints (Checks, Primary and Foreign Key).
• Involved in designing complex queries, stored procedures, triggers, and user defined functions using T-SQL.
• Well versed in OLTP/OLAP environment.
• Experienced in working with SSIS packages involving ETL process, extracting data from various sources (flat files, excel files, legacy systems) and loading into SQL server using Import Export Wizard.
• Experience in Transforming and validating data using Control Flow item and Data Flow Transformations.
• Involved in migration of DTS packages to SSIS (2005/2008/2012 ) and troubleshooting migration issues.
• Experience in creating SSIS package configuration, logging, scheduling, and error handling in SSIS packages.
• Experience in performance tuning in SSIS using row transformations, block and unblock transformations.
• Involved in installation, configuration, development, deployment of Reporting Services using SSRS 2012/2008/2005
• Experience in developing Ad-Hoc, drill down, drill through reports, parameterized reports, sub reports, linked reports using SQL Server Reporting Services (SSRS).
• Experience in building reports using Crystal reports.
• Expertise in scheduling and deploying reports and uploading files to a report server.
• Proficient in data warehouse design concepts, experienced in relational, multi-dimensional (Star) and snowflake, logical and physical data modeling and data mapping.
• Hands on experience in creating Cube in SQL server analysis services and edit various properties, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization.
• Good knowledge about administrative tasks such as data loading, unloading, scheduling backup, performance tuning, optimization, recovery.
• Excellent communication, analytical and interpersonal skills and ability to learn new concepts.
• Ability to work individually as well as in a team, quick learner and self-motivated.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP,2003/2008 Server, Windows 7

Databases: MS SQL Server 2005/2008/R2/2012,Access 97/2000/2003

SQL Server Tools: Management Studio(SSMS), Business Intelligence Development Studio(BIDS), SQL Server Data Tools (SSDT), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard

ETL Tools: DTS, SSIS, Informatica

Data Modeling: ERWIN, ER Studio, Enterprise Architect.

Languages: T-SQL, PL/SQL, HTML, VB.NET

Packages: MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

SQL Server Developer /SSIS/SSRS

Responsibilities:

• Created and maintained SQL queries and stored procedures.
• Created database objects like tables, views, synonyms, procedures, functions and database triggers to meet the business requirements using T-SQL.
• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2005.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate etc. for creating many SSIS packages.
• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
• Worked with different methods of logging in SSIS.
• Used SSIS 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.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Created packages in SSIS with error handling.
• Migrated all the packages to Test Environment and finally deployed from Test Environment.
• Designed reports using SQL Server Reporting Services (SSRS).
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Integration Service, SQL Server Reporting Services, T-SQL, VB.NET, Windows XP, Microsoft Visio, SQL Server Analysis Services, Toad, MS Excel.

Confidential, Atlanta GA

Business Intelligence / SQL Server Developer

Responsibilities:

• Involved in requirement gathering, design and development.
• Responsible for Dimensional modeling.
• Analyzed and designed software and database solutions.
• Developed reports using efficient data retrieval techniques.
• Involved in creating views to display only required information and to maintain privacy.
• Created triggers to validate consistent data entry into the database.
• Created SQL packages, stored procedures and functions using T-SQL commands.
• Wrote several complex T-SQL queries and created constraints to maintain data integrity.
• Involved in development and implementation of SSIS application solutions for various business units across the organization.
• Created SSIS package to transfer data between heterogeneous data sources.
• Transforming and validating data using SSIS Transformations and scheduled SSIS packages.
• Extensively used various SSIS control flow tasks like Loop Containers, FTP, Bulk insert task, Transfer job task etc. and different data flow tasks like Derived Column, Fuzzy lookup, merge join, Multicast, data conversion etc.
• Extensively used SSIS Data Profiler Task to profile target source systems (tables & views)prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing the table structures.
• Deployed SSIS packages across various Environments (Development/Test) using configuration files and variables.
• Worked on SSRS Reports, Sub Reports, Data Drill-Down, and Data sorting/grouping.
• Created several types of reports, such as bar charts, line charts and pie charts on data from cubes and SQL Server in Excel.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Formatted the reports using the Global variables and expressions.
• Developed multi-dimensional databases, OLAP Cubes and data marts using SSAS.
• Experience in using Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards and Score Cards.
• Involved in performance tuning of cubes, optimization of queries, to improve performance.
• Supported team on performance testing by extending work hours and on weekends.

Environment: MS SQL Server 2008, SSAS, SSRS, T-SQL, OLAP Services, MDX, Share point 2010, MS Access, ASP.NET, XML, Microsoft Source safe, Clear Quest, Export Data

Confidential, Boston, MA

SQL Server Developer/ Business Intelligence

Responsibilities:

• Created huge Stored Procedures, User Defined Functions, Views and Implemented the Error handling in Stored Procedures and SQL Objects and also altered existing stored procedures, triggers, views, indexes depending on the requirement.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in tuning the Stored Procedures.
• Called Complex Stored Procedures in SSIS Packages and SSRS Reports.
• Used Dynamic T-SQL to implement multiple processes with same code.
• Used joins and common table expressions to simplify queries involving multiple joins.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements.
• Worked on comprehensive backup and disaster recovery Strategies for SQL Servers.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Developed and deployed complex SSIS packages for extracting data from different sources.
• Implemented the concepts of Incremental Data Load and Slowly Changing Dimensions for updating and maintaining the history of the records.
• Designed many SSIS Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL.
• Worked on DTS/SSIS Package, DTS Import/Export Wizard for transferring data from heterogeneous database sources
• Extracted data from various sources like DB2, Oracle, Flat files, Excel Spread sheets and loaded in to Fact and Dimension tables of datawarehouse.
• Created and configured OLAP Cubes (Star Schema and Snowflake Schema) using SQL Server 2008 Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Knowledge in creating MDX codes to meet additional needs that are calculated from existing measures.
• Involved in generating SSRS reports for Forecasting Revenues based on the historical data.
• Created Ad-Hoc, Sub-Reports, Drill Down, Drill Through, Summary and Parameterized Reports in SSRS.
• Ensured project requirement and delivery with active interactions with end users

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), VB.NET

Confidential, Riverside, CA

SSIS/SSRS/SQL Server Developer

Responsibilities:

• Transferred data from various data sources systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS using.
• Created SSIS packages and scheduled the jobs to run automatically.
• Created SSIS Configuration files and logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created several KPI’s, perspectives, calculated members and used them in the BI application for analysis and reporting purpose.
• Responsible for Scheduling Jobs, Event Handling, Error Handling, Alerting and Maintaining SSIS packages.
• Involved in development, integration and creating reports.
• Created reports such as Drill down, Drill through, Sub-reports and Parameterized Report.
• Used subscription for delivery of reports to intranet company managers.
• Created several SSIS master child packages for loading data from various heterogeneous sources, cleaning data and populating the data marts.
• Collected business requirements from users and translated them as technical specifications for development.
• Created reports out of the views and developed OLAP cubes.
• Involved in daily data loading using Full and Incremental load into database.
• Created SQL and PL/SQL Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Experience in SQL joins, sub queries, tracing and performance tuning.
• Involved in trouble-shooting of reports in Authoring, managing, and delivery phases on multiple servers.
• Maintained Locks and performance of SQL Server.
• Used Notification services to generate error messages and mail them to the user.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, MS Excel, Window XP, Toad.

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development and deployment.
• Creating SQL Server stored procedures for clinical databases.
• Tuning and updating stored procedures according to the requirements.
• Created tables, relationships, constraints and wrote SQL Queries, views for preproduction and postproduction clinical data.
• Maintained the customer databases and tuning database instances.
• Worked with all database objects, including tables, cluster indexes, views, and procedures.
• Troubleshoot problems concerned with the databases, applications, and development tools.
• Implementing MS SQL Server Security and database Permissions.
• Worked on Data modeling, normalization, de-normalization, physical database design, and relational data models.
• Design and implementation of Backup & Recovery strategies.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio,.Net 2.0 Framework, SQL Server Profiler, SSIS, SSAS,SSRS, IIS, T-SQL, PL/SQL.

Confidential

SQL Server Developer

Responsibilities:

• Studying the business requirements, interacting with the client and preparing the detailed design document.
• Involved in installation and configuration of SQL server.
• Data gathering and importing into SQL Server Database.
• Created database objects like tables, user defined functions and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Used Indexes to enhance the performance of individual queries.
• Created clustered/non-clustered indexes on tables.
• Created joins and sub-queries for complex queries involving multiple tables.
• Testing and Tuning SQL query for better performance.
• Evaluate and monitor database performance and carry out maintenance duties such as performance tuning, backup, restoration.
• Analyzed database performance with SQL Profiler and Optimized Indexes to significantly improve queries.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows XP, MS Visio 2000, MS Projects 2000.