SUMMARY

• Around 8+ years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2012,2008, 2005, 2000 in Production, Testing and Development.
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents.
• Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2008R2 and 2012.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/ /2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Knowledge of Relational Database Management systems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T-SQL(DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up theServer Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Install and Configure SQL Server 2012, 2008, 2008R2, 2005 on Virtual Machines.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SSMS onSQLServer 2005/2008/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server 2000/2005/2008.
• Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes.
• Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Experience in deploying RDL file in SSRS to the reporting server and assigning roles to render the report to recipients.
• Good hands on experience in Microsoft Power BI tools such as Power View, Power Pivot, Power Query and Power Map to retrieve, analyze and present data in well-designed visualizations.
• Experience on high availability SQL Server Solutions like backup/restore, Log shipping, Mirroring and scheduling the jobs.
• Experience in Migrating raw data from COSMOS to SQL Server.
• Knowledge in developing Stand-alone and web applications using .NET Framework, C# and ASP.Net.
• Experience in Data Modeling using Erwin Design Tool.
• Knowledge of Networking Concepts and Object Modeling Technology.
• Good Experience working and implementing processes in different business domains like Finance and Mortgages
• Good interpersonal, Analytical and Communication skills.
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.

TECHNICAL SKILLS

Languages: Transact SQL, PL/SQL, C, Visual Basic 6.0, HTML, .NET.

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 9i,10g,11g, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), SQL Server Migration Assistance (SSMS), Crystal Reports, Tableau

ETL Tools: DTS, SQL Server Integration Services (SSIS)

Data Modeling Tools: Erwin, MS Visio

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/2007/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL BI Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database viewsto implement the business logic and also created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data
• Analyzed, designed and created a star schema dimensional data model using Erwin for an enterprise data warehouse.
• Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal
• Creation of Data visualization using Power-BI tools such as Power pivot and Power view to support business decisions and integration with Excel.
• Visualized nation-wide growth of the sales using Power Map.

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010, IIS, VB.Net, Erwin, Power view, Power Map and Power Pivot

Confidential, MN

MS SQL Server Developer/BI Developer

Responsibilities:

• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created and updatedDatamodelsusing SQL DeveloperDataModeler(SDDM) for theData warehouse team
• Creating/ managing the project plan, task allocation, work with stake holders and PMO office for achieving project goals in an agile work environment.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Worked onFACETSData tables and created audit reports using queries. Manually loaded data inFACETSand have good knowledge onFACETSbusiness rules.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created SSIS Packages from BIML.
• Involved in developing applications in C# to meet the business requirements using Visual Studio .NET 2010.
• Designed, built and maintained data marts and numerous complex reports and scorecards, before development of the Data Warehouse.
• Did the forward andbackwarddata mapping between the fields in mainframe andFACETS.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Experience in creating snapshots of static reports and configure subscription.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Identified dimensions, facts, and grains within the data. Created an enterprise dimensional data warehouse data model by following the methodology of Data Warehouse.
• Built cubes for production application, partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS2008.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Identify sources for master data, identify data owners, analyze metadata, determine which applications produce master data, evaluate the data, data clean up by creating SSRS visualization
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Worked closely with the QA team to review and develop XML data standards and data sharing models
• Lead the team of developers to write efficient code.
• Involved in system and unit level testing.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS,No-SQL, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

Confidential, Pittsburgh, PA

SQL BI Developer

Responsibilities:

• Working as SQL Server Analyst / ETL Analyst using SQL Server 2008 for CMH Project.
• Source Controlling using IBM Rational Clear Case
• Developing and Management Database for Collateral Management and Hedging
• Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Design and Deploy SSIS Packages
• Creating SSIS Packages, Configure SSIS packages for different environments using DTSConfig
• Produce CSV, utilize CSV files as part of ETL Process
• Used .Net Scripts in SSIS
• Produce XML Files for Tibco (Real Time Data Transfer)
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Code deployments / configurations/ config management in various environments
• Implement Security, Roles, Logins, and Permissions
• Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
• Maintain Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autosys, writing JIL Scripts
• Enhance existing applications to meet new business requirements
• L3 Production Support on Rotation basis
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Capacity Planning DBs, Disk Requirements
• Deploy the code in various environments i.e. DEV/SIT/UAT
• Create and maintain DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, Pre-Prod)

Environment: SQL Server 2008 R2, 2012, VB.NET, Oracle 10g, Microsoft Visual studio 2010, Clear Case 7.1, Autosys, Share Point, SQL Server 2008 Integration Services, Quality Center 10.0, Compass Point

Confidential, Jersey City

SQL Server Developer

Responsibilities:

• Working as SQL Server Analyst / Developer / DBA using SQL Server 2008 for Atlas Data warehousing Project.
• Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),
• Actuarial Data Mart (ADM), DB according to the user requirements.
• Source Controlling, environment specific script deployment tracking using TFS
• Export the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users.
• Developing, Administering, and Managing corresponding databases: Consolidated Data Store,Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart
• Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain Physical Structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Analyze the Legacy Data, Import the data into DB that was verified and published by DMRB (Data Management Review Board)
• Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
• Creating ETL mappings using Informatica Power Center
• Day to Day maintenance of databases, Staging, Backup / Restores of databases.
• Deployment of Scripts in different environments according to Configuration Management, Playbook requirements
• Create / Manage Files/File group - Table/Index association
• Query Tuning, Performance Tuning
• Defect tracking and closing by using HP Quality Center
• Maintain Users / Roles / Permissions.
• Capacity Planning DBs, Disk Requirements
• Creating Range and Hash(by using MOD function) Table Partitioning, Index management
• Create and maintain DB Change Log to track the state of the DB in each environment (Dev, UAT, T02, T03,Conversion, Pre-Prod, etc.)

Environment: SQL Server 2008 R2, Team Foundation Server, Erwin 7.3, Model Mart 7.3, Share Point Server, Informatica 8.6, Cognos, Quality Center

Confidential

SQL Server Developer

Responsibilities:

• Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services and Dundas Reporting
• Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
• App Testing in Development, Production, DR
• UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2003.
• Deploy various reports on SQL Server 2005 Reporting Server
• Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Create and maintain database for Incident, Problem Tracking, Metrics
• Working with SQL, and T-SQL
• Design Reports as of Internal User needs
• Access SharePoint Server using Web Services to deploy reports on Reporting Server
• Working with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configuring the Database Mail, Mail Operators using SQL Server 2005
• Creating Jobs, Job Notifications
• General Day to Day Database Administration
• Importing Data from various sources like DB2, Oracle, Excel, XML
• Ensuring Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, Oracle, Reporting Services (SSRS), Integration Services (SSIS)