PROFESSIONAL SUMMARY:

• 8+ years of Data warehousing experience with Microsoft SQL Server 2012/2008R2/2005/2000, SSIS/SSAS/SSRS
• Extensive experience in creating interfaces using SSIS in Microsoft SQL Server 2012/2008 R2/2005/2000 and its different tools like SSMS ( SQL Server Management Server) , BIDS (Business Intelligence Development Server) and SQL Server Configuration Manager.
• Experienced in developing the applications using T - SQL Programming (DDL, DML and DCL).
• Proficient in Upgrading from SQL Server 2005/2000 to SQL Server 2012/2008R2.
• Skilled in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Experience in designing Database Models using MS Visio and ER-Win.
• Hands on experience in creating ETL packages using SQL Server 2012 Integration Services ( SSIS ).
• Created SSIS Packages using Various Transformations like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Knowledgeable in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Creating the Cubes, deploying, processing, maintaining and dimensions building of cubes using SQL Server Analysis Services (SSAS).
• Proficient in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations, using Multi-Dimensional Expression (MDX) to access them.
• Good knowledge in RDBMS, Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert at creating reports using SSRS (SQL Server Reporting Services), (SQL Server Analytical Services) and OLAP (Creating cubes) including Interfaces with BIDS.
• Proficient in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experienced in migration of SSRS reports fromSQL Server 2005 to SQL Server 2008.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports, cached and snapshot reports, linked, click reports and sub-reports using SQLServerReporting Services ( SSRS ) in Business intelligence development studio ( BIDS ).
• Skillful in using global variables, expressions and functions for the SSRS reports.
• Proficient in design and development of various dashboards, reports utilizing Tableau
• Excellent communication skills, analytical skills, understand business requirements in various domains. Strong problem solving and analytical skills with ability to work independently as well as in a team.

TECHNICAL SKILLS:

SQL Server Tools: SQL2012/2008R 2/2008/2005/2000 , SSIS, SSRS, SSAS

RDBMS: MS Access, Oracle 11g/10g

ETL Tools: SSIS(SQL Server Integration Services), Data Stage, Bulk Copy Program (BCP), Import Export Data, DTS(Data Transformation Services),

Languages: SQL, T-SQL (Transact SQL), PL/SQL, C, Java, Visual Basic 6.0, VB.Net, HTML, CSS, C# .NET

Operating Systems: Windows 8/7/vista/XP

Reporting Tools: Report Builder 3.0, SSRS

Other tools: Microsoft Visual Studio 2010/2008/2005 , MS Office

PROJECTS SUMMARY:

Confidential, Columbus, Ohio

MSBI Developer

Responsibilities:

