SUMMARY

• 8+ years of experience as a Database Developer/ BI Developer in Data Analysis. Design, Implementation, OLTP, OLAP, ETL, Data warehousing, RDBMS, Data Modeling and Reporting using SQL Server 2019/2017/2014/2012/2008 R2/2008, SSIS, SSRS and Power BI.
• Extensive database programming experience in developing complex T - SQL stored procedures, User defined functions, triggers, views, indexes, queries for implementing business logic in backend process, for data extraction and client interfaces.
• Very strong in Power BI - visuals design, data modeling, security, DAX functions and transformation techniques.
• Experienced in data mining, data analysis, modeling of large-scale complex data sets.
• Strong knowledge of data warehousing methodologies and including star schemas and snowflake schemas.
• Expert in designing and scheduling complex SSIS packages for transferring data from multiple data sources and integrates data based on business requirement and load it in data warehouse.
• Strong analytical thinking for translating and comprehending data from a variety of data sources
• Experience with all phases of Software Development Life Cycle (SDLC) using Waterfall and Agile methodologies.
• Worked as team member, Team Lead and as Consultant on medium and large-scale projects.
• Strong root cause investigation and problem-solving skills.

TECHNICAL SKILLS

Databases: SQL Enterprises Manager, SQL Profiler, Query Analyzer, SQL Server SetupSecurity Manager, Service Manager

Languages: T-SQL, DAX, HTML, XML

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)Import Export Data, Bulk Insert

Reporting Tools: Power BI,SSRS

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Operating Systems: Windows 98/NT/2000/XP, 2003/2008/2016 Server, Windows 7/8, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Lead Database Developer

Responsibilities:

• Involved in all aspects of the development life cycle including requirements gathering, architecture, development, testing, training implementation and support.
• Documented system changes upon implementation.
• Designed and performed data analyses to resolve complex data issues.
• Used data analysis and technical skills to help architect comprehensive models that integrate with other external systems.
• Worked on troubleshooting and streamlined data validation efforts in data base migration.
• Created complex SQL queries and database objects (Stored procedures, views, functions etc.) to pull and manage data.
• Worked closely with internal teams and clients, understanding critical touch points and implications.
• Developed and implemented scripts, queries to access, analyze and integrate data between several sources to ensure availability of data in production environments.
• Provided support to other developers on projects and lead continued development.
• Tuning and monitoring integration scripts and packages.
• Analyzed and solved data related performance issues encountered by users.
• Performed analysis of data sources and process to ensure data integrity, completeness and accuracy.
• Monitored, diagnose and repair all data loading and processing packages to ensure data integrity.
• Build and delivered dashboard and analytics solutions using Microsoft’s Power BI and related Azure data services.
• Wrote calculations using Data Analysis Expressions (DAX).
• Designed and developed SQL stored procedures/ ETL jobs with optimized processing time.
• Performed code reviews, identify potential issues to reduce technical debt and provided coding best practice recommendations.
• Lead the technical planning and requirements gathering phases including estimate, develop, test, manage projects, architect and deliver.
• Independently analyzed, solved and corrected database related issues in real time while developing efficient solutions.
• Collaborated with developers on table design and tuning complex queries.
• Responsible for end user training on use of Power BI platform.
• Designed Power BI Data visualization utilizing cross tabs, scatter plots, pie, bar and density charts.
• Developed and maintain data interfaces with various 3rd party applications.

Environment: MS SQL Server 2018, MS SQL Server 2019, Transact - SQL, Power BI, Enterprise Manager, Query Analyzer, SSIS

Confidential

Sr SQL Developer

Responsibilities:

• Requirements gathering from end user and detailed requirements analysis.
• Debugged and resolved deployment errors.
• Using joins, correlated and non-correlated sub-queries for complex business requirements involving multiple tables from different databases and implemented triggers, stored procedures and enforced business rules via checks and constraints.
• Optimized queries by deleting unnecessary columns, eliminated inconsistent data, normalization of tables, developed joins and created clustered/non-clustered indexes wherever necessary.
• Extensively used different types of transformations such as lookup, slowly changing dimension (SCD), multi-cast, merge, OLE DB command, and derived column to migrate SSIS packages from one database to another database.
• Created several SSIS Packages to migrate data from heterogeneous data sources such as flat files, oracle, access, excel etc.., into SQL server staging database and created data mappings to load the data from source to destination.
• Created incremental load packages to load the updated and new data into the enterprise data warehouse.
• Extensively used data conversions, lookups, derived column, conditional split to implement incremental data loading, for data cleaning, to remove unnecessary columns, to eliminate redundant and inconsistent data.
• Developed complex stored procedure to run multiple DML statements from flat files to run incremental updates on tables on staging database.
• Created indexes on selective columns to speed up the queries in SQL server.
• Interpreted and analyzed data collected from various sources using exploratory and statistical techniques, validating findings using an experimental and iterative approach.
• Performed data extraction and migration activities to populate test (non-production) and customer databases.
• Developed advanced Power Bi reports, reviewing and testing with the business prior to implementation.
• Developed Power BI reports and dashboards from multiple data sources.

Environment: MS SQL Server 2014, MS SQL Server 2016, Power BI, Transact - SQL, Enterprise Manager, Query Analyzer, SSIS, SQL Server 2008 R2.

Confidential

Software Developer

Responsibilities:

• Extensively participated in all phases of projects life cycle.
• Involved in resolving performance issues of complex stored procedures to improve the response time.
• Developed and integrated user defined functions and stored procedures for reporting services.
• Enhanced the performance by using optimization techniques such as normalization, indexing, transaction isolation levels, monitoring logs to ensure the consistency of batch processes and scripts.
• Optimized SQL queries to develop database objects such as triggers, joins, constraints, cursors, indexes, views, and created stored procedures to automate sequential updates in fewer transactions.
• Helped front end developers in writing SQL queries, approving database changes and designing data models.
• Performed debugging of SSIS packages using error handling methods like break points and check points.
• Responsible for validation and deployment of SSIS packages from development to QA and production environment.
• Performed daily and weekly data loads by scheduling corresponding ETL jobs in SQL server agent.
• Identified and provided necessary steps to enhance the user response time by checking fragmentation and re-indexing tables for efficient application access and methods.

Confidential

Masters Assistant

Responsibilities:

• Installation, configuration of MS SQL Server 2005 instances and databases for development and testing purposes using SQL Server setup program.
• Created tables, indexes, views, constraints and stored procedures for modular integrity and application as per client’s requirement.
• Designed and implemented database triggers and stored procedures to check the referential integrity of database.
• Used data transformation services (DTS) an ETL tool of SQL server to migrate data from various data sources.
• Designed complex SQL queries to fetch data from multiple tables in remote databases using joins and database links.
• Troubleshooting problems related with databases, application tools, development tools and minimizing production down issues.

Environment: MS SQL Server 2005, MS SQL Server 2008 R2, Transact - SQL, Enterprise Manager.