SUMMARY:

• 7 years of experience in role of a Microsoft Business Intelligence Developer
• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS.
• Proficient to build end to end data integration and workflow solutions from input source extraction, apply various transformations and data load
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• SSIS:
• Developed and Maintained Microsoft SSIS packages including database design, ETL and analysis integrations to meet business requirements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• SSRS:
• Created SSRS report projects in BI Visual studio and created, modified and managed various report models with multiple objects, source fields and expressions.
• 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.
• Developed various types of intricate reports like drill down, drill through, gauges, pie chart, bar chart, sub-reports
• SSAS:
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.
• Implemented different slowly changing dimension methodologies to maintain and update historical data corresponding to dimension tables in the data warehouse.
• Followed Agile Methodology to keep track of projects and maintained schedule by conducting daily scrums and bi-weekly sprints
• SSMS:
• Full System Development Life Cycle (SDLC) experience including requirement gathering, analysis, design, development, testing, and Implementation of various medium and large scale client/server applications in a structured development environment.
• Design, implement and maintain database schema, entity relationship diagrams, data modeling, tables, stored procedures, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
• Tested applications for performance, data integrity and validation issues.

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010

Languages: T-SQL

OLAP Tools: SSAS, SSRS

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010

ETL Tools: SSIS, DTS, Import/Export Wizard

PROFESSIONAL EXPERIENCE

Confidential, Frisco, TX

SQL Server/SSIS/ETL Developer

Responsibilities:

• Interacted with users extensively in gathering the requirements and analyzing the needs of the end users
• Analyzed source system data to determine the data model and ETL solution that will meet business requirements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases from multiple sources of data.
• Created databases, tables and provide constraints and user defined rules and defaults.
• Involved in writing various database objects like user defined functions, stored procedures, usage of indexes for accomplishing various tasks.
• Created views to reduce database complexities.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, and created indexes.
• Tested applications for performance, data integrity and validation issues.
• Contributed to the development and modification of coding standards to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Designed and developed data warehouse and business intelligence using multi-dimensional models - star schema.
• Developed several detail and summary reports, including bar graphs and pie charts, trend analysis reports and sub-reports according to business requirements in order to help with management and control of all inventory.
• Added parameterized report functionality for the users with drill-down and drill-through features.
• Enhanced end users’ understanding of interactive dashboard report by creating user-friendly materials.

Confidential, Dallas, TX

Business Intelligence Engineer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Wrote SQL queries and stored procedures to generate data for reports.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Analyzed source data to determine the data model and ETL solution that will meet business requirements.
• Extracted data from multiple sources including (Excel, SQL, etc.)
• Created complex SSIS packages using various transformations and tasks like sequence containers, for loop and for each loop containers, execute SQL package, 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.
• Designed complex packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.
• Participated in AGILE iterative development methodology that allowed upper management to see their product sales information through frequent delivery of product.
• Generated daily, weekly and monthly reports for managers based on product sales reaching certain targeted demographics and business goals.
• Created substantial documentation for reports as a for upper management and sales associates
• Applied security to reports on item and folder level.

Confidential, Washington D.C.

Technical Program Manager

Responsibilities:

• Formulated and documented the physical ETL process based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008 R2.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Actively supported business users for changed requests.
• Designed and developed dashboards and reports using SSRS on a week-to-date, semester-to-date and year-to-date to manage facility reservation requests easier.
• Organized and communicated face-to-face meetings, conference calls providing advice and consultation to student leaders, group advisors, and UC clients regarding scheduling and event logistics.
• Involved in creating different parameterized reports to sort through facility use to date and facility use based on statistics and types of clientele (student, faculty, external organization, etc.)