SUMMARY:

• Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Enthusiastic IT professional in Database Design Development, ETL Implementation and support of OLAP/OLTP/Data warehouse systems using Microsoft SQL Server 2008/2005 across various SDLC environments.
• Strong proficiency in the use of T - SQL for developing complex stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.
• Proficient to build end to end data integration and workflow solutions from input source extraction, apply various transformations and data load
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS)
• Well versed with the knowledge of RDBMS, data warehousing i.e. OLTP & OLAP systems
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills
• Can quickly adapt into given role and deliver results early

TECHNICAL SKILLS:

DBMS/RDBMS: MS-SQL 2016, 2014,2012,2008R2

ETL: SQL Server Integration Services(SSIS),SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS), Power View, Power BI

Languages: T-SQL, C#, DAX

Operating System’s: Windows server 2008/2003/XP/Vista, Windows 7/8/10

BI Tools: SQL Server Management Studio (SSMS), Data Tools (previously BIDS), Power BI

Office Tools: Office 365,MS Word, PowerPoint, Excel, Access, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SQL Server BI/SSIS/SSRS/ ETL Developer

Responsibilities:

• Gathering the requirements, Creation/review of Business, Functional requirement Documents for business systems, experience in database design process and data modeling process.
• Designed, reviewed, and created primary objects such as Views, Indexes based on logical design models, user requirements and physical constraints.
• Development and performance tuning of complex stored procedures, user defined functions and views for data migration.
• Query tuning based on query execution plans, statistics, and profiling
• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and ForEach Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Created SSIS packages to capture the incremental changes for the data warehouse.
• Scheduled and maintained nightly and weekly loads of data in SSIS by creating the corresponding job tasks.
• Created automatically running stored procedures for day-end operation using SQL Server Agent.
• Involved in creating new databases, performance tuning, deploying, scheduling and creating reports. This included writing T-SQL backup and creates various operational, drill-through and dynamic reports using SSRS.
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
• Created parameterized reports for the users and clients, with drill-down, drill-through features.
• Designed and develop Dashboards and Reports using SSRS.
• Experience using Microsoft PowerBI for the creation of dashboards, standard reports and ad-hoc reports

Environment: MS SQL Server 2008R2/2016, Reporting services (SSRS), Integration Services (SSIS)

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Worked on developing tables, indexes, views, creating complex stored procedures, triggers, functions.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, and created indexes.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Designed and developed databases with the best practices of data modeling and data normalization.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Created SSIS Packages by using advanced tools (i.e. Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Responsible for creating all reports such as matrix report, drill down report, drill through report, sub report and chart report etc.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Helped the users to test the reports created and optimized the performance of the end reports
• Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, and Snow flake modeling for fact and Dimension tables.