SUMMARY:

• Above 5+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience with different phases of project life cycle (Analysis, Design, Implementation and debugging new and existing client - server based applications). In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2014/2012).
• SQL Server 2005/2008/2008 R2/2012/2014 RDBMS database development including T-SQL programming.
• Experience in creating dashboards, scorecards and building reports using performance point server
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience with adhoc reporting , Parameterized , Custom Reporting using SSRS for daily reports and SSAS projects.
• 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.
• Developing reports on SSAS & SSRS on SQL Server (2012/2014). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage. Involved in DBA activities such as backups, restores, replication etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

SQL, T: SQL, PL/SQL. C, C++, .Net, VB 6.0, Perl, CSS, HTML, XML, MHTML, JAVA.

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle 10g,9i/8.x, DB2, MySQL, MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, Tableau 10.0

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

MS Office: 2013/2007/2003/2000 , Adobe Professional, SharePoint

Operating Systems: Windows 10/ XP/NT, Unix.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio(SSMS), Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies: Logical and Physical Database Design, Database Design and Normalization, Data Modeling

EXPERIENCE:

Confidential, Richmond, VA

SQL BI developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration, Installation of SQL Server, SSMS, SSIS, SSRS and support of ETL processes for large-scale Data project which included the claims & policy data of the client.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards. Implemented different types of constraints on tables.
• 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.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Implemented SSRS solutions, used dashboards and gauges to enhance for the business users.
• Deployed and Generated SSRS reports using the Reporting Services, Report Manager and Microsoft SharePoint 2010.
• Loaded data into data warehouse from multiple sources such as flat files, excel sheets and from different databases.
• Worked on enhancing the ETL packages & deploying them to the server from development to production environment.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Gained experience with the AS400 Query and SQL, and Microsoft Office.
• Wrote programs that translated data files received from clients, and loaded the information into the AS400. Files were received electronically via FTP and emails, or through CDs, tapes, and diskettes.
• Created complex SSIS packages using various Data transformations like Conditional Splitting, Aggregate, Derived Column, Multi Cast, Data conversion, Row Count, Percentage Sampling.
• Created SCD Type 1 & Type 2 dimensions using lookups & conditional splits for maintaining history in the database.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages using integration services catalog.
• Loaded data from different sources to the staging tables & loaded to dimension & fact tables accordingly.
• Worked on SSIS ETL tool for running the jobs to get the data from legacy system (Source) to the ODS and then to DataMart. Used File System Task to move files from one location to another location.
• Migrated Database from SQL Server .
• Developed all types of reports like Tableau reports/Dashboards, Data Visualization, Matrix reports, List & Chart reports, Parameterized reports, Drill down, Drill through, Sub reports, linked reports, Snapshot, Ad-hoc reports in SSRS.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star/snow Schema.

Environment: MS SQL Server 2014/2012, SQL Server Management Studio (SSMS), Microsoft Visual Studio 2012/2015, SQL Server Profiler, ETL, HTML, XML, SSIS, SSRS, SSAS, Tableau Windows Server 2008/Windows 7

Confidential, Cincinnati, Ohio

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering.
• Involved in database Schema design and development. Migrated Database from SQL Server 2014.
• Migrated Database from SQL Server .
• Used SSIS 2014 for Extraction, Transformation and Loading data from source systems into the target data base.
• Responsible for developing for the ETL (Extract, Transform and Load) processes using SQL Server Integration Services
• Analyze the data based on requirements and wrote down techno functional documents and developed complex mappings using SSIS used to remove the noises of data using standardization, merge, match, Data conversion, lookup Transformations etc and performed unit testing of accuracy of data.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances. Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Created SSIS DB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment. Used Batch Files to Import Data from other Data Base.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases. Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and maintained ETL (Data Extraction, Transformation and Loading processes to extract the data from multiple source systems and flat files to the Staging area, ODS and then to the Data Marts.
• Defined relationship between facts and dimensions with star schema and Snowflake Schema in SSAS.
• Deployment and Processing SSAS cubes, monitor full and incremental loads and support any issues.
• Designed and developed Data Warehouse for the Reporting group.
• Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Developed all types of reports like Tableau reports/Dashboards, Data Visualization, Matrix reports, List & Chart reports, Parameterized reports, Drill down, Drill through, Sub reports, linked reports, Snapshot, Ad-hoc reports in SSRS.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis. Expert in SSIS Deploying and Scheduling

Environment: SQL Server Enterprise Edition, SSIS 2014/2012, SSRS 2014/2012, SSAS, MS PowerPoint, MS Project, Tableau10.0, Oracle, PL/SQL, C#, XML, ETL, Visual Studio 2013, visual source surface

Confidential

SQL Server Developer

Responsibilities:

• In-depth knowledge with requirements gathering, analysis, design, development, change management, deployment and user training.
• Created Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for error handling during the SSIS process.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/Snowflake schemas using Dimensional Modeling principles in SSAS.
• Analyzed and Designed and developed MOLAP cubes with SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Created MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.
• Design and Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, user defined objects, Aggregate Aware Objects, Charts and synchronized queries.
• Conversion of Crystal Reports to Reporting Services and also existing SAS reports to Reporting Services 2005.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and Execution Plan.
• Validated reports to ensure quality of data and conducted meetings with business users to review reports and obtain continuous feedback.
• Coordinated the activities of subordinates in the Data Warehouse Team and organized weekly status meetings.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Query Analyzer, Microsoft Visio Professional 2005, ETL Tool.