Ms Sql Server Developer/bi Developer Resume
Melon, NY
PROFESSIONAL SUMMARY:
- MS SQL Server Developer with over 7+ years of experience in various domains like Financial, Healthcare, Insurance and Retail with expertise in MS SQL Server version 2016/2 r2/2005.
- Designed Logical and physical Database of database using Erwin.
- Expert in Data conversion, Data modeling, Normalization and Enterprise Manager.
- Wrote complex Stored Procedures, User Defined Functions, Views and creating other database objects.
- Expert in Migration of data from Oracle, Sybase and DB2 to SQL Server.
- Involved creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, MOLAP cubes, Including Star and Snowflake schema.
- Expert in Creating, maintaining and Configuring DTS and SSIS packages.
- Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server.
- Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Involved creating operational reports in SSRS 2012/2014/2016 i.e. Drill - Down, Drill- through, Dashboard, Sub-Report, and Matrix reports for various domains.
- Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
- Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
- Highly Proficient in Agile, and Waterfall software development life cycle
- Strong knowledge in creating reports by using Power BI Desktop.
- Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
- Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.
TECHNICAL SKILLS:
Programming Languages: T-SQL, PL/SQL,HTML, SELENIUM,XML
Business Intelligence tools: Business Intelligence Development Studio (SSIS/SSRS/SSAS), Erwin, Power BI Desktop, DTS
Database: MS SQL Server 2016/2 r2/2005, MYSQL, Sybase, DB2, MS Access 2007/2003, Teradata
Operating Systems: XP, Windows Server2008R2/2008/2003
SDLC tools: HP Quality center, Team foundation Server(TFS)
EXPERIENCE:
Confidential, Melon, NY
MS SQL Server Developer/BI Developer
Responsibilities:
- Wrote T-SQL query for creating and maintaining existing store procedures.
- Involved in writing views, triggers, cursors, and functions for day to day data retrieval.
- Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
- Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SSRS.
- Developed and deployed Table, Chart, Matrix, Parameterized report and Sub-Reports.
- Populated dimension and Fact tables of Data Warehouse which were later used to create SSAS Cube.
- Design, develop, configured & test the ETL processes according to industries best practices using SSIS.
- Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
- Interaction with clients regarding business requirements, design & implementation phases.
- Used TFS for source control and SSIS package deployment.
- Converted PL/SQL queries to T-SQL queries
Tools: & Technologies: Microsoft SQL Server 2016/2014/2012 , Erwin, SSMS, SSIS, SSRS, T-SQL, TFS, Oracle, Sybase, PLSQL
Confidential, Westbury, NY
T-SQL/SSIS developer
Responsibilities:
- Interaction with clients while business requirements, design & implementation phases.
- Created and maintained existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
- Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
- Design, develop & test the ETL processes according to industries best practices using SSIS.
- Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
- Used Script task for Data Flow and Error Handling in SSIS.
- Worked with T-SQL to create database objects such as Tables, Views, Functions, Triggers and Stored Procedures.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
- Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary.
- Documented for all kinds of reports and SSIS packages.
- Migrated data from Informatica to and from SSIS.
Tools &Technologies: MS SQL Server 2012/2008, SSIS 2012/2008, SSRS, Power BI Desktop, T-SQL, Excel
Confidential. Buffalo, NY
MS SQL Server /SSRS/SSIS Developer
Responsibilities:
- SQL Server 2012, 2008 database development using T-SQL programming, queries, stored procedures, views.
- Improved existing Stored Procedure by creating indexes and changing logic.
- Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.
- Generated matrix, drill down, drill through, sub reports, chart reports, and dashboard reports.
- Generated multi parameterized reports in MS SSRS 2012 allowing users to filter data before executing reports.
- Worked on migrating ad-hoc reports from SSRS 2005 to SSRS 2012 using TFS server.
- Used Erwin data modeling tool to design logical and physical database.
- Worked on Stored Procedures to fix the errors and modifications of existing reports.
- Created SSIS packages to import data from Excel and Flat file to SQL Databases using SSIS component like Slowly Changing Dimension, Merge, Merge Join, Union All and Lookup.
- Deployed and configured SSIS package.
- Developing reports on SSRS on SQL Server (2012).
- Worked on OLAP Data warehouse, Model, Design, and Implementation.
- Sound Experience and understanding of OLAP cube, and multi-dimensional modeling on Multi-terabytes database.
- Involved creating interactive report using Power BI Desktop.
Tools &Technologies: MS SQL Server 2005/2012, MS Windows Server 2003/2008, SSIS, SSRS, Report Builder, TFS, Visual Studio 2012, T-SQL, XML.
Confidential, Northbrook, IL
MS SQL Server/SSIS Developer/DBA
Responsibilities:
- Involved in creating various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables.
- Involved creating complex stored procedure based on business requirements.
- Proficient in tuning SQL queries using execution plan, index and DMV.
- Created SSIS packages with different data sources (SQL Server, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
- Use Packages by testing and cleaning the Standardized Data by using tools in Data Flow.
- Involved in scheduling SSIS packages in multiple servers using SQL Server Agent.
- Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
- Responsible for database tuning using normalization and application tuning.
- Documentation for all kinds of reports and SSIS packages.
- Schedule and maintain Full, Differential, Transactional Log backup and restore the data using restore with recovery and restore with no recovery option.
- Worked on locking(Isolation Level)
- Gathered data from distribution lists and copied to our Data warehouse using SSIS.
- Involved in performance tuning of slow running queries using execution plan and index tuning wizard.
- Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure.
Tools &Technologies: MS SQL Server 2008/2005, T-SQL, SSIS 2008r2/2008/2012, Microsoft visual studio and, Windows server 2008.
Confidential, Cincinnati, OH
MS SQL Server Developer
Responsibilities:
- Wrote T-SQL queries for day to day task.
- Created tab delimited text files according to the general requirements for load ready files.
- Converted the data from its original format into the target (SAP) format
- Executed the load ready files into the specified client.
- Executed the objects in the respected sequence according to the LSMW configured steps.
- Created an excel log of all object information including the number of entries in each object, the start time and end time.
- Created scripts to create new tables, views, queries is Oracle Databases for new enhancement in the application using TOAD.
- Used an extended computer aided test tool (ecatt) for objects with larger data size.
- Tested objects in the development client, multiple times in a day.
- Tested objects into the Quality environment, before loading it to production.
- Loaded all legacy data into ECP (production).
- Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
- Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
- Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
- Extracted data from Oracle database using SSIS.
- Scheduled the published dashboards from Tableau Server on weekly basis.
- Sending the dashboards to users by emails with the help of admin team with subscriptions.
- Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
Tools and technologies: Microsoft SQL Server 2008/2005, SSIS, SAP LSMW, T- SQL, SSRS