SUMMARY:

• Over 7 years of extensive experience in Database design, development and administration of applications with Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in Developing SSAS Tabular Models for generating Power BI reports, and implemented row level security & Roles for the Tabular Model & Multi-Dimensional Cube
• Experience in Developing the Power BI report using different Data Sources like SQL Server Analysis servers (MDX&DAX Query’s), SQL Server Database.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Experience in Visual Studio Team Foundation Server, Visio.
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations.
• Experience in Checking the code (Tables, Store Procedures, Views, Schema) into TFS for the deployment process into the production
• Involved in the complete Data Warehouse Development Life Cycle. Actively supported business users for change requests.
• Experienced in Logical and Physical Database design and development, Normalization, Data mapping, Data profiling and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Expert in using Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008 and Efficient in migration from MS SQL Server 2000 to MS SQL Server 2005.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix and Linux

ETL Tools: BI Development Studio, SSIS, SSRS, SSAS, DTS, DSS, Import/ export wizard, Bulk Insert, Informatica power center 9.1,9.5

Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder 1.0/3.0, POWER BI, Excel, Crystal Reports 12, Tableau 9, IBM Cognos 10

Database Tools: BIDS, SQL Server Management studio, Visual Studio, Configuration Manager, SQL Query Analyzer

Databases: SQL Server 2014/2012/2008, Oracle 11g/10g, My SQL

Networking: LAN, WAN and Configuring network printer

Problem and Incident Mgmt: JIRA, BMC remedy

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL/BI Developer

Responsibilities:

• As a member of BI/Database team, involved in a business unit that oversees, sales, marketing, and service initiatives; customer and partner programs; and product support and consulting services.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers .
• Designed and developed backend SQL Database objects such as Tables, stored procedures, Functions, Triggers, Views, index & roles.
• Created the views in the intake-database for the MS Sales hierarchies to be use in the store Procedures in staging database.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases .
• Created many complex Query’s and used them in Power BI Reports directly to generate reports on the fly.
• Used SSRS to create well-formed reports and web-based reports for health-related applications and transactions.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Using the Data Profiling Task to Profile All the Tables in a Database using ProfileInputXml property.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
• Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems.
• Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results
• Scheduled, enabled/disabled jobs using SQL server job agent for daily, weekly and monthly loads.
• Deployed SSIS packages on development, test and production servers. Involved in Change management process to deploy data objects on servers.

Environment: SQL Server 2012, SQL server 2016, Windows Server 2008, Visual Studio 2012, TFS, SSRS, SSIS, Power BI, Agile, Scrums.

Confidential, Brea, CA

SQL/BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Creating Database Objects like Tables, Indexes, User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• Design, development, and testing of ETL using Microsoft SSIS, processes to in corporate source data into the Enterprise Data Warehouse
• Using Data Script in SSIS to run programs, packages and handle errors in files
• Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS 2012.
• Helped in developing Tableau reports as part of the compliance project requirement.
• Created data blending in case of merging two different datasets using Tableau.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Designed and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Actively involved in change management process to deploy database objects to QA/UAT/Production servers.
• Troubleshooting, on call production support once every two weeks.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created and maintained daily SQL jobs to monitor the health of SSIS packages.
• Develop logical and physical dataflow models for ETL applications. Codes, tests, implements, and automates complex processes.
• Used Entity framework combined with LINQ queries to do database operations.
• Extract and analyze data using Power Query , PivotTables, MS Excel, POWER BI and SSAS
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments.
• Designed and developed web n-tier applications for different phases using .Net Framework (C#, ASP), ADO code with SQL SERVER 2000 as the database.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel , and POWER Pivot, and POWER Point .
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Strong technical skills designing, developing, debugging, documenting, and implementing applications.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.

Environment: SQL Server 2012, Windows Server 2008, Query Analyzer, SSIS, SSAS, SSRS, Tableau 9.3, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, MS Visual Studio, Team Foundation Server (TFS).

Confidential

SQL Developer

Responsibilities:

• Involved in database design to create new databases that maintained referential integrity.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries.
• Enhancing performance using optimization techniques-normalization(2nf), indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers
• Participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise Data warehouse to do better analysis.
• Used basic Script Task for renaming the file names, storing Row Count Values into User Variables.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Documentation of all the processes involved in maintaining the database for future reference.
• Performed unit tests, was involved in deploying database objects to test/production environment.

Environment: SQL Server 2008, Visual Studio 2008, TFS, SSRS, SSIS, Waterfall methodology.

Confidential

SQL Developer

Responsibilities: ·

• Involved in ER diagrams and mapping the data into database objects, design of the Database and the Tables.
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.
• Strong reporting experience using Excel, Access.
• Worked on Client/Server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to Administer SQL Server
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Created dashboards on data blending from different database and tables to meet the business requirements
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Experience in creating Indexes for faster performance and views for controlling user access to data.
• Performed unit testing, provided bug fixes and deployment support.

Environment: SQL Server 2005, DDL, DML, Store Procedures, Views, UDFs, VSS, Waterfall methodology.