SUMMARY

• Microsoft SQL Developer / Data Analyst with Over 6 years of experience at designing, analyzing, adapting, developing, implementing, testing, and maintaining database solutions through Business Intelligence usingSQLServer 2012/2008R2/2008/2005,SQLServer Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS).
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types,effective functions,Cursors and Indexes using T - SQL.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating ComplexStored Procedures, Triggers, User-defined Functions, CTE's Views and Cursors
• Strong experience in developingparameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005/2008 using data from a variety of sources.
• Proficient in various Extracting, Transforming, and Loading (ETL) tasks, using different transformations like Slowly Changing Dimension, Lookup, Conditional Split, Derived Column to manage data.
• Experienced increating Job, Alert and scheduling execution ofSSIS Package usingSQLServer Agent.
• Experience in creating stored procedure for generating reports usingSQLServer Reporting Services (SSRS).
• Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environmentsand maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of Data Marts, Data warehouse,Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, OLTP Relational Schema and OLAP Dimensional Modeling.
• Able to communicate effectively with multifunctional teams, programmers and technical staff at all levels. Strong customer service orientation.
• Experienced in consulting with users, resolving problem and meeting specific technical and business needs.
• Participated in requirements analysis reviews and Design sessions to understand the requirements and designing Reporting Solutions.
• Committed team player with excellent communication skills and capable of working independently. Good problem solving skills, initiative and judgment.
• Good business understanding and effective at working across multiple teams within an organization.

TECHNICAL SKILLS

Platforms: Windows XP/Vista/7/8, Windows 2003/2008/2012 server, Microsoft SQL Server 2000/2005/2008/ 2012 , Mac iOS, Linux, Unix, Microsoft Azure

Tools: MS Visual Studio 2008/2010/2012 , SQLServer Business Intelligence Development Studio (BIDS), SSMS, SSRS, SSIS, SSAS, Microsoft Visio, Crystal Report, SQL Report Builder, SQL Query Analyzer, SQL Profiler, SQL Performance Monitor, Database Tuning Wizard, Import & Export

Software: Microsoft Office 2003/2007/2010/2013 , Microsoft Project 2005, Macromedia Flash MX, Macromedia Dreamweaver MX, Microsoft SQL Server, Joomla, Word Press, Photoshop, Microsoft Visio, Epi-Info, SPSS, Tableau

Programming Languages: T-SQL, C++, Visual Basic, Java, HTML

Databases: Microsoft SQL Server 2000/2005/2008/ R2/2012, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Data Analyst/ SQL Developer

Responsibilities:

• Created reports with drill down, drill through, cascading parameters, conditional formatting, interactive sorting, dynamic grouping functionalities and custom assembly
• Developed different kind of reports such asSub Reports,Charts,Matrix andLinked reports while using cascaded parameters to generate reports from two different Data Sets about potential risks and benefits of probable locations of new branches.
• Wrote stored procedures, triggers and queries for creating reports from data marts, also worked with various report items like tables, matrices and images, and eventually formatted reports to export to Excel as well as to print.
• Responsible for resolving report defects in the dashboard application, and published reports to testing and production environments and facilitated the testing process.
• Responsible for Data Modeling, created data models using Microsoft Visio, and objects like tables, views, indexes, user defined functions and triggers.
• Created SSIS packages to extract data from OLTP to OLAP systems
• Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
• Extensively used derived column, union all, conditional split, audit, script,lookup, copy column, row count in SSIS packages.
• Responsible for creating SSIS packages to load data to dimension and fact tables inSQLServer data mart.
• Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS.
• Performed daily tasks includingbackup and restore by usingSQLServer 2012 tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.
• Developed logical and physical data models for schemas using MS Visio.
• Used tools such as performance monitor, query execution plans to increase the efficiency of the queries.

Confidential, Dallas, TX

Data Analyst/ SQL Developer

Responsibilities:

• Worked effectively across functions and establish strong relationships with key functional stakeholders (Risk, Finance, IT and Compliance Units)
• Responsible for Risk Data collection processes that create monthly/quarterly/annual risk data reporting for regulatory reporting and monitor data accuracy and completeness to ensure data quality
• CodedSQLand T-SQL for database access, database modifications, and construct database stored procedures. Adhere to company standards, concepts, practices, and procedures for database load
• Identified data sources, constructed data decomposition diagrams, provided data flow diagrams and documented the process
• Created and designed the multiple dimensions and fact table for business report purpose
• Designed and managed schema objects such as tables, views, indexes, stored procedures, triggers according to business rules usingSQLserver 2008
• Responsible for the maintenance and support of the data warehouse, analysis services cubes, dashboards, and reporting needs
• Created SSIS packages for application that would transfer data among servers and perform other data transformations
• Identified data quality issues and supported the data governance initiative by participating in necessary activities including data profiling
• Managed the security of the servers, creating the new logins and users, changing the roles of the users Manage Issues, Dependencies and Risks pertaining to Requirements Definition and Management Process

Confidential, Mather, CA

BI / Data Analyst

Responsibilities:

• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Created packages using MSSQLServer Integration Services (SSIS) for dataextraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQLServer Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Worked with BCP utility and Bulk Insert to load data from different data sources toSQLServer.

Confidential

SQL Server Developer

Responsibilities:

• Performed code and tested activities for Business Intelligence project using the Microsoft suite of products, including SSIS, SSAS.
• Designed and developed SSIS packages to move data from different environments within the organization.
• Created and modified views and stored procedures according to technical specifications and business requirement.
• Created configuration files in order to deploy packages in different environments.
• Developed, maintained and executedSQLscripts/queries and validated completeness, integrity and accuracy of data.