SUMMARY

• 6 Years of Experience as a Microsoft SQL Server - MSBI / ETL Developer specialized in SSIS, SSRS, SSAS development and administration in OLAP, OLTP environment in SQL Server 2005, 2008, 2012.
• Expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and in SQL Server Analysis Services (SSAS) in Business Intelligence (BI).
• Experienced in implementing various logic using objects like Tables, Joins, Views, Roles and Constraints using Data Definition Language (DDL), Data Manipulation Language (DML).
• Expertise in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using SQL in observing Business Rules.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS, Bulk Insert, creating mappings/workflows to extract data from Oracle, DB2, SQL Server, Excel and Flat File sources and load into various Business Entities.
• Strong Experience in Creating, retrieving, Configuring, Deploying and Testing SSIS Packages.
• Extensive experience in and deploying ETL SSIS (Integration services) packages.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience with Reporting Services (SSRS) in creating tabular, matrix, ad hoc reports based on predefined models and interactive reports from relational, multidimensional or XML data sources and publishing reports, scheduling report processing, or accessing reports on-demand.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Proficient in SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server2012, 2008 R2, 2005.
• Experience in Managing Security of SQL Server 2005, 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio.
• Strong written and verbal communications. Interested in a challenging technical track career in an application development environment.
• Exceptional ability to quickly master new technologies and capable of working in-group as well as independently
• Worked with Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0

BI Tools: SSIS, SSAS, SSRS.

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

Language: SQL, PL/SQL, MDX,C, HTML.

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008 , UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

PROFESSIONAL EXPERIENCE

Confidential, Morrisville, NC

MSBI Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex SQL code for the application.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Developed packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• Involved in designing the physical databases model on SQL Server 2012 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Worked with development teams in the design of physical databases and in modification.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2012 Reports Services (SSRS).
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used Notification services to generate error messages and send them to the user through e-mails, messages, as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2012 Server, MS SQL Server 2012, SSMS, Performance point Server, ASP .NET, XML, SSIS, SSRS, SSAS, Power Pivot, Share Point.

Confidential, St. Louis, MO

SQL Server / MSBI Developer

Responsibilities:

• Imported the data in to the SQL server from different External sources and internal sources with the help of ETL tool SSIS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.
• Created SSIS packages after performing ETL for getting data from multiple data sources for certain reports.
• Scheduled jobs and job streams to ETL SSIS packages.
• Creating and modifying SSIS and DTS packages. Package deployment
• Migration of DTS into SSIS packages.
• Created multiple tasks in a package and executed them.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Designed and maintained reports in SSRS 2012.
• Distributed reports to the users by uploading them to Report Web.
• Gained knowledge of various databases including Service Center, Asset Center.
• Worked with SQL optimization team to optimize SQL statements and implement better techniques for efficient SQL execution.
• Controlled security for reports in Report Web.
• Performed administrative functions on the SharePoint site.
• Reduced monthly manual maintenance by automating certain reports and tasks, and achieving consistency among database logins.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Analyzing, designing, building & testing of OLAP cubes.

Environment: SSRS, SSIS, SAS, Oracle, UNIX, SQL Server, Share point.

Confidential, Somerset, NJ

SQL Server Developer

Responsibilities:

• Created Tables, Views, User Defined Functions and Stored Procedures for new and modified business requirements in SQL server and SSIS Servers.
• Written T-SQL Stored Procedures and queries for accessing Data from Teradata Database.
• Created various connection managers (OLE DB connection, flat file connection, ADO.NET connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as Oracle, SQL Server, flat files, excel to perform ETL process.
• Done ETL process extract, transform and load data from Excel sheets, Flat files to tables using SSIS and Data Flow Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Extensively involved in designing and maintaining the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database
• Optimization of stored procedures in SQL Server to improvise the speed of the application to display the data
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Used Stored Procedures to retrieve reports data that accept parameters.
• Deployed packages in SQL server MSDB database.
• Used SSIS Documenter for documenting SSIS packages.
• Designed and programmed custom reports throughout the organization. Maintained current reports created in SQL Reporting Services. Created Ad-hoc reports as needed and carry out report projects as required.
• Used SQL Profiler for debugging issue, performance tuning whenever necessary.
• Modified and created new stored procedures, views and SSIS packages for the existing ones to reduce their execution time.
• Reviewed and documented existing stored procedures.

Environment: MS SQL Server 2008R2, SQL Reporting Services, Oracle, Visual Studio 2008/2010, C#.Net, Crystal Reports 10, SQL Server Integration services, TFS/VSS, C#.Net, T-SQL, ASP.

Confidential, Dearborn, MI

SQL Server / SSIS Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Involved in database Schema design and development.
• Created efficient Queries, Indexes, Views and Functions.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Optimized the Database for best performance.
• Design and develop the payroll module using MS SQL Server 2008 R2.
• Installation and Administration of SQL Server 2008 R2.
• Migrated data from MS Access to SQL Server.
• Performance Tuning of the client databases for better performance on a regular basis.
• Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
• DesignedSSIS packages to perform Extract, Transform and load (ETL) data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed ETL SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Produced operational reports in SSRS 2008 R2 i.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files with proper mapping.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations

Environment: SQL server 2008/ R2, MS VB Access, Windows 2003 Standard Edition, Microsoft Share point Portal Server, Visual Studio 2005, C#,VB.net 2005,.NET 3.0 SP2, SSRS, SSIS, DTS, SQL Profiler, net scripting, VSS,TFS.

Confidential, Framingham, MA

SQL/ SSIS Developer

Responsibilities:

• Designed SSIS strategies to pull data from different sources, like SQL server, flat files and load it to the destination database as a part of ETL.
• Prepared the technical documents for existing stored procedures. And updated those stored procedures with new data elements
• Created mapping documents for every stored procedure.
• Performed documentation of standards, best practices, and ETL procedures.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Used Email Notification package success or failure. If the package is success send the mail with package name, how many records inserted, updated and total records using Send Mail Task. If the package is failed it will send the mail package name and error description using On Error Event handlers in Send Mail task.
• Defined precedence constraints and implemented various control flow tasks such as Data Flow Task, Execute SQL task, Execute Package Task and Send Mail Task.
• Used Merge Statement for maintain the Inserts and updates if the table have less data.
• Used different ETL transformations from SSIS such as lookup, condition split, row count Transformation, Derived Column, Data Conversion.
• Created Stored Procedures for package Initialization and end package information to update the package log table.
• Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value.

Environment: Microsoft SQL Server 2008, SSIS 2008, SSRS 2008, Visual Studio 2008,SSMS(SQLSERVER Management Studio),T-SQL, Oracle 10g,Windows2008/XP, .NET Framework, C#2008, TFS(Team Foundation Server), ASP.NET2008, ADO.NET3.5.