| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Status: U.S Citizen( : PHONE NUMBER AVAILABLE* : EMAIL AVAILABLEOBJECTIVE: Highly motivated Professional over 6 Years of experience in IT includes extensive Functional and Technical experience in Business Intelligence (BI) product development and reports generation experience along with Business Analyst experience of translating business needs into long-term business intelligence solutions with the Power BI, Business Objects, Crystal Report, Tableau, MS SQL Server platform with SSIS and SSRS and other related tools.SUMMARYOver 6 years of experience in RDBMS technologies like SQL Server, MySQL and PL/SQLExperience as Business Analyst in understanding business requirements and processes, leading ongoing reviews and developing optimization strategies for those.Worked with end users and stakeholders to understand business requirements, recommended technical solutions and documented functional requirementsExperience in Extracting, Transforming and Loading (ETL) data flow among different source and destination files formatsExperienced in SQL Server 2008, 2012 and 2014Experienced with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting business requirements, Design, Development & implementationWorked with T-SQL, DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign KeysExperienced in MSBI using Business Intelligence Development Studio (BIDS) and SQL Server Development Tools (SSDT) to create packages SSIS and SSRSExperience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Crystal reportsDeveloped, modified and troubleshot new and existing Crystal ReportsExpertise in creating complex SSIS and DTS packages for ETL purposesUsed advanced concepts of SQL including Joins, Sub Queries, Set Operators, Tables, Views, Indexes, T-SQL & PL/SQL Stored Procedures, Triggers, Functions, Packages, Cursors, Exceptions and Dynamic SQLExpert in Database Designing/Modeling for new applications (OLTP & OLAP systems) and Database changes to existing applicationsExpert in creating, configuring and fine-tuning ETL workflows designed in Server Integration Services (SSIS)Experience in integrating data as per the requirement from multiple databases like Oracle, DB2 etc (Excel, CSV, flat file, etc.) by using multiple transformations provided by SSISExperience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL TablesStrong in Analyzing Business Specifications and in developing appropriate Test Plans, Test Scripts and Test Cases based on customized needsProficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server DebuggerKnowledge of NoSQL databases like MongoDb and CassandraExcellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentationAn excellent Inter-personal skill with ability to develop creative solutions for challenging client needs using design patternTECHNICAL SKILLSLanguagesSQL, PL/SQL, TSQLData ModelingMS Visio, Visual ParadigmDatabasesMS SQL Server 2014/2012/2008/2005/, Oracle 11g/10g/9i/8i, MS Access, MySQLBI ToolsTableau10, SSIS, SSRS, Crystal Repot, DTS Import/ExportProject Management ToolsJIRA, SharePoint, Team Foundation Server, PivotalOperating SystemsLinux, Windows, Mac OS X, Android, iOSPROFESSIONAL EXPERIENCEFond Du Lac Cold Storage Inc [Edison, NJ] Database Developer Jul 2019 PresentActively participated in interaction with business users, Director, VP and CFO to fully understand the requirements of the systemDesigned and Developed Database Objects like Tables, Stored Procedures, Triggers and schema for all the project applications of warehouseIntegration of scanning tools and apps with the SQL server database and transfer of data from the scanner to databaseSetup issue tracking system for the whole warehouse for the tracking of the items and deliveryGeneration of reports in Quickbooks from the data coming from SQL server databaseWrote stored procedures for the automation of the data coming from SQL server into Quickbooks for the daily generation of reportsImplementation of window servers and the web servers to run the integrated tools for the warehouseAdministered the SQL server database and the IT systemsDeveloped, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned viewsKnowledge of SSIS Packages user data from the Flat files on monthly and weekly basisKnowledge of views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulationWebMD [NYC, NY] SQL & BI Developer July 2017 Oct 2018Wrote queries for retrieving data from the Various databases and formats like (SQL Server, Excel, Flat file, Oracle, MS AccessDaily generated reports using SSRS & Tableau for our internal clientsWorked on few Outcomes Medic internal applications to pull data from databases using SSIS and run report with SSRS then upload to Workfront & Box toolsInvolve in Planning, Defining and Designing data based on business requirements and provide documentationDevelop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reportsCombined views and reports into interactive dashboards in Tableau Desktop that were presented to Business UsersReviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasetsDeveloped story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed informationUsed various dashboard objects like horizontal, vertical, text, image and webpage to integrate all the worksheets togetherBuilding, publishing customized interactive reports and dashboards, report scheduling on Tableau serverImplement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in TableauCreate Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionalityWorked extensively with Advance analysis Actions, Calculations, Parameters, Background images, MapsAccomplished reports deadlines assigned in Workfront and uploaded in BoxEY [Secaucus, NJ] SQL & BI Developer Aug 2016 May 2017Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reportsDeveloped rich interactive graphics and data visualizations of large structured data in browser-friendly formats.Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).Planned, Defined and Designed data based on business requirement and provided documentationExperience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL AccessCreated Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRSCreated new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, MapsGenerated parameterized reports, sub reports, tabular reports using SSRS 2012Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development StudioCreated various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Multi-valued parameters and also understanding of the tablix control and Dashboard reporting, Share Point with Power View tool etcCitigroup Inc. [San Francisco, CA] SQL/BI Developer Oct 2014 May 2016Actively participated in interaction with users, team lead, DBA and technical manager to fully understand the requirements of the systemInvolved in project planning, also schedule for database module with project managersResponsible for writing T-SQL code for creating cursor and handling data validationsDesigned and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for the projectDeveloped, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned viewsKnowledge of SSIS Packages user data from the Flat files on monthly and weekly basisCreated Database objects views, and functions and developing procedures for implementing application functionality at the database side for performance improvementDefined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tablesKnowledge of views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulationDeploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current statusCreated datasets, data source and involved in deploying the reports in to the report serverCreated reports using SQL Server 20012(SSRS) and integrated into the web front endInvolved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of PerformanceMoney Gram Inc. [Burlingame, CA] SQL Database Developer Sep 2013 - June 2014Writing queries for retrieving data from the databaseEfficient in creating joins and sub-queries for queries involving multiple tablesWorked with different teams such as DBAs and Data owners during the business rules and data validation processExperienced in creating SSIS package to extract and load data from the different sources and destinationWorked on creating ad hoc reports creating and running SQL queries and providing reports out to different departments in Excel and AccessGathered requirements to identify and create database objects such as tables, views, triggers and indexesInvolved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrityCreated ER diagrams using VisioCreated Views to enforce security and data customizationCreated Non-Clustered indexes to improve query performance and query optimizationInvolved in the performance tuning and optimization of T-SQL queriesCreated Stored Procedures for commonly used complex queries involving join and union of multiple tablesEDUCATIONBS, San Jose State University San Jose, CAPERSONAL SKILLSPassionate about learning new technologies and business processesLeadership skills with detail orientation and self motivationEfficient in decent written and spoken skillsInteracting with different technical meet up groupsSuperior documentation and organization skills |
