Candidates About

                                  Salma                                                           

MS BI SQL Server Developer

● SSRS Developer ● SQL Server SSRS/SSIS Developer● DW Database Developer

_______________________________________________________________________________________________

 

 

Summary

 

·         Around 6+ years of experience as SQL Server Developer/Admin/Business Intelligence Developer. 

·         Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.

·         Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.

·         Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

·         Experience in importing/exporting data between different sources like Oracle/Access/Excel etc.using SSIS/DTS utility.

·         Experience in ETL processes involving migrations and in sync processes between two databases.

·         Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.

·         Experience with SQL Server 2008 R2/2012 /2014 RDBMS database development including T-SQL programming.

·         Proficient in T-SQL queries using Stored Procedures, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, and DDL etc and Proficient in Performance Tuning of SQL query.

·         Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, De Normalization,

·         Partitioning, ACID Property, Data Warehouse, Bill Inmon methodology, Ralph Kimball methodology, Star flake schema, Snowflake Schema, SSAS Dimension Attribute Properties and etc.

·         Good experience in developing reports using SQL Server (SSRS)

·         Experience in Visual Studio Team Foundation Server, Visio.

·         Proficient in writing MDX query and good knowledge of all MDX Functions.

·         Expert in Creating and managing roles for security in SSRS reports.

·         Experience in Database Backup, Recovery and Disaster Recovery procedures.

·         Experience in deploying created reports in various sources like Web browser, XML and PDF.

·         Excellent experience in Crystal report. Use tables, view, Store Procedures

·         Active Directory Basic operation and integration with related application for directory entity.

·         Familiar with Agile methodology in software development.

 

Education

Information System and Technology- Bachelor in Technology,2009

Cuny,NY,USA

 

 

 

Professional Experience :

 

Wells Fargo(Uptown), Charlotte,NC                                                                                              Oct  2017 – Present

SQL Developer & ETL Specialist

Project: Credit Risk ,EOne project

 

 

·         Designed and implemented stored procedures and triggers for automating tasks.

·         Created automate processes through stored procedures utilizing T-SQL to facilitate additional production capacity and not overburden the main data server.

·         Reviewed data and classified the tables/measures functions by using multiple queries, views and procedures.

·         Designed database schema contains over 30 tables such as users, groups, threads and posts.

·         Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects. Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.

·         Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.

·         Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.

·         Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs.

·         Involved in Creation of Dimensions using  STAR  and SNOWFLAKE Schema.

·         Created Logical & Physical Data Modes using Entity Relationship Diagrams.

·         Created classes and dimension and measure objects according to business requirements.

·         Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting, so create reports that draw content from a variety of data sources.

·         Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.

·         Deployed SSRS Reports in SharePoint for web based access for multiple end users.

·         Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

·         Created reports using stored procedures and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.

·         Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

 

Environment: Windows XP, MS SQL Server 2014, SQL Server Management Studio (SSMS),NOSQL,NewSQL,Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

 

 

TIAA, Charlotte,NC                                                                                                                    April 2017 – Oct 2017

SQL Server SSIS/SSRS Developer

Project: Cyber Risk Assessment Acceleration

 

Description:

TIAA, formerly TIAA—CREF, is a financial services organization that is the leading retirement provider of financial services for the academic, research, medical, cultural and governmental industries.TIAA was created  as a stock life insurance company for the purpose of providing retirement income for professors through fixed premium guaranteed deferred annuity contracts.A nonprofit organization that provides investment and insurance services for those working in education, medicine, culture and research..

 

·         Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions using SSIS.

·         Used C# scripts in SSIS script task to run custom scripts in package flow.

·         Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other.

·         Worked with Business Analysts for gathering the requirements & implementing the tasks.

·         Conducted code walkthroughs and review peer code and documentation.

·         Configure TFS environment such that SQL Reporting and SharePoint interact with each other.

·         Knowledge on  maintaining  Production  Servers  which  are  in  remote location.

·         Performed Unit Testing of ETL Programs to support QA on End-to-End testing.

