EXPERIENCE SUMMARY:

• 6+ years of experience in SQL development with SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of SDLC - Agile/Scrum from gathering requirement, development, implementation, testing and support.
• Hands on experience with MSBI stack - SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).
• Experience in SQL design and development with Microsoft SQL Server, versions 2012 through 2016, and SQL Server 2017
• Experience in Database Design, Database Modeling, Data Retrieval and Database Security.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snowflake Schemas.
• Extensive SQL development in Oracle and SQL Server environments.
• Good familiarity in working with MS Azure cloud, Tableau for dashboards, visualisations and MongoDB NOSQL databases.
• Solid knowledge and experience with developing complex, hi-performance data solutions using all available tool in the SQL toolkit
• Extensive experience in analyzing functional data mart and data warehouse requirements for BI and designing Star/Snowflake Schemas.
• Extensive experience in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks and Unique), writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering and relational database models.
• Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Experience in Data Base Development, Implementation, Customization, and Data Migration (ETL Process-Loading millions of records by using PL/SQL procedures with optimize techniques).
• Excellent working experience on Data Bases (OLTP), Data warehouses (OLAP) and Data Marts (OLAP).
• Proficiency in object-oriented programming and experience applying modern design patterns
• Experience with Team Foundation Server (TFS), GitHub and Git version controls.
• Strong understanding of SDLC - Agile best practices with emphasis on BI practices
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Extensive working experience inmigratingSSIS code across various environments.
• Hands on experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring.
• Extensive experience in creating complex SSIS packages for ETL purposes using various components of SSIS 2012/2014/2016 .
• Proficient in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes using DDL, DML, DCL commands
• Proven ability to collaborate with other analysts and developers in a BI team environment.
• Extensive use of Oracle SQL, Sybase and SQL Server for data retrieval.
• Expertise in developing Parameterized, Chart, Graph, Linked, Drill-down, Drill-through and Cascading reports using SQL Server Reporting Services(SSRS).
• Capable of understanding Business Requirement and mapping data to it and generating required reports.
• Experience with Agile using JIRA software, and Confluence.
• Effective organization and time management skills with the ability to work under pressure
• Effective ability to establish working relationships with individuals at varying levels within the organization
• Excellent presentation, verbal and written communication, and time management skills.

TECHNICAL SKILLS:

SQL, PL/SQL, T: SQL, UML, XML

Reporting Tools: SSRS, Tableau

ETL Tools: SQL Server Integration Services (SSIS) 2012/2014/2016

Methodologies: Star/Snowflake Schema, Physical, Logical and Relational Modeling, Dimension Tables, OLAP, Dimensional Modeling.

Databases: Oracle, SQL Server 2014/2016

Operating Systems: Windows 10, UNIX (Solaris, HP, Linux)

Control: M, SQL Agent, Windows, UNIX

Other software: CVS, PVCS, SQL Developer, Toad, ODS, SQL Plus

PROFESSIONAL EXPERIENCE:

Confidential, West Hartford, CT

SQL Developer

Responsibilities:

• Created and managed databases, analyzed business requirements, participated in the design of Enterprise database and collaborated with business analysts on client requirements and changes.
• Created joins and sub-queries for complex queries involving multiple tables.
• Writing scripts, stored procedures and functions for database system.
• Develop, implement and optimize stored procedures and functions using T-SQL
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Analyzed and designed the architectures and data models of SQL Server database.
• Database management: Database server installation, daily performance monitoring and tuning, loginand user account management, role and permission configuration, and database backup.
• Generated complex SSIS ETL processes to transfer data from different sources like Oracle, SQLServer, and Excel files and load into Pre-Staging and Staging database for populating production.
• Developed and optimized Stored Procedures and User Defined Functions to implement complicatedbusiness logic for interfacing with parameterized reports and generating datasets for reports.
• Analyze existing SQL Queries for performance improvements
• Created simple data masking validation to compare masked values against original data to guarantee that all sensitive values are different, and to confirm that all substituted values come from a data dictionary.
• Extensively worked with different control flow tasks such as Execute SQL Task, Data Flow, ExecutePackage, File System Task, Script Task, Send Mail Task and different containers like For Each Loopand Sequence Container.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts using XML.
• Created different database objects like Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures and User Defined Functions etc.
• Resolve database problems, queries and error reports in accurate and timely manner.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports. Debugged and deployed reports in SSRS
• Creating Tableau reports using different visualization to analyze trend.
• Design and develop ad-hoc /scheduled reports and dashboards.
• Perform quality assurance tests for ensuring data integrity and quality.

