Sr. Ms Sql Server/ Ssrs /ssis/ssas Developer Resume
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.
