We provide IT Staff Augmentation Services!

Sr. Ms Sql Server/ Ssrs /ssis/ssas Developer Resume

4.00/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • Over 7 years of experience as a MS SQL Server Developer working on large - scale enterprise and performance critical applications.
  • Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server 2000 / 2005 / 2008.
  • Experienced wif VB6, VB.NET 1.1, 3.0 & 3.5 and ADO.NET 2003.
  • Proficient in Database performance optimization, debugging and tuning using teh Query Analyzer, SQL Profiler and SQL Server Debugger.
  • Expert in using BI tools like SSIS, SSRS and SSAS in MS SQL server 2005 and 2008.
  • Involved in teh Logical Design of teh Database & transforming it into a Physical Design.
  • Performed Data Modeling using Erwin.
  • Experienced in supporting a team of application developers for their .NET database application.
  • Transformed data from various data sources using OLE DB and ODBC connections.
  • Experienced in SQL Development in teh .NET environment especially wif CLR Stored Procedures.
  • Well experienced wif DTS, BCP and Jobs for MS SQL SERVER.
  • Expert in teh Installation of Analysis Services in MS SQL SERVER 2000.
  • Exceptional Computer Science background wif programming skills in VB6 & VB.NET as a Junior Programmer.
  • Worked extensively on system analysis, design, development, testing and implementation of various projects.
  • Excellent verbal and written communication skills wif a strong focus on customer facing interaction, customer service, and presentation.
  • Self-Motivated and possess teh ability for critical thinking, analysis, good interpersonal and communication skills. Technically motivated and creative. User oriented wif a desire to learn client's business requirements. Excellent noledge of health care, finance, manufacturing, sales and insurance industry applications.
  • Ability to work excellently as an individual and also as a proactive team member wif minimum amount of supervision.

TECHNICAL SKILLS

  • MS SQL Server 6.5 / 7 / 2000 / 2005 / 2008 including SSIS
  • SSAS and SSRS
  • MS Access- 97 / 2000 / 2007
  • DOS
  • Windows NT/ 98/ME/2000/XP/Vista
  • Advanced Server 2003 & My-SQL
  • VB 6
  • VB.NET
  • ADO.NET
  • MS Visio 2003/2010. Teradata SQL

PROFESSIONAL EXPERIENCE

Confidential, San Jose CA

Sr. MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

  • Extensively involved in teh full lifecycle of ETL software development-analysis, design, building, documentation and testing for teh project using SQL Server Integration services.
  • Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
  • Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.
  • Scheduled teh jobs to streamline and automate cumbersome repeated tasks using SSIS.
  • Involved in all phases of System Development Life Cycle (SDLC).
  • Developed, executed and maintained SQL queries/scripts and to validate completeness, integrity and accuracy of data.
  • Extensively wrote and edited existing Stored Procedures, User Defined Functions and Triggers using T-SQL.
  • Created teh Best Coding Practices Document for stored procedures & functions for teh developers.
  • Created new database files and database file groups in SQL Server 2008 using SSMS and T-SQL.
  • Configured report server in development and production and also created SQL Server Reports using SSRS 2008 from initial stage.
  • Created Sub Reports and Drill down Reports as per teh client requirements using SSRS.
  • Worked on parameters to generate cascaded parameterized reports along wif dat extensively used global variables, expressions and functions.
  • Analyzed reports and fixed bugs in stored procedures on teh ongoing database operations, as needed, to resolve business problems.
  • Responsible for deploying reports to Report Manager and Troubleshooting for errors occurring in execution.
  • Generated reports dat can handle dynamic grouping and dynamic sorting for teh purpose of efficient and clear viewing of teh reports.
  • Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
  • Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process.
  • Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
  • Optimized queries by getting insight from Execution Plan for better performance of teh database

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, DTS, SQL Profiler, MS Office, Windows Server 2003.

Confidential, Addison, TX

Senior MS-SQL Server Developer

Responsibilities:

  • Used teh script task to create and write to batch and text files.
  • Utilized teh FTP task to send teh finalized files to our partners.
  • Used teh file system task along wif teh script task to create a custom zip batch file.
  • Enable logging and used events and teh email task to alert users, managers and IT personnel if an error occurred wif teh SSIS package.
  • Created protected SSIS packages wif login credentials.
  • Created teh logical and physical schema for teh defaulter’s database.
  • Loaded previous data from old Access database after data scrubbing and profiling.
  • Created stored procedures and functions for teh new defaulters database
  • Created pivoted views at teh database level to be viewed in teh UI for teh defaulter’s database.
  • Used VB.NET to create teh defaulter’s database front-end.
  • Enabled deleting, adding and modifying of teh Questionnaire Answers through teh front-end via data grid views.
  • Set up immediate saving and viewing (refreshing) of data through teh datagridviews before teh general saving of other data.
  • Encrypted user passwords for teh application.
  • Created reports using T-SQL and VB.NET.