·         Collaborated with development team during all phases of the project to promote successful delivery of quality products to our customers.

·         Ability to work independently  as  well  as  work  with  teams  having varying backgrounds on complex  issues  and  have  strong  verbal  and communication skills.

·         Analyzing the requirements and discussed with managers and leads on the functionality.

Involved in SDLC followed by Agile methodologies to produce high quality software model using N-Tier Architecture

·         Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2016

·         Wrote complex SQL queries, Stored Procedures,CTE’s and Views.

·         Involved in creating multiple parameterized Stored Procedures, which were used by the reports to get the data.

·         Regression testing was performed after each new build of the application.

·         Involved in the process of Defect logging and Defect follow up in Team Track.

    .

Environment: SQL Server 2014,Autosys,TFS tracker &, Sharepoint,SSIS 2014, Visual Studio 2008,SSRS 2014, T-SQL, Visio 2015,Enterprise Manager,  Windows Server.

 

Wells Fargo, Charlotte,NC                                                                                                              Sep 2016 – March 2017

SQL Developer & ETL Specialist

Project: Comprehensive Capital Analysis and Review(CCAR)

 

Description:

CCAR reviews are part of the “stress testing” conducted annually by the Federal Reserve to determine a bank’s capital adequacy. The goal behind it is for important banks to have a reliable two-year documented capital plan that demonstrates that they have sufficient capital to continue operating soundly during times of economic distress & to have a robust capital planning process that includes a sophisticated understanding of their unique potential risks. I was part of Data Services team which supplied data for CCAR.

 

·         Installed, configured, maintained and supported SQL server 2010 and 2012 in different environments.

·         Worked with Business Analysts for gathering the requirements & implementing the tasks.

·         Conducted code walkthroughs and review peer code and documentation.

·         Uploaded the source code to version control tool (SVN).

·         Developed various SSIS packages for the ETL process involved in CCAR application.

·         Designed & implemented generic packages for all CCAR templates in SSIS.

·         Performed Unit Testing of ETL Programs to support QA on End-to-End testing.

·         Collaborated with development team during all phases of the project to promote successful delivery of quality products to our customers.

·         Expertise in Autosys Job Scheduling through JIL file and extensively worked on production support.

·         Created JIRAs to track efforts,assign work and generate reports for the team capacity .

·         Created SSIS Packages to export heterogeneous data from OLE DB Source (SQL), Excel Spreadsheet and flat files.

·         Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

·         Documentation  of  all  the  processes  involved  in  maintaining  the database for future reference.

·         Worked with DBAs in order to schedule SSIS  packages  as  jobs  either daily, monthly, yearly or ad-hoc.

·         Created Email Alerts for successful or unsuccessful completion of  scheduled Jobs.

·         Written and executed complex T-SQL queries using SSMS for back end data validation testing.

·         Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like

OLEDB Command, Conditional Split, Lookup, Multicast,Data Conversion and Derived Column.

·         Implemented Metrics Checks for data loads in SQL to compare row counts & send Email notifications using SSIS

Packages.

·         Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.

·         Used Report Manager to assign roles, permissions and to create report schedules.

·         Rendered reports in different formats like pdf, excel etc tobe executed automatically on weekly or monthly basis and

managed subscriptions.

·         Development of mappings according to the ETL specifications for the staging area data load using SQL Server

Integration Service & SQL Server 2008 R2.

·         Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

·         Implemented Slowly Changing Dimension (SCD) in T-SQL using MERGE.

·         Developed a package to copy tables data from one environment to another(UAT to Prod) dynamically using SqlBulkCopy in script task.

 

Environment: SQL Server 2012,2010,2008 Autosys, JIRA tracker & Tortoise SVN for source control, Sharepoint, Visual Studio 2008,SSRS2008, T-SQL, Visio 2010, Crystal Report2011,Enterprise Manager,  Windows Server.

 

 

B/E Aerospace, New Berlin, Wisconsin                                                                                         Feb 2015 – Aug 2016

