SUMMARY

• SQL Developer with around 7 years of experience in developing custom SQL queries and performing data analysis in SQL Server environment.
• Merit of generating, maintaining, enhancing and troubleshooting reports targeting various audiences utilizing SQL Server Reporting Services and Microsoft Excel.
• Proven capabilities in implementing innovative ideas and business solutions in the projects worked on.
• Strong written and verbal communication to interact effectively with both technical and non - technical users at all levels of the organization.

TECHNICAL SKILLS

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

SQL Developer

Responsibilities:

• Gathered system requirements through end-user collaboration through JRD and JAD meetings.
• Designed a dimensional model of the new data mart with Erwin.
• Incorporated database objects with T-SQL such as stored procedures, UDFs, triggers, and Indexes to create complex scripts and batches.
• Created a SQL Server job in SSMS for package executions.
• Improved the performance of SQL codes, procedures, and functions with SQL Profiler and DTA
• Optimized SQL queries with execution plans to enhance performance.
• Prevented potential blocks and deadlocks with complex code.
• Managed the design, development, and maintenance of relational databases.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created the schema and implemented all stored procedures and SSIS packages.
• Worked with SSIS performance tuning using counters, error handling and re-running of failed SSIS packages using checkpoints and scripting.
• Designed complex SSAS cubes with fact measures groups and multiple dimension hierarchies.
• Created the deployment scripts and managed the code in Microsoft Team Foundation Server.

Tools: & Environment: SQL Server 2016, SSIS, SSAS, SSMS, SSDT, T-SQL, Erwin, TFS, SQL Profiler, DTA

Confidential, Columbus, IN

SQL Server Developer

Responsibilities:

• Collaborated with business users and project management to gather system specification requirements for the project via JRD sessions.
• Designed data mart from existing data warehouse utilizing Inmon approach.
• Reviewed database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity and recommend changes as necessary.
• Created, optimized and maintained complex T-SQL as part of stored procedures, views, functions, and queries.
• Tuned SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring.
• Created ETL strategies to populate the data warehouse/data-mart with facts and dimensions.
• Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
• Implemented slowly changing transformations with SSIS to maintain historical data in the data mart.
• Created SSAS cubes with dimensions, perspectives, hierarchies, measure groups, and KPIs to analyze business units.

Tools: & Environment: SQL Server 2012, Erwin, SSMS, SSDT, SSIS, SSAS, T-SQL, MS Excel, TFS, DTA

Confidential, Greenville, SC

SQL/ETL Developer

Responsibilities:

• Analyzed and documented business requirements by participating in JRD sessions.
• Worked with subject matter experts to evaluate current data quality, identify possible metrics to measure quality over time, implement metric collection and review process.
• Designed logical and physical database models for data warehouse applications.
• Designed, coded, tested, and implemented programs and scripts.
• Wrote and debugged SQL including stored procedures, triggers, and views.
• Monitored and resolved deadlocks in SQL Server databases with locks, isolation levels, and SQL Profiler.
• Developed SSIS packages to extract data from sources such as SQL Server OLTP, Excel, and Flat Files.
• Analyzed source OLTP systems and created data mapping documents for the ETL process.
• Resolved errors with event handlers and precedence constraints.
• Designed and deployed SSAS multi-dimension cubes used in analytic research and report generation.

Tools: & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSMS, SSDT, SQL Profiler, Erwin, DTA

Confidential, New York, NY

SQL/SSIS Developer

Key Result Areas:

• Interacted with business users for business requirements enhancement through JAD sessions.
• Worked closely with solutions architect to design dimensional and data models.
• Modified existing dimension data model by adding required dimensions and facts using star schema.
• Supervised the creation and modification of SQL stored procedures.
• Performed business analysis and wrote SQL scripts to analyze data.
• Created SSIS packages to implement SQL maintenance tasks (rebuilding indexes, creating backups, and updating statistics)
• Optimized issue resolution procedures for large-scale production environments in SSIS.
• Improved package performance with the implementation of multiple properties.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Implemented an interface to organize reports, sort data sources, schedule report executions, and track report history.
• Created reports with multiple options with Report Designer and Report Builder in SSRS.

Tools & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSMS, SSDT, SQL Profiler, MS Visual Studio, Erwin, MS Excel, TFS

Confidential, Boston, MA

SQL Database Developer

Key Result Areas:

• Acted as the liaison between business stakeholders, developers, infrastructure teams and project management groups.
• Drove optimal solution design by collaborating with architects and cross-functional teams.
• Evaluated and interpreted requirements to design, develop and implement appropriate solutions.
• Maintained referential integrity, domain integrity and column integrity by utilizing constraints.
• Enhanced and implemented pre-existing logical and physical database.
• Wrote SQL code based on functional specification and technical design.
• Automated the ETL process with SSIS package execution schedules utilizing jobs.
• Implemented package configurations and deployments into the production environment.
• Defined specific read/process permissions for the users in SSAS instance.
• Created and used complex stored procedure in SSRS to generate reports using SSRS.
• Developed reports using SSRS using various features such as cross tab, parameterized reports as per client requirements.

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSIS, SSAS, SSRS, SQL Profiler, DTA, TFS

Confidential, PA

Database Developer

Responsibilities:

• Worked closely with ETL developers, DBAs and other BI developers.
• Normalized tables to remove redundancy and maintain system consistency.
• Maintained Data Model and synchronized it with the changes to the database.
• Created complex SQL statements with joins, sub queries, and correlated sub queries.
• Maintained data integrity; created various constraints and DML triggers on the relational databases.
• Created packages with multiple transformations to cleanse data and apply business rules.
• Migrated SSIS packages from development to production environments with package configurations.
• Implemented report deliveries and backup schedules with subscription configurations and snapshots.

Tools: & Environment: SQL Server 2008, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, SQL Profiler, DAX, TFS, DTA