SQL Developer

Kirti Patel

SQL Developer

Mobile: 917-***-**** Email: *********@*****.*** Location: New Brunswick, NJ

Summary:

More than 4 years of IT industry as SQL Developer with expertise in Data Analysis, SSIS and SSAS

Experience in Software Development Life Cycle SDLC which includes requirement gathering, designing, implementing and testing.

Was involved in all aspects of the software development life cycle and demonstrate abilities to learn both the business processes as well as new and existing technologies.

Skilled in Designing, Development and Deployment of Reports in Business Intelligence Development Studio (BIDS).

Developing back-end PL/SQL packages, building UNIX shell scripts for data migration batch processing.

Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.

Knowledge in creation of Tabular model in SSAS for creating Power pivots, Power View reports and Dashboards.

Proficient knowledge in Designed and developed Informatica Mapping for data load and data cleansing.

Good knowledge of database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.

Good knowledge creating Visualization and dashboards in Tableau desktop using Oracle, SQL Server and Teradata as data source.

Articulate communicator with strong analytical and interpersonal skills, skilled at collaborating with project teams, interfacing with clients.

Proficient in logical and physical data modelling of the database in ERWIN and MS Visio.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.

Creating mappings/workflows to extract data from Oracle, MySQL, SQL Server and Flat File sources and load into various Business Entities.

Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies

Skills:

SQL, PL/SQL, T-SQL, MySQL, SQL, Waterfall, SDLC, Agile, SSIS, SSAS, Informatica, MS Visio, MS Office, SSRS, SSIS, Tableau, ETL, DevOps, Windows, Linux, Oracle, MS-SQL Server, DTS, Power BI

Education:

Masters in Computer Application Dec 2010

Indira Gandhi National Open University, New Delhi

Experience:

Merck Group, Somerville, NJ Aug 2018 - Current

SQL Developer

Performance tuning and SQL query tuning. Write and tune the PL/SQL code effectively to maximize performance.

Conducted data import and export operations using the DTS wizard.

Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.

Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.

Creating logical and physical database design as per application requirement with E/R models and normalization using Erwin Data Modeler.

Well used Informatica power center for extraction, transformation and loading process.

Worked in Agile environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional

split, back up and involved in scheduling of SSIS packages.

Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.

Involved in creating and deploying cubes using SSAS.

Coordinated with the back end design team to provide them with the necessary stored procedures and packages.

Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.

Create the database system and successfully improve operational efficiency by implementing data analysis tool and theory into business.

Ally Financial, Detroit, MI May 2016 - Jun 2018

SQL Developer

Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.

Developed ETL packages in SSIS and pulling data from different data warehouse databases like Oracle.

Worked with DBA to perform data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.

Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.

Developed PL/SQL Procedures, triggers, Functions and Packages and used SQL loader to load data into the database.

Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.

Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.

Implemented and followed Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.

Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T-SQL.

Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.

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

Created SSRS Reports from the SQL server tables, for different client’s needs for data analysis.

Contact this candidate