SUMMARY

• Over 7 years of experience in analysis, design, Development, Implementation and Testing using MS SQL Server Developer with SQL 2012/2008 R2/2008/2005 and BI Developer using SSRS, SSIS, SSAS
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence, delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
• Experience in transforming unstructured data from various data sources using SSIS transformations like Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term extraction, Merge, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleansed data
• Excellent T - SQL Developer skills including Stored Procedures, Indexes, Views, User Defined Functions, Triggers, Cursors, Joins, Data Import/Export, Normalization, Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, CTE using SQL Servers to facilitate efficient data manipulation and data consistency.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP)
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool
• Experienced in creating, migrating, deploying complex SSIS packages with complicated transformations using SQL Server Integration Services (SSIS)
• Expertise in creating and managing Conceptual, Logical, Physical Data Models, Data Mapping, Data Normalization, databases and data warehouse (OLTP/OLAP)using tools like Erwin, MS Visio and Visual paradigm
• Experience in migration of SSRS reports from different versions of SQL Server
• Expertise in creating different types reports such as Tabular, Matrix, Drill-Down, Drill through, Ad hoc, Cascaded parameterized, Chart report, Sub reports, Cross Tab Reports and Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS)
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance
• Experience in creating and managing fragmentation of Indexes to achieve better query performance, Query optimization and performance tuning.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on OLAP/ Analysis Serve
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies

TECHNICAL SKILLS

• Microsoft SQL Server 2005/2008/2008- R2
• 2012 SQL Server Management Studio (SSMS)
• SQL Server Business Intelligence Development Studio(BIDS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• Oracle 8i/9i/10g/11g
• MySQL
• MS-Access
• MS-Excel
• SQL
• T-SQL
• HTML
• DHTML
• ASP
• ASP.NET
• XML
• Visual Studio 2005/2008
• SQL Profiler
• ERWIN
• MS Visio .

PROFESSIONAL EXPERIENCE

Confidential, Glen Mills, PA

SQL Server BI Developer

Responsibilities:

• Develop solutions to create the weekly reports for the management mapping the sales forecast with the actual sales
• Create SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into the development environment
• Design and develop Informatica workflows to extract sales and forecast data from SAP ABAP and Oracle based forecast managing application (OMP) respectively
• Create dashboard maintaining the statistics of the sales data extracted weekly using SQL Server and Informatica workflows and create jobs to automate it
• Design SSIS packages to export and import data from SQL Server to flat files, MySQL, Excel files
• Create Dynamic parameters on the server to extract data from SAP and Oracle databases based on the dates the sales were made
• Filter bad data using complex T-SQL statements, and implemented various constraint for data consistency.
• Automating the processes by creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages
• Create complex queries, stored procedures and programs to implement the designed data model and extract the relevant data
• Automate the creation of the reports by scheduling jobs to execute T-SQL stored procedures, SSIS packages and Informatica Workflows
• Create Data flow diagrams, timing diagrams and ER diagrams for documentation and sign-off purposes using Microsoft Visio tool
• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation
• Identify the future scope of the project, the technical challenges involved in it and document in the project charter.

Environment: SQL Server, SAP ABAP, T-SQL, SSIS (Integration Services), Flat files, MySQL, Excel, OLTP, Microsoft Visio

Confidential, NYC, NY

SQL Server BI Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Designed Data Mapping, DDL scripts, Data Dictionary and Meta data
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation check during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
• Defined Calculated members, named sets, and executed other script commands using MDX expressions.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows, SQL Server R2/2012, SQL Integration Services (SSIS), SQL Reporting (SSRS), Business Intelligence Studio, Visual Studio, OLE DB, Erwin

Confidential, Pittsburg, PA

SQL BI Developer

Responsibilities:

• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• 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 OLAP Star and Snow-flake schemas and tan Dimension and Fact Tables
• Created partitions of the Analysis Services cube to improve performance.
• Analyzed the xml data (XMLA) and transformed to access and SQL server database.
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, InfoPath files, text files and Excel files.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created data driven subscriptions for different users using Report Manager.
• Designed and implemented stored procedures and triggers for automating tasks.
• Successfully migrated data between different heterogeneous sources such as InfoPath forms, flat file, Excel, Access Database and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Used OLAP Processing Tasks for automatic processing of OLAP Databases
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
• Developed Access and SQL Database and wrote queries for data migration and Reporting Services. (SSRS).

Environment: SQL Server, Windows, SSIS, SSRS, InfoPath, Access, Agile, Share Point Portal, IIS, XML, ETL, Microsoft Visio, MS Visual Studio

Confidential, Rochelle Park, NJ

SQL Server BI Developer

Responsibilities:

• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Configured Internet Information Services (IIS) and Deployed Reports and Analysis Project in to server.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008 R2.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports, Linked, cascaded, parameterized, Drill Down and Drill-through
• Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Responsible for defining the complete Data Warehouse architecture (e.g. ODS, ETL process)
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed, developed and implemented the Dimension Data Model through multiple expert interviews for multiple fact tables.
• Performed data transfers using BCP and BULK INSERT utilities.
• Performed performance tuning by studying Execution Plan, Analyzing Indexes.

Environment: MS SQL Server, SQL Server Management Studio (SSMS), SSIS, OLAP, OLTP, SSRS, SQL Server Profiler, Visual studio, SQL Analyzer, Enterprise Manager and SQL Server Agent.

Confidential

SQL Server SSRS Developer

Responsibilities:

• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Created calculated member for complex calculation in reports using Business Intelligence.
• Created matrix reports and table formatted reports.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Work closely with management and end-users to create and evaluate business requirements.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Managed off shore team in Report migration project.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Involved in Product Releases and support calls.
• Created Report Models for Business Users to create their own reports.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn’t interfere with each other.

Environment: SQL Server 2005/2008, Windows, T-SQL, SSRS, Share Point 2010, BIDS

Confidential

SQL Server Developer

Responsibilites:

• Involved in analyzing and designing disaster recovery/replication strategies with business managers to meet the business requirements.
• Tested to optimize the procedures and triggers to be used in production.
• Experience in Data Modeling using Erwin Design Tool
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Actively participated in gathering of User Requirement and System Specification.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC

Environment: T-SQL, SQL Server, MS Access, SSMS, Erwin, Windows, Visual Basic.