Malinda

908-***-****

acqjy5@r.postjobfree.com

Professional Summary:

MS SQL Server Developer with 8+ years of strong experience in Health Care, Insurance, Retail, Finance and Banking domains.

Highly proficient in operating MS SQL Server 2012/2008 R2/2008/2005/2000 suite of products like SSIS, SSRS and SSAS.

Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation.

Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.

Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.

Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.

Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.

Conversant in working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server databases.

Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).

Expert in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.

Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.

Highly experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.

Good knowledge in developing Cubes and Dimensions using SQL Server Analysis Services.

Hands on experience in writing MDX queries to work with cube data.

Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.

Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.

Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.

Working knowledge in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, Drill-Down, Parameterized and for the end user requirement Ad Hoc Reports using SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).

Strong leadership, communication, problem-solving and multi-tasking abilities.

Technical Skills:

MS SQL Server 2012/2008 R2/2008/2005/2000/7.0, Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft Access 2007/2003/8.0, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Erwin Data Modeler 4.2/4.1/4.0, VB6, Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Power Point, T-SQL, PL-SQL, HTML, XML, C++, Crystal Reports 8.5, SQL Compare, SQL Data Compare, MS Visio 2003, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

Education:

Bachelor of Science in Aerospace Engineering and Mathematics.

Professional Experience:

GEHA Inc., Lees Summit, MO May 14 - Present

Role: SSRS/SSIS Report Developer

GEHA is a health insurance company which provides coverage to more than 1 million lives worldwide.

Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005).

Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.

Involved in database Schema design and development.

Migrated Database from SQL Server 2005 to 2008.

Experience in using SQL Server 2012.

Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.

Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.

Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

Enhancing and deploying the SSIS Packages from development server to production server.

Wrote the ETL scripts to load the data into database from various source files.

Experienced in error handling and troubleshooting the scripts in failure to load the data into database.

Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.

Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.

Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.

Expert in SSIS Deploying and Scheduling.

Developed modules of the application in ASP.NET, Silverlight and involved in writing C# classes.

Experience in Developing Script component in SSIS by using C#.

Experience in executing SSIS Package from ASP.NET and C#.

Identified and Defined Key Performance Indicators in SSAS 2005/2008.

Defined report layouts for formatting the report design as per the need.

Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).

Generated Reports using Global Variables, Expressions and Functions for the reports.

Created reports and Dash boards using Microsoft Performance Point service.

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.

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

Experience in using Star Team for source control. Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2008 R2/20012,, SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin7.2, SQL Server Profiler, Database Engine Tuning Advisor.

Retail Solutions, Providence, RI Aug 13 – May 14

MS SQL Server Developer

Retail Solutions, the largest and fastest-growing company in the Retail Execution Management field, has more experience with processing customer-specific retailer data than any other company. Ahold retailer on boarding process requires the files to be loaded in review database and convert it to the format downstream systems can understand which might include some cleanups and transformation. Data available in review database should be a raw load, with minimal or no transformation, which data operations can use to validate and define the mappings for the downstream system. This process also helps to verify the file format to the actual data and modify the file mappings if needed.

Responsibilities:

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.

Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.

Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.

Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS (SQL Server 2008).

Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.

Handled slowly changing dimensions to maintain the history of the data.

Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).

Involved in Designing and deploying cubes in SSAS environment using Snowflake Schema Designs for the operational data

Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.

Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services, SQL Server Analysis Services, MS Visual Studio2008, Windows 2008 and T-SQL, Erwin7.2, SQL Server Profiler.

PNC Bank, Columbus, OH Mar 12 - Aug 13

MS SQL Server/SSIS Developer

PNC Bank is a national banking institution in the United which offers banking, insurance, brokerage, and investment banking services. The main goal of the project was to migrate data from Legacy Source System involving extensive ETL process to load the data in MS SQL Server 2005 and Developing reports in SSRS.

Responsibilities:

