PROFESSIONAL SUMMARY:

• Over 7 years of IT experience as a SQL BI developer that includes migration of data and reports using SQL server 2012/2008R2/2008/2005 and Visual studio 2010/2008.
• SQL/SQL BI Developer in various industrial domains such as Finance, Insurance, and Health Care.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2008 R2/2012 with expertise on data normalization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) specially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Good understanding in Database and Data warehousing concepts (OLTP & OLAP).
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008 R2/2012 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.
• Widely used VB scripts in the script task in SSIS packages.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little .

TECHNICAL SKILLS:

Database: MS SQL Server 2012, 2008R2, 2008, 2005, MS-Access.

SQL Server Tools: SSIS, SSRS, SSAS, SQL Profiler, SQL Server 2005/2008/2008 R2,SQL Server 2008 Management Studio, DTS, Sql Server Business Intelligence Studio

Tools: Microsoft Visual Studio 2010/2008, Share Point Server 2007, Microsoft Project Server 2007.

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools: SSIS (SQL Server Integration Services), DTS

Languages: C, C++, C#, T-SQL.

Operating System: Windows 8.1/ 8/7/Vista/XP/ NT/2000, DOS, Windows Server 2003/2007.

PROFESSIONAL EXPERIENCE:

Confidential

SQL/ BI Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2008 and Dashboard report using PPS.
• Identified the data source and defined them to build the Data Source Views.
• Developed query for generating drill down reports in SSRS.
• Designed and implemented stylish report layouts.
• Generated reports using global variables, expressions and functions for the reports.
• Identified and worked with parameters for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for transferring the data using SSIS packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications and implemented different types of constraints on tables.
• Used ETL tool to communicate with the many different relational databases and read the various file formats used throughout in the organization.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Managed index, statistics and optimized queries by using execution plan for tuning the database.
• Improve performance in inserting and then fetching the data from database objects by using partitions function and schema in database objects.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler and monitored scheduled jobs and alerts.
• Optimized the performance of TSQL queries and work in job scheduling and alerts.
• Analyzed and designed disaster recovery and replication strategies based on business requirements.
• Created Reports for Company budget like ledger report, transaction summary listing, made receipt & payment report.
• Involved generating reports like profit & loss statement and balance sheet statement for client.
• Identified and defined Key Performance Indicators (KPIs) in SSAS.
• Created complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models and developing reports using MDX and SQL in SSAS.

Environment: MS SQL Server, T-SQL, SSRS, SSIS, SSAS, Microsoft Office Excel

Confidential, Virginia Beach, VA

SQL/ BI Developer

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Sharepoint Server with SSRS and deploying SSRS reports on to Sharepoint Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Migrate reports from Dev to Production
• Provide on call support after reports are deployed to production
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL Server 20 R2, SSIS, SSRS, SSAS, OLAP, OLTP Performance Point Server, SQL Server Business intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL.

Confidential, Conshohocken, PA

SQL/ BI DEVELOPER

Responsibilities:

• Involved in Planning, Defining and Designing information focused around business necessities and gave documentation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, client characterized information sorts and capacities in SQL Server.
• Designed SSIS Packages to concentrate, exchange, load (ETL) existing information into SQL Server 2005/2008.
• Experienced in improving and sending the SSIS Packages from advancement server to generation server.
• Experience in utilizing distinctive changes like fluffy lookup, inferred section conversions and so forth in SSIS reports.
• Extensively planned the bundles and information mapping utilizing Control stream assignment, Sequence compartment errand, Data Flow Task, Execute SQL Task, Data transformation undertaking, Derived Column errand and Script Task in SSIS Designer.
• Perform unit testing at different levels of the ETL.
• Understanding the OLAP handling for changing and keeping up the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube in SSAS.
• Querying and controlling multidimensional solid shape information through MDX Scripting in SSAS.
• Excellent information in making reports utilizing SSRS.
• Migrated SSRS 2005 reports into SSRS 2008 reports.
• Involved in making various types of reports like plain reports, grid reports, sub-reports, penetrate down reports and so forth and conveyed them to the report administrator utilizing SSRS.
• SSRS experience with far reaching report improvement experience, dash sheets and advancement of 3d shapes for reporting.
• Done execution tuning to improve the run time.

Environment: SQL Server 2008 Enterprise Edition, SQL, Enterprise manager, Crystal Reports, UML, VB.NET, MS PowerPoint, MS Project, Oracle.

Confidential, MD

SQL Server Developer

Responsibilities:

• Used SQL Server Analysis Services (SSAS) 2008.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008.
• Created complex reports using Gathered requirements from the business users, created technical specification documents.
• Created/modified SQL Joins, subqueries, and other T-SQL implement business rules.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2008.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005).
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes SSRS 2008 from the OLAP cubes for end user analysis.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.

Tools: and Technologies: MS SQL Server 2008R2, SSRS 2008, SSIS 2005/2008, SSAS 2008SSMS, T-SQL, Oracle, Access and Excel

Confidential

SQL BI Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integration Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Perform unit testing at various levels of the ETL.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSRS).
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in Report writing according to business requirement using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Designed and created the table schema and stored procedures that will be used in Data QC.

Environment: SQL Server 2005/2008, MS Access, SSRS, SSIS, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.