We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

2.00/5 (Submit Your Rating)

Redmond, WA

PROFESSIONAL SUMMARY:

  • 5 years of IT experience in the field of Data Science & analysis, SQL business intelligence development, ETL Development, Data Modelling, and Data Management.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance, Master Data Management and Configuration Management.
  • Experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
  • 3+ years of hands on experience in TSQL/SQL, SAS, Python, Excel.
  • Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
  • Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Knowledge in Business Intelligence tools like Business Objects, SAS, Tableau, and Power BI.
  • Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
  • Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
  • Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
  • Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 8.0 and 8.1 as an Analyst.
  • Knowledge on Azure data factory, Azure data lake, Cosmos.
  • Working knowledge on Confidential business intelligence stack: SSIS, SSAS and SSRS.
  • Experience in Working with different industries like private banking, financials, retails.
  • Implemented Optimization techniques for better performance on the ETL side and also on the database side.
  • Experience in creating functional/technical specifications, data design documents based on the requirements.
  • Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS:

Programming: C++, Java, Python, TSQL, PL/SQL, SAS, R

Confidential office tools: Excel, PowerPoint, Access, Visio, Outlook

Data analysis tools: SAS, Excel, Tableau, TSQL, R, Power BI

RDBMS: MySQL, MS SQLSERVER 2012/2013/2014 , Oracle 10gFoxPro, DB2

Operating systems: Windows, UNIX, Mac

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer, Redmond, WA

Responsibilities:

  • Designed C# based scope scripts to acquire data from multiple sources viz. Cosmos, SQL, Blob.
  • Designed SSIS package and re modified the existing package, benefited the team to bring down the overall process to run within 4 days (earlier was 1 month).
  • Deployed and designed pipelines through Azure data factory and debugged the process for errors.
  • Extensively worked on Visual studio 2012/13/14 (enterprise and ultimate versions) to analyze SQL server packages and implement recommendations.

Environment: Visual Studio 2013/14/15 Enterprise/Ultimate, MS SQL server management studio 2012/13/14, MS Office 2013, MS Visio 2013, Azure Data Factory, Azure Data lake, Cosmos, Power BI, MS Excel, PowerPoint, MS Project, MS Outlook.

Confidential, Jacksonville, FL

Data Analyst

Responsibilities:

  • Performed data manipulation, data cleansing and data profiling in the source systems that are required for Dual credit report Data mart.
  • Performed statistical analysis using SQL, SAS, R, Python, and Excel.
  • Experience with high performance data processing.
  • Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
  • Created import job, workbook and export job into DataMeer.
  • Define the list codes and code conversions between the source systems and MDR and also defining the trumping rules applied by Master Data Repository.
  • Liaising with end-users and 3rd party suppliers.
  • Analyzing raw data, drawing conclusions & developing recommendations also writing SQL scripts to manipulate data for data loads and extracts.
  • Applied Master Data Management standards in data conversion, mapping and migration.
  • Performing daily system checks, Data entry, and data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
  • Involved in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Embarcadero.
  • Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
  • Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements.
  • Involved in defining the source to target data mappings, business rules, and business and data definitions.
  • Responsible for defining the functional requirement documents for each source to target interface.
  • Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
  • Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
  • Document data quality and traceability documents for each source interface
  • Experience with Mainframe enterprise billing systems.
  • Worked with internal architects and, assisting in the development of current and target state data architectures.
  • Used data analysis techniques to validate business rules and identify low quality for missing data in the existing Data Mart.
  • Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: SQL/Server, Java, Python, Oracle 10g, MS-Office, MS BI Stack ETL, Hadoop, Informatica IDQ, MDM

Confidential, Buffalo, NY

Sr. Data Analyst

Responsibilities:

  • Worked according to the software development life cycle.
  • Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Confidential ’s employees).
  • Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stakeholders.
  • Wrote the test cases and technical requirements and got them electronically signed off.
  • Created new reports based on requirements.
  • Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
  • Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
  • Involved in defining the source to target data mappings, business rules, and business and data definitions.
  • Created dashboards for ad-hoc reporting and analysis.
  • Extensively involved in filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
  • Provide 24 x 7 problem management support to the development team.
  • Document various Data Quality mapping document.
  • Perform small enhancements (data cleansing/data quality).
  • Worked on daily basis with the mainframe team and lead data warehouse developers to evaluate impact on current implementation.
  • Communicated with the third party vendor to do the programming.
  • Upgraded the present application by adding new functionalities.
  • Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.

Environment: MS Office 2007, MS Visio 2003, Windows XP, MS Excel, PowerPoint, MS Project, UML, MS SQL Server, Erwin, Business Objects, MS Outlook.

We'd love your feedback!