Conducted detailed analysis of each Legacy source system interface with Data warehouse (DW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.

Worked with Project Manager and Business Analyst to understand business requirement and also involved in planning, defining and designing data based on business requirements.

Worked with data modeling product support team on tool features, functionality and maintenance.

Designed and developed SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to DW.

Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.

Developed Package Configuration by using SQL Server type for making Package dynamic.

Modified the Existing SSIS Packages and added more audits and alerts in case of package failure

Created Views to reduce complexity of end user.

Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.

Created Indexes to optimize performance of TSQL queries.

Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.

Created parameterized, Drill down and Drill through reports in MS SQL environment using SSRS.

Generated SSRS Report through SSIS Package using script component as per business requirement.

Involved in scheduling job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement.

Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Created documents for all Store Procedure, SSIS Package and SSRS Reports that I developed.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Server analysis services, OLAP, BIDS, Visual Studio 2008, T-SQL,VSS,, MS-Access 2007, MS Excel, Report builder, Crystal Report, ER Win R7.3 Windows XP Professional,,VB.NET, Performance point server, SQL Profiler.

Farmers Insurance, Woodland hills, CA Jul 11 – Feb 12

MS SQL Server/SSIS/SSAS/SSRS Developer

Farmers Insurance is a Insurance Group Which provides auto, home, small business, specialty, life, financial service. The major part of the project was creating the packages for extracting, migrating, loading data in data warehouse and creating Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as per the requirements.

Responsibilities:

Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."

Performed improvement of application by replacing the old cursor logic in various triggers by writing complex T-SQL queries.

Reversed engineer backend database to change the T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically.

Drew the flowchart of the trigger logic to remove the repetitive pattern in T-SQL scripts to reduce dependencies.

Created various types of performance reports from the TFS server database using SSRS.

Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to data warehouse (PDW).

Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.

Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.

Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.

Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using Sql Server Reporting Services(SSRS).

Scheduled execution and delivery of end of the day report using SSRS.

Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008R2/2008/2005, SQL Server Integration Services 2008, SQL Server Reporting Services 2008, Erwin 7.2, SQL Server Profiler, C#, VB.NET.

Magellan Health Services, Glen Allen, VA Dec 09 – Jun 11

MS SQL Server/SSIS/SSRS Developer

Magellan Health Services offers a comprehensive, integrated suite of products, including behavioral health management, radiology benefits management, and specialty pharmacy management. Being a member of the Client Interface Support team, responsibilities involved maintaining the physicians and member’s records within each client database I was involved in transferring the DTS packages to SSIS packages.

Responsibilities:

Installed SQL Server 2008 and configured the database.

Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file.

Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )

Created SQL Server Reports using SSRS 2008.

Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.

Modified the Existing SSIS Packages and added more audits and alerts in case of package failure

Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.

Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.

Identified the Data Source and defining them to build the Data Source Views.

Developed Query for generating drill down reports in SSRS 2008.

Designed and implemented stylish report layouts.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Id entified and worked with Parameters for parameterized reports in SSRS 2008.

Environment: MSSQL Server 2008/2005, SQL Server Integration Service, SQL Server Reporting Services, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), Windows XP, MS Acces, MS Word.

Oriental Bank of Commerce, Hyderabad, India July 07 – Nov 09

Jr. SQL Server Developer

Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions and for managing banks property and equipment.

Responsibilities:

Created and maintained database objects.

Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using TSQL.

Created various reports using MS Reporting Services.

Assisted in writing and optimizing complex SQL Queries.

Analyzed the existing application programs and tuned SQL queries using SQL Profiler.

Involved in writing scripts for the programs.

Loading data from various data sources using MS Data Transformation Services.

Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.

SQL performance tuning by modifying SQL or adding/changing indexes.

Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML etc.

Wrote and integrated stored procedures to generate the reports.

Provided on-call support for various projects.

Environment: SQL Server 2000, Sybase, DTS, Excel, MS Access 2000, ASP, MS SQL Reporting Services.

Contact this candidate