PROFESSIONAL SUMMARY:

• Over 5+ years of IT Experience in Database Design, Development and support in intelligence of Microsoft SQL Server Data Warehouse, Development, Test and Production Environments.
• Extensive experience in Microsoft BI studio products like SSIS, SSAS, SSRS for implementationof ETL Methodology in data extraction, transformation and loading.
• Experience in handling Data transfer projects, EDI standard transactions, Design Documentationand Expertise in collaborating with Business users, Cross functional Groups to understandrequirement.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like starschema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles,Relational Database Models, Data Dictionaries and Data Integrity.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and TechnicalManagement.
• Well experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Experience in SQL Server 2016 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Good experience of creating OLAP cubes in SSAS.
• Experience in creating MDX queries to retrieve data from SSAS Cubes.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers,Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in enhancing and deploying the SSIS Packages from development server to productionserver.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions,Packages, joins and hash indexes in Teradata database.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing anddeployment.
• Experience in using variables, expressions and functions and also defining Query for generatingdrill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple table’s inner and outer joins, storedprocedures.
• Excellent analytical, problem solving skills and a motivated team player with excellent interpersonal skills and familiar with offshore and multi-site development.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/14/16, Oracle, PL/SQL, MS Access

Programming Languages: T-SQL, PL/SQL, HTML, XML, Unix.

Tools /Utilities: Enterprise Manager, SQL Server Management Studio (SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio, SQL * Plus, Ervin, BI

Database Design Tools Data Modeling: MS Visio, MS Access, MS SQL Server, Star Schema/Snowflake Schema modeling. Physical & logical data modeling, Agile Scrum Methodologies.

Business Intelligence Tools: Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), DTS Packages.

Operating Systems: Windows Server, Windows XP/Vista.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

MS BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Involved in designing and developing packages for a Data Warehousing and Data Migration projects using Integration services (SSIS) on different Data Sources.
• Extracted the data from Flat Files, transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS (SQL Server).
• Created SSIS Packages by using various Control Flow and Data Flow Tasks to execute SQL Task for each loop Container, Derived Column, and Data Conversion.
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data into the tables from Text files, Excel files, CSV files and XML files.
• Developed Power BI reports using query logic based on business rules, and visuals selected by united stakeholders.
• Creating Power Pivot models and Power Pivot reports, publish reports on SharePoint, and deploy models into SQL Server SSAS instance.
• Merging and transforming data according to the requirements for ease of analysis in Excel by using Power Query in Power BI.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Enhanced and wrote triggers, existing stored procedures, views, functions, database objects to meet additional requirements of latest releases, Coding using Transact-SQL (TSQL). Created and maintained Physical Structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services (SSRS).
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Involved in writing the technical documentation and maintained throughout the process.
• Defined data repository requirements, database performance and cost, and performed backup and restored the databases using SQL Server management studio.

Environment: MS SQL Server, Visual studio, SQL Server Integration Services, SQL Server Reporting Services, SQL Server analysis services, OLAP, Power BI, Power Query, Power Pivot, T-SQL, MS-Access, MS Excel, Report builder, VB.NET.

Confidential

MS BI Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with enterprise Data warehouse (EDW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Worked with Business Analyst, SME's and Data architects to understand business requirement and involved in planning, defining and designing data based on the requirements.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Designed and developed SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to DW.
• Responsible for creating database objects like Table, Stored Procedures, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• Created Views to reduce complexity of end user.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Indexes to optimize performance of TSQL queries.
• Generated multiple enterprise reports using SSRS from OLTP and OLAP, and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Developed reports, dashboards, and SQL queries using Tableau.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Worked on SSAS storage and partitions, and Aggregations, calculation of queries with DMX, Data Mining Models, developing reports using MDX and SQL.
• Involvedin automating process by creating jobs and error reporting using Alerts, SQL Mail Agent.
• Tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created documents for all Store Procedure, SSIS Package and SSRS Reports that I have developed.

Environment: T SQL, SQL Server, SSRS, SSIS, Team Foundation Server (TFS), Visual Studio, SQL Server Management Studio, Tableau.

Confidential

MS SQL BI Developer (TSQL, SSIS/SSRS/SSAS)

Responsibilities:

• Migrated data from Heterogeneous Data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Worked on Data Flow Transformations like Slowly Changing Dimension, Conditional Split, Data Conversion, Derived Column, Look-up & Script Component, Aggregate, Audit etc.
• Created packages in SSIS with error handling and Worked with different methods of logging in SSIS.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Designed data model from the scratch to assist the team in data collection to be used for Tableau visuals.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Creating new Documentation, DB Schema designing, creating new ERD's using Visio.
• Proficient in creating, analyzing and testing of OLAP cubes in SQL Server analysis services (SSAS) using MDX.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
• Developed Query for generating drill down reports in SSRS.
• Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.
• Identified the Data Source and defining them to build the Data Source Views.
• Experience in Backup and Restore databases by SQL Server Management Studio and writing T-SQL.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Identified and worked with Parameters for parameterized reports in SSRS.

Environment: MS-SQL Server, Visual studio, SQL Server Integration Service, SQL Server Reporting Services, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, MS Access, MS Word, Tableau.

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Involved in analysis, design and development of large databases to solve complex business problems.
• Design of the Database and the Tables and built table relationships.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL Joins for applications.
• Developed SQL procedures, functions, packages and triggers for building customized code in SQL Navigator.
• Optimized query performance by creating indexes.
• Enhancing and deploying the SSIS packages from development server to production server and scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Loaded the data from the source flat files and RDBMS tables to target tables meeting the user business requirements and business rules using the SQL Loader.
• Created Queries for generating drill down reports in SSRS.
• Created Condition Objects in the Universe to restrict data.
• Created simple SQL query filters, prompted filters and complex filters to restrict data in reports.
• Created report in SQL Server and deployed them on local-host for remote access.
• Created several stored procedures, triggers, views.
• Tuned many ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment: MS SQL Server, SSRS, SSIS, SSAS, T- SQL, Stored Procedures and Windows.