• Planned and designed database based on business requirements and provided documentation.
• Performed analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa. 
• Successfully migrated data between different heterogeneous sources such as flat files, Excel and SQL Server 2008 using SSIS and Bulk Insert.
• Created  SSIS  Packages using  Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc  to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Development of ETL using Informatica 8.6 .
• Creating Data entry Forms using VBA .
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views)
• Created reports in MS Access 2010 and Excel 2007.
• Designed specifications/layouts for Data entry screens and reports.
• Securing the Database and providing user rights and logins .
• Extensively used embedded SQL in VBA front end .
• Created parameterized driven reports in Access running through Access VBA front-end , also Generated Daily, Weekly, and Monthly Reports as per the customer requirements.
• Created various  SSRS Reports  involving different features like  Reports, Charts, Filters, SubReports, DrillDown, Drill-Through, Multi-valued parameters  etc
• 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.
• Experience in Data Warehouse such as Relational, Dimensional, Multidimensional Modeling, Star and Snowflake schemas, Data marts, Fact and Dimension tables identification, and OLAP/OLTP .
• Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures .
• Designed, Developed Web Forms using .Net Framework (C#, ASP.Net, ADO.Net), for the user interface (UI) with MSSQL as the Database.
• Implemented applications using ASP.NET 3.0, C#.NET, MS Visual studio 2010 and SQL Server 2008.
• Used  SQL Profiler and Index Tuning Wizard  for tracing slow running queries and stored procedures.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.

Environment: SQL Server 2008 R2, Visual Studio 2010, MS Access 2010, Informatica Power Center 6.2, Excel 2007,ASP.NET.

Confidential, Lincoln, RI

Sr. SQL Server Developer/ BI Developer

Responsibilities:

• Planned and designed database based on business requirements and provided documentation.
• Performed analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Professional experience in the BI Stack- Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Designed, developed and maintained large data sets passed through the MSBI Stack using Business Intelligence Development Studio.
• Created several SSIS packages in Microsoft SQL Server 2012.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, .CSV files into SQL Server 2012.
• Deployed various types of SSIS Transformations in packages including slowly changing dimension, aggregate , fuzzy lookup, conditional split, row count, derived column, script component, etc. and handled erroneous output using event handlers .
• Implemented Package configuration to make packages dynamic in order to modify the SSIS packages from a test/ development environment to the production servers for day to day operation.
• Created cubes, dimensions and data source views.
• Developed cubes using SQL Server Analysis Services and wrote MDX queries.
• Involved in designing, building the dimensions, cubes with star schema and snowflake using SQL Server Analysis Services (SSAS) for analyzing purpose
• Created drill down and drill through reports, cascaded reports, sub-reports, and parameterized reports in SSRS.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Created report models from cubes as well as relational data warehouse to create ad-hoc reports and chart reports.
• Designed reports to include charts and logos that complies with the organizations culture and polices of reporting and documentation.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• SQL Server Data Quality Services (DQS) has been used to cleanse data, match, standardize and enrich data to deliver information across Business Intelligence .
• Used DQS to create a knowledgebase which contains information about the metadata , cleansed the data and removed duplicates, performed Master Data Management (MDM) to upload cleansed data into an Excel file and processed the automation using SSIS .
• Migrating from clipper database to SQL Server .
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize r
• ports.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel.
• Created report schedules, data connections, projects, groups in Tableau server.  
• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Presentation layer (GUI) application has been created using web forms, ASP.NET 3.0, C#.NET, MS Visual studio 2010, HTML.
• Installation, configuration and upgrade of  TFS 2010/2012/2013 Instances.
• Used web services to share information between applications in SSIS Packages .
• Monitoring autosys to make sure every job meeting SLA 
• Created stored procedures to perform Index maintenance, data profiling, metadata search for loading data marts and reporting database.
• Made changes to existing data warehouse with fact and dimensions to hold current as well as historical data for reporting purposes.
• Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures.
• Created Triggers to update master tables in order to authenticate the transactions depending on business logics.
• Created partitions on tables, indexes and indexed views as well as querying and managing partitions from optimization point of view according to the business requirements.

Environment: SQL Server 2012/2008 R2, Visual Studio 2010, MS Project, TFS, MS Visio, Autosys, SSIS, SSRS, Power BI, SSAS, Tableau,ASP.NET.

Confidential, Tampa, FL

Sr. SQL BI Developer

Responsibilities:

• Gathered and analyzed project requirements from business and clients.
• Translated project requirements into ETL design specifications.
• Developed SSIS packages to extract, transform and load data from multiple input sources like flat files, excel with multiple sheets, Production SQL Servers into SQL Server 2012 and to SQL Server 2008R2 Staging Database.
• Transferred data into various formatted files and updated my managers with the automated email systems.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Developed SSIS packages and SQL Scripts to extract data from OLTP systems to flat files and for pre-calculated aggregates, summaries and user specific calculations.
• Created Audit process for each ETL package which stores all the package information like On Error, Execution date, start and end date.
• Studied existing OLAP systems and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created SSAS cubes and attribute relationships for optimal MDX query performance of hierarchies and fact dimensions.
• Administered and deployed OLAP cubes on development and production server for performance analysis using SSAS.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports, debugged and deployed reports in SSRS.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Performed Installation, Configuration and Deployment of packages using SSRS.
• Published reports on to Share-Point 2010 and Report Server and set the data-driven subscriptions for these reports.
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS) and report builder. 
• Design, development and deployment of tableau reports.
• Development & Scheduling of jobs using Autosys.
• Performed Db mirroring for the SQL server database in order to maintain the redundant copies of database.
• Embedded reports into web pages using C#.NET Report Viewer Web Control. 
• Using SQL server 2008 always on feature setup High Availability for TFS/SharePoint.
• Wrote several stored procedures for the ease of application.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance
• Designed, developed, modified and enhanced the database structures and database objects.
• Created complex Stored Procedures, Triggers, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Environment: Microsoft SQL Server 2012/2008R2, Business Intelligence tools - SSIS, SSRS, SSAS, Tableau, Share-Point Designer 2010, TFS, ODBC, MS Access, Autosys, T-SQL programming,C#.NET.