SQL Server BI Developer (SSRS/SSIS)

Project:United Launch Alliance(ULA)

 

·         Created complex Stored Procedures, Triggers, Functions, Indexes,Constraints, Tables, Views and other T-SQL code and SQL joins for applications.

·         Create SSIS and DTS packages to process the data. Make use of various Control Flow and Data Flow items from Toolbox. Perform Error handing and version log using Event Handler.

·         Work in Stored Procedures to prevent SQL Injection.

·         Manage Large Scale Stored Procedures and tuning to reduce execution time.

·         Developed and maintained a backup and recovery strategy for all databases.

·         Work with EVENT MANAGER to manage the whole scheduling reports and manage recipient scheduling.

·         Used Report Manager to assign roles, permissions and to create report schedules.

·         Used Lookups Transformation  to get the data from reference data sets .

·         Created permanent tables, temporary tables and table variables.

·         Responsible for hiding and disabling attributes and attribute hierarchies.

·         Developed T-SQL queries and Stored Procedures with multiple parameters to created data sets for reports.

·         Created report snapshots to improve the performance of SSRS.

·         Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.

·         Implemented procedures for coding and debugging of Progress 4GL applications.

·         Assisted in designing, development and testing of existing Progress and Open Edge applications.

·         Provided technical assistance for delivery of bug fixes and improvements to Progress and Open Edge applications.

·         Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, to SQL Server and created complex SSIS packages using various transformations.

·         Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.

·         Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

·         Created Stored Procedures to retrieve data from CDC enabled tables to load all deltas into destinations.

·         Created SSIS package to loop through multiple shared folders for multiple file servers to get all the files along with file path and folder names.

·         Created Event Handlers for the SSIS package on Error, on Post execute.

·         Identified the dimension, fact tables and designed the data warehouse using star schema.

·         Created Stored Procedures to load data into fact tables and dimensions tables for spot fire reporting dashboard.

·         Write Complex Crystal Formula to format report as business logic .

·         Crosstab Report with Crystal Report to provide unlimited dynamic column in report.

·         Export and mail Crystal report data with different type and format.

·         Active Directory Basic operation and integration with related application for directory entity.

·         Manage Group, Role, Organizational Unit for users in Active directory.

 

Environment: SQL Server 2012,2010,2008 Control-M Manager, DTS, Sharepoint, Visual Studio 2008,SSRS2008, T-SQL, Visio 2010, Crystal Report2011,Enterprise Manager,  Windows Server.

 

 

 

EMC Corp, Research Triangle Park, NC                                                                                            Sep 2012 – Jan 2015

MS SQL Server Developer/SSRS

 

·         Designing and Developed queries using Microsoft visual studio 2008 R2.

·         Created Database Diagram using third party tool Erwin in beginning of the project, identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.

·         Created database and database objects like tables, stored procedures, views, triggers, rules, defaults user defined data types and functions with T-SQL to facilitate data consistency.

·         Created multiple hierarchical aggregates for faster performance.

·         Created perspective of the cube to simplify the process of browsing for the end users.

·         Supported all production operation activities with focus on integration and development of new and existing products and services. , control, and automation opportunity to improve overall access to information.

·         Created report snapshots to improve the performance of SSRS.

·         Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with error description.

·         Involved in writing MDX Scripts for the OLAP CUBES and Developed multidimensional Objects using MS Analysis.

·         Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.

·         Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

·         Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

·         Administrated the created reports by assigning permission to the valid user for executing the reports.

·         Designing and developing the web forms using ASP.Net 2.0.

·         Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.

·         Created different business classes and interfaces using .Net Framework 4.0 with Object Oriented Programming Methodology.

·         Provide Support to other teams to fetch the data from the centralized database using ASP.net XML Web Services.

 

Environment: SQL Server 2005, T¬SQL, Window 200 Advanced Server,.NET,NOSQL,NewSQL ETL, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9i/11g SQL Server Analysis Services