PROFESSIONAL SUMMARY:

• Around 9+ years of experience in IT industry, Business Intelligence, Reporting, Data modeling, Data Warehousing, Data Analysis, Design, Development, Implementation, OLAP and testing Data Warehousing Applications on various domains like Health, Insurance, Finance etc.
• Over 9 years of experience as aSQL Server Developer ofSQL Server … in various domains.
• Extensive experience in writing DataDefinition Language(DDL), DataManipulation Language(DML), Stored Procedures, Triggers, Views and Functions in complex T - SQL queries.
• Worked in SDLC (Systems Development Life Cycle) and Agile methodologies for developing systems/Software.
• Experience in analytical Database Design and DataModeling skills using ERWIN, PowerDesigner, TOAD and MS Visio.
• Experience in designing and building Business Intelligence applications using SQL Server and Microsoft BI Stack (SSIS, SSRS, SSAS).
• Highly proficient in developing, maintaining, and troubleshooting SSIS packages that include input\output datain variety formats from\to vendors and clients.
• Extensive experience in analyzing and interpreting data, producing clear and compelling reports for different audiences with graphs and charts using SSRS.
• Adept in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports using SSRS.
• Experienced in SQLServer Analysis Service (SSAS), Cubes, Dimension, Multidimensional Expressions (MDX) queries.
• Highly proficient in the use of T-SQLfor developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and dataintegrity, SQL joins and query writing.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
• Experience in Using multiple join statements to retrieve data from multiple tables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.

TECHNICAL SKILLS:

Databases: MS SQL Server, MySQL, Oracle, Teradata

Languages: C, C#, Java, Visual Basic, SQL, T-SQL, PL-SQL, HTML, XML, JavaScript

Reporting: SQL Analysis Services(SSAS), SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS)

Modeling Tools: Analytical and Transactional Data Modeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin, PowerDesigner, Microsoft Visio, ER Studio

Environment s: SQL Server Management Studio, MS-Office, Windows Server, Visual Studio, VISIO, Crystal Reports

PROFESSIONAL EXPERIENCE:

SQL BI Developer/Data Analyst

Confidential, BaskinRidge, NJ

Responsibilities:

• Actively involved in Business meetings and requirement gathering sessions as a part of the team for gathering and analyzing the requirements and needs for the end user.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Involved in designing OLAP Cubes in SSAS environment using Snowflake and Star Schemas.
• Designed application flow using Visio. Performed ETL mappings using SSIS.
• Developed and deployed SSIS packages for ETL from various sources into data warehouse production server.
• Extensively used SSIS transformations such as Slowly Changing Dimension, Script Task, Lookup, Merge, Derived column, Data conversion and Aggregate etc.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Responsible for creating Performance Point scorecard templates based on the business users requirements.
• Extensively involved in cube designing using SSAS and involved in the cube optimizations, named set calculated measures, aggregations, partitions and Time dimension calculations leverage that in Performance Point Server and Excel Power Pivot.
• Involved in the Processing, deployment of cubes/SSIS Package in test and productions environment.
• Extensively worked with performance point services to provide the best possible KPIs, Analytical Grid, Line chart and Scorecard to build the best possible Dashboard for the end client.
• Generated various reports (Pie and Grid, Decomposition Tree and other reports) to embed them into Dashboards, used sets and measure for dashboards.
• Defined dynamic KPIs using SSAS, analytical reports and Scorecard using MDX functions.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.

Environment: Microsoft SQL Server, T-SQL, ETS, PowerPivot, SQL Server Integration Services, SQL Management Studio, SSRS, SSAS, Windows Server, MS Visio, MS Excel, SharePoint, Visual Studio, asp.net.

SQL BI Developer /Data Analyst

Confidential, Lincoln, NE

Responsibilities:

