Senior Bi/sql Developer Resume
Austin, TX
SUMMARY
- 8+ years of IT experience with a strong background in business analysis, Database design and development utilizing SQL Server 2012/2008R2 (SSRS, SSIS, SSAS, Replication) OLTP, OLAP & Data Warehousing Systems environments that include experience design, development, implementation and administration of database systems.
- Adept at interfacing with end users to gather requirements and produce functional requirements.
- Involved in Database Design, Development, Implementation, ETL and Reporting in SQL Server 2008/2012.
- Experience in Physical & Logical Data Modeling using ERWIN tool and SQL Diagrams
- Experience in database programming in writing T - SQL, Dynamic-queries, sub-queries, Complex joins, Stored procedures, Triggers, Constraints, and Indexes using various DDL and DML commands
- Experience in Migrating/Upgrading SQL Server, Usage of Upgrade advisor, In- place upgrade and new server build
- Exposure to multiple Database systems like MS SQL, Oracle, MS Access, MYSQL and SYBASE.
- Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
- Highly experienced in whole cycle of DTS/SQL Server Integration Services (SSIS 2008/20012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
- Conversion of DTS packages to SSIS and Interfacing Legacy components within SSIS for complex transformations and logic.
- Experience in performance tuning in SSIS packages by using row transformations, block and unblock Transformations
- Extensively used control & data flow transformations like OLEDB command, execute SQL task, sequence generator, send mail task, derived column, conditional split, lookup, multi cast and script component task etc.,
- Expert in generating drill down reports, parameterized reports, linked reports, sub reports, filters, charts using SQL Server Reporting Services, Crystal Reports, and MS Excel.
- Experienced in creating Ad-hoc reports, data driven subscription reports by using Report Builder
- Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
- Experienced SSRS Developer with experience working on large-scale enterprise projects involving complex business case functions, web integration, and data management.
- Expert in generating drill down reports, Cross-Tab, parameterized reports, linked reports, sub reports and filters, charts in SSRS 2005.
- Strong understanding of the principles of Data Warehouse using Fact and Dimension Tables and Star / Snowflake schema modeling.
- Responsible for automation of maintenance jobs, Day-to-day maintenance activities like running DBCC checks, Transaction Logs, Filegrowths etc
- Proven ability in database backup and recovery procedures.
- Test & Deploy code across various SDLC Environments like TEST,UA/UT/Production
TECHNICAL SKILLS
Languages: SQL, PL/SQL, Dynamic SQL, C, C# (.NET), ASP.NET,HTML,XML
RDBMS: SQL Server 2012/2008R2, Oracle 11g, PostgreSQL, Teradata V2R5 and MS Access 2000
Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization
DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Replication, Team Foundation Server (TFS).
Operating Systems: Windows 8/7/XP, UNIX, Sun Solaris
PROFESSIONAL EXPERIENCE
Confidential, Austin TX
Senior BI/SQL DeveloperResponsibilities:
- Demonstrated superior technical ability to create complex SQL queries, views, and stored procedures.
- Performed highly complex to advanced (senior-level) computer systems analysis work.
- Responsibly collaborated with business-area customers to plan and analyze user requirements, procedures, and problems to automate processing and improve existing systems.
- Worked under limited or minimal supervision, with considerable latitude for the use of initiative and independent judgment and received many accolades from business-area customers and superior management.
- Created informative and aesthetically pleasing reports in Microsoft SQL Server Reporting Services using SQL queries, stored procedures, parameters, grouping, and sub-reports.
- Used superior communication skills to build strong partnerships with business area customers to deliver products and services that meet their expectations and needs.
- Worked closely and amicably with other Information Technology Division staff to quickly and reliably develop creative and responsive products for our customers.
- Have provides guidance in troubleshooting and solving problems related to the TxWISE computer system, specifically the supporting data and associated reports.
- Determined operational, technical, and support requirements for the location, installation, operation, and maintenance of the TxWISE computer system, supporting data, and associated reports.
- Designed, developed tests, deployed, and did maintain complex SQL queries, views, stored procedures, and Microsoft SQL Server Reporting Services reports.
- Converted user requirements into functional documentation to support business continuity and maintenance needs, while delivering the final product in a timely manner.
- Analyzed issues in the system, data, or reports to determine root cause and recommend solutions to resolve the problem or concern.
- Demonstrated initiative to take ownership in researching and solving problems as they arise.
Confidential, Dallas TX
Senior BI/SQL DeveloperResponsibilities:
- Design and develop SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
- Migrated data from different sources (PostgreSQL and Oracle) to SQL Server databases using SQL Server 2012 Integration Services (SSIS).
- Configured and managed Master Data Services - MDS
- Created views and indexed views to reduce database complexities in data migration.
- Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
- Involved in creating custom C# Script tasks to check for data validation, duplicate records, delete/modify them depending on the business rule.
- Troubleshooting DB performance issue and implementing necessary ETL/DB changes and implemented processes to ensure Optimal Query Performance.
- Used ETL to implement Slowly Changing Dimension to maintain historical data in ODS.
- Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery.
- Created technical specifications, test plans and test data to support ETL processes.
- Created new and improve existing database reports using SQL Reporting Services.
- Identified the database tables for defining queries for the reports.
- Created matrix reports, drill down reports anddevelopedreports with graphs.
- Created reports with different type of properties like chart controls, filters, SQL parameters etc.
- Provided required reports from production environment to other departments on request basis and perform data analysis to provide management.
- Modified report content and export reports in multiple formats based on user input.
- Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
- Created Stored Procedures, views in SQL Server using T-SQL to collect data for SQL reports.
- Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
- Unit testing and Integration testing for various modules.
Environment: MS SSIS, SSRS - SQL Server 2012, TFS, PostgreSQL, Windows 7, Windows Server 2008, Agile.
Confidential, Alpharetta GA
Senior BI/SQL Developer
RESPONSIBILITIES:
- Gathered the requirements from the client and translated the business design into Technical Design
- Worked closely with the Database Developers to ensure adherence of the database guidelines, standards and procedures
- Prepared a database design document based on the functional and technical specifications
- Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
- Involved in loading the data from Source Tables to ODS (Operational Data Source) Tables using Transformation and Cleansing Logic using Informatica.
- Extensively used DTS Packages to load data from various formats into a warehouse, Created and processed cubes
- Scheduled DTS tools and services to run at different intervals in SQL Server that are ideal for developing custom ETL routines for populating decision support databases using ODBC
- Worked on storing DTS packages, implementing package passwords, and tracking package metadata and data lineage
- Created ETL test plans, ETL process scheduling system
- Coded stored procedures, Functions, Triggers and SQL scripts at high level
- Involved in performance tuning of the database which includes index maintenance optimizing SQL statements and monitoring the server.
- Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
- Modified report content and exported reports in multiple formats based on user input.
- Created different type of reports including Cross-tab, Conditional, Drill-down and Sub reports.
- Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
- Created linked, unlinked and on-demand Sub Reports.
- Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
Confidential, Dallas TX
Senior BI/SQL Developer
Responsibilities:
- Analyzed Business requirements to prepare the technical use-case design documents and technical design documents.
- Migrated legacy data (Oracle) to SQL Server using SSIS and established extract, transfer, load (ETL) for on-going data synchronization .
- Configured Snapshot and Transactional Replication (Creating Distribution Databases, updating publishers, creating & managing Publications, managing Replication monitors) for real-time reporting.
- Created distributed partitioned views, debugging/troubleshooting stored procedures, upgrading existing in Oracle 11g and SQL Server.
- Upgraded SSIS packages from 2005 and conversion of DTS packages from .
- Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like excel spreadsheets, flat file etc. and vice versa.
- Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
- Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data warehouse.
- Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
- Created large enterprise reports for various business functionalities assigning report parameters.
- Developed SSRS Reports, linked reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
- Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
- Involved in Query Tuning using Execution Plans, SQL Profiler, Lock Monitor, Indexes and other
- Implemented change tracking using SQL 2008 Change Data Capture CDC.
- Assigned, coordinated and mentored work load with offshore development.
Environment: MS SSIS, SSRS, SSAS - SQL Server 2008, TFS, PAS Legacy App, Windows 7, Windows Server 2008, Oracle 11g, Scrum.
Confidential, VA
SQL Server DBA/BI Developer
Responsibilities:
- Actively initiated the meetings to discuss the profile requirements for the Oracle Identity Management Tool. Also conducted the meetings with the Database application owners to study the data architecture of the current applications (SOL, PS, LDAP and AD)
- Created a Business Process flow diagram and Data flow diagrams to indicate the validation and cleansing process from different sources using Microsoft Visio.
- Initiated and facilitated the meetings to finalize the Validation and Cleansing rules for each of the profile types (Employee, Contractor, Application ID, System ID and Group Mailbox) from each of the sources mentioned above.
- Developed the T-SQL Scripts and stored procedures to cleanse the identified bad data from the validation process.
- Set up the DTS for the exchange of data between different data sources (SQL Server,DB2 and Oracle 9i, Oracle10g Systems)
- Creating views, debugging / troubleshooting stored procedures upgrading existing ones.
- Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis.
- Data migration (Import & Export - BCP) from text to SQL Server.
- Involved in administration of SQL server reporting services (SSRS).
- Involved in creating and building standard reports, sub reports, data driven reports, and drill down reports using SQL Server Reporting Services (SSRS).
- Involved in creating and supporting reporting data mart, which includes tables, views, cubes and dimensions, as well as necessary infrastructure to support pre-built reports.
- Involved in writing SQL Joins, sub queries, and usage of temp tables and table variables.
- Hands on experience in error handling and event Logging.
Environment: Oracle 10g, SQL Server 2005/2008, Oracle 9i Windows XP professional, Main Frames, People Soft, Microsoft Visio, Microsoft Access.
Confidential
MS SQL Developer
Responsibilities:
- Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
- Created SQL tables with referential integrity and developed queries using SQL.
- Involved in writing Triggers which internally called procedures and functions.
- Involved in testing the database for queries that were generated and handled the performance issues effectively.
- Data transformation activities using DTS Import/Export for transferring data between different Databases like Oracle, Sybase. Design new DTS Packages as per needs, resolve problems with existing DTS packages etc.
- Worked extensively on BCP utilities for bulk data & image file uploading.
- Assisted in establishing connectivity between VB applications and MS SQL Server.
- Involved in documenting the entire technical process.
- Supported technical teams involved with MS SQL issues and operations.
- Involved in the maintenance of the database.
Environment: MS SQL 2000, Query Analyzer, SQL Profiler, Import & Export Wizard, Data Transformation Services (DTS), Visual Basic, Oracle 8i, Sybase, Windows NT.
Confidential
Intern / Developer
Responsibilities:
- A key member of the team and playing a key role in articulating the Design requirements, Analyzing and development of JDE Objects
- Gather requirements from more than one trust and propose designs and responsible for Retrofit and customizations of JDE Objects.
- Responsible for removing Hard coding logic and applying as per Consolidation perspective.
- Responsible for performing impact analysis.
- Acting as a key liaising person with all external teams with respect to development of JDE objects.
- Did Analyzing and Testing of few Interfaces
- Comparing the ER code by Using Beyond Compare.
- Updating the Technical Documentation of the Client.
- Responsible for Unit testing of Retrofitted Objects and preparation of Test scripts.
- Undergone training at Confidential India Pvt. Ltd which includes RDBMS, SDLC, .Net Framework, C#, ASP.Net, SQL Server 2005/2008R2, JD Edwards (ERP tool), UNIX.
Environment: Oracle EnterpriseOne 9.0