Mob: +1-202-***-**** E-mail: firstname.lastname@example.org
Over 9+ years IT experience in Database Design, Development and business intelligence of Microsoft SQL SERVER on various business domains like Financial, Health, Marketing, Insurance and Manufacturing. Experienced in requirement analysis, design, development, testing, and production rollover of reporting and analysis projects. Experience with database programming (Oracle or SQL Server) and Microsoft Office Suite Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
Working experience in BI Solutions (ETL & Reporting) using SSIS, SSRS, SSAS, Tableau, Power BI, QlikView and T-SQL Programming using DDL, DML, and DCL commands for various business applications. Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors. Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes. Expert in using SQL Server Agent to Schedule and monitor Jobs. Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability. Experience in Error handling and debugging coding issues and troubleshoot production problems. Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans.
Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues. Used incremental approach in the workflows and data flows to integrate source data into warehouse tables using required transformations.
Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS. Experience in creating configuration files to deploy the SSIS packages across all environments. Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drill-down and Drill-Through, Cascade, Parameterized reports that involved conditional formatting. Expert at developing ETL interfaces using SSIS and enterprise reports Page 2
Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports. Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms. Experience building various web and desktop applications under .Net Framework using ASP.Net, C#, ADO.Net, ADO.Net, Entity Framework to SQL Server.
Used ADO.Net Entity Framework to retrieve a manipulated data with database operation by implementing Data Access Layer. Designed front-end in VB.Net 2008 for crystal report for live core banking project. Developed SQL scripts to handle different databases of insurance applications and created front end application in VB.Net 2005 to achieve desired results and data.
Experience in developing applications using C#. Net, VB.Net. Strong Experience in Unit, Integration and System Testing. Developed reports & Dash board by using excel services and business Intelligence. Design and create dash board reports which illustrate the data in tabular format and well formatted charts. Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX, DAX and SQL.
Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX, DAX. Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements. Good understanding of business environment, excellent communication skill and ability to work proactively Communicate effectively with colleagues and business users. Technical & Business Skills:
MS-SQL Server 2012/2008R2/2008/2005/2000, SQL SERVER BIDS, T-SQL, Visual studio 2008/2010/2017 (SSIS/SSRS/SSAS), Microsoft Access 2007/2003, Microsoft Excel, Outlook, MS SQL Profiler, SQL Server Query Analyzer, Index Tuning Wizard, ASP.Net Frame Work 2.0, C#, Oracle, DB2, Crystal report, Erwin8/7.3/3.5, Windows 2007/2005 Advanced Server/Professional, Windows XP, MS Access, Java, My SQL, CSS, HTML.
Bachelor Science in Computer Science
Masters Science in Engineering
Wells Fargo, Columbia, MD
Role: Sr. SQL/SSRS/SSIS Developer
Duration: Dec 2018 – Till Date
Developed highly optimized stored procedures, functions, and database views to implement the business logic Developed Physical data models and created DML scripts to create database schema and database objects Involved in Data Mapping and data mining
Involved in Documentation of Technical Specifications and High-Level Technical Design for the business requirements Conducted employee meetings, ensuring employees were knowledgeable on processes and procedures Leading both on-shore and off-shore development teams Created clustered and non-clustered indexes.
Involved in performance monitoring, tuning and capacity planning. Performed Debugging on the Stored procedures for the requirement to handle the error Development of custom scripts and stored procedures for data import and manipulation. Page 3
Design and Develop SQL Server Integration Services packages and procedures. Design and Develop T-SQL procedures that support the business processes. Created ETL SSIS packages both design and code to process data to target databases. Identify and resolve problems encountered during both development and release of the SSIS code. Debugging and troubleshooting the technical issues while implementing the applications. Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Create and maintain technical documentation as required by standards and policies Created DTS Packages for extracting data from Flat Files, Excel, MS Access, and SQL Server Created packages in SSIS with error handling and worked with different methods of logging in SSIS Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Design and develop reports using data visualization tools (SQL Server Reporting Services (SSRS) and Power BI) Working with development teams (offshore and onshore) to develop necessary queries and reports Consistently attended meetings with the client subject matter experts to acquire functional business requirements. Participate in production releases as required qualifications Evaluate reporting requirement
Identified the data source and defined them to build the data source views Involved in the analysis and profiling of source data and sample reports to help with requirements and design (SSRS) Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered. Involved in Creating configuration files to deploy the SSIS packages across all environments. Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data. Developed various SSRS and Power BI Reports like Charts, Filters, Sub-Reports, Scorecards, Drill-down and Drill-Through, Cascade, Parameterized reports that involved conditional formatting. Design and create dash board reports which illustrate the data in tabular format and well formatted charts Generated periodic reports based on the statistical analysis of the data from various time frame and division Used cascaded parameters to generate a report from two different Data Sets. Involved with Query Optimization to increase the performance of the Report. Involved with Monitoring database performance and related reports to maintain performance efficiency and Suggests applicable opportunities for improvement pertaining to report structure. Developed Reports for business end users using Report Builder with updating Statistics Merging SSRS sub-report in to one main report to generate in pdf Configuring and deploying SSRS reports onto report server service Created Fact & Dimension table
Environment: Databases: SQL Server 2017/2016/2000/2005, Oracle, MySQL SQL Server Tools: DTS, BIDS(SSIS, SSAS, SSRS), BIMS, Query Analyzer, Enterprise manager Operating Systems: Windows 95/98/2000/2003/XP-Pro, Windows NT, Windows XP Programming Languages: T-SQL,PL/SQL,C#,VB.NET,C,C++,PHP, Java Script, CSS,HTML, XML, Microsoft Office Tools: Microsoft Word, Excel, Access and Visio, Visual Source Safe Reporting Tools: SSRS, Business Intelligence Tools, MS Access, Jira and Team Foundation Server Page 4
Liberty Mutual Insurance, Richardson, TX
Role: SSIS/SSRS Developer
Duration: Apr 2016 – Nov 2018
Created ETL SSIS packages both design and code to process data to target databases. Debugging and troubleshooting the technical issues while implementing the applications. Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2000 Created packages in SSIS with error handling and worked with different methods of logging in SSIS Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) Loaded the data into destination tables by performing complex transformations using SSIS/DTS packages. Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse. Responsible for Deploying, Scheduling Jobs and Maintaining SSIS packages and Updating and maintaining Visual Source Safe. Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code Created SQL joins for applications following SQL code standards. Responsible for data analysis, loading data from Data feed to Data Warehouse tables. Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance. Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations Created views to display required information on user interface, and triggers to validate consistent data entry into the database. Created various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access. Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners. Documented all the work and all the process of integration and reporting services for further references Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC). Provided Production support to Tableau users and Wrote Custom SQL to support business requirements Created Scatter Plots, Stacked Bars, Box, Bullet charts, Filled Maps and Symbol Maps according to deliverable specifications. Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports Created BI interactive Dashboard
Experience with creating Worksheets and Dashboard. Created the Test Evaluation and Summary Reports.
Experience of Client-Interaction on onsite/Offshore. Environment: MS SQL Server 2016/2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Enterprise Manager, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010, MS Access, Crystal Reports, MS Excel 2007.
Cigna Health Benefits, Nashville, TN
Role: SSRS/ETL Developer
Duration: Jan 2015 – Mar 2016
Created ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases. Developed SSIS Templates that can be used to develop SSIS Packages Worked on development, implementation and support of ETL processes for large-scale Data Warehouses using SSIS and DTS. Created SSIS process design architecting the flow of data from various sources to target Involved in extracting the data using SSIS from OLTP to OLAP. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages. Using DTSX Change tool converted DTS packages to SQL Server 2005 SSIS packages. Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Formatted the results into reports and kept logs.
Created SSIS packages to retrieve data from Legacy sources to retrieve user data from the Flat files on monthly and weekly basis. Responsible for data analysis, loading data from Data feed to Data Warehouse tables. Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment. Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and dynamically deployed SSIS packages into Dev., Test and Production Environments. Responsible for maintaining cubes using SSAS and populate the cubes with the data Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS. Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security Created reports with Analysis Services Cube as the data source using SSRS 2005/2008. Involved in designing the physical database models on SQL Server RDBMS using DML/DDL implementing constraints Extensively used T-SQL to manipulate and architect to produce results for users. Filtered inaccurate data from legacy system using complex T-SQL statements, and Implemented various constraints and triggers for data consistency Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization Created incremental data load task using SQL Server Integration services Involved in project status report updates/ creation of issue items for reviews/ updates of technical and Transformation files on timely basis.
Used SQL profiler to view indexes performance to mostly eliminate table scan. Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance. Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server Worked with development teams in the design of physical databases and in modification. Involved in migration from SQL Server 2005 to SQL Server 2008 Gathering data sources like QVD files, Excel, ERP, and Oracle in developing the QlikView Data Models Created QlikView files updated on timely basis as database updates Developed QlikView Functions and Reports as business needs Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007. Page 6
Ethiopia Commodity Exchange, Addis Ababa, Ethiopia Role: MS SQL/SSRS/SSIS Developer
Duration: Apr 2010-2015
Actively participated in gathering of User Requirement and System Specification Developed database objects like tables, views, stored procedures in SQL Server 2008 Created Partition Tables based upon Partition Functions and Partition Schemas Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries. Created reports based on the format specified in the design document Documentation of all the processes involved in maintaining the database for future reference Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS. Involved in development and modification of existing Financial Reports and Marketing Reports Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and Used Multi-Dimensional Expression (MDX) to access them. Extensively involved in the SSAS storage and partitions and Aggregations Extensively involved in Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL. Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 200R2 and in adding calculations using MDX. Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2000 Responsible for data analysis, loading data from Data feed to Data Warehouse tables. Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
Data access layer implemented using ADO.NET with Data-base. Implemented ADO.NET concepts to connect to the database. SQL .NET Data provider, Data Adapter and Data Set were used to retrieve and access data.
Developed SQL stored procedures and daily as well as monthly batches using ADO.NET and SQL Server 2005 Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Designed and built the ETL for mass uploading of product attribute changes into a custom-built analytical MDM solution. Developed Subject Areas for MDM using SQL Business Intelligence Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and Produced ad-hoc, standard and super user reports using SSRS Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Involved in creating Dataset in SSRS for calling the stored procedures and passed the parameters to the dataset. Used .Net Framework for creating and customization of reports. ENVINORMENT: MS SQL Server 2005/2008, Visual Studio 2005, COM/COM+, VC++, C#, MySQL, Windows 2000, Windows XP, T-SQL, VB.NET, ADO.NET, ASP.NET, Visual SourceSafe, XML, MDM, MDX, Crystal Reports, SSAS, SSRS, ERWIN, Brio.