SUMMARY

• Over 7 years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Expertise in analyzing, designing, and developing Client/Server, Business Intelligence (BI) database applications using MS SQL Server 2012/2008/2005/2000 , SQL Server Integration, Reporting & Analysis Services.
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Involved in creating numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).
• Involved in designing T - SQL programming artifacts such as complex queries, stored procedures, triggers (DDL and DML), indexes, and user-defined functions.
• Strong debugging skills and the ability to solve complex problems.
• Extensive experience in Tuning SQL queries& improving the performance of the Database.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Built the data cubes by implementing SQL Server OLAP services in SSAS.
• Used MDX script to create dimensional cubes and query data.
• Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map.
• Managed report by using SSRS tools such as report management, report delivery and report security.
• Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services Exposure to all phases of Software Development Life Cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using Multidimensional Expression (MDX).
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
• Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2016/2008R2/2005 T-SQL, SQL Loader.

ETL: SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL using Stored Procedures.

Tools: Visual Studio 2008/2005/2003 , Toad Reporting Services, Crystal Reports, Tableau, Power Pivot.

Database Connectivity: OLEDB and ODBC.

Front End: SQL Reports, C#, .Net, Python

BI Tools: SSRS / SSIS / SSAS.

Version Control Tools: TFS, VSS, SVN

Languages: C, C++, PL/SQL.

Web Knowledge: XHTML, XML, JavaScript

Operating System: Windows 7, XP, Vista, UNIX, Windows 2000, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

SQL/BI Developer

Responsibilities:

• Developed SSAS Cubes with Star Schema.
• Designed SSAS cube to hold summary data for Tableau dashboards.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
• Created roles using SSAS to restrict cube properties.
• Was involved in migration of Windows 2008 R2 server to Windows 2012 server.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Tableau and Qlik view.
• Was involved in developing Tableau Dashboards using both relational and Multidimensional data.
• Improved the performance of calculated measures in cube by modifying MDX queries in an efficient manner.
• Also developed rolling averages using MDX calculated measures in the cube for analysis.
• Developed Aggregations, advanced aggregations and also usage based aggregation in order to improve the query time performance.
• Created bottom count, top count, cross join and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created parallel period, filter, ancestors and cross join MDX queries.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Created SQL server Analysis Projects using MS SQL Server 2008 R2.
• Created the Molap Cubes and Dimensions.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance the cube's utilization. Also used MDX to query them.
• Identified and Defined Key Performance Indicators in SSAS 2008 R2.
• Maintained Security Role and Database Users.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2005.
• 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.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expert in calculating measures and dimension members using multi-dimensional expression
• (MDX), mathematical formulas, and user-defined functions.
• Conceptualized and Designed Logical and Physical Data Models using ERWIN.
• Analyzed the project database requirements from the user.
• Defined aggregations required and granularity available and required in DW.
• Developed Python scripts to send Tableau dashboards in an email for unlicensed users.
• Developed calculations in Tableau dashboards for KPI’s.
• Maintained Tableau server and monitor the performance of Dashboards.
• Resolved the issues of Tableau daily refresh extracts in Tableau server.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2008 R2 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), visual studio 2008, Tableau, Microsoft Office Share Point Server, OLTP, OLAP,MOLAP, XML, Python.

Confidential, Philadelphia, PA

SQL Developer/BI Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Done Performance tuning using TOAD
• Worked on Excel Power Pivot for providing ad-hoc reporting for the clients.
• Deployed and generated reports on the server and fine tuned the database objects and server to ensure efficient data retrieval.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created various Dash Boards using Performance Point Server
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Effectively used data blending feature in tableau.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
• Managed the migration of SQL Server 2000 databases to SQL Server 2008.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2012 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), visual studio 2008, Performance Point Server, Microsoft Office Share Point Server, TOAD, OLTP, OLAP, XML.

Confidential, Portland City, OR

SQL Developer/BI Developer

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Designed and developed data model in SQL Server using Visio.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Consolidated two databases into one, which maintains customer profile information.
• Implemented security for customer information by encrypting sensitive data using SQL Server 2005 encryption. Used AES algorithm for encryption and decryption.
• Created SSIS packages to transfer data from AS400 to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, trouble shooting process issues and errors.
• Built a effective queries for high performance reporting and rendered them to PDF and excel formats using power pivot services.
• Used various Control Flow tasks in SSIS like For Each loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created several Staging Databases. Used 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.
• Identified the fact and dimension tables from the SQL server based on the requirements.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multi value, hidden, default etc.) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc.), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint
• Created Scorecards based on Key Performance Indicators (KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining
• Created and debugged data connections, data sources and Data Source Views.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.

Environment: Windows 2007/XP/vista, NET Framework, MS Excel, Microsoft SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL,TOAD, Visual Studio 2008/2005, PL/SQL.

Confidential, Philadelphia, PA

SQL Server Developer/BI Developer

Responsibilities:

• Designed, coded, tested and implementeduser interfaces, procedures and functionsfor new and existing softwareapplication requirements.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created custom and Ad hoc reports using SSRS.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Triggers and Stored Procedures.
• Actively involved in Normalization & De-normalization of database.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Wrote DTS scripts for data transfer.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Involved in System testing.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSRS, MS .NET Frame Work, ASP.NET, T-SQL, Access 2000 & Windows 2K platform ADO.NET, MS Project.

Confidential

SQL Developer/DBA

Responsibilities:

• Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs
• Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Created Views to replace old tables and created new tables with triggers to support new business needs.
• Modified the current stored procedures using Visual Source Safe 6.0 to meet current design.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP.

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2000.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter.
• Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth.
• Generated Reports for the day-to-day as well as weekly/monthly purposes.
• Created Distributed Partition views Using T-SQL.

Environment: MS SQL server 2000, Windows 2000, Enterprise manager, Query analyzer, DTS, SQL profiler.