| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SQL and BI Developer: Visualization/Data ManagementEMAIL AVAILABLEPHONE NUMBER AVAILABLEWith more than seven years of experience, Proficient in gathering requirements, analyzing, consolidating, creating documentation, Planning, implementing, coding from scratch, testing, and creating report or visualization with meaning full format.Experienced in generating reports or visualization by using SSRS, Power BI and Tableau.Developed many complex parameterized custom reports and visualizations.Used tableau and Power BI to create visualization for health care, education institution, and financial institution.Experienced in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, DB2, MS access using SQL Server SSIS R2008/2012/2014/2016/2017/2018.Experienced in Creating, testing, and updating the existing ETL packages.Experienced in updating and using Star schema and Snowflake data warehouse.Proficient in Relational Database Management Systems (RDBMS) with Conceptual, Logical and Physical data models.Created databases, tables, views, Stored procedures on SQL server management studio.Worked as good team player as well as worked independently on assignments. Provides guidance and tips on advanced issues. Understands performance, tuning and troubleshooting issues.Always focused data accuracy, by checking data sources, did unit testing, tested all the functions that has been applied, checked any assumption has been applied besides the primary requirements.Collaborated with users to validate the data in the transactional database.Expert in using Team foundation server.Experienced in Agile Software Development Methodologies.Knowledge of Azure Data Lake, and Teradata.Excellent written and verbal communication skills.Strong analytical, problem solving and decision-making skill and always curious to learn new environment with new tools.Work ExperienceSystem Analyst and SQL DeveloperOmaha Public SchoolFeb 2020 PresentOmaha Public school is one of the top school districts in the state. There are several Special education services than any other schools in the district.Gathered and analyzed business requirements into a meaningful requirement documentation.Have been writing and executing complex queries, interpreting results, and communicating non-technical Users.Participated in designing logic and reviewed, provided logic for query optimization, and have been doing troubleshooting.Written SQL queries from scratch and have built more than 50 custom reports including budget and special education services.Deployed reports to the report server.Responsible for training and mentoring junior developers.Experienced in generating reports by using views, Stored procedures, and embedded SQL code.Created and managed visualizations and analytics reports that turn data into knowledgeCreated tables, Views, and stored procedures with comments on the code.Partner with leadership and subject matter experts to determine project requirementsHave been doing unit testing, QC and peer reviewing the code written by the other developer in the team.Always focused data accuracy, by checking data sources, function that has been applied, any assumption has been applied besides the primary requirements.Environment: SSIS, SSRS, Tableau, SQL Server Management Studio, Microsoft SQL Server, Microsoft Office, MS Excel, TFS, and SharePoint.MS SQL/SSIS DeveloperMITS - Omaha, NEApril 2017 to Jan 2020MITS delivers were a networking services along with Applications services, Infrastructure services, and Business Process Outsourcing (BPO) services. MITS provides integrated communication platform to connect its clients with their customers and conferencing services with a combination of technology know how, domain and process expertise. MITS clients are Banking & Capital Markets, Insurance, Manufacturing, and Healthcare.Responsibilities:Created database Tables, Sequences, Views, Procedure, Cursors and Triggers for database development.Used all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)Extensively used advanced features like Object types, Collections and Dynamic SQL.Analyze, design, Develop, implement and tune SSIS 2014 /SSIS 2016 packages to perform the ETL process.Responsible for understanding the complex SSIS packages and make understandable to the team.Strong understanding of data driven business decisions using mapping document and implement in SSIS ETL process.Used Tableau to customize interactive reports and dashboards with customized parameters.Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various sources.Design ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data warehouse by performing different kinds of transformations by using SQL ServerIntegration Services (SSIS) used SSIS tester automated tool to test packages, tasks, and precedence constraints.Created SSRS reports such as tabular, matrix, charts, dashboard, and sub-reports using SSRS 2008R2.Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.Participated in daily SCRUM meetings and gave the daily status of testing.Developed data visualizations and dashboards using Power BI and Tableau.Environment: SSIS, SSRS, SSAS, SQL Server Management Studio, Microsoft SQL Server, Microsoft Office, Tableau, Windows Server, MS Excel, MS Access, Power BI (Power Pivot, Power View using Excel and SharePoint), SRUM Master and Agile methodology.Jr. SSIS DeveloperAlzheimer Association - Omaha, NEMarch 2016 to March 2017Alzheimer is a big non- profit American volunteer health organization. Alzheimer's Association helps with care, support, and research to Alzheimer's patients. Alzheimer is non-curable diseases, and Alzheimer's Association has International Research funds for the investigation to identify new treatment strategies. Alzheimer's Association been pulling data from all over the world for the better investigation and research.Roles &Responsibilities: Conducted database administration, execution estimation and execution tuning for new databases and existing databases by utilizing SQL Profiler, Data Engine Tuning Advisor. Developed complex projects in T- SQL, composing Stored Procedures, Triggers and Queries with best execution design. Generated occasional reports in view of the factual investigation of the information utilizing SQL Server Reporting Services (SSRS) Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server. Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, and views. Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements. Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2008. Configured SQL mail operator for sending programmed messages when a SSIS bundle is fizzled or succeed. Created questions for creating drill down reports in SSRS 2008. Organized the reports utilizing the Global factors, articulations, and Functions. Created Linked Servers to associate OLE DB information sources and suppliers. Designed different reports utilizing diverse detailing highlights, for example, amass by and penetrate through and so on. Created the Data source connections, Data Source Views, Relationships, Named Query forcustomized analysis in SSAS.Environment: Microsoft SQL Server, Power BI, SSRS, Excel, MSBI tools, MS Excel, MS Access.EducationMS in Computer Information Systems in DatabaseBellevue University - Bellevue, NE Almost Done.BS in Computer Information SystemsBellevue University - Bellevue, NEMarch 2017Associate of Applied Science in Management Information SystemsMetropolitan Community College - Omaha, NEMarch 2015Studied:Programming languagesJava Script, ASP.NET (CSS, HTML), JAVA, C, C#, C++, Web Scripting, VB.NET, SQL.Operating SystemsMS-DOS, Microsoft Windows platforms.DatabaseSQL Server 2014/2012/2010/2008, MS Access, Oracle, MySQLToolsMicrosoft Business Intelligence Services (SSIS, SSRS, SSAS), Power Center Informatica, PowerBI, and Tableau.TrainingScrum Master, Tableau by Aim institute Omaha, MSBI training from Intellipaat, Oracle 12 c Admin training from Net com learning Omaha NE.Skills Ms access Sql server Business intelligence ToolMicrosoft Business Intelligence tool (SSIS, and SSRS).Power BITableauCOLLEGIATE ACTIVITIESVolunteer Contributor: Alzheimers association, Omaha Public Library.Member: Omaha Agile Development Meetup Group (Member and Presenter) https://www.meetup.com/Omaha-Agile-Development/photos/26525339/443803757/Member: Power BI group Omaha https://www.meetup.com/Omaha-Power-BI-User-Group |
