SUMMARY

• 7+ years of strong experience in the IT industry as a MS SQL Server 2016/2014/2012/ 2008 R2/ 2008/ 2005 Developer/BI Developer.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in analytical Database Design and Data modeling skills using MS Visio and ERWIN.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008/2008 R 2/ 2012/2014/2016.
• Skillful in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server 2012/2014 Analysis Services (SSAS).
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server).
• Experience in SQL server administrative skills including, backups, disaster recovery, database maintenance, user roles, authentication and authorizations and database creation.
• Database design & administration experience on SQL Azure, MS-SQL Server 2016/2014/ 2008 R2/ 2012.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Create Power Pivot models and Power Pivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Strong experience in data retrieval using ADO.NET data objects such as Dataset, Data Reader, Data list, Data Adaptor.
• Strong in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in extracting, transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility. Working knowledge with Oracle BI Applications, extracting data from multiple data sources such as OBIEE, Siebel, flat files and loading into OLAP systems.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL/Sybase Server Reporting Services (SSRS/Crystal)
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.
• Having hands on Linux server, for reviewing logs and also to login toCisco.
• Experience in Data Conversion and Data Migration using SSIS/Crystal across different databases like Oracle, MS access and flat files.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2014/2012/2008 R 2/2008/2005.
• Experience in migration of SSRS/Crystal reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/2014/2016.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Quick learner, excellent communication skills and good performer both in team and independent job environments.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, VBScript, C#.Net, JavaScript, ASP, HTML 4.0, DHTML, XML.

Databases: SQL Server 2016/2012/2008 R 2/2008/2005/2000 , Oracle 9i/8.x, DB2 MS Access, Teradata, MS Azure

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, Power BI, Tableau.

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Business Objects XI R2/R3.

Other Software: MS Office- 2007/2010, Adobe Professional.

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

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, SQL Server Analysis Services (SSAS), TOAD

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr SQL Server Developer

Responsibilities:

• Involved in writing and modifying stored procedures to get data from database
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Developed complex reusable formula, parameter reports and reports with advanced features such as conditional formatting, built-in/custom functions and stored them in repository explorer.
• Migrated database from SQL server 2014 to SQL server 2016 using utilities i.e. exp/imp and attach/detach for SQL servers 2016 futures.
• Wrote Formulas to calculate the Percentages, subtotals, running on totals and Summaries based on the group levels.
• Knowledge in pre-defined Crystal functions like string, date, numeric, conversion, is null, month to date, last full month, last full week, in repeated group header etc.
• Exported reports from crystal to PDF, txt, word and Microsoft excel formats
• Expert in writing complex formula at the summary level and group level to implement the business logic.
• Connecting with Teradata database and working on SQL queries for extracting data in the required output as per business logic.
• Involved in transmitting crystal reports to mainframe with windows batch file
• Involved in FTP Stored Proc with windows Batch file
• Using Stored Proc and command to crate crystal reports.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Interacted with users in resolving the Help Desk Tickets (Service Now).
• Performed parallel runs to validate the Teradata results to match the SQL results exactly.
• Executed queries against SQL Server 2016/2014 and Teradata databases and tables to support testing, data quality, data integrity.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Working in production support to tune and optimize SSIS the process for better performance.
• Created and Consumed ASP.Net Web Services and implemented WCF Services for service layer, created filters.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX and MDX queries, Roles.
• Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such as to accept input from the page request, invoke the requested actions on the controller
• Worked in production support to optimize SSIS the stored procedures and scheduled many jobs using SQL server 2016/2014.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Experience in the Data migration activities to load the Data into different DB Schemas.
• Worked with offshore team to develop reports/ resolve issues Worked closely with production support team to move the reports to Production once they are finalized by the users.
• Reduced the overall ETL time by SQL Query Performance Tuning. Discussed with user interface.
• Created jobs and job plans in UC4 automatic system and schedule the job to run on specific intervals.
• Designed the ETL process to pull and populate data from OLTP sources to the data mart.
• Wrote CTEs and ranked functions to remove duplicate records in OLTP tables.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Developed SSIS packages using SQL Azure database and used SQL Azure database to connect to Power BI.
• Migration of SSRS reports from SQL 2014 to SQL 2016.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server 2014/2016 Performance.
• Created Autosys jobs (jil files) for scheduling the SSIS packages.