Environment: MS SQL Server, SSIS, SSRS, SSAS, T-SQL, Multi-Dimensional Model, Tabular Model, Tableau, Visual Studio, TFS, ER-Studio, SQL Agent, Tableau.

Confidential, Windsor, CT

SQL Developer/ SSRS

Responsibilities:

• Coordinate with team members to perform database programming based on project requirements.
• Assist in planning and implementing the data integration and data migration activities.
• Provide valid inputs in database architectural discussions.
• Test database systems and perform bug fixes.
• Maintain accurate and complete database programming documentations.
• Designed and created ETL packages with SSIS using LookUp, Filter, Aggregators, Data
• Conversion, Expression and Merge transformations, Control Flow using for loop Containers andFuzzyLookups.
• Participated in meetings ranging from requirement gathering to moving to production andcollaborated with Business Analysts, SMEs and Report Developers on full cycle BI Projects.
• Designed DataMartusing Star and snowflake schemas to create data warehousing system. Thisincluded integrating several transactional database components like Fares, Complaints, Trips and Runs.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively worked with different control flow tasks such as Execute SQL Task, Data Flow, Execute
• Package, File System Task, Script Task, Send Mail Task and different containers like For Each Loopand Sequence Container.
• Used DTS/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.
• Created different database objects like Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures and User Defined Functions etc.
• Worked with the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files into SQL server.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration,
• Parent package variables. Worked on Project level deployment in TFS.
• Used SSIS to do transformations on XML data and integrate better with existing data. This included customer reviews and support call info from third-party vendors.
• Participated and collaborated with business analysts on client requirements and changes to the existing system.
• Improved Report performance by designing and loading multiple aggregate tables from transaction detail table using SSIS.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Name to set, filter, ancestors, cross join, dynamic measures and members in MDX queries.
• Development of Tableau reports and dashboards.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Environment: MS SQL Server, SQL Server Data Tools, T-SQL, BI Development Studio, Visio, SSIS, Visual Studio, SQL Developer, Tableau.

Confidential

SQL Server Developer/ SSIS

Responsibilities:

• Involved in Data Model design and enhancements of Data Marts based on the ETL projectrequirements.
• Created ETL design and process flow documents from Design Mapping Specification (DMS).
• Led the group in analyzing DB requirements.Worked collaboratively with technical staff and business experts to develop solutions to business requirements and client problems.
• Worked in a system with two different databases Oracle and SQL Server for legacy and current applications.
• Developed the Complex T-SQL queries using Joins, Stored Procedures, Views, Triggers to implement the business rules and transformations.
• Designed and developed ETL data models in data warehouse and data mart environments.
• Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables.
• Worked on Performance Tuning for packages. This included identifying data-quality issues and suggesting methods for their resolution.
• Troubleshot various report issues including connection problems and data errors.
• Worked on developing data designs and processing flows to support customer support service functions.
• Worked on different transformations like fuzzy lookup, conditional split, derived column transformations in SSIS packages.
• Deployed the SSIS packages and scheduled the package through Jobs in all Tiers including DEV, UAT and PROD including setting the Configuration files which was done in the specified tables and created technical specs documents for all the enhancements.
• Analyzed the data warehousing requirements with the Business Analyst team, Data Base team to configure the Data marts and Development environments.
• Worked collaboratively with technical staff and business experts to develop solutions to business requirements and client problems.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• 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.
• Generated daily, weekly, monthly report for analysis purpose when the end user wants to see the reports on fly using SSRS.

Environment: Microsoft SQL Server, T- SQL, S SR S, SSIS, MS Visio, MDX, Windows server, Oracle, Toad, SQL Developer.

Confidential

SQL Developer/SSIS Developer

Responsibilities:

• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Worked on other packages of the SQL server 2008 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Performed ETL using SSIS by extracting data from various data sources such as MS Access, Excel, Flat files, CVS files and network locations.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 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.
• Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base.
• Use SQL profiler to identify long running queries.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server Reporting Services (SSRS.

Environment: SSIS, SSRS, SSAS, MS SQL Server, OLAP, ERWIN, Windows, MS Office, TFS.