We provide IT Staff Augmentation Services!

Senior Sql Bi Developer Resume

Dublin, Oh

SKILLS INVENTORY

  • Experience in database design and development in SQL server 2012/2008/2005 in OLAP and OLTP environment.
  • Worked on Data Analysis Expressions (DAX) functions, operators, and constants that can be combined to build formulas and expressions in PowerPivot for Excel.
  • Experience on Data modeling techniques and tools which translate complex system designs into easily understood representations of the data flows and processes
  • Worked on Kimball’s data warehousing architecture focuses on ease of end user accessibility and provides a high level of performance to the data warehouse.
  • Highly Experience in MS SQL Server 2005/2008, Business Intelligence in MS SQL server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS)
  • Expertise with relational database management systems, including E/R diagrams, Normalization, constraint, querying, joins, keys, Data Import/Export.
  • Extensive knowledge in sub-query, correlated sub-query, complex stored procedure and encapsulated Ad-hoc TSQL statements into store procedures for optimization. Written ad-hoc TSQL statements into store procedure for optimization.
  • Proficient in Extracts, transforms and loading data (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, XML).
  • Experienced in writing parameterized Queries for generating reports, Formatting reports layout, reports using Global variables, Expressions, Functions, Sorting the data, defining data source and subtotals for reporting using SSRS 2005/2008.
  • Hand on experience in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and Ad-hoc reports using SQL Server Reporting Services (SSRS).
  • Expertise in use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleaning, Relational Database models and Data integrity, and SQL joins.
  • Extensively Monitored Performance with multiple tools like SQL Profiler, Event Viewer to achieve better performance.
  • Experience in calculating measures and dimensions members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
SUMMARY OF EXPERIENCE

Senior SQL BI Developer
Confidential, Dublin, OH
  • Participated in end user meetings to gather Analytic/Reporting requirements of various business users.
  • Experience in data modeling knowledge and related to supporting development life-cycle.
  • Analyzed the business requirements and translated the functional specifications into technical specifications.
  • Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
  • Developed various Measures and defined dimensional hierarchies.
  • Migrated data from Heterogeneous data sources (Excel, Flat file, CSV file) to centralized SQL server database using SQL server integration services (SSIS) to overcome transformation constraints.
  • Developed Dashboards with different subject matter views(drill-down/dynamic, Pivot Table, Chart)
  • Created packages to transfer data between OLTP and OLAP database using Lookups, Derived columns, Condition Split, Execute SQL Task, Data Flow task, Execute package task etc.
  • Developed SSIS packages to load the data in to the tables from Text files, Excel files and CSV file.
  • Developed packages to handle data cleaning, loading multiple files and executing tasks multiple times (Using for Each Loop).
  • Worked on Data warehouse to develop star schema based on Kimball's dimensional modeling which contains facts and dimensions
  • Worked with T-SQL to create Tables, Functions and Stored Procedure, Sub-query, Correlated sub-query and complex Stored Procedures.
  • Developed Master Child Packages and added more audits and alerts in case of package failure.
  • Used SSRS to create Sub-reports, drill-down, drill-through and parameterized reports.
  • Investigated and fixed several issues and proactively suggested new output formats to satisfy the requirements.
  • Developed and wrote documents for stored procedures, SSIS packages and SSRS Reports.
  • Developed framework to create web applications and create prototypes for windows development.
  • I have created upgrades, security, backups , recovery and performance optimization turning
  • Experience in operational DBA supporting OLAP and OLTP environment including implementation and design of data warehousing.
  • Worked with visual studio 2010/2008/2005/2003 , .Net framework using ASP.Net and C#
Environment: MS SQL Server 2008,T-SQL, SSIS 2008 MS SQL Profiler, SQL Query Analyzer, SQL, Visual Studio 2005, Windows XP,MS Office 2003/2007, MS Access, Business Objects, Tableau 8,Erwin, Visual studio 2010,.Net 4.0framework

Senior SQL BI Developer
Confidential, Gaithersburg, MD
  • Installed and maintained SQL Server 2008 in multiple database environments, namely development, QA and staging.
  • Designed and developed a windows application and component for this module using C# to automatically update SQL tables using XML source file
  • Worked on creating User Interface Web forms using Web Server Controls and User controls
  • Involved in migrating classic VB pages to ASP.NET
  • Worked on Data Analysis Expressions (DAX) functions, operators, and constants that can be combined to build formulas and expressions in PowerPivot for Excel.
  • Responsible for performance tuning and optimization of SQL queries and indexes.
  • Created databases and schema objects including tables, indexes, views and applied constraints.
  • Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS).
  • Scheduled the jobs to streamline and automate repeated tasks using SSIS.
  • Used the SSIS Configuration files to make the packages connections, variables etc configurable and maintained the same on Test and Production environments.
  • Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2008 including Claims, finance, Insurance.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Designed SSIS packages to replicate the data from DB2, flat files and excel documents to the Staging Area in SQL server 2008.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Created objects, attributes, relationships and responsibilities that represented the core abstractions involved in business and technical services for the enterprise.
  • Created SSIS log files and configuration files to store configuration and to log execution of packages.
  • Scheduled Packages using SQL Server Agent Jobs, Monitoring jobs.
  • Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
  • Created data loads and Upgrade scripts for data migrations and validations.
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic
Environment: MS SQL Server 2008, T-SQL, SSIS, MS Access, Windows 2008 server, SSIS, SQL profiler, .Net framework 4.0, ASP.net 2.0, ETL, Performance Monitor, C#, Erwin.

SQL Server Developer
Confidential, Richmond, VA
  • Designed and developed dynamic SSIS packages to process dynamic queries and produce flat files runtime.
  • Provided services starting with sales and extending to customers areas like marketing where as sales force provide along with cloud computing platform provide customer services
  • Worked on sales cloud and service cloud which include real time sales collaboration tools
  • Created, deployed, and scheduled SSIS packages to run SQL tasks and enable data transfer from several sources including Excel, Access and Flat Files.
  • Worked with only part of a column, or with unique values from a column by using DAX functions that filter the column or return unique
  • Design database models and ER diagrams integrating existing and new tables, based on business requirements and corporate database development standards. Create data mapping of the new fields to existing or new data sources using SQL Server Analysis Services (SSAS).
  • Upgraded database from SQL Server 2005 to SQL Server 2008 using In-Place and Side-by-Side strategies.
  • Generated different SSIS packages using transformation such as fuzzy lookup, derived column to perform different design.
  • Migrated data from transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).
  • Designed and developed reports using SSRS such as parameterized reports, drill through reports, matrix reports, linked reports in SSRS.
  • Monitored locking issues and high availability issues.
  • Developed interface stored procedures to transform and load policy feeds.
  • Used T-SQL for developing complex Stored Procedures to get clean data according to client requirements.
  • Created triggers for updating of required fields accordingly.
  • Experience in working with data modeling tools like Erwin
  • Analyzes, design, and codes web applications and maintains entire software cycle
  • Design and implement redundant systems as well as policies for protection and integrity of data assets
  • Creates models for new database development and modifies existing databases
Environment: MS SQL server 2005/2008, SQL Server integration Services (SSIS), SOAP, AppExchange, SQL Server Reporting Services (SSRS), Management Studio, Transact-SQL, MS Excel VBA, Live Meeting, Windows XP/2003,Erwin.

SQL BI Developer
Confidential, Columbia, MD
  • Used SQL Reporting Services and Report Builder Model to generate custom reports.
  • Modified existing database to fit new business requirement by adding tables and relationship.
  • Involved in a team for gathering and analyzing the User requirements.
  • Upgraded SQL Server 2005 database to SQL Server 2008.
  • Involved in import and export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
  • Created Indexed View to optimize query performance by facilitating easy user interface implementation.
  • Worked on XML parameters for inserting data into tables using for XML, OPEN XML.
  • Worked on SQL Server 2008 Enterprise Manager and Query Analyzer to administer SQL Server.
  • Created Linked Server to retrieve data from other databases.
  • Documented different Stages of Data Transformation, procedures and Scripts.
  • Created Database, Tables, Triggers, Unique Constraints, Cluster Index, Stored Procedures.
Environment: MS SQL Server 2005/2008, T-SQL, DTS, BIDS, SSIS, SSRS, SSAS, Erwin.

SQL BI developer
Confidential, India
  • Monitored database performance, performed software installation and upgrades, performed capacity planning on SQL Server 2008 server.
  • Worked on Force.com platform which allows to create add-on applications that integrate into main salesforce.com application and are hosted on salesforce.com infrastructure.
  • Created execution logging tabled to monitor the execution status and loads in the client.
  • Creating data collected database with XML scripts, staging database with desterilized and translated scripts. Developed SSIS packages procedures to provide the data required for dashboards.
  • Error handling and monitoring SQL Server for Scheduled jobs.
  • Automated and enhanced daily administrative tasks, including space management and backup and recovery strategies.
  • Implementation if high availability solution for mission critical SQL Server Task, Active X Script, Execute SQL tasks, XML Task, Send Mail Task.
  • Created and developed the stored procedure, Triggers to handle complex business rules.
  • Implemented SQL Server Groups and stream line privileges and data base role.
  • Implementation if high availability solutions for mission critical SQL Server data bases, including clustering and data replication.
  • Create and maintain automated process for SQL queries connected to various available SQL database to gather and manipulates the required data (SSIS).
Environment: MS SQL Server Management Studio 2008, T-SQL, MS –Excel, SOAP, PAAS,MS-Access, XML, ,Informatica, OLAP, SOAP, AppExchange

SQL Server Developer
Confidential, India
  • Create ETL packages to move data from feed files (XML, TXT) to database.
  • Designing of new mappings and workflow and production of technical specifications.
  • Communicated with customer community resources regarding project status reports, priority settings and resource allocation.
  • Coordinated with support team members for optimization of ETL solutions by performance tuning and measurement techniques.
  • Suggested proper new ETL technologies for all data warehouse operations with proper analysis and selection.
  • Provide technical assistance for installation and configuration of new middleware applications and production.
  • Create packages to migrate from Oracle to SQL server.
  • Create parameterized reports to accommodate business requirements.
Environment: MS SQL Server 2005, MS SQL Server Analysis Services, Integration Services (SSIS), T-SQL, MS Excel, C#, .Net, XML, SQL Profiler, Informatica, Unix.

Hire Now