PROFESSIONAL SUMMARY

• Around 8 years of experience as MS - SQL Server Developer, involved in Design, Development and Support of MSSQL Server 7.0/ 2000/2005/2008/2012/2014 for both OLTP and OLAP Systems.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS in different fields like Banking, Sales, Insurance and Health.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization, De-Normalization and building Referential Integrity Constraints.
• Extensive noledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes(i.e., Clustered and Non Clustered), Data Import/Export, Triggers, Functions, Sub Queries, Cursors.
• Thorough noledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Extensive experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, flat file, and Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2008/2012.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Scheduling the SSIS packages and Jobs.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, defining data source and subtotals for the respective reports using SSRS 2008R2/2008.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in SSRS reports - Report Services integration and deployment, Subscription.
• Very well aware of the changes made to Configuration files and deployment models and other changes in SQL Server 2012.
• Experience in deploying packages to Integration Services Catalog in SQL Server 2012.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Proficient in using Multi-Dimensional Expression (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Good noledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Ability to grasp and work in new technologies quickly.

TECHNICAL SKILLS

Database Technologies: SQL Server (2000, 2005, 2008,2008R2,2012,2014), MS-Access

Programming Languages: SQL,T-SQL, HTML, HTML5, CSS, XML, C, C++, C#

Business Intelligence Tools: MSBI (SSIS, SSRS & SSAS)

IDEs /Tools: MS Visual Studio 2012/2008/2005/2000, SSMS

Other Tools: MS Office Suite (Word, Power Point, Visio), OLAP, OLTP, Erwin

Operating Systems: Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/2012 Server

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

Reporting Tools: SQL Server Reporting Services (2012/2008/2005/2000), Microsoft Access 2013, Excel

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

BI/SSIS/SSRS Developer

Responsibilities:

• Analyzed specifications provided by the client.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Used Temporary tables, Table variables and Common Table Expressions (CTE) depending on the requirement.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Worked on Performance tuning, query optimization and execution plan of queries for better performance.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Flat file, Excel, Oracle.
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• 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.
• Extensively used SSIS for Transformations, Aggregations and Lookups.
• Monitored the data warehouse system to maintain periodic data.
• Scheduling the SSIS packages and Jobs.
• Experience in Ralph Kimball and Bill Inman Methodologies (Star Schema, Snow Flake Schema).
• Define Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Dimension Granularity within a Measure Group. Designed and Developed KPIs, Aggregations and Cube Partitions.
• Generated Named calculations and named queries.
• Deployment of Cubes to the production server.
• Generated Monthly and quarterly Reports are generated using different techniques like Drill down, Tabular reports, Matrix reports, List reports, Parameterized, Pie charts, Drill Through using Expressions, Global variables and Functions. Deployed SSRS reports in Share point for web based access for multiple end user.

Environment: SQL 2008/2012, T-SQL, Query Analyzer, Visual Studio 2010, VB.NET, ASP.NET, SQL Server Profiler, SSMS, BIDS.

Confidential, Baltimore

BI/SSIS/SSRS Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Project Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Giving inputs to the team.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2012/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

Confidential, Glen Allen, VA

MSBI Developer

Responsibilities:

• Developed SQL queries to Insert, Update and Delete data in Database.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created 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.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from dat servers.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Generated various SSRS Reports based on requirements.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

Confidential, Branchville, NJ

MSBI Developer

Responsibilities:

• Work with various business units to understand reporting requirements to provide practical and cost effective solutions.
• Develop, maintain, implement and support all SSIS development & production efforts.
• ETL development for data warehouse data marts daily refresh and real time reporting, utilizing both SSIS and DTS packages using SQL Server 2005 and 2008.
• Developed and created database objects like stored procedures, advanced queries, triggers, views, indexes and functions for databases.
• Create stored procedures to create dynamic SQL Queries to adopt dynamic environment.
• Created the packages based on mapping document using SQL Server Integration Services (SSIS).
• Using SSIS 2005, building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages.
• Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Deploying and scheduling SSIS packages and jobs using SQL Server Agent.
• Create jobs, Alert and schedule DTS/SSIS Packages and SSRS to generate reports.
• Working with reporting team in Designing, Developing and Deploying Reports in SSRS.
• Designed and architected Report Layout including both simple and complex report using SSRS 2005.
• Studying the structure of RDBMS to develop multi dimension Objects (Cubes, Dimension) using SSAS.
• Created calculated fields with MDX code to meet additional measures needs dat are calculated from existing measures.
• Practical involvement in creating dimensions using STAR and SNOWFLAKE schema.
• Experienced on writing complex queries, performance tuning and optimized SQL queries using T-SQL, SQL Profiler in SQL Server 2005.
• Monitored performance and Optimized SQL Queries for maximum efficiency.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Perform DBCC checks to ensure the physical consistency of the database and objects.

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

Confidential

SQL BI Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• 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.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/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.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.

Environment:SQL Server 2005 / 2000(2003, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS.