Sql Bi Developer Resume
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.