We provide IT Staff Augmentation Services!

Sql Developer Resume

Kanas City, MS

Around 7 yearsplus of extensive experience as aMSSQL Server SQL Server 2005/2008 Developer with major focus onT-SQL, SSIS, SSAS and SSRS. 6 years of sound experience as a database developer in banking, IT and financial sectors. Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.

  • Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, and triggers when required.
  • Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
  • Estimate, schedule and trackETLprojects throughoutSDLC.
  • Good knowledge in RDBMS concepts, data models,Star/Snow Flake Schemas.
  • Expert inExtraction, Transforming and Loading(ETL) data flows usingSSIS; creating mappings/workflows to extract data fromOracle, SQL Server andFlat Filesourcesand load into various Business Entities.
  • Exceptional hands on working knowledge with SQL ServerIntegration Services(SSIS) ,SQL Server Analysis Services (SSAS)andSQL ServerReporting Services(SSRS).
  • Proficient in InstallingSQL Server 2000/2005/2008and configuration of their tools.
  • Good understanding indatabaseanddata warehousing concepts (OLTP and OLAP).
  • Experience in Data Warehouse Modeling withSQL Server Analysis (SSAS).
  • Experience in Creation and deployment of cubes onSSAS.
  • Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in usingReport Designeras well asReport Builder.
  • Good Hand on Resolving complex issues and Error Handling inSSIS.
  • Very good knowledge in scheduling and deploying reports on report manger.
  • Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
  • Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
  • Worked on predefined, developed stored procedures for automation and scheduling in crystal reports
  • Experience in developingCustom Reportand different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
  • Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Experience in TOAD v9.5 for developing and managing PL/SQL scripts.
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users..
  • Knowledge inMS-SQL Server 2008
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Education:

  • Bachelor of Technologyin Jawaharlal Nehru Technological University, Hyderabad, India

Technical Skills:

  • Operating Systems: Windows 2000 Server, Windows 2000 Advanced server, Windows 2003 , Windows 2008 , Windows NT 4.0, Windows XP, Windows Vista.
  • components/environment: MS SQL Server 2005/2008, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services.
  • Languages: C,C++, PL/SQL,T-SQL
  • RDBMS: SQL Server 2008,2005/ 2000 /7.0,8.0,9.0,10.0,MySQL,MS Access, Oracle 11Gi
  • Application: Rational Rose (UML), Erwin, Visual Studio
  • Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, Toad for SQL
  • Database Software: TOAD,MYSQL
  • Systems familiarity: OLTP,OLAP, Unix/Linux, Windows
ProfessionalExperience:

Client :Confidential, Kanas City, MS
Role : Sr SQL Server Reports Developer(SSIS/SSRS)
Project Description:
Blue Cross Blue Shield Association(BCBSA) is a federation of 38 separate health insurance organizations and companies in the United States. Combined, they directly or indirectly provide health insurance to over 99 million Americans.This project is responsible for loading data (gets from various legacy systems) into SQL Servers by creating Integrated Packages (SSIS) and makes available data for Analysis (SSAS) and Reporting services (SSRS).
Job Responsibilities:

  • Designed and Developed Database Objects likeTables, Stored Procedures, Triggers,Rules, Defaults, user defined data types andfunctionsfor this project.
  • Developed, tested and implementedReferential Integrityrules and regulations through constraints, triggers and views, partitioned views.
  • Developed multiple processes for Daily Reports using SSIS and SSRS.
  • Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS
  • CreatedViewsfor specific columns on a table to maintain privacy of a customer data.
  • CreatedIndexesto get the high level performance.
  • Performing theETLoperations to support the incremental, historical data loads and transformations usingSSIS.
  • DesignedSSISpackages for synchronizing the data between two different servers.
  • Maintained databases, performed software installations and upgrades, monitoredDatabase Performance.
  • Responsible for gatheringBusiness RequirementsandSystem Specificationfrom users.
  • Designed numerous ad-hoc and custom reports usingSQL Reporting Services (SSRS).
  • Created variousTabular and Matrix Reports usingSSRS.
  • Created various drill down reports using SSRS.
  • Experience in the design, development and maintenance of different cubes usingSSAS.
  • Involved in the post deployment maintenance of reports and cubes.
  • Developing ETL Frame work to extract and load the data from multiple databases fromSQL Server 2008toFile Server and File Server to work flow Job System SQL databases.
  • Createdandscheduled jobsfor various tasks.

Environment:
Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel.

Client :Confidential, Pittsburg, PA
Role : SQL Server BI developer
Project Description:
PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities. No matter how simple or complicated your needs, we\'re sure to have the products,knowledge and resources necessary for financial success.
Job Responsibilities:

  • Installation ofSQL Serveron Development and Production Servers, setting up databases, users, roles and permissions.
  • Responsible for all technicalSQL Serverdatabase operations, Administration, ongoing development for various in-house databases.
  • Designed and Developed Database Objects likeTables, Stored Procedures, Triggers,Rules, Defaults, user defined data types andfunctionsfor this project.
  • CreatedIndexesto get the high level performance.
  • Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
  • Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Performing theETLoperations to support the data loads and transformations usingSSIS.
  • Developed multiple processes for Daily Data Ingestion from Client associated data vendors and Production Team, Client site employees using SSIS and SSRS.
  • Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
  • Involved in migration from Oracle to SQL Server 2005 using SSMA and SSIS.
  • Developed Cubes using SQL Analysis Services (SSAS).
  • Deployment of SSAS Cubes to the production server.
  • Generation of reports from the cubes by connecting toAnalysis serverfromSSRS.
  • SSASstorage and partitions, and Aggregations, Data Mining Models, developing reports using SQL.
  • Experience in Developing and ExtendingSSASCubes, Dimensions and data source viewSSAS-Data Mining Models and Deploying and ProcessingSSASobjects.
  • Maintained databases, performed software installations and upgrades, monitoredDatabase Performance.
  • Implementedautomated backupanddatabase maintenance / cleanup jobs.
  • ManagingLogins, Users, RolesandUser permissions.
  • RunningTracefrom theProfilerto trouble shoot database and runningDBCC consistency checksfor other database maintenance aspects.
  • Designed numerous ad-hoc and custom reports usingSQL Reporting Services.
  • Created variousTabular and Matrix Reports usingSSRS.
  • Created andscheduled jobsfor various tasks and also was responsible for maintaining jobs.

