SUMMARY:

• SQL BI Developer wif 8+ years of experience in Designing, Development and maintenance of database applications using SQL Server 2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
• Extensive experience in disciplined Software Development Life Cycle (SDLC) process and familiar wif Spiral and Agile Models.
• Good understanding of Normalization /De - normalization, Normal Form and database design methodology.
• Used ER-Win Data modeling tool to design and implement Logical and Physical models of various Relational Databases.
• Maintained Data Integrity and Consistency by passing Data through several analysis steps such as parsing and Prototyping.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Expert in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Bulk Insert, BCP.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created test scripts in T-SQL to validate data staging tables and data warehouse tables to validate the data results on DEV/UAT/Prod environment.
• Performed data cleansing using fuzzy transformations wifin SSIS packages to eliminate redundant data from the pre-staging database before applying business logic.
• Experienced in creating configuration files, Logging and Error handling using Event Handlers in SSIS.
• Experience in deploying and enhancing theSSIS Packages from development server to production server.
• Experience in creating multidimensional optimized cubes using the SQL Server Analysis Services.
• Expert knowledge and experience inauthoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Experienced in creating reports using Grouping and Sorting and creating Sub Reports, Cascading parameterized Report, Report Snapshot, Drill-Through Reports, tabular and matrix reports Parameterized Reports, and ad hoc reports using SQL Server Reporting Services.
• Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server.
• Utilized Report Manager to secure the reports wif windows user groups and roles for individual reports and also reports folders.
• Administered Report execution based on Caching and Snapshot as well as managed report delivery using standard and data driven subscriptions.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin, MS Visio

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access

Programming Languages: SQL, PL/SQL, C, C++, HTML

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, SharePoint 2010, Power Pivot, Power View, TFS

Script Languages: Shell Scripting, PERL

Operating Systems: Windows, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

SQL BI Developer

Responsibilities:

• Involved in analyzing business requirements that will facilitate the planning and the implementation phase of a data mart.
• Used various approaches to collect the business requirements and worked wif the business users for ETL application enhancements by conducting various JAD sessions.
• Used Erwin tool for dimensional modeling (Star schema). Forward Engineered Data Model of Staging Database to SQL 2012 Server and help database architecture to modify physical and logical data model for new add tables.
• Created complex stored procedures and functions to perform data profiling, for efficient data storage and manipulation.
• Analyze the requirements and fine-tune the stored procedures to improve performance.
• Written dynamic SQL batches to perform the bulk operation in OLTP environment.
• Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Designed Mappings between Sources to Operational Staging Targets, Using Star Schema, and designed logic for incremental load using slow changing dimension and Check sum.
• Created SSIS packages providing specific functionality like Data Profiling and Data Cleansing for a clean ETL process and populating Data-Marts.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• CreatedScript Task to capture the Load counts, Miss Counts and Hit counts ofdata from one source to anotherusing C#.NET
• Implemented Master/Child Packages so only the Master Package TEMPhas to be scheduled which will in turn fire the other packages.
• Created package configurations using Parameters in 2012 to deploy in different environments like DEV, UAT and PRODUCTION.
• Created Integration services catalog (SSIDB) using SQL 2012 to deploy the SSIS packages.
• Involved in debugging of packages wif help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented new and complex Calculated Members that will be permanently stored in cubes to boost query performance of reports.
• Designed and created OLAP cubes by selecting proper User defined hierarchies, Dimensions and Aggregations.
• Customized KPI’s by writing MDX to analyze companies information in making appropriate business decisions.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Formatted and extended reports by creating parameters wifin reports, multi value parameters and extended reports wif expressions as well as embedding functions wif expressions
• Created ad-hoc, parameterized, drill down, and drill through reports and formatted reports wif parameters.
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Worked on Team Foundation Server (TFS) to synchronize the data wif different-2 sources as well.

Environment: SQL Server 2012/2008R2, Windows Server 2008, SSDT/SSIS/SSRS, MS Visio, TFS, SharePoint 2010, Power Pivot, Power View, .Net, Visual Studio, Power BI

Confidential, Houston, TX

BI Developer

Responsibilities:

• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Actively involved in logical and physical design phase of creation of the Data Mart.
• Created several tables, views using SQL Server 2008R2. These tables, views are created based upon the function specifications.
• Created/Modified T-SQL batches, database scripts, indexes, stored procedures, views, tables, and triggers, table-valued and scalar functions in SQL Server.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Used error handing techniques like Try Catch and error functions to create robust T-SQL code.
• Involved in designing and optimizing various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler.
• Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema.
• Performed ETL from legacy systems (text based files, Excel spreadsheets, and Access) to SQL Server databases using SSIS.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Identified and handled early arriving Facts and late arriving dimensions using inferred dimensions.
• Used C#. Net to develop different modules of the end-user interfaces and different SSIS packages.
• Used best practices for SSIS design such as Master Child architecture to leverage parallel execution of various packages.
• Monitored all the packages that were scheduled. Implemented Error Handling during ETL load in SSIS packages to identify dimensions and facts that were not properly populated.
• Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
• Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
• Enabled Checkpoints on already implemented transactions to optimize entire ETL strategy so as to start the package execution from latest point of failure.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Created QA scripts and Stored procedures for SSIS packages to perform various QA operations during ETL such as data profiling, data cleansing and data verification.
• Created cube objects like KPI’s and Calculated members using MDX and hidden some cube data by creating Perspectives on Cube.
• Optimized cubes by assigning appropriate storage modes (MOLAP, HOLAP, and ROLAP) to different partitions.
• Implemented Proactive Caching for refreshing the cubes, either by using scheduled MOLAP or Automatic MOLAP.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Exported data from a report to several file formats likes PDF, Image and Excel according to the needs of management.
• Designed and developed the most suitable User Interface such asDashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Generated reports using SSRS and Excel Spreadsheets wif Power pivots and deployed them in SharePoint integrated mode.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Used push method of delivering reports - subscriptions by scheduling the reports to deliver on time using MS SQL Server Jobs Agent in different formats viz. Excel, Pdf, Text, etc.

