Surya

+816*******

Email Id: acto8v@r.postjobfree.com

SQL/MSBI DEVELOPER

Professional Experience:

7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using SQL Server 2000/2005/2008/2008R2/2012/2014.

Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.

Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .

Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.

Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.

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

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Experience in Visual Studio development environment, for windows and web based applications having used them for professional and academic projects.

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode.

Experience in Agile Methodology for full life-cycle of the project such as planning analysis, prototyping, design implementation, testing, release and following for next iteration as per needs.

Experience in web development with Microsoft technologies as C#, ASP.NET, MVC, Ajax, Entity Framework, ADO.NET, LINQ, Web services & WCF.

Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Caching and Configuration Management Application Blocks).

Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.

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

Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS:

Languages

T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases

MS SQL Server Denali,2012,2008R2,2008,2005,2000

DWH / BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling

MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages

MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity,Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau,MS projects

Operating Systems

Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

Education:

Bachelor of Technology in Electrical and Electronics Engineering from ANU, India.

Professional Experience:

Sonexus Health, Lewisville, TX Nov 2014 – Till Date

MS SQL/MSBI Developer

Sonexus Health empowers pharmaceutical manufacturers with comprehensive commercialization solutions. The main task of this project was to create and implement packages to extract data from OLTP systems to the Staging Database and loading into Enterprise Data Warehouse and to Generate Reports according to user.

Responsibilities:

Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.

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

Responsible for identifying and defining Data Source and Data Source views.

Working in an agile Environment to deliver higher-quality software far more rapidly.

Successfully organized initial set of requirements into master list of Use Cases.

Involved in development of Web Forms, Classes using C#.NET that incorporates both MVC architecture and database connectivity.

Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

Involved in creating calculated members, named set, advanced KPI’s for the SSAS cubes.

Created DSV, Cubes, and Dimensions, MDX for SSAS Reports.

DDL Scripts for generating Tables, Views, Functions.

Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.

Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.

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

Identified and worked with Parameters for parameterized reports in SSRS 2008r2/2012.

Performed detailed analysis of project requirements and assisted in the development of functional specifications.

Worked with the VAN to implement the necessary enhancements and monitor document transmissions.

Performed detailed design and mapping specification creation for translation between Legacy and EDI formats.

Hands on experience with developing HIPAA transactions: 270, 271, 276, 277, 278, 834, 835, 837(P, I, D), 997/999.

Experience in developing, implementing and testing EDI ANSI X12.

Analyzed and designed maps for various transactions like 834 (Benefit

Enrollment and Maintenance), 835 (Health Care Claim Payment/Advice), 837 (Health

Care Claim).

Processed, controlled, and troubleshoot EDI process to ensure efficient day to day operations.

Diagnoses problems with EDI processes, working with other technical and/or business

resources as necessary for assistance. Troubleshoots application problems. May provide on-call application technical support for production systems

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access and client/server applications.

Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s, redesigning schemas and many more.

Also, went through query execution plans, sql profilers and did query optimization.

DDL Scripts for generating Tables, Views, Functions.

Helping Development Team in deploying and testing the application, which uses SQL Server as a database.

Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.

Environment: SQL server 2014/2012/2008 R2, Windows Server 2012/2008R2 Enterprise Edition, Tableau, SSRS, SSIS, SSAS, SSMS, T-SQL, SQL Profiler, SQL Server Agent, VSS, SQL Diagnostic Manager, HTML, ASP .Net .

BANK OF AMERICA, Broadway, NY Mar 2012 – Oct 2014

MS SQL/BI Developer

Description: Bank of America is highly diversified financial services organization. The corporation engages in commercial and retail banking, electronic payment processing services, and investment advisory services in the United States.

Responsibilities:

Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.

Developed the flow charts and diagrams as well as translation of the detailed designs with Lotus Notes application.

Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.

Provided ongoing Qlikview implementation and support.

Outlined new features of Qlikview for clients.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Created SSIS packages to validate, extract, transform and load data to data warehouse databases.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Handled Tableau admin activities granting access, managing extracts and Installations

Built connections to/pulling data from AS400, mainframe/db2 and Oracle.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Worked on Database Compression for different databases to save space across different environments.

Wrote many stored procedures for cleaning, manipulating and processing data between the databases.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Created different Power Pivot reports as per the client requirement.

Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).

Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.

Repaired/recreated PPS reports damaged in the conversion process.

Worked on Filtered Views, views and Base table integration between different Source systems.

Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.

With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.

Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.

Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.

Interacted with vendors, developers and customers to manage the business requirements.

Verified business requirements and functional specifications.

Environment:

Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012, TSQL, PL/SQL, Informatica, Visual Studio 2008, SharePoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

FEI Systems JUN 2011 – Feb 2012

Columbia, MD

SSIS and MS SQL Developer

Description:

Fei is a leading information technology, services, and analysis company specializing in healthcare solutions for federal, state and local governments. In the past decade, we have been at the forefront in our primary areas of expertise - Behavioral Health Data Systems, Long Term Services and Supports Software Solutions and all phases of the Software Development Life Cycle for Federal clients.

Responsibilities:

Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Created SSIS packages to validate, extract, transform and load data to data warehouse databases..

Built connections to/pulling data from AS400, mainframe/db2 and Oracle.

Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Worked on Database Compression for different databases to save space across different environments.

Wrote many stored procedures for cleaning, manipulating and processing data between the databases.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.

Repaired/recreated PPS reports damaged in the conversion process.

Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.

Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.

Interacted with vendors, developers and customers to manage the business requirements.

Verified business requirements and functional specifications.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0

Gartner Group Inc. Oct 2009 – May 2011 Stamford, Connecticut

MS SQL, SSIS, SSAS and SSRS Developer

Domain: Financial

Description: Gartner Group, Inc. is the world's leading information technology research and advisory company which has many resources like Gartner Research, Gartner Executive Programs, Gartner Consulting and Gartner Events to deliver the technology-related insight to the clients.

Responsibilities:

Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.

Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.

Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.

Created complex joins and implemented Constraints on tables for maintaining Data Integrity.

Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.

Designed and developed custom .NET components and user controls using ASP.NET

Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.

Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.

Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.

Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.

Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.

Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.

Created Tablix reports, Tabular/Matrix reports based on requirements.

Created Dashboards using SSRS.

Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.

Created databases, tables, and fields for data entry, performing database capacity planning.

Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.

Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

HDFC Bank, Hyderabad, India May 2008 - Sep 2009

SQL Server Developer

Description: This project was for the Automobile Finance division of a leading bank. The department in the company provides customers with loan solutions to pay for and manage the cost of automobile. Customer-centric data base was built to analyze transactions across finance, marketing, risk, collections, and consumer relation was developed.

Responsibilities:

Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system

Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)

Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.

Implemented Exceptional Handling

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports

Creating and automating the regular Jobs.

Tuned and Optimized SQL Queries using Execution Plan and Profiler

Rebuilding Indexes and Tables as part of Performance Tuning Exercise

Involved in performing database Backup and Recovery

Worked on Documentation using MS word

Contact this candidate