SUMMARY:

• SQL BI Developer with 7+ 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 with Spiral and Agile Models.
• Good understanding of Normalization /De - normalization, Normal Form and database design using Kimball 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 Perl and Shell test scripts in T-SQL to validate data staging tables and data warehouse tables to validate the data results on DEV/UAT/Prod environment.
• Implemented Data Mining techniques on production data, to create data mining databases like data collection, data cleaning, data selection, for specify requirements.
• Performed data cleansing using fuzzy transformations within 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.
• 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 with windows user groups and roles for individual reports and also reports folders.
• Expert hands on experience with Microsoft Office applications like Word, Excel, PowerPoint, Visio, manager.
• Good knowledge on other reporting tools like QLik view reports and Crystal reports.

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 2012/2008/2005, 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

Miscellaneous: Full Life - Cycle Development, Star and snowflake Schemas, Executive Dashboards, MS - Office (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

SQL/SSIS/SSRS Developer

Responsibilities:

• Analyzed business requirements and involved in designing the data models for data warehouse using ERWIN.
• Created database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment forSQLServer 2012 as per the requirement.
• Used SQLServer Integration Services (SSIS) to create ETL packages to validate, extract, transform and load data into database.
• Created SSIS design template packages for Source load, Type-1, Type-2 dimensions & Fact SSIS packages to use across the Project.
• Designed and developed ETL (SSIS) packages for building a new Data Warehouse by extracting, transforming and loading data from Banks various legacy data warehouse sources.
• Automated SSIS Execution using Windows Scheduler using DTExec Command.
• Created logging, custom logging and error handling SSIS packages.
• Grouped, aggregated and split data using SSIS.
• Developed SSIS packages to automate many FTP’s files and email to required list of clients.
• Extracted data from different sources (text based files, Excel spreadsheets CSV files, and Access) to SQLServer databases usingSSIS.
• Scheduled the packages and jobs to keep extracting the data from OLTP at specific time intervals using SSIS and SQL Server Agent.
• Generated reports using SQL Server Reporting Services (SSRS) and deployed on the report server to make it available for the users.
• Designed reports using Cascading parameters, Parameterized Reports and Report Models usingSQLServer Reporting Services (SSRS) based on Business requirement.
• Migrated SAS code to T-SQL to support the new database.
• Modified MicroStrategy reports & dashboards.
• Supported user questions and issues in production.
• Optimized code and improved efficiency in databases including re-indexing, updating statistics, usingSQLProfiler, and re-compiling Stored Procedures and performing other maintenance tasks.
• Used Try Catch in Stored Procedures, added error handling in SSIS packages and used SSIS catalog.
• Worked on validation of the tables, SSIS packages and Reports.
• Performed ADMIN activities on the Server by taking Back-up & restoring the DB, providing user access privileges, creating linked servers.
• Implemented best practices for development and test environments for all the projects before releasing it to users.
• Created and updated deployment scripts and documents.

Environment: MS SQL Server 2012, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Flat File, TFS, ERWIN, SAS, MicroStrategy, MS Visio, SharePoint 2010, Power Pivot, Power View, Visual Studio, Power BI

Confidential, Des Moines, IA

SQL BI Developer

Responsibilities:

• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Used various approaches to collect the business requirements and worked with 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.
• 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.
• Created several tables, views using SQL Server 2008R2. These tables, views are created based upon the function specifications.
• 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.
• Created 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.
• Collected data from different data source, eliminated irrelevant and unneeded data, and imputed the missing values using different Data Mining Techniques.
• Improved data quality by implementing data mining concepts on the production database.
• 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 has 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 with 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 (Perl) to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• 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 with 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 with 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 with 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.
• 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 with 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.
• 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.
• Involved in analyzing business requirements that will facilitate the planning and the implementation phase of a data mart.
• Actively involved in logical and physical design phase of creation of the Data Mart.
• 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.
• 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 with 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 with production schedules within 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 different data mining database models based on project accounts.
• 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 with 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 with 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 with 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 with 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 with 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 with 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 with 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 with 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 with 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.
• 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 with the help of SSRS and presentations to meet business requirements.
• Optimized the performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary with 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