Environment: MS SQL Server 2005 & 2008, SSIS, DTS, T-SQL, ADO.NET, VB.NET and Windows XP

Confidential

MS SQL Server / SSIS BI Developer

Responsibilities:

  • Used teh row count transformation to keep track of teh rows processed and write teh data to a text file
  • Utilized teh multicast transformation to make copies of teh data set to enable various conversions and profiling of teh data.
  • Lookup transformation was employed to find users dat were in one database only or those dat were in teh French database wif a slightly different name but were teh same person in teh USA database.
  • Wrote teh rows transformed, rows rejected and Travelers names etc. for Travelers dat were in one database only into a text file using teh script component.
  • Sequence containers were used to enable “if-then” conditional processing of multiple data sources and clean up tasks.
  • Precedence constraints were modified to enable processing depending on completion or success and also depending on teh value of certain variables.
  • SQL Task was used to create and drop tables and to enable selective insert and updates depending on other tasks.
  • Debugged wif teh assistance of data readers.
  • Created stored procedures and scheduled jobs to improve teh functionality of existing reports.
  • Wrote rollback scripts for teh conversion/export. Rollback scripts were both DDL and DML.

Environment: MS SQL Server 2005 & 2008, SSIS, DTS, T-SQL and Windows XP

Confidential, Jacksonville, FL

MS SQL Server / SSRS / SSAS Business Intelligence Developer

Responsibilities:

  • Managed a team of five persons to design and develop teh System.
  • Prepared functional requirement specifications, checked standards and quality of deliverables and managed teh implementation of teh project on teh live server.
  • Designed and developed teh Logical and Physical model of teh database.
  • Created complex Stored Procedures, triggers, cursors, tables and views for teh application.
  • Worked on MS SQL Server tasks such as batch jobs, BCP, DTS, SSIS, Linked Servers and Indexes.
  • Identified teh database tables for data retrieval for teh reports and defined report layouts in SSRS.
  • Created Cross-Tab, Drill-down and Sub-Reports using RDL.
  • Identified teh data source and teh data source views.
  • Debugged and deployed reports.
  • Scheduled teh reports to run automatically.
  • Created adhoc reports using teh report builder.
  • Configured teh report viewing security.
  • Created schedules and subscriptions.
  • Imported and converted SQL Server 2003 reports into SSRS 2005.
  • Identified and added teh report parameters.
  • Formatted teh reports using global variables and expressions.
  • Identified and created Data Source Views for OLAP cubes.
  • Defined advanced attribute and dimensions properties in SSAS for OLAP cubes.
  • Identified and defined Fact relationships in SSAS for OLAP cubes.
  • Defined unnon members and null processing properties for OLAP cubes.
  • Defined Granularity wifin a measure group and drill through actions for cubes.
  • Wrote MDX queries for teh Business Intelligence Solution.
  • Wrote teh queries for teh drill down reports.

Environment: Win 2003 Server, SSAS, SSRS, SSIS, SQL Server 2000, T-SQL and Visio 2000

Confidential, Rahway, NJ

MS SQL Server Developer

Responsibilities:

  • Involved in gathering requirements from teh clients.
  • Participated in teh design of teh LOGICAL and PHYSICAL databases, tested teh system, enhanced teh data warehousing application and applied noledge of database design standards.
  • Fetch and update data using SQL Client Connection and ADO.NET.
  • Developed part of teh system wif VB.NET technology for teh Claims Management Department (Premiums, Claims, Investment Portfolio/Apportioning and Maturity etc.).
  • Used data binding to bind various server controls to teh forms from teh database.
  • Performed capacity planning by estimating and sizing teh tables.
  • Decided upon teh locking strategy for programming structures & transactions.
  • Managed all indexing and Tuned SQL statements (e.g.: - Using Indexes).
  • Used Performance Monitor, Query Analyzer and SQL Profiler to optimize queries and enhance teh performance of database servers.
  • Reduced teh T-SQL overhead successfully by avoiding unnecessary use of UNION, *, Top, Distinct and <> statements.
  • Configured SQL Server’s Optimal Settings (Locking & Memory) according to teh usage of its tables, # of users and hardware.
  • Created DTS packages for teh data cleansing/transfer and transformation.
  • Created stored procedures, triggers, indexes, rules, integrity constraints, cursors, views and adhoc queries for teh business logic.
  • Created and scheduled Jobs and Alerts using SQL Server Agent.
  • Performed Database Normalization.
  • Created and maintained Datamarts of approx 15G.

Environment: Windows 2000, SQL Server 2000 Enterprise Edition, MS Access 2000 & Windows 2K platform, VB.NET, ADO.NET, UML, MY-SQL and MS PowerPoint.

We'd love your feedback!