SUMMARY

• SQL BI Developer with 10+ years of IT experience in Database Design, Development, Testing, Support and Business Intelligence of Microsoft SQL Server 2005/2008/2012/2014 in Development, Test, Performance Tuning, Troubleshooting and Production Environment on Various Business Domains. Good Experience in Information Technology field as a SQL Server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact - SQL coding.
• 10+ years of Experience in SQL Development, Data Warehousing, Reporting and Business Intelligence solutions using SQL Server 2014/2012/2008 R 2/2008/2005.
• Experience in Microsoft SQL Server BI Studio, SSAS, SSIS and SSRS, Power View and Power Pivot.
• Experience with multiple RDBMS including MS SQL Server 2000/2005/2008/2014 , oracle 10g/9i/8i, DB2, and Microsoft Access.
• Experienced in Enterprise Data Modeling (Dimensional & Relational) with a solid understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, and fact and dimension tables modeling of data.
• Involved in T-SQL programming and creating complex stored procedures, triggers, views and user defined functions on SQL 2012/2008 and 2008 R2 Servers to meet the requirement of the applications.
• Strong Knowledge on writing shell scripts.
• Expertise in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk Insert and BCP.
• Implemented various SSIS Transformations such as Slowly Changing Dimension, Aggregate, Data Conversion, Derived Column, Lookup, etc.
• Developed SSIS packages with various tasks like - FTP, file system, for-each-loop, execute package, data flow task, execute SQL task, custom script task.
• Optimized the performance of SSIS packages using features like Auditing, Checkpoints, Transactions, Loggings and Event-Handlers.
• Involved in planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and fact Dimensions.
• Designed Reports using SQL Server Reporting Services (SSRS). Included graphical structures using charts, tables, matrices, parameters and conditional formatting.
• Created Parameterized Reports, Sub Reports, Drill Through, Drill Down Reports in SSRS and Ad-hoc reports using Report Builder.
• Expert in theDataAnalysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading in SQL Server, ORACLE and other relational and non-relational databases.
• Have Experience with Teradata and writing BTEQs.
• Experience in Finance and Insurance domains.
• Capable of handling all phases of a project cycle, from planning and design through deployment and support.
• Strong individual contributor and a good team player with proven ability and excellent verbal and written communication skills to interact with clients and peers

TECHNICAL SKILLS

SQL Server Tools: MS SQL Server, Enterprise Manager, Profiler, SQL Query Analyser, MSSQL Server Reporting Services (SSRS), MSSQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), Teradata.

RDBMS: MS SQL Server 2005/2008/2012/2014/2019 , MS Access

Programming Languages: SQL, T-SQL, PL-SQL, Python, LINUX, HTML, Manual testing, QA.

Operating systems: MS-DOS, Windows 95/98/2000/2003 , UNIX.

Graphics Editing Program: Adobe Photoshop

PROFESSIONAL EXPERIENCE

Confidential, Pembroke, MA

Sr SQL Developer

Responsibilities:

• Developed and maintained complex SQL queries, views, stored procedures, and functions to support business needs and optimize database performance.
• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Designed and developed web based ecommerce application. *Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Worked closely with cross-functional teams, including software developers, business analysts, and project managers, to gather requirements and design database solutions that meet customer needs.
• Designed and implemented database schema changes, data migrations, and data validation procedures to ensure data accuracy and consistency across different systems.
• Collaborated with database administrators to optimize database configurations, monitor database performance, and troubleshoot database issues.
• Contributed to the development and improvement of software development processes and methodologies within the organization

Confidential

SQL ETL Developer

Responsibilities:

• Created ETL Design Specifications.
• Experience with the full software Development Life Cycle (SDLC).
• Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
• Experienced in designing and development of Tableau visualizations and created business requirement documents and plans for creating dashboards.
• Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.
• Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.
• Perform Data Cleansing and Data Auditing to ensure Data Quality.
• Involved in Performance and Tuning the ETL processes.
• Identified Slowly Changing Dimensions and determined the hierarchies in the dimensions
• Experience writing complex PL/SQL Queries, writing Stored Procedures, Functions, Packages and Triggers using SQL Server Management Studio.
• Experience in developing report specifications based on business requirements.
• Experience in developing different types of reports using Crystal.
• Worked closely with the business to ensure Data Warehouses can support all business requirements across the organization.
• Defined and developed Physical and Logical data models to support business needs.
• Developed database batch process to move reference data of the Traders to the Trading System.
• Created and scheduled SQL Agent jobs and maintenance plans
• Created Alerts for successful or unsuccessful completion of Scheduled jobs. Developed Ad-hoc queries for end users.

Confidential, New York, NY

SQL/ETL Developer

Responsibilities:

• Developed and implemented database backup and recovery procedures to ensure data availability and disaster recovery readiness.
• Created and maintained database documentation, including data dictionaries, ER diagrams, and technical specifications.
• Participated in code reviews and provided feedback to ensure adherence to coding standards, best practices, and security policies.
• Mentored junior developers and provided technical guidance and support to other team members.
• Stayed up-to-date with emerging trends and technologies in database development and applied new tools and techniques to improve development processes and product quality.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent. • Created reports to retrieve data using Stored Procedures that accept parameters.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• 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.

Confidential

Software Developer

Responsibilities:

• Responsible for developing and unit testing of ETL (Extract, Transform and Load) processes.
• Responsible for support and maintenance of data warehousing and business analytics solution.
• Involved in source data profiling & source system analysis.
• Involved in extracting source data from Siebel CRM, DB2, Flat Files, VSAM files on different systems
• Day to Day included manipulation of XML, CSV and XSL files.
• Developed complex SSIS mappings to facilitate daily, monthly and yearly loading of data
• Perform initial Data load and Data validation in production environment.
• Involved in development and debugging of complex batch Transact SQL Procedures and functions.
• Created and Modified Reports using MS SQL Server Reporting Services (SSRS).
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Created, maintained and manage documentation for data warehouse design and ETL development.

Environment: T-SQL, SQL Server 2005/2008/2008 R2/2012/2014, SSRS, SSIS, SSAS, DTS, OLAP Services, MDX, Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Teradata, Siebel CRM 8.1/7.7