SUMMARY

• Over 7+ years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2005/2008/2012/2014 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) in SQL Server
• Experience in optimizing code and improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Extensive working experience in Normalization and De-Normalization techniques for OLTP and OLAP systems.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience with handling moderate to large tables/databases, Query performance tuning, Distributed Transaction, Distributed Queries/Linked Servers.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Hands on experience in creating the Cube dimensions and facts (SSAS)
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages
• Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Experience in designing and developing reports using different tools such as Visual Studio and Report Builder.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• SQL Server OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience with Power shell language in writing complex T-SQL Scripts.
• Experienced in creating Jobs, Alerts using SQL Server Agent.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in deploying SQL Server Analysis Services Projects using MS SQL Server.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Experience in creating visualizations and reports using Power BI.
• Experience in Microsoft Power BI tools (Power View and Power Pivot).

TECHNICAL SKILLS

BI Tools: SSIS, SSRS, SSAS, Crystal Reports, Power BI.

Databases: SQL Server 2005/2008/2008 R2/2012/2014, Oracle 10g/11g, MYSQL, MS-ACCESS.

Programming languages: C, C++, SQL, C#.Net, SQL, T-SQL, PL/SQL, Base SAS, MDX, DAX

SQL Server Tools: Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor, Business Intelligence Management Studio.

Reporting Tools: SSRS, Power BI, Tableau, Report Builder, Share Point.

OLAP Tools: SSAS, MS Excel.

Data Modeling Tools: MS Visio, Erwin

Project Methodology: Waterfall Methodology, Agile Methodology.

Applications: Microsoft Office, Adobe Acrobat, Microsoft Visio, Erwin.

Operating systems: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

PROFESSIONAL EXPERIENCE

MSBI Developer

Confidential - New York, NY

Responsibilities:

• Responsible for working with Business Analysts to translate functional and technical specifications into a comprehensive reporting design.
• Assisted in requirements analysis, data analysis, data mapping and report development
• Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and Triggers, complex PL/SQL packages
• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them in SQL Server Data Tools for Visual Studio 2012.
• Created ETL, SSIS packages both design and code to process data to target databases.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Provided SQL/ETL production support of critical data loads.
• Maintenance and Production support of existing systems on day to day basis.
• Developed complex Stored Procedures to generate various Group by, Drilldowns, Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
• Created weekly and monthly reports as per requirement using SSRS.
• Scheduled Reports to be delivered to user on demand basis in SSRS report Manager.
• Deployed and uploaded SSRS reports to SharePoint Server for the end users to look at them
• Extensively used embedded SQL in VBA front end.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end
• Used SQL Server as backend database for MS Access 2010 applications.
• Maintaining the MS Access application in production.
• Created Queries, Reports and Forms in MS Access 2010 using VBA
• Used MAPI to create an email program for sending automated reply to the user requests.
• Experience with ALM - Application Life Cycle Management
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Environment: MS SQL Server 2012, Windows Enterprise Server 2012, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Data Tools for Visual Studio 2012, MS Access 2010, ETL, ALM, RTC, MDX, DAX, XML, Tableau Desktop, Tableau Server, Tableau Reader, Tableau public, Power BI.

MS SQL Server Developer (SSIS/SSAS/SSRS)

Confidential, OR

Responsibilities:

• Involved in Complete Software Development Life Cycle (SDLC) by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Database Object Schemas, Tables, Triggers and Constraints.
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server and flat files.
• Migrated data from different sources (delimited, csv, text, fixed width files) to SQL Server databases using SQL Server Integration Services (SSIS).
• Developed Complex Packages to load data into Stage and Data Ware House systems.
• Involved in daily, bi-weekly, semi-monthly, monthly, annual batch loads (Full & Incremental) into staging and ODS area, troubleshooting load issues and errors using SSIS.
• Involved in complete SSIS Life Cycle in creating SSIS packages, building, testing, deploying and executing the packages.
• Deployed the SSIS packages to Test and Prod using XML Package Configurations.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks
• Used Various Control Flow and Data Flow Tasks like Execute SQL Task, For Each Loop Container, Derived Column, Data Conversion, etc. for Creating SSIS Packages
• Designed and Modified XML Package Configurations used different types of Event Handlers to send an automated alert for package Failures.
• Build a data cube around the existing offer click, impression and revenue statistics from redirectors
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Involved in Installation, configuration of SQL Server 2008R2 on Windows 7.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Excellent command on subscriptions, report snapshot and report cache.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Monitored the system utilization and checking the execution plan to improve the performance.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services 2008R2, Integration Services (SSIS), Analysis Services (SSAS), T-SQL, MS Access, MS Excel, XML, Version Control, Agile Environment.

SQL Server Developer (SSIS/SSRS)

Confidential, UT

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Windows 2007 enterprise, SQL Server 2008, SQL Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio.

SQL Server Developer (SSIS/SSRS)

Confidential

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

MSBI Developer (SSIS/SSAS/SSRS)

Confidential

Responsibilities:

• Merging existing databases and to design new data models according to the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Writing T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Creating joins and sub-queries for complex queries involving multiple tables.
• Install and Configure SQL Servers 2005 and 2008 on development server for designing and testing.
• Analyzing reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Creating complex Stored Procedures, Views, Triggers, Tables and other SQL joins. Maintaining data integrity by performing validation checks.
• Providing research, design, and creation of a robust system ensuring effective processing of financial information from multiple external locations.

Environment: MSSQL Server 2005, Windows Server, Windows NT, Visual SourceSafe, DTS, MS Access.