Windows 2008/2000/2003/98 Advanced Server, Windows XP/10
MS SQL Server 2017/2016, 2014, 2008 R2, 2008, Oracle, MYSQL, MS-Access.
SQL Server Reporting Services (SSRS), Power BI, Crystal Reports, SQL Server Analysis Services (SSAS)
T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)
Other Software Tools
SQL Profiler, MS Office/Excel, MS Project, SharePoint, MS Visio, C#, Microsoft Team foundation server
Ad, MS Access, SDLC
Agile, C#, Self-motivated
Analytical skills, MS-Excel, Servers
Approach, Excel, Scripts
Automate, Mail, Script
BI, MS Office, Software Development
Business Objects, MS-Office, Sorting
Change Management, MS Project, MS SQL Server
Crystal Reports, SharePoint, SQL
CSS, Windows, SQL Server
Data Conversion, 2000, Tables
Data entry, 98, Team player
DTS, Windows XP, T-SQL
Data warehouse, MYSQL, T- SQL
Databases, Enterprise, User interface
Database, Navigation, Validation
Designing, OLAP, VBScript
Documentation, Operating Systems, View
ETL, Optimization, Visio
XML, Oracle, Microsoft Visual studio
Features, Developer, Visual Studio
HTML, Oracle and SQL
DB2, Problem solving
Access, Requirements gathering
Over 5 years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2014, 2012, 2008 in Production, Testing and Development.
Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
Proficient in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries.
Well versed in Data Modeling, Data Mapping, Table Normalization, performance tuning and optimization of SQL scripts and SQL queries.
Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages.
Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).
Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
Hands on experience with performing various SSIS data transformation tasks like Look-up, Fuzzy Look- up, Conditional Splits and Event Handlers.
Strong knowledge in designing Extraction, Transforming and Loading (ETL) data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management using SSIS (SQL Server Integration Services).
Expert in creating various types of reports like complex drill down reports & drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Solid experience working on offshore-onshore model.
Good knowledge on SSAS to create cubes using data from data marts/data warehouse for deeper and faster data analysis.
Experience in cubes construction based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Fact and Dimension Tables.
Hands on experience on publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for upcoming data in power BI server.
Excellent communication skills with capability to form and maintain positive and productive working environment as an individual or a team player.
MSBI Developer, 10/2018 to Current FedEx Supply - Memphis, TN
Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Involved in Performance tuning and Query Optimization by using SQL profiler.
Resolved deadlocks issues with the databases and servers on a real-time basis.
Worked with business analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of data extraction and reporting using SSRS.
Migrated SQL Server databases to latest version 2014 from SQL server 2005.
Integrated data from homogeneous, heterogeneous sources and legacy systems (SQL, DB2, Excel sources) to SQL server database.
Generated performance-based reports using SSRS for the managers to show holdings against various measures like time, area, and price-range.
Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Created scripts components to write customer functions in dataflow used data grids to display the data in a customized way.
Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third-party data source to transfer data.
Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases.
Designed, developed, modified, and enhanced the database structures and database objects.
Worked as point of contact for the offshore team in India.
Updated the existing Business Objects Universes as requested by the users with the new requirements to add new universe classes and objects for new database entities and attributes.
Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), Power BI, Microsoft Visual studio 2010, SharePoint, C.
SSIS Developer, 02/2017 to 10/2018 Valero - San Antonio, TX
Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
Worked as an SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Creating table indexes and constraints to ensure data integrity and enhance query processing.
Actively involved in requirements gathering/analysis, meetings with Business and provide description about the analysis and approach.
Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a time depending on requirements.
Also, used SSIS to move data from text files to SQL Server.
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Exclusively used SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
Worked extensively with SSIS for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
Created SSIS packages for transforming data from warehouse to mart, to import data from source systems, or transfer data from one server to another.
Designed daily/weekly/monthly SSRS reports utilizing multiple types of reports including sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports.
Created cube structure for the analysis of business condition and for creation of report using SSAS.
Generated Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
Used Power View and Power Map to visualize reports in Power BI.
Used Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
Coordinated and attended every day standup's/scrum/agile meetings and weekly sprint meetings to evaluate completed work.
Worked efficiently on Agile Methodology and Microsoft Team Foundation Server (TFS).
Environment: SQL Server 2014, Visual Studio-2010, SSAS, SSIS, T- SQL, Power BI, TFS, MS SQL Server 2005/2008, MS-Office, MS-Excel.
SQL/ETL Developer, 05/2015 to 01/2017 Ingram Micro Mobility - Fort Worth, TX
Involved in Preparation of documentation for all the requirements and enhancements to reports.
Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
Hands on experience working on Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Test and Production Environments.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
Created cross validation rules to ensure mapping accuracy.
Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
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.
Implemented Triggers for checking complex business conditions, providing security for the tables.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
Ability to handle Multiple tasks, Initiative and Adaptable.
Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
Environment: SQL Server 2008R2/2012, SSIS, ETL, SSRS, SSAS, DTS, OLAP, MS Access, Trello, Windows, SharePoint, MS Visio.