SUMMARY:

• Database Engineer specializing in Design, Development & Administration with 5+years of hands - on experience using MS SQL Server and BI tools - SSIS, SSRS and SSAS.
• Exposed to all phases of software development life cycle SDLC including in-depth noledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Experience in wide range of industries i.e. Pharmacy, Insurance and Telecommunication industries with a strong understating of data & analytics.
• Extensive experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/2012/2008 R2 and 2005.
• Experience in RDBMS database design, performance tuning, Optimization, backup and recovery
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.
• Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principals.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Extensive noledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Expertise in defining the business process flow and gathering business requirements.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Databases: MS SQL server 2014/2012/2008 R2/2005, Oracle 11g/10g/9i, Teradata, My SQL

Programming Languages: SQL, PL/SQL, Transact- SQL, HTML, XHTML, C, C++, java, j2EE, XML.

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

OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, DBCC, BCP, SQL server profiler.

Data Modeling Tools: Erwin tool, Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Operating Systems: Windows 10/8/7/XP/Vista, MS-DOS, UNIX, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OH

Sr. MS BI Developer

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Managed the migration of SQL Server 2008 databases to SQL Server 2014.
• Created SSISPackages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server
• Identifying the DBMS platform according to the Application team requirements.
• Worked on Database Administration operations like Backup, Recovery and Replication.
• Design, Implement and Test database schemas.
• Experience in synchronizing the design.
• Created Tables, Stored procedures and user defined functions.
• Fine-tuning Stored Procedures to improve performance dat was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed Physical Data Models, data warehouse models and created DDL scripts to create database schema and database objects.
• Documented design and development works for report deployment, uploaded reports into SharePoint site, created new pages and folders and maintained reports in SharePoint site.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, adhoc reports, parameterized reports, interactive reports & custom reports
• Responsible for Individual OLAP database moves and server migrations (both physical and virtual servers).
• Identifying new features and facilitates incorporating into the application design.
• Built and developed MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Wrote various Stored procedures for the purpose of application development
• Developed backup & restore scripts for SQL Server as needed.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Reviewed and developed data models and database designs with development teams
• Wrote Store Procedures for some job automations.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Managing the strategic relationship with DBMS vendors.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Environment: SQL Server 2012/2014, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 10g/11g, T-SQL, MDX, Windows 8, XML, MS Excel and MS Access.

Confidential, Silicon Valley, CA

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• CreatedSSISpackages to migrate data from different data sources to data warehouse.
• Successfully extracted, transformed and load data into Data Warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively worked on Data Flow tasks like For each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Performed server installation and configuration using SQL Server 2012.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Participated Databases Architecture and data modeling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQLTask, Data conversion task, and Script Task inSSISDesigner.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Deployed and configured the reports in the Report Server.
• Defined parameters for parameterized Reports using SSRS
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.

Environment: MS SQL Server 2008 R2/2012, MS Visual Studio 2010, SQL Server Integration Services, Oracle 11g, T-SQL, SharePoint, DTS.

Confidential, Washington DC

MSBI Developer

Responsibilities:

• Created various Data Interfaces using SSIS as per the specifications.
• Involved in the development of SSIS Packages & SSRS reports using BIDS.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for different applications.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Worked on OLAP Data warehouse, Model, Design, and Implementation
• Worked on performance point server to create dashboard and scorecards for business intelligence.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages.
• Developed Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using T-SQL.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services.
• Created multiple reports with drop down menu option having complex groupings within the report
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Created snapshots of static reports and configure subscription.
• Involved in data Extraction and Transformation from source database and Loading to EDW (Enterprise Data Warehouse) with DataStage using DataStage design toll in the parallel processing mode.
• Used CTEs for recursive functionality to bring the organization structures.
• Built Table Valued Functions, Scalar Valued Functions to suffice the needs for business rules and for the implementation in stored procedures.
• Performed extract/transform/load (ETL) routines using SQL Server Integration Services (SSIS).

Environment: SQL Server 2008R2/2005 Enterprise Edition, SSRS, SSIS, Windows Enterprise Server, T-SQL, DTS,MDX, XML, MS Excel, MS Access, MS Visio, and Visual source safe (VSS), Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Designed and created SQL Database, tables, indexes, and views based on user requirements.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Responsible for creating databases, tables, cluster/non-cluster index, unique/check constraints views, stored procedures, triggers rules and defaults.
• Created SSAS cubes with multiple fact measures fact groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Assisted developers in writing optimized queries and Stored Procedures.
• Created new NT logins and granted privileges to users/groups and objects.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, ORACLE, and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created joins and sub-queries for complex queries involving multiple tables.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.

Environment: MS SQL Server 2005, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, VB, Visual studio2005, Windows XP.