Environment: MS SQL Server 2016/2014 Enterprise Edition, Teradata 14, SQL Assistant, ASP.NET Tabular, MS Azure, Autos, ETL,UC4, Power BI, Microsoft Dynamics, SharePoint 2010, Agile, Visual studio 2015,SSIS, UNIX, SSAS, SSRS,C#.NET,OLTP, T-SQL, OLAP, Crystal reports.

Confidential, Bakersfield, CA

SQL BI Developer

Responsibilities:

• Worked on Teradata SQL Assistant, Proficient in transferring data from Teradata view or Table using SSIS package and deploy to SQL server 2014/2012, 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 2012/2014 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 creatingSQL Logins, RolesandAuthentication modesas a part of security policies for various categories of users.
• Migrated database from SQLserver2012 to SQLserver2014 using utilities i.e. exp/imp and attach/detach for SQL servers 2014 futures.
• 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 2014/2012Reporting Services.
• Generated reports usingSSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Involved in designing the ETL process to pull and populate data from OLTP sources to the data mart.
• High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Involved in thecreation and deploymentof the reports usingSSRSand configuring the SQL Server Reporting Server.
• Applied Agile Methodology for Rapid Software Development in all BI Reporting and Security project.
• Experience in working withSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Deployed SQL Server with HA DR (using Always ON) using Azure Infrastructure as a service platform.
• Developed custom C# code to consume and convert data from various Web service API's given in different formats like JSON, ODATA to a flat file format.
• Expert in creatingComplex Crystal ReportsAd Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
• Design, Develop and Deploy SSIS Packages.
• Created integration component to connectCRMwith SharePoint2010.
• Upgraded packages from SQL Server 2008R2 to SQL Server 2012/2014.
• Data mining and report development using T-SQL Scripts, SQL Server Reporting Service (SSRS) and other data tools.
• SSIS, Data migration, extraction, quality assessment, data cleansing, loading and validation.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server 2012/2008.

Environment: MS SQL Server 2012/2008 R2,Enterprise Edition, Teradata 14, SQL Assistant, Tabular, ETL, SSIS, SSAS, SSRS, Autosys, T-SQL, Visual studio 2013,UNIX, SharePoint, C#.NET,OLTP, Agile,ASP.NET, MS Azure, UC4, OLAP, Crystal reports.

Confidential, Boston, MA

SQL Server BI Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Used BCP and DTS utility for Meta data transfer across servers.
• Involved in installation and configuration of SQL Server 2008 R2 and SQL Server 2012 with latest Service Packs.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system and CSV Files and load into staging tables.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012/2014 as SSIS Packages.
• Created Script in C# in Script task using Excel Interop to read the excel file and also generate customized excel files after data modification.
• Created SSAS Tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008/2012.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• All historical data stored in Teradata database, push the old data from cube to Teradata.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on Various sources systems including Oracle and Teradata.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex packages using proper control and data flow elements.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Good experience in working with high volume of transactions for OLTP & OLAP applications.
• Used replication to create a snapshot of passwp database. Because there were 100GB volumes of data snapshot replication was used.
• Pulling data on daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Experience in handle the offshore team and maintain.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into b Server 2008.

Environment: MS SQL Server 2008 R2/2012, Powershell, Crystal Reports, Teradata, Management Studio, ETL Informatica, UNIX, Visual studio 2010,Crystal Reports, OLTP, Data Modelling, OLAP, MDX, T-SQL, Windows 2003, SSAS, SSIS, SSRS.

Confidential, Atlanta, GA

MS SQL Server Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing.
• Developed and deployedSSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Involved in migration of DTS Packages (2008) to SSIS (2012) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2008/2012.
• Expert in Created/Updated database objects like tables, views, stored procedures,function, packages.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services (SSIS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Extracting required data from database through Teradata.
• Leading offshore team in India and client facing skills.

Environment: MS SQL Server 2008R2/2012, T-SQL, Teradata, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe,Visual studio 2010,SQL Profiler, Visual Studio 2008, XML, Informatica, Oracle 10g, VB.Net.

Confidential

SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using Erwin.
• Installed MS SQL Server 2008 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Converted existing Excel templates into SSRS reports to migrate the reporting model to SQL Server Reporting Services.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Performed daily tasks including backup and restore by using MS SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Environment: MS SQL Server R2, SSIS, SSRS, SSAS, BIDS, Visual Studio 2005/2008, Erwin v7.3, Windows NT/2003, MS.NET 3.5.