Environment:
Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel.

Client :Confidential, Boston, MA
Role : SQL Server BI developer (SSIS/SSRS)
Project Description:
Iron Mountain is a world leader in information management services, assisting more than 140,000 organizations in 39 countries on five continents with storing, protecting and managing their information.
.job Responsibilities:

  • Created and maintained various databases for Development and Testing Environment usingSQL Server 2000/2005and involve in actual Relational Database Design for highOLTPenvironment.
  • Designed automated scripts inT-SQL,andBCPto import data from variousODBCsources intoSQLServer databases to maintain the consistency and data integrity.
  • Exposed to data conversion from different data sources toSQL Server 2005usingSSIS.
  • Experienced in data warehouse systems, ETL processes usingDTS.
  • Experienced inETL(Extracting, Transforming and Loading) development usingSSISfor migration of data between legacy systems toSQL Server 2000/2005.
  • Created ad-hoc reports for business users usingSSRS.
  • Developed drill down reports usingSSRS.
  • Developed scripts for tables,Stored Procedures, andSSIS, (SQL 2K5) tasks.
  • Experience in buildingStar schemaandSnowflakeschema depending on the business data requirement.
  • ScheduledNightly jobs for some of the process to run for the Data flow.
  • Created Maintenance plans for theData IntegrityandBackups.
  • DesignedDatabase Maintenance Plannerfor the Performance ofSQL Server, which coversDatabase Integrity Checks,Update Database StatisticsandRe-indexing.
  • Worked withSSRSto generate reports likeDrill DownandscheduledSSISPackages.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5 , MS Excel.

Client :Confidential, Alabama
Role : SQL Developer
Project Description:
Regions Financial Corporation was formed in 1971 as First Alabama Bancshares Inc., Alabama’s first multibank holding company. With the combination of three well-respected banks, the holding company
began operations with a total of $543 million in assets and 40 banking locations in Birmingham, Huntsville and Montgomery.
Job Responsibilities:

  • Modified current database by adding tables and relationships to support online system.
  • DefinedConstraints, Rules and Defaults.
  • Was Involved inDatabase Normalization
  • CreatedViewsas required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
  • Created complexT-SQL Queries,Stored ProceduresandFunctionsto support efficient data storage and manipulation.
  • CreatedSSISpackages to capture the Incremental changes for the Data ware house.
  • BuiltSSISpackages to process Cubes, Dimensions and partitions.
  • Have a very Good Experience with all the Control Flow and Data Flow tasks inSSIS.
  • Created and managedSQL Server login, database users and Roles.
  • Assisted in designing and creating website for the system usingHTML.
  • Scheduled jobs for backup, and created alerts for error reporting.
  • Data migration (import & export – BCP) from Text to SQL Server.
  • Participated in different testing and debugging for the system.
  • Documented all processesinvolved in maintaining the database for future reference.
  • Develop various reports usingReporting Service(SSRS) as required.
  • DevelopedChartsandTabularreports in Excel and Web format usingSSRS.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Client :Confidential, India
Role : SQL Developer
Project Description:
This project involved migration of data from SQL Server 7 to SQL Server 2000 and then executing complex queries on the data.
Job Responsibilities:

  • CreatedViewsto reduce apparent database complexity for end users and preventing sensitive columns from being displayed
  • WroteTriggers and Stored Procedures.
  • EvaluatedDatabase Performanceand performed maintenance duties such asTuning,Backup and Restore.
  • Scheduling Jobs and Alerting usingSQL Server Agent.
  • Successfully designed and implemented SSIS packages to transfer data within servers.
  • Developed custom reports usingSSRS/SQL Server BI studio.
  • Used Performance Monitor andSQL Profilerto optimize queries and enhance the performance of database servers.
  • Managing and configuring logins to SQL Server, database user accounts, permissions.
  • Created complexT-SQL Queries,Stored ProceduresandFunctionsto support efficient data storage and manipulation.
  • Troubleshooting, Monitoring and Tuning the SQL Server for optimum performance.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Client :Confidential, Hyd - India
Role : Software Programmer
Job Responsibilities:

  • Technical Design and development.
  • Interacting with the client for more clarity on the requirements if required.
  • HLD/Customer Visible Documentation.
  • Creation of tables CDMAPART and DNHLRRTE.
  • Development of Customer Forms and Reports.
  • Table content monitoring during restarts.
  • Product Testing
  • Created packaged procedures, triggers validation procedures.
  • Developed validation scripts for the complex business rules using PL/SQL.
  • Designed the Test Case documents for the product.
  • Tested product Performance and Functionality.
  • Created test cases at all phases of unit and acceptance testing for all the developed forms and reports according to the client requirement.

Environment: Proprietary database, Proprietary language called PROTEL similar to JAVA, PL-SQL code browsing tool MENTOR, 2000/XP, UNIX.

Hire Now