Environment: SQL Server 2008 R2, Windows Server 2008, SSIS/AS/RS, ER-Win, BIDS, SharePoint 2010, C#.Net, Power Pivot, TFS

Confidential, San Antonio, TX

SQL/BI Developer

Responsibilities:

• Involved in Database designing (physical and logical) to meet requirements using ERWIN.
• Created data-related documentation like file descriptions and definitions, entity relationships and attributes.
• Designed new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development environment.
• Created Stored Procedures for Reporting on Audit Information and Error Information during each ETL Process.
• Handling Query Optimization and Performance Tuning using SQL profiler and Database Tuning Advisor (DTA).
• Designed and facilitated the implementation of data Mart required by application systems by Validating change requests and made appropriate recommendations.
• Promoted database objects from test/development to production servers by coordinating and communicating wif production schedules wifin development team.
• Completely involved in creation of Data Mart from scratch by taking into various business process by identifying different dimensions and facts from existing Data Warehouse.
• Used SSIS Packages to extract, transform and load data from multiple input sources like flat files into SQL Server 2008R2 Staging Database.
• Identified dimensions and facts that were not populated using custom logging.
• Implemented various different SSIS features like logins, transactions, checkpoints, deployment, and configuration on designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.
• Actively involved in managing and optimization of the cube process.
• Created cubes from relational data warehouses and created KPI’s for the front end team.
• Created several calculated members, KPI’s as well as perspectives in support of analytical applications and dashboards.
• Created aggregations, user defined hierarchy for the cubes and KPIs.
• Created perspectives for the ease of use of the cube for different departments.
• Assigned the MOLAP, HOLAP and ROLAP storage modes for the data depending upon the requirements.
• Implemented named queries for the performance optimization and created usage based aggregations.
• Created different types of reports like drill down reports, drill through reports, sub-reports, and parameterized reports.
• Designed reports to include charts and logos that comply wif the organizations culture and policies of reporting and documentation.
• Created ad-hoc reports using Report Builder to provide a template for end-users for creating reports by themselves wif pre-selected group of relational tables
• Utilized conditional formatting to create reports which provide a visually appealing and descriptive representation.
• Designed and deployed Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along wif Building parameter-driven queries and stored and placing them, in the data field.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.

Environment: Microsoft SQL Server 2008R2, SSIS, SSAS, SSRS, ER-Win, BIDS, SSMS, Flat Files, Windows Server 2008, TFS

Confidential, Herndon VA

SSIS/SSRS Developer

Responsibilities:

• Conducted JAD sessions wif different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS.
• Worked on database objects like Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL to create complex scripts and batches.
• Designed and facilitated the implementation of data warehouses required by application systems.
• Modified database structures as directed by developers for test/develop environments and assist wif coding, design and performance tuning.
• Analyzed queries for optimization and performance tuning using SQL Profiler and Database Tuning Advisor.
• Made changes to existing data warehouse wif fact and dimensions to hold current as well as historical data for reporting purposes.
• Auditing framework for SSIS packages as a part of Package template was created that will audit package events such as start and begin of package, tasks and transformation execution and error information along wif package versions.
• Designed staging database as intermediate stage for population recovery Data Mart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Created complex ETL (SSIS) packages to pull data from Oracle, load monthly data from Excel to SQL server.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well as executing packages in parallel.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Scheduled and Delivered on-demand reports for business analysis using SQL Server Reporting Services.
• Followed the regular reporting life cycle Analysis, Design, Development, Testing and Scheduling to develop User Interface Reports.
• Deployed reports on SharePoint servers for easy access to the users by setting permissions and roles at report server in SharePoint Integrated mode.
• Designed and deployed reports wif Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Delivered on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services.
• Scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: Microsoft SQL Server 2008/2008R2, BIDS, SSMS, SSIS, SSAS, SSRS, Visio, Excel, Oracle, Windows Server 2008

Confidential

SQL Developer

Responsibilities:

• Gathered system requirements through end-user collaboration through the use of various JRD meetings as well as JAD meetings wif developers.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 R2.
• Created Stored Procedures, User Defined Functions to facilitate the automation of data entry by a front end application.
• Implemented indexes on tables and views for optimum performance tuning.
• Designed CTEs for code management in complex stored procedures.
• Involved in dimensional data modeling and story boarding ETL processes.
• Designed the ETL process using SQL Server 2008 R2 SSIS Packages which the data sources include Flat files, Access, and Excel.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Created SSIS packages for loading the data from various sources involving flat file and Oracle tables.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.
• Created reports wif the help of SSRS and presentations to meet business requirements.
• Generated various reports like parameterized and linked reports from the cubes.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Optimized the performance of queries wif modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary wif Profiler and Execution Plans.
• Used Reporting Services to schedule various reports to be generated on predetermined time. Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.

Environment: Microsoft SQL Server 2008, BIDS, SSIS, SSAS, SSRS, ER-Win, BIDS, Erwin, Windows Server, Visio, Excel