Sql Server Developer Resume
Long, BeacH
SUMMARY
- Over 8+ years of Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), SQL SERVER Reporting Services (SSRS), SQL SERVER Analytical Services (SSAS) and Data Transformation Services (DTS).
- Experience in data analysis, design and development of databases for business applications in client/server and data warehouse environments in SQL 2000/2005/2008/2012/2014/2016.
- Extensive experience with SQL SERVER and T - SQL in constructing tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
- Excellent experience in developing complex Stored procedures, Views and Indexed Views.
- Good experience in creating User Defined Functions and Triggers in observing Business Rules.
- Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
- Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
- Created SSIS log files and configuration files to store configuration and to log execution of packages.
- Involving in developing Data models, Data dictionaries, mapping documents and cross-functional documents across systems for all the ETL needs.
- Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically
- Knowledge of deploying packages into Development, Testing and Production Environments.
- Design, develop, deploy, maintain, monitor, and tune SSIS ETL solutions to incrementally load Enterprise Data Warehouse and Enterprise reporting systems.
- Design and develop solutions that identify data issues and report errors for further analysis.
- Knowledge in Database Administration
- Experience in making formal and informal presentations to technical and non-technical staff
- Manage entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
- Work well with customers to determine requirements and application scope.
- Worked in different SDLC Processes (Agile, Waterfall, Prototype)
- Having good domain knowledge in Insurance, HR, Transportation and Invoice.
- Experience in Excel power query, power pivot, power map.
- Knowledge on NoSQL (MongoDB)
- Skilled trainer and team developer and able to direct multiple tasks effectively.
- Ability and adaptability to work with different technologies and frameworks
TECHNICAL SKILLS
Operating Systems: Windows NT/XP/Vista/7/2008, Mac
Programming Languages: C, Java, C#, T-SQL
Database: MS Access, MS SQL Server 2012/2008/2005
Internet Technologies: ASP.NET, JavaScript, VBScript, XML, CSS, HTML
Tools: MS Office, VisualStudio2008/2005, DTS, SSIS, SSRS, VSTF, DQS,PowerBI
NoSQL: MongoDB
PROFESSIONAL EXPERIENCE
Confidential, SFO, CA
SQL/SSIS/SSRS/Power BI Developer
Responsibilities:
- Participated in gathering User Requirements and System Specifications.
- Developed Stored procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL SERVER.
- Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
- Migrated existing self-service reports and Ad-hoc reports to POWER BI
- Developed custom calculated measures using DAX in POWER BI to satisfy business needs
- Used Team Foundation Server(TFS) for source control and sprint planning
- Built Ad-Hoc reports in POWER BI depending on business requirements was one of the major responsibilities
- Designed databases and relevant objects through preparation of tables, groups, and indexes.
- Created Dimensions and cubes with star schema using SQL SERVER Analysis Services (SSAS).
- Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
- Design, deployment, and maintenance of various SSRS Reports in SQL SERVER.
- Designed and implemented Parameterized and cascading parameterized reports using SSRS.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL SERVER and non-production database code as well as T-SQL code from Developers and QA.
- Developed Star schema using SSAS cubes.
Environment: MS SQL SERVER 2014/2016, SSIS, SSRS, SSAS, T-SQL, Excel, Windows NT
Confidential, Long Beach, CA
SQL Developer/SSIS/SSRS/SSAS
Responsibilities:
- Managed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources
- Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
- Converted data types using Derived column, Data Conversion Transformation.
- Utilized different built in transformations including SCD, Aggregate, Lookups, and Data Conversion to implement complete ETL strategy
- Built Ad-Hoc reports in POWER BI depending on business requirements was one of the major responsibilities
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
- Created SSIS Packages for Incremental Loading and slowly changing dimensions.
- Created logging, custom logging and error handling packages.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports, and Charts.
Environment: SQL SERVER 2014/2016, Enterprise Edition, Visual Studio 2012, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003 R2.
Confidential
SQL BI /SSAS/SSRS/SSIS
Responsibilities:
- Created DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle using SSIS.
- Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers, and custom loggings.
- Implemented Error Handling during ETL load in SSIS packages to identify dimensions and facts that were not properly populated
- Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Experience in migrating some of the DTS packages in to SSIS.
- Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
- Developed reports using SSRS and Crystal reports. Used table control, matrix control for cross tab reports.
- Configured Reporting Services in SQL SERVER.
- Troubleshooting performance issues with Fragmentation using Profiler, System Monitor, and DMV’s.
- Configured nodes and virtual server to set up Active/Active Clustering.
- Import Data from MS-Access Database and XML to SQL SERVER Database.
- Involved in Installation, Configuration of Share Point Form in Cluster Environment
Environment: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), C#, XML, Sun Gardi Work’s Proceed 8.6, SSMS, MS Excel, Windows 2000.
Confidential
SQL BI Developer
Responsibilities:
- Monitored performance and optimized SQL queries for maximum efficiency
- Created and Modified T-SQL Stored Procedures/ triggers for validating the integrity of the data
- Created Star Schema Cubes using SSAS and Managed OLAP Cubes using SSAS
- Created indexed views and appropriate indexes to reduce the running time for complex queries
- To keep track of data manipulations using Audit functionalities
- Generated custom and parameterized reports using SSRS
- Created reports that call Sub reports in SSRS
- Configuration and Deployment of all the Reports using Report Definition Language and Remote Data Service (RDL, RDS) across various SDLC environments
- Developed Complex SSRS Reports involving Sub reports, Matrix/Tabular Reports, Charts and Graphs
- Created several packages in SSIS
- Scheduled the packages to keep extracting the data from OLTP at Specific Time Intervals
- Used various transformation tasks to create ETL packages for data conversion
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to user communities
- Responsible for Rebuilding the Indexes and Tables as part of Performance Tuning
- Used SQL Server Agent for scheduling jobs and alerts
- Performer Query optimization & Performance Tuning
- Optimized queries using SQL Profiler and Database engine tuning advisor
Environment: SQL SERVER 2012/2014, Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, C#,VB.NET,ASP.NET.
Confidential
SQL SERVER Developer
Responsibilities:
- Involved in analysis and design of the system specification and gathering requirements and prepared the document for proposed system.
- Involved in the Design of Interactive User Interface and Coding of the application.
- Involved in Designing and creating of Database Tables and Views.
- Participated in creating Stored procedures in Oracle database. functions to insert the data depending on the criteria into the tables
- Interacted with financial analysts to gather requirements, test plans and DBA's for database schemas.
- Wrote Database triggers for audit and to implement complex business logic.
- Involved in the database design for better understanding the relations, associations, and dependencies within the data base.
- Involved in writing functional and technical documents.
- Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences, and Synonyms.
- Created indexes to improve the performance of database.
- Involved in database Backup and Restore.
- Generated various kinds of Reports using Crystal Reports.
- Created ActiveX components which are being used throughout the application.
- Involved in integrating individual tools and executing them from Visual Basic.
- Involved in Manual Testing and implementation of software at client location.
Environment: .NET Framework, VB and C#, ASP.NET, ADO.NET, Web Services, T-SQL, SQL SERVER 2008, COM/COM+, UML, Visual Studio.NET, Windows 2000 Advance Server.