Confidential, Chicago,IL

SQL Server/ BI Consultant

Responsibilities:

• Played a key role in team in gathering and analyzing Business Requirements
• Participated actively in designing the system database structure.
• Implemented database modification process and data re-modeling process Created SSIS packages to move data to SQL Server and also from other sources such as Text and Excel files.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, For-Each loop container, Merge Join and Union all.
• Used various control flow tasks like FTP, Bulk insert task, transfer job tasks and various data flow tasks.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Reviewed and testing packages using SQL 2008 Business Intelligent Development Studio.
• Expert in creating Star schema cubes using SSAS .
• Extensively worked, Created and Managed on OLAP cubes using SSAS .
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
• Hands-on experience in calculating measures and dimension members using multi-dimensional expression (MDX) , mathematical formulas, and user-defined functions.
• Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history using SSRS 2008.
• Installed and administered Microsoft SQL Server 2008/2005, SQL Server Integration Services 2008/2005, SQL Server Reporting Services 2008/2005, and Team Foundation Server 2008/2005.
• Developed Reports Using SSRS on statistical data during migration of data and also built Reports in SSRS for errors generated in SSIS Packages.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Expert in creating reports using SQL Server Reporting Services and handling sub-reports. Well-versed in defining data sources for creating data source views for SSRS reports using Report Builder 3.0
• Identified and worked with parameters for parameterized reports using SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed stored procedures, functions, triggers, SQL, T-SQL
• Performed optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Report Builder 3.0, SQL Profiler, SQL Server Reporting services, Tableau.

Confidential, Fort Worth, TX

SQL BI Developer

Responsibilities:

• Participated in meetings to develop conceptual database design, improve functionality, and achieve optimal performance and development strategy.
• Designed and implemented data warehouse to data-mart using Top-down approach.
• Used SSIS Packages to extract transform and load data from multiple input sources like Excel files , Production SQL Servers (2008/2005) and Oracle into the data mart in optimized way.
• Implemented Error Handlers and Error Handling in SSIS packages and notified results to various users.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeeded.
• Used many DTS tasks like dynamic property tasks to change the properties of package at run time, Execute Package task and Execute Process task.
• Created OLAP cubes to provide aggregated data for the faster analysis .
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008& 2005(SSAS)
• Created simple KPI, perspective, calculated members to enhance the structure of the cube .
• Implemented MOLAP cubes on SQL Server Analysis Services 2005 .
• Created ad-hoc Reports using SQL 2008 Server Reporting Services to validate the information inserted to the warehouse after refreshing it.
• Created Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Created triggers and audit tables in order to capture the incremental data from OLTP and created complex stored procedures to perform data profiling in the pre-staging database.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Created and implemented stored procedures to perform database maintenance tasks like index rebuilding & reorganizing to take care of internal and external fragmentations.
• Partitioned the data of larger fact tables to improve the performance.
• Incorporated Error Redirection during ETL Load in SSIS Packages. Performed Unit testing and System Testing of ETL Process.

Environment: SQL Server 2008/2005, Business Intelligence Development Studio (BIDS), SSIS, SSRS, Windows Server 2008/2003

Confidential

Database Developer

Responsibilities:

• Actively participated in gathering system specification requirements for the project.
• Extensive participation in logical and physical database design and normalizing the database to accommodate possible changes in OLTP & created data flow diagrams and enforced all referential integrity constraints.
• Good knowledge of advance query concepts such as group by, order by, having clause, union, union all, rank and row functions.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.
• Developed SSIS packages for extracting data from different data sources and loading it into the Data Warehouse
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2005. Create Calculate member in MOLAP cube using MDX in SSAS 2005. 
• Created data model, logical design, and physical design of the database. Developed stored procedures to create various reports using SSRS 2005.
• Worked on different types of Control flow and Data flow Transformations.
• Participated in monitoring performance and trouble-shooting at the server and database level.
• Participated in generating Backup and Maintenance plan.
• Worked on Documentation using MS word

Environment: SQL Server 2005, T-SQL, Oracle, Windows 2000/XP.