Resume

Sign in

SQL Developer

Location:
Johns Creek, Georgia, United States
Posted:
January 29, 2018

Contact this candidate

Resume:

SOWMYA TEKKAM SRINIVASAN ac38p5@r.postjobfree.com +1-470-***-****

SUMMARY

Energetic and motivated ETL Developer with passion for innovation, learning and technology

* *****’ experience of Strong Knowledge of Data ware housing including Extract, Transform and Load Processes using SQL Server DTS and SSIS

Technical Expertise of managing all phases of Software Development Life Cycle(SDLC)

Developed and documented Conceptual/Logical/Physical design. Constructed entity relationship diagram (ERD) for data modeling.

Talented communicator, adept at working in both individual and team settings, and creating strong relationships with coworkers

Talented analytical thinker, proficient at identifying and resolving technical problems.

TECHNICAL SKILLS

RDBMS: SQLServerManagementStudio(SSMS), SQLServerBusinessIntelligenceDevelopmentStudio

OperatingSystems:Windowsserver2003,Windows2000advancedserver

Languages:T-SQL,C#,PL-SQL

DatabaseTools:MS SQL Server,MSAccess

BITools: SQL ServerIntegrationServices(SSIS), SQL ServerAnalysisServices (SSAS),SQLServerReportingServices(SSRS),Data

TransformationServices(DTS

ReportingTool: SQL Server Reporting Services (SSRS),Excel

PROFESSIONAL EXPERIENCE

Sr.SQL/SSIS developer

Bank of America Charlotte, NC September 2015 – December 2017

Bank of America is one of the world's leading financial institutions, serving individual consumers, small and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.

Experience in design, development and implementation of databases

Responsible for creating, modifying and maintaining tables for associate’s call performance

Responsible for creating, monitoring and troubleshooting multiple intra-day and nightly scheduled agent jobs

Creating necessary Indexes for query optimization

Created Stored Procedures for commonly used complex queries across multiple commodity

Optimized data integrity by utilizing constraints and functions

Utilized Triggers to facilitate consistent data entry into the database and to keep track of changes to the attributes of the table

Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database

Designed new database tables to meet business information needs

Created Views to facilitate easy user interface, row/column level security

Creating and reviewing documents that mapped data to be moved from source table to target table

Involved in SQL server performance monitoring and tuning

Proficient in design of logical and physical data modeling using VISIO data modeling tool

Building, deploying and processing cubes in SSAS by creating Hierarchies, KPI’s, partitions and build attribute relationships

Create new SSIS packages to perform ETL process and maintain/troubleshoot existing SSIS packages

Experience in designing, developing, configuring and deploying SSIS packages for various heterogeneous sources like Oracle, Excel, Flat Files, .CSV using BIDS

Analyze data formats and design the necessary transformations to map the source data to the destination

Adding and configuring various transformations like lookup, derived column, data conversion, aggregate, conditional split, merge, merge join, row count and union

Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule SSIS Packages.

Support product development and quality assurance teams

Knowledge in Event/Error handling by assigning events at package and task level to handle errors

Debugging control flow tasks, data flow tasks and SSIS packages by creating check points and break points

Add logging to SSIS packages to keep track of the package execution results

Proficiency in creating simple tabular and matrix reports using SSRS

Created parameterized (including cascading parameters), Drill-down, Drill-through, linked, lists, templates and sub reports

Involved in design/developing, maintaining and deploying reports in MS SQL Server environment using SSRS

Efficient in building recursive queries using CTEs (Common Table Expressions)

Jr. SQL Developer

Allsec Technologies India February 2009 – January 2013

Allsec Technologies provides web development, web design, search engine optimization, strategic teleservices, customer care, and quality management services. Across multiple industry verticals it also provides data verification, processing orders received through telephone calls, telemarketing, monitoring quality of calls, and customer services.

Knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined functions and Indexes

Wrote User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts

Creating necessary Indexes for improving the performance of the database

Created Stored Procedures for commonly used complex queries

Optimized data integrity by utilizing constraints and functions

Rebuilding the indexes at regular intervals for better performance

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Utilized Triggers to facilitate consistent data entry into the database and to keep track of changes to the attributes of the table

Created Views to facilitate easy user interface, row/column level security

Responsible for the overall change control process to implement appropriate change requests and work orders through testing and production

Rebuilding the indexes at regular intervals for better performance

EDUCATION

Master of Science in Information Technology

Women’s Christian College, Chennai, India

Bachelor of Science in Computer Science

Ethiraj College for Women, Chennai, India

ADDITIONAL INFORMATION

Authorized to work for any Employer in US.ON L2 VISA



Contact this candidate