SUMMARY

• Have more than 5 years of experience in Database, Data Warehouse Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012 in Production, Testing and Development in Financial and Banking domains.
• Proficient in 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.
• Competent 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.
• Proficient in developing Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors, and Indexes using T-SQL, and have ability to create and manage various database objects like tables, views.
• Implemented third normalization form in OLTP Database modelling and Star, Snowflake Schemas in OLAP Dimensional modelling.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experienced in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Extensively worked on SQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with proficiency onSQL Server Analysis Services(SSAS).
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Merge,andunion all.
• Worked Extensively on ETL process using SSIS package. Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Have worked in maintenance and Administration ofSSISby creating Jobs, Alerts, SQL Mail Agent, and scheduleDTS/SSIS Packages.
• Designed and developed Full load and Incremental load using merge statements and SSIS Look Up and slowly changing dimension transforms.
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Competently worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Dimension, Attributes, Measure Groups, Hierarchies.
• Well versed with Ralph Kimball and Bill Inmon strategies of implementing Data Marts and Data Warehouse.
• Implemented ETL Workflows to handle late arriving dimensions and late arriving facts using Surrogate Key Pipelining concept.
• Implemented Slowly Changing Dimensions up to Type 3 using SSIS Slowly Changing Dimension Wizard and Hashing mechanism.
• Developing reports onSSRSon SQL Server (2012, 2014 and 2016). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Experience in report development using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Well versed in Performance Point Server. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Sound knowledge of installing, configuring, managing, upgrading, and migrating, monitoring, and troubleshooting SQL Server 2012, 2014 and 2016.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

Operating systems: Windows XP/Vista/Windows7/8 Windows 10Windows Server 2012,2012 R2,2016 and Linux

Databases: MSSQLServer (2012, 2014,2016), MS Access, Oracle, MYSQL

Database Tools: SQLServer Management Studio,SQLServer Business Intelligence Development Studio (BIDS), MySQL Workbench

ETLTools: SQLServer Integration Services, Data Import Export Wizard

Analytical Toolsp: SQL Server Analysis Services - SSAS

Reporting Tools: SSRS, R-studio, Micro Strategy, Tableau, Power BI

Programming Languages: T-SQL, PL-SQL, Python, Linux, HTML, XML, C#, VB.Net, Asp.Net

Application Packages: Microsoft Office Suite, visual studio

PROFESSIONAL EXPERIENCE

SQL SSRS/SSIS/SSAS Developer

Confidential, Round Rock, TX

Responsibilities:

• Created SQL server Reports usingSSRS 2016.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report
• Development.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data
• Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Developed complexSSISpackagesusing proper control and data flow elements with error handling.
• Created different Power BI reports utilizing the desktop and the online service and schedule refresh.
• Utilized various ETL tools like SSIS/Import Export Wizard for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from one server to another server as well as Created interface stored procedures used inSSISto load/transform data to the database.
• Designed Data flows, Workflows, and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and developed the OLAP systems for data mart applications using SQL Server Analysis Services (SSAS)
• Designed and built OLAP cubes to meet reporting needs.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Designed Cubes with Star Schema using SQL Server Analysis Services. Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services.
• Implemented process for changing and maintaining the Warehouse, Optimizing Dimensions,Hierarchies and adding the Aggregations to the Cube.
• Created reports in SSRS with different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created complexSSISpackages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2016 aslegacy SSISPackages Migration assignment.
• Performed Documentation for all kinds of reports and SSIS packages.

Environment: MSSQL Server 2016, T-SQL, SSRS, SSAS, SSIS, Visual Studio 2017, ODBC, Erwin, ASP.Net 4.5, Ado.Net 4.5, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows Server 2016, IIS.

SQL/ETL Developer

Confidential, Aberdeen, Washington

Responsibilities:

• Performed various activities with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.
• Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.
• Developed logical and physical data models for schemas using MS Visio.
• Defined check constraints, rules, indexes, and views based on business requirement.
• Developed the Stored Procedures, Views, User Define Functions and Complex Queries.
• Created Temporary Table and Common Table Expression (CTE) for query Optimization.
• Designed and optimized indexes, views, stored procedures, and functions using T-SQL.
• Programmed Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Developed SSIS packages to load slowly changing dimension tables (for Type 2 and Type3 loads).
• Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to staging database in SQL Server using Business Intelligence Development Studio.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data into the Data Warehouse.
• Involved in development of Incremental Load Process using SSIS Packages and various Transformation and data cleansing activities using various Control Flow and Data Flow tasks in SSIS packages during data migration.
• Involved inDimensional Data ModelingandCube partitioninginSSAS.
• Worked with testing team to understand test cases and created processes (using stored procedures and SSIS packages) to automate ETL and SSRS testing.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Develop code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Using a query editor in Power BI performed certain operations like fetching data from different file.
• Develop Unit test cases and perform Unit testing of assigned components
• Knowledge of financial instruments such as Mortgage, bonds, MBS etc.
• Using Rational Clear Case, Clear quest for the source control.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Worked on to generate on-demand/daily reports using COMPASS POINT software used by the Traders in the Mortgage Industry.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Environment: MS SQL Server 2014, SSIS, Oracle 10g, Visual Studio 2013, .NET Framework 3.5, Informatica, Power BI, Tableau 9, Windows Server 2012 R2, Autosys, HP Quality Center, IBM Rational Clear Case, Compass Point tool.

Jr. SQL Developer

Confidential

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Translated requirements, designs and functional specs into use case document, test plans and test cases documents.
• Actively participated in daily calls with Client and Client Team. Worked as SQL Server Analyst / Developer / DBA using SQL Server 2012 for Atlas Data warehousing Project.
• Logicalized and created the table schema andstored proceduresthat used in Data Centre.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services(SSIS).
• Developed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Built SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• UsedSSISto unite data from existing system and performed transformations on MS SQL 2012.
• Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services (SSIS)
• Converted Data Transformation Services(DTS)application to SQL Server Integrated Services(SSIS)as assigned.
• Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Developed Star schema modelling in Data Warehouse and extended same in SSAS multidimensional cubes (Dimension, Hierarchies and Measure Groups).
• Programmed parallel period, filter, ancestors, and cross join MDX queries.
• Developed Aggregations, partitions, and calculated members for cube as per business requirements.
• Assisted in production OLAP cubes, wrote queries to build reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting usingReport Builder.
• DevelopedParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chart,andmatrix report).
• Involved in designing, developing, debugging, and testing of reports in SQL Server Reporting Services(SSRS).
• BuiltParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chart,andmatrix report).
• Developed several drill down and drill through reports usingSSRS.
• Used Performance Point Server to create reports, scorecards, and dashboards.
• Utilized Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS),SQL Server Analysis Services(SSAS),MS Visual Studio 2013, TFS (SharePoint), VB.net, VB Script and Windows 2012 Server.