SUMMARY

• Around 5+years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2017,2016,2015,2008, 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 2017, 2016, 2015, 2012, 2008R2 and 2012.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2016/200 /2008 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 the SQL Server 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 2016, 2015, 2012, 2008, 2008R2 on Virtual Machines.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to 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 onSQLServer 2008/2012,2016,2017 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
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough noledge 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 using SQL Server 2017/2016/2012/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 Data Modeling using Erwin Design Tool
• Knowledge of Networking Concepts and Object Modeling Technology.
• 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

Relational Database Management Systems (RDBMS): SQL Server 2008/R2, 2014, 2016, 2017, 2018, Oracle

ETL Tools: Import/Export Wizard, Microsoft SQL Server Integration Service (SSIS), and InformaticaReporting Tools: SSRS, MS Excel, Power Business Intelligence, and Tableau.

Analytical Tools: SSAS - multidimensional and tabular model

Programming Languages: C#, ASP.NET, T-SQL, PL/SQL, MDX, and DAX.

Web Technologies: HTML, CSS,JAVASCRIPT

Cloud Technologies: Azure SQL Database

Methodologies: Agile, Scrum, Waterfall

Other Tools: TFS (Team Foundation Server), Visual Studio 2013, GitHub, and JIRA (JQL queries)

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

SQL Developer / MSBI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Thorough noledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Good working noledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Environment: MS SQL Server 2016, Visual Studio 2017/2019, SSIS, Actian Data Connect, CozyRoc, Share point, MS Access, Team Foundation server, Git.

Confidential, San Diego, California

SQL Developer

Responsibilities:

• Create and maintain database for Server Inventory, Performance Inventory.
• Worked in Agile Scrum Methodology with daily stand up meetings, great noledge working with Visual SourceSafe for Visual studio 2010 and tracking the projects using Trello.
• Generated Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Used Data warehouse for developing Data Mart which for feeding downstream reports, development of User Access Tool using which users can create ad-hoc reports and run queries to analyze data in the proposed Cube.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS, FLAT FILES, Excel Files, to SQL SERVER 2008R2 using SSIS.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Great Expertise in Deploying SSIS Package to Production and used different types of Package configurations to export various package properties to make package environment independent.
• Experienced with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Shared data outside using Snowflake to quickly set up to share data without transferring or developing pipelines.
• Used Snowflake to set up an Insights-as-a-Service platform.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Deployed SSRS reports to Report Manager and created linked reports, snapshots and subscriptions for the reports and worked on scheduling of the reports.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: Windowsserver, MSSQLServer 2014, SSIS, SSAS, SSRS, SQLProfiler, Power BI, C#, Performance PointServer, MS Office, SharePoint

Confidential, Irving, TX

SQL Server Developer

Responsibilities:

• Working as SQL Server Analyst / Developer / DBA using SQL Server 2012, 2015, 2016.
• Created jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),
• Actuarial Data Mart (ADM), Reference 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, Reference
• 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 Reference DB dat 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 Quality Center
• Maintain Users / Roles / Permissions.
• Capacity Planning, Disk Requirements
• Creating Range and Hash(by using MOD function) Table Partitioning, Index management
• Create and maintain Change Log to track the state of the in each environment

Environment: SQL Server 2008/2012 Enterprise Edition, SSRS, SSIS, T-SQL, Windows Server 2003, Performance Point Server 2007, C/C++, Oracle 10g, PL/SQL, Visual SourceSafe, visual Studio 2010