SUMMARY

• SQL Server/BI developer with more than 8+ years of IT experience in Database/ Data Warehouse design, development & administration using Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS)
• Experience in full IT development Life Cycle in Financial and Healthcare industry
• Expertise in creating/modifying Tables, Views, Stored Procedures, Functions, indexes and Triggers and in depth knowledge in query optimization & performance tuning
• Have strong experiences in creating SQL Server SSIS packages (ETL) to import, extract, and transform data between databases and external data sources
• Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and using SQL Server 2000/2005/2008. Used Version control tool Team foundation server (TFS) for the entire development cycle.
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. - - -
• Hands on experience in using version control software s like VSS, Rational clear case and (TFS) Team Foundation Server.
• Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations
• Experience in migration of data from external database such as MS Excel, MS Access, Oracle, and DB2 into MS SQL Server by using Import Export Wizard, DTS and SSIS / ETL
• Proficient in exporting and importing data to and from SQL Server to any OLEDB and ODBC provider using extensive knowledge
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in developing and deploying reports using MS SQL Server Reporting Services (SSRS) 2012/2008R2/2008/2005
• Experience in creating ad-hoc reports by using Excel and Report Builder in SSRS 2012/2008R2/2008/2005
• Experience in creating and developing OLAP cube using SSAS
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
• Experience in designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems
• Experience in developing physical database architecture using Erwin Data Modeler
• Excellent Analytical, Interpersonal and Communication skills, fast learner, diligent and versatile team player
• Experiences in various types of financial products: Mutual Funds, Index Funds, Credit Rating
• Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure or complex scenarios.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• Transact-SQL (T-SQL)
• Visual Studio
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• SQL Server Profiler
• Version Control: Visual SourceSafe (VSS)
• Team Foundation Server (TFS)
• SQL Query Analyzer
• ERWIN
• Netezza
• MS SharePoint
• MS Access
• MS Office Suite
• MS

PROFESSIONAL EXPERIENCE

MS SQL Server SSAS/SSRS Developer

Confidential, Winston - Salem, NC

Responsibilities:

• 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, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• 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 SSASstorage and partitions and Aggregations, 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 SSAS200R2 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 usingADO.NETwith Database.
• ImplementedADO.NETconcepts 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 usingADO.NETand SQL Server 2005
• Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Designed and built the ETL for mass uploading of product attribute changes into a custom-built analyticalMDMsolution.
• Developed Subject Areas forMDMusing 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. Reports variables are passed from ASP.NET web pages.
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks
• Involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Used .Net Framework for creating Reports and also for customization of reports.

ENVIRONMENT: 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.

SQL Server Developer/ MS BI Developer (SSIS/ SSAS/ SSRS)

Confidential, Charlotte, NC

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, extraction and transformation.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan,SQLProfiler and Index Wizard to optimize queries, locate and eliminated bottleneck and enhance the performance of databases.
• Created ETL packages using OLTP data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Used bulk insert in SSIS and SSMS for faster transfer of data.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Used Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Derived Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Created Multi-Dimensional cubes using SSAS 2012 based on business requirements.
• Used MDX to extract cube data and created pivot tables for revenue analysis.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Used sub reports functionality for complex report calculations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008R2, Microsoft Visual Studio, SQL server Integration Services, SQL server Reporting Services, SQL server Analysis Services, SQL Server Profiler, Netezza, Cognos, Erwin r7.2, MS Dynamics CRM, Windows 7, MS Office 2007/2010, Visual SourceSafe (VSS), MS SharePoint

MS-SQL Server / MS BI Developer (SSIS/ SSRS)

Confidential - Jacksonville, FL

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Experienced in creating package dynamics by using SSIS expressions and variables.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created reports using SSRS based on business requirements.
• Developed drill down, drill through, and parameterized reports using SSRS

Environment: MS SQL Server 2008, Visual Studio 2008, SQL server Integration Services, SQL server Reporting Services, SQL server Analysis Services, TFS, VSS, MS Visio, MS Office 2007(MS Excel, MS Access), MS Windows Vista

MS SQL Server Developer/Database Analyst

Confidential - Birmingham, AL

Responsibilities:

• Installed and Configured SQL Server 2005 successfully.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Developed a Conceptual model using Erwin based on requirements analysis
• Actively involved in Normalization (3NF) & Demoralization of database.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Database creation; database tuning, performance planning, backup planning and database administration.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems
• Proactive and Reactive tuning of databases in every stage of the project.
• Created Tables, Views and Indexes.
• Wrote Triggers and Stored Procedures.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. (Execution Plans).

Environment: MS SQL Server 2005, T-SQL, Microsoft Visual Studio 2008, SQL server Query Analyzer, Erwin r7.1/7.2, Oracle 9i, MS Office 2007, MS Access

SQL Server Developer

Confidential - Atlanta, GA

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Involved in documenting process using Doors.
• Responsible for designing different Data warehouse schemas like Start and Snowflake using Erwin.
• Involved in developing Logical and Physical Data Models.
• Performed user interviews and participated in JAD sessions.
• Map the source and target databases by studying the specifications and analyzing the required transforms.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Experience with all the activities for data migration including data extraction, data transformation, data loading, data cleansing, database design and development.
• Implemented constraints on tables using some basic requirement.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Extensive experience on using Variables, Passing Parameter to each and every individual task.
• Worked on Different ETL tool Data Junction good understanding of that tool too.
• Created Project Documentation on data migration process strategy based on the blueprint.
• Worked on Company Main Part of Control Logic for calculating Total No of Claims, Billed Amount and Paid Amount.

Environment: MS SQL Server 2008/2005, SSIS, Data Junction(ETL tool),T-SQL, Visual Studio 2005/2008, MS Office, SQL Profiler, SQL Job Agent, Windows 2000/2003,SQL Tuning, Oracle 8i, PL/SQL Developer.