SUMMARY:

An Information Technology professional possessing a thorough understanding of the software development life cycle (SDLC) including requirement analysis, requirement gathering, design, development, implementation and testing and deployment with 5 years of experience as a Microsoft Business Intelligence Developer. A well - organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills able to quickly adapt into the given role and deliver results early.

SSIS:

• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Experienced on various SSIS Transformations such as conditional split, derived column etc. on the data retrieved, perform meta data validation checks during staging and then loaded the data .
• Experienced on developing, testing and deploying SSIS packages in different environments for various projects.
• Experienced in providing Logging, Error handling using Event Handler, and Custom Logging for SSIS Packages.

SSRS:

• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Proficiency in creating various types of Parameterized Reports such as Cross-Tab, Drill-down, Drill-Through, Summary, Graph, Chart and formatting those using SSRS.
• Experience in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experienced on Creating interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Excellent experience in performance tuning and optimization of SSRS Reports
• Implementation of security in SSRS report at item level and group level with SSRS roles.

SSAS:

• Experienced in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Experienced in handling Slowly Changing Dimensions while loading data into the data warehouse.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modeling, Snow flake modeling for fact and Dimension tables.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

SQL:

• Extensive experience in using T-SQL creating tables, stored procedures, views, indexes, cursors, triggers, user defined functions, database models and data Integrity in SQL Server 2012/ 2008/2005 platforms.
• Experienced in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data retrieval, data manipulation and data consistency.
• Solid understanding of Isolation Levels, Normalizing and De-normalizing tables and maintaining Referential Integrity by using Primary and Foreign Keys.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.

TECHNICAL SKILLS:

DBMS/RDBMS: MS-SQL 2012,2008R2, 2005

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

Report Tools: SQL Server Reporting Services (SSRS)

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL

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

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

Office Tools: MS Word, PowerPoint, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville, TX

BI/SQL/SSIS/SSRS/ETL Developer

Responsibilities:

• Work on all activities related to the development, implementation, administration and support of ETL processes
• Design and develop data warehouse, data marts and business intelligence using multi-dimensional models - star schema.
• Use SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases from various sources like Text Files, XML Files, Excel and Access.
• Create packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Create SSIS Packages to perform filtering operations and automated it to import the data on daily basis from the sources to SQL Server to load the data
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Create trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Design, develop and deploy SSRS reports that include; parameterize reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports, Gauges, Pie Chart, Bar Chart
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Scheduled the reports to run on daily and weekly basis in report manager and email them to managers and analysts to review in excel spread-sheet.
• Use ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Confidential

SQL Server Business Intelligence Junior Developer

Responsibilities:

• Worked with users and business analysts to design and develop all reporting layouts, report interactions and report features.
• Actively participated in gathering of User Requirement and System Specification
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Created all reports such as matrix, drill down, drill through, sub-report, chart and dashboard reports.
• Developed SSIS Packages to load data into database and flat file using SSMS 2008 R2 and BIDS 2008
• Created SSIS package which extract data to single flat file from different data-source
• Created Log Files to troubleshoot package failure errors
• Maintained and scheduled packages
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting
• Created SSIS packages to load customer information to a flat file
• Worked with a combination of multiple Dataflow Transformations to build packages in SSIS
• Troubleshooted processes, issues and errors in SSIS Packages to improve their performance
• Worked with other team members to document systems and process environments