• Worked on Teradata SQL Assistant, Proficient in transferring data from Teradata view or Table using SSIS package and deploy to SQL server, excel, access and other destinations.
• Proficient in using Customized SQL Tool. Created data Schemas (Name Spaces), views and established various connections with Teradata and SSMS in Customized SQL tool.
• Proficient in Data Migration from sources like Teradata, MS Access, SQL server, Text Files, Excel to SQL server using SQL Server Integration Services (SSIS).
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Worked with SQL Agent to create new SQL Job, as well as monitor and maintain existing SQL jobs.
• Creating new SSIS Packages and Marinating old packages.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Experience in using BCP and Bulk Insert commands while working with Flat files, Excel file.
• Worked with import export wizard to Import and export Data to and from SSMS.
• Worked with various SQL Joins, Aliases and SQL Functions.
• Proficient in various Data Flow Transformation in SSIS
• Create database objects such as tables, views, stored procedures, Triggers etc.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.

  Develop reports in SQL Server Reporting Services.

• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports basing on the requirements using SSRS.
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
• Design, Develop and Deploy SSIS Packages.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Participate in development and creation of Data warehouses.

Environment: MS SQL Server Enterprise Edition, Teradata, SQL Assistant, Tabular, VBA, ETL, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, Crystal reports, OLTP, UNIX, Linux, MDX, Excel Pivot, Office-2007, DB2, MS Excel.

MS SQL Server Developer/SSIS Developer, Data Modeler

Confidential, White Plains, NY

Responsibilities:

• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQLcode and SQLjoins for applications following SQL code standards.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Design and Develop SSIS packages using Control flow, Data Flow and Transmissions.
• Monitor packages every day.
• Involved in Error Handling, Check points, package configuration.
• Developed SSRS Reports using SQL Server, Cubes as data sources.
• Formatted the reports using the Global variables, expressions and Functions
• Optimizing slow performing query/ETLs(DTA, Query Execution planning, Index, Filtered index, covering index, Column store index, Statistics, Query hints)
• Designed, created and implemented multi-threaded partitioned data load to transfer very large volume of data
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc, in SSIS Packages
• Writing highly complex queries with Left Joins, Self Joins, full Outer Joins.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Environment: SQL Server 2012/2008 Enterprise Edition,SQL SSIS, OLAP, OLTP, ETL, Enterprise manager, Windows Server 2008.

MS SQL Server Developer/SSIS Developer, Data Modeler

Confidential, Boston, MA

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Hands on experience in gather requirement and understand business process then generate conceptual, logical and physical Data Model. Based on the Data Model generate DDL Scripts for new Database Creation and Data Mapping in ERStudio Data Architect.
• Expert in Business Intelligence products such as Microsoft BI solutions. Worked high level and detailed analysis, defining and writing programs using MS-SQL BI stack. Also, performed system integration and deployment activities, prepare system support documentation, and document program and system functions.
• Experience in evaluation to suggest size of new Database and use database inventory to identify the most preferable server based on the requirement and also identify new database's dependency on any existing databases.
• Hands on experience to use SQL Server Profiler to identify the problem of stored procedure and based on the problem provide solutions like create appropriate indexes or re-write existing stored procedures.
• Expertise in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Created Packages to group logically related column types and to transfer data.
• Used VSS & TFS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Environment: MS SQL Server, VSS, TFS, Microsoft Visual Studio, SQL Server Management Studio, Microsoft Visual Studio, SSIS, MS Excel, T-SQL, ER Studio.

MS SQL Server/SSIS/SSRS Developer

Confidential

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Gathered data and documenting it for further .
• Designed DB using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Lookup Values & implementing rules provided by Business in the mapping document.
• Created SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Generated parameterized reports, sub reports, tabular reports using SSRS.
• Designed, Developed and Deployed reports in MS SQLServer environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQLServer, SQLServer Integration Services, MSExcel,MSAccess, Enterprise Manager, Management Studio, SQLProfiler and SSRS.

SQL Server Developer

Confidential

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment forSQLServer.
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQLQueries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Involved in performance tuning and monitoring of both T-SQLand PL/SQLblocks.
• UsedSQLProfiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQLprocedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQLfor various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Responsible for Cleansing up database for Maintenance of the database.
• Responsible for unit testing, writing design documents and uploading it to share point server.

Environment: SQL Server, T-SQL, MS.NET Framework, MSVisio, HTML, XML, VB.NET, SQLProfiler, Windows Server, Visual source safe (VSS).