Resume

Sign in

Data Developer

Location:
Princeton, NJ
Salary:
65/hr or W2
Posted:
October 11, 2019

Contact this candidate

Resume:

Hima Bindu / SQL Developer

: +1-908-***-****

: adakhk@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7 years of IT experience as a SQL/SQL BI Developer, experience in Data Modeling, Database Design, Programming, Development, Implementation of Client-Server Applications & Database systems and can perform well both independently and as a team player

Experience in Information Technology on logical and physical Database design with Different Data Modelers using ERD, data normalization, scripts and implementation on MS SQL SERVER 2008 & 2012, 2014, 2016 And 2017

Excellent experience of managing BI environment, which includes, Data Model, Data sources, ETL tools, target data warehouse, Data marts, Data analysis and Reporting tools

Created and designed various database objects and elements like tables, joins, views, stored procedures, triggers, indexes and partitions. Extensive experience in creating Clustered, Non-Clustered, Covered indexes and indexed views

Extensive experience in Working with SQL Server Agent Jobs, Monitoring and Troubleshooting SQL Server Performance, Performance Tuning, Maintaining Database Snapshots

Expertise in developing, monitoring and transforming data using SQL Server Integration Service (SSIS), SQL Server Reporting Services(SSRS) and SQL Server Analysis Service (SSAS).

Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes

Knowledge of T-SQL to perform batch processing and implement business logics into backend. Hands on experience in Querying Data, Formatting Result Sets, Modifying Data and Worked on Transactions.

writing optimal T-SQL queries, stored procedures, view creation, reading query plans, tuning, and troubleshooting issues.

In-depth knowledge about Extracting and Loading Data, Using Data Flow Transformations, Managing Control Flow, Scripting Tasks, Debugging Packages and Managing Package Execution.

Strong in RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers using SQL Server, T-SQL.

Experience in Power BI Reports from Power BI Desktop to Power BI Service.

Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.

Experience with development in other aspects of the Microsoft BI Stack – SSAS/SSRS

Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

TECHNICAL SKILLS:

Database Technologies/Tools:

SQL Server Management Studio, T-SQL, Data Transformation Services (DTS), Business Intelligence Studio, Query Analyzer, Performance Monitor, OLTP, OLAP, Sequel Sever Integration Services(SSIS), Sequel Server Reporting Services (SSRS)

RDBMS/DBMS:

MS-SQL Server 2008/2008 R2, MS-SQL Server 2012, 2014, 2016, 2017 MS Access and Excel.

Microsoft Tool:

MS POWER BI

Operating Systems:

Windows 2008/2000/XP/Vista/7, MS-DOS, Unix

Software Development Methodologies:

Agile Methodology, Software Development Life Cycle (SDLC)

Applications:

OLAP, OLTP, HTML, XML, Visual Studio

Microsoft Tools:

MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

Testing Tools:

Quality Center

PROFFESSIONAL EXPERIENCE:

NY Life, NJ Jan’2018 to Till Date

Role: Sr. SQL/BI Developer

Responsibilities:

Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.

Experience in Information Technology on logical and physical Database design with Different Data Modelers using ERD, data normalization, scripts and implementation on MS SQL SERVER 2008 & 2012, 2014, 2016 And 2017

Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.

Experienced in slowly changing dimension in SSIS packages. Performed incremental data load packages in SSIS.

Developed, monitored and deployed SSIS packages. Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP).

Responsible for fine tuning of the database, troubleshooting, memory management.

Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)

Created reports based on database usage and perform capacity planning.

Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

Environment: SQL Server 2008 & 2012, 2014, 2016 2017 R2/2012, SSIS, SSRS, MS 2003, XML,

Cardinal Health, OH Dec’2015 to Oct’2017

Role: Sr. SQL / BI Developer

Responsibilities:

Gathered requirements from the business users, created technical specification documents.

Loaded the data from different sources to SQL Server database using SQL Server Integration services (SSIS) 2012.

Used the concepts of priority constraints, look up tables to validate data while dealing with SSIS.

Created data marts respect to insurance domain and populated data as pr reports needs.

Scheduled the SSIS packages to process the cubes in order to update the data from OLTP to OLAP.

Refined the existing cubes by adding the new attributes to the dimensions and defining the relationship between the new attributes and the measure groups.

Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008

Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.

Wrote many complex MDX queries to gather the data from the OLAP cubes while generating the reports in SSRS.

Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.

Scheduled tasks to run every day to update changes in the base tables.

Ran and tested required queries and reports before publishing.

Published the reports and scheduled the reports in different formats (Email, Public Folder).

Designed and implemented stored Procedures and triggers for automating tasks.

Managed all indexing, debugging, optimization and performance tuning using T-SQL.

Created/Modified SQL Joins, Sub–queries and T-SQL code to implement Business rules.

Performed database administration backup recovery, maintenance plans, database creation, tables & indexes.

Involved in documenting the project steps and presenting to the team members

Worked and resolved high critical incidents and resolved issues based on severity.

Environment: MS SQL Server 2008/2012, Windows Win7/Win10, SSIS 2008/R2/2012, SSRS 2008/2012 SSAS 2008/2012

Medtronic, MN Jun’2014 to Sep’2015

Role: BI Developer

Responsibilities:

Interacted with Business users and Functional team to gather and document requirements for developing a Data model.

Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies in Tableau Desktop.

Used Data Blending, and aggregated data to compare and analyze data in different perspectives

Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.

Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.

Involved in monitoring user, user groups, and scheduled instances for reports in Tableau.

Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.

Provided 24/7 production support for Tableau users.

Combined visualizations into Interactive Dashboards and publish them to the web.

Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Assisted with QA team in preparing test plans, test cases and test scenarios for the testing the application.

Used Marketing analytics based on key Business metrics to evaluate the performance.

Environments: Tableau server, Tableau Desktop 9/8, MS SQL Server 2012, MS Excel, TSQL, Windows, Agile.

FedEx, TN Jan’2013 to May’2014

Role: Sr. SQL Developer

Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Excel, DB2, SQL 2000, and SQL 2005).

Created Configurations to make package portable and created Event handlers for handling package error.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Created and modified various Stored Procedures used in the application using T-SQL.

Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.

Developed yearly and quarterly company expense reports.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Tuning SQL query for better performance using SQL Profiler.

Environment: Windows server 2008, MS SQL Server 2012/2008R2, SQL Server Management Studio, SQL Profiler, SQL Server 2012, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services(SSAS).

Office Depot, FL June 2012 to Dec 2013

Role: SQL Developer

Responsibilities:

Developed SSIS Packages, Procedures and Functions for Various Extract Process run through SQL Jobs.

Coded SSIS Packages and Procedures using Bulk Binding, for all Statements, DynamicSQL and Cursor Variables.

Tuned SSIS Packages and SQL Procedure to manipulate large no of data using collections like nested queries and C# script.

Created Schema Objects like Tables, Views, Triggers, Sequences, Constraints, and Indexes.

Developed and Deployed Data REPORTS in MS Excel.

Improved Performance of Discoverer Reports using Materialized views.

Developed UNIX Shell Scripts for Autonomous Jobs.

Experience in developing logical and physical database design, data modeling using Erwin.

Provided Productions support and ongoing user support for the application.

Designed Development Documentation and Support Documentations.

Environment: MS SQL Server 2005, SSIS, SSRS, TOAD, UNIX, MS Excel, Erwin



Contact this candidate