LiveCareer-Resume

bi developer resume example with 7+ years of experience

JC
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Summary
  • 7 Year of extensive experience in all phases of Software Development Life Cycle (SDLC) including identification of business needs and constraints, collection of requirements, architecture,
  • In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
  • Good hands on experience in RDBMS concepts, data models.
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.,
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studios BIDS.
  • Experience in Enterprise Reporting in generating reports using linked reports, sub reports and filters charts in SQL server reporting services.
  • Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services SSRS.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS packages.
Skills
  • MS SQL Server 2012/2008R2/2008 ,SQL Server Management Studio
  • T-SQL
  • Business Intelligence Development Studio BIDS
  • SQL Server Agent, Data Transformation Services DTS
  • SQL Server Integration Services SSIS
  • SQL Server Reporting Services SSRS
  • SQL Server Analysis Services SSAS
  • BI, Enterprise
  • Charts, OLAP
  • Data dictionary, Oracle,DTS, PL/SQL
  • Data warehouse, Pick
  • Database, Quality
  • Designing, Reporting
  • ETL, Requirements Analysis
  • Graphs, MS SQL Server
  • DB2, SQL,Access, Tables
  • MS Access, T-SQL,MS Excel, T- SQL
Experience
08/2017 to Current BI Developer Cognizant Technology Solutions | Las Piedras, PR,
  • Use Statistical and Quantitative Analysis to bring insights to client issues and business problems.
  • Created a report in Tableau to identify the target market for the applicationand brainstormed over the strategies to help expand the market reach
  • Develop Advanced Analytics Platform for Risk Management and FraudDetection.
  • Promote Data-Driven decision-making and strategic planning across the business.
  • Manage the operations of a Big Data Analytics platform using SQL, Hive,Spark,Tableau, Power BI
  • Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
  • Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
05/2015 to 06/2017 MS SQL Server/ BI Developer Luxoft | Jacksonville, FL,
  • Develop advanced SQL stored procedures, functions, triggers, views.
  • Create, modify and automate business reports in SSIS,SSRS and ETL Packages.
  • Work with senior developers to facilitate creation of high performing data centric components and applications
  • Manage, monitor, and resolve issues with Scheduled Jobs, Database Mail, and other back ends system data flow
  • Provide support for database objects and performing code review
  • Responsible for performing SQL development and SSIS /SSRS development
  • Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations
  • Perform data validation checks and filtered bad data.
  • Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
  • Responsible for the ad-hoc reporting, modification and regenerating on request.
  • Building scorecards and dashboards using the Performance Point Services 2010 with BI application.
  • Schedule the reports to run daily, weekly, and monthly and automatically emailed reports to department directors and analyst to review it.
  • Environment: MS SQL Server 2008R2 SSRS/SSAS/SSIS, Point Services 2010, Microsoft office 2010, T-SQL, Windows 7.
08/2012 to 03/2014 MS SQL Developer Orawaves InfoTech Private Limited | City, STATE, India
  • Involved in Planning Defining and Designing data based on business requirements and provided documentation.
  • Used SSIS and T- SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Developed and Deployed data transfers packages to the appropriate destinations using SSIS.
  • Experience in creating jobs, Alerts, SQL Mail Agent, and schedule SSIS packages.
  • Created SQL server configurations for SSIS packages.
  • Responsible for creating reports based on the requirements using SSRS 2008-R2.
  • Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed, implemented, and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Developed and implemented procedures to ensure the quality, usability, and accuracy of reports
  • Environment: MS SQL Server 2008/2008R2, MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin.
Education and Training
Expected in 08/2014 Master of Science | Computer Science Sacred Heart University, Fairfield, CT GPA:
Activities and Honors

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Sacred Heart University

Job Titles Held:

  • BI Developer
  • MS SQL Server/ BI Developer
  • MS SQL Developer

Degrees

  • Master of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: