SUMMARY:

• Dedicated, team player self - motivated IT professional with development and support skills coupled with a "can-do" attitude having around 8+ years of IT Experience.
• Extensive knowledge as a Database engineer using MS SQL 2008/2012/2014/2016 , BI Stack in various industries
• Extensive knowledge dealing with Relational Database Management Systems (RDBMS), OLAP, OLTP systems.
• Experience in creating various SQL server Objects like Tables, Views, Stored Procedures, User Defined Functions.
• Experience in BI Development, Deployment & Maintenance of SSIS packages.
• Involved in various phases of BI development projects during the tenure that includes Scope Study, Requirements Gathering, Design, Development, Implementation and Acceptance Testing for end-to-end IT solution offerings.
• Experienced in writing Complex T-SQL scripts to support Ad-hoc needs.
• Very good knowledge in fine tuning long running T-SQL scripts by breaking down complex scripts to simple once, Creating Indexes, Updating statistics and so on.
• Hands-on experience in Database Administration Operations like Backup, Recovery, Installing, Configuring, Managing, monitoring and using SQL Profiler.
• Designed and developed ETL-SSIS packages with various transformations, stored procedures, configuration files and tables.
• Expert in Extracting and transforming data (ETL) from various heterogeneous sources and loading them into various heterogeneous sources.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Experience in creating complex SSIS packages which contains several control flow tasks like Execute SQL Tasks, Script Tasks, Data Flow Tasks, For Each Loop, and so on.
• Experience in transforming data using Data Flow Tasks like Derived Column, Data Conversion, Row Count, Merge Join, Union All, etc.
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages.
• Experience in various kinds of SSIS Deployments like Catalog Deployment, File Based Deployment, and SQL Server Deployment.
• Involved in creating the report subscriptions and user security in SSRS.
• Experience in creating various complex reports in SSRS (tabular, drill down, drill through, matrix, chart, and parameterized) per requirements.
• Experience in creating various kinds of Subscription Reports, Linked Reports, Cached Reports in SSRS.
• Wide experience in Creating OLAP Cubes using SSAS.
• Experience in identifying dimensions, attributes, hierarchies, calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Good Knowledge in writing test cases for testing. Involved in writing the test cases for manual testing.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models and E-R Diagrams .
• Proficient in OLTP, OLAP and Data Warehouse Design concepts.
• Very good knowledge in various kind of schema’s in OLAP like Start Schema, Snow Flake Schema.
• Expertise in writing complex DAX functions in Power BI
• Hands on experience in designing DW Databases using Inmon, Kimball methodologies.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
• Hands on experience in designing databases using tools like VISIO, ER Studio.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), and Tableau
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation.
• Experience in SCRUM & Agile Process.
• Experience in Service Management (which includes Incident, Change and Problem) and well versed in handling issues in Production.
• Demonstrated ability to identify root causes of problems, considering both the long and short-term impact of proposed solutions and develop workable solutions.
• Good Knowledge in Application support process with SLA (Service Level Agreement).
• Basic knowledge in Share point 2010 like Creating lists, Libraries, Alerts, People access, etc.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2007/2010

RDBM/Databases: MS SQL Server 2008/2012/2014/2016 , MS Access 2010, MySQL

Programming Languages: T-SQL, Dynamic SQL, DOS Scripting

Data Modeling: MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access

Data Design Tools: MS Visio, Smart Draw

BI Tools: SQL Server Reporting Services (2008/2012), SQL Server Integration Services (SSIS 2008/2012), SQL Server Analytical Services (SSAS 2008), BIDS

Tools: /Database Utilities:: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS)

Application Packages: MS Office, Microsoft SharePoint Server

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr. SQL BI /Power BI Developer

Roles & Responsibilities:

• Actively participate in gathering of user requirement and system specification.
• Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems. Maintain historical data in data warehouse used ETL to implement the slowly changing transformation.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views, Cursors, CTE's, schemas, used DDL, DML commands. Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Effectively used various properties in SSIS package to improve the performance.
• Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS-SQL Server by using DTS and SSIS services. Created ETL SSIS packages both design and code to process data to target databases.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications
• Developed custom calculated measures using DAX in Power BI to satisfy business needs
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
• Used various SSIS task such as conditional split, derived column, which did data scrubbing, including data validation checks during staging before loading data to data warehouse and data marts.
• Scheduled Automatic refresh and Scheduling refresh in Power BI service
• Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions. DBA activities like creating users, roles and granting and revoking privileges.
• Deployed and uploaded the SSRS reports to Report Manager and organized them into folders for the end users and involved in enhancements and modifications.

Environment: T-SQL, MS SQL Server 2016/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Team foundation Server(TFS), SharePoint, MS Excel

Confidential, TN

Sr. SQL BI/Power BI Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design for in-house application development.
• Have Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Created the derived columns from existing columns using Derived Column transformation for the given requirements. Involved in complete SSIS life cycle in creating and re-designing the SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Migrated on premise SQL Server databased to Azure SQL database.
• Built Dashboards that used Windows Azure SQL database
• Managed the ETL processes between various environments through SSIS Configuration
• Used multiple complex transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, Flat file, SharePoint Data to SQL Server databases using SSIS.
• Modified inline SQL queries in SSIS packages and made all the variables to dynamic from static to pass the values dynamically and Scheduled SSIS packages to create SQL jobs.
• Normalized the source data for loading the Data into Dimension and Fact Tables using ETL controls in SSIS.
• Used SSIS variables to capture start time, end time and failure of a package and execute the package dynamically
• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Created Executive dashboards to reflect various retail KPIs based on Region, Countries, allowing management to drill down to individual retail store level.
• Used SQL Server Destination in Data flow to improve an exceptional performance changes in Replications.
• Installed and configured Enterprise gateway and Personal gateway in POWER BI service.
• Created Workspace and content packs for we users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in POWER BI service.
• Wrote calculated columns, Measures query's in POWER BI desktop to show good data analysis techniques. Created Reports using POWER BI.
• Automated POWER Query refresh using POWER shell script and windows task scheduler.
• Used various sources to pull data into POWER BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Used several types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created Pivot Tables and Pivot Charts in MS Excel.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• End to end support for upcoming major changes in the business logic in Sybase development
• Prepare Technical specifications for customizations required during a Dynamics AX implementation
• Migrating Dynamics AX 2009 to Dynamics AX 2012 R3 application.
• Configured SQL mail agent for sending automatic e-mails to employees for Invoice using SSIS packages.
• Defined Key Performance Indicator metrics to create scorecards.
• Stabilizing the DB2 environments and streamlined the systems
• Key Developer in analyzing the technical feasibility of the functionality which was required to be developed using asp. net and C#.

Environment: SQL Server 2012/2016, T-SQL, BIDS (Business Intelligence Development Studio), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS, DTS (Data Transformation Services), Visio, DAC, Share point Products, MS Excel Query Analyzer, Profiler, Power BI.

Confidential, San Francisco, CA

MS SQL Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and created User Defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards. Managed database portioning across multiple disks.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases. Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties. Knowledge of Database Performance monitoring tools.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis. Created ETL SSIS packages both design and code to process data to target databases.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created jobs to collect status information from various servers and feed them to the Master Server.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc. Implement automated Index Maintenance strategy run as SQL Jobs daily.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server. Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 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
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor. Created Snapshots, Subscriptions and Transactions using Replication services.
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio

Confidential

SQL DEVELOPER.

Responsibilities:

• Executed complicated analyses and make the results accessible and relevant to a wide variety of business users.
• Designed, implemented and administrated SQL Server 2008 databases.
• Developed various reports to validate the data between source and the target systems.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute Task. Actively SQL involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Created and Modify Stored Procedures, Triggers, Views according to the business.
• Implemented Constraints (Primary Key, Foreign Key, Default, Unique, Check and Not Null/Null) and fine tune Indexes on Tables.
• Performed database consistency checks at regular intervals.
• Involved in database design process and data modeling process using diagrams and Visio.

Environment: SQL Server 2008, SQL Profiler, Data Transformation Services, SSIS